Lesson Plan
Curated OER

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

For Teachers 5th - 12th
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.
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

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Young scholars 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...
Lesson Plan
Curated OER

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Students 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
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

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...
Lesson Plan
Curated OER

Twelve Days of Christmas

For Teachers 6th - 8th
Students create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.
Lesson Plan
Curated OER

Keypals and You

For Teachers 6th - 12th
Learners collect and compare data received from keypals. They use electronic mail to exchange information with keypals and rrite a paper comparing similarities and differences between themselves and their keypals. In addition, use a...
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
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.
Lesson Plan
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L3: What's That Layout? Enhancing Charts

For Students 9th - 10th
In Module 4 Lesson 3 of this course on spreadsheets, students learn how to use advanced features of Excel to simplify analysis of their data, for example, to make predictions about future trends or to take mini-snapshots of data trends...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software Applications: M4: L1: Chart It! Working With Charts

For Students 9th - 10th
In Module 4 Lesson 1 of this course on spreadsheets, students learn how to build a chart from their spreadsheet data so that it is easier to interpret. Includes a glossary and slideshow tutorials.
Activity
BBC

Bbc Bitesize: Spreadsheets

For Students 9th - 10th
Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Rainfall and Elevation: A Charting and Critical Thinking Exercise

For Teachers 9th - 10th
In this lab, students will learn to organize and present data in a visual way so that they can then summarize in writing their conclusions about the relationships between the data.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 4 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about building charts, using conditional formatting, and enhancing their spreadsheet by inserting images, text, and...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L4: And This! Inserting Objects and Content

For Students 9th - 10th
In Module 4 Lesson 4 of this course on spreadsheets, students learn how to insert text, graphics, and charts into a spreadsheet. They will learn how to import and export data and images between different types of documents. Includes a...
Website
Other

The University of Arizona: Study Finance: Getting Started With Excel

For Students 9th - 10th
A great tutorial that takes you through all the steps you need for mastering the Microsoft Excel spreadsheet application.
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online lesson, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think will be the...