Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
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. ...
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

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.
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson plan; 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...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Students create arrays using Microsoft Excel. In this technology-based math activity, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Young scholars investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft...
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

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

WORKING WITH WORKBOOKS

For Teachers 5th - 8th
Students work through problems in the textbook and teacher-made problems to reinforce the new learning. They turn in practice problems to instructor to be checked for accuracy and evidence of understanding
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.
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.
Activity
Other

Making a Word Find With Microsoft Excel

For Teachers 9th - 10th
Teachers and students can create a word find using Excel. It will help them learn to manipulate columns and rows and format and lock cells. This plan is based upon 10 word or phrases on any topic.
Unit Plan
Department of Defense

Do Dea: Spreadsheets: M1:l3: Operating System and Spreadsheet Applications Screen

For Students 9th - 10th
In Module 1 Lesson 3 of this course on spreadsheets, students begin learning how to use Microsoft Excel to create spreadsheets. Slideshows walk them through how to navigate the menus and tools of Excel.
Unit Plan
Department of Defense

Do Dea: Spreadsheets: M4: L2: What Are the Conditions? Calculate With Functions

For Students 9th - 10th
In Module 4 Lesson 2 of this course on spreadsheets, students learn how to use conditional formatting to more easily analyze data. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheets: M5: L2:loans and Investments: Calculate With Functions

For Students 9th - 10th
In Module 5 Lesson 2 of this course on spreadsheets, students will learn how to use the advanced Financial, Logical and Date & Time functions to analyze spreadsheet data. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: M1: L4: Starting Here, Starting Now! Beginning a Spreadsheet

For Students 9th - 10th
In Module 1 Lesson 4 of this course on spreadsheets, students create their first spreadsheet using Microsoft Excel. Includes slideshow tutorials.
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...
Handout
Other

The Excel Addict

For Students 9th - 10th
The Excel Addict offers free tips, tutorials, newsletters, and more relating to the spreadsheet and database program, Microsoft Excel.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M6: L1: Designing Spaces: Using Templates

For Students 9th - 10th
In Module 6 Lesson 1 of this course on spreadsheets, students learn how to use the templates in Excel to save time when making new spreadsheets. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L1: Layout and Lay Up: Managing Workbooks

For Students 9th - 10th
In Module 5 Lesson 1 of this course on spreadsheets, students learn how to work with large spreadsheets that extend beyond the screen. They will change the view, use split windows, freeze rows and columns, remove gridlines, etc. Includes...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M6: L4: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 6 Lesson 4 of this course on spreadsheets, which is the final lesson of the course, students review what they have learned in the previous three lessons about using templates, using data validation tools, and importing data...
Unit Plan
Department of Defense

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

For Students 9th - 10th
In Module 3 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about adding shapes and graphics to spreadsheets, using drawing tools to format them, using the autosum function,...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions

For Students 9th - 10th
In Module 2 Lesson 3 of this course on spreadsheets, students learn how to save time when setting up a spreadsheet by copying functions and formulas. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions

For Students 9th - 10th
In Module 2 Lesson 2 of this course on spreadsheets, students learn how to use the built-in functions in Excel so that they don't have to retype a formula each time they use it. Includes slideshow tutorials.