Skip navigation
Oak National Academy Logo

Unit Overview: Spreadsheets

Lessons:

5 lessons

The RSC Live event

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.

  • 2 Quizzes
  • 8m Video
  • Presentation(PPT)
  • Worksheet
  • Transcript

RSC data visualisation

In this lesson, we will learn how to create accurate and useful charts based on generated data. Charts are often used to quickly give information and to help visualise sometimes quite complex data, but it is important to select the right chart for the data and to implement the chart accurately.

  • 2 Quizzes
  • 7m Video
  • Presentation(PPT)
  • Worksheet
  • Transcript