MIS 4372 -- PARKS -- FINAL EXAM -- FALL 2017

Name_________________________________________________________

Last 4 Digits of your PSID_________________disc-nt Server Acct__________________ (glxxxx)

e-mail address___________________________________________________

EXAM TO BE RETURNED BY 5:30 PM MON DEC 4 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 174 exam points available: Delete 24; Add 39; Modify 39; Post 60; Summary 12)

  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
    1100 0004 0000 0000      
    1000 4000 0000 0000      
    6000 1000 3000 0000      
    9000 9000 0000 0000      
    4000 3000 3000 0000      
    7000 1000 4000 0000      
    8000 1000 1000 0000      
    9999 9999 0000 0000      

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

    Major Minor Sub 1 Sub 2 Description Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    1100 0004 0000 0000 Investments      
    2400 2000 0000 0000 Texas Sales Tax Payable      
    2400 3000 0000 0000 Harris County Property Tax Payable      
    1000 5000 0000 0000 Cash Bank of St. Louis      
    1700 1000 0000 0000 Furniture and Fixtures      
    1900 3000 0000 0000 Prepaid Interest      
    1100 0004 0000 0000 Facebook Stock      
    1100 0006 0000 0000 Target Stock      
    9100 2000 0000 0000 New Propeller for the Yacht      
    1000 6000 0000 0000 Cash California Bank, Stockton Branch      
    4000 3000 5000 0000 Yacht Sails Sale      
    4000 3000 4000 0000 Holiday Liquidation Sale Revenue      
    5000 1000 4000 0000 Direct Labor - Tar and Feather Crew      
    9100 4000 0000 0000 Seamen Belt Buckle Expense      
    7000 1000 5000 0000 Contract Programmer Expenses      

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

    Major Minor Sub 1 Sub 2 New Description Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    7000 1000 4000 0000 US Centers Total Expense      
    3000 5000 0000 0000 PIC      
    1000 5000 0000 0000 Cash American Bank of East St. Louis      
    9000 9000 0000 0000 Electric Power Expense      
    9100 1000 0000 0000 Bank Credit Card Interest Expense      
    4000 3000 3000 0000 Web Site Sales      
    9999 9999 0000 0000 Suspense Account      
    4000 3000 2000 0000 Houston Store Sales      
    8000 1000 3000 0000 Direct Labor - Contract Programmers      
    7000 1000 3000 0000 Direct Labor Temporary Officers      
    8000 1000 7000 0000 Direct Labor Navigator Fees      
    9100 2000 0000 0000 New Office Sign      
    9000 8000 0000 0000 Sanitation Expense      

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

    SRN:  4211 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    4000 3000 5000 0000 -316.83 Xmas Sale Reveunue      
    1000 4000 0000 0000 316.83      
    SRN:  4212 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    8000 1000 1000 0000 6230.01 Hacker ransom      
    1000 3000 0000 0000 -6230.01        
    SRN:  4213 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 2000 0000 0000 -45505.71 Buy More Target Stock      
    1100 0006 0000 0000 45505.71        
    SRN:  4214 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    3000 5000 0000 0000 -974.10 Clear the Suspense Account      
    9999 9999 0000 0000 974.10        
    SRN:  4215 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 1037.81 Yacht Sail Advertising Rental      
    4000 3000 5000 0000 -1037.81        
    SRN:  4216 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 8000 0000 0000 134.92 Garbage Expense      
    1000 1000 0000 0000 -134.92        
    SRN:  4271 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 4000 0000 0000 -328.44 Repayment      
    2400 2000 0000 0000 328.44        
    SRN:  4217 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -3.43 Welcome Mat Expense      
    6000 1000 2000 0000 3.48        
    SRN:  4218 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1100 0007 0000 0000 1378.20 Buy Twitter Stock      
    1000 1000 0000 0000 -1300.20      
    1000 2000 0000 0000 -70.00      
    1000 3000 0000 0000 -8.00      
    SRN:  4219 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1700 1000 0000 0000 19.53 New Green Stapler      
    1000 6000 0000 0000 -19.35        
    1000 2000 0000 0000 -0.20        
    SRN:  4220 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -371.21 Move Cash to Hawaii      
    1000 5000 0000 0000 371.21        
    SRN:  4221 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 6000 0000 0000 242.19 Long Distance Phone Bill      
    1000 3000 0000 0000 -224.19        
    SRN:  4222 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 -530.20 Limo Rental Expense      
    9000 2000 0000 0000 -530.20      
    SRN:  4271 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -14.15 Bought New Wall Clock      
    1700 1000 0000 0000 14.15        
    SRN:  4223 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 6000 0000 0000 -2145.12 New iPhone 11 prototype      
    9000 6100 0000 0000 2145.12        
    SRN:  4228 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -39.32 Party Hats for the Office Party      
    9000 5000 0000 0000 38.32        
    SRN:  4229 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 4000 0000 0000 -3330.21 Cashier Bonuses      
    5000 1000 3000 0000 3330.21        
    SRN:  4230 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 200750.00 Sell Stock      
    1100 0003 0000 0000 -200750.00        
    SRN:  4238 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    4000 3000 3000 0000 -54.02 Gangplank Salvage Sales      
    1000 3000 0000 0000 54.02        
    SRN:  4239 Fiscal
    Month    		  7 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    5000 1000 1000 0000 221.01 Vacation Bonuses for the Store Crew      
    1000 2000 0000 0000 -221.01        

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

    final gl account count in "glmaster"
    (using SRCGL as the initial glmaster)    		 final gl account count in "glmaster"
    (using SRCGLV as the initial glmaster)    		 final gl account count in "glmaster"
    (using SRCGLC as the initial glmaster)
     
    Count=__________________
         		  
    Count=__________________
         		  
    Count=__________________
     
    final journal entry count in "je"
    (using SRCGL as the initial glmaster)    		 final journal entry count in "je"
    (using SRCGLV as the initial glmaster)    		 final journal entry count in "je"
    (using SRCGLC as the initial glmaster)
     
    Count=__________________
         		  
    Count=__________________
         		  
    Count=__________________
     
    final total balance from a44.asp final total balance from a44v.aspx final total balance from a44c.aspx
     
    $___________________
         		  
    $______________________
         		  
    $_____________________
     
    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 DEC 4 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).