Curated OER
Let's Keep Track of Grades
Students participate in a technology project. This lesson 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 spreadsheet, create...
Curated OER
FILLING EMPTY POCKETS: BORROWING, LOANS AND CREDIT.
Students learn that maintaining financial security takes a good math understanding. In this instructional activity, students apply mathematical formulas to make important financial decisions like getting the right loan to buy a house,...
Curated OER
Graphing and Analysis of Water Quality Reports
Young scholars practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
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
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
Graphing the Standard Curve
Srudents demonstrate analysis of colorimetric assay results by analyzing them using a computer graphing program and demonstrate application of standard curves by finding other areas of science that can utilize standard curves in analysis...
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?
Pupils 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.
Curated OER
Don't Trash the Earth
Learners experience a hands-on environmental science project. They access about recycling as they collect data on their own family's trash production. Students analyze the data with worksheets, chart the data, and present their findings.
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
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
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...
Discovery Education
Sonar & Echolocation
A well-designed, comprehensive, and attractive slide show supports direct instruction on how sonar and echolocation work. Contained within the slides are links to interactive websites and instructions for using apps on a mobile device to...
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...
Curated OER
Weights and Measures
Students master the gathering, averaging and graphing of data. They practice conversion to metric measures. They gain fluency in the use of technology tools for math operations.
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
Beisbol! Latino Baseball Pioneers and Legends
Students explore Latin America by researching the favorite past time, baseball. In this Latin culture lesson, students identify the leaders in the Latin American baseball movement such as Felipe Alou, Jose Mendze, and the great Roberto...
Curated OER
Vampires: Fact or Fiction?
Middle schoolers predict how many vampires are in the world, based on the legend that, once bitten, each victim becomes a vampire. Extrapolating how many vampires would populate the earth in 30+ weeks, students then compare the total...
Curated OER
Fighting Obesity with Footsteps
Analyze the influence of culture, media, technology, and other factors in health through the use of pedometers and daily walking/jogging logs with this activity. The key focus is in dealing with obesity and how small steps can help...
Curated OER
Color Matters
Students create a spreadsheet to chart favorite colors, then collect data, create appropriate charts, and use percentages to describe quantities.
Other
The University of Arizona: Study Finance: Getting Started With Excel
A great tutorial that takes you through all the steps you need for mastering the Microsoft Excel spreadsheet application.
Goodwill
Gcf Global: Excel 2016
A website with 33 links plus a quiz on how to use Microsoft Excel 2016. Topics include Excel 2016 Basics, Working with Cells and Sheets, Formulas and Functions, Working with Data, Doing More with Excel, and Extras.
Department of Defense
Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions
In Module 2 Lesson 3 of this course on spreadsheets, students learn how to save time when setting up a spreadsheet by copying functions and formulas. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M2: L1: From the Ground Up: Create Basic Formulas
In Module 2 Lesson 1 of this course on spreadsheets, students begin learning how to create formulas in a spreadsheet. They learn also about the importance of remembering the correct order of operations. Includes slideshow tutorials.