Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Learners improve data entry in a spreadsheet.
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious instructional activity invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which...
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.
Curated OER
Creating a Spreadsheet and Graph
Students create graphs in Excel. For 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...
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
Class Birthday Graph
Students analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.
Curated OER
Metrically Me!
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.
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...
Curated OER
Weather
Students create a spreadsheet and chart using data collected. In this weather lesson plan, students select five cities from their state, including the city they live in. Students take daily temperature readings from all five cities. ...
Curated OER
BRIDGING THE GENERATION GAP
Students create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Curated OER
Historical Population Changes in the US
High schoolers conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret...
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
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
What Goes Up Must Come Down!!
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
Curated OER
Does Humidity Affect Cloud Formation?
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Curated OER
A "Capital" Idea
Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows...
Curated OER
EXCEL It!
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Curated OER
Management of Wildlife Resources
Students investigate how wildlife management policies affect the size of large animal populations. They develop a spreadsheet that incorporates a mathematical model to predict big game herd sizes, and using worksheet data manage a bison...
Curated OER
Does Your Fitness Compute?
Fourth graders chart and analyze baseline data pertaining to improving and maintaining fitness levels. Personal trainers calculate their clients' charts and write a one-page report on the findings for the evaluation portfolio of each...
Curated OER
Heat of an Unknown Metal
Eighth graders complete labs to find the specific heat of many different types of substances, and use characteristic property to identify an unknown metal. CBL be used to determine energy lost or gained, and students complete a...
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
Amphibian Spawns
Students observe tadpoles as they gradually change into adults. In this amphibian biology instructional activity, students watch tadpoles in a tank in the classroom, keep a daily record of what they observe, and chart the growth...
Curated OER
Why Would I Owe My Soul to the Company Store?
Sixth graders listen to "Sixteen Tons" by Tennessee Ernie Ford and discuss what it means to owe one's soul to a store. In this mathematics lesson, 6th graders determine what a miner's income was minus his expenses graphing findings in a...
Curated OER
Jelly Bean Statistics
Students develop a process of packing jelly beans efficiently. In this math lesson plan, students explain the quality control methods they designed. They construct histograms using Excel spreadsheet.