Week+4


 * < ==**__Week 4 - Microsoft Excel__ **==

Hour 1 - [|What I See! What I Enter!]
 * []
 * What is a field? What is a record?
 * Entering Information
 * Formatting Font and Cells
 * Basic Formulas - sum, multiply, average
 * Sorting your data
 * Filtering your data
 * Paste //**Special**//
 * Setting Print Area

Hour 2 - Project: Creating your class' gradebook
 * [[file:Sample Grades.xls]]

|| || Hour 3 - [|Graphs and Charts] - Giving value to your data!
 * Together we will enter the grade book you brought with you (or a supplied sample)!
 * Calculate an average
 * Conditional Formatting
 * < xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx ||  ||
 * Grouping your data
 * Creating a graph

Hour 3 - Creating a Mail Merge (2007 Illustrated Directions)
 * Making Labels
 * Making a Form Letter

Hour 4 - Google Docs - Online Forms
 * Create a Form (Quiz and Other)
 * Send a link to classmates
 * Complete the Form
 * Download the form results spreadsheet
 * Analyze that data - sorting and graphs

Hour 4 - Finding and Using Online Excel Resources
 * []
 * Earthquake Simulation
 * Hours of Daylight

Hour 5 - Create an Excel Tutorial
 * Identify skills you believe your staff needs
 * Rehearse your video
 * Record your video
 * Share your video