Excel+Resources

** Lesson Plan Ideas/ ** ** Teacher Tools that Incorporate those Skills ** // (don't be misled by the content area or grade level; you can learn from any of them and most can easily be modified to suit your curricular needs) // || ** Tutorials for those Skills ** //(////these tutorials cover a variety of versions of Excel and you may have to adapt the instructions to fit your version...and sometimes there are pieces that are incorrect because of the difference in versions; but these are starting points)// || and and (environmental education/science, grades 6-12) //Students will examine the amount of water their family uses on a typical Saturday, record the information in an Excel template, and analyze and compare their water usage to that of others.// || [|Very basic tutorial.] Also good for people who know Excel but are new to Office 2007/Office 2008. Geared towards Windows users.
 * ** Skills in Microsoft Excel ** || ** Lesson Plans/ **
 * **Basic vocabulary** (cell, column, row)
 * Introduction to concept of a spreadsheet** (how cells are named, purpose of spreadsheet, . . . )
 * Entering data** || [|How Much Water Does Your Family Use?]

[|This is a free website for learning and self practicing all the basics of Excel.] It includes many tutorial videos and easy step by step manual instructions. Choose one of the subjects from the list at the top of the page and a list of relevant videos will appear. The videos are online, short and very easy to understand, planned especially for beginners.

[|A .pdf of a basic introduction] designed for high schoolers in a North Carolina School district.

[|A hangman game to review basic vocabulary terms]. Each word gives you a "hint" (the definition). [geared for Excel 2007 for Windows]

Resources: [|Excel 2008 basics for Mac] or [|Excel 2007 basics for Windows] || (social studies, science, any subject, grade 3 and higher) (teacher tool)
 * **Formatting** (cells, fonts, row height, text slant, borders, changing number format to decimal or percent . . .) || [|Create a Timeline of President Obama's Life] or a [|Tiimeline of Famous Science Experiments]

Create and Analyze Rectangular Patterns (math, grades 4-9) || [|Creating a Timeline] (the grown-up version for Excel 2007) || (+, -, *, /, using parenthesis, referencing multiple cells in one formula, using the Summation tool) || [|Vampires: Fact or Fiction?] (math, grades 6-8)
 * **Initial (simple) formula writing**

//Would you rather receive $1,000,000.00, or one penny the first day, double that penny the next day, then double the previous day's pennies and so on for a month?//

[|Mind Your "Peas" and Qs] (science, grade 3) //Students will plant peas, record growth, and enter data into a simple spreadsheet to produce a graph.// || This tutorial shows you the basics of Excel (assumes very little prior background) while making a gradebook (Bob Hope and Eddie Murphy will be in your class!). You'll learn some skills while learning how to make something useful in Excel. Even if your school uses PowerSchool or other gradebook software and you won't need to make your own gradebook, you can relate to the concepts while going through the steps. [] || (math & social studies, grade 5) //give your friends a survey, create a simple spreadsheet, enter survey data, and then graph the results// ||  || Students can design a class survey project to include interviewing many people with a questionnaire, capturing data in forms, entering results in a database, and tracking/analyzing the data using Microsoft Excel. || [|Creating a Form using the Form Tool](grown up version) ||
 * **Creating graphs** || [|Excel-lent Graphing]
 * Fun and/or Advanced and/or Random Features ||
 * **Form Tool** || [|Students Design a Survey and Evaluate the Data]

Files we used in the Excel workshop