+
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.  Students complete...
+
Lesson Plan
Curated OER

Excel Lesson

For Teachers 4th - 5th
Young scholars 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

Excel Lesson

For Teachers 9th - 10th
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.
+
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

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

Comp Tech: Format Cells Scavenger Hunt

For Teachers 6th - 8th
Students begin their use of Microsoft Excel. Individually, they practice using the program, formatting cells and changing the appearance of the spreadsheet. To end the lesson, they participate in a scavenger hunt completing different...
+
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 plan.
+
Lesson Plan
Curated OER

Pedestrian Safety for Students

For Teachers 3rd - 4th
Young scholars create a spreadsheet. In 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

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

Spreadsheet Function Machine

For Teachers 7th - 8th
Students create a spreadsheet to analyze functions. In this algebra lesson, 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

Dough Lake Topology

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

Comuter Technology-Applying Spreadsheet Information

For Teachers 9th - 12th
Students create spreadsheets and practice sorting within the spreadsheet with three different activities. Students manipulate different materials such as addresses, real estate sales, and athletic participation numbers.
+
Lesson Plan
Curated OER

Skittles Candy Count

For Teachers 10th - 12th
Students study how to use formulas, edit the spreadsheet, and create and edit charts. They add data to a spreadsheet, format it, add a chart and format it. They count the number of each color of Skittles and record it onto their Candy...
+
Lesson Plan
Curated OER

WORKING WITH WORKBOOKS

For Teachers 5th - 8th
Students work through problems in the textbook and teacher-made problems to reinforce the new learning. They turn in practice problems to instructor to be checked for accuracy and evidence of understanding
+
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

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.