Year 11

Year 11

# RSC stock control

## Lesson details

### Key learning points

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

## Worksheet

Share with pupils

## Starter 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.

## Exit quiz

Share with pupils

### 5 Questions

Q1.
Why is conditional formatting used?
Correct answer: To give a visual indication when certain criteria are met.
To prevent user error.
To provide the SUM of the cells.
Q2.
What does label A represent?
"in this range of cells".
Correct answer: "Look up this cell".
"return the value in the 3rd column".
"search for an exact match".
Q3.
What does label B represent?
Correct answer: "in this range of cells".
"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".
Correct answer: "return the value in the 3rd column".
"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".
Correct answer: "search for an exact match".