Curated OER
2002 U.S. National Chemistry Olympiad National Exam - Part I
As to be expected from the American Chemical Society Olympiad Examinations Task Force, this 60-question test tops the charts in terms of excellence. It consists entirely of multiple choice questions designed to assess a year's worth of...
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...
Royal Society of Chemistry
Chemistry Masterclass—Chemistry Outreach
Immerse your chemistry class in the world of organic chemistry! Science scholars isolate acetaminophen from an over-the-counter sample during an intense and interesting lab. Groups use many different separation and analysis techniques to...
Curated OER
Excel temperature Graphs
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend line to their graph.
Curated OER
World Population Activity I: Excel
Students use Excel to explore population dynamics using the Logistic equation for (S-shaped) population growth. This activity is primarily intended as an introductory tutorial on using Excel.
Teach Engineering
Understanding the Air through Data Analysis
Is there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...
Chicago Botanic Garden
GEEBITT (Global Equilibrium Energy Balance Interactive TinkerToy)
Students use the GEEBITT excel model to explore how global average temperatures are affected by changes in our atmosphere in part two of this series of seven lessons. Working in groups, they discuss, analyze graphs, and enter data to...
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,...
Curated OER
Soil Excavation
Students comprehend how percent of change and multipliers are used to determine volume for removal and replacement of soils. They calculate soil volume percent changes using data tables. They apply formulas to solve a variety of...
Curated OER
Law of Large Numbers - Hospital
Students explore concepts of probability and independent events. They develop a formula for deviation percentage.
Curated OER
Star Light...Star Bright
In this brightness of stars worksheet, students use a given formula using the temperature in Kelvins of a star to find its brightness. Students solve 4 problems using this equation.
Curated OER
Why Are Hot Things Red?
In this radiation and temperature worksheet, students use 2 methods to derive the Wein Displacement law that shows the relationship between the temperature of a body to the frequency where the Planck curve's value is at its maximum....
Curated OER
A Mathematical Model of the Sun
In this mathematical model of the sun worksheet, learners read about the way scientists use the sun's radius and mass to determine a mathematical model of the sun using the volume of a sphere, and the relationship between density, volume...
Curated OER
Sea Floor Spreading I
Students use Excel to explore the geodynamics Model equation for ocean depth around a sea-floor spreading center. They complete an introductory tutorial on Excel for students with no prior Excel experience.
Curated OER
Love Canal-A Man Made Disaster
High schoolers watch a "Waste Management" Power Point as well as a "Love Canal" PowerPoint (a link is provided for the second presentation). Students write the chemical formula for each chemical and convert the contamination to grams...
Curated OER
Using a Statistical Procedure To Search A Database For Out of the Ordinary Values
Students develop a spreadsheet containing formulas and find summaries for them. In this investigative instructional activity students choose a topic, investigate it and use MS Excel to sort data.
Curated OER
Electricity and Ohm's Law Lesson Plan
Students investigate the concept of Ohm's Law and how it is used when finding a solution to an equation. They use properties of equality in order to find the solution for the variable. Students also apply a formula to real life problems...
Curated OER
Graphing and Analysis of Water Quality Reports
Young scholars practice making graphs and interpreting them. They compare and contrast different sets of data. They use Microsoft Excel to create different types of graphs.
Curated OER
Graphing the Standard Curve
Srudents demonstrate analysis of colorimetric assay results by analyzing them using a computer graphing program and demonstrate application of standard curves by finding other areas of science that can utilize standard curves in analysis...
Curated OER
Dissolved Oxygen Lesson
Students investigate what dissolved oxygen is and why it is important to aquatic life and what factors influence levels of dissolved oxygen in a lake. They study how to use MS Excel to make charts to show trends and correlations.
Chicago Botanic Garden
Micro-GEEBITT Climate Activity
A truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...
Discovery Education
Sonar & Echolocation
A well-designed, comprehensive, and attractive slide show supports direct instruction on how sonar and echolocation work. Contained within the slides are links to interactive websites and instructions for using apps on a mobile device to...
Curated OER
Down the Drain: How Much Water Do You Use?
Participate in an Internet-based project to share information about water usage with other young scholars. Collect information about water usage and compare it to the average used by people in other parts of the world.
Curated OER
Frogs
Young scholars explore the external and internal structures of an amphibian and how frog anatomy compares to human anatomy. They collect pictures of a frog using a digital camera, create a web page, develop a PowerPoint presentation,...
Other popular searches
- Microsoft Excel Formulas
- Teaching Excel Formulas
- Excel Formulas and Functions
- Writing Excel Formulas