Spreadsheet activities for a data management unit : a teacher's resource using Microsoft Excel

Percey, Ralph (2000) Spreadsheet activities for a data management unit : a teacher's resource using Microsoft Excel. Masters thesis, Memorial University of Newfoundland.

[English] PDF (Migrated (PDF/A Conversion) from original format: (application/pdf)) - Accepted Version Available under License - The author retains copyright ownership and moral rights in this thesis. Neither the thesis nor substantial extracts from it may be printed or otherwise reproduced without the author's permission. Download (10MB) [English] PDF - Accepted Version Available under License - The author retains copyright ownership and moral rights in this thesis. Neither the thesis nor substantial extracts from it may be printed or otherwise reproduced without the author's permission. (Original Version)

Abstract

Statistics are all around us. Statistical reports from areas like business, weather, politics, and sports are encountered daily by students and adults. Yet, the study of statistics as a branch of mathematics has primarily been an optional course offering in the high school curriculum of Newfoundland. However, through the efforts of the Atlantic Provinces Education Foundation (APEF), the study of statistics will now have a compulsory place in each level of the regional high school mathematics curriculum. This curriculum also calls for the integration of appropriate technologies like computer software to explore the relevant objectives. -- The aim of this project is to offer teachers a resource that supports the instruction of statistics through the integration of technology. This project is designed to explore various curriculum topics in statistics using the computer software package Microsoft Excel. The high school curriculum objectives for the Data Management unit as outlined in Course I, Level Y, Teacher's Pilot Draft Guidelines of the Atlantic Canada Mathematics Curriculum (1997) provides the framework for the activities. -- The project consists of a series of activities that use Microsoft Excel as a tool to help students investigate several concepts in statistics. The National Council of Teachers of Mathematics has long supported involving students in constructing and applying mathematical ideas, using a variety of instructional formats like small cooperative groups and individual explorations, and using computers as tools for learning and doing mathematics (NCTM, 1989, p. vi). This project integrates these ideas into an organized collection of activities.

Actions (login required)

View Item