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 ...