Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Young scholars create arrays using Microsoft Excel. For 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

Pet Count Excel Graphing

For Teachers 3rd - 5th
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Middle schoolers create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Middle schoolers print graphs without trend lines and...
Lesson Plan
Curated OER

Pets Galore!

For Teachers 4th
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
Lesson Plan
Curated OER

Graphing Our Marbles

For Teachers K
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
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

Stress, Strain and Hooke's Law

For Teachers 10th - 12th
Students study Hooke's Law and stress-strain relationships.  In this spring lesson students create a strain graph in Microsoft Excel.
Lesson Plan
Curated OER

What's your favorite pi?

For Teachers 6th
Sixth graders toss popcorn kernels at a 12? circle inscribed in a 12? square. By counting the number of popcorn kernels that land inside the circle and inside the square the students calculate estimates for the value of pi.
Lesson Plan
Curated OER

Creating Your Own Web Site

For Teachers 6th - 12th
Pupils explore and explain how to design Web pages complete with text, graphics, and hypertext links. After adding backgrounds, navigation buttons, and audio-visual effects, and revising their work based on comments from peers and...
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
Curated OER

Tracking Your Favorite Web Sites

For Teachers 9th
Ninth graders track the hit count on their favorite web sites.  In this Algebra I activity, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine if the...
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
Lesson Plan
Curated OER

Excel temperature Graphs

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

It's In The Chocolate Chips

For Teachers 6th - 8th
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
Lesson Plan
Curated OER

Student Costs Data Table

For Teachers 5th - 7th
Students compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
Lesson Plan
Curated OER

What's your favorite physical fitness activity?

For Teachers 4th
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
Lesson Plan
Curated OER

Code Crackers

For Teachers 6th - 8th
Students work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
Lesson Plan
Curated OER

Peopling the New World -- An Archaeological Exercise in Excel

For Teachers 6th - 8th
Students examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in other...
Lesson Plan
Curated OER

Graphing and Analyzing Biome Data

For Teachers 4th - 6th
Students explore biome data. In this world geography and weather data analysis lesson plan, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees...
Lesson Plan
Curated OER

Using Imported Data in Excel

For Teachers 7th - 10th
Students import atmospheric data from the internet. In this earth science lesson, students graph the data they collected. They complete the worksheet after the activity.
Lesson Plan
Curated OER

USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION

For Teachers 6th - 12th
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
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

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
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.
Lesson Plan
Curated OER

History Trifold in Publisher

For Teachers 4th - 7th
Students create a timeline of events happening around the world. In this timeline lesson plan, students use Microsoft Publisher to create a timeline of events happening around the world as they live their lives presently.

Other popular searches