|
Task 4 Objectives: Analysing
Survey Data n
Today
you will learn: •
To check data
for mistakes •
To sort and
search for specific information •
To create data
tables for charts n
I
am looking for you to: •
Clean up a ‘dirty’
dataset •
Search data to
find answers to questions •
Present data
clearly in charts |
|
|||
|
|
|
|||
|
Instructions |
Help and Resources |
Time |
||
|
4.1 Welcome. Today we are going
to practice the skills you will need to analyse your survey data. |
Complete the Energy Survey |
10 mins |
||
|
4.2* Save Analysis to
your Survey folder, then
watch the demonstration by your teacher of how to apply a data filter to check for dirty data. |
SAVE & OPEN Analysis.xls |
10 mins |
||
|
4.3 Check the worksheet for dirty data, deleting any
rows that cannot be analysed. |
|
5 mins |
||
|
4.4* On the Input sheet, watch a
demonstration by your teacher of how to sort and
search the data, copying relevant records onto a Process sheet and entering the number counted
into a data table. |
|
5 mins |
||
|
4.5 Work through the sheets in Analysis. You should aim to have produced at least 3 charts by the end of the lesson. |
|
25 mins |
||
|
Extension If you have completed all of today’s tasks, open
up your Survey Report and continue to
follow the instructions. |
For those who don’t have a copy: SAVE & OPEN Survey-Report.ppt |
|
||
|
Plenary Discuss today’s objectives: What is dirty data and why is it a problem? How can we search data for answers? What formulae did you learn to use today? Homework If you have not done so yet, please answer the survey (type Energy Survey into a NotreNet Title search) |
|
|
||
|
Key Vocabulary: alphanumeric,
bar chart, classify, data , data type, database, enquiry, field, hypothesis,
improve, interrogate, numeric, pie chart, questionnaire, record, sample
composition, search method, sort, table, value |
||||
|
Teacher notes: 4.2 We are
checking for rows that contain blanks, or obvious errors such as text in a
number field. Such rows should be deleted by right-clicking the row number
and choosing Delete. 4.4
When we talk about ‘searching’ data, we mean using Data-Filter-Autofilter
to create filters (searches) for specific data items (such as ‘M’ in the
Gender field). Filtered rows should be copied, then pasted onto a Process
sheet for analysis. |
||||
