Non-GCSE – Lesson 4 – RSC data visualisation

Curriculum KS4 Unit Lesson

The purpose of this lesson is to demonstrate to learners how to create accurate and useful charts based on data generated in previous lessons. 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. Learners will examine some charts which give inaccurate information due to incorrect or erroneous use of charts. Learners will also investigate adding a macro to carry out a repetitive task.

Learning objectives

  • Select the most suitable chart to visualise the selected data
  • Recognise the importance of clear titles and labels
  • Implement and test a macro to carry out a repetitive task

Package contents

  • Lesson plans
  • Slide decks
  • Learner resources
  • Homework