Font size
WorksheetsSECTION A [40 MARKS] - Question 1 (a)
Total questions: 25
Worksheet time: 20mins
A teacher wants to ensure that student test scores entered into an Excel spreadsheet are valid whole numbers between 1 and 100. Which feature should the teacher use in Excel?
Filter
Pivot Table
Data Validation
Conditional Formatting
A software development company is looking to streamline its operations by focusing solely on developing and running applications without having to manage the underlying hardware or software updates. Which cloud service model should they choose to best suit their needs?
Infrastructure as a Service (IaaS)
Software as a Service (SaaS)
Function as a Service (FaaS)
Platform as a Service (PaaS)
What formula should be used in cell E2 to calculate the total sales for Monday?
= B2 * D2
= C2 * D2
= B2 * C2 * D2
= SUM( C2 : D2 )
Mr. Penjor wants to create a program that prints all the even numbers from 1 to 15 for his ICT class. Which of the following for loop statements should he use to achieve this task effectively?
A
B
C
D
Mrs. Pema Wangmo is writing a research paper on the psychological effects of social media on teenagers. She found a book titled "The Digital Age: Psychological Impacts of Social Media," written by Dr. Jane Smith, published in 2021 by HarperCollins Publishers. She wants to cite this book in APA format. Which of the following is the correct APA citation for the book?
Smith, J. (2021). The Digital Age: Psychological Impacts of Social Media. Harper Collins Publishers.
Smith, J. (2021). The digital age: Psychological impacts of social media. Harper Collins Publishers.
Smith, J. (2021). The Digital Age: Psychological Impacts of Social Media. New York: Harper Collins Publishers.
Smith, J. (2021). The digital age: psychological impacts of social media. New York: Harper Collins Publishers.
Which logical function in Excel would you use to reverse the logical value of its argument?
A. AND
B. NOT
C. OR
D. IF
Given a situation where you need to execute a block of code for a specific number of times, which type of loop is most appropriate to use?
do-while loop
if statement
while loop
for loop
You, a teacher using Google Workspace for Education, want to create a collaborative project for your students where they can simultaneously work on a presentation. Which of the following Google Workspace tools is the most appropriate for this task, and what steps would you take to set it up?
Google Forms: Create a new form, share it with students, and have them input their contributions in the form fields.
Google Docs: Create a new document, share it with students, and have them add their content in different sections.
Google Sheets: Create a new spreadsheet, share it with students, and assign different rows or columns for their input.
Google Slides: Create a new slide deck, share it with students, and assign different slides to each student for their contributions.
You are assigned to create a shape using Python's Turtle graphics. Based on the provided code snippet, which shape will be produced by the given code?
Square
Octagon
Pentagon
Hexagon
As a content creator preparing to publish your artwork online, demonstrate your understanding of creative commons licenses by identifying the statement that accurately describes a creative commons license.
Creative commons licenses prohibit any use of your artwork without explicit permission from you.
Creative commons licenses allow others to use, share, and adapt your artwork under specific conditions determined by you.
Creative commons licenses automatically transfer full ownership of your artwork to the public domain.
Creative commons licenses apply only to non-commercial uses of your artwork, excluding any commercial exploitation.
What will be the correct output from the sample code?
A. ['Range', 'function', 'inbuilt', 'variable']
B. ['Range', 'inbuilt', 'variable']
C. ['Range', 'function', 'inbuilt']
D. ['Range', 'function', 'variable']
Which of the following names adheres to Python's rules for valid variable names?
school – 1
school_1
school 1
1school
Given the tuple, my_tuple = (10, 20, 30, 40), what is the result of my_tuple[1]?
A. 10
B. 20
C. 30
D. 40
Which of the following Python functions, correctly calculates the profit given the cost price (CP) and selling price (SP) of an item?
A Line Code 1 def calculate_profit(cp, sp): 2 profit = cp - sp 3 return profit 4 print(calculate_profit(50, 70))
B Line Code 1 def calculate_profit(cp, sp): 2 return cp * sp 3 print(calculate_profit(50, 70))
C Line Code 1 def calculate_profit(cp, sp): 2 profit = cp + sp 3 return profit 4 print(calculate_profit(50, 70))
Which of the following formulas will give the total salary for employees in the IT department?
=SUMIF(A2:A6, "IT", C2:C6)
=SUMIF(A2:A6, "IT", B2:B6)
=SUMIF(B2:B6, "IT", B2:B6)
=SUMIF(B2:B6, "IT", C2:C6)
Complete the following statement with the most appropriate word: In Python, an ordered collection of items which is changeable and allows duplicate members is a (a) .
Complete the following statement with the most appropriate word: Acknowledging ownership of intellectual property by citing sources is crucial to avoid (a) .
Complete the following statement with the most appropriate word: The exclusive legal right given to an originator or an assignee to print, publish, perform, film, or record literary, artistic, or musical material, and to authorize others to do the same is called (a) .
Complete the following statement with the most appropriate word: The data structure used to store key-value pairs, where each key is unique, is called a (a) .
Complete the following statement with the most appropriate word: If Mr. Sonam Wangchuk wants to encapsulate code for reuse and perform a specific task, he would define a (a) in Python.
State whether the following statement is TRUE or FALSE: Google Docs allows multiple users to edit a document simultaneously and provides real-time updates to all collaborators.
True
False
Mr. Raju is working on data structures in Python. He wants to ensure that a collection of elements contains no duplicates, and the order of elements does not matter. He should use a Python set.
True
False
State whether the following statement is TRUE or FALSE: Miss Yuden shared that consistently using vague variable names and avoiding comments to explain complex code helps improve code readability and maintainability.
True
False
State whether the following statement is TRUE or FALSE: A while loop in Python continues to execute as long as the specified condition is true.
True
False
Creative Commons licenses allow creators to waive their copyright completely.
True
False
