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