Curated OER
Basic Excel
Young scholars explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Young scholars title the columns on the spreadsheet and format the cells. Students...
Curated OER
Multiplication Tables Using Microsoft Excel
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Open Oregon Educational Resources
Beginning Excel
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Curated OER
Excel Lesson
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Curated OER
Excel Lesson
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.
Curated OER
Excel Lesson
Students investigate Microsoft excel. In this technology lesson plan, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
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.
Curated OER
Let's Get Linear
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
Curated OER
Piecewise Linear Functions and Excel
In 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...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; 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...
Curated OER
Using Spreadsheets and Graphs
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...
Curated OER
Conversation Heart Graphing
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Curated OER
The Viewing Tube
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a very...
Howard Hughes Medical Institute
Gorongosa: Scientific Inquiry and Data Analysis
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Curated OER
Shoe Showdown
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.
Curated OER
Building Arrays Using Excel Spreadsheets
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.
Teach Engineering
Energy Perspectives
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
Curated OER
Comp Tech: Format Cells Scavenger Hunt
Learners begin their use of Microsoft Excel. Individually, they practice using the program, formatting cells and changing the appearance of the spreadsheet. To end the instructional activity, they participate in a scavenger hunt...
Howard Hughes Medical Institute
Measuring Biodiversity in Gorongosa
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Curated OER
Computer Science: Pendulum
Students investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel...
Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. For this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Curated OER
Interest Calculation and Spreadsheets
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Curated OER
Solving Polynomial Equations
Young scholars demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Curated OER
Spreadsheet formulas
Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...