Curated OER
Graphing on the Computer
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
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 plan 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
Students 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
Students, 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. ...
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...
Curated OER
Beginning Graphs in MS Excel
Young scholars practice creating graphs in Microsoft Excel. In this technology lesson plan, students conduct a random survey and collect data. Young scholars 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
In 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
Tessellations in Excel
Students complete an Excel project on tessellations. In this technology and math lesson, students discuss tessellations and their occurrences in nature. Students use the Excel computer program to create tessellations.
Teach Engineering
Applying Statistics to Nano-Circuit Dimensions in Fabrication
Do flexible circuits change dimensions during fabrication? Groups use GeoGebra software to measure the length of pictures of flexible nano-circuits. To determine if the circuits change dimensions, future engineers use Microsoft...
Curated OER
Creating Circle Graphs with Microsoft Excel
Students create graphs of circles. In this geometry lesson, students use Microsoft Excel to create graphs. They construct the graphs using paper and pencil as well as the computer.
Curated OER
Counting
First graders explore collecting data. They collect data using a data collection sheet and enter the data into Excel. Students create graphs using Excel. They share their graphs with the class.
Curated OER
Pet Count Excel Graphing
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
Curated OER
The Big Hand Challenge
Students utilize a computer spreadsheet to record and analyze data. In this problem solving lesson, students compare their hand size to that of the principal. Students understand standard and nonstandard measurement.
Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Curated OER
Graph Lesson
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
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
Tracking Your Favorite Web Sites
Ninth graders track the hit count on their favorite web sites. In this Algebra I lesson, 9th graders record the number of hits on their favorite web site for twenty days. Students explore the data to determine if the relation...
Curated OER
Using Excel to Draw a Best Fit Line
Middle schoolers 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. Middle schoolers print graphs without trend lines and...
Curated OER
Tasty Tech Activity With Excel
Students are introduce to basic Excel skills, rank their opinions of menu items from fast food restaurants, add their answers to the spreadsheet, and then create a simple graph of the results.
Curated OER
Building Arrays Using Excel Spreadsheets
Students create arrays using Microsoft Excel. In this technology-based math instructional activity, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
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.