Curated OER
Let's Get Linear
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
Open Oregon Educational Resources
Beginning Excel
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
Council for Economic Education
Using an Excel Checkbook
High school is the time that many scholars get their first jobs. Help young entrepreneurs apply economic principles to crucial skills for their new jobs and for functioning in society in general. They use Excel to balance a checkbook by...
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...
Teach Engineering
Searching for Bigfoot and Others Like Him
Individuals create a GIS data layer in Google Earth that displays information about where one might find seven different cryptids. The class members research to find data on cryptid sightings they can include in their data layer.
Teach Engineering
Using Hooke's Law to Understand Materials
Provide a Hooke for a lesson on elasticity with an activity that has groups investigate a set of springs. They use a set procedure to collect data to calculate the spring constant for each spring using Hooke's Law. The groups predict the...
Microsoft
Microsoft Computer Applications
From creating and editing workbooks in Microsoft Excel to designing presentations using Microsoft PowerPoint and documents in Microsoft Word, this is your one-stop, must-have resource for lessons on Microsoft Office (2010).
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...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology instructional activity; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the...
Curated OER
The Viewing Tube
Looking for an excellent lesson that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet. This is a very...
Curated OER
Conversation Heart Graphing
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Curated OER
Data Analysis and Probability: Graphing Candy with Excel
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...
Curated OER
Adding and Subtracting Decimals With Excel
What a great way to have pupils apply classroom learning to real-world skills! They complete problems involving the addition and subtraction of decimals related to banking-type questions, and then use a spreadsheet to display their results.
Curated OER
Students Favorites
Students complete activities using a frequency table and construct a pie graph for the data. In this frequency table lesson, students complete a survey to find data for a frequency table. Students use the given link to make a pie graph...
Curated OER
Presenting Painless Breast Cancer Detection!
Students depict a tumor inside a healthy body using a graph in Microsoft Excel. in this breast cancer lesson plan, students also design a brochure that advertises a new form of painless breast cancer treatment.
Curated OER
Counting
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Curated OER
What's your favorite pi?
Sixth graders toss popcorn kernels at a 12? circle inscribed in a 12? square. By counting the number of popcorn kernels that land inside the circle and inside the square the students calculate estimates for the value of pi.
Curated OER
Chart Challenge: Behavior Management
Students develop a behavior management plan using Excel. They use the computer to develop a behavior chart. Students record their behavior on a daily basis using the chart they developed using Excel.
Curated OER
How Big Is Your Head?
Learners explore measurement by measuring classmates' heads. They record their measurements and they put the measurements in order from smallest to largest. Students figure the mean, median, mode, maximum, minimum, and range of their...
Curated OER
kind of Bean
Third graders sort different types of beans and collect the data. They create a data table, put the information on the data table and then graph their results. They answer follow-up questions.
Curated OER
Excel
For this technology worksheet, students are taught how to create documents using Excel. They follow the directions on a handout to help them create documents. They print their final work and submit it.
Curated OER
Data Lesson Vital Information
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.
Curated OER
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
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...