Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
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

Shoe Showdown

For Teachers 3rd
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Lesson Plan
Curated OER

Fast Food Survey Using Bar Graphs

For Teachers 2nd
Second graders conduct survey and sort data according to categories, construct bar graph with intervals of 1, and write a few sentences about their graphs.
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Lesson Plan
Curated OER

Meet The Graphs

For Teachers 3rd - 4th
Students identify two types of graphs. They analyze and interpret authentic data shown in bar and pie graphs and complete a graph given specific data. Perform simple functions within an Excel document:
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

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

Who is Being Left Behind?

For Teachers 7th - 9th
Students investigate scores as they relate to race. In this algebra lesson, students analyze standardized scores and how race can affect these scores. They plot their findings on a graph and draw conclusions.
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

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.