21  Century   Excel

 

Hit Counter

CLICK  FOR Statistics and Probability
This webpage is designed to allow educators and students use excel in the classroom to learn basic addition, subtraction as well as multiplication and division and much much more.  Watching the videos we have posted below will show how students may create their own lessons at any math level and learn by doing. Please watch the short videos to see how easy this is to do.

More lessons are listed below for you to discover other methods of using excel in the real world. We have provided for you lessons that will not only prepare you for the future but allow you to understand what is presently occurring in the world today.

VIDEO - 1 (ADDITION)   VIDEO - 2 (SUBTRACTION)    VIDEO - 3 (MULTIPLICATION)    VIDEO - 4 (DIVISION)

 

 EXCEL 
(After you open each lesson you will need to click Enable Editing to work on the lesson)

LESSONS GRADE LEVEL LESSONS Brief Description

VIDEOS 

Excel
Math Lesson Using Excel

Students answers are checked and presented instantly in the spreadsheet.

 

Students may also author their own lessons using this concept.

1

1. Lesson  Simple Addition Numbers 1-10 Video

The video above shows you how to create the lessons!

Easy for anyone to do.

1

1. Lesson  Simple Addition Numbers 1-30

1

1. Lesson  Simple Subtraction Numbers 1-10

1

1. Lesson  Simple Subtraction
 Numbers 1-30
     

3-4

1. Lesson  Multiplication  
     

3-4

1. Lesson  Division
       

4-5

1. Lesson  Decimals Add & Subtract  

4-5

2. Lesson  Decimals Add & Subtract  

 

     

6- -7- -8

1. Lesson One Step Algebra    
       

4-5

1. Lesson  Order of Operations  

4-5

2. Lesson  Patterns  

4-5

3. Lesson  Round to Thousands  
       
       
       
Excel  2-3-4 1A. Lesson Basic Excel Lesson
  2-3-4 A. Lesson Learn cells -  Learning  
  2-3-4 B. Lesson Continents & Oceans - Learning  
  2-3-4 1. Lesson Simple Addition  
  4-5-6-7-8 2. Lesson Fruit Chart- Columns chart VIDEO
  4-5-6-7-8 3. Lesson Clothes Budget  
  4-5-6-7-8 3A. Lesson M & M Column Graph VIDEO
  3-4-5-6-7 3B. Lesson  Mac Excel M & M Column Graph
  4-5-6-7-8 4. Lesson School Supplies  
  4-5-6-7-8 5. Lesson Picture Graph Chocolates  
  4-5-6-7-8 6. Lesson M&M Picture Graph VIDEO
  4-5-6-7-8 7. Lesson Petting-Zoo Picture Graph  
  4-5-6-7-8 8. Lesson M&M Pie Chart  
  6-7-8 9B Lesson  Data Learning Budget 3 Parts

VIDEO

  7-8 9. Lesson  Data Budget Template Simple  
  7-8 10. Lesson  Data Household Budget detailed  
Data is the Excel sheet 7-8 11. Lesson  Data Loan Amortization VIDEO
  8-12 12. Lesson  Data Excel Functions  
  7-8 13. Lesson  Data Three Charts in Excel Olympics  
  7-8

14. Lesson

 Data

Creating Mailing Labels

VIDEO

  7-8 15. Lesson  Data Creating Return Labels VIDEO
  7-8-9-10-11-12 16. Lesson  Data Data Base in Excel-Sorting-Filter VIDEO
  9-10-11-12 17. Lesson Functions (Count-Average-Median-Mode-Left-Right-Len)
  9-10-11-12 18. Lesson  Data IRA - ROTH IRA 1.3 Million  
  7-8-9-10-11-12 19. Lesson  Data Advanced Chart Lesson VIDEO
  6-7-8-9-10-11-12 20. Lesson  Data This lesson should present a unique concept of money and time. VIDEO

COLOR USING SPREADSHEET

CREATING A DRAWING USING EXCEL SIMPLE AND EASY  by Brandon Pike
1. Open up Excel  from the link below.  When open at the top click on Enable Editing.
2. To place a color in the cell just click on the cell you want the color to appear (UPPER OR LOWER CASE) and type the letter of the colors listed to on the left.  r for red -- g for green bo for brown  --  bb for Black and so on

CLICK HERE FOR COLORING SPREADSHEET IN EXCEL

Video on how to transferring files to Google sheets

 

DIRECTIONS FOR PRINTING YOUR DESIGN FROM YOUR SPREADSHEET  ON PAPER USING MICROSOFT OFFICE EXCEL

1.     SMALL AREA: will fit on a one sheet of paper

a.      If your coloring is in a small area on the spreadsheet you only need to go to file then print.

2.     LARGER AREA:  will fit on more than one sheet of paper

a.      PAGE LAYOUT AT TOP MENU

b.     You may adjust to a percentage or

c.      Click FIT TO 1  BY 1

 

 

Statistics and probability

 

1. Introduction to Mathematical Statistics 2. Using and Handling Data 3. Statistics and Probability | Khan Academy
4. Excel Functions 5.  VIDEOS  
Basic Statistics Lesson 1 (Video 1)
a. Lesson Basic Statistics Lesson 1 (Video 2)
b. Data Basic Statistics Lesson 1 (Video 3)
  Basic Statistics Lesson 1 (Video 4)