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 go behind the scenes to examine the database of RSC merchandise. We will discuss the use of barcodes and QR codes (2D codes) and the different kinds of data they can hold.
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.
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.
5 Questions
Q1.
Why is conditional formatting used?
To prevent user error.
To provide the SUM of the cells.
Q2.
What does label A represent?
"in this range of cells".
"return the value in the 3rd column".
"search for an exact match".
Q3.
What does label B represent?
"Look up this cell".
"return the value in the 3rd column".
"search for an exact match".
Q4.
What does label C represent?
"in this range of cells".
"Look up this cell".
"search for an exact match".
Q5.
What does label D represent?
"in this range of cells".
"Look up this cell".
"return the value in the 3rd column".