# The Measurement of Adolescents, II

## Statistics and Spreadsheets

Your feedback is important to us!

After viewing our curriculum units, please take a few minutes to help us understand how the units, which were created by public school teachers, may be useful to others.

## Lesson 4

### Objectives:

- 1. To create formulas using the pointing method.
- 2. To create formulas using the keyboarding method.

### Directions:

Move the cursor to E8.

- 1. Using the pointing method, find Pam’s points for the first 8 games. 1-2-3 likes this method because it minimizes typing mistakes and because it allows you to see the actual cells that you are using.

Press + to start the formula.

Press the left-arrow key twice to obtain for our formula the cell which contains the number of baskets scored. The control panel now displays +C8.

Press * to multiply.

Type 2 to multiply by 2 since each basket is worth 2 points.

Press + to add.

Press the left-arrow key once to obtain for our formula the cell which contains the number of foul shots made. The control panel now displays +C8*2+D8.

Press [ENTER] to enter the formula.

Move the cursor to E9 and use the above procedure to find Pam’s points for the Hamden game.

Continue through the West Haven game.

Move the cursor to E16.

- 2. Using the keyboarding method, find Pam’s points for the next 8 games. You will need to know this method when you are in the Edit Mode.

Press + to get into Value Mode.

Type C13*2+D13 to create the formula.

Press [ENTER] or the down-arrow key to enter the formula.

Move the cursor to E17 and use the above procedure to find Pam’s points for the Cross game.

Continue through the remaining games.

Press / to bring up the Main Menu.

- 3. When you have completed entering the formulas, resave the file.

Select File.

Select Save.

1-2-3 now prompts you with BASKET, the file you loaded

Press [ENTER]

Select Replace.