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