Curated OER
Topic 6: Evaluating and Presenting Results
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Curated OER
Fraction Strips on Excel
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
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
Fast Food Survey Using Bar Graphs
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Curated OER
Bunny Cakes and Graphing
Third graders graph and analyze data relating to the book "Bunny Cakes" by Rosemary Wells. They listen to and discuss the book, vote on their favorite cake using Excel computer software, and discuss the results.
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
Graphing and Analyzing Biome Data
Students explore biome data. In this world geography and weather data analysis lesson, students record data about weather conditions in North Carolina, Las Vegas, and Brazil. Students convert Fahrenheit degrees to Celsius degrees and use...
Curated OER
Sales Spreadsheet
Students use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Getting to the Point
Students determine location by using the technique of triangulation. They imagine that they are out in the wilderness and have come to the top of a ridge. How can one identify the ridge on the topo map? How can one figure out where you...
Curated OER
Let's Keep Track of Grades
Students participate in a technology project. This instructional activity is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a...
Curated OER
The Human Memory
This is a well-designed, creative lesson plan to help learners learn more about the human memory. Working in pairs, students complete tasks and gather data. Excellent websites for resources are also provided.
Curated OER
Cockroach Slope
Students identify the slope of linear functions. In this slope lesson, students collect data and graph it. They write equations with no more than two variables and use technology to explain their data.
Curated OER
Swing in Time
Students examine the motion of pendulums and come to understand that the longer the string of the pendulum, the fewer the number of swings in a given time interval. They see that changing the weight on the pendulum does not have an...
Curated OER
FILLING EMPTY POCKETS: BORROWING, LOANS AND CREDIT.
Students learn that maintaining financial security takes a good math understanding. In this lesson, students apply mathematical formulas to make important financial decisions like getting the right loan to buy a house, decide which...
Curated OER
Ancient Peoples of the Middle East
This is an excellent multidisciplinary lesson designed by Scientific American. It provides three creative activities--designing a garden, studying hieroglyphics, and writing poetry--relevant to the ancient peoples of the Middle East....
Curated OER
Journalism
Learners insert raw data about Ad sales into an Excel chart. They use raw data in a letter to local businesses by using the Mail Merge program. They represent data using tables and graphs.
Curated OER
Pets Galore!
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
Curated OER
Technology - Data Collection
Learners collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Learners compute the mean, median and mode. They create...
Curated OER
Predicting Temperature: An Internet/Excel Learning Experience
Third graders use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. They keep track of the temperature in these two locations for 10 days.
Curated OER
Marvelous Math -- Colorful Fractions
Students begin the activity by discovering that a fraction is one part of a whole. In groups, they practice reducting larger fractions into small fractions and discovering they are equal. They use blocks to identify the relationship...
Curated OER
Slopey Math
Students identify the slope of a line and use it to solve real life problems. In this algebra lesson, students write linear equations in slope intercept form and make a correlation to its relation to the real world. They use the slope an...
Curated OER
Math for the Frontier
Students explore the concept of inflation. In this inflation instructional activity, students compile a list of necessities they would need to take with them if they were moving to a new state next month. Students compare their list...
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...
Curated OER
Interest Calculation and Spreadsheets
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...