| Year
9 Project - Data Handling (Unit 9.2) |
|
|
This
is lesson 6 |
|
|
|
Previous
lesson |
Using
A Spreadsheet To Analyse Data
(extension work) |
|
|
We
Are Learning
To... |
What
I'm Looking
For... |
At
the end of the lesson can you... |
1.
Use a spreadsheet as a database
|
1.
A spreadsheet downloaded into your user space. The spreadsheet should
then be opened from your userspace.
|
1.
Download, save, open and use a spreadsheet provided for you to use.
2. Use
the functions of a spreadsheet to analyse and display data to an audience.
|
| 2.
Load a given spreadsheet |
2.
Analyse data using sort and filter functions |
| 3.
Sort and filter data in a spreadsheet. Produce graphs to tests an hypotheses |
3.
Evidence of sorting and filtering data and graphs to display information |
| Click
here to remind you what this project is about |
Starter |
Lesson
- What you need to do |
At
the end of lesson... |
1.
Comparing databases and spreadsheets.
Open and
save the Comparing databases and spreadsheets presentation and complete
the tasks in it (10 mins). |
1.
Download, save and re-open the customers spreadsheet.
2. Complete
the customers spreadsheet tasksheet. |
1.
Write a report comparing a spreadsheet to a database (use this template
to help you).
|
Resources: |
Resources: |
Resources: |
| Comparing
databases and spreadsheets. |
Customer
spreadsheet.
Customers
spreadsheet tasksheet. |
Decide
which application is most appropriate for you to write-up your report. You
will need to justify your decision to your teacher. |
| |
|
Funbrain
wordsearch maker |
Important
Words: Data, information, analyse, sort, filter, graph, chart wizard,
gantt chart.
|
|
|
|
|
|
| Some
special links |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
|
