+
Assessment
1
1
Inside Mathematics

Quadratic (2009)

For Teachers 9th - 12th Standards
Functions require an input in order to get an output, which explains why the answer always has at least two parts. After only three multi-part questions, the teacher can analyze pupils' strengths and weaknesses when it comes to quadratic...
+
Activity
1
1
Agile Mind

Isabella’s Credit Card

For Teachers 8th - 12th Standards
An in-depth activity that involves a real-world problem about credit card debt. Learners are given a scenario in which Isabella plans to stop using her credit card and pay off the balance by paying a fixed amount each month. The first...
+
Lesson Plan
Curated OER

Using a Spreadsheet to Solve Gas Law Problems

For Teachers 9th - 12th
High schoolers use a spreadsheet to solve gas law problems. In this gas laws lesson plan, students use the Express Calc program to load a spreadsheet for the gas law problems. High schoolers compute volume, temperature, or pressure...
+
Lesson Plan
Curated OER

Sales Spreadsheet

For Teachers 6th - 8th
Students use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
+
Lesson Plan
Curated OER

Iterating the Function and Complex Numbers

For Teachers 7th - 10th
Students identify the end behavior of polynomial graphs. In this algebra lesson, students factor and solve quadratic and complex equations. They factor out negative roots and identify the real and imaginary parts of an equation.
+
Lesson Plan
Curated OER

Using Tables to Solve Linear Functions

For Teachers 9th - 12th Standards
Oh that intercept! Budding algebra masters solve linear equations from standard to intercept form. They identify the slope and y-intercept to help graph the lines, an then create coordinate pairs using a table of values. Great TI tips...
+
Unit Plan
Radford University

Real World Data

For Teachers 9th - 12th Standards
Make math class feel more real by using real-world data. Scholars research or collect data on several different topics, such as nutrition, the motion of moving objects, cooling curves, and daylight hours. They create scatter plots using...
+
Lesson Plan
Kenan Fellows

Applying Linear Regression to Marathon Data

For Teachers 10th - 12th Standards
It's not a sprint, it's a marathon! Statistic concepts take time to develop and understand. A guided activity provides an opportunity for individuals to practice their linear regression techniques in spreadsheet software. The activity...
+
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
+
Lesson Plan
Curated OER

Creating a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
+
Assessment
Concord Consortium

Heights and Weights

For Students 7th - 9th Standards
Height is dependent on weight—or is it the other way around? Given data from a physicians handbook, individuals compare the height and weight of males and females at different areas. They calculate differences and ratios to assist with...
+
Activity
Curated OER

Sunrise, Sunset

For Teachers 10th - 12th Standards
What locations on Earth get the longest number of hours of daylight in the summer? Hint: It's not the equator! Use real-world sunrise and sunset data to develop trigonometric models that can be used to estimate the number of hours of...
+
Lesson Plan
Curated OER

The Remainder Theorem Using TI-Nspire CAS

For Teachers 9th - 12th Standards
Investigate the Remainder Theorem in this algebra lesson. Explore the relationship between the remainders of polynomial division and the function. Each of the four problems gets progressively more complicated. This might be a great...
+
Lesson Plan
Curated OER

Spreadsheets - WP9/Quattro Pro

For Teachers 10th - 12th
Pupils discover spreadsheet applications using Quattro Pro. They demonstrate basic knowledge and application of hardware, software, and Internet use. They recognize and appreciate the value of recording keeping, data input and data...
+
Interactive
CK-12 Foundation

Newton's Method

For Students 11th - Higher Ed
Does the accuracy of the first guess make a difference down the line? Learners investigate the effects of the iterative process of finding roots, using Newton's Method. By moving the initial guess of a root on a graph, pupils observe the...
+
Lesson Plan
Curated OER

Linear and Exponential Models

For Teachers 9th - 12th
High schoolers investigate the differences between linear and exponential models.  In this linear and exponential models lesson, students make a table of given data.  High schoolers determine if the data is linear or exponential by...
+
Lesson Plan
Curated OER

Data, Data, Everywhere... and What Am I To Think?

For Teachers 9th - 10th
Students demonstrate good random sampling techniques for data collection, select and develop graphic presentations of data and analyze the data to solve a problem presented.
+
Lesson Plan
Curated OER

Thanksgiving Feast

For Teachers 7th - 9th
Use the Tool Factory Workshop to have your class create a list of people to invite to their Thanksgiving Feast.They will take pictures related to the fall season and create invitations using Tool Factory Database. Students make a grocery...
+
Assessment
Concord Consortium

Boards I

For Students 7th - 9th Standards
Learners create patterns in a table to mimic the function of an electronic spreadsheet. The result is a table that creates an addition table for decimals in intervals of one-tenth. While creating the pattern, pupils must thoroughly...
+
Lesson Plan
Curated OER

Thinking Outside the Box

For Teachers 9th - 12th
Now this lesson sounds fun! Students throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
+
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
+
Lesson Plan
Council for Economic Education

Using an Excel Checkbook

For Teachers 9th - 12th Standards
High school is the time that many scholars get their first jobs. Help young entrepreneurs apply economic principles to crucial skills for their new jobs and for functioning in society in general. They use Excel to balance a checkbook by...
+
Assessment
Concord Consortium

Center of Population

For Students 7th - 12th Standards
Let the resource take center stage in a lesson on population density. Scholars use provided historical data on the center of the US population to see how it shifted over time. They plot the data on a spreadsheet to look the speed of its...
+
Lesson Plan
Curated OER

Modeling Population Growth

For Teachers 9th - 12th
Learners create linear, exponential, and quadratic models of U.S. population data to determine which function best represents U.S. population growth. They predict future populations based on each model.