SPREADSHEET+PROJECT 

STEP ONE:
Review examples of spreadsheets given below and on the Spreadsheet Project page.

//**1.) All levels -** Get the big idea: How can teachers use Excel in the classroom? Review the following examples://

 * //**For Young Students:**//
 * //First Grade - [[file:Voting-Excel-First.xls]]//
 * //Animal Comparison -[[file:animalsheet.xls]]//
 * //**Older Students:**//
 * //**Heart - [[file:ExampleHeart1.xls]]**//
 * //**Music - DJ time - [[file:DJProject.xls]]**//
 * EASY GRAPH TOOL - http://nces.ed.gov/nceskids/createagraph/default.aspx
 * //**Single Use:** @http://www.internet4classrooms.com/single_use_ss.htm//
 * //**Other ideas:** @http://www.internet4classrooms.com/on-line_excel.htm//
 * //**USES Spreadsheet Problems for Teachers:** @http://eusesconsortium.org/edu/resources-problems.php//
 * **//Interactive Excel for Developing Math Connections//** //(a presentation by Kathy Post for Penn State University One-to-One Conference): http://interactiveexcel.wikispaces.com///

= STEP TWO = //**2.) Determine your level, and learn how to use Excel, on a basic level if needed. You should know how to do the following:**//
 * Put data into the cells
 * Understand data, cells, rows, columns
 * Functions & Formulas - where and how to write
 * How to make a chart (graph)


 * In class we will go over the automatic features of Excel and some of the "beautification".**

//Determine if you are a beginner, intermediate or advanced with spreadsheets in Excel.//
 * __**Beginner**__ //**=** You know very little to nothing on the ways to use Excel.//
 * **__Intermediate__** //**=** You have used Excel in the past, but it may have been awhile. You need to brush up. You may want to look at some beginning information to refresh yourself.//
 * **__Advanced__** //**=** You use Excel all the time and you want to get more ideas on ways to use it in the classroom.//

//**3.) Do the assignment as per your experience level.**// __**Beginners:**__ Review many of the examples. Download 2 spreadsheets, and slightly modify them. Example: Change the name categories and add directions that would modify them slightly. IF you are not sure how to do something, write it on the side or a piece of paper**.** OR, you may do some of the same things done in the video tutorials in Excel Helpfuls.

__**Intermediate:**__ Review many of the examples. Download 2 spreadsheets, and slightly modify them. Example: Change the name categories, add directions that would modify them slightly. //Challenge yourself to come up with at least one more original idea//. IF you are not sure how to do something, write it on the side or a piece of paper. OR, you may do some of the same things done in the video tutorials in Excel Helpfuls.

**__Advanced:__** Review many of the examples. Download 1 spreadsheet and slightly modify. Example: Change the name categories, add directions that would modify them slightly. Challenge yourself to come up with at least one more original idea. See if you can do the "beautification", which may include hiding unnecessary grid lines, making your graph look good and colors , add images etc.

hyperlink to a web page or another excel worksheet, here are directions: @http://peltiertech.com/Excel/Hyperlinks.html IF you are unsure how to do this, copy & paste the web page address into a cell.*
 * If you want to

= STEP THREE: CREATE YOUR SPREADSHEET AND WRITE YOUR PROJECT PLAN =

THESE ARE THE PROJECT PLAN AND RUBRIC FOR THE SPREADSHEET PROJECT
You will need to do the following:
 * You will create a lesson that uses Excel that you can use in your teaching.**
 * Create a **Project Plan** using the sheet provided. Download this sheet and fill it out. [[file:Project_plan_SP12.doc]]
 * Create a **sample of the Excel work that you will do or expect students to do**.
 * Rubric for YOUR assessment - [[file:Webquest&Excel -Rubric_SP12.xls]]


 * = Need help with writing objectives and goals, please go to the Projects Page. =

Conclusion
You have thought and worked hard! In classes, we will share learning experiences and learn from one another. You should bring your excel ideas on a USB saving drive. You should be ready to ask questions (write them down!) so that you learn how to use excel even better! We will take at least 45 minutes explore the ways to use excel!


 * An Ode To Spreadsheets..**

A table of values arranged with perfection, columns and rows in any direction.

From top to bottom and left to right, the info you need, so tidy & tight.

Formulas, filters, labels & cells, for these wonderful tools, my heart swells.

by Jill Nobles