spreadsheets

=Module 4 - Spreadsheets=

**PART 1 - Desktop Spreadsheets**
Learn the basic functionality of spreadsheets and how they can be a powerful addition to any class in any subject area - not just math or science. This session includes basic use of formulas and graphing.

Overview of Spreadsheets

 * [|Spreadsheets]
 * Menus: File, Edit, View, Insert, Format, and More...
 * Toolbars: Standard, Formating, Drawing, and More... (Including Formula Bar)
 * [|Keyboard Shortcuts]

Activities

 * [|Activity 1: Introduction to Formulas] with a Grade Book (Word Doc from OCDE)
 * [|Activity 2: Introduction to Graphing] with M&Ms

Resources

 * Spreadsheets for Younger Students - A Google Search for: [|spreadsheets elementary students]
 * [|More Useful Formulas for Educators], Including:
 * [|IF] (for conditional formulas... or self grading quizes... nested IF formulas can even be used for giving letter grades - or feedback)
 * [|COUNTIF] (to find the number of times certain data, such as student responses, appear)
 * [|VLOOKUP] (to combine two lists of data - like reading level & test scores that don't have the //exact// same list of students)
 * [|SUMPRODUCT] (for weighted averages)

**PART 2 - Online Spreadsheets**
Extend your use of spreadsheets online. Collect data through an online form. Collaborate with students or colleagues to analyze and represent the data. Then publish your results online. This session shows you how.

Overview of Online Spreadsheets and Google Docs

 * [|Google Docs Support for Spreadsheets]
 * [|Creating a Form]

Activity: Collaborative Spreadsheet - "Participant Profiles"

 * Log in to [|Google Docs] using your Google Account (or Gmail Account)
 * Work in a group of 3 to 5 to create a spreadsheet of the following information:
 * Your First and Last Names
 * Your School Sites
 * Your Grade Level or Subject Area
 * Your Number of Years in Education
 * Create a formula to determine your average number of years in education. (Play with other statistical formulas if time permits.)
 * Create a graph of your number of years in education. Publish the graph (or document) and paste a link below:
 * Your Links Here!
 * http://spreadsheets.google.com/pub?key=psE2JifikQGmjry7bra62Aw&oid=2&output=image
 * [|http://spr eadsheets. google.com /pub?key=p eAb4JI-aHh 8tR2GQTpz- DQ&oid=4&o utput=imag e]
 * []
 * []

Interactive Demonstration: Collecting Data Via Forms with Google Docs

 * One group will volunteer and the instructor will create a form using their spreadsheet.
 * All other participants will enter data into the form.
 * Demo Form Link Here!
 * Demo Graph Link Here!
 * Another Example (with an Embedded Form!): http://edtechlife.com/?p=2041

Additional Resources
Module 4 2007 Archive