• create and format spreadsheets
• use formulas and functions to make calculations in spreadsheets 
• identify uses for spreadsheets within K-12 classrooms create bar / line, pictograph, pie, and scatter plot graphs
• evaluate raw data and make decisions about what type of graph will best display that data
• design instruction that incorporates a spreadsheet created in Excel

  B.  Spreadsheets in the Classroom

• Create an alphabetized class list and simple grade book
• Shoe Graph activity (It's a Shoe In! - Math + Science: A Solution)
• Activities Integrating Math and Science (AIMS) that Generate Data Sets
• By Golly By Gum (Jaw Breakers and Heart Thumpers)
• The Big Banana Peel 
• Are You a Square? (Hardhatting in a Geo-World)
• Inclined Plane (It's Simply Marbleous - Math + Science: A Solution)
• Rocket Ballooons 
• Practically Pi 
• M&M frequency distribution - chi square analysis 
• Practice making charts and graphs 
• Creating an Excel Scatterplot (Office XP) - Duke University Fuqua School of Business
• Creating an Excel Scatterplot (Office 2007)
• Working with Existing Data Sets
• Supermarkets 
• State Population & Electoral Apportionment - Wikipedia 
• Google "crime statistics" - FBI Uniform Crime Reports 
• U.S. Statistical Abstract - U.S. Census Buteau, statistics on the social, political, and economic organization of the U.S.
• CIA Fact Book 
• Poodwaddle World Clock 
• Online tools for using spreadsheets in the classroom
• Online Stopwatch / Timer 
• Virtual Dice 
• Kid's Zone 

• Excel Tutorials / Help / How To
• BayCon Group Microsoft Excel Tutorial 
• Integrating Excel (spreadsheets)
• Spreadsheet Magic (ISTE Learning & Leading with Technology article) 
• Integrating Spreadsheets in the Classroom 
• The Next Generation of Teaching and Learning - Indiana Buddy2
• Excel Classroom Examples
• Tree Carbon Content 
• Calculating Carbon Article 
• "What's Your Favorite Color of the Rainbow?" Lesson Plan 
• Favorite Color of the Rainbow Excel 
• Inclined Plane Integrated Science Inquiry Lesson (Lab Practicum Practice)
• Word
• Inclined Plane Unformatted Text 
• PowerPoint
• ramp.jpg
• marble.jpg 
• car_sound.wav 
• Files for practicing on your own
• Directions 
• Formatted Word document 
• PowerPoint 

• Mini Economy Banking Program - Free classrom economy software - Indiana Council for Economic Education
• Articles / Resources about Classroom Economies
• Inflation and Money - Foundation for Teaching Economics
• Example Excel Spreadsheet for a Classroom Economy 
• The classroom Mini-Economy: Integrating Economics into the Middle School and Elementary Classroom - Indiana Dept. of Ed.

• Spreadsheets in the Classroom Read through the section describing the rainbow lesson.
• Read Why Integrate Technology into the Currriculum?: The Reasons Are Many by the Edutopia staff as well as Seven Brilliant Things Teachers Do With Technology by Doug Johnson. Then think about the understandings you've gained form this course and complete a Course Reflection which is due next week. This will also be added to your webpage.
• Video Showcase - due next week.