Gce Model Questions Vol1 2024 Computer Studies Question 10

Practice essay / theory question 10 from the 2024 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheets, Word Processing, Formulas, Conditional Formatting, Pivot Tables, Linking Objects, Mail Merge .

Gce Model Questions Vol1 2024 Computer Studies Essay / Theory
Topics: Spreadsheets Word Processing Formulas Conditional Formatting Pivot Tables Linking Objects Mail Merge
Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2024 • COMPUTER_STUDIES • essay

A secondary school wants to use a spreadsheet to record the scores of its students in three subjects (Mathematics, English and Science) and then generate individual report cards in a word‑processing document. The spreadsheet contains the following columns: - Column A: StudentName - Column B: MathsScore (out of 100) - Column C: EnglishScore (out of 100) - Column D: ScienceScore (out of 100) Using this data, answer the following:

Question Parts

( a )
Write the formula to place in cell E2 that calculates the total score for the student in that row. Write the formula for cell F2 that calculates the percentage (out of 300). Explain the difference between relative and absolute cell references in these formulas.
( b )
Define a conditional formatting rule that highlights the entire row in red when the total score (column E) is less than 150. State the formula used in the rule.
( c )
Describe the steps to create a pivot table that shows the average score for each subject. Explain how the resulting pivot table should be interpreted.
( d )
Explain how to link the spreadsheet table into a Microsoft Word document so that any change made to the spreadsheet automatically updates the table in the Word file.
( e )
Outline the procedure for using mail‑merge to produce an individual report card for each student. Specify the required data fields and the main steps involved.

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 Gce Model Questions Vol1 2024 Computer Studies Question 10. It is one of the essay questions from the 2024 Gce Model Questions Vol1 Computer Studies examination.

The question covers Spreadsheets, Word Processing, Formulas, Conditional Formatting, Pivot Tables, Linking Objects, Mail Merge .

View More Gce Model Questions Vol1 2024 Computer Studies Questions More Gce Model Questions Vol1 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