San Narciso School of Consolacion, Cebu, Inc.
Sto. Nino 1, Casili, Consolacion, Cebu
S. Y. 2024-2025
Fourth Quarter Examination
COMPUTER 10
Teacher: Mr. Gerald Q. Estoconing
Name: ____________________ Year& Section: __________ Date: ________Total Score: _______
Proctor’s Name: _________________________ Parent’s Signature: _____________________
TEST I. MULTIPLE CHOICE. Directions: Read and understand each statement/question carefully.
Choose the one alternative that best completes or describes the given statement.
AVOID ERASURES
1. What is the primary purpose of using spreadsheets in data collection?
a. To store and organize numerical and textual data b. To create artistic designs
c. To write research papers d. To browse the internet
2. In a spreadsheet, what is the term for the intersection of a row and a column?
a. Table b. Cell c. Chart d. Formula
3. Which function is best for counting the number of entries in a column that are not blank?
a. =SUM() b. =COUNT() c. =AVERAGE() d. =IF()
4. When collecting survey responses, which spreadsheet tool helps prevent duplicate entries?
a. Conditional Formatting b. Data Validation c. Goal Seek d. Pivot Table
5. Which of the following is the best spreadsheet function for filtering specific responses from a
dataset?
a. VLOOKUP b. FILTER c. CONCATENATE d. UPPER
6. You are conducting a study on students' academic performance and have collected their test
scores in a spreadsheet. Which function would be most useful to calculate the average score of
the class?
a. =COUNT() b. =SUM() c. =AVERAGE() d. =ROUND()
7. A researcher wants to compare male and female students' participation in extracurricular
activities. What spreadsheet tool should they use to summarize this data efficiently?
a. Conditional Formatting b. Pivot Table c. Data Validation d. Track Changes
8. Your team collected survey responses in a spreadsheet, but some respondents left the age field
blank. Which function can help you count how many age values are missing?
a. =COUNT() b. =COUNTA() c. =COUNTBLANK() d. =IF()
9. In analyzing survey data, a researcher wants to determine how many respondents chose
"Strongly Agree" in a Likert scale question. What function is the best choice?
a. =SUM() b. =COUNTIF() c. =VLOOKUP() d. =LEFT()
10. A research group is comparing two sets of data—one from 2023 and another from 2024. They
want to display trends visually. Which feature is best for this purpose?
a. Data Validation b. Pivot Table c. Line Chart d. Conditional Formatting
11. Which function is best for finding the highest value in a dataset?
a. =MAX() b. =MIN() c. =AVERAGE() d. =ROUND()
12. If you need to apply a formula to an entire column of data, which method is the most efficient?
a. Typing the formula in each cell manually
b. Using the AutoFill handle to drag the formula down
c. Copying and pasting the formula in every row
d. Entering the formula in a new sheet
13. What does the IF function allow you to do in a spreadsheet?
a. Find the sum of numbers b. Apply conditions and return different values
c. Convert text to uppercase d. Count empty cells
14. A researcher wants to automatically categorize age groups (e.g., "Teen", "Adult", "Senior") based
on respondents' age. Which function would be helpful?
a. =COUNTIF() b. =IF() c. =VLOOKUP() d. =SUMIF()
15. In a dataset, a researcher needs to identify duplicate names in a list of respondents. What feature
can they use?
a. Conditional Formatting b. Data Validation c. Pivot Table d. COUNTIF
16. What is the advantage of using a Pivot Table in data analysis?
a. It prevents data from being modified
b. It allows dynamic summarization of large datasets
c. It permanently deletes unnecessary data
d. It is required for spreadsheet security
17. Which of the following best describes the purpose of Data Validation?
a. It allows for automatic calculations
b. It ensures that only valid data is entered in a cell
c. It checks for grammatical errors
d. It sorts data in alphabetical order
18. You want to analyze survey data and check how many people fall within a specific income
bracket. What function should you use?
a. =AVERAGE() b. =COUNTIF() c. =VLOOKUP() d. =LEN()
19. A research team wants to combine first names and last names into one column. Which function
should they use?
a. =SPLIT() b. =LEFT() c. =CONCATENATE() d. =LEN()
20. When dealing with sensitive survey data, what is a good practice to ensure data privacy?
a. Making the spreadsheet public
b. Removing passwords to allow easy access
c. Applying encryption and access restrictions
d. Saving data in multiple locations without security measures
21. A researcher conducted a survey on students’ preferred learning styles. The results are as
follows:
Learning Style Frequency (f)
Visual 15
Auditory 10
Kinesthetic 5
What is the percentage of students who prefer the Auditory learning style?
a. 25% b. 30% c. 20% d. 50%
22. The scores of 5 students in a Math quiz are: 80, 85, 90, 95, and 100.
What is the mean (average) score?
a. 85 b. 90 c. 95 d. 100
23. Given the dataset: 4, 6, 8, 10, 12, compute the standard deviation (round to two decimal places).
a. 3.16 b. 2.83 c. 4.24 d. 1.41
24. A researcher conducted a survey on student participation in extracurricular activities. Out of 200
students, 120 reported being involved in at least one extracurricular activity.
What is the percentage of students who participate in extracurricular activities?
a. 50% b. 60% c. 40% d. 70%
25. The following are the test scores of students in a Science exam: 85, 90, 88, 85, 92, 85, 90, 88,
85.
What is the mode of the dataset?
a. 85 b. 90 c. 88 d. 92
TEST [Link] the missing values (2 points each).
Score Range Frequency (f) Percentage (%)
90 - 100 5 (30-31) ____%
80 - 89 (26-27). ___ 20%
70 - 79 12 (32-33). ____%
60 - 69 (28-29). ___ 25%
Below 60 5 (34-35). ____%
Total 40 100%
TEST IV. ESSAY. Instruction: Write a strong conclusion for the research given below that reflects the
main findings, discusses the potential future of AI in education, and offers suggestions on how AI can
be used responsibly and effectively in schools. Your answer will be graded based on the rubrics
below. WRITE YOUR ESSAY IN CURSIVE AND AVOID ERASURES
RUBRICS POINTS
Clarity and Coherence of Key Findings 6
Discussion of Future Potential/Reccommendations 5
Grammar and Language 4
TOTAL: 15
36-50. Imagine you are a teacher in the near future, where artificial intelligence (AI) is widely
integrated into education. Your school has introduced an AI-powered tutoring system that provides
personalized learning experiences for students, but some teachers and parents worry that it might
replace human educators. As a teacher, how would you balance the use of AI in the classroom
while ensuring that human connection, creativity, and critical thinking remain essential parts
of education? Provide specific examples to support your response.
Let Jesus be the captain of your ship and let your faith in Him be your guiding star, because in
times when you get lost, His truth will always be the compass that will point you back north.
-Ser Jayrolled
“Therefore, I tell you, whatever you ask for in prayer, believe that you have
received it, and it will be yours.”
-Mark 11:24
