City Guilds Model Questions Vol1 2020 Information Technology Question 4

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

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

A secondary school records the scores of six students in three examinations. The data are given below. | Student | Exam 1 | Exam 2 | Exam 3 | |---------|--------|--------|--------| | Ada | 68 | 74 | 81 | | Bayo | 55 | 62 | 58 | | Chidi | 82 | 79 | 85 | | Damilola| 47 | 51 | 44 | | Efe | 73 | 70 | 68 | | Fatima | 39 | 45 | 41 | Using a spreadsheet application, answer the following tasks.

Question Parts

( a )
Enter the data exactly as shown into a worksheet, ensuring that the header row is bold.
( b )
In column E, calculate the average score for each student, rounding to the nearest whole number. State the average for each student.
( c )
Using the IF function, assign a grade in column F based on the average: - A for ≥ 75 - B for 60 – 74 - C for 45 – 59 - D for < 45 State each student’s grade.
( d )
Create a column G that displays “Pass” for grades A, B or C and “Fail” for D. Then compute the overall pass percentage for the class (rounded to one decimal place).
( e )
Generate a vertical bar chart of the average scores (column E). Identify which student performed best and state the chart’s title and axis labels that you would use.

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

The question covers Spreadsheets .

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