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

No comments: