Monday-Tuesday, April 30-May 1, 2007

Proactive form of Demonstration -
Click on this link to visit an email you can sign to send to the following head of state:

U. S. State Representative Gerald McNerney (D)
(925) 833-0643
info@jerrymcnerney.org


Today's Agenda:
1. Warm up
2. Introduction to Data Analysis and Graphing
3. Worksheet on Data Analysis and Graphing

1. Warm up
Open up MS Word or your Blogger:

(1) What have you learned, so far, about MS Excel?
(2) What do you think EXCEL is used for?
(3) What other things do you think EXCEL can do?
(4) Describe your weekend.

Save as (if you used WORD): PerX-last-first-warmup-date.doc

2. Introduction to Data Analysis




Friday, April 27, 2007

Today's Agenda:
1. Warm up (MS Excel)
2. Discuss Homework
3. Receipt (Grocery)
4. Receipt (Entertainment)

1. Warm up
Create a NEW Spreadsheet workbook.

Set up your new Worksheet to look like what is on the board.

Create a simple receipt (don't include any graphics or spend too much time on design of receipt) for this purchase.

Save as: PerX-last-first-warmup.xls

3. Entertainment and decoration Receipt (cont'd)
Friday, April 27, 2007

Today's Agenda:
1. Warm up (MS Excel)
2. Discuss Homework
3. Receipt (Grocery)
4. Receipt (Entertainment)

1. Warm up
Create a NEW Spreadsheet workbook.

John purchased the following items from the Taco Bell

12 Tacos ($0.89 each)
1 Nacho Belgrande ($2.80 each)
5 Bean Burritos ($0.79 each)
2 Grilled Stuffed Burritos ($2.25 each)
Tax in Delano, California is 7.25%

Create a simple receipt (don't include any graphics or spend too much time on design of receipt) for this purchase.

Save as: PerX-last-first-warmup.xls

2. Grocery Receipt (cont'd)
3. Entertainment and decoration Receipt (cont'd)
Thursday, April 26, 2007

Today's Agenda:
1. Warm up (More Practice on MS Excel)
2. Orders of Operation
3. Receipts and formulas
4. Homework

1. Warm up
Create a NEW Spreadsheet workbook.

Part I:
Type up each set of numbers in the columns specified. In ROW #10 of each column, enter a FORMULA that would add up the column. Place a Thick Dark border around each answer.

COLUMN A = 200, (100x31), 300, 123, (251-50), 321, 31.12, 1
COLUMN B = (34110+123+0.24), (0.23x100), 0.3, 8.151, 6.123, 4, 12.75, (1.2-0.9)
COLUMN C = (1682-123), (-321/12), (58*0), (8.231x23), (75x45), (-45x1990), 82, 5
COLUMN D = 751, 752, 753, 754, 1, 2, 3, 4
COLUMN E = 8222, 1, 75, 2.2, 1.1, 8.321, 12.5, 1.375

Part II:

CELL F1: Enter a Formula that would ADD UP all the numbers in ROW1. Fill the CELL with Orange.
CELL F2: Enter a Formula that would ADD UP all the numbers in ROW2. Fill the CELL with Blue.
CELL F3: Enter a Formula that would ADD UP all the numbers in ROW3. Fill the CELL with Green.
CELL F4: Enter a Formula that would ADD UP all the numbers in ROW4. Fill the CELL with Yellow.
CELL F5: Enter a Formula that would ADD UP all the numbers in ROW5. Fill the CELL with Gray.
CELL F6: Enter a Formula that would ADD UP all the numbers in ROW6. Fill the CELL with Purple.
CELL F7: Enter a Formula that would ADD UP all the numbers in ROW7. Fill the CELL with Light Green.
CELL F8: Enter a Formula that would ADD UP all the numbers in ROW8. Fill the CELL with Teal.

Cell F9: Enter a Formula that would add up all the totals in your workbook. Use ARIAL 25PT font.
Friday, April 20, 2007

Today's Agenda:
1. Warm up
2. More Practice
3. Homework/Practice Review
4. Intro to Formulas 2.2 Worksheet (*,/,-,OOE)
5. Turn in Stamp Sheets

1. Warm up
Read the following article:
http://en.wikipedia.org/wiki/Columbine_High_School_massacre
You may read as little or as much as you would like. Answer the question below in your blog or on MS Word.

This is a FREE WRITE. WRITE a Paragraph (6-7 Sentences) In light of recent events (The Virgina Tech Shooting) and what you have just read about the Columbine Shooting that occured 8 years ago today, what are your initial thoughts about these violent acts? What motivated the murderers to do what they did?

2. More Practice
Create a NEW Spreadsheet workbook.

Part I: Type up each set of numbers in the columns specified. In ROW #10 of each column, enter a FORMULA that would add up the column. Place a Thick Dark border around each answer.

COLUMN A = 200, 100, 300, 123, 251, 321, 31.12, 1
COLUMN B = 2110, 0.23, 0.3, 8.123, 6.91, 3, 81.75, 1.2
COLUMN C = 1682, -321, 58, 8.231, 75, 45, 82, 5
COLUMN D = 751, 752, 753, 754, 1, 2, 3, 4
COLUMN E = 8222, 1, 75, 2.2, 1.1, 8.321, 12.5, 1.375

Part II:

CELL F1: Enter a Formula that would ADD UP all the numbers in ROW1. Fill the CELL with Orange.
CELL F2: Enter a Formula that would ADD UP all the numbers in ROW2. Fill the CELL with Blue.
CELL F3: Enter a Formula that would ADD UP all the numbers in ROW3. Fill the CELL with Green.
CELL F4: Enter a Formula that would ADD UP all the numbers in ROW4. Fill the CELL with Yellow.
CELL F5: Enter a Formula that would ADD UP all the numbers in ROW5. Fill the CELL with Gray.
CELL F6: Enter a Formula that would ADD UP all the numbers in ROW6. Fill the CELL with Purple.
CELL F7: Enter a Formula that would ADD UP all the numbers in ROW7. Fill the CELL with Light Green.
CELL F8: Enter a Formula that would ADD UP all the numbers in ROW8. Fill the CELL with Teal.

Cell F9: Enter a Formula that would add up all the totals in your workbook. Use ARIAL 25PT font.
Wednesday-Thursday, April 18-19, 2007

Today's Agenda:
1. Warm up
2. Review and/or Bingo part II
3. Intro to Formulas 2.0 Worksheet
4. Homework Overview

1. Warm up
Open up MS Excel and follow the following directions:

1.B4:B15 = RED
2.C9 = Red
3. D4:D15 = RED
4. F6 = YELLOW
5. F9:F15 = YELLOW
6. H4:H13 = Blue
7. H15 = BLUE
9. Columns A, G, E, and I. Width = 2
10. Row 6 and 15. Height = 40
11. B17:H17 = Black
12. K4 = Black
13. M4 = Black
14: K6 and M6 = Black
15. L8 = Olive Green
16. J10 = Olive Green
17. K11 = Olive Green
18. L12 = Olive Green
19. M11 = Olive Green
20. N10 = Olive Green

3. Intro to FORMULAS
4. Homework: Formula Worksheet
Monday-Tuesday, April 16-17, 2007

WELCOME BACK!

Today's Agenda:
1. Blog (www.blogger.com)
2. New Grading Procedures Begin Today (15 Minutes)
3. Fill out Grading Sheet (3 minutes)
4. Definitions and Notes (10 Minutes)
5. Tutorial (25 Minutes)
6. Homework
7. BINGO (10 Minutes to END)
8. Save your work


Warm Up: Blogger

How was your Spring Break? What do you end up doing? Where did you go? For an upstamp, you need to write at least 1 4-5 sentence paragraph.


You are thinking of a GRAY ELEPHANT from DENMARK

Am I correct? If I'm not, tell me in an email...