CS 101 FINAL EXAM

This is an electronic exam. No printing will be permitted during the exam.

PART 1 (30 points) SPREADSHEETS

 Create the following spreadsheet:

               Mary's Computer Emporium

Department     Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Total
     
Computers 356,666   453,765   544,345   565,988   xxx
Printers   45,564    54,655    23,544    87,567   xxx
Software   50,660    65,566    98,440    65,650   xxx

Grand Totals    xxx       xxx       xxx       xxx      xxx

        Average Computer sales =    yyy
        Average Printer sales      =    yyy
        Average Software sales   =   yyy
       
where xxx are the appropriate sums of each item and yyy is the appropriate average 
for each item.

     Create a Header containing your name (in the center) and the current date (use 
the date function) at the far right.  Create a footer containing the page number 
(centered) and the phrase Final Exam Test A" at the far left. Format all the 
numeric fields so they contain a comma and no decimal point. 

Save the spreadsheet as PART1A on the A drive.

     Draw a pie chart of the above data comparing the Grand Totals for each 
quarter. Each of the four pie pieces must be identified (i.e., Quarter 1, 
Quarter 2, etc.). Copy both the pie chart and the entire spreadsheet (without 
grid lines) to the following letter:

                 SUPERIOR GOLD MINING CORPORATION
                          July 19, 1997           

                               MEMO

TO:       John Morgan
FROM:     Mary 
RE:       Corporate Profits for Year

     For this year our company has been very successful as measured by sales 
volume. The exact values for each quarter are given as follows:

          PLACE ENTIRE SPREADSHEET HERE

As you can see from the following pie chart of the totals for each of the four 
quarters, our sales have continuously increased each quarter:

          PLACE PIE CHART HERE

I think this data shows that our company will be successful and your investment 
including 1000 shares in our company and the purchase of 5,000 dollars in 
corporate bonds is a safe and sound investment. 
  
Save the letter with the included spreadsheet and pie chart as PART1B on the 
A drive.

PART 2 (30 points) DATABASES

Create a data base containing the following columns:

     INVESTOR LAST NAME (25 characters), INVESTOR FIRST NAME 
(25 characters), NUMBER SHARES (number), AMOUNT OF BONDS 
(in dollars with two decimals to the right).

The database must have as its column names the above names (INVESTOR 
LAST NAME, INVESTOR FIRST NAME, NUMBER SHARES, AMOUNT
OF BONDS) in that order.

     Load the following data into the database:

Record 1
     INVESTOR  NAME      John Morgan
     NUMBER SHARES       1000
     AMOUNT OF BONDS     5000.00


Record 2
     INVESTOR  NAME      Sue Smith
     NUMBER SHARES       5000
     AMOUNT OF BONDS     8000.00

Record 3
     INVESTOR  NAME      Chris Stevens
     NUMBER SHARES       10000
     AMOUNT OF BONDS     15000.00

Save the database as PART2A on the A drive.  

     Using the above database that you created, create a report for MARY that
 lists each of the investors in her company, their individual number of shares, 
and the amount of money each has invested in corporate bonds. Include your 
name at the top of the report. 

Save the report and database as PART2B on the A drive.

PART 3 (10 points) INTEGRATION

Reload the memo found in PART1B. Copy the three records from the database 
into the memo.

Save the rewritten memo as PART3 on the A drive.

PART 4.  (15 points) USING THE WWW

     Using Netscape, go to LSSU's web page. Click on the Sault Ste. Marie 
hypertext item on LSSU's main page. Capture the picture of the International 
Bridge that is in the Sault Ste. Marie section of LSSU's Home Page. Store the 
picture on your floppy as PICTURE. 
     Copy all the text about Sault Ste. Marie that appears on that page and place 
the text in your memo of PART3. Create a footnote identifying the captured text 
as coming from LSSU's WWW site. Include in your footnote the URL address of 
the location of the text. Place the footnote at the end of the document. Save this 
modified memo as PART4. 
     
     I will assume you know how to copy the graphic picture of the International 
Bridge into your document. Therefore, you do not have to place the picture in your 
document--just store it on your floppy.
     
Be sure to spell check all memos.

Your floppy should contain the following files:

     PART1A
     PART1B    
     PART2A
     PART2B
     PART3
     PART4
     PICTURE
     
PART 5 SUBDIRECTORIES (15 points)

Create the subdirectory  BACKUP on your floppy.  Copy PART1A, PART1B, 
PART2A, PART2B, PART3, PART4, and PICTURE into the subdirectory 
BACKUP. 

At this point, your floppy should contain the seven files you saved for this exam, 
a subdirectory called BACKUP, and a copy of the seven files within the BACKUP
 subdirectory.  There is to be no other files or subdirectories on your floppy.  

WARNING: This is a final exam to verify certain knowledge gained in this course. 
Before you turn in your floppy, verify that all files exists on your floppy. Since there
 is no makeup for this exam, if you turn in a floppy that does not contain files, I will
 assume that you did not know how to do the work that is missing.