Computer Science and Computer Engineering 120
Computerized Information Systems
Spring 2007



Lab 1

Simple Excel

The goal for this lab is to help you develop and demonstrate your skills using Excel by completing 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 Movies" 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 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.
3. Work the Clark School problem on page 1046. You do not need to print the spreadsheet but instead submit it electronically as directed below.

Requirements

• Format the Movies and Clark School spreadsheets 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. For example, the paper grader might enter different values for the number of tickets sold and change the prices in the movies spreadsheet. Your spreadsheet should correctly recalculate the results with the new data.
• Make sure that your name and section number appear on each of the 3 spreadsheets.
• Copy the spreadsheets from the "Accuracy Counts" and "Clark School" workbooks into the "Movies" workbook so you will only have to submit one workbook.

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 well as its description of the problem and the ways to avoid mistakes of this nature in the future.

Submitting your your assignments:

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

1. Open all three workbooks in the same Excel window.
2. In the "Accuracy Counts" 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 Movies 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 Movies workbook.
8. Repeat this process with the Clark School problem.
9. Remember to save the workbook containing all three 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 (csce120-brink-secX, Spring 2007 where X is 1 or 3) 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 Movies 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

Midnight, Thursday, Feb. 15. There will be a 24 hour grace period. After the grace period late submittals will not be accepted except with written permission from the instructor and will be subject to a 20% per day. (Late assignments turned in on Thursday are 2 days late and are subject to a 40% penalty.)

Revised: Feb. 1, 2007