Task 3 Objectives: Planning and creating a simple public information system Today you will learn: § identify what weather information is needed by different users § plan a public information system I am looking for you to: choose three different target audiences in the table and identify what information about the weather they would need and why look at how the weather information is presented for different audiences on 2 commercial websites · begin to plan a public information system by recognising the Input, Process and Output stages and using paste special.
	Teacher feedback wiki
Instructions		Help and Resources		Time
Welcome		Welcome3.ppt | Hangman
3.1 Download and SAVE Worksheet 3.1 in your weather folder.		SAVE Worksheet 3.1		5 mins
3.2 View Teacher 3.2.ppt		Teacher 3.2.ppt NOTE 3 SLIDES		15 mins
3.3 View world weather website and choose a city.		World Weather Website		5 mins
3.4 Open a new Excel Worksheet. Save it in your weather folder with the name of your chosen city i.e. Helsinki				5 mins
3.5* Copy the data from the website onto the input sheet. Process the data and display it as a chart.		Teacher3_5.ppt | Example3.5.xls		25 mins
3.6 View assessment criteria		Assessment criteria
Plenary* View Plenary.		Teacher 3 Plenary.ppt		5 mins
Homework		Homework 3.doc		15 mins

*Teacher info:

3.5 Point out the formulae that have been created in the cells in the ‘Process’ worksheet. Explain that when the content of the ‘Input’ cells changes, the formula in the ‘Process’ cells will recalculate the results automatically and put them in the display cell in the ‘Output’ worksheet. Remind pupils how to create graphs and how to create these in the ‘Output’ worksheet.

Undertake focused group work with pupils who were identified in the previous lesson as needing extra support, for example, by loading 8.1T3e lesson3.xls and modifying the graph, step by step. Demonstrate in more detail how to create graphs, emphasising the needs of the user by careful questioning at each stage.

Ask pupils working at a higher level to suggest alternative ways of displaying the data and to justify their choices. For example:

· the data could be displayed as a horizontal bar graph;

· rainfall and temperature could be plotted on the same graph, against two axes, or in a table.

Plenary Discuss why the graph could not be presented as a pie chart or radar graph.

Select individual pupils and ask each of them to suggest one way of improving the quality of presentation of the data. Ask them to justify their suggestions and to explain how to make the change. Draw out responses such as:

· add a title to clarify what the graph shows and the place that the data relates to;

· label the horizontal axis ‘Months of the year’;

· move the label ‘Max (°C)’ to the vertical axis;

· do not join points of the graph since intermediate points have no meaning;

· avoid using a 3D graph so that vertical bars representing the same temperature are the same height;

· change the graph type to a bar line graph;

· change the scale of the vertical axis to show temperature changes more clearly;

· change the font to make the temperatures easier to read;

· change the alignment of the labels to make them easier to read;

• change background colour and/or column colours to emphasise heat

Remind pupils that in this lesson they have considered how the presentation of weather data needs to take account of what the audience expects and needs

Keywords:

From Year 6: input, process, output

From Year 7: storyboard