Navigating your way through the activities
You can use the chart below to see what aspects of data
handling are addressed within each 'pathway'.
Outcomes
|
Activities
|
Flood
Alert Package |
YR 3 Handling
Data
Pupils should be taught to:
Solve a problem by collecting, sorting and organising information
in simple ways.
|
As outcomes, Year 3 pupils should, for example:
Use, read and begin to write:
Sort, set, represent, graph, chart, pictogram, diagram, table, list, count,
tally, axis, label, title, most/least common or popular.
Classify objects, numbers or shapes according to one criterion, progressing
to two criteria, and display on a Carroll or Venn diagram.
Use the data in a frequency table linked to a problem the class is trying
to solve. Make or use a computer to make a simple bar chart,
with the vertical ax
is labelled in ones, then twos.
Collect data quickly (for example, by voting in a show of hands) and
make a simple frequency table.
Decide what data is needed, collect it quickly then make or use
a computer to make a simple pictogram, where the symbol represents
2 units.
|
Lesson: Pictograms
- Flash generated pictogram worksheet of rainfall with questions for children - Flash graph drawing program where children can create their own pictograms of
rainfall
Lesson: Bar chart
- Flash generated bar chart worksheet for children to answer questions
- Flash graph drawing program for children to create their own bar charts
Lesson: Carroll diagrams
- Flash animal sorting activity
- Template worksheets and clipart for children to create their own Carroll diagrams
Lesson: Venn diagrams
- Flash activity where children required to sort different shaped signs
- Template worksheets and clip art for children to create their own venn diagrams
|
YR 4 Handling
data
Pupils should be taught to:
Solve a problem by collecting, organising, representing, extracting and
interpreting data in tables, graphs and charts |
As outcomes, Year 4 pupils should, for example:
Use, read and write:
Vote, survey, questionnaire, data, count, tally, sort, set, represent, table, list, graph, chart, diagram, axes, label, title, most common or popular.
Find the answer to a question by collecting data quickly then making
a tally chart.
Find the answer to a question by using data collected in another subject
or at home. Make a pictogram, where the symbol represents several units.
Answer a question or solve a problem by interpreting a bar chart with
the vertical axis marked in multiples of 2, 5, 10 or 20, noting that a
graph has a title, and axes are labelled.
Use sorting diagrams such as two-way Venn and Carroll diagrams to display information about shapes or numbers.
|
Lesson: Combined activity - Children are provided with data of bird species and must build up a tally sheet
- Children display the data using the Flash graph drawing program provided
Lesson: Interpreting graphs
- Using Flash generated graphs children answer questions on river traffic
- Children use the provided graph to generate and answer questions
Lesson: Branching database
- Using Flash generated branching database children answer questions
- Use a branching database to identify birds
|
YR 5 |
As outcomes, Year 5 pupils should, for example:
Use, read and write, spelling correctly, the vocabulary from the previous
year, and extend to:
Classify, mode, maximum/minimum value, range
Test a hypothesis about the frequency of an event by collecting data
quickly: for example, from a simple experiment, a local newspaper, a reference
book, work in other subjects Discuss a bar chart or bar line chart
showing the frequency of the event and check the prediction.
Develop understanding of the mode (most common item) and the range (difference
between greatest and least) of a set of data. Make a simple database on paper.
Draw and interpret a line graph. Understand that intermediate points may
or may not have meaning.
|
Lesson: Spreadsheets1
- Sorting a prepared Excel sheet to answer questions on river lengths
- Use prepared Excel sheet of river lengths to sort and answer questions.
Lesson: Spreadsheets2
- Using a tally sheet to identify continents with the longest rivers.
- Use prepared Excel sheet of river lengths and tally the data.
Lesson: Spreadsheets3
- Sorting a prepared Excel sheet of common river lengths
- Use prepared Excel sheet of river lengths and graphs to analyse the data.
Lesson: Line graphs
- Using graphs children answer questions about noise levels in the Tyne Tunnel
- Use prepared line graph to analyse temperature over a 24 hour period.
|
YR 6 |
As outcomes, Year 6 pupils should, for example:
Use, read and write, spelling correctly, the vocabulary from the previous
year, and extend to:
Statistics, average, distribution, median, mean.
Test a hypothesis by drawing and discussing a bar chart where (discrete)
data are grouped: for example, to check predictions of the most common
number.
Begin to interpret simple pie charts, such as those showing the data
in a computer database.
Find the mode and range of a simple set of data in a computer database.
Begin to find the mean and median.
In other subjects, test hypotheses by interrogating data in a prepared
computer database, such as census data on road
safety.
Begin to draw and interpret a line graph, in which intermediate values
have meaning.
|
Lesson: Interpreting Line graphs
- Using Flash generated graphs children answer questions on water related topics - Interpret a line graph in which intermediate values have meaning - Draw a line chart from suitable data
Lesson: Interpreting Pie charts
- Using Flash generated pie charts children answer questions on village
flooding Interpreting a pie chart relating to flood damage.
Lesson: Conversion graph / charts
- Making predictions based on data collected. - Discussing results and making predictions. - Transferring data to a simple computer database.
|
YR 7 Handling data
Pupils should be taught to:
Respond to a given problem, and predict and hypothesise about possible
answers.
Identify which data need to be collected and how.
Collect data from surveys, experiments and secondary sources, and record
in a frequency table, grouped where appropriate in equal class intervals.
Calculate statistics from data, using ICT as appropriate, finding the
mode, mean, median and range.
Calculate statistics from data, using ICT as appropriate, finding the
mode, mean, median and range.
Construct graphs and diagrams to represent data.Use ICT to produce graphs
and charts, and identify which are most useful in the contex
t of the problem.
Interpret diagrams and graphs, and draw inferences based on the shape
of graphs and simple statistics for a single distribution.
Compare two simple distributions using the range and one of the measures
of average.
|
As outcomes, Year 7 pupils should, for example:
Use, read and write, spelling correctly: survey, questionnaire, data,
statistics, discrete, continuous, variable, tally, frequency, table, data
collection sheet
Given a problem, suggest possible answers.
Confirm whether or not these predictions are correct by the subsequent
collection and analysis of data.
Specify what data should be collected that would be relevant to the enquiry.
For example: Design, refine and use a suitable data collection sheet, specifying questions
that will give rise to relevant data.
Carry out simple surveys or experiments to collect and record the required
data, or gather the data from secondary sources.
Use, read and write, spelling correctly:
Statistic, distribution, interval, range, mean, median, mode, modal class
Find the median of a small number of items.
Draw and label graphs, charts and diagrams, representing information
collected from a survey or experiment, or from secondary sources.
Generate diagrams and graphs using ICT, including pie charts (for discrete data) and frequency diagrams covering the range for discrete and continuous data.
Interpret the data collected, using the diagrams, graphs and charts drawn.
Compare the distribution of two sets of data, and the relationships between
them, using the range and one of the mode, mean or median.
|
Lesson: Data handling1
River alert
Continuous data: Mean
- Worksheets and Excel spreadsheet
- Calculating the Mean Lesson: Data handling2
- Worksheets and Excel spreadsheet - Mean, mode, median and range from discrete data. Lesson: Data handling3
- Worksheets and Excel spreadsheet - Calculating the mode
|
|