Thursday-Friday, May 28-29, 2009

Objective(s):
1. Students will take a MIDTERM EXAM for the EXCEL unit.
2. Students will complete and graph their DATA from the senses experiment.

Agenda:
1. Digital Zen
2. Announcements and Quick Review
3. Midterm (Open-Notes)
4. Complete and Graph Data from senses experiment
5. Graphing Analysis and Stamp
6. Notebook Check (If time)

Digital Zen:
Answer these questions on YOUR blog.

1. If I wanted to multiply A3 with C3, what formula would I type?
2. Write the formula for 20 divided by 5
3. Which is the correct formula for adding a Column: =SUM(A3:A12) or =(A3:A12)?
4. When should you use the word "SUM" in your formula?
5. If tax is 10.25%, write a formula that would figure out the tax for a subtotal of $23.95 that is in CELL D16?
6. What company makes EXCEL?
7. What is a Spreadsheet?
8. On Excel, make a quick Reciept for these 2 items. YOU DON'T NEED TO SHOW THIS TO ME FOR CREDIT, just write your answers on BLOGGER. 1 Box of Tissues ($1.59 EACH) and 2 Toothbrushes ($2.59 Each). Figure out SUBTOTAL, TAX (9.25%), and GRANDTOTAL.
- What is the SUBTOTAL?
- What is the TAX?
- What is the GRANDTOTAL?





QUIZ FIGURES:

CLICK on EACH SHEET TO ZOOM IN:

SHEET #1:



SHEET #2:



QUIZ LINK: http://www.quia.com/quiz/1839701.html

QUIZ (En Espanol) - http://www.quia.com/quiz/1842481.html

Wednesday, May 27, 2009

Objective(s):
1. Students will graph various DATA using the graph tool on MS Excel.

Language:
1. Tell me what you need to give excel in order to graph?

Agenda:
1. Digital Zen (EXCEL)
2. Announcements
3. Graphing (Page 56)

Digital Zen:
Create a Receipt on EXCEL that will give me the total bill for the following orders. Tax is 9.25%

1 Bottle of Ketchup - $1.50 EACH
1 Bottle of Mustard - $1.29 EACH
1 Bottle of Relish - $2.10 EACH
3 12-Pack Coca-Colas - $3.99 EACH
4 12-Pack Hot Dogs - $2.99 EACH
6 8-Pack Hot Dog Buns - $1.50 EACH
2 100-Count Napkins - $0.79 EACH
2 Pack of 12 Cups - $1.50 EACH
3 Large Bags Potato Chips - $1.99 EACH

Friday, May 15, 2009

Objective(s):
1. Students will use appropriate formulas and by adjust cell properties by creating a simple Grocery Receipt.
2. Students will graph various DATA using the graph tool on MS Excel.

Language:
1. Tell me what you need to give excel in order to graph?

Agenda:
1. Digital Zen (EXCEL)
2. Announcements
3. Graphing Lecture
4. Graphing Exercises

Digital Zen:
First, Click, Save As and Open is file. Complete the Digital Zen instructions on the EXCEL spreadsheet.

MAKE SURE YOU FILE>SAVE AS>WARMUP-TARGET

Monday-Tuesday, May 11-12, 2009

Objective(s):
1. Students will use appropriate formulas to add, subtract, multiply, and divide.
2. Students will use appropriate formulas on Excel to create a Receipt budget for a dinner party.

Language:
1. Write a formula to add, subtract, multiply and divide 20 and 5. (Total of 4 Formulas)
2. Write a formula that would sum A1:A20.

Agenda:
1. Digital Zen (MS Excel)
2. Subtraction, multiplication and division worksheet
3. Application: Creating a Receipt.

Digital Zen:
1. Create a multiplication table from 1 to 26 using the Fill function on Excel WITH a checkerboard color pattern. (Remember what you did on Friday? Recreate it QUICKLY! You should be able to do it in 1 minute! If you don't, ask someone!)


2. On Sheet 2 Take the following sums (Put the totals on ROW 7, COLOR the BOX)


  • Column A: 123,321,234,213,423
  • Column B: 231,231,332,321,321
  • Column C: 123,324,5123,32133,3231
  • Column D: 0.001, 0.003, 0.3, 3.1, 5.113
  • Column E: 123, 123.01, 123.9991, 123.91
  • Column F: Add the Totals of each ROW here.

GROCERY RECEIPT ACTIVITYGrocery Circular Grocery Circular Narciso Aguda

Friday, May 8, 2009

Objective(s):
1. Students will use summation formula [=sum(variable,variable)]

Language Objective(s):

1. Write a 4 formulas to add, subtract, multiply and divide 6 and 3.

Agenda:
1. Digital Zen
2. Columns and Row Challenge Competition:

Digital Zen: (Save as Warmup)
Complete the following on a new MS EXCEL SPREADSHEET

1. Go to column B, type the numbers 1-40 down the column in B1:B40
2. Go to column C, type the numbers 2-40 counting by 2's down the column in C1:C50

Wednesday-Thursday, May 6-7, 2009

Objective(s):
1. Students will user the appropriate formulas to add, multiply, and divide math problems on MS Excel.

Language Objective(s):
1. Write a 4 formulas to add, subtract, multiply and divide 6 and 3.

Agenda:
1. Digital Zen
2. Finish Intro worksheet (Page 53)
3. Formulas Lecture
4. Formulas Worksheet (Page 54)

Digital Zen: (Save as Warmup)
Complete the following on a new MS EXCEL SPREADSHEET

1. Write your name from A1:A25
2. Change the size of Column A to fit your name.
3. Change Row 10, 12, 14, 16, 18 to Height Size 50
4. B11:H11 Any Dark Color
5. B13:H13 Any Dark Color
6. B15:H15 Any Dark Color
7. B17:H17 Any Dark Color
8. B9:H9 Any Dark Color
9. B19:H19 Any Dark Color
10. Grey Box C12:G16 With a Dark Box Border
11. B10, D10, F10, H10 Any Blue Color
12. B18, D18, F18, H18 Any Red Color
13. B14, H14 Any Color

Monday-Tuesday, May 4-5, 2009

Objective(s):
1. Students will adjust cell properties on MS Excel
2. Students will user the appropriate formulas to add, multiply, and divide math problems on MS Excel.

Language Objective(s):
1. Write a 4 formulas to add, subtract, multiply and divide 6 and 3.

Agenda:
1. Digital Zen
2. Finish Intro worksheet (Page 53)
3. How to Fill
4. Bingo!

Digital Zen: (Save as Warmup)
Complete the following on a new MS EXCEL SPREADSHEET
1. In Cell A1 type your name
2. In Cell A2 type today's date
3. Change the Width of Columns B, C, D, G, H, I to 5
4. Color B3:D7 yellow
5. Color C4:C6 red
6. Color C8:C14 green
7. Color A9, E9, B10, and D10 green
8. Color A15:E15 Brown
9. Color G3:I7 yellow
10. Color H4:H6 red
11. Color H8:H14 green
12. Color F9, G9, I10, and J10 green
13. Color F15:J15 Brown