Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Preview

AC 1.1: Spotting patterns in sales data

This is the first page of the lesson. Read it and have a go at the activities. The rest is in the full lesson.

40 minutes

Five bad rows, one shop

On Tuesday an analyst finds five bad rows in a sales sheet. Each looks different: "no date", "price blank", "name missing", "total zero", "date in the future".

A new analyst fixes them one by one. An experienced one sees that all five came from the same shop. One fix at the source may solve all of them.

By the end of this lesson

Note

I can find a pattern in data and use it to make a prediction.

Key words

WordWhat it meansExample
Pattern recognitionSpotting things that repeat or look alike
TrendA change that keeps going in one directionsales rise each week
SimilarityA way two things are alike
Common featureSomething that two problems share
PredictionA careful guess about what will happen next
AssumptionSomething you accept as true without proof

The cells students fill in are left blank in this preview.

Starter

Have a go

Starter

3 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

Pattern recognition saves time

The purpose of pattern recognition is to use what repeats. If you have seen a problem before, you already know a fix. If many problems share a cause, you fix the cause once.

A week of sales rows

DayShopProblemRow
MondayNorthPrice blankRow 4
MondayNorthPrice blankRow 9
TuesdayEastDate missingRow 15
TuesdayNorthPrice blankRow 21
WednesdayWestName missingRow 30
ThursdayNorthPrice blankRow 38

The cells students fill in are left blank in this preview.

Check

Have a go

Check

3 questions
Have a go: your answers are marked here and then forgotten. Sign in if you would like your score kept, and to pick up where you left off.Sign in to keep your score

Your answers are marked here and are not kept. A college account keeps every student’s marks.

The lesson goes on

8 more parts of this lesson are in the full curriculum, with the tasks, the final check and the labs. A college account gives your students all of it.