RSC stock control
Slide deck
Download slide deck
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.
Video
Share with pupils
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".