Year 11

Year 11

# RSC data visualisation

## Lesson details

### Key learning points

1. 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.

## Video

Share with pupils

## Worksheet

Share with pupils

## Starter quiz

Share with pupils

### 3 Questions

Q1.
Conditional formatting could have been used here on Column G, how would it be used?
Correct answer: To apply a specific colour depending on the average.
To change the average to a percentage.
Q2.
What do you think the formula in column G is doing?
Correct answer: It is calculating an average of the marks achieved in the four exams.
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

## Exit quiz

Share with pupils

### 3 Questions

Q1.
What is an advantages of representing data as a chart?
It can oversimplify data.
Correct answer: It is easier to interpret.
Correct answer: It is more visual.
Q2.
What type of chart would be ideal for representing percentage or proportional data?
Bar chart
Line chart
Correct answer: Pie chart
Q3.
What is a macro in spreadsheets?
A type of chart.
Correct answer: Something you can record to automate tasks.