Anonymous

Visualising data: Difference between revisions

From OER in Education

Visualising data (view source)

Revision as of 15:21, 3 October 2012

2,406 bytes removed ,  13 years ago
no edit summary
No edit summary
No edit summary
 
(7 intermediate revisions by 3 users not shown)
Line 2: Line 2:


{{Rinfo
{{Rinfo
|type= Lesson idea
|attribution={{James de Winter}}
|final=yes
|title= Variation of human characteristics - Visualising Class data  
|title= Variation of human characteristics - Visualising Class data  
|subject=Science
|subject=Science
Line 8: Line 13:
|image=SC0012_screenshot.png
|image=SC0012_screenshot.png
|resourcenumber= SC0012
|resourcenumber= SC0012
|age= Primary, KS1
|age= KS1, Primary
|content= Students measure themselves (including but not limited to; arm length, height, hand span) and then analyse their data to look for patterns of distribution amongst the class. A spreadsheet allows graphs showing the data to be drawn instantaneously as the data is input - helping students to visualise the variation and distribution of the data within the class.
|content= Students measure themselves (including but not limited to; arm length, height, hand span) and then analyse their data to look for patterns of distribution amongst the class. A spreadsheet allows graphs showing the data to be drawn instantaneously as the data is input - helping students to visualise the variation and distribution of the data within the class.
|format=  
|format=  
Line 26: Line 31:


|resources=
|resources=
*[[Wiki text of an Idea for a teaching strategy]]
* Template [[file:Class Data Set.xls]] in excel
* Template [[file:Class Data Set.xls]] in excel
* And in ODS format [[file:Class Data Set.ods]]
* And in ODS format [[file:Class Data Set.ods]]
* Both files will automatically update the pie chart for data. You can add as many children as you like, and you can change the ranges given in the tables. You cannot add or remove rows - the number of intervals should stay the same. You can change the data being visualised by using the 'drop down' menu on the Excel sheet.
* Both files will automatically update the pie chart for data. You can add as many children as you like, and you can change the ranges given in the tables. You cannot add or remove rows - the number of intervals should stay the same. You can change the data being visualised by using the 'drop down' menu on the Excel sheet.
[[File:SC0012_screenshot.png|350px|none|alt=Graph of collected data.]]}}
[[File:SC0012_screenshot.png|350px|none|alt=Graph of collected data.]]}}
'''Idea for a teaching strategy based on a class of 30 students'''
[[File:SC0012_screenshot.png|thumb|none|alt=Graph of collected data.]]
Three 'measuring' work stations set up (one for each continuous variable: height, hand span and arm length) with space and materials for 3 groups of 3-4 around each station.  Each pupil is to be given a personal data slip that they must complete whilst working in groups of 3-4. 
The data slip could be something simple like this:
Name:_________________________<br/>
Height (cm):__________________<br/>
Hand span (cm):_______________<br/>
Arm length (cm):______________<br/>
Collect data (pupils could enter the data directly into a class spreadsheet projected on to a white board) as each set of three groups finishes at their station making sure each pupil has their personal data completed on their data slip before moving to the next station.  Groups circulate through all three stations helping each other to make accurate measurements. 
Data could be collected in one lesson and analysed in a further lesson.  This gives the teacher time to set up the range fields on the spreadsheet based on the data collected.
'''Possible Extension Activities'''
* Data sets for other classes (or indeed the whole school) could be collected and students could see if the patterns/distributions seen in one class were similar/different to others.
* Calculators could be used to work out averages and other data analysis as an alternative, see moving stones activity for examples.
* Some students may analyse the data further, calculating the mean, mode, median of the data set (see counting stones activity for more suggestions and instructions).
Extension/enrichment activities: hand span measurement could be used to measure arm length/hand (see professional development PDF below) could be drawn around on square paper and the area worked out and compared with hand span to look for patterns/data could be analysed by sex, age, to look for patterns also pattern spotting between variables.
* The Witch's Hat is a fun drama lesson plan to introduce measuring in cm. (av. rating 4.7/5 out of 12 ratings on TES) http://www.tes.co.uk/teaching-resource/MATHS-DRAMA-LESSON-THE-WITCH-S-HAT-6013315/review/1/.
* Photo and info for measuring hand span:  http://www.topendsports.com/testing/tests/hand-span.htm.
* Great professional development PDF explaining in detail a lesson on using hand spans to measure arm length: http://www.mathsolutions.com/documents/0-941355-42-X_L2.pdf.
Retrieved from "https://oer.opendeved.net/wiki/Special:MobileDiff/8630...12011"