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
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...
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....
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...
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...
Curated OER
Discovering Pi
Sixth graders measure circumference and diameter to the nearest eighth of an inch, record measurements on a spreadsheet, and use the internet to complete a "scavenger hunt" of facts concerning pi.
Curated OER
Graphing Pendulum Results
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Curated OER
Excel Lesson
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Curated OER
Buying a Car
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
Curated OER
Sweet Data
Students input data about the colors of their serving of M&M candies onto a spreadsheet. They create charts and graphs based on this information.
Curated OER
Integers in the Weather
Middle schoolers engage in a clever lesson that combines meteorology with mathematical thinking. They use integers in relation to high and low temperatures that they record. They use a spreadsheet of weather data, a computer, and gain...
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