Gce Model Questions Vol1 2019 Computer Studies Question 10

Practice essay / theory question 10 from the 2019 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheet functions, Data validation, Conditional formatting, Pivot tables, Weighted averages .

Gce Model Questions Vol1 2019 Computer Studies Essay / Theory
Topics: Spreadsheet functions Data validation Conditional formatting Pivot tables Weighted averages
Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2019 • COMPUTER_STUDIES • essay

A school administrator uses a spreadsheet to record the scores of each student in Mathematics, English and Science and to produce a summary report for the class.

Question Parts

( a )
Describe the steps required to set up data validation so that any score entered in the worksheet must be an integer between 0 and 100 inclusive.
( b )
Write a formula that calculates each student's weighted average where Mathematics carries 40 %, English 30 % and Science 30 %. Assume the scores are in columns B (Math), C (English) and D (Science) of the same row.
( c )
The administrator wants to highlight any student whose weighted average is below the class mean. Explain how to apply conditional formatting to achieve this, specifying the rule formula that should be used.
( d )
To summarise class performance, the administrator creates a pivot table. Outline the steps required to build a pivot table that shows the average weighted score for each subject and the overall class average, and explain how to refresh the pivot table after new scores are added.

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

The question covers Spreadsheet functions, Data validation, Conditional formatting, Pivot tables, Weighted averages .

View More Gce Model Questions Vol1 2019 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