Excel+Exploration

= [|Excel] Exploration =

Agenda 1. Take Excel Skills Survey (Click here to access the survey) 2. Discuss ways we THINK excel can help us differentiate in the classroom. 3. Explore examples of how excel has been used by Bruce Teachers. _ a. Check the examples below. _ b. Firman and Debord will share mail merge examples aloud. 4. Discuss new ways we feel that excel can help us differentiate in our classrooms.

Examples Below are a few examples of how excel can be used by teachers to break down assessment data.


 * **Link** || **Resource Description** ||
 * [[file:PE Example.xls]] || A sweet example of how Mr. Gorman used an online template to make individual graphs for all of his students fitness tests. ||
 * [[file:Parabola Mastery Quiz.xls]] || Very simplistic example of how to use conditional formating and formulas to show objective-based assessment data. ||
 * [[file:Complex Middle School Example.xls]] || A very complex example of how a Bruce teacher put all of her assessment data into a comprehensive spreadsheet to measure her students' cummulative growth. ||
 * [[file:Homework Tracker.xls]] || A simple homework tracker. Notice that there is a "Data" sheet and a "Graph" sheet at the bottom left hand corner of the screen. I showed this to my students to compare homework turn in between classes. ||

See the process from start to finish...
I've take a basic spreadsheet containing question by question data, and broken down the steps one by one in an word document, so whoever is interested can learn the steps I took to break down the data. Just download the original data and the word document, follow the steps described on the word document, and open the final sample test data when you're done to see if yours ended up looking the same.


 * Here's the original data. || [[file:Sample Test Data.xls]] ||
 * Here's the word document describing the steps. || [[file:Creating Simple Excel Tracker.docx]] ||
 * Here's the final product. || [[file:Final Sample Test Data.xls]] ||