In this Spreadsheets across the Curriculum activity, students calculate their own course grade and cumulative grade point average. Students will learn to utilize Excel spreadsheets as a tool for completing repetitive calculations. The use of basic formulas, as well as more advanced tools like the "Lookup" function, is explained throughout the module. The main focus of the module is to use the concept of weighted averages in a context that students will find useful and applicable to their everday lives.
- Create and work with spreadsheets in Excel.
- Gain experience working with percentages and averages.
- calculate a course grade in several different scenarios, each with a different grading regime.
- calculate their semester grade point average.
Context for Use
Description and Teaching Materials
PowerPoint SSAC2006.LB3051.SKB1.2-student version (PowerPoint 343kB May2 07)
The module is a PowerPoint presentation with embedded spreadsheets.
If the embedded spreadsheets are not visible, save the PowerPoint file to disk and open it from there.
This PowerPoint file is the student version of the module. An instructor version is available by request. The instructor version includes the completed spreadsheet. Send your request to Len Vacher (firstname.lastname@example.org) by filling out and submitting the Instructor Module Request Form.