+
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

Inserting Formulas in a Worksheet in Excel

For Teachers 9th
Ninth graders study the vocabulary necessary to create formulas in Microsoft Excel. They complete assigned problems from the textbook for each type of function demonstrated by the teacher until they have developed competency with each...
+
Lesson Plan
Curated OER

Hemlock Trees and the Pesky Pest, The Woolly Adelgid

For Teachers 5th - 6th
Students review Excel and how to create graphs with this program. They create two graphs in Excel, one showing the average number of woolly adelgid egg sacks on the outer 15 cm of hemlock branch at sites sorted by latitude, then one...
+
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

Fairy Tales

For Teachers 6th
Sixth graders explore the elements of fairy tales. In this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
+
Lesson Plan
Curated OER

Skittle it Up

For Teachers 6th - 8th
Students make a graph. In this graphing and Excel lesson, students work in groups and are given a bag of skittles. Students count the number of each color skittle and create a table in Excel. Students learn how to make a pie graph using...
+
Worksheet
Curated OER

Piecewise Linear Functions and Excel

For Students Higher Ed
For this linear function worksheet, students use Excel worksheets to solve piecewise linear functions. They plot functions and produce piecewise linear functions. This six-page worksheet contains detailed instructions on how to use...
+
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
+
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

Introducing Tessellations

For Teachers 6th - 12th
Students create tessellations to increase their knowledge of the applications of geometry. They explore the different shapes of polygons.
+
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

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
+
Lesson Plan
Curated OER

Creating Circle Graphs with Microsoft Excel

For Teachers 9th - 10th
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
+
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 lesson, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine if the relation defines a...
+
Lesson Plan
Curated OER

Excel Turns Data Into Information

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

How to keep a timecard in Excel

For Teachers 3rd - 6th
Students fill out a timecard of family activities in Microsoft Excel. In this Excel lesson plan, students use the program to fill in times they do various activities with their families.
+
Lesson Plan
Alabama Learning Exchange

The State Capital of Stem and Leaf

For Teachers 5th - 10th Standards
Students explore the concept of stem and leaf plots.  In this stem and leaf plots lesson plan, students plot the 50 US states' capitals on a stem and leaf plot according to the first letter of each state.  Students compare their stem and...
+
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Young scholars 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...
+
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

Integrated Project

For Teachers 6th - 8th
Students participate in a project that integrates Microsoft Word, Excel and PowerPoint. In groups, they write a proposal for their project and complete the necessary steps to create and design it. To end the lesson, they are graded...
+
Lesson Plan
Curated OER

Introductory Excel Lesson involving Problem Solving

For Teachers 6th
Sixth graders analyze an introductory lesson for Microsoft Excel. They go step by step through the creation of a basic spreadsheet and the use of simple formulas in a problem solving format.
+
Lesson Plan
Education World

A Spooky Adlib Story

For Teachers 3rd - 5th
Students navigate a simple spreadsheet and develop their creativity. They answer questions, filling in cells on Excel, using a template after filling in all the fields, a silly spooky story is created from the answers they give. Students...
+
Lesson Plan
Curated OER

Creating Your Own Web Site

For Teachers 6th - 12th
Students 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

Made Round To Go Round

For Teachers 2nd - 3rd
In this lesson students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...