Lesson Plan
Curated OER

Parts of a Spreadsheet

For Teachers 9th - 12th
Learners create their own spreadsheet. They identify the different parts that make up a spreadsheet and organize their data. They practice using functions and formats.
Lesson Plan
Curated OER

Parts of a Spreadsheet

For Teachers 7th - 9th
Students experiment with the basic functions of a spreadsheet. They practice using headers, footers, functions and fonts. They also organize information.
Lesson Plan
Curated OER

Class Birthday Graph

For Teachers 2nd - 3rd
Students analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
Lesson Plan
Curated OER

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
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

Using a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Lesson Plan
Curated OER

Cross Cultural Transportation and Resources Exchange

For Teachers 10th - 11th
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Lesson Plan
Curated OER

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Graph Frenzy!!

For Teachers 6th - 7th
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Lesson Plan
Curated OER

Graphing My Path to Success

For Teachers 7th
Seventh graders examine their school performance through self-assessment of strengths and weaknesses. They construct a line graph, plotting all courses and achievements. Students use graph paper and colored pencils for each activity. If...
Lesson Plan
Curated OER

Creating a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
Lesson Plan
Curated OER

Getting It Right! An Investigation of the Pythagorean Theorem

For Teachers 6th - 8th
Learners construct a variety of right triangles using a right-angled set square, cutting corners from pieces of paper or cardboard, and using dynamic geometry software. They measure the sides of these various right triangles and record...
Lesson Plan
Curated OER

Correlation of Variables by Graphing

For Teachers 7th - 10th
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
Lesson Plan
Curated OER

Haber's Process- A Computer Simulation

For Teachers 10th - Higher Ed
Students use an on line simulation to produce ammonia using Haber's process. In this Haber's process lesson plan, students use a spreadsheet to manipulate the pressure, temperature and catalysts used in the production of ammonia. Their...
Lesson Plan
Alabama Learning Exchange

How Big Can a Bee Be?

For Teachers 7th - 10th Standards
Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
Lesson Plan
Curated OER

Forces of Flight - Lift

For Teachers 3rd - 8th
Learners design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson is excellent for use with upper-elementary and middle-level learners and uses spreadsheet software...
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Lesson Plan
Curated OER

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Lesson Plan
Curated OER

Math Hunt

For Teachers 8th - 10th
Go on a scavenger hunt around your school to find evidence of math. Investigate different areas of your school for patterns, fractions, and different geometric shapes. Finally, create a spreadsheet and plot the data you've collected.
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Young scholars use NASA satellite data to compare water vapor over the United States.  In this data analysis instructional activity students use an Excel spreadsheet to map their data. 
Lesson Plan
Curated OER

Houses and Cars and Loans

For Teachers 8th - 10th
Young scholars create a spreadsheet to track their spending. In this algebra lesson, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need to buy a car and...
Lesson Plan
Curated OER

Don't Lose Your Load!

For Teachers 9th - 11th
Students create graphs using collected data. In this algebra lesson, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
Lesson Plan
Curated OER

Graphing With a Spreadsheet

For Teachers 4th
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...

Other popular searches