# The RSC Live event

## Lesson details

### Key learning points

1. In this lesson, we will implement a spreadsheet which represents seating for the live event of Rock Star Challenge. The spreadsheet includes different seat prices for adults, students, and over 60s. We will use a drop-down list to select seats, and formulae will be used to calculate the price.

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

### 4 Questions

Q1.
Write a formula for cell D9.
=B9xC9
B9*C9
B9xC9
Q2.
Write a formula for cell D24.
=D8:D22
=D8:D24
=D8*D22
Q3.
Write a formula for cell J8.
=H8*G8
=I8*H8
=J6*J7
Q4.
Write a formula for cell J15.
=SUM(G8:G15)
=SUM(G8:J13)
=SUM(I8:G13)

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