Gce Model Questions Vol1 2017 Computer Studies Question 10

Practice essay / theory question 10 from the 2017 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheet formulas, Data analysis, Conditional formatting, Word processing integration, Reporting .

Gce Model Questions Vol1 2017 Computer Studies Essay / Theory
Topics: Spreadsheet formulas Data analysis Conditional formatting Word processing integration Reporting
Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2017 • COMPUTER_STUDIES • essay

A university department uses a spreadsheet to manage the grades of students enrolled in a semester. The worksheet contains the columns: StudentID, Name, CourseCode, CourseTitle, CreditUnits, Score (out of 100). The grading scale applied by the department is: - 70–100 : A (4 points) - 60–69 : B (3 points) - 50–59 : C (2 points) - 45–49 : D (1 point) - below 45: F (0 points) The department must calculate each student's GPA (grade‑point average), identify the top three performers, and produce a formatted report in a word‑processor that includes a table of results and a bar chart showing the distribution of final grades. Answer the following questions.

Question Parts

( a )
Write the spreadsheet formula (or set of formulas) that converts the Score in column F to a Grade‑Point in column G, and then computes the GPA for each student (weighted by CreditUnits). Assume the data for a single student occupies consecutive rows and that the GPA should appear in column H of the first row belonging to that student.
( b )
Explain how to apply conditional formatting so that any student whose GPA is below 2.0 has the entire row highlighted in light red.
( c )
Describe the steps required to export the spreadsheet data to a word‑processor, insert a table of the final results, and embed a bar chart that displays the number of students achieving each final grade (A, B, C, D, F).

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

The question covers Spreadsheet formulas, Data analysis, Conditional formatting, Word processing integration, Reporting .

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