Hi, what do you want to do?
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
Using Electronic Manipulatives in Multiplication
Factor polynomials using electronic manipulatives. Your class will create a spreadsheet in excel and use it to multiply and perform basic operations and solve problems correctly. They create a visual to go along with each multiplication...
Curated OER
Credit Cards: The Good, the Bad, and the ugly
Students study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Curated OER
Excel temperature Graphs
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson plan, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend line to...
Curated OER
Building Arrays Using Excel Spreadsheets
Learners create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Curated OER
It's Your Life - Safe or Sorry/Safety Issues
Students examine and chart data about safety hazards and unsafe situations. For this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
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...
Curated OER
Cross Cultural Transportation and Resources Exchange
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
Polar Trec
Ozone Data Comparison over the South Pole
Did you know the hole in the ozone is seasonal and filled by January every year? The lesson uses scientific measurements of the ozone over the South Pole to understand patterns. Scholars learn that the hole grew bigger annually before...
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...
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
Fitness plan: number 3
Students monitor their fitness levels for six weeks of their P.E. course through the use of an Excel spreadsheet. They also research the obesity epidemic among youth in the U.S. today, presenting their findings to the class. This lesson...
Curated OER
Using Excel to Draw a Best Fit Line
Students create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Students print graphs without trend lines and manually draw...
Curated OER
Making a Spreadsheet
Young scholars explore spreadsheet software. In this personal finance and computer technology lesson plan, students develop a vacation spreadsheet on the computer. Young scholars represent hotel, food, transportation, and...
Curated OER
Where Will You Go?
Fifth graders participate in a WebQuest in which they calculate mileage and cost per person for a trip to an amusement park. They explore various websites, and produce an Excel spreadsheet.
Curated OER
Graph Frenzy!!
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Curated OER
Appalachia: Physical Fitness
Students plan a family fitness outing. In this physical education lesson, students will research possible physical activities which might be completed by a family during a daily-long outing in the Appalachian area. Students will...
Curated OER
Water Chestnut Graphing Activity
Students are taught how to format and enter data into an Excel spreadsheet. They make a graph and interpret graphed data. Students discuss possible impacts of water chestnut invasion. They graph data on water chestnut. Students report...
Curated OER
Zebra Mussel Population Simulation
High schoolers are taught how to format and enter data into an Excel spreadsheet. They make a graph, and interpret graphed data. Students discuss the possible impacts of zebra mussels on the Hudson river. They graph zebra mussel data.
Curated OER
Peopling the New World -- An Archaeological Exercise in Excel
Middle schoolers examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in...
Curated OER
Back-To-School Shopping
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
Curated OER
Daily Time Ratios
Students track and record how much time they spend on each activity. In this spreadsheet lesson, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day. They...
Curated OER
Using Averages to Create Graphs Through Excel
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...