Visual Literacy Tools Workshops : Excel

Excel

	Today‚s children are growing up digital. Their view of the world is very different. (http://www.ncrel.org/engauge/skills/growup.htm)
Where to find tutorials:	WikiVid for Excel: free short video lessons BayCon Group Excel tutorial: step by step 'how-to's' Atomic Learning: fee based video lessons MrExcel podcast tutorials: video podcast lessons Internet4Classrooms: teacher focused step by step lessons with templates for classroom use, and other student activities
Books and Resources:	Excel Workshop for Teachers, by Janet Caughlin, Tom Snyder Productions Make It with Office, by Vicki Sharp, Visions Software Charts, Excel, www.softwarecharts.com
Teacher Resources:	EXCEL-lent Middle School Math Lessons! Classrooms that EXCEL Resources Use Spreadsheets to Teach Math Why Use Spreadsheets Across the Curriculum?

Ways to use Excel in the Classroom

Spelling/Vocabulary lists
Class roll 
Posters 
Data charts 
Database of states, presidents, etc. 
Tally charts 
Graphing lessons 
KWL (Know, Want to know, Learned)
Lesson plans 
Compare and contrast 
Estimation activities 
Calendars?
Diagram- use comments to add definitions and information 
Multiplication tables 
Random number generator 
Log Data 
Attendance sheet 
Probability and statistics
Types of charts

Creating Charts for data analysis in the classroom	Add-ins for Excel to create many different types of charts: MathTools list of add-ins for Excel
Pareto Charts: Smart Teaching Step by Step with Excel (PDF download)	Simple Run Charts
Histograms: Peltier Technical Step by Step Instructions	Scatter Charts: Microsoft, how to add labels to data points

Last update: Sunday, June 10, 2007 at 1:26:54 PM
Copyright 2008 Visual Literacy Tools Workshops

Excel

Where to find tutorials:

Books and Resources:

Teacher Resources: