Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; 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
Excel, Word, and Basketball
Wow, this lesson packs a punch. Pupils interview basketball players, write about a game, and use Excel to organize statistics related to the players and the points scored. Afterward, they create posters, presentations, and much more.
Curated OER
Excel Lesson
Young scholars investigate Microsoft excel. In this technology lesson, students create formulas using excel and apply these formulas to solve relative, absolute and mixed reference cells. They perform immediate and delayed calculations.
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Young scholars, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
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...
West Contra Costa Unified School District
Correlation and Line of Best Fit
Computers are useful for more than just surfing the Internet. Pupils first investigate scatter plots and estimate correlation coefficients. Next, they use Microsoft Excel to create scatter plots and determine correlation coefficients and...
Curated OER
Beginning Graphs in MS Excel
Students practice creating graphs in Microsoft Excel. In this technology lesson, students conduct a random survey and collect data. Students use the Microsoft Excel program to create a bar graph of the data.
Curated OER
How to Graph in Excel
Fourth graders construct data graphs on the Microsoft Excel program. In this statistics lesson, 4th graders formulate questions and collect data. Students represent their results by using Excel.
Curated OER
Excel for Beginners
For this Excel lesson, students set a formula to check their homework. Students also use clipart, work in groups, and learn to use the tools in the drop-down list.
Curated OER
The Big Hand Challenge
Students utilize a computer spreadsheet to record and analyze data. In this problem solving instructional activity, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Curated OER
Fish and Clips
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
Curated OER
Get My Point!
Here is one of the better lessons I've come across on how to teach fractions and decimals. This lesson does a great job of showing how these two mathematical representations of numbers are interrelated. Some excellent websites, printable...
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
Ancient Peoples of the Middle East
This is an excellent multidisciplinary lesson plan 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...
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
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
Data! Data! Graph that Data!
Fifth graders create data graphs using Microsoft Excel. In this data collection lesson, 5th graders create and conduct a survey, then use Excel to organize and graph their 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
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
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to terminology...
Curated OER
Exploring Linear Equations And Scatter Plots - Chapter 5 Review
Students complete rolling stocks experiment, and collect and enter data on the computer. They enter data on graphing calculators, complete scatter plot by hand with line of best fit, and discuss different graphing methods.
Curated OER
Sales Spreadsheet
Learners 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
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
Publisher Brochures
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing lesson, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use text boxes, fonts...