Curated OER
Graphing With a Spreadsheet
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
Curated OER
Three Squirrels and a Pile of Nuts
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Curated OER
Simple Bar Graphs Using Excel
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Curated OER
Checking Test Comparability/Scattergrams
Students construct a scattergram graph. In this statistics lesson plan, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.
Curated OER
Measuring and Observing Weather Phenomena
In this weather worksheet, students take the temperature and record data over a period of time of 1 month. Students then make a spreadsheet of their data and include variables that contribute to the weather.
Curated OER
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson plan, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to...
Curated OER
Spreadsheet Moon Comparison
Students use the Internet to research characteristics of moons for other planets They use a spreadsheet to organize information for all of the moons researched. They use the spreadsheet data to make statements showing comparisons and...
Curated OER
Volcano Spreadsheet and Graph
Fourth graders find the height of selected volcanoes and convert their measurements to feet. Students interpret information from a graph. They also write math questions that require the use of a class created graph. Students use a...
Student Handouts
Chapter and Unit Grades in Microsoft Excel
Keep track of grades with an Excel spreadsheet that is already formatted to average scores. The assignments are all listed as chapters, but could easily be changed to reflect your assignments. Included in the spreadsheet is sample...
Curated OER
The Viewing Tube
Looking for an excellent instructional activity that incorporates math, science, and technology? Groups of three learners use a viewing tube to perform an experiment, and discover how to organize their data into an Excel...
Curated OER
Build Your Dream Bedroom
Designers measure their own rooms and produce a scale drawing. They use the Internet to visit sites to find the costs of purchasing new carpet, paint, or anything else they would like to add to their room. Using a $1500 budget, they will...
Curated OER
Historical Pollution in the Hudson: Part 2
Ninth graders practice how to format and enter data into an Excel spreadsheet, make a graph, and interpret graphed data. They recognize how the pollution in the Hudson River has changed over time, and explain the consequences of these...
Curated OER
Atomic Emission Spectra and the Bohr Model of the Atom
Students investigate the wavelengths of spectra lines for common atoms. In this atomic emission spectra lesson plan, students use a transformer and diffraction grating to observe the emission spectra of various atoms. They find the...
Google
The Law of Large Numbers and Probability
Learners investigate why theoretical probability doesn't always match reality. The activity involves using Python 2.7 (or Sage) to set up a Bernoulli Trial. It also involves setting up a spreadsheet to simulate the Birthday Paradox....
Student Handouts
Tracking and Grading Student Class Participation
You will find a variety of uses and applications for this simple spreadsheet, which includes a column for student names and several following columns to incorporate grades, track class participation, etc.
Vertex42
Yearly Schedule of Events
Keep track of events, holidays, and deadlines on one colorful and easy-to-edit calendar. The page includes two main columns, one for a color-coded calendar for each month and one for typing in events. Instructions are included on the...
Virginia Department of Education
The Rate of Motion
How much time does it take to jump over three balloons? Pupils calculate the speed of tasks that require different motions. They determine motions for tasks such as walking, skipping, hopping, and jumping before creating a...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...
Yummy Math
Parametric Equations and a Heart
Trigonometry, art, and Valentine's Day come together in a creative activity about parametric equations. Learners calculate several equations before graphing them either by hand, on a graphic calculator, or Excel spreadsheet to curve...
Bowland
Speed Cameras
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Curated OER
Lesson Plan Outline for Rainbow Science
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
NOAA
Biological Oceanographic Investigations – Signals from the Deep
The Deepwater Horizon oil spill directly impacted an area of the Gulf of Mexico the size of Oklahoma. A marine biology lesson looks at the impact of an oil spill on the deeper parts of the ocean. Scholars download actual data collected...
Kenan Fellows
Applying Linear Regression to Marathon Data
It's not a sprint, it's a marathon! Statistic concepts take time to develop and understand. A guided activity provides an opportunity for individuals to practice their linear regression techniques in spreadsheet software. The activity...
Radford University
Fibonacci is All Around
One ratio to rule them all. Young mathematicians investigate the Fibonacci sequence and the Golden Ratio. To begin the first lesson, they use a spreadsheet to see how the Fibonacci sequence gives the Golden Ratio. The second lesson...
Other popular searches
- Spreadsheets
- Excel Spreadsheets
- Budget Spreadsheet
- Favorite Foods Spreadsheet
- Microsoft Excel Spreadsheets
- Candy Wrapper Spreadsheet
- Basic Spreadsheet Skills
- Spreadsheet Lesson Plans
- Meteorology and Spreadsheets
- Using Excel Spreadsheets
- Amusement Park Spreadsheet
- Creating a Spreadsheet