Lesson Plan
Curated OER

Party Math

For Teachers 10th - 12th
Students create a spreadsheet that they will use to plan a small party or outing. They calculate expenses and stay within a budget amount for their party.
Lesson Plan
Curated OER

Should Voting in the United States be Mandatory? Research Activity

For Teachers 8th
Eighth graders research how many voters actually vote in the U.S. and nine other nations. They create a spreadsheet using this information and write a persuasive essay.
Lesson Plan
Curated OER

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...
Lesson Plan
Curated OER

Houses and Cars and Loans

For Teachers 8th - 10th
Young scholars create a spreadsheet to track their spending. In this algebra instructional activity, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need...
Lesson Plan
Curated OER

Create A Business and A Life

For Teachers 9th - 12th
High schoolers look through a phone book and pick a business they think they would enjoy. They brainstorm ideas about the needs of a business. They set their prices to payback their investment into the new business.
Lesson Plan
Curated OER

ACC Basketball Statistics

For Teachers 6th - 8th
Students use math skills and create a spreadsheet. In this statistics and computer skills lesson, students gather ACC basketball statistics, convert fractions to decimals and then percents. Students use the gathered information to create...
Lesson Plan
Curated OER

T-Shirt Lettering

For Teachers 3rd - 8th
Students determine the cost of a t-shirt using a variety of mathematical operations to solve problems. Then they use a spreadsheet to calculate the cost of lettering a t-shirt and display this information in a graph.
Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study...
Lesson Plan
Curated OER

Triangle Midsegment

For Teachers 9th - 12th Standards
Learn how to calculate the length and midsegments of triangles. Learners differentiate between similar and congruent triangles. They create a spreadsheet with their findings.
Lesson Plan
Curated OER

Writing a Personal Narrative

For Teachers 3rd - 5th
Students complete a variety of computer file pre-writing activities to help them prepare for writing a personal narrative. They focus on including a beginning, middle and end to their narrative. They make a class book.
Lesson Plan
Curated OER

Student News And Weather Channel

For Teachers 5th
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Lesson Plan
Curated OER

Historical Population Changes in the US

For Teachers 9th - 12th
Learners conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret their...
Lesson Plan
Curated OER

Counting Coins

For Teachers 2nd
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
Lesson Plan
Curated OER

How Tolerant Are Kids in Your School?

For Teachers 6th - 12th
Students graph results of a survey about attitudes and tolerance in their school. They discuss the social climate of their school. Students complete a questionnaire, and tabulate the raw data from their class. They create a bar graph...
Lesson Plan
Curated OER

What Goes Up Must Come Down!!

For Teachers 5th
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
Lesson Plan
Curated OER

"Living in the Limelight The Universal Dream"

For Teachers 9th - 12th
High schoolers, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses...
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

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Middle schoolers use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a...
Lesson Plan
Code.org

Making Data Visualizations

For Teachers 9th - 12th
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...
Lesson Plan
Curated OER

Budget Making

For Teachers 9th - 11th
Students develop a budget for spending and saving. In this economics lesson, students create a budget based on personal, family and government income. They discuss jobs at home and allowances. They discuss how they manage their money...
Lesson Plan
Curated OER

Introduction to the National Debt

For Teachers 9th - 11th
Students relate the national debt to the economy. In this algebra lesson, students discuss what the national debt is, create a national budget based on priority and what the government should spend money on. They analyze their findings...
Lesson Plan
Curated OER

Acceleration Science

For Teachers 9th - 12th
In collaborative groups, physics learners design and create a web portfolio of internet resoucres explaining poitive and negative acceleration, zero acceleration, and positive and negative velocity. This is a terrific assignment for...
Lesson Plan
Curated OER

BRIDGING THE GENERATION GAP

For Teachers 9th - 12th
High schoolers create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Lesson Plan
Curated OER

Code Crackers Math Game

For Teachers 6th - 8th
Middle schoolers, through this math game, are provided with opportunities to work with math operations and simple algebraic equations. They create a spreadsheet-based "rule machine."