Task 5 Objectives: Meeting the needs of the user

 

Today you will learn:

  • use a web query to create an information system
  • evaluate the system

I am looking for you to:

  • Create a system using Input, Process, Output
  • Import weather data from a web page
  • use paste special to automatically refresh the data

·        Evaluate your system

Teacher feedback wiki | 8.1 assessment grid

Instructions     

Help and Resources 

Time

Welcome

Welcome5.ppt

 

5.1 Download and SAVE student5.1.xls and read the instructions on each sheet.

SAVE student5.1.xls

 10 mins

5.2*  Watch a demo by your teacher on how to complete the task.  View Assessment Criteria

VIEW Assessment Criteria

 35 mins

Plenary View plenary 5.ppt

Teacher 5 Plenary.ppt

5 mins

Homework

Homework 5.doc

15 mins

 

* Teacher info:

5.1 Remind pupils that the system is being designed to enable a travel agent to look up weather information for customers. Ask pupils to work in pairs to discuss what they would like to change. Ask one of each pair to jot down the suggestions. After 5 minutes, gather pupils’ ideas. Use these questions to prompt if necessary.

·        How easy is the system to use?

·        What do you have to do to change the location?

·        What do you need to know about the URL?

·        How attractive is the graph?

·        What other information would the travel agent need?

·        What impression does the output worksheet give?

Draw out responses.

·        The system is difficult to use.

·        The user needs to know about and be able to use URLs.

·        It is easy to make a mistake in entering the location.

·        The graph is not very attractive.

·        The output worksheet looks unclear and is not well presented.

·        The user, a travel agent, expects the system to be quick, accurate and easy to use.

·        The system uses ICT to automate the process of gathering data and presenting the information to meet the user’s needs.

 

5.2 Explain that you are going to demonstrate a feature of a web query which will help to make the system more user-friendly. Show sample system 8.1T5b lesson5.xls on the large screen. Point out that it is the system they developed, with one change. Move to the ‘Output’ worksheet and demonstrate what happens when the location in cell A1 is changed.

Note: the web query will not work if there is no live Internet access.

Show how the data are collected from the website, processed and displayed automatically. Ask pupils if this helps to make the system easier to use.

 

5.3 IMPORTANT The students will not be putting the string into student5_4.xls as this is very tricky.  This is  presentation will just show them how it was done.

5.4 Ask pupils to think about how the information is displayed, reminding them that the system is being designed for a travel agent to look up weather information for customers. Remind pupils that the presentation of information needs to be clear, easy to read and understand. Ask for suggestions about how to enhance the presentation of information. Give pupils 2 minutes to think of suggestions before selecting pupils to respond. Draw out points such as:

·        providing on-screen instructions;

·        changing the type of chart to a more appropriate one;

·        changing the scale on one or both of the axes;

·        removing gridlines, scroll bars, etc.;

·        enlarging fonts, changing font typeface or colour;

·        changing the colours of the background, lines, bars, etc.

Add suggestions to the list on the whiteboard from activity 1.

Ask pupils to modify their systems, taking into account these suggestions. Say that at the end of the lesson they will return to the list to judge how well their system meets the needs of the user. Give pupils help sheets or guidelines, as appropriate, or direct them to the help menus in the application.

Undertake focused group work with pupils working at a higher level. Prompt pupils to reflect on their system by asking these questions.

·        What happens when a location is entered incorrectly?

Answer: System returns an error.

·        What are the simple mistakes users might make?

Answer: Spelling incorrect; failure to use a capital letter.

·        What happens when a city is not on the website database?

Answer: System returns an error message with little explanation of what the error is.

·        How can we avoid these errors?

Answer: Provide instructions; provide training for users; adjust the system to take account of errors.

Keywords: