The template
topicsearch could not be loaded. HTTP Status code: 0
PRINCIPLES OF BUSINESS COMPUTING INF550 Principles of Business Computing INF550 Principles of Business Computing The paper attempts to presents the principles of business computing in a holistic context. It focuses on the use of MS Excel as well as MS Access in attempting to record, organize and interpret information for business purposes. The paper is basically a presentation of customer purchases of the packages being offered by Maya's Travel Agency. TASK 1: EXCEL SPREADSHEET Difference of Embedding and Linking The basic difference between the concept of embedding an object, a chart in this case, or linking an object lies in the source of data storage and whether or not it will be updated if changed are made in the actual object. If a chart is embedded into the word document, it will not be updated if the source table, from where the data is being used for the creation of the chart, is updated; however, if the chart is linked, the chart will be updated in accordance with the changes made in the source table. The tables are presented on the next page. Current Date Wednesday, May 30, 2012 S/n Customer ID CustomerLast Name Package PackageCost (Each) FlightCost (Each) FlightNeeded Numberof People Total Cost DownPayment BalanceLeft MonthlyPayments Per Person For Group 1 10034 Nelson Taupo Getaway 375 350 Yes 2 725 1450 145 1305 $112.02 2 3421 Desai Hamner Getaway 400 350 Yes 2 750 1500 150 1350 $115.88 3 12123 Saxer Wellington Getaway 175 300 Yes 4 475 1900 190 1710 $146.78 4 23901 Tran Queenstown Cruise (4-Day) 300 275 No 2 300 600 60 540 $46.35 5 12012 Salinas Taupo Getaway 375 350 Yes 4 725 2900 290 2610 $224.03 6 20301 Burns Wellington Getaway 175 300 Yes 4 475 1900 190 1710 $146.78 7 20310 Crockett Auckland Weekend 175 250 No 2 175 350 35 315 $27.04 8 12314 Nelson Queenstown Cruise (4-Day) 300 275 Yes 2 575 1150 115 1035 $88.84 9 12345 White Hamner Getaway 400 350 No 5 400 2000 200 1800 $154.51 10 20154 Jackson Auckland Weekend 175 250 Yes 3 425 1275 127.5 1147.5 $98.50 11 11120 Anderson Queenstown Cruise (4-Day) 300 275 No 2 300 600 60 540 $46.35 12 20091 Austin Auckland Weekend 175 250 Yes 1 425 425 42.5 382.5 $32.83 13 12540 Martin Queenstown Cruise (4-Day) 300 275 No 6 300 1800 180 1620 $139.06 14 3567 Johnson Taupo Getaway 375 350 No 4 375 1500 150 1350 $115.88 15 21893 Morris Queenstown Cruise (4-Day) 300 275 Yes 5 575 2875 287.5 2587.5 $222.10 \ Package Count Maximum Minimum Average Median TOTAL Auckland Weekend 3 $1,275.00 $350.00 $683.33 $425.00 $2,050.00 Hamner Getaway 2 $2,000.00 $1,500.00 $1,750.00 $1,750.00 $3,500.00 Queenstown Cruise (4-Day) 5 $2,875.00 $600.00 $1,405.00 $1,150.00 $7,025.00 Taupo Getaway 3 $2,900.00 $1,450.00 $1,950.00 $1,500.00 $5,850.00 Wellington Getaway 2 $1,900.00 $1,900.00 $1,900.00 $1,900.00 $3,800.00 TOTAL 15 $10,950.00 $5,800.00 $7,688.33 $6,725.00 $22,225.00 Current Date =NOW() Sr/n Customer ID CustomerLast Name Package PackageCost (Each) FlightCost (Each) =IF(C6="","",1) 10034 Nelson Taupo Getaway =IF(E6="","",VLOOKUP(E6,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E6="","",VLOOKUP(E6,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C7="","",B6+1) 3421 Desai Hamner Getaway =IF(E7="","",VLOOKUP(E7,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E7="","",VLOOKUP(E7,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C8="","",B7+1) 12123 Saxer Wellington Getaway =IF(E8="","",VLOOKUP(E8,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E8="","",VLOOKUP(E8,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C9="","",B8+1) 23901 Tran Queenstown Cruise (4-Day) =IF(E9="","",VLOOKUP(E9,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E9="","",VLOOKUP(E9,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C10="","",B9+1) 12012 Salinas Taupo Getaway =IF(E10="","",VLOOKUP(E10,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E10="","",VLOOKUP(E10,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C11="","",B10+1) 20301 Burns Wellington Getaway =IF(E11="","",VLOOKUP(E11,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E11="","",VLOOKUP(E11,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C12="","",B11+1) 20310 Crockett Auckland Weekend =IF(E12="","",VLOOKUP(E12,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E12="","",VLOOKUP(E12,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C13="","",B12+1) 12314 Nelson Queenstown Cruise (4-Day) =IF(E13="","",VLOOKUP(E13,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E13="","",VLOOKUP(E13,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C14="","",B13+1) =IF(E14="","",VLOOKUP(E14,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E14="","",VLOOKUP(E14,'Data Set'!$B$16:$E$20,4,FALSE)) =IF(C15="","",B14+1) =IF(E15="","",VLOOKUP(E15,'Data Set'!$B$16:$E$20,3,FALSE)) =IF(E15="","",VLOOKUP(E15,'Data Set'!$B$16:$E$20,4,FALSE)) FlightNeeded Numberof People Total Cost DownPayment BalanceLeft MonthlyPayments Per Person For Group Yes 2 =IF(C6="","",IF(H6="Yes",F6+G6,F6)) =IF(C6="","",J6*I6) =IF(K6="","",K6*10%) =IF(K6="","",K6-L6) =IF(M6="","",PMT(0.055/12,12,M6)*-1) Yes 2 =IF(C7="","",IF(H7="Yes",F7+G7,F7)) =IF(C7="","",J7*I7) =IF(K7="","",K7*10%) =IF(K7="","",K7-L7) =IF(M7="","",PMT(0.055/12,12,M7)*-1) Yes 4 =IF(C8="","",IF(H8="Yes",F8+G8,F8)) =IF(C8="","",J8*I8) =IF(K8="","",K8*10%) =IF(K8="","",K8-L8) =IF(M8="","",PMT(0.055/12,12,M8)*-1) No 2 =IF(C9="","",IF(H9="Yes",F9+G9,F9)) =IF(C9="","",J9*I9) =IF(K9="","",K9*10%) =IF(K9="","",K9-L9) =IF(M9="","",PMT(0.055/12,12,M9)*-1) Yes 4 =IF(C10="","",IF(H10="Yes",F10+G10,F10)) =IF(C10="","",J10*I10) =IF(K10="","",K10*10%) =IF(K10="","",K10-L10) =IF(M10="","",PMT(0.055/12,12,M10)*-1) Yes 4 =IF(C11="","",IF(H11="Yes",F11+G11,F11)) =IF(C11="","",J11*I11) =IF(K11="","",K11*10%) =IF(K11="","",K11-L11) =IF(M11="","",PMT(0.055/12,12,M11)*-1) No 2 =IF(C12="","",IF(H12="Yes",F12+G12,F12)) =IF(C12="","",J12*I12) =IF(K12="","",K12*10%) =IF(K12="","",K12-L12) =IF(M12="","",PMT(0.055/12,12,M12)*-1) Yes 2 =IF(C13="","",IF(H13="Yes",F13+G13,F13)) =IF(C13="","",J13*I13) =IF(K13="","",K13*10%) =IF(K13="","",K13-L13) =IF(M13="","",PMT(0.055/12,12,M13)*-1) =IF(C14="","",IF(H14="Yes",F14+G14,F14)) =IF(C14="","",J14*I14) =IF(K14="","",K14*10%) =IF(K14="","",K14-L14) =IF(M14="","",PMT(0.055/12,12,M14)*-1) =IF(C15="","",IF(H15="Yes",F15+G15,F15)) =IF(C15="","",J15*I15) =IF(K15="","",K15*10%) =IF(K15="","",K15-L15) =IF(M15="","",PMT(0.055/12,12,M15)*-1) Package Count Maximum Minimum Average Median TOTAL Auckland Weekend =COUNTIF($E$6:$E$20,E26) =MAX(K12,K15,K17) =MIN(K12,K15,K17) =AVERAGE(K12,K15,K17) =MEDIAN(K12,K15,K17) =SUM(K12,K15,K17) Hamner Getaway =COUNTIF($E$6:$E$20,E27) =MAX(K7,K14) =MIN(K7,K14) =AVERAGE(K7,K14) =MEDIAN(K7,K14) =SUM(K7,K14) Queenstown Cruise (4-Day) =COUNTIF($E$6:$E$20,E28) =MAX(K9,K13,K16,K18,K20) =MIN(K9,K13,K16,K18,K20) =AVERAGE(K9,K13,K16,K18,K20) =MEDIAN(K9,K13,K16,K18,K20) =SUM(K9,K13,K16,K18,K20) Taupo Getaway =COUNTIF($E$6:$E$20,E29) =MAX(K6,K10,K19) =MIN(K6,K10,K19) =AVERAGE(K6,K10,K19) =MEDIAN(K6,K10,K19) =SUM(K6,K10,K19) Wellington Getaway =COUNTIF($E$6:$E$20,E30) =MAX(K8,K11) =MIN(K8,K11) =AVERAGE(K8,K11) =MEDIAN(K8,K11) =SUM(K8,K11) TOTAL =SUM(F26:F30) =SUM(G26:G30) =SUM(H26:H30) =SUM(I26:I30) =SUM(J26:J30) =SUM(K26:K30) TASK 2: ACCESS DATABASE Database Plan in Word Purpose of Database Databases are designed for the purpose of managing information. The three main purposes of databases are to organizing, storing and most importantly retrieving the information in the manner required. The efficiency of the database to store data will be of no use if it fails to retrieve the information when required. Thus, a database should have the capacity to store, organize and retrieve information as per requirements. The tables used for the purpose of designing database are presented on the next page. Designing Tables THE PURCHASE TABLE Field Name Data Type Description RetailerID Text The retailer ID is field that distinguishes records. It has to be entered in the format 1234-56 ProductCode Text The product code is field for identifying the product type. It has to be entered in the format 1234 PurchaseDate Date/Time The date of purchase. HowManyBought Number The number of the product bought. THE RETAILER TABLE Field Name Data Type Description RetailerID Text The retailer ...
Related Ads
www.researchomatic.com... Case Study: Amazons New Store Utility Computing ...
www.researchomatic.com... On the one hand, for demonstration, computer ...
www.researchomatic.com... The company's portfolio of offerings comp ...
www.researchomatic.com... Cloud Computing is ideal for businesses ...
www.researchomatic.com... Accounting 1- Principles of Financial Account ...
The template
footersearch could not be loaded. HTTP Status code: 0
© Copyright 2013-2022 Researchomatic. All rights reserved
The template
disclaimer could not be loaded. HTTP Status code: 0