Gce Model Questions Vol1 2025 Computer Studies Question 10

Practice essay / theory question 10 from the 2025 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheets, Formulas, Data Validation, Conditional Formatting, Mail Merge, Word Processing .

Gce Model Questions Vol1 2025 Computer Studies Essay / Theory

Topics: Spreadsheets Formulas Data Validation Conditional Formatting Mail Merge Word Processing

Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2025 • COMPUTER_STUDIES • essay

A university department maintains a spreadsheet to track student grades for a course. The spreadsheet contains the columns: StudentID, Name, Assignment1, Assignment2, Assignment3, Midterm, Final. The department also prepares a report in a word processor to publish the final grades and a summary of class performance.

Question Parts

( a )

Describe how to calculate each student's total weighted mark, given the weightings: Assignments 20 % (each assignment equally weighted), Midterm 30 %, Final 30 %. Provide the formula to be entered in the spreadsheet and explain how to copy it for all rows.

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

The question covers Spreadsheets, Formulas, Data Validation, Conditional Formatting, Mail Merge, Word Processing .

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