Thursday-Friday, April 29-30, 2010

And...we're back!
It looks like BLOGGER is back on line...
Objective(s):
By the end of today you will...
1. Finish your receipt activity.
2. Practice these calculations with another receipt activity.
3. Ketchup and get a stamp.


Agenda:
1. Warm Up
2. Announcements
3. Finish Shopping
4. Complete the Cheesecake Factory Receipt (More Practice)
5. Ketchup and Exit Slip

Warm Up:

Open up the EXCEL FILE on your desktop called "Receipt Review" or download it by clicking HERE.


Enter the correct formulas in the cells that are BLUE. If you type the correct formula, the cell on the right will turn green. If you don't, it will remain RED.


When you are done, open your RECEIPT (Saved as Shopping) and continue shopping until you have spent all your money!

Shopping Templates
(Without formulas)
(With Formulas)



Monday, April 19, 2010

BLOGGER IS STILL BLOCKED!
So, do the warm-up on MS WORD
Objective(s):
By the end of today you will...
1. Review what you learned last time (cell formatting)
2. Know how to create and use appropriate formulas for various math functions in Microsoft Excel
3. Take a short quiz


Language Objective: What is the difference between a summation formula and the standard formula?


Agenda:
1. Warm Up
2. Announcements
3. Excel Bingo
4. Introduction to Formulas
5. Worksheet
6. Exit Slip

Warm Up:

Open up EXCEL and do the following (do them in the order they appear here)


Cell A1: 16 + 72
Cell A2: 75 + 34
Cell A3: 5 x 3 x 2 ÷ 35
Cell A4: 752 ÷ 2
Cell A5: Cell A2 ÷ Cell A1
Cell A6: 132 - 35 x 2
Cell A7: 300 + 12 + 1 + 3
Cell A9: Add up the entire column (change the font size to 20 and color to Yellow)


QUIZ:
English: 
http://www.quia.com/quiz/2393443.html

SPANISH
http://www.quia.com/quiz/2395494.html






Thursday-Friday, April 15-16, 2010

BLOGGER IS STILL BLOCKED!
So, do the warm-up on MS WORD
Objective(s):
By the end of today you will...
1. Review what you learned last time (cell formatting)
2. Know how to create and use appropriate formulas for various math functions in Microsoft Excel


Language Objective: What is the difference between a summation formula and the standard formula?


Agenda:
1. Warm Up
2. Announcements
3. Excel Bingo
4. Introduction to Formulas
5. Worksheet
6. Exit Slip

Warm Up:

Open up EXCEL and do the following (do them in the order they appear here)


A1:E14 = Blue
B3:D5 = Orange
C2:C3 = Yellow
A4:E4 = Yellow
C4 = RED
C7:C14 = Green
A15:E16 = Brown
A9 = Green
B10 = Green
D10 = Green
E9 = Green