Task 4 Objectives: Automating processes in a simple information system

 

Today you will learn:

  • use automated processes in a spreadsheet
  • use a web query to create an information system

I am looking for you to:

  • create a web query to download the data for Rome into the Input Sheet
  • see how the data on the Input Sheet is paste linked on to the Process Sheet

·        Create a graph to be shown on the Output Sheet.

Teacher feedback wiki

Instructions     

Help and Resources 

Time

Welcome

Welcome4.ppt

 

4.1 View teacher 4.1.xls

 Teacher 4.1.xls

5 mins

4.2 Watch your teacher give a demo on how to create a more automated model.

 teacher 4.2.ppt

5 mins

4.3 Right click the link and show in new window.

Average weather Rome

5 mins

4.4 Open a new Excel Worksheet.  Save it in your Weather folder and give it the filename city. Rename the sheets Input, Process and Output

 Teacher4.4.ppt

10 mins

4.5 Create a weather information system for Rome.  Create a chart showing temperature and rainfall.

teacher 4.2.ppt

15 mins

4.6* Go back over the questions in teacher 4.6.xls.

Teacher4.6.xls

5 mins

4.7 Watch your teacher give a demo on how to amend the model for Athens.

Teacher 4.7.ppt

5mins

4.8  Update your own system for Athens and Sydney.  Compare the charts produced to your homework.

 

10 mins

Plenary*  Explain what you have done this lesson.

Teacher 4 plenary.ppt

5 mins

Homework

Homework 4.doc

 

 

*Teacher info:

4.6 Tell the pupils that they now have enough experience to answer the questions on the whiteboard. Allow a few minutes before asking pupils to respond. Gather ideas, drawing out these points.

·        The web query allows us to import data from a website, quickly, easily and without error.

·        The linked cell references allow the ‘Process’ and ‘Output’ worksheets to update automatically.

 

Plenary Draw a system diagram on the whiteboard and remind pupils of the three-part system. Select pupils to explain in their own words:

·        what happens when the web query runs;

·        what is happening in the ‘Process’ worksheet;

·        what the ‘Output’ sheet shows.

Remind pupils of the objectives for the lesson and that they have worked through an example of automating a simple process by creating a software routine.

Keywords:

Year 8: automated process, dynamic link, URL (universal resource locator)