1
FIT1013 Digital Futures: IT for Enterprise
Assignment 2 Developing an application using Excel (VBA) (35%)
Half 1: Sunday, 25 September 2022, four:30 PM
Half 2: Friday, 14 October 2022, four:30 PM
Group Assignment (Most of three college students)
Half 2 Necessities
Performance
1. A consumer type named “Full Rental” shall be proven when the corresponding button in the principle menu is
clicked. It permits the main points of a group, i.e. the return of a selected gown to be recorded.
i. Every assortment is comparable to a selected gown rented (see Rental worksheet). A listing of clothes
presently rented (not returned but) shall be made out there for choice. (Be aware: RentalID N0104
with DressID 105 has two sizes, they’re thought of completely different clothes).
ii. The gathering date/time will be entered manually.
iii. Customers can choose the return situation – both Good, Broken, and Soiled.
iv. The price of the rental (together with the supply cost) shall be calculated and up to date to the
TotalAmount column.
The price of rental is calculated primarily based on the kind of gown, length of rental and a supply price.
Rental lower than 24 hours shall be charged for a day plus a supply price. For rental greater than 24
hours, the due time is 12 midday. For instance, a Kate Spade’s Flower Blossom gown is delivered at
11.30am on 23rd December, and returned on 29th December 9am shall be charged for five day solely,
price of rental is $175 x 5 days + $15 supply price, will come to a complete price of $890.
As this rental is greater than 24 hours, that is the way it seems like:
23/12/2021 11:30 – 24/12/2021 12:00 – 1 day – $175
24/12/2021 12:00 – 25/12/2021 12:00 – 1 day – $175
25/12/2021 12:00 – 26/12/2021 12:00 – 1 day – $175
26/12/2021 12:00 – 27/12/2021 12:00 – 1 day – $175
27/12/2021 12:00 – 28/12/2021 12:00 – 1 day – $175
28/12/2021 12:00 – 29/12/2021 9:00 – zero day – $zero
The column TotalAmount is calculated primarily based on the belief that just one gown is returned.
v. The shape ought to embody a ‘Full’ button that transfers the main points to the corresponding row in
the Rental worksheet, updates gown amount within the corresponding sheet, then returns to the
earlier type i.e. “Important Menu” type.
vi. Take away the highlights (e.g. yellow color) for the DateReturned, ReturnCondition and
TotalAmount columns for this rental.
vii. The deliver-collect monitoring system utilized by SAF’s driver is a cellular application that may scan the
gown code throughout assortment, and the gathering knowledge will be saved as an Excel file. An instance file
2
is given to you – “FIT1013 A2_2022_track_collect.xlsx”. The CEO of SAF, Mark want to
have a button that may import these assortment knowledge from the Excel file and switch to the Rental
worksheet (i.e. in changing the handbook steps above). Identify the button “Import from Assortment”.
(9 marks)
2. A consumer type named “Show Rental” shall be proven when the corresponding button in the principle menu is
clicked. It permits customers to decide on a buyer from an inventory, then enter a begin date and finish date. It should then
current all accomplished leases between these dates, for the chosen buyer. A button is to be included on
this consumer type for customers to print the information to a PDF file (title it as
e.g. 11203Show20220925). Design the consumer type in such a manner that it’ll show the next particulars:
The date on which the bill is produced, buyer first and final title, gown title, date rented,
date returned, return situation, rental quantity for every gown, and a grand whole for the interval.
(three marks)
High quality of Answer
Some issues:
1. Acceptable use of graphic controls and consistency within the design of your consumer kinds.
2. Appropriateness of variable and fixed declarations and utilization, e.g. are conventions adopted, are
variables declared in appropriate locations, and so forth.? Is the code concise, straightforward to learn and perceive?
three. Glorious use of determination constructions and repetition constructions.
four. Embody knowledge validation to make sure the consumer solely enters legitimate info, and report any significant
error messages.
5. Robustness – does the answer cope effectively with human errors, e.g. protected the sheet or vary which are
speculated to be learn solely by a knowledge entry clerk?
6. Use applicable indentation in your code in order that it’s simply readable. Embody applicable
documentation (or feedback) in your code.
(6 marks)
Demonstrations
Reveal your application to your tutors in Week 12.
(2 marks)
Recordsdata Supplied
● FIT1013 A2_2022_track_collect.xlsx
