Computer Science and Computer Engineering 115
Solve It with Computers
Fall 2006



Lab 1

Simple Excel

The goal for this lab is to help you develop and demonstrate your skills using Excel by developing two spreadsheets and debugging another. Before doing this lab you are strongly urged to work though Chapter 1 actually carrying out Hands-On Exercises 1 through 4.

1. Work the MiniCase called "The Housing Office" on page 64. Follow instructions in the problem except you do not need to print the workbook. Instead submit the final spreadsheet electronically as directored below.
2. Work the exercise called "Excel Chapter 1: The Clark School" on page 1046 except you do not need to print the workbook. Instead submit the final spreadsheet electronically as directed below.
3. Work the MiniCase called "Accuracy Counts" on page 64. Create the memo in Microsoft Word. In additions to the instructions in the text, correct the workbook. Submit both the corrected spreadsheet and the memo electronically as directed below

Requirements:

• Format the housing office spreadsheet in an appropriate way using the standards of Chapter 1.
• Remember to use formulas whenever appropriate. Assume the papergrader will change the data before grading the sheet. Your spreadsheet should correctly solve the problem with the new data.
• Copy the spreadsheets from the "Clark School" and "Accuracy Counts" workbooks into the "Housing Office" workbook so you will only have to submit one workbook.
• Make sure to include your name on every worksheet and in the Word document

Grading:

Your spreadsheets will be graded on meeting the requirements, correctness, general looks, and impression they leave the reader. The memo for the "Accuracy Counts" problem will be graded on readability as will as its description of the problem and the ways to avoid mistakes of this nature in the future.

Submitting your lab:

After completing your spreadsheets and the memo, copy the "Accuracy Counts" and "Clark School" worksheets into the workbook for the "Housing Office" worksheet. The method:

1. Open all three workbooks in the same Excel window.
2. In the "Clark School" workbook right click the worksheet's tab on the bottom of the sheet.
3. Select "Move or Copy".
4. In the "Move or Copy" dialog box, select the housing office workbook in the "To book:" drop down box.
5. Select "(move to end)" in the "Before Sheet:" box.
6. Check the "Create a copy" box.
7. When everything is ready, click "OK" Excel will copy the sheet to the "Housing Office" workbook.
8. Repeat the process to add the "Accuracy Counts" spreadsheet to the "Housing Office" workbook.
9. Remember to save the workbook containing both worksheets!

Now submit the combined workbook and your memo.

1. Use the URL http://www.cs.plu.edu/submit/login.php
2. Select your class (csce115, Fall 2006) from the drop down box.
3. Enter your submit system username and password as provided by the instructor.
4. Click "Login".
5. In the add Assignment box, browse to find the workbook for the housing office that contains both worksheets.
6. Select "Lab 1" for the assignment and then click "Upload".
7. Repeat the upload for the memo for "Accurcy Counts".
8. Double check to make sure both files have been uploaded.
9. Click "Sign Off" near the top right hand corner of the window.

Due date

Monday, Sept. 18. Late submittal will not be accepted except with written permission from the instructor. Even with permission, there will be a significant penalty for late submitals.

Revised: Sept 9, 2006