Lesson Plan
Curated OER

Graphing Using Excel

For Teachers 5th
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information.  For this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the...
Lesson Plan
Curated OER

How to Graph in Excel

For Teachers 4th
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Lesson Plan
Curated OER

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Lesson Plan
Curated OER

Excel Turns Data Into Information

For Teachers 3rd - 8th
Students use excel to analyze data. In this technology lesson plan, students enter data into the excel program to find averages and organize data.
Lesson Plan
Curated OER

Farm Stories, Animal Webbing, Favorite Farm Animal Graph

For Teachers K
Students brainstorm animals they would expect to see on a farm. They save these on a Kidspiration web. Students watch or read a farm story. They discuss the characters. Students vote for their favorite farm animal and crate a graph using...
Lesson Plan
Curated OER

Graphing on the Computer

For Teachers 6th - 8th
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Lesson Plan
Curated OER

Data! Data! Graph that Data!

For Teachers 5th
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their data.
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Young scholars surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

Basic Excel

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

Using Averages to Create Graphs Through Excel

For Teachers 6th
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Young scholars collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Students gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the class.
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology activity; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Graphing With Paper and Computers

For Teachers 4th
Fourth graders construct bar graphs. In this graphing lesson, 4th graders create bar graphs in connection with the story, The Copycat Fish. After creating the initial graphs on paper, students use MS Excel to create graphs.
Lesson Plan
Curated OER

The Stoichiometry Behind Pollution

For Teachers 9th - 12th
Students research car emissions of various cars and find the toxins emitted.  In this stoichiometry lesson, students calculate the relationship between reactants and products in a chemical reaction. Students collect data on...
Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.
Worksheet
Curated OER

Endangered Species

For Students 9th - 12th
In this geography worksheet, students identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Lesson Plan
EngageNY

Building Background Knowledge: Colonial Craftspeople

For Teachers 4th Standards
In the first lesson plan of this unit on colonial trade, fourth graders gain background knowledge of different jobs performed by early colonists. The class begins with a slide show presentation that includes a variety of great...
Activity
North Haven Middle School

Environmental Expert Presentation

For Teachers 6th - 12th
Individuals or groups select an environmental issue, then spend time researching and creating a presentation to share in class. By allowing learners to choose the issue that matters most to them, you will motivate them to do...
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. For this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

Seeing What You Cannot See--RADAR

For Teachers 4th - 8th
Student imitate mapping the ocean floor using the basic concepts of radar. Then they explain what radar is and how it workds. All of their measurements are recorded on a data sheet. Then the data is entered into a spreadsheet program. A...