Materials Contributed through SERC-hosted Projects
Medicine in the Body part of Pedagogy in Action:Library:Teaching with Spreadsheets:Examples
In this activity, we will explore how the dosage and frequency of a medicine taken affect the amount of medicine present in the blood.
Creating and Reading Two-Way Tables - Pendulum and Sobriety Testing part of Teaching Resources:Quantitative Writing:Examples
In this activity, the students create a two-way table through a class activity. At the beginning of class, the instructor distributes "Yes (almost to 1/3 of class)" and "No" cards to class participants. Depending on the card student receives, he/she will be assumed to be using alcohol or not. Then, the students have to go through a "pendulum testing" to decide "scientifically" if they use alcohol or not. After the result of testing, the students organize the data as a two-way table.
The "Perfect" Date: Ranking and Rating Decisions with a Spreadsheet part of Spreadsheets Across the Curriculum:General Collection:Examples
In this Spreadsheet Across the Curriculum activity, students will build a spreadsheet to apply a ranking and rating scheme using weighted averages to help them decide which person to date. In the activity they will explore the difficulties involved in rating systems. One of the main issues is to decide how to measure and rank the quantitative and qualitative factors that affect their decision.
Finding Your 'Perfect Partner': Evaluating matchmaker profiles usings ratings and cutoff methods part of National Numeracy Network:Teaching Resources:Quantitative Writing:Examples
In this activity, students will explore two decision making methods; rating and cut-off methods.
Grade Calculation part of Spreadsheets Across the Curriculum:General Collection:Examples
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.
Index Numbers: Gasoline and Inflation -- Why We Need the Consumer Price Index part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to examine the price of gasoline, 1978-2005. QL: using ratios and proportions to make comparisons.
Other Contributions (2)
Carbon Dioxide Emissions part of Starting Point: Teaching and Learning Economics:Teaching Methods:Teaching with Spreadsheets:Examples
In this activity, we will create charts by using the data provided by U.S. Department of Energy, Energy Information Administration related to world carbon dioxide emissions from the consumption and flaring of fossil fuels (Million Metric Tons of Carbon Dioxide), between 1980 and 2006. We will use these charts to explore and compare the carbon dioxide emission for different regions/countries of the world.
Semra Kilic-Bahi part of Starting Point: Teaching and Learning Economics:About this Project:Project Participants
Assoc. Prof. of Mathematics Colby-Sawyer College 541 Main Street New London, NH 03257 email@example.com Office: 603-526-3633 Background Information James Madison University, Harrisonburg, Virginia ...