1
\nFIT1013 Digital Futures: IT for Enterprise
\nAssignment 2 Developing an application using Excel (VBA) (35%)
\nHalf 1: Sunday, 25 September 2022, four:30 PM
\nHalf 2: Friday, 14 October 2022, four:30 PM
\nGroup Assignment (Most of three college students)
\nHalf 2 Necessities
\nPerformance
\n1. A consumer type named \u201cFull Rental\u201d shall be proven when the corresponding button in the principle menu is
\nclicked. It permits the main points of a group, i.e. the return of a selected gown to be recorded.
\ni. Every assortment is comparable to a selected gown rented (see Rental worksheet). A listing of clothes
\npresently rented (not returned but) shall be made out there for choice. (Be aware: RentalID N0104
\nwith DressID 105 has two sizes, they’re thought of completely different clothes).
\nii. The gathering date\/time will be entered manually.
\niii. Customers can choose the return situation \u2013 both Good, Broken, and Soiled.
\niv. The price of the rental (together with the supply cost) shall be calculated and up to date to the
\nTotalAmount column.
\nThe price of rental is calculated primarily based on the kind of gown, length of rental and a supply price.
\nRental lower than 24 hours shall be charged for a day plus a supply price. For rental greater than 24
\nhours, the due time is 12 midday. For instance, a Kate Spade\u2019s Flower Blossom gown is delivered at
\n11.30am on 23rd December, and returned on 29th December 9am shall be charged for five day solely,
\nprice of rental is $175 x 5 days + $15 supply price, will come to a complete price of $890.<\/p>\n
As this rental is greater than 24 hours, that is the way it seems like: 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\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7724,7725,7726,7548,7723,7728,7727,7729],"tags":[1400,613,142,7594,1394,7598,7595,7593,7597,7599,7601,7590,7596,133,7655,7656,7591,7592],"class_list":["post-65006","post","type-post","status-publish","format-standard","hentry","category-best-dissertation-writing-services","category-best-research-paper-writing-services","category-college-paper-writing-service-cheap","category-dissertation-writing-services-cost","category-dissertation-writing-services-near-me","category-dissertation-writing-services-reviews","category-legit-research-paper-writing-services","category-thesis-writing-services","tag-best-custom-essay-writing-services","tag-best-dissertation-writing-services-uk","tag-best-online-essay-writing-services","tag-cheap-custom-essay-writing-services","tag-custom-research-paper-writers","tag-custom-research-papers-writing-service","tag-essay-writer-websites","tag-essay-writing-service-quality-cheap","tag-free-research-paper-writing-service","tag-help-me-write-a-research-paper","tag-i-need-help-with-my-dissertation","tag-professional-dissertation-writing-service","tag-quick-essay-writing-service","tag-research-paper-writing-service-cheap","tag-service-writing-my-essay-write-custom","tag-someone-to-write-my-paper","tag-top-rated-dissertation-writing-services","tag-top-uk-dissertation-writing-services"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/65006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=65006"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/65006\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=65006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=65006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=65006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n23\/12\/2021 11:30 – 24\/12\/2021 12:00 – 1 day – $175
\n24\/12\/2021 12:00 – 25\/12\/2021 12:00 – 1 day – $175
\n25\/12\/2021 12:00 – 26\/12\/2021 12:00 – 1 day – $175
\n26\/12\/2021 12:00 – 27\/12\/2021 12:00 – 1 day – $175
\n27\/12\/2021 12:00 – 28\/12\/2021 12:00 – 1 day – $175
\n28\/12\/2021 12:00 – 29\/12\/2021 9:00 – zero day – $zero
\nThe column TotalAmount is calculated primarily based on the belief that just one gown is returned.
\nv. The shape ought to embody a \u2018Full\u2019 button that transfers the main points to the corresponding row in
\nthe Rental worksheet, updates gown amount within the corresponding sheet, then returns to the
\nearlier type i.e. \u201cImportant Menu\u201d type.
\nvi. Take away the highlights (e.g. yellow color) for the DateReturned, ReturnCondition and
\nTotalAmount columns for this rental.
\nvii. The deliver-collect monitoring system utilized by SAF\u2019s driver is a cellular application that may scan the
\ngown code throughout assortment, and the gathering knowledge will be saved as an Excel file. An instance file
\n2
\nis given to you \u2013 \u201cFIT1013 A2_2022_track_collect.xlsx\u201d. The CEO of SAF, Mark want to
\nhave a button that may import these assortment knowledge from the Excel file and switch to the Rental
\nworksheet (i.e. in changing the handbook steps above). Identify the button \u201cImport from Assortment\u201d.
\n(9 marks)
\n2. A consumer type named \u201cShow Rental\u201d shall be proven when the corresponding button in the principle menu is
\nclicked. It permits customers to decide on a buyer from an inventory, then enter a begin date and finish date. It should then
\ncurrent all accomplished leases between these dates, for the chosen buyer. A button is to be included on
\nthis consumer type for customers to print the information to a PDF file (title it as
\ne.g. 11203Show20220925). Design the consumer type in such a manner that it’ll show the next particulars:
\nThe date on which the bill is produced, buyer first and final title, gown title, date rented,
\ndate returned, return situation, rental quantity for every gown, and a grand whole for the interval.
\n(three marks)
\nHigh quality of Answer
\nSome issues:
\n1. Acceptable use of graphic controls and consistency within the design of your consumer kinds.
\n2. Appropriateness of variable and fixed declarations and utilization, e.g. are conventions adopted, are
\nvariables declared in appropriate locations, and so forth.? Is the code concise, straightforward to learn and perceive?
\nthree. Glorious use of determination constructions and repetition constructions.
\nfour. Embody knowledge validation to make sure the consumer solely enters legitimate info, and report any significant
\nerror messages.
\n5. Robustness – does the answer cope effectively with human errors, e.g. protected the sheet or vary which are
\nspeculated to be learn solely by a knowledge entry clerk?
\n6. Use applicable indentation in your code in order that it’s simply readable. Embody applicable
\ndocumentation (or feedback) in your code.
\n(6 marks)
\nDemonstrations
\nReveal your application to your tutors in Week 12.
\n(2 marks)
\nRecordsdata Supplied
\n\u25cf FIT1013 A2_2022_track_collect.xlsx<\/today\u2019s><\/customerid><\/p>\n","protected":false},"excerpt":{"rendered":"