Lesson Plan
Curated OER

Spreadsheets and Database in Social Studies

For Teachers 5th
Fifth graders create/use spreadsheets to solve real-world problems, explore patterns and make predictions, select/explain most appropriate types of graph to display data, and enter data into a prepared spreadsheet to perform calculations.
Lesson Plan
Curated OER

Graphing Favorite Holidays

For Teachers 1st - 3rd
Young scholars create spreadsheets and bar graphs based on results of survey of favorite holidays.
Lesson Plan
Curated OER

Menu Math

For Teachers 5th - 6th
Learners follow the food pyramid to create a daily food budget. They research food prices online or in newspapers. They graph the amount of each food group included in their menus. They can also create a weekly food menu based on a fixed...
Lesson Plan
Curated OER

The Egg Drop

For Teachers 9th - 12th
Students 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

Healthy School Food

For Teachers 5th - 8th
Young scholars design a balanced school menu or a healthy snack vending machine. Students create a colorful wall display. Young scholars demonstrate about food groups on a spreadsheet. Students answer a survey on what foods to eat and why.
Lesson Plan
Virginia Department of Education

Mystery Iron Ions

For Teachers 9th - 12th Standards
Young chemists perform an experiment to determine if a compound is iron (II) chloride or iron (III) chloride. Then they determine the formula, balance the equation, and answer analysis questions. 
Lesson Plan
Curated OER

Getting to Know the Thirteen Colonies

For Teachers 5th
Fifth graders analyze information about the thirteen colonies. Using the information, they can manipulate and identify a region in which the colony is located. As a class, they make generalizations about the various regions and time...
Lesson Plan
Curated OER

M & Ms in a Bag

For Teachers 3rd - 5th
Students make predictions about the number and colors of M&M's in a snack size package. They create an Excel spreadsheet to record the data from their small group's bag, create a graph of the data, and discuss the variations of data...
Lesson Plan
Curated OER

Memory Game

For Teachers 6th - 9th
Students create cards for a memory game by entering data into a spreadsheet that is then merged into a word processing document. Tutorials are available through links on the activity page.
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

What is for Sale and at What Price?

For Teachers 7th
Seventh graders will research information on products carried by a store (such as sporting goods, department, clothing, etc.) They will create purchase prices for the products they wish to carry. They also will decide what percentage...
Lesson Plan
Curated OER

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. In this spreadsheet instructional activity, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time...
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. Learners make a grocery...
Lesson Plan
Curated OER

Environmental Risk Analysis

For Teachers 9th - 12th
Young scholars complete a survey and enter the responses in a spreadsheet. The spread sheet is used to create a bar graph. Students complete spreadsheets listing types of hazards in their community.
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Lesson Plan
Alabama Learning Exchange

Wet Heads

For Teachers 6th - 8th
Middle schoolers apply the steps of the scientific method to an experiment. They complete an instructional activity of scientific inquiry and use a spreadsheet software to create a graph illustrating data gathered.
Lesson Plan
Curated OER

The Ultimate Vacation

For Teachers 9th - 12th
Students use research skills to solve a problem. They research information needed to plan a vacation. Students create a letter, a flyer, an itinerary, an activity list, cost spreadsheet, a reference page, table of contents and a title page.
Lesson Plan
Curated OER

A Christmas Project

For Teachers 7th
Seventh graders publish a letter and spreadsheet using the computer. They build a three-dimesnsional object with construction paper and develop a Christmas object using coordinates on a graph. Students compose a response in their journals.
Lesson Plan
Curated OER

Finding Percent When Given A Fraction

For Teachers 7th
Seventh graders calculate percentages when given a fraction. They convert a percentage to a fraction. All of this be done by each student's ability to read the graphs made available by the spreadsheet information.
Lesson Plan
Curated OER

Catalog Display for the Novel : The Family Under the Bridge by Natalie Carlson

For Teachers 4th
Fourth graders explain the novel through creative descriptions, learn importance of word choice in descriptive writing, and implement technology skills of searching the Internet, typing, cutting and pasting, graphic designs, and...
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
Education World

A Spooky Adlib Story

For Teachers 3rd - 5th
Students navigate a simple spreadsheet and develop their creativity. They answer questions, filling in cells on Excel, using a template after filling in all the fields, a silly spooky story is created from the answers they give. Students...
Lesson Plan
Curated OER

It's 'ELEMENT' ary

For Teachers 6th - 8th
Students, using a Web site about the periodic table of elements, create spreadsheets representing elements and their properties. They also create graphs that compare the physical properties of the elements.
Lesson Plan
Curated OER

What's Your Favorite? Survey And Graphing Project

For Teachers 6th
Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.

Other popular searches