Solution Sheets © Mike Splane June 2016

The solution sheet is a tool to help you document the progress you are making as you work on each project objective. It will be updated as you work. You will use it in class to quickly share ideas with other students and after graduation as “work product” to show off your skills to future employers.

The solution sheet has four parts:

Objective: What you want to do - a statement of the problem and the desired outcome.

Method: A brief general description of how you plan to achieve the objective.

Formulas and Functions: A list of Formulas and Functions that were used as part of your method.

Difficulties: A list of the problems and obstacles that you need to work through in order to make the method work. Under each difficulty describe how you overcame it.

A solution sheet could include more than one idea of how to meet the objective. Each of these methods with its formulas and its obstacles should be described in separate sections.

Bring hard copies of your solution sheets to class. These handouts will be shared with other students during class to compare methods, overcome obstacles, and find an optimal solution. The solution sheets will be altered as you work your way through the obstacles. If you want to document the solution process you could include side notes describing what steps you went through to reach your solutions.

If you get stuck, you might find it useful to create a separate solution sheet for any obstacles you run into that you can’t immediately overcome. We will spend some time in class discussion helping each other brainstorm ideas for overcoming the toughest obstacles.

Example of a Solution Sheet

Name Mike Splane

Date June 7, 2016

Objective: In the A1:A1000 range enter the numbers between 1000 and 1999.

Method: Enter the number 1000 in cell A1. Create a formula that adds 1 to the number found in the cell above it. Select the A2:A1000 range. Use Ctrl + Enter to enter the formula into the range.

*Note: I can think of at least two other Methods, typing in each number
by hand, and by using the AutoFill handle. Can you think of a different way to
do it?*

Formulas and Functions:

=A1+1

Difficulties:

I don’t know how to select the range A2:A1000 quickly and efficiently without using the scroll-down method.

Solution: I can type A2:1000 into the name box to quickly select the range.

I don’t know if the cell reference to A1 will change to refer to new rows as I copy it down using Ctrl + Enter. It might keep the cell reference as A1.

Solution: Excel updated the row references so this was not a problem.