Spreadsheet Development
(1) Spreadsheet Development
- Review chapter 20
- List your ideas (examples) for spreadsheets online.
- Develop a spreadsheet file that can be used to teach a lesson in your field or a related field. Help your partner develop a spreadsheet for another topic in your discipline or related discipline.
- The spreadsheet must be self-contained and include:
- multiple worksheets
- general information
- procedures
- diagrams and/or photographs
- calculations
- graphs
- weblinks
- Post your Excel file on your website
- Post the Excel file of your partner on your website
- Post both files as Google Docs. Share "with the world" and provide a link on your website
- Post both spreadsheets on the class wiki files page
(2) Lesson using spreadsheet
- As a team, develop lessons for both spreadsheets. Your lessons should include:
- Objectives
- Standards (if applicable)
- Student directions (What are they suppose to do?)
- Explanation of the data file (source, reliability, etc.)
- Sample problems and solutions
- Questions, Problems and or Activities (with answers)