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...
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
Excel
In this technology worksheet, learners 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
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.
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.
Curated OER
Graphing Using Excel
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...
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
Daily Time Ratios
Learners track and record how much time they spend on each activity. In this spreadsheet lesson, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day. They...
Curated OER
Create and Analyze Rectangular Patterns
Students explore the concept of geometric patterns. In this geometric pattern lesson, students use Microsoft Excel to explore geometric patterns. Students analyze growth rates of pattern growth. Students create their own patterns and...
Curated OER
Made Round To Go Round
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...
Curated OER
Excel temperature Graphs
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.
Curated OER
Code Crackers
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.
Curated OER
Ict Activity 22
Students use Excel to solve quadratic equations by trial and improvement. They enter formulas and try different solutions to improve their solutions more quickly. Afterwards, they report the solutions to different levels of accuracy.
Curated OER
Credit Cards: The Good, the Bad, and the ugly
Students study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Curated OER
Law of Large Numbers - Hospital
Students explore concepts of probability and independent events. They develop a formula for deviation percentage.
Curated OER
Range and Measures of Central Tendency
Third graders take notes on a PowerPoint presentation featuring calculating and analyzing data. They practice skills highlighted in the presentation and create a table in Microsoft Excel showing data analysis.
Curated OER
FILLING EMPTY POCKETS: BORROWING, LOANS AND CREDIT.
Students learn that maintaining financial security takes a good math understanding. In this lesson, students apply mathematical formulas to make important financial decisions like getting the right loan to buy a house, decide which...
Curated OER
Three Squirrels and a Pile of Nuts
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Curated OER
Solving Polynomial Equations
Students 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
Candy is Dandy
Students investigate color distribution in bags of M&Ms They sort and classify the contents of a bag of M&Ms and summarize their findings on a worksheet. Students convert the numbers into charts and make predictions about color...
Curated OER
Do Vampires Really Exist?
Students identify and extend a number pattern into very large values. They create and interpret a graph based on their number patterns. Students compare a math model with real-world statistics about the existence of vampires.
National Council of Teachers of Mathematics
National Debt and Wars
Take a functional approach to the national debt. Learners collect information about the national debt by decade and plot the data. They determine whether an exponential curve is a good fit for the data by comparing the percent changes...
Curated OER
Building My Dream House
Young scholars create their dream house using a spreadsheet for measurements. In this measurements and drawings instructional activity, students apply concepts of units and conversions as they build and create different shapes. They...
National Research Center for Career and Technical Education
Depreciation (Double Declining)
Have you ever been told that your new car begins to lose its value as soon as you drive it off the lot? Aspiring accountants take on the concepts of depreciation and book value through an easy-to-deliver career and technology lesson. The...