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
Excel Lesson
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.
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 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.
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...
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...
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
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.
Illustrative Mathematics
Extensions, Bisections and Dissections in a Rectangle
Gaining practice in translating a verbal description into a diagram and then an equation is the real point of this similar triangles exercise. Once the diagram is drawn, multiple methods are provided to reach the conclusion. An effective...
Curated OER
Springfield Digital Storytelling Project #6: Grapes Commercial
Here is a fabulous lesson that should have your class very excited! They utilize the GRAPES formula in order to produce a commercial like ones we see on TV. Working in pairs, they must come up with a script, take video, provide music,...
Curated OER
Daily Time Ratios
Students track and record how much time they spend on each activity. In this spreadsheet lesson plan, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day....
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
Making Molecular Models
In these creative hands-on activities, students construct several different molecular models that represent substances that play an essential role in our nutritional needs. Using gum drops and toothpicks, students design the models....
Curated OER
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Curated OER
Sea Floor Spreading I
Students use Excel to explore the geodynamics Model equation for ocean depth around a sea-floor spreading center. They complete an introductory tutorial on Excel for students with no prior Excel experience.
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
ICT Activity 17
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Curated OER
Building My Dream House
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up...
Curated OER
WORKING WITH WORKBOOKS
Students work through problems in the textbook and teacher-made problems to reinforce the new learning. They turn in practice problems to instructor to be checked for accuracy and evidence of understanding
Curated OER
Sports Science
Students explore athletes and how they perform. In this physics lesson, students investigate how physics is involved in sports. Students go online to interactive sites that explain physics and biomechanics. Students also research...
Curated OER
Fruitvale Extension
Students determine sources and extent of ground water contaminate, apply mathematics to model in real world simulation, and use technology to present results.
Curated OER
Cones, Cylinders, Spheres
Students classify polygons by name and shape. In this geometry lesson, students identify the lateral surface of each conic. They differentiate between cones, cylinders and spheres.
Curated OER
Pi Digit Distribution
Students study graphing skills and compare and contrast data sets. They compute pi through the first 50-100 digits and create a bar graph showing the frequencies of specific digits.
Better Lesson
Better Lesson: Rewriting Formulas
For this lesson, students explore "real-life" resources that make use of literal equations (rewriting known formulas) to help make people's lives easier. Students will use Excel to design formulas that find a specific value like those...