Spreadsheet Modelling

In this unit, you will be introduced to the fundamentals of spreadsheet modelling: using spreadsheets to handle, analyse and make use of numerical data.

Learning objectives

  • Develop ICT-based models and test predictions by changing variables and rules.
  • Create and modify ICT models to improve their accuracy and extend their scope.
  • Explore and interpret collected data to draw conclusions.
  • Represent data graphically through formatting tools and charts.

Blended learning

We are teaching this unit using blended learning. You will be taught in lessons in class just as you always have, but you will also be given to extra resources to use out of school to help you learn the content effectively and prepare yourself for the  assessment at the end of the unit.

If you have any questions about this or any other aspect of this unit, email your class teacher.

Mr Greenwood, Mr Bach & Mr Jeggo.

Introduction to spreadsheets

Lessons

Lesson 1: Making a markbook

Lesson 2: Google Trends

Lesson 3: Olympic medals

Lesson 4: Ron’s gourmet hotdogs

Knowledge organiser

All content from this unit is summarised in the knowledge organiser. The version below includes links to further learning resources, and is available as a PDF.

Download PDF (164kb)

Assessment

At the end of this unit, your knowledge and understanding will be assessed by completing an online test. Key features:

  • The test should take approximately 15 minutes, but you can take up to 40 minutes if you need to.
  • The questions will focus only on content covered in the knowledge organiser.

Your score from the test (70%) will be combined with your progress in each of the three lessons (10% each) to make your final result.

Grade boundaries

A*ABCDEF
90%80%70%55%45%35%0%

Resources

Vocab

Learn the vocabulary from this unit using the flashcard deck below, or explore the set on Quizlet.

Quiz: numerical operators

Video tutorials