The first STEM lesson in a group of 10 explores composting. After discussing how to make a better tomorrow, classes are challenged to track garbage in their communities, visit a local waste management facility, and conduct a survey...

Does the media shape people's views on gender? Scholars use data on gender portrayal in magazines to explore the idea. They use a spreadsheet program to create bar graphs and perform a chi-square test. They also use provided data to...

Would your ideal science lab be filled with bubbling beakers and zapping Tesla coils? Or would it contain state-of-the-art computer technology and data analysis? Dream big with an innovative lesson that connects math and language...

One ratio to rule them all. Young mathematicians investigate the Fibonacci sequence and the Golden Ratio. To begin the first lesson, they use a spreadsheet to see how the Fibonacci sequence gives the Golden Ratio. The second lesson...

Make math class feel more real by using real-world data. Scholars research or collect data on several different topics, such as nutrition, the motion of moving objects, cooling curves, and daylight hours. They create scatter plots using...

Young mathematicians put their skills to the test in the real world during this four-lesson consumer math unit. Whether they are learning how compound interest can make them millionaires, calculating the cost of remodeling...

In Module 1 Lesson 4 of this course on spreadsheets, students create their first spreadsheet using Microsoft Excel. Includes slideshow tutorials.

In Module 6 Lesson 4 of this course on spreadsheets, which is the final lesson of the course, students review what they have learned in the previous three lessons about using templates, using data validation tools, and importing data...

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...

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.

In Module 5 Lesson 3 of this course on spreadsheets, students learn how to work with two or more spreadsheet workbooks at the same time where they have related data and how to create different customized views. Includes slideshow tutorials.

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...

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...