Lesson Plan
Curated OER

Marvelous Math -- Colorful Fractions

For Teachers 2nd - 6th
Students begin the lesson by discovering that a fraction is one part of a whole. In groups, they practice reducting larger fractions into small fractions and discovering they are equal. They use blocks to identify the relationship...
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson plan, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Lesson Plan
Curated OER

Measuring Ourselves

For Teachers 5th
Fifth graders conduct various measurement activities on themselves and a partner. They measure their height, weight, thumb-to-pinky span, and body temperature, recording the information in the form of an Excel spreadsheet.
Lesson Plan
Curated OER

American History Through Architectural Masterpieces: Monticello

For Teachers 3rd - 5th
Students examine the life of Thomas Jefferson, explore great American landmark Monticello, discover relationships between climate, geographical factors, and time as to what kind of architecture was used, conduct research online, write a...
Lesson Plan
Curated OER

What Temperature Is It?

For Teachers 3rd - 5th
Students use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums, minimums and...
Lesson Plan
Curated OER

Holiday Flier in Publisher

For Teachers 2nd - 5th
Students use Publisher in this lesson to make a holiday flier. For this technology lesson, students create a holiday flier. Students choose fonts, use clipart, use grammar and spelling check, and save to their work to a flash drive or...
Lesson Plan
Curated OER

A Holiday Newsletter In MS Word For Elementary School

For Teachers 4th - 5th
Learners produce a holiday newsletter using a software program. In this holiday newsletter activity, students use a software template to write a newsletter. They fill in the template with appropriate information and pictures.
Lesson Plan
Curated OER

Indegenous Cultures Magazine in Publisher

For Teachers 4th
Fourth graders use Publisher to create their own magazine. In this online magazine lesson, 4th graders follow the instructions to create a magazine using text, pictures, and colors within the Publisher system.
Lesson Plan
Curated OER

Internet ABC's for Elementary Schoolers

For Teachers K - 4th
Students develop basic Internet skills. In this lesson introducing the basics of the Internet, students discover how to use toolbars, address bars, how to save a website to revisit later, and how to use the back and forward buttons. This...
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

I'm in the Money - Practical Money Skills

For Teachers 3rd - 6th
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.
Lesson Plan
Curated OER

GeoHunt

For Teachers 7th - 8th
Students describe the difference between geological resources and othe natural resources. They list the rocks, minerals, and fossil fuels that are found in Illinois and their uses. They identify ways to conserve natural resources.
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
Lesson Plan
Curated OER

Iterating the Function over Real Numbers

For Teachers 8th - 10th
Students use a spreadsheet to find sequences of numbers. In this algebra lesson, students find the values for c of a quadratic written in standard form. They relate the behavior of the graph to the values of the equation.
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

Tech Smart

For Teachers 6th
Sixth graders practice computer skills. In this technology lesson plan, 6th graders use programs such as Microsoft Word, Excel, Print Shop, and PowerPoint. They use the Internet for research and data collection to be incorporated in...
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

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

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

Fighting Obesity with Footsteps

For Teachers 1st - 5th
Analyze the influence of culture, media, technology, and other factors in health through the use of pedometers and daily walking/jogging logs with this activity. The key focus is in dealing with obesity and how small steps can help...
Lesson Plan
Curated OER

Plants Under Attack

For Teachers 3rd
Third graders will identify the four needs for plant survival and gain skills and confidence in using scientific measurement tools, probes as well as the spreadsheets and graphing capacity of a computer to represent and analyze data.They...
Lesson Plan
Curated OER

SolidWorks for Sheet metal

For Teachers Higher Ed
Students practice using the different tools on the Sheet Metal toolbar. In this engineering lesson, students create a sketch given a set of procedures to follow.
Lesson Plan
Curated OER

Numbers, Patterns, and Algebraic Thinking

For Teachers 5th
Fifth graders use spreadsheets.