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.

Welcome Activity


Overview of Spreadsheets

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

Activities


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)

Discussion: Spreadsheets in Education


Advanced Spreadsheet Techniques or Q & A (Time Permitting)


Reflection Activity


Online Evaluation




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.

Welcome Activity


Overview of Online Spreadsheets and Google Docs


Activity: Collaborative Spreadsheet - "Participant Profiles"


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

Discussion: Online Spreadsheets in Education


Advanced Google Docs Techniques (Time Permitting)


Proof-of-Concept Project


Reflection Activity


Online Evaluation




Additional Resources


Module 4 2007 Archive