Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
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...
Howard Hughes Medical Institute
Measuring Biodiversity in Gorongosa
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
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,...
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
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...
Howard Hughes Medical Institute
Gorongosa: Scientific Inquiry and Data Analysis
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...
Teach Engineering
Energy Perspectives
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
Education Development Center
Interpreting Statistical Measures—Class Scores
Explore the effect of outliers through an analysis of mean, median, and standard deviation. Your classes examine and compare these measures for two groups. They must make sense of a group that has a higher mean but lower median compared...
Howard Hughes Medical Institute
Tracking Genetically Modified Mosquitoes
What's that buzzing in your ear? An insightful lesson about genetically modified mosquitoes! Partnered pupils explore the creation, release, and monitoring of mosquitoes designed to reduce the mosquito population. After watching a video,...
Howard Hughes Medical Institute
Scientific Inquiry Using WildCam Gorongosa
How do scientists determine what questions to ask to meet their research goals? Help your class develop an inquiry mindset with a lesson based on studies in the Gorongosa National Park. Partners create their own research questions by...
English Banana
Job Advertisements
In this working with a partner learning exercise, students observe four job advertisements from a newspaper with missing parts in each ad and communicate verbally to discover the missing sections, and fill in the blanks. Students write...
Curated OER
Help the Trick-or-Treaters Find the Haunted House
In this Halloween maze worksheet, students help a group of trick-or-treaters find the most efficient route through a maze to get to the haunted house.
Georgia State University
Georgia State University: Creating Spreadsheets Using Ms Excel
This Georgia State University site gives in outline form the basic principles of using spreadsheet software. At the end of the outlines, specific uses for spreadsheets in recordkeeping are suggested.
BBC
Bbc Bitesize: Spreadsheets
Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns.
National Council of Teachers of Mathematics
The Math Forum: Algebraic Problem Solving Using Spreadsheets
A unit is presented on instructing students how to build and use spreadsheets for algebraic problem solving. Easy-to-follow steps are provided along with problems for students to practice.
Texas Instruments
Texas Instruments: Spreadsheets Anyone
This activity is meant to give students a quick review on how to navigate their cursors in Activity Center.
Other
Anguilla Library: Lessons for Achieving Computer Literacy
This site presents lessons on software usage by members of a computer club. Lessons include Basic Dos Systems, Windows, Spreadsheets, Basic Programming, and more.
TeachEngineering
Teach Engineering: Energy Perspectives
Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students...
Texas Instruments
Texas Instruments: Social Security Issues
In this activity, you will look at the relationship between the age at which you start drawing social security and the amount drawn. Both graphs and spreadsheets will be used.
Science Education Resource Center at Carleton College
Serc: Average Rates of Change and Trend Lines
In this Spreadsheets Across the Curriculum activity, students calculate the average rate of change and graph a scatter plot of status high school dropout rate for 1975-2002. The module combines interpretation of rate of change in the...
Other
Fast Food Fun
Use your knowledge of spreadsheets to analyze the calories and fat content of fast food choices. This project gives links to a USDA site and a final report format. A sample spreadsheet and grading rubric is also provided.
Other
Making a Word Find With Microsoft Excel
Teachers and students can create a word find using Excel. It will help them learn to manipulate columns and rows and format and lock cells. This plan is based upon 10 word or phrases on any topic.
![Wired Math: Organizing Data Grade 7 [Pdf] Activity](https://d15y2dacu3jp90.cloudfront.net/images/attachment_defaults/resource/large/FPO-knovation.png "Wired Math: Organizing Data Grade 7 [Pdf] Activity")
University of Waterloo (Canada)
Wired Math: Organizing Data Grade 7 [Pdf]
A collection of worksheets that focus on data analysis and organizing data. Includes detailed examples, colorful visuals, and a link to a related game. Acrobat Reader required.
Other
Current Electoral Vote Predictor
This website is dedicated to tracking the electoral vote by examining the state-by-state polls. The data appears as a map, spreadsheets and table. As new state polls are released, the maps, spreadsheets, and tables will be updated.
Other popular searches
- Excel Spreadsheets
- Microsoft Excel Spreadsheets
- Meteorology and Spreadsheets
- Using Excel Spreadsheets
- Math Using Spreadsheets
- Heart Rate and Spreadsheets
- Creating Spreadsheets
- Math Spreadsheets
- Using Spreadsheets
- Spreadsheets Charts
- Excel Spreadsheets Graph
- Excel Spreadsheets Planets