Lesson Plan
Curated OER

Second Star To the Left and Straight On 'Till Morning" - Spreadsheet Driven Exploration of Pacific Asian Geography

For Teachers 6th - 12th
Students explore the geography of Pacific Asia. The class is divided into two groups to participate in a role-play activity where they act as European explorers. Students utilize mathematics, spreadsheet and internet technology to make...
Lesson Plan
Curated OER

4 Month Budget Spreadsheet

For Teachers 8th
Eighth graders create and maintain a spreadsheet budget based on a predetermined salary. They have an opportunity to make "investments and purchases." Budget records be kept for an imaginary 4 month period.
Lesson Plan
Curated OER

Circles and Stars

For Teachers 3rd - 4th
Students solve multiplication problems utilizing virtual manipulatives, express multiplication problems in form of expressions, enter data into a spreadsheet and analyze results, and play game Circles and Stars.
Lesson Plan
NOAA

Biological Oceanographic Investigations – Signals from the Deep

For Teachers 9th - 12th Standards
The Deepwater Horizon oil spill directly impacted an area of the Gulf of Mexico the size of Oklahoma. A marine biology lesson looks at the impact of an oil spill on the deeper parts of the ocean. Scholars download actual data collected...
Lesson Plan
Curated OER

WebQuest: Thrills and Spills- Pick Your Park!

For Teachers 4th - 6th
Students participate in a WebQuest in which they must determine which amusement park is the "median priced" park. Students visit park websites to accumulate prices for parking, activities, restaurants, and gift shops.
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

Bingo!

For Teachers 1st
First graders practice and reinforce phonics and/or math skills by creating Bingo! game using computer spreadsheet. Students incorporate phonics or math skills class has been practicing onto Bingo! cards, which can be printed and made...
Lesson Plan
Curated OER

Backyard Birds: Who's Who Out There?

For Teachers 3rd - 4th
Students practice techniques of field observation and data-gathering while studying local bird population, describe ecosystem as complex combination of elements, which can affect or be affected by each other, and determine effects of...
Lesson Plan
Curated OER

The Egg Drop

For Teachers 9th - 12th
Learners design and create a container that allows a raw egg to drop from the second floor of a building without breaking. They develop and compute an invoice for project expenses using spreadsheet software. Students role-play a proposal...
Lesson Plan
Curated OER

Code Crackers Math Game

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

Checkbook

For Teachers 3rd - 5th
Develop life skills through the use of an AppleWorks Banking kit, a spreadsheet program, and a role play activity. This life skills lesson utilizes technology plus busines and social studies principles. Note: All materials...
Lesson Plan
Curated OER

Get A Life

For Teachers 9th - 12th
Students explore choosing a career and living on a budget. They receive an alternative identity and must make choices and decisions based upon given situations. Students research possible solutions, and use spreadsheet technology to...
Lesson Plan
Curated OER

Money Math

For Teachers 6th - 12th
Young scholars explore the use of money in daily life. Through activities and real-life simulations, students write and balance a checkbook, explore the importance of budgeting, saving, and expenses. Using spreadsheet technology, they...
Lesson Plan
Curated OER

Toy Planet

For Teachers 4th - 6th
Students design a toy store, supply it with merchandise (on paper) and create advertisements. They also manage the store's debits and credits by using a spreadsheet. They consider how to promote the sale of their merchandise.
Lesson Plan
Curated OER

Running a Business

For Teachers 6th - 8th
Students discuss spreadsheets and how they work. They then imagine they are owners of a store, determine twenty items that they would sell, and create spreadsheets to record amounts of each item sold in a two-week period. After entering...
Lesson Plan
Curated OER

How Well Will I Eat This Week?

For Teachers 8th
Eighth graders develop a healthy menu for the coming week using Palm technology to develop healthy eating habits. They develop a spreadsheet for the seven days and for each menu using the Palm.
Lesson Plan
Curated OER

Personal Budgeting Project

For Teachers 8th - 11th
Students create an Excel spreadsheet of a personal budget by estimating their possible income and monthly expenses from a worksheet. They group together to create a family unit and use the personal budget sheets to plan a family budget.
Lesson Plan
Curated OER

Buying My First Car

For Teachers 5th - 12th
Students pretend they are about to buy their first new car. They must do all the calculations necessary to estimate the cost of purchasing the car. They see that the math they learn in school really does have real-life applications.
Lesson Plan
1
1
California Academy of Science

Optimal and Sustainable: Renewable Energy Revamp

For Teachers 6th - 10th Standards
More than 100 cities around the world have shifted from fossil fuels to renewable energy sources. Scholars investigate a city wanting to make this switch, but needs help determining how to make the shift. Groups consider all options,...
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
ARKive

Biodiversity and Evolution – Darwin’s Finches

For Teachers 9th - 10th
Teens experience natural selection firsthand (or first beak) in an activity that has them act as finches foraging for food. Using different household items  to act as different beak styles, your little finches will collect as much...
Lesson Plan
Curated OER

Make Your Fortune in Stocks

For Teachers 4th
Fourth graders participate in a stock investment activity in which they research stocks to place in an imaginary portfolio. They invest $10,000 in a variety of stocks and track their progress using the Internet or newspapers.
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...
Lesson Plan
Curated OER

A Simple Model for Natural Selection

For Teachers 6th - 12th
Do you have what it takes to survive as a fit predator or will elusive prey lead to your extinction? Find out in a creative natural selection activity. Using different colors and shapes of grains to represent different species and...

Other popular searches