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...
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...
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
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...
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...
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
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,...
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,...
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.
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.
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.
National Council of Teachers of Mathematics
The Math Forum: How to Make a Bar Graph
Site contains specific directions for making bar graphs using a Claris Works spreadsheet file.
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.
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.