Year 11
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
Lesson details
Key learning points
- In this lesson, we will learn how to create accurate and useful charts based on generated data. Charts are often used to quickly give information and to help visualise sometimes quite complex data, but it is important to select the right chart for the data and to implement the chart accurately.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
Loading...
3 Questions
Q1.
Conditional formatting could have been used here on Column G, how would it be used?
To change the average to a percentage.
Q2.
What do you think the formula in column G is doing?
It is calculating the total of the marks achieved in the four exams.
It is counting the marks achieved in the four exams.
Q3.
What do you think the formula looks like?
=AVERAGE(C4+D4+E4+F4)
=SUM(C4:F4)/4
3 Questions
Q1.
What is an advantages of representing data as a chart?
It can oversimplify data.
Q2.
What type of chart would be ideal for representing percentage or proportional data?
Bar chart
Line chart
Q3.
What is a macro in spreadsheets?
A type of chart.