RSC merchandise
Slide deck
Download slide deck
Lesson details
Key learning points
- 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
Loading...
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?
Increases user input errors.
3 Questions
Q1.
Conditional formatting could have been used here on Column G, how would it be used?
To change the average to a percentage.
Q2.
What do you think the formula in column G is doing?
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