Curated OER
Excel Lesson
Students investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Curated OER
Lesson 14: Genetic Disorders
Students create PowerPoint presentation on the topic they researched. In this biology lesson, students fill out a storyboard about their topic. They share their project in class.
Curated OER
DNA Technology
Students prepare PowerPoint presentation on DNA and cells. In this biology lesson, students create a storyboard of their presentation. They share the finished project in class.
Curated OER
Making a Travel Brochure of a Louisiana Parish
Although the attachments for this travel brochure project are no longer linked, you can still use the idea here and create your own assignment sheet and rubric. Learners choose a parish in Louisiana (or a city in your state) to research,...
Curated OER
Fabulous Fossils
Seventh graders investigate how fossils are formed and discuss how scientists determine the appearance of ancient plants and animals. They make fossils of everyday objects for others to identify. They make spreadsheets to display fossil...
Curated OER
Graphing With a Spreadsheet
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
Curated OER
Chart/Graph
Students create a class survey, place the data in a spreadsheet and graph the information.
Curated OER
World Education Statistics
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Curated OER
Pedestrian Safety for Students Lesson 4: A Walkable Survey
Students create a survey. In this survey lesson, students use www.walktoschool.org to help them come up with questions to ask other students. They put the information in spreadsheet format.
Howard Hughes Medical Institute
Tracking Genetically Modified Mosquitoes
What's that buzzing in your ear? An insightful lesson about genetically modified mosquitoes! Partnered pupils explore the creation, release, and monitoring of mosquitoes designed to reduce the mosquito population. After watching a video,...
EngageNY
Normal Distributions (part 2)
From z-scores to probability. Learners put together the concepts from the previous lessons to determine the probability of a given range of outcomes. They make predictions and interpret them in the context of the problem.
Bowland
Outbreak: Infection Detection
Explore the mathematics of infection outbreaks with activities that ask learners to use coordinate grids to locate infected patients. They calculate amounts of ingredients for antidotes and determine which groups of people should be...
Education Development Center
Interpreting Statistical Measures—Class Scores
Explore the effect of outliers through an analysis of mean, median, and standard deviation. Your classes examine and compare these measures for two groups. They must make sense of a group that has a higher mean but lower median compared...
Curated OER
Survey Says...
Students practice taking surveys to answer different questions about radio. In this communications lesson, students brainstorm to create questions they can ask strangers about how often they listen to their radio. Students...
Curated OER
A Healthy Heart
Sixth graders create a spreadsheet using specific data. A speaker comes to discuss the heart, and the difference between anaerobic and aerobic activity. They make posters to encourage a healthy heart lifestyle.
Curated OER
Exploring our Community
Students research Los Angeles and its surrounding communities. They create digital presentations of the information they have gathered by answering the question included in the lesson.
Curated OER
Spreadsheet Function Machine
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.
Curated OER
Tiling a Patio
Fifth graders practice, with spreadsheets, to demonstrate how to determine the number of tiles needed to create a patio. They use pictures and gathered data to determine a pattern that can be used to solve problems. Students create a...
Curated OER
What is for Sale and at What Price?
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...
Curated OER
Giving Them the Business
Students work in small groups of 4-5 students to form a business, create, market and sell their product, and track their expenses and profits. They experience the roles of the producer, distributor, and consumer of goods.
Curated OER
Organizing Writing/Composing a First Draft
Seventh graders access an organizer from an earlier lesson and transition sentences to begin a new essay. In this organization and composing lesson, 7th graders work in small groups to create a draft of an article about...
Curated OER
Simple Bar Graphs Using Excel
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Curated OER
How to Buy a Computer
Students investigate the purchase of a specific computer hardware with specific components without going over a budget. The use of computer catalogues, tables, and spreadsheets support the search.
Curated OER
Texas Native Americans
Fourth graders research the Native Americans of Texas using the Internet. They create a Power Point presentation over the four Indian tribes of Texas - Caddo, Jumano, Karankawa, Apache.