Activity
Howard Hughes Medical Institute

Measuring Biodiversity in Gorongosa

For Teachers 9th - 12th
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Lesson Plan
Curated OER

Solving Polynomial Equations

For Teachers 9th - 12th
High schoolers demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Lesson Plan
Curated OER

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Lesson Plan
Curated OER

Using Calculators And Spreadsheets

For Teachers Higher Ed
Students discuss the advantages of using calculators and spreadsheets in balancing checkbooks. They also identify the pros and cons of using these tools in adult education classrooms.
Lesson Plan
Curated OER

Graphing Favorite Holidays

For Teachers 1st - 3rd
Young scholars create spreadsheets and bar graphs based on results of survey of favorite holidays.
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

Dino-Myte Spreadsheet

For Teachers 4th - 8th
Do your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Lesson Plan
Curated OER

Working with Spreadsheets

For Teachers 4th - 12th
Learners integrate physical education and technology. They give their best during jogging time and keep tally of the number of laps they run during their jogging time each day. They record this on a tally sheet and enter a formula which...
Activity
Howard Hughes Medical Institute

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,...
Lab Resource
Pingry School

The Water Lab – Spreadsheet Simulation

For Students 9th - 12th Standards
More than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
1
1
Curated OER

The Solstices

For Teachers 6th - 9th
Compare surface temperatures when the solstice occurs in the different hemispheres. Young scientists draw conclusions from their investigation of data collected using spreadsheets and a globe.
Lesson Plan
Council for Economic Education

Loan Amortization - Mortgage

For Teachers 9th - 12th Standards
When you buy a home for $100,000, you pay $100,000—right?  On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Printables
Student Handouts

Blank Monthly Calendar

For Students Pre-K - 12th
Don't have time to fiddle with spreadsheets or tables? Here's a printable calendar that you can quickly print and use for any month of the year!
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean

For Students 9th - 12th
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...
Activity
Howard Hughes Medical Institute

Spreadsheet Tutorial 5: Histogram

For Students 9th - 12th
A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...
Activity
Howard Hughes Medical Institute

Gorongosa: Scientific Inquiry and Data Analysis

For Teachers 9th - 12th Standards
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Assessment
Concord Consortium

Boards IV

For Students 7th - 9th Standards
Build a connection between algebraic sequences and spreadsheets. Learners examine a specific folding pattern and convert the pattern into a spreadsheet. The goal of the spreadsheet is to produce a sequence of a specific pattern modeled...
Lesson Plan
Texas Education Agency (TEA)

Advanced Technical Skills in Business

For Teachers 11th - 12th Standards
Scholars put their technical skills to the test as they practice writing a business letter, creating charts and spreadsheets, and designing a flyer. Additionally, pupils create a PowerPoint presentation about a professional topic of...
Lesson Plan
Curated OER

Introduction to Limits

For Teachers 9th - 12th
High schoolers practice using graphing calculators and spreadsheets as they explore numeric limits using sequences and functions. They complete a sequencing worksheet, and determine which sequence corresponds to story a story called...
Lesson Plan
Curated OER

Penny Pushing

For Teachers 5th
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
Lesson Plan
Curated OER

Flavorful Spreadsheets

For Teachers 4th - 8th
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
Lesson Plan
Curated OER

Introduction to Spreadsheets

For Teachers 6th
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...

Other popular searches