Gce Model Questions Vol1 2020 Computer Studies Question 10

Practice essay / theory question 10 from the 2020 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheets, Word Processing .

Gce Model Questions Vol1 2020 Computer Studies Essay / Theory
Topics: Spreadsheets Word Processing
Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2020 • COMPUTER_STUDIES • essay

A university department uses a spreadsheet to manage student grades for a course and then generates a formatted report for each student using a word‑processing document. The spreadsheet contains the following columns for each student: StudentID, Name, Assignment1, Assignment2, Midterm, Final, and a cell for the FinalGrade which is a weighted average (Assignment1 20%, Assignment2 20%, Midterm 25%, Final 35%).

Question Parts

( a )
Write the formula that should be entered in the FinalGrade cell to compute the weighted average, assuming the first data row starts at row 2.
( b )
Explain the steps required to apply data validation so that marks entered in the Assignment and exam columns are restricted to the range 0–100, and describe how to set conditional formatting that highlights any FinalGrade below 50 in red.
( c )
Using the data in the spreadsheet, outline the procedure to create a bar chart that shows the distribution of FinalGrade scores grouped into the intervals 0‑49, 50‑69, 70‑84, and 85‑100. Briefly interpret what a chart that is heavily weighted toward the 0‑49 interval would suggest about the cohort.

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

The question covers Spreadsheets, Word Processing .

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