MIS 4372 -- PARKS -- FINAL EXAM -- SPRING 2019

Name_________________________________________________________

Last 4 Digits of your PSID_________________auckland server Acct__________________ (glxxxx)

e-mail address___________________________________________________

EXAM POSTED: 4:00 PM WED 4/17/2019
EXAM TO BE RETURNED BY 5:30 PM MON APR 29 TO 280E MH

  1. Write a new program that dumps the "je" table details (all columns) and counts the number of journal entries in the "je" table (name this program a47.asp). Sort the report in "sourceref ASC, srseq ASC" order. See step 6, 2nd table row.
Steps 2 thru 6 below should be performed 3 times as follows:

  1. First, run your glrestor program on your database to restore it to its original status. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in the first column the outcome of the transaction either "ok" or "failed" with an explanation of why -- if it failed.

  2. Second, modify your glrestor program by changing:
       this line: rsold.open oldsql,"DSN=SRCGL;UID=;PWD=;"
       to this: rsold.open oldsql,"DSN=SRCGLV;UID=;PWD=;"
    Run glrestor.asp again. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in the second column the outcome of the transaction either "ok" or "failed" with an explanation of why -- if it failed.

  3. Third, modify your glrestor program by changing:
       this line: rsold.open oldsql,"DSN=SRCGLV;UID=;PWD=;"
       to this: rsold.open oldsql,"DSN=SRCGLC;UID=;PWD=;"
    Run glrestor.asp again. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in the third column the outcome of the transaction either "ok" or "failed" with an explanation of why -- if it failed.

There are 168 exam points available in the five sections shown below:

Section 2 Delete 24
Section 3 Add 48
Section 4 Modify 39
Section 5 Journal Voucher Posting 63
Section 6 Summary 12
TOTAL POINTS186

  1. Delete the following accounts from the general ledger (24 pts):

    Major Minor Sub 1 Sub 2 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    6000 1000 4000 0000      
    1900 9000 0000 0000      
    1000 5000 0000 0000      
    9999 9999 0000 0000      
    4000 3000 4000 0000      
    9100 1000 0000 0000      
    7000 1000 1000 0000      
    1000 1004 0000 0000      

  2. Add the following accounts to the general ledger (48 pts):

    Major Minor Sub 1 Sub 2 Description Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    9100 1000 0000 0000 Interest Expense      
    1000 5000 0000 0000 Cash Account Bank of Bismark SD      
    1700 3000 0000 0000 Lobby Aquarium      
    9500 1000 0000 0000 Spring Paint Job      
    9500 2000 0000 0000 Dock Electric Bill      
    9500 3000 0000 0000 Dock Security Service      
    1100 0004 0000 0000 Apple Stock      
    1100 0005 0000 0000 Alphabet Stock      
    1100 0006 0000 0000 General Motors Stock      
    9100 2000 0000 0000 MasterCard Corporate Account Upgrade      
    4000 3000 4000 0000 Rum Running Revenue      
    4000 3000 5000 0000 Spanish Main Plunder      
    4000 3000 6000 0000 Ship Salavaging Revenues      
    5000 1000 2000 0000 Direct Labor - Crows Nest Cushion Installation      
    9100 3000 0000 0000 Eyepatches Inventory      
    9100 4000 0000 0000 Peg Legs Inventory      

  3. Modify the following account descriptions (39 pts):

    Major Minor Sub 1 Sub 2 New Description Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    3000 5000 0000 0000 Paid In Capital      
    2500 1000 0000 0000 Providence Town Tax Payable      
    1000 4000 0000 0000 Petty Cash Nassau      
    5000 1000 4000 0000 Saint Kitts Dock Rental      
    5000 1000 5000 0000 Barbados Dock Rental      
    5000 1000 6000 0000 Cartagena Dock Rental      
    4000 3000 6000 0000 St. Lucia Extortion Revenue      
    9999 9999 0000 0000 Suspenseful Account      
    4000 3000 3000 0000 Brick and Mortar Store Revenues      
    8000 1000 3000 0000 Direct Labor - Ship Doctor      
    7000 1000 2000 0000 Direct Labor Looting and Burning Team      
    8000 1000 3000 0000 Scrimshaw Tools      
    9000 4000 0000 0000 Battle Plan Insurance Expense      

  4. Using your transaction system post the following journal vouchers to your general ledger system (63 pts):

    SRN:  5611 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    4000 3000 1000 0000 -18752.41 November Store Sales      
    1000 4000 0000 0000 18752.41      
    SRN:  5612 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    8000 1000 3000 0000 4512.66 Part-Time Catalog Sales Salaries      
    1000 2000 0000 0000 -4512.66        
    SRN:  5613 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 38535.33 Sold Microsoft Stock      
    1100 0003 0000 0000 -38535.33        
    SRN:  5614 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    3000 6000 0000 0000 -975.00 Clear Suspense Account      
    9999 9999 0000 0000 975.00        
    SRN:  5615 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 6000 0000 0000 -264.43 Internet Sales Refunds      
    4000 3000 1000 0000 264.43        
    SRN:  5616 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 9000 0000 0000 3272.11 Diesel Fuel Expense      
    1000 1000 0000 0000 -3272.11        
    SRN:  5661 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -4235.22 November Note Payment      
    2400 2000 0000 0000 4235.22        
    SRN:  5617 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -9123.82 Contract Programmer Labor      
    6000 1000 1000 0000 9123.82        
    SRN:  5618 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1100 0004 0000 0000 66884.88 Buy Apple Stock      
    1000 1000 0000 0000 -66800.00      
    1000 2000 0000 0000 -84.00      
    1000 3000 0000 0000 -0.88      
    SRN:  5619 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1700 1000 0000 0000 762.48 Deck Chairs      
    1000 5000 0000 0000 -762.00        
    1000 2000 0000 0000 -0.48        
    SRN:  5620 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -45000.10 Move Cash to Bismark      
    1000 5000 0000 0000 45000.01        
    SRN:  5621 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1700 3000 0000 0000 832.93 Tropical Fish for the Aquarium      
    1000 5000 0000 0000 -832.93        
    SRN:  5622 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -28452.22 Credit Cards Purchases      
    9000 2000 0000 0000 28452.22      
    SRN:  5661 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 3000 0000 0000 -45211.61 Lifeboats      
    1700 1000 0000 0000 45211.61        
    SRN:  5623 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 4000 0000 0000 14782.11 Contraband Rum Sales      
    4000 3000 4000 0000 -14782.11        
    SRN:  5628 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -457.34 Sparkling Water Dispenser      
    9000 8000 0000 0000 457.43        
    SRN:  5629 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 2000 0000 0000 -100.00 Dock Security Charges      
    9500 3000 0000 0000 100.00        
    SRN:  5630 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 2000 0000 0000 -60000.00 Buy More MS Stock      
    1100 6000 0000 0000 60000.00        
    SRN:  5638 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    4000 3000 5000 0000 -1152.33 Spanish Doubloons Sale      
    1000 3000 0000 0000 1153.23        
    SRN:  5639 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    5000 1000 1000 0000 522.71 Annual Bonuses for the Crew      
    1000 3000 0000 0000 -522.71        
    SRN:  5639 Fiscal
    Month    		  12 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9100 6000 0000 0000 175.22 Credit Card Charges      
    1000 3000 0000 0000 -175.22        

  5. After all the add, modify, deletes and journal vouchers have been processed in a column, show (12 pts):

     
      Using SRCGL as the initial glmaster  
         		  
      Using SRCGLV as the initial glmaster  
         		  
      Using SRCGLC as the initial glmaster  
     
    Final gl account count in "glmaster"

      Count=__________________
     

    		 Final gl account count in "glmaster"

      Count=__________________
     

    		 Final gl account count in "glmaster"

      Count=__________________
     

    Final journal entry count in "je"

      Count=__________________
     

    		 Final journal entry count in "je"

      Count=__________________
     

    		 Final journal entry count in "je"

      Count=__________________
     

    Final total balance from a44.asp

      $___________________
     

    		 Final total balance from a44v.aspx

      $___________________
     

    		 Final total balance from a44c.aspx

      $___________________
     
    Which Cash accounts are overdrawn?
     

      

     

    		Which Cash accounts are overdrawn?
     

      

     

    		Which Cash accounts are overdrawn?
     

      

     

  6. Print and hand in a copy of EACH your trial balance outputs after you have completed the column tasks (a44.asp, a44v.aspx, a44c.aspx).

    BE SURE TO: ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.
    BE SURE TO: SHOW THE OVERALL glmaster BALANCE.
    BE SURE TO: SHOW THE NUMBER OF ACCOUNTS IN THE glmaster TABLE.
    BE SURE TO: SHOW THE REPORT TIME AND DATE.

    Make sure ALL of your working code is uploaded and working on your server account.

    Make sure your index.htm file has working links to each assignment component (I will not grade dead links)

  7. Print and hand in the a47.asp output created at the end of each column of tasks

    BE SURE TO: ORDER THE REPORT IN ASCENDING sourceref and ASCENDING srseq ORDER.
    BE SURE TO: SHOW THE NUMBER OF JOURNAL ENTRIES IN THE je TABLE.
    BE SURE TO: SHOW THE REPORT TIME AND DATE.

  8. Print and hand in the source code for the server side programs that post the journal voucher data -- i.e., a3.asp, a3v.aspx, a3c.aspx )

SO, you will turn in 10 documents (in the following order, staple together the individual documents -- i.e, ten staples):

  1. this entire examination page (fill in the blanks at the top of the page AND all OUTCOMEs for parts 2 through 6)
  2. a44.asp output report (Full Trial Balance)
  3. a44v.aspx output report (Full Trial Balance)
  4. a44c.aspx output report (Full Trial Balance)
  5. a47.asp output je report (using the final results from using SRCGL to create glmaster)
  6. a47.asp output je report (using the final results from using SRCGLV to create glmaster)
  7. a47.asp output je report (using the final results from using SRCGLC to create glmaster)
  8. a3.asp (source code)
  9. a3v.aspx (source code)
  10. a3c.aspx (source code)

Put your name, Student Number, Database Acct # on the top page of each of the 10 documents.

IN SUMMARY: Turn in by 5:30 PM MON APR 29 to 280E MH:
  1. All exam pages with Name, Student Number, gl account, and email and outcomes of the posting entries.
  2. Output of a44.asp, a44v.aspx, a44c.aspx trial balance after posting
  3. Dump of each of the three je tables after posting (a47.asp)
  4. a3.asp, a3v.aspx, a3c.aspx (code to post journal vouchers to the glmaster)

Make sure ALL of your working code is uploaded and working on your server account.

Make sure your index.htm file has working links to each assignment component

Bind the pages so that they DO NOT fall apart.

email me at parks@uh.edu if you have issues (include your database name and pwd).