1. Identify a specific instance of the problem.
2. Solve the problem using algebra.
3. Identify how many cells are needed to hold information that is to be typed in by the user of the spreadsheet.
4. Label the cells from the previous step.
5. Identify the value the spreadsheet is supposed to determine.
6. In your spreadsheet, label cell(s) for the value(s) to be determined.
7. Now, generalize your specific instance in your spreadsheet.
8. Put the actual values from your specific instance into the correct cells.
9. In the cell, you are using to compute a value, press = and then put your algebraic expression into that cell, except wherever you have a number that appears in your specific example, click on the cell with that number so that the cell name appears as part of the formula.

Create 1 spreadsheet that solves these 3 problems. Make sure you label everything in your spreadsheet. Paste a link to your shared spreadsheet below when you are finished.

1. Develop a spreadsheet that will allow a person to enter an hourly rate of pay and the number of hours worked each week. The spreadsheet should calculate the gross pay for the person for the year. You can assume the person works 50 weeks a year.