Curated OER
Weights and Measures
Young scholars 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
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.
Curated OER
Vampires: Fact or Fiction?
Learners 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 predicted...
Curated OER
Area graphics for 7th graders
Students randomly select dimensions for three geometric shapes (square, right triangle and circle). From the graphs they compare and contrast the graphical results of each shape.
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
All About Me
Students practice biographical and autobiographical forms of writing: autobiography, biopoem, character traits, classmate biography.
Curated OER
Color Matters
Young scholars 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 Formulas: Simple Formulas
One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. In this lesson, we'll show you how to use cell references...
Goodwill
Gcf Global: Excel Formulas: Complex Formulas
A simple formula is a mathematical expression with one operator, such as 7+9. A complex formula has more than one mathematical operator, such as 5+2*8. When there is more than one operation in a formula, the order of operations tells...
Goodwill
Gcf Global: Excel Formulas
In this interactive tutorial, learn how to create formulas to solve real-world problems.
Goodwill
Gcf Global: Excel Formulas: Functions
A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and...
Better Lesson
Better Lesson: Rewriting Formulas
In this instructional activity, 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...
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.
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.
Science Struck
Science Struck: How to Calculate Percentage Increase
Explains and demonstrates how to calculate the percentage increase from year to year and how to calculate it using an Excel spreadsheet.
Department of Defense
Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions
In Module 2 Lesson 2 of this course on spreadsheets, students learn how to use the built-in functions in Excel so that they don't have to retype a formula each time they use it. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills
In Module 2 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about formulas, functions, and manipulating a spreadsheet. Content is stored in the Resources section. Practice...
Department of Defense
Do Dea: Spreadsheet Software: M3: L2: In the Library: Calculate With Functions
In Module 3 Lesson 2 of this course on spreadsheets, students learn about naming cells and cell ranges and how a name moves with the range it is attached to. Names can also be used in constructing absolute cell reference formulas....
Education Development Center
Tune in to Learning: Get Going With Rate
Explore the concepts of rate, distance, and speed in this interactive lesson. Discover how to use formulas to solve word problems and calculate salaries. A concise lesson with excellent examples, connections to real world experiences,...
Other
Personal: Let's Go Shopping
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
Other
Tonya Skinner Business Ed Lesson Plans: Grocery Shopping
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...
University of Illinois
University of Illinois: Quadratic Formula
This site from the University of Illinois offers an excellent simulation of the quadratic formula, where you can type in different values for a, b, and c, and then view the change in the answer for x.
Other popular searches
- Microsoft Excel Formulas
- Teaching Excel Formulas
- Excel Formulas and Functions
- Writing Excel Formulas