Lesson Plan
Curated OER

The Snack Bar

For Teachers 6th
Sixth graders complete a purchase order. In this ratios and patterns lesson, 6th graders work in groups to complete a purchase order for a grand opening of the school snack bar. Students use rations to figure out the need and quantity...
Lesson Plan
Curated OER

Checking Test Comparability/Scattergrams

For Teachers 7th - 12th
Students construct a scattergram graph. In this statistics lesson plan, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.
Lesson Plan
Curated OER

History Trifold in Publisher

For Teachers 4th - 7th
Students create a timeline of events happening around the world. In this timeline lesson plan, students use Microsoft Publisher to create a timeline of events happening around the world as they live their lives presently.
Lesson Plan
Curated OER

Reading + Keyboarding= Success

For Teachers 3rd - 8th
Students practice their keyboarding skills. In this typing lesson, students use interesting stories to practice their skills. They practice throughout the semester and then monitor their improvement.
Lesson Plan
Curated OER

Class of 2000 - Student Loans

For Teachers 10th - 12th
Students determine how they will finance their postsecondary education. In this student loan lesson, students create spreadsheets that help them budget their first year of college. Students identify methods to fund the budgets and...
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

Dough Lake Topology

For Teachers 9th - 12th
Young scholars practice coordinates and measurements, develop 2D, 3D topological map, construct grid with string on real surface, establish "level" fixed point for measurements, take and record data points of elevation, and enter data on...
Lesson Plan
Curated OER

Did Somebody Say...? Where to Work?

For Teachers 6th - 8th
Middle schoolers conduct research on four fast food restaurants to determine where they might apply for a job. They conduct research on hourly rate, working conditions, and benefits, construct a spreadsheet with a graph, and present...
Lesson Plan
Curated OER

Pedestrian Safety for Students

For Teachers 3rd - 4th
Students create a spreadsheet. For this spreadsheet lesson, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Lesson Plan
Curated OER

Spreadsheet Project: Planning a Party

For Teachers 9th - 12th
Students create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
Lesson Plan
Curated OER

Million Dollar Project

For Teachers 5th
Each student is given the task of spending $1 million. The way students spend their money is dependent on a theme such as "creating a dream world," "taking a trip," or "doing something to better society." Each student researches,...
Lesson Plan
Curated OER

And the Survey Says...

For Teachers 7th - 8th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information; apply appropriate technologies to critical thinking, creative expression, and decision-making skills. They collect and explore data...
Lesson Plan
Curated OER

Linear Regression (and Best Fit)

For Teachers 9th - 12th
Students explore notions of relationships between two variables. They use discussion, games, worksheets, spreadsheets to consider relationships such as: height vs. shoe size, cricket chirping vs. temperature.
Lesson Plan
Curated OER

How Does Cell Size And Shape Affect Transport of Materials

For Teachers 10th
Tenth graders explore concepts of surface area, volume, and ratios, create spreadsheets to aid organization of data collected and provide graphing capabilities, and use NIH Imaging to enable calculations of microscopic organisms.
Lesson Plan
Curated OER

Chaucer's Characters in The General Prologue

For Teachers 12th
Twelfth graders explore the characters in The General Prologue. They describe the characters and their occupations and their lands of origin. Students organize the characters using Excel spreadsheets.
Lesson Plan
Curated OER

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Lesson Plan
Curated OER

What Happens on Average

For Teachers 5th
Fifth graders are introduced to convergence of sequences based on averaging previous terms in the sequence. The power of the "fill-down" function in spreadsheets is exploited. By using various starting numbers, and inferring the limit,...
Lesson Plan
Curated OER

Geography Fieldwork River Study

For Teachers 8th
Eighth graders collect, record, and analyze data from a local river and input the data into the computer. They collect and record the information, discuss the data collected, and enter the data into a spreadsheet and charts to compare...
Lesson Plan
Curated OER

Graphing Grazy Crayons

For Teachers 2nd
Children create crazy crayons they made to sort and construct a floor bar graph. Then, using technology resources, they make a simple bar graph to compare the top four colors produced. Students will then interpret the printed graph by...
Lesson Plan
Curated OER

Texas Weather Report

For Teachers 4th - 5th
Young scholars use provided links to observe selected weather sites and collect temperature and precipitation data for listed cities. They enter the information onto their spreadsheet. Students study maps of the Texas natural reagions,...
Lesson Plan
Curated OER

ABC's of Banking

For Teachers 9th - 10th
Young scholars explore the concept of managing money. In this managing money lesson plan, students discuss how to write checks and keep an accurate check registry. Young scholars discuss the importance and uses of debit cards and deposit...
Lesson Plan
Curated OER

Dream Vacation

For Teachers 9th - 12th
Students research cities, states, or countries using the internet and other resources to learn about a vacation spot. They make a final presentation of their findings in forms other than a written report.
Lesson Plan
Curated OER

Have Fun With Technical Report Writing

For Teachers 9th - 12th
Students use Clarisworks Word Processing and Spreadsheet, Quick-Take Camera and Software, and produce a publishable technical paper.
Lesson Plan
Curated OER

Bones and Math

For Teachers 5th - 12th
students identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and organize...

Other popular searches