Thursday 11 April 2013

Spreadsheet fun (yes, honestly!)

I'm looking for some interesting ideas for spreadsheets to show their general awesomeness.

I always open with showing just how amazingly BIG a spreadsheet is.

Then I go to how amazingly FAST a spreadsheet is (How many times have I seen you doing.... 3 timer per hours, 5 hours per day, 5 days per week, 45 weeks per year... etc) always gets a gasp.

I really like doing a quiz based on =IF(   ) function. It blows the kids away.

I have a template that I use myself (I usually get the kids to build it up themselves), but here's a page of templates that I might use for a less able group:
http://homepage.ntlworld.com/neil.williams50/free-resources2.htm

and here are some other instructions http://college.cengage.com/accounting/resources/instructors/air/fall_2006/Connell_and_Mulig_Paper.html


I'm looking for new ideas for younger groups, so here's some links I've found around the net:

Timelines
http://www.fi.edu/fellows/fellow4/feb99/murphy/spreadsheet_tl.htm

Simon Haughton
I'm hoping to keep away from a 'classroom' style classroom for this series of sessions, but these are really fantastic at building up the complexity of spreadsheets.
http://www.simonhaughton.co.uk/theme-park-spreadsheets/


A list of graph questions and yes/no questions.
http://www.canteach.ca/elementary/numbers13.html

Are we there yet...Use a spreadsheet to record distances between places.

Something for older children...or maybe not...?

My daughter was asking last week how to make a pictogram in excel. Here it is:
http://www.pics4learning.com/downloads/pictograph.pdf
(She's just informed my she's already got the answer. Oh)

Fastfood calorie counter
http://www.wmburgweb.com/Resources/Lesson/


No comments:

Post a Comment

Please let me know if you have any thoughts on this post...