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