13-Spreadsheets

(1) Introduction to Spreadsheets

• Video:  Introduction to spreadsheet formulas [5:52] 

• Video:  Using a spreadsheet to make forecasts - Personal budget. [7:18]

• Assignment- Assume the individual for whom this budget spreadsheet was developed was notified of a 15% salary cut.  Make reasonable adjustments to the monthly values column such that the budget exactly balances once more.  Justify each adjustment using the comment feature, and post the file so that the comments show.

(2) Spreadsheets in the Curriculum

• • Video:   Using a spreadsheet to do calculations - chemical bond energy [3:09] - File - Bond energy

  • Video: Using a spreadsheet to do calculations - Loan calculations [6:12] - File - Loan calculations

  • Assignment - After watching the videos, describe how students can use spreadsheets describe how spreadsheets may be incorporated into your own curriculum, or into the curriculum of a related field.

(3) Creating Spreadsheets

• • Video:   Creating a spreadsheet [14:58] 

  • Assignment - Create a new spreadsheet file on a topic of your choice from scratch.  Your worksheet should include a variety of calculations and features as illustrated in the video. 

(4) Calculations

• • Video:  Practicing calculations in a spreadsheet [6:15]

  • Assignment - Complete the calculations in the Calculations worksheet as described in the video.

(5) Bar, Column & Area Charts

• Video:  Creating Bar, Column  and Area Charts [10:02]

• Assignment - Recreate the bar, column and area charts on  File - Graphs-1. Create a bar, column, OR area chart of data relevant to your interests or to what you teach  on the final tab. 

(6) Stacked & Pie Charts and Scatter Plots

• Video:  Creating Stacked Column & Pie Charts and Scatter Plots [8:15]

• Assignment - Recreate the charts and plots in Graphs sheet - 2.  Create a stacked column, pie charts OR scatter plots of data relevant to your interests or to what you teach  on the final tab.