Curated OER
Data Analysis and Probability: Graphing Candy with Excel
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
5280 Math
Stories That Formulas Tell
Learn the stories a formula holds. An interesting lesson takes a unique approach to teach how to use formulas. Beginning with a formula, learners predict what the variables stand for and then use the formula to make calculations and tell...
Curated OER
Excel
In this technology worksheet, students are taught how to create documents using Excel. They follow the directions on a handout to help them create documents. They print their final work and submit it.
Curated OER
Inserting Formulas in a Worksheet in Excel
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...
Curated OER
Adding and Subtracting Decimals With Excel
What a great way to have pupils apply classroom learning to real-world skills! They complete problems involving the addition and subtraction of decimals related to banking-type questions, and then use a spreadsheet to display their results.
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
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.
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.
Student Handouts
Chapter and Unit Grades in Microsoft Excel
Keep track of grades with an Excel spreadsheet that is already formatted to average scores. The assignments are all listed as chapters, but could easily be changed to reflect your assignments. Included in the spreadsheet is sample...
Curated OER
2002 U.S. National Chemistry Olympiad National Exam - Part I
As to be expected from the American Chemical Society Olympiad Examinations Task Force, this 60-question test tops the charts in terms of excellence. It consists entirely of multiple choice questions designed to assess a year's worth of...
Curated OER
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the computer and then...
Curated OER
Excel for Beginners
In this Excel lesson, students set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
Math Worksheets Land
Recognize Area Word Problems - Matching Worksheet
Don't let the title fool you on this one; there aren't any word problems here. Scholars examine five rectangles that have been partitioned into rows and columns, determining the area based on these equal square units. Units aren't...
Curated OER
Math Operations/Formulas
Students discuss the ways spreadsheets can help them solve story problems. In groups, they must set up a spreadsheet with the correct formulas based off of different scenerios using the correct order of operations. To end the lesson,...
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Curated OER
Introductory Excel Lesson involving Problem Solving
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.
Royal Society of Chemistry
Chemistry Masterclass—Chemistry Outreach
Immerse your chemistry class in the world of organic chemistry! Science scholars isolate acetaminophen from an over-the-counter sample during an intense and interesting lab. Groups use many different separation and analysis techniques to...
Curated OER
Using Excel To Teach Probability And Graphing
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...
Curated OER
We All Scream for Ice Scream
High schoolers explore the formulas for volume of three-dimensional objects. They participate in various activities involving ice cream, ice cream cones, small candies, and gum balls, recording their calculations on a lab sheet.
Curated OER
Computing with Mathematical Formulas
Students solve problems using formulas. In this algebra lesson plan, students evaluate numbers using substitution. They graph their answers using a TI and discuss the outcome.
Curated OER
Sales Spreadsheet
Students use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Excel temperature Graphs
Learners 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. Learners will find the average weather and add a trend line to their graph.
Curated OER
World Population Activity I: Excel
Students use Excel to explore population dynamics using the Logistic equation for (S-shaped) population growth. This activity is primarily intended as an introductory tutorial on using Excel.
Other popular searches
- Microsoft Excel Formulas
- Teaching Excel Formulas
- Excel Formulas and Functions
- Writing Excel Formulas