Michael D. Eisner College of Education
Spreadsheets
(1) Using Existing Spreadsheets
- VIDEO - part 1- Using an Existing Spreadsheet (17 minutes)
- Use Microsoft Excel or other spreadsheet program to analyze
the file entitled budget.xls.
Assume that one of the wage-earners in this family looses his or her
job. Create a second budget that shows "reasonable" cuts that
may be made to balance the family budget. Include a printout of the
budget
(2) Creating Spreadsheets
- VIDEO - part 2- Developing a Spreadsheet (21 minutes)
- Create
a new spreadsheet file or a new worksheet in an existing educational spreadsheet
file. Your worksheet should include a variety of calculations based
upon cells in your new worksheet and/or associated ones in your modified
spreadsheet file. Include a printout of your new spreadsheet in your
portfolio.
(3) Graphing Data
- VIDEO - part 3- Graphing Data (27 minutes)
- Graph and chart creation and interpretation are part of the academic language of many subjects. Create two or more graphs (charts) from a spreadsheet
files related to your discipline. Make sure the graphs are meaningful
and are fully and correctly labeled. Include a screen-shot of the graph
in your portfolio and explain its significance.
(4) Electronic Spreadsheets in Teaching
- Develop two questions that can be answered from a spreadsheet
file in your field. Chose another field if there are no relevant
files posted. Include screen captures that show the answers to these
questions as calculated by the spreadsheet program.