Year 11

Year 11

# RSC merchandise

## Lesson details

### Key learning points

1. In this lesson, we will learn how databases are used to manage sales and stock levels. We will look at a partly completed spreadsheet showing items of merchandise to be sold at the RSC Live event.

### 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.
a. Using 1 word, what do you think the formula in cell F3 is doing?
Averaging
Summing
Q2.
b. What do you think the formula in cell F3 looks like? Circle your answer
=COUNTA(C4:C15)
=COUNTIF(C4:C15,">0")
Q3.
For each employee, their point on the payscale is entered (column C) and a lookup formula in column D returns their actual salary. What two advantages are there to using a lookup here?
Correct answer: Data held in just one place, making it easier to change if necessary.
Increases user input errors.

## Exit 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?