Wednesday-Thursday, April 30-May 1, 2008

Objective(s):
Today you will -
- Perform an experiment on each other's senses.
- Calculate the average (over and over again)
- Use a graph as a tool to show the fastest sense.
- Provide Reasoning for your hypothesis.

Agenda:
1. Warm-up (Graphing on EXCEL!)
2. Lab Introduction and Explanation
3. Perform the Lab
4. Data Collection/Analysis and Conclusion

Warm up:
1. Create a NEW Spreadsheet workbook using the following information and graph. Make sure to take the average.

Two cars were tested to see their speeds from 0-60mph. For each car, they completed 7 different trials, recorded the time (in seconds) it took for each car to reach 60mph, and then took the average. Tabulate, then graph all (including the averages) results:

VW Jetta (0-60mph) time (seconds):
Trial 1 = 9.2
Trial 2 = 11
Trial 3 = 12
Trial 4 = 8.5
Trial 5 = 9
Trial 6 = 9.2
Trial 7 = 8.9

Porche 911 (0-60mph) time (seconds):
Trial 1 = 7
Trial 2 = 3
Trial 3 = 5
Trial 4 = 8
Trial 5 = 5.2
Trial 6 = 5.9
Trial 7 = 5


2. Underneath the graph on the spreadsheet tell me what the graph and chart is saying!
Monday-Tuesday, April 28-29, 2008

Objective:
Students will understand the concept of an average by creating and analyzing a special type of graph known as a Histogram be able to relate its shape to the definition of the average.

Agenda
1. Warmup
2. Finish Graphing Friday's activity
3. Averages Lecture
4. Graphing the Histogram and Averages

Warm up:
How was your weekend? What did you do to deal with the heat? Write 1 paragraph (5 sentences) for an upstamp.
ADVISORY

CLICK HERE FOR THE TEMPLATE

Thursday-Friday, April 22, 2008

Objective(s):

Students will understand how graphs are made and how data can be analyzed by creating their own tables and graphs in MS Excel.

Agenda:
1. Warm up
2. Announcements
3. Averages and Graphing Lecture
4. Graphing with Averages - Worksheet and Practice

Warm-up:
1. What is a Category?
2. What is a Value?
3. What is a Series?
4. Graph the Following Data onto EXCEL-- into a BAR GRAPH.

Title: Costs of Burgers at Restaurants
Burger King Whopper $1.39
Jack N The Box Jumbo Jack $1.29
Mc Donald's Big Mac $1.10
Carl's Jr. $6 Burger $2.39
Islands Burger $7.29
Tam's $1.09
Tomy's Burger $1.05
White Castle $0.39

Wednesday, April 22, 2008
Objective(s):
Students will understand how graphs are made and how data can be analyzed by creating their own tables and graphs in MS Excel.

Agenda:
1. Warm up
2. Announcements
3. Graphing Lecture
4. Graphing Worksheet and Practice.

Warm-up:
Remember the warmup you completed on Monday? You were supposed to have listed all the food you and your family ordered the last time you ate together at a restaurant.  Now that you've listed your food items, the quantity ordered, and how much each item cost, create a simple receipt that reflects, Quantity, Total, Sub Total, Tax, and Grand Total.  Don't spend too much time decorating the receipt...just get it done.


Save as WARM-UP

Midterm Part 1:

http://www.quia.com/quiz/1368334.html


Midterm Part 2 – Applications (Excel and Receipts)




SHEET 1: Title your worksheet as "Excel math" (10 points)

Cell A1: 1+3
Cell A2: 2x3
Cell A3: 1032 divided by 63.1
Cell A4: 72 divided by 8
Cell A5: Multiply A4 x 3
Cell A6: 4 x 4
Cell A7: 12 x 3

Cell B1: 13586 - 3546
Cell B2: 72 x 33
Cell B3: 5 divided by 33
Cell B4: 12.0032 divided by 63.1
Cell B5: 3.12 x 4
Cell B6: 12 x 3
Cell B7: Multiply B1 x B2

C1: 32 divided by 3
C2: 5 x 3
C3: C1+C2
C4: C2+C3
C5: C1xC4
C6: Add C1 + C3
C7: Add A9 + B9

Cell A9: Add up Column A
Cell B9: Add up Column B
Cell C9: Add up Column C
Cell D12: Add up all Numbers

SHEET 2: Title your worksheet as "Best Buy" (10 points)

Mr. Aguda needs to furnish his new home with a brand new Flat Panel TV. Unfortunately, he needs to buy more than just the TV. He needs the following Items:

- Flat Panel TV (LCD or PLASMA)
- Power Conditioner
- XBOX 360
- Blue Ray DVD player
- HDMI Cable
- Home Theater System

1. Go to http://www.bestbuy.com/ and go shopping. - Use the search box to type in the items you're looking for. (10pts)
2. Use Sheet to for the design and change the logo to BESTBUY. (10pts)
a. Include: Qty, Item #, Description, Unit Cost, and Total for each line item
b. Include: Sub Total, Tax (8.25%), and Grand Total

Extra Credit Portion (10 Extra points) - optional...you don't have to do this part...

3. I have a coupon for 5% off her next purchase, include another item in the main column for a 5% discount and adjust your formulas accordingly.

Save as MIDTERMPART2 and email to me
MIDTERM DAY!

Agenda:
1. Warm-up
2. Review
3. Midterm
4. Make-up Work/Free Time/Grades/Notebooks

Warm-up: (2 Sentences for each answer)
1. During midterm week, what class(es) do you think will have the most difficult test? Why?
2. What are you doing to prepare for these tests?
3. What is your goal for each class?
4. In Mr. Aguda's class, do you understand how to use EXCEL?
Tuesday-Wednesday, April 15-16, 2008 -

AGENDA:
1. Warm - up (12 minutes)

Warm-up (you will email me this assignment -- Save as Warmup):
1. Go to MS EXCEL.
2. Pick a NUMBER from 1 to 9. Think about it in your head. EXCEL will guess WHAT YOU ARE THINKING!
2. In Column A answer the following problems: (You must enter the correct formulas for credit!)
- A1: To your number, SUBTRACT 5 [ =(your number - 5) ]

- A2: Multiply the answer in A1 by 3 [ =(A1*3) ]

- A3: Multiply the answer in A2 by itself (A2*A2)

- A4: Add the digits together until you only get one digit.
(For example: 64 = 6 + 4 = 10 [which is still 2 digits, so continue: then 10 = 1 + 0 = 1])

- A5: If A4 is less than 5, add 5. If it's more than 5, subtract 4.
[For example: If the answer in A4 is six, type the formula: =(A4-4)]
[If the answer in A4 is 3, type the formula: =(A4+5)]

- A6: Multiply the answer in A5 by 2

- A7: Subtract 6 from A6
[ =(A6-6) ]

- A8: Give your digit a LETTER - Type the Letter in the A8.
[A = 1, B = 2, C = 3, D = 4, E = 5, F = 6, etc.]

- A9: Pick a country in EUROPE that begins with that letter - write it in CELL A9.
[Countries in Europe include: Spain, Portugal, England, Italy, France, Click here for more European countries!]

- A10: Take the second letter of that Country and write the letter in CELL A10

- A11: In this cell, write the NAME of a MAMMAL that begins with that letter. Click here for mammals.

- A12: Think of the COLOR of that MAMMAL. Write it in A12

- I JUST READ YOUR MIND, CLICK HERE WHEN YOU'RE DONE.

- Save and EMAIL ME YOUR FILE!
Let's go shopping (Activity)
Complete the assigned activities as presented.
Monday, April 14, 2008 - 

Hey Students:
I'm out sick today. Please, remember to respect the sub, take care of our room, and complete the assignment.  I highly *respect* classes that follow these golden rules, so make me proud.

Mr. Aguda

AGENDA:
1. Warm - up (12 minutes)
2. Web Hunt Game (Win a PRIZE WEDNESDAY!)
3. Free-Surf time (ONLY IF YOU'RE DONE!)

Warm-up (you will email me this assignment  -- Save as Warmup):
1. Go to MS EXCEL.
2. Pick a NUMBER from 1 to 9.  Think about it in your head.  EXCEL will guess WHAT YOU ARE THINKING!
2. In Column A answer the following problems: (You must enter the correct formulas for credit!)
   - A1: To your number, SUBTRACT 5 [  =(your number - 5) ]

   - A2: Multiply the answer in A1 by 3 [ =(A1*3) ]

   - A3: Multiply the answer in A2 by itself (A2*A2)

   - A4: Add the digits together until you only get one digit. 
     (For example: 64 = 6 + 4 = 10 [which is still 2 digits, so continue: then 10 = 1 + 0 = 1])

   - A5: If A4 is less than 5, add 5.  If it's more than 5, subtract 4.
     [For example: If the answer in A4 is six, type the formula: =(A4-4)]
     [If the answer in A4 is 3, type the formula: =(A4+5)]

   - A6: Multiply the answer in A5 by 2

   - A7: Subtract 6 from A6 
      [ =(A6-6) ]

   - A8: Give your digit a LETTER - Type the Letter in the A8.
     [A = 1, B = 2, C = 3, D = 4, E = 5, F = 6, etc.]

   - A9: Pick a country in EUROPE that begins with that letter - write it in CELL A9.
     [Countries in Europe include: Spain, Portugal, England, Italy, France, Click here for more  European countries!]

   - A10: Take the second letter of that Country and write the letter in CELL A10

   - A11: In this cell, write the NAME of a MAMMAL that begins with that letter. Click here for mammals.

   - A12: Think of the COLOR of that MAMMAL. Write it in A12

   - I JUST READ YOUR MIND, CLICK HERE WHEN YOU'RE DONE.

   - Save and EMAIL ME YOUR FILE!

TODAY'S ACTIVITY: WEB SCAVENGER HUNT!

Visit this website = http://homepage.mac.com/cohora/ext/april.html

Click on the links on the website to find the ANSWERS, then write the ANSWERS on the HANDOUT.

The class that completes this assignment the FASTEST--AND WITH THE MOST CORRECT ANSWERS, WINS A REWARD TOMORROW.
Friday, April 11, 2008


Today: Notebook Checks: Wednesday and Thursday (April 9-10)

Objective(s):

  • Students will perform addition, subtraction, multiplication and division problems by creating cash-register receipts from a grocery store.

Agenda:

  1. Warm up
  2. Announcements
  3. Quick Tutorial: how to format a receipt.
  4. Format your worksheet / purchase stuff!
  5. Notebook Check

Warm-up:

  1. Blog about what you would like to do this weekend. (1 Paragraph = 5 sentences)
Thursday, April 10, 2008

Today: Notebook Checks: Wednesday and Thursday (April 9-10)

Objective(s):

  • Students will perform addition, subtraction, multiplication and division problems by creating cash-register receipts from a grocery store.

Agenda:

  1. Warm up
  2. Announcements
  3. Quick Tutorial: how to format a receipt.
  4. Format your worksheet / purchase stuff!
  5. Notebook Check

Warm-up:

  1. Open up MS Excel and perform the following calculations:

- Cell A1: 32 x 25
- Cell A2: Multiply A1 x A1
- Cell A3: Find the sum of A1 and A2
- Cell A4: 35 - 12
- Cell A5: Add A1:A4
- Cell A6: Subtract A1 from A3
- Cell A7: 5 divided by 2
- Cell A9: Add the entire Column using the correct formula and range. Color the box RED and put a border around it.
- Title your sheet1 "warmup"
- Save as: Warmup

Tuesday-Wednesday, April 8-9, 2008



Today: Notebook Checks: Wednesday and Thursday (April 9-10)

Objective(s):

  • Students will perform addition, subtraction, multiplication and division problems using Excel.
  • Students will become familiar with and use formula strings to perform basic math functions on Excel.
  • Students will use the RANGE function to add a series of numbers in a table.

Agenda:

  1. Warm up
  2. Announcements
  3. Formulas lecture II: Subtract, Multiply, Divide, and Orders of Operations
  4. Worksheet Continued
  5. Notebook Check

Warm-up:

  1. Open up MS Excel and perform the following calculations:

- Cell A1: 32 + 25 + 20 + 21 + 98 + 62 +512 + 089 + 9
- Cell A2: 662 + 123 + 434 +532 + 1 + 531 + 324 + 20 + 9
- Cell A3: 12 +3
- Cell A4: 5 +12 + 3 +18
- Cell A5: 82 + 3 +12 +1234 + 2032 +1029
- Cell A6: 12 + 2 + 2 + 1 + 13 + 44
- Cell A7: 72 + 88 + 83 +25 +65
- Cell A9: Add the entire Column using the correct formula and range. Color the box RED and put a border around it.
- Title your sheet1 "warmup"
- Save as: Warmup

Monday, April 7, 2008


COMING SOON: Notebook Checks: Wednesday and Thursday (April 9-10)

Important Announcement: (Periods 1, 2, 4, and 5) - Newspaper Redos or make-ups have been extended through April 8, 2008. I have added 2 office hours on Monday and Tuesday after school next week. Late papers are due no later than 4:30pm in my in-box on April 4, 2008.
Important Announcement: (Period 3) - Newspapers for period 3 will be due at the end of the class period on Friday, April 4 at 3:10pm. Anything turned in later will be considered late.

Objective(s):

  • Students will perform addition, subtraction, multiplication and division problems using Excel.
  • Students will become familiar with and use formula strings to perform basic math functions on Excel.
  • Students will use the RANGE function to add a series of numbers in a table.

Agenda:

  1. Warm up
  2. Announcements
  3. Cell Bingo
  4. Formulas lecture
  5. Addition Worksheet

Warm-up:

  1. What did you do this weekend? (2-3 sentences)
  2. What do you think the MS EXCEL program is used for?
  3. When is the next NOTEBOOK CHECK?
  4. Copy and paste the Table of Contents (see above) for the next notebook check onto your blog.
  5. Which of these pages are you missing?

Friday, April 4, 2008

Hi class:

I'm not here today because I'm spending some quality time with my family.

Today, please remember the rules when a sub is present.
(1) Treat the sub with respect
(2) Complete the assignment that is given and turn it in.
(3) You may surf the net or do other classwork QUIETLY when you are through.
(4) If you get written up by the substitute, you will serve detention on Tuesday or Thursday and be required to complete another assignment.

Thanks ahead of time for your BEST behavior...and have a GREAT day!

PLEASE LOOK THROUGH THE INFORMATION BELOW

Notebook Checks: Wednesday and Thursday (April 9-10)

Important Announcement: (Periods 1,2, 4 and 5) - Newspaper Redos or make-ups have been extended through April 8, 2008. I have added 2 office hours on Monday and Tuesday after school next week. Late papers are due no later than 4:30pm in my in-box on April 4, 2008.
Important Announcement: (Period 3) - Newspapers for period 3 will be due at the end of the class period on Friday, April 4 at 3:10pm. Anything turned in later will be considered late.

Thursday-Friday, April 3-4, 2008


Notebook Checks: Wednesday and Thursday (April 9-10)

Important Announcement: (Periods 1, 2, 4, and 5) - Newspaper Redos or make-ups have been extended through April 8, 2008. I have added 2 office hours on Monday and Tuesday after school next week. Late papers are due no later than 4:30pm in my in-box on April 4, 2008.
Important Announcement: (Period 3) - Newspapers for period 3 will be due at the end of the class period on Friday, April 4 at 3:10pm. Anything turned in later will be considered late.

Objective(s):

  • Students will perform addition, subtraction, multiplication and division problems using Excel.
  • Students will become familiar with and use formula strings to perform basic math functions on Excel.
  • Students will use the RANGE function to add a series of numbers in a table.

Agenda:

  1. Warm up
  2. Announcements
  3. Cell Bingo
  4. Formulas lecture
  5. Addition Worksheet

Warm-up:

Define the following key terms IN EXCEL (not blogger)
Put the Key term under the "A" column and then type the definitions in the "B" Column. You may need to resize each column!

(A) Spreadsheet
(B) Microsoft Excel
(C) Table
(D) Column
(E) Row
(F) Cell
(G) Formatting

  • When you are finished, label SHEET as "Definitions"
  • Save as: PerX-last-first-date-warmup
Notebook Check for April 9-10:

Page 59: Parts of a Newspaper PowerPoint notes 10 Points
Page 60: Make 3 Mastheads 15 Points
Page 61: Newspaper Project Guidelines 10 Points
Page 62: Example Newspaper (N. Torres) 10 Points
Page 63: Masthead Guidelines 10 Points
Page 64: Lead Stories Worksheet 20 Points
Page 65: Mr. Aguda's Example Newspaper 10 Points
Page 66: Accountability Slips 10 Points
Page 67: Secondary Articles (Mr. Aguda's Newspaper Example) 10 Points
Page 68: Revised Project Guidelines 10 Points

Total: 115 Points!