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
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
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
Young scholars 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.
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
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. In this graphing lesson plan, 5th graders graph favorite desserts of the class. Student put their results into the computer and...
Curated OER
Using Excel To Teach Probability And Graphing
Young scholars 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
Spreadsheet formulas
Learners, 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...
Curated OER
Daily Time Ratios
Students track and record how much time they spend on each activity. In this spreadsheet instructional activity, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent...
Curated OER
Create and Analyze Rectangular Patterns
Students explore the concept of geometric patterns. In this geometric pattern lesson plan, students use Microsoft Excel to explore geometric patterns. Students analyze growth rates of pattern growth. Students create their own...
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
What's your favorite physical fitness activity?
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.
Curated OER
Code Crackers
Young scholars 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
Peopling the New World -- An Archaeological Exercise in Excel
Young scholars 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...
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
Let's Keep Track of Grades
Students participate in a technology project. This instructional activity is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a...
Curated OER
FILLING EMPTY POCKETS: BORROWING, LOANS AND CREDIT.
Learners 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
Graphing and Analysis of Water Quality Reports
Learners practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.