+
Lesson Plan
Texas Education Agency (TEA)

Advanced Technical Skills in Business

For Teachers 11th - 12th Standards
Scholars put their technical skills to the test as they practice writing a business letter, creating charts and spreadsheets, and designing a flyer. Additionally, pupils create a PowerPoint presentation about a professional topic of...
+
Lesson Plan
Curated OER

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
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.
+
Lesson Plan
Code.org

Making Data Visualizations

For Teachers 9th - 12th
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...
+
Lesson Plan
Curated OER

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
+
Lesson Plan
Curated OER

Graphing Fun In Third Grade

For Teachers 3rd
Third graders display information in a graph, table, and chart. In this data lesson plan, 3rd graders look at graphs, tables, and charts, discuss their importance, and make their own.
+
eBook
Open Oregon Educational Resources

Beginning Excel

For Students 9th - Higher Ed Standards
How can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...
+
Lesson Plan
Curated OER

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
Students explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and help...
+
Lesson Plan
Curated OER

Hopes and Dreams: A Spreadsheet Lesson Using Excel

For Teachers 4th
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
+
Lesson Plan
Curated OER

Mmm, Mmm, M&M's

For Teachers 3rd - 5th
Here is another version of the classic M&M math lesson. In this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
+
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Young scholars practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
+
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
+
Lesson Plan
Curated OER

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Pupils review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
+
Lesson Plan
Curated OER

Level III: Technology Integration

For Teachers 4th
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
+
Lesson Plan
Curated OER

Break Even Analysis and Budgeting

For Teachers 11th - Higher Ed
Students analyze the use of break even charts in business planning. They examine the purpose and nature of budgets. They explore price elasticity and how to use Excel spreadsheets to manipulate financial information.
+
Lesson Plan
Curated OER

And the Survey Says...

For Teachers 7th - 8th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information; apply appropriate technologies to critical thinking, creative expression, and decision-making skills. They collect and explore data...
+
Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
+
Lesson Plan
Curated OER

Iditarod

For Teachers 6th - 8th
In this Iditarod worksheet, students complete word problems about fractions, money, and more, based on the Iditarod race. Students complete 10 problems.
+
Lesson Plan
Curated OER

Unit 2: Lesson 7

For Teachers 6th - 8th
Students are introduced to spreadsheets. They conduct a survey of television viewing time of different shows based on different age categories. Students work in small groups. They collect, data and interpret the data from a survey.
+
Lesson Plan
Curated OER

Graphing Favorite Holidays

For Teachers 1st - 3rd
Students create spreadsheets and bar graphs based on results of survey of favorite holidays.
+
Worksheet
Curated OER

Experiment-Using Formulas and Spreadsheets

For Students 9th
In this Algebra I worksheet, 9th graders track information relating to a sporting event and create a spreadsheet and appropriate formulas used to track data.  The one page worksheet contains the assignment and instructions.  Answers are...
+
Lesson Plan
Curated OER

Down the Drain: How Much Water Do You Use?

For Teachers 4th - 8th
Participate in an Internet-based project to share information about water usage with other students. Collect information about water usage and compare it to the average used by people in other parts of the world.
+
Lesson Plan
Curated OER

Meet The Graphs

For Teachers 3rd - 4th
Students identify two types of graphs. They analyze and interpret authentic data shown in bar and pie graphs and complete a graph given specific data. Perform simple functions within an Excel document:
+
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This lesson 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 spreadsheet, create...
+
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...