21_Century

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

	6 - 9	*1 Step Algebra*					Algebra
	6 - 9	2 Step Algebra


	6 - 9	Order of Operations

	6 - 9	*Slope*
	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	VIDEO
	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
	*2-3-4-5-6-7-8*	9S. LESSON					*Simple budget*
	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
*PAYROLL & BUDGET*	4 - 12	*10A Lesson*	*Data*				*Learning about education for life and finance with payroll and budgeting*
*Payroll for the year*	*4 - 12*	*10B*	*Learning about Excel and your future with your educational background.*				*Learning about a year in your life using Excel and your future with your educational background.*
*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
4. *Excel Functions*	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)

Statistics and probability