City Guilds Model Questions Vol1 2023 Information Technology Question 4

Practice practical question 4 from the 2023 City Guilds Model Questions Vol1 Information Technology examination. This question covers Spreadsheets .

City Guilds Model Questions Vol1 2023 Information Technology Practical
Topic: Spreadsheets
Question 4 CITY_GUILDS_MODEL_QUESTIONS_VOL1 • 2023 • INFORMATION_TECHNOLOGY • practical

A secondary school is analysing the performance of its Form 2 students in three subjects using a spreadsheet program.

Question Parts

( a )
Enter the following data into a worksheet (rows 2‑9, columns A‑D). Column A: Student name; Column B: Mathematics score; Column C: English score; Column D: Science score. | Student | Math | English | Science | |---------|------|---------|---------| | Ada | 78 | 85 | 69 | | Bode | 64 | 58 | 71 | | Chidi | 92 | 88 | 95 | | Damilola| 55 | 62 | 48 | | Emeka | 81 | 77 | 84 | | Fatima | 70 | 73 | 67 | | Grace | 88 | 91 | 90 | | Hassan | 47 | 54 | 50 |
( b )
In column E, calculate each student's total score (sum of the three subjects) and in column F, calculate the average score (to one decimal place). State the formulas used for the first student (row 2).
( c )
Using an appropriate function, determine the class rank for each student based on total score (higher total = better rank). Show the formula placed in column G for the first student.
( d )
Create a column chart that displays the average score for each subject (Mathematics, English, Science). List the steps required to produce the chart from the data entered.
( e )
Apply conditional formatting to highlight any individual subject score below 50 in red text. Outline the procedure.

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 City Guilds Model Questions Vol1 2023 Information Technology Question 4. It is one of the practical questions from the 2023 City Guilds Model Questions Vol1 Information Technology examination.

The question covers Spreadsheets .

View More City Guilds Model Questions Vol1 2023 Information Technology Questions More City Guilds 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