Welcome to Dataville!


Spreadsheets and online databases provide the opportunity for students to generate, manipulate and analyze their own data. We will spend several class periods on spreadsheets to see their various uses.

Monday: No Class. On your own, explore the spreadsheet lesson plan websites below to see how this tool is integrated in the classroom. Post your favorite lessons to the discussion board. And don't forget to add them to your delicious site, too.

Everything You Wanted to Know About Spreadsheets
Spreadsheet Lesson Plans

Wednesday:
Go to M&Ms page: http://us.mms.com/us/
The M&Ms Lesson Plan
This is one of my favorites. Be sure to come to class for this spreadsheet review. Plus we'll eat some candy! You'll post the completed spreadsheet to your portfolio.

Out of Class: Addtional Spreadsheet Activities: Each of the activities is worth 10 points apiece. Post them to your electronic portfolios by midnight, Monday, October 23, 2006.

  1. Conditional Formatting: Example from Mrs. West at DJ Montague: Click on the links for the count by 3's and 4's and open in Excel. The spreadsheet uses conditional formatting to make it work. Find the directions here.
  2. Fancy Formulas: Example from Creative Ways to Use Software: Read the directions and use the template to create a self-checking quiz.
  3. Fast Food Fun: I created this lesson plan many years ago and I get at least two or three emails a year from teachers who are using it.
  4. Plotting Earthquakes: While this is definitely an upper elementary activity, it shows how spreadsheets can be used for visualization activities. I'll provide the directions in class.
  5. Making a Word Find with Excel: Yet another way to use spreadsheets.

Continue to blog, work on long-range assignments

Back to Schedule