Numbers 1 - 12  illustrate different Excel Concepts.  Located more towards the bottom of this page you will discover examples for lessons per grade level.
1.  Introduction to Excel   /   NEW VIDEO 2.  Parts of a Spreadsheet 3.   Entering information & Formatting
4 Sum Function 5.  Subtraction Function 6.   Percentage
7.  Sorting 8.  Creating a Chart 9.  Spreadsheet  Video
Example:   DOC
10. VLookup Table video    Example

Table lookup

12.  Count Functions Video

Video1
Video 2
Video 3

Listed below you will find websites, examples in Excel and videos that may assist you in creating lessons for your class and this course.
Examples allowing students to learn math quickly and easily.  You will also provide them with the ability to author their own learning.  This is a win win lesson.  Please look over to the right and use and create any and all lessons you need.

Students may also author their own lessons using this concept.

This concept is good for almost all math.

 You may use the lessons below to illustrate not only learning some Excel but also the different areas of Math.  You may also have students learn by doing with these lessons. Grade Lesson Description More examples coming. 1 1. Lesson Simple Addition Numbers 1-10 1 1. Lesson Simple Addition Numbers 1-30 1 1. Lesson Simple Subtraction Numbers 1-10 1 1. Lesson Simple Subtraction  Numbers 1-30 VIDEO EXPLAINING 3 - 4 1. Lesson Multiplication 3 - 5 1. Lesson Division More on the way

Documentation on Pictograph
 Creating a Pictograph   Video 1  Video 2 Collie English German Sheppard Boston Terrier Scottish Terrier

The websites on the right may help you to form more ideas in using Excel in your classroom.  1.   Website one
2.
Website two
3.
Website three

Subject Area Activities Example
In Excel

VIDEOS

K - 2 You will discover ideas here that will allow you to create your own Excel spreadsheets.   Addition

Counting
Subtraction   Sub
Weather Excel Weather
Counting Coins Excel Coins
Counting
M & M with Graph
Excel
Using Excel to teach MATH and CHECK Math Lessons answers all grades
Example lessons listed to the right.  Students and teacher may modify the lessons for learning.
Addition Excel You need to edit the area of the spreadsheet that is in red.  Adjust it so that it will equal the answer.  This applies to all 5 lessons listed.
Subtraction Excel
Multiplication Excel Order of Operations
Division Excel
Algebra Excel 2-Step Algebra
Slope Slope
3 - 4   Multiplication   Multiply
Division   Division
Visualizing Fractions Excel
Bar Graph Excel

Pictograph is located above example

Example1 Video 1
Video 2
Making a Sandwich   Photo Example - 1 Video   / PDF
Map Coordinates Excel Map1  Map2
Population density per square KM. Excel
5 - 6   Ratio Converter Excel Conversion
7 - 8   Judy's Allowance

Budget for President of USA

Excel Example Video 1
Video 2

## Collecting Weather Data

Counting Functions Excel Video
Time Line in Excel
Documentation
Video
9 - 12   Loan amortization Excel Video1
Video 2