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!
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.
Objective(s):
2. What is a Value?
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
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?
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!]
Hey Students:
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:
- Warm up
- Announcements
- Quick Tutorial: how to format a receipt.
- Format your worksheet / purchase stuff!
- Notebook Check
Warm-up:
- Blog about what you would like to do this weekend. (1 Paragraph = 5 sentences)
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:
- Warm up
- Announcements
- Quick Tutorial: how to format a receipt.
- Format your worksheet / purchase stuff!
- Notebook Check
Warm-up:
- 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
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:
- Warm up
- Announcements
- Formulas lecture II: Subtract, Multiply, Divide, and Orders of Operations
- Worksheet Continued
- Notebook Check
Warm-up:
- 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
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:
- Warm up
- Announcements
- Cell Bingo
- Formulas lecture
- Addition Worksheet
Warm-up:
- What did you do this weekend? (2-3 sentences)
- What do you think the MS EXCEL program is used for?
- When is the next NOTEBOOK CHECK?
- Copy and paste the Table of Contents (see above) for the next notebook check onto your blog.
- Which of these pages are you missing?
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.
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:
- Warm up
- Announcements
- Cell Bingo
- Formulas lecture
- 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
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!