USE

the data and produce charts to explain the results of the survey.

HOME | IDENTIFY | PLAN | DESIGN | CREATE | USE | REVIEW

Teacher Notes | Teacher feedback wiki | 9.2 assessment grid

 

Aims

Information

 

Lesson 5

Welcome

VIEW this presentation for the lesson aims.

Task 1

SAVE results.xls into your global survey folder and follow the instructions.

Task 2

Watch your teacher show how to create simple and complex pivot tables.  Write notes, then create some tables using results.xls

Task 3

Watch a teacher demo on how to filter data and use formulae.  Write notes, then create some tables using results.xls

MARK ALERT! 

Make sure that you have done the following:

  • On the results sheet described what the charts show and prove.
  • Added clear notes on how to create pivot tables and formulae in report draft.doc

 

Lesson 6

Welcome

VIEW this presentation for the lesson aims.

Task 1

VIEW some contributions to the following blog posts:

Global Issues
Local Issues

Technology

Task 2

OPEN results.xls and draft report.doc to remind yourself what you did last lesson.  Complete any sections if not yet finished.

Task 3

Your teacher will tell you whether to SAVE results2.xls or results3.xls

Task 4

If you are using results3.xls copy the hypotheses, charts and chart descriptions into the results section of your finished report.

MARK ALERT! 

  • Complete all your charts
  • Complete the phrases to explain what they show.