Physical Sciences and Mathematics Commons^™

Spreadsheets Across The Curriculum, 1: The Idea And The Resource, H L Vacher, Emily Lardner

Numeracy

This paper introduces Spreadsheets Across the Curriculum, a workshop-based educational materials development project to build a resource to facilitate connecting mathematics and context in undergraduate college courses where mathematical problem solving is relevant. The central idea is “spreadsheet modules,” which, in essence, are elaborate word problems in the form of short PowerPoint presentations with embedded Excel spreadsheets. Students work through the presentations on their own, making and/or completing the spreadsheets displayed on the slides in order to perform calculations or draw graphs that address the issue (context) posed in the word problem. The end result of the project is the …