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...
Concord Consortium
Broken Spreadsheet II
Work in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...
Curated OER
Spreadsheet formulas
Middle schoolers, 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...
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...
Concord Consortium
Broken Spreadsheet I
There is power in spreadsheet formulas and learners use this power to model quadratic data. Given a scatterplot of a parabola, pupils create formulas in a spreadsheet to populate the data. The formulas they use lead to an understanding...
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
The Remainder Theorem Using TI-Nspire CAS
Investigate the Remainder Theorem in this algebra lesson. Explore the relationship between the remainders of polynomial division and the function. Each of the four problems gets progressively more complicated. This might be a great...
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
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
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
Curated OER
Creating a Spreadsheet and Graph
Students create graphs in Excel. In this spreadsheet lesson plan, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data. The directions to create the graph...
Concord Consortium
Boards II
Build spreadsheet skills while investigating decimal multiplication. An open-ended task asks learners to edit a spreadsheet to create a multiplication table for decimals. Provided with a specific interval, pupils create formulas that...
Concord Consortium
Boards I
Learners create patterns in a table to mimic the function of an electronic spreadsheet. The result is a table that creates an addition table for decimals in intervals of one-tenth. While creating the pattern, pupils must thoroughly...
Curated OER
Math Operations/Formulas
Pupils 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
Down the Drain: How Much Water Do You Use?
Participate in an Internet-based project to share information about water usage with other students. Collect information about water usage and compare it to the average used by people in other parts of the world.
Alabama Learning Exchange
How Big Can a Bee Be?
Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...
EngageNY
More on Modeling Relationships with a Line
How do you create a residual plot? Work as a class and in small groups through the activity in order to learn how to build a residual plot. The activity builds upon previous learning on calculating residuals and serves as a precursor to...
Curated OER
Using Computer for Statistical Analysis
Students use the computer and S'COOL data for statistical analysis.
Curated OER
Formula for Fitness
Many youngsters don't understand that fitness is a life-long endeavor, and that it really pays off to be healthy. Use a spreadsheet to document progress in a fitness plan to see if there really in a benefit to running and exercise. Adapt...
Curated OER
Experiment-Using Formulas and Spreadsheets
In this Algebra I activity, 9th graders track information relating to a sporting event and create a spreadsheet and appropriate formulas used to track data. The one page activity contains the assignment and instructions. Answers are...
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
Creating a "Concrete" Spreadsheet
Learners create a spreadsheet that calculate the amount of concrete needed to pour various concrete forms.
Curated OER
Using a Statistical Procedure To Search A Database For Out of the Ordinary Values
Students develop a spreadsheet containing formulas and find summaries for them. In this investigative lesson students choose a topic, investigate it and use MS Excel to sort data.
Curated OER
M&M Graphing
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.