Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson plan; 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 groundhog...
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
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
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Learners improve data entry in a spreadsheet.
Curated OER
Creating a Spreadsheet and Graph
Students create graphs in Excel. In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data. The directions to create the graph are...
Federal Reserve Bank
Creating a Budget
Learning to create and maintain a budget is an important life skill. Guide individuals in the discovery of their spending habits and how to track them. They then use what they learned to create a budget and make decisions on where they...
Curated OER
Using Excel To Teach Probability And Graphing
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. Students complete...
Curated OER
USING MICROSOFT, POWERPOINT, WORD, EXCEL AND THE INTERNET TO CREATE A PRESENTATION
Explore the basic PowerPoint commands and options. They research information (including the WWW) related to an approved topic for presentation development. They create a presentation defined by specific criteria. They document research...
Curated OER
Graphing Using Excel
Fifth graders complete a series of graphs by gathering information and using Excel to graph the information. In this graphing lesson, 5th graders graph favorite desserts of the class. Student put their results into the computer and then...
Curated OER
Using Excel to Reference and Graph Live Data from a Web Site
Students collect live buoy data about water temperatures in the Gulf of Mexico from the Internet and work individually to organize their data and create a line graph using Excel Spreadsheet. Students analyze their data and examine any...
Curated OER
Counting Coins
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
Curated OER
How Credit Card Interest Works
Students experiment with an Excel spreadsheet model that demonstrates the effects of interest on payments. They calculate actual costs, interest paid, and time necessary to pay off credit purchases and draw conclusions about the...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis lesson students use an Excel spreadsheet to map their data.
Curated OER
"Living in the Limelight The Universal Dream"
Students, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses about...
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 activity encourages...
Curated OER
State Economy Chart
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Statistics Education Web
Are Female Hurricanes Deadlier than Male Hurricanes?
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
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...
Bonneville
Making Observations and Recording Data for Solar Powered Water Pumping
Get pumped about an activity with water pumps. The fifth of seven installments in the Understanding Science and Engineering unit has pupils learn how to make observations, record data, and create data displays. Each group measures the...
Curated OER
Which Amusement Park Would You Choose?
Students analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on their...
Curated OER
It's Your Life - Safe or Sorry/Safety Issues
Students examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
Curated OER
Lemonade Business
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
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.