The Spreadsheet Lab Manual

Subtitle

**Objective:** Incorporate spreadsheets into STEM education by providing teachers with self guided modeling activities students call "Spreadsheet Labs".

Each __Spreadsheet Lab Manual__ activity begins with a breif intro powerpoint that prelabs the step by step guide to program a spreadsheet model and then use it to investigate and solve problems related to their specific course content. (follow the link to view subject specific activity list)

All 21st century high school students should learn on spreadsheets in their math and science classes... Spreadsheets are everywhere, they are immensely powerful, improve worker efficiency exponentially and are not going away!

Students Will: OPEN A BLANK SPREADSHEET AND PROGRAM A QUANTITATIVE MODEL

-*Then study the model learning science, math and spreadsheet capabilities simultaneously!*

Every STEM teacher can do it using __The Spreadsheet Lab Manual__. Spreadsheet Lab Manual Schools: **97**

Spreadsheet Labs enhance course content, __Engage every student__ and provide a foundation for computer data analysis.

** Question: ** Why do all 3 major spreadsheet brands (Excel, Google Sheets and Apple) have

__The Spreadsheet Lab Manual__ is the only collection of Science and Math instructional resources that your high school teachers will ever need. The complete school license provides the training and the instructional materials (25 original "Spreadsheet Labs") to teachers in every STEM subject area permanently. Having electronic copies of materials makes it easy to incorporate mathematical models of STEM content on a spreadsheet into your instruction. Click to view: __Full List of Activity Descriptions__ (by subject area)

OBJECTIVES:

-Provide teachers with 25 classroom ready STEM activities for students in Math and Science.

-Train students and teachers with limited experience to become proficient with spreadsheets.

-Give the calculating power and time saving ability that spreadsheet skills produce to all students for they will be certain to benefit them in the future.

Scroll Down to View Graphs and Activity Summaries: *The following graphs are produced and manipulated by students completing the activities in The Spreadsheet Lab Manual*. The data is generated from mathematical models written and assembled by the students by following the procedures outlined in the activities.*

**Activity:** "Comparing Trajectories" (Physics) click to view: Video Demonstration

**Description:** This graph compares the trajectories of projectiles with and without air resistance on a spreadsheet. Students can investigate this motion by adjusting cross sectional area, mass, initial velocity, launch angle or drag coefficient and immediately observing the effect of the change.

**Content Areas:** Kinematics, Forces and Newton's Laws

**Objectives: **Students will create a spreadsheet from scratch that quantitatively calculates the trajectory of a projectile and then answer questions that will allow them to model a wide variety of projectiles experiencing drag force.

__________________________________________________________________________________________________________________

**Activity: **Taken from "Acid Base Titration" (Chemistry) click to follow: Video Demonstration

**Description: **This graph is produced by students simulating titration of an acid with a base of known concentration using logical and problem solving functions on a spreadsheet.

**Content Areas:** Acid Base Chemistry, Analytical Methods

**Objectives: **The students will simulate titration, perform titration calculations by solving problems with spreadsheet functions (goal seek), and explain why students often over titrate in a lab due by quantitatively observing the small volume required for neutralization.

**Activity: **Taken from **"**Population Growth 2*" (Predator Prey Simulation) (Biology)

**Description:** This is a graph of the populations of predator and prey populations approaching equilibrium numbers as their linked populations cycle based on their interdependence. **Content Area:** Ecology, Population Dynamics

**Objectives: **The students will observe the dynamics of a predator and prey species and conditions that lead to extinction by constructing a mathematical model of their populations and graphing them verses time on spreadsheet. The students will alter variables such as initial populations, predator benefit, prey fatality probability, logistic competition factors, minimum viable populations.

* Serves as a follow-up to "Population Growth 1" which compares Ideal and Logistic Models.

**Activity:** "The Superposition Principle" (Physics) Video Demonstration

**Description: **Superimposing wave functions with equal amplitudes and nearly equal frequencies to produce beats on a spreadsheet.

**Content Area: **Wave Mechanics

**Objectives: **The students investigate how the superposition principle can cause wave amplitudes to combine for waves both in phase and out of phase. Beats are observed at multiple different frequency combinations to study the effect of varying frequency and amplitude to infer a model for the phenomena of beats.

**Background:**

__View Demonstration Video__ for High School teachers and administrators*

__The Spreadsheet Lab Manual__ is a collection of Science and Math activities each of which begins by opening a blank spreadsheet and following the instructions to construct a spreadsheet that performs a relevant task. The tasks range from simulations of physical behavior (such as the above examples) that can be modeled mathematically to solving a multiple step mathematical problem. Activity levels range from basic to advanced and serve to enrich the curriculum with 21st Century Skills such as spreadsheet manipulations, calculations, graphs and programming among others. They do this while boosting students' understanding of the course content with a level of interaction with the material that would not be possible without the** calculating power** and **immediate feedback** that a spreadsheet can provide. Through their own preparation and student observation during classroom use of the activities, teachers will garner and reinforce their own skills with spreadsheets while creating a dynamic of students and teachers sharing their skills.

__Comprehensive NJCCCS alignment__

**Content area** and **subject area** of each lab activity:

For a more detailed description of each activity please refer to the following __Activity Descriptions__ and __Activity Planner__

- Vector Addition of multiple 2 dimensional vectors.(
**Physics:**Vectors) __Terminal velocity__(**Physics:**motion and forces)- Projectile motion with air resistance (
**Physics:**motion and forces) - Graphing instantaneous velocity and position verses time of a rocket with changing mass due to burning fuel and air resistance acting on it (
**Physics:**motion and forces) - Shifting gears in a car and accelerating it through a range of engine speeds (
**Physics:**rotational motion and forces) - Inflating a balloon and plotting buoyant force and weight vs. diameter (
**Physics:**buoyancy - Superimposing Wave functions to observe interference and beats (
**Physics**: waves) - Performing electrostatic field, force, potential and PE calculations (
**Physics:**electrostatics) - Analyzing mathematical relationships in circuits (
**Physics**: current electricity) - Generating heating/cooling curves for objects using Newton's Law of Cooling (
**Physics**: heat) - Predicting limiting reactants and percent excess for chemical reactions (
**Chemistry**: stoichiometry) - Simulating titrations and solving related problems (
**Chemistry**: acid-base reactions) - Comparing population growth in ideal and logistic models (
**Biology/Environmental**: populations) - Modeling predator prey interactions in an ecosystem (
**Biology/Environmental**: populations) - Solving and graphing quadratic and nonlinear equations (
**Math**) - Modeling investments, compounding interest and amortizations (
**Math**) - Simulating casino games to analyze the probability of winning or losing over the long run (
**Math**) - Optimization of can design using cylinder geometry
**(Math)** - Analyzing functions over varying intervals and graphing
**(Math)**

_____________________________________________________________________________________________________________