Refine Your Results

Content Curators

Grades

Subjects

Resource Types

Standards

251 reviewed resources for spreadsheet using formulas

Videos (Over 2 Million Educational Videos Available)
Population Genetics Video
2:45
Population Genetics
Defining Gravity Video
3:11
Defining Gravity
How Computers Work: What Makes a Computer, a Computer? Video
5:10
How Computers Work: What Makes a Computer,...
Other Resource Types ( 251 )
3:38
Lesson Planet

Excel 2016: Intro to Formulas

For Students 9th - Higher Ed Standards
How do techies use formulas in an Excel spreadsheet to calculate numerical data?  A short instructional video teaches scholars about cell references, mathematical operators, and models how to create, copy, and edit formulas. 
Lesson Planet

Spreadsheet Tutorial 1: Formulae, Functions, and Averages

For Students 9th - 12th
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...
Lesson Planet

Broken Spreadsheet II

For Students 11th - 12th Standards
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...
4:59
Lesson Planet

How to use Excel to Calculate Confidence Interval

For Students 11th - 12th Standards
Utilize Excel software to analyze a set of data by making statistical calculations. The instructor shows how to find the standard deviation, mean, minimum, maximum, margin of error, confidence intervals, and range using Excel commands....
Lesson Planet

Broken Spreadsheet I

For Students 8th - 11th Standards
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...
5:10
Lesson Planet

Excel 2016: Creating More Complex Formulas

For Students 9th - Higher Ed Standards
Please Excuse My Dear Aunt Sally! The 13th of 27 instructional videos from the Microsoft Excel 2016 set covers the order of operations. First, scholars review how to use the order of operations to solve math equations. Next, they see how...
Lesson Planet

Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

For Students 9th - 12th
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,...
Lesson Planet

Beginning Excel

For Students 9th - Higher Ed Standards
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,...
5:24
Lesson Planet

Excel 2016: Relative and Absolute Cell References

For Students 9th - Higher Ed Standards
What are the two main types of cell references in Excel? Scholars discover the answer through a short instructional video that models how to create and copy formulas using relative and absolute references. Additionally, users explore how...
Lesson Planet

The Remainder Theorem Using TI-Nspire CAS

For Teachers 9th - 12th Standards
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...
Lesson Planet

Using a Statistical Procedure To Search A Database For Out of the Ordinary Values

For Teachers 7th - 10th
Students develop a spreadsheet containing formulas and find summaries for them.  For this investigative lesson students choose a topic, investigate it and use MS Excel to sort data. 
5:15
Lesson Planet

Excel 2016: Functions

For Students 9th - Higher Ed Standards
When working with numerical data in a Microsoft Excel spreadsheet, which is better: formulas or functions? Pupils discover the answer through a short, instructional video.  First, scholars learn about the parts of a function and discover...
4:18
Lesson Planet

Solving Real-Life Problems in Excel

For Students 9th - Higher Ed Standards
Jane has 20 bananas and gives 16 away; how many are left? Microsoft Excel can help with that! A video provides a brief overview of the software program. Viewers learn how to use planning, basic math, and knowledge to solve real-life...
Lesson Planet

Using Computer for Statistical Analysis

For Teachers 9th - 12th
Students use the computer and S'COOL data for statistical analysis.
Lesson Planet

Formula for Fitness

For Teachers 7th - 10th
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...
Lesson Planet

Spreadsheet formulas

For Teachers 6th - 8th
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...
2 In 2 Collections
EngageNY

More on Modeling Relationships with a Line

For Teachers 9th - 10th Standards
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...
Lesson Planet

Boards II

For Students 7th - 9th Standards
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...
Lesson Planet

Boards I

For Students 7th - 9th Standards
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...
Lesson Planet

Using Electronic Manipulatives in Multiplication

For Teachers 9th - 11th
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...
Lesson Planet

How Big Can a Bee Be?

For Teachers 7th - 10th Standards
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...
Lesson Planet

Adding and Subtracting Decimals With Excel

For Teachers 5th
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.
Lesson Planet

Using a Spreadsheet to Solve Gas Law Problems

For Teachers 9th - 12th
High schoolers use a spreadsheet to solve gas law problems. In this gas laws lesson plan, students use the Express Calc program to load a spreadsheet for the gas law problems. High schoolers compute volume, temperature, or pressure...
Lesson Planet

Using Tables to Solve Linear Functions

For Teachers 9th - 12th Standards
Oh that intercept! Budding algebra masters solve linear equations from standard to intercept form. They identify the slope and y-intercept to help graph the lines, an then create coordinate pairs using a table of values. Great TI tips...