Task 2 Objectives: Using and displaying live data Today you will learn: § understand how data can be represented in different ways to make it easier to understand § import data § use charts to represent the data more effectively I am looking for you to: § Import Snowdon weather data § create and modify further charts · create a summary report
	Teacher feedback wiki
Instructions		Help and Resources		Time
Welcome		Welcome2.ppt
2.1* Discuss your answers and view the sites remotely using RM Tutor				5 mins
2.2 View the link for live weather info in Snowdonia. Discuss		http://weather.ccw.gov.uk/index.htm or for Notre Dame Sheffield | 2		10 mins
2.3* Right mouse click and SAVE TARGET AS Snowdon.txt in your weather folder. Open the text file and discuss how difficult it is to use.		SAVE TARGET AS Snowdon.txt		10 mins
2.4 Open a new Excel Spreadsheet and Save it as import in your Weather folder. Follow the teacher’s instructions to import the weather data.		Teacher 2.4.ppt		15 mins
2.5* Create a chart using the data with labelled axis.		Assessment Criteria 2		15 mins
Extension View extension2.ppt		Extension2.ppt
Plenary View the presentation				5 mins
Homework: Complete homework 2 for next lesson.		Homework2.doc		15 mins

*Teacher info:

2.1 Select some pupils to give their answers, justifying them by referring to the information on screen. Extend the responses, asking pupils to say how the information is displayed, for example, dial, numbered scale, table including text and numbers, and to suggest why these forms of display are chosen. Ask more able pupils whether they understand the significance of the numbered scale labelled pressure. (The pressure is measured in milligrams of mercury; rising pressure usually indicates finer weather.) Ask the class to say what kind of place
it might be.

Tell pupils that the weather station is in Wales and that the data are being sent over the Internet. Explain that the data are collected and displayed live but that the transmission causes a short time delay.

Say that the website is an example of a public information system because it provides information about the weather to anyone who wishes to browse the website. Introduce the idea of a system by explaining that the website gathers data from sensors in the weather station, selects and processes the data and then displays them in different ways.

Say that in this lesson they will look at different ways of displaying information using the information system on the website as an example. Tell pupils that they will import data and store it in a spreadsheet, then present the information as a line graph

Say that the aim of the rest of this unit is for pupils to produce an information system of their own. They will use a spreadsheet to gather data, to select and process them and to display the information in different ways. Refer pupils to the objectives for the lesson

2.3 Ask pupils to consider why these data are difficult to understand. Draw out responses such as:

· too much data displayed at once;

· incomprehensible numbers;

· unfamiliar formats, for example, date displayed mm/dd/yy rather than dd/mm/yy;

· unfamiliar units, for example, InHg;

· unknown measurements, for example, what do ‘dew’, ‘I temp’, ‘O temp’ refer to?

Ask pupils how the data could be presented to make them easier to understand. Draw out responses such as:

· select some relevant data and discard the rest;

· present data as a graph or chart;

· provide an explanation for the data.

2.5 Increase the complexity of the task for pupils working at higher levels, for example, asking them to:

· graph two related sets of data on the same chart, such as inside and outside temperatures, or temperature and humidity;

· convert Fahrenheit temperatures to Celsius temperatures;

· alter scales on axes to display data more effectively;

· use the help system built into the system to resolve difficulties.

Keywords:

From Year 7: import

From Year 8: live data, remote sensor, length delimited file, public information system