Spreadsheets
Note: This is an asyncrhonous session. You can complete it at any time prior to the next regularly scheduled session.
(1) Introduction to Spreadsheets
Video: Introduction to spreadsheet formulas [5:52]
Video: Using a spreadsheet to make forecasts - Personal budget. [7:18]
Task- 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
Task - 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]
Task - 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]
Task - 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]
Task - 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]
Task - 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.