首页
网站开发
桌面应用
管理软件
微信开发
App开发
嵌入式软件
工具软件
数据采集与分析
其他
首页
>
> 详细
IS2022代做、代写C++,Java程序
项目预算:
开发周期:
发布时间:
要求地区:
IS2022 Business Programming with Spreadsheet
▪ City University of Hong Kong ▪ Department of Information Systems ▪ IS2022 ▪ 1/2
Individual Assignment (8%)
Develop a professional error-free application using MS Excel and VBA to calculate fees
and charges for a golf club.
The ISmart Golf Course (IGC) is a public golf course that requires players to take the Golf
Course Ferry from the designated pier. The round-trip ferry price are as follow: $85 for
regular users, $40 for junior (under 12 years of age), and $40 for senior (60 years of age
and over).
IGC offers three exceptional public golf courses in Asia: the East Course, North Course,
and South Course. Players must reserve a course at least one week in advance. The
individual course fees are provided in Table 1. The golf course also offers a variety of golf
tuition programs for beginners to advanced golfers. The tuition fees include the golf course
charges, and the details can be found in Table 2. Optional equipment hire services are also
available.
You may copy the fee tables to MS Excel in order to calculate fees and charges accurately.
Create a button on the worksheet to initiate your application. Develop a Sub procedure in
a Module with appropriate variables, or constants, and data types to calculate the total
amount a golf player needs to pay, considering tuition, fees or charges. Use Input box
functions (traditional input boxes, NOT Input box methods; NO userform is required) to
prompt the user for mandatory information, such as reservation date, player’s full name,
gender, and player status (regular junior/senior, HKID card holder or non-HKID card holder).
The user should also indicate whether they want to reserve a golf course or register a
lesson.
If the user wants to reserve a golf course, they will enter the corresponding code for the
desired course, as listed in Table 1. If the user is booking a lesson, there is no need to
reserve a golf course. Instead, they will enter appropriate tuition code from Table 2. The
User may also reserve equipment by entering the corresponding hire code(s) from Table 3.
The application and input boxes should incorporate appropriate data validation and error
handling mechanisms to avoid abrupt termination, and input errors or execution errors. The
application should calculate the fees and display the results in a message box. The
message box should display the player’s full name, a breakdown of charges and fees, and
the total fees formatted with appropriate currency format, icon, title and current date.
If the user chooses to retry after viewing the result message box, the application should
display all the input boxes again and repeat the process. If the user chooses to cancel, the
application should terminate.
Your task is to develop a comprehensive and user-friendly application that accurately
calculates fees and charges for the golf club, incorporate proper validation, error handling,
and user interaction features.
Assessment criteria of the individual assignment will be based on your ability to perform
the criteria above in terms of the followings:
o Write macros (sub procedures) using VBA in Microsoft Excel.
o Use appropriate data types to declare variables and/or constants.
o Use appropriate input box functions to capture user input with data validation rules and
error handling mechanisms.
IS2022 Business Programming with Spreadsheet
▪ City University of Hong Kong ▪ Department of Information Systems ▪ IS2022 ▪ 2/2
o Use repetition, decision and/or selection structures in VBA code.
o Use message box with appropriate prompt to display results correctly.
Save your file as IndAssign_
.xlsm
Submission deadline: 14 April 2024, (Week 12 Sunday) 11:59 pm
Please check and confirm the file you submit on Canvas is correct and complete
before the submission deadline.
Incomplete or late submission will result in 0 mark.
Fee Tables:
Table 1: Green Fee
Regular
G01 East Course (18 holes) $1,200
G02 South/North Course (18 holes) $980
G03 South Course (9 holes) $550
Senior (60 years of age and over)
G04 East Course (18 holes) $850
G05 South/North Course (18 holes) $750
G06 South Course (9 holes) $380
Junior (Under 21 years of age)
G07 East Course (18 holes) $475
G08 South/North Course (18 holes) $450
G09 South Course (9 holes) $250
Regular (non-HKID Card Holder)
G10 East Course (18 holes) $1,600
G11 South/North Course (18 holes) $1,300
G12 South Course (9 holes) $800
Junior non-HKID Card Holder (Under 21 years of age)
G13 East Course (18 holes) $675
G14 South/North Course (18 holes) $650
G15 South Course (9 holes) $350
Table 2: Golf Tuition
Regular Per Person
T01 Introduction (8 hours) $2,200
T02 On Course Lesson (4 hours) $1,200
T03 Golf Pass (8 hours) $2,500
T04 Private Tuition Fee with Head Golf Professional $4,000
Junior (Under 21 years of age) Per Person
T05 Junior Group Lesson $600
T06 Junior Private Tuition Fee (3 hours) $1,000
Table 3: Hire Service
H01 Set of Golf Club (Premium) $500
H02 Hire Center Golf Bag Storage $40
H03 Private Locker – Annual rate* $4,000*
H04 Golf Bag Carrier $340
软件开发、广告设计客服
QQ:99515681
邮箱:99515681@qq.com
工作时间:8:00-23:00
微信:codinghelp
热点项目
更多
cis432代做、代写python/java程...
2024-05-04
eeen3007j代写、c++程序设计代...
2024-05-04
代写data程序、代做c/c++, jav...
2024-05-04
comp2006代做、代写c++程序语言
2024-05-04
comp26020代做、java/c++设计编...
2024-05-04
csci251 advanced programming...
2024-05-03
cs 6290: high-performance co...
2024-05-03
assignment 2: executing and ...
2024-05-03
ecse427/comp310 programmin...
2024-05-03
cs 452 (fall 22): operating...
2024-05-03
comp9414 23t2 assignment 2 ...
2024-05-03
dpst1091 23t1 assignment 2 ...
2024-05-03
program代做、代写python设计编...
2024-05-03
热点标签
finm8007
comp2006
comp26020
comp1721
eeen3007j
cis432
csci251
comp5125m
com398sust
32022
mth6158
comp328
finn41615
2024
mec302
mgmt3004
mgt7158
com160
as.640.440
econ3016
finm7405
econ7021
fin600
infs4205/7205
mktg2510-
f27sb
csse2310/csse7231
rv32i
eecs 113
comp1117b
cs 412
comp 315
econ7300
comp2017
ecs 116
fit5046
com6511
comp30024
acs341
econ1020
isys3014
acc408
comp1047
csc 256
cs 6347
finm7008
comp34212
csmde21
estr2520
comp285/comp220
mds5130/iba6205
finc6010
is3s665
busi2194
125.785
iom209
msin0041
econ339
cmt218
mast10007
comp5349
ecx2953/ecx5953
bios706
comp3310
mth6150
comp30027
comp20005
eec286
busi2211
bff2401
fnce90046
visu2001
mang6554
finc6001
125785
data423-24s1
engi 1331
fint2100
(520|600).666
can202
cs 61b
mast20029
info20003
stat512
econ3208
cmpsc311
engg1340
ecmt1010
fit5216
basc0003
ee3121
acct2002
comp5313
busi2131
ise529
elec372/472
csit940/csit440
cenv6141
comp3027/comp3927
ftec5580
comp1433
msci223
mark203
en3098
eden1000
ece6483
econ4410
mats16302
cs 6476
com6521
comp222
comp3211
comp10002
csc1002
chc6186
cs 161
comp27112
comp282
swen20003
comm1190
elec9764
acfi3308
acct7101
fin6035
comp2048
geog0163
comp2013
coen 146
dts101tc
sehh2042
comp30023
comp4880/8880
cs 455
07
stat0045.
fil-30023
celen085
psyc40005
math40082
are271
comp9311
ee5311
imse2113
comp 2322
acct2102
fnd109
int102
is3s664
is6153
data4000
accfin5034
fit5212
cs536-s24
fit5225
ecos3006
mes202tc
finc5001
stat3061
csc171
cs1b
7ssmm712
bu.450.760
cs170
comp3411
swen90004
cpt206
comp5313/comp4313—large
bl5611
kxo206
comp532
elec207
kxo151
cs 2820
cpt108
math2319
dts204tc
qm222
comp2511
ccs599
infs1001
mat2355
eeee4123
25721
ifn647
pols0010
hpm 573
qbus6860
comp9417
csci 1100
stat0023
cse340
comp2003j
cs 2550
cs360
fin 3080
ierg 4080
cs6238
cit 594
finm7406
hw6
联系我们
- QQ: 9951568
© 2021
www.rj363.com
软件定制开发网!