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

Preview

DA 1.1: Internal and external data sources

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

45 minutes

The canteen mystery

Every Friday the school canteen runs out of chips by 12:30. The manager wants to know why.

The answer is hidden in data. But whose data? Some is in the canteen. Some is held by other people. Finding the right source is the first job of an analyst.

Key words

WordWhat it meansExample
Internal dataData that an organisation holds itself.Till sales in the canteen
External dataData that another organisation holds.Local weather records
Organisational dataInternal data that the whole organisation shares.The school register
Departmental dataInternal data that one team looks after.Canteen stock list
Public sectorBodies paid for by the government, such as councils and the NHS.A council
Private sectorBusinesses owned by people or shareholders, not the state.A supermarket
Voluntary organisationA charity or other not for profit group. It puts any money it makes back into its cause.A food bank
NGOA non-governmental organisation: it works for a cause and is not part of any government.A child health group

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

By the end of this lesson

Note

I can say whether a source is internal or external, and name who holds each kind of external data.

Starter: whose data is it?

Have a go

Starter: whose data is it?

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.

Internal data: held by us

Internal data is data your own organisation holds. There are two levels.

Organisational data belongs to the whole organisation, such as the school register. Departmental data belongs to one team, such as the canteen stock list.

Internal data is usually quick to reach. You already have a way in.

External data: held by others

External data is held by another organisation. You must ask, search or sign up to get it.

Four kinds of group hold it: the public sector, the private sector, voluntary organisations and NGOs. Each has its own reasons for keeping data and its own rules for sharing it.

Who holds external data

HolderWhat it isInvented example
PublicPaid for by the governmentA council weather and traffic log
PrivateA businessA grocery chain price list
Voluntary or charityNot for profit, run for a causeFood bank donation counts
NGOIndependent of government, works for a causeA child nutrition survey

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

The lesson goes on

4 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.