Unit Plan
Radford University

Fibonacci is All Around

For Teachers 9th - 12th Standards
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...
Unit Plan
Radford University

How Is Your Gender Represented?

For Teachers 9th - 12th Standards
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...
Unit Plan
Radford University

Real World Data

For Teachers 9th - 12th Standards
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...
Unit Plan
Radford University

Being Green – Minimizing the Surface Area of a Soda Can

For Teachers 9th - 12th Standards
Save the world by designing a new soda can! Learners first measure the dimensions of a typical soda can and calculate its surface area and volume. They then use spreadsheet software to minimize the surface area for the volume, thus...
Unit Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Students integrate language arts with math applications. They write letters to town officials and local businesses asking for favorite dessert recipes. They then tabulate their responses in a spreadsheet and turn their survey results...
Unit Plan
We are Teachers

What Goes Up Must Come Down

For Teachers 9th - 12th Standards
From understanding stock market performance and return on investment to identifying the costs and benefits of credit and avoiding debt problems, this is an absolute must-have resource for financial planning and literacy.
Unit Plan
Intel

Composting: Why Bother?

For Teachers 8th - 10th Standards
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...
Unit Plan
University of Missouri

Money Math

For Teachers 5th - 8th Standards
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...
Unit Plan
1
1
Curated OER

Build Your Dream Science Lab

For Teachers 6th - 8th Standards
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L4: Work With Me! Collaboration Options

For Students 9th - 10th
In Module 5 Lesson 4 of this course on spreadsheets, students will learn how to collaborate on a spreadsheet document while working from different locations. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: M1: L4: Starting Here, Starting Now! Beginning a Spreadsheet

For Students 9th - 10th
In Module 1 Lesson 4 of this course on spreadsheets, students create their first spreadsheet using Microsoft Excel. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software Applications: M2: L4: Manipulate Data

For Students 9th - 10th
In Module 2 Lesson 4 of this course on spreadsheets, students learn how to alter the information in a spreadsheet by manipulating it and formatting. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L1: From the Ground Up: Create Basic Formulas

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 4 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about building charts, using conditional formatting, and enhancing their spreadsheet by inserting images, text, and...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M6: L4: Show Me Your Skills: Practice Skills

For Students 9th - 10th
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L4: And This! Inserting Objects and Content

For Students 9th - 10th
In Module 4 Lesson 4 of this course on spreadsheets, students learn how to insert text, graphics, and charts into a spreadsheet. They will learn how to import and export data and images between different types of documents. Includes a...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L3: Customization: Modifying a Worksheet

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 5 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about working with large spreadsheets, using advanced functions to analyze data, working on more than one workbook...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M3: L3: Can You Draw It? Working With Shapes

For Students 9th - 10th
In Module 3 Lesson 3 of this course on spreadsheets, students learn how to insert shapes into a spreadsheet and enhance them by resizing, rotating, changing line width, adding color and text, etc. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software Applications: M4: L1: Chart It! Working With Charts

For Students 9th - 10th
In Module 4 Lesson 1 of this course on spreadsheets, students learn how to build a chart from their spreadsheet data so that it is easier to interpret. Includes a glossary and slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M1: L2: Ethical and Efficient Use of Computers

For Students 9th - 10th
In Module 1 Lesson 2 of this course, students are introduced to issues related to copyright, public domain, and licensing agreements. They will also learn about industry certification for this course on spreadsheet applications.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M3: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 3 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about adding shapes and graphics to spreadsheets, using drawing tools to format them, using the autosum function,...

Other popular searches