Neco 2022 Computer Studies Question 4

Practice essay / theory question 4 from the 2022 Neco Computer Studies examination. This question covers Data and Information .

Neco 2022 Computer Studies Essay / Theory

Topic: Data and Information

Question 4 NECO • 2022 • COMPUTER_STUDIES • essay

A teacher is preparing a spreadsheet to record the scores of 25 students in three continuous assessment tests (CA1, CA2, CA3) each out of 20 marks. The teacher wants to calculate the total score for each student, determine the class average for each test, and assign a grade based on the total score using the following scale: 0‑30 = F, 31‑45 = C, 46‑55 = B, 56‑60 = A.

Question Parts

( a )

Write the Excel formula that the teacher should enter in cell E2 to compute the total score for the first student, assuming CA1, CA2 and CA3 are entered in columns B, C and D respectively.

( b )

Describe how the teacher can use the AutoFill feature to copy the total formula to all 25 students efficiently.

( c )

Using the data, the teacher wants to find the average score of CA2 across the class. Write the formula and explain why the AVERAGE function is appropriate.

( d )

Propose a method using Conditional Formatting to highlight any student whose total score is below 31 (i.e., grade F). Include the rule expression that should be used.

Detailed Solution & Marking Scheme

Get the step-by-step solution, key points required by examiners and detailed marking guidance through the Edcrib AI Tutor.

Reveal Answer

About This Question

This is Neco 2022 Computer Studies Question 4. It is one of the essay questions from the 2022 Neco Computer Studies examination.

The question covers Data and Information .

View More Neco 2022 Computer Studies Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows

Chat with Support