MICROSOFT  EXCEL  CLASS 
ON  LINE

Hit Counter

 

   

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 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

11.  Advance
Table lookup

12.  Count Functions Video

Example for Count Functions

 

Video1   
Video 2  
  Video 3   

Example

 

 13.  Header for Excel

   
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.

Note: Students answers are checked and presented instantly in the spreadsheet.

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

  1. Excel Lessons

  2. Excel Templates

  3. Excel Lessons

  4. Excel Lessons

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

Example Lessons by Grade Level

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  
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

   
Time Line in Excel
Documentation
  Video
9 - 12   Loan amortization Excel Video1
Video 2
Spreadsheet and Graphing Documentation Video
Counting Functions Excel Video
Roth IRA       Make a Million
Documentation
Excel Video

Spreadsheet WebQuest

Spreadsheet WebQuest