Quick Assignment Hub Logo

Discunt Sale! Upto 20% Off

Make an Order
Chris Lewis
March 22, 2022
Share Follow


Group 2387ITECH1100 Understanding The Digital Revolution


This subject will provide a broad understanding of Information Technology. It will help students to understand IT as a process that collects, stores, transports, transforms data to provide information and streamline practices. The subject will introduce students to topics like hardware, software, operating systems, input and output, data storage and manipulation, coding, networking and security, and privacy, as well as the lifecycle of data.

Learning Outcomes

1) Prepare a fundamental solution to a business issue
2) Choose the best IT solutions for your company’s needs
3) Use data visualisation and analysis software for company information
4) Create a simple programming logic diagram
5) Analyse and portray corporate data flow and procedures
6) Describe the fundamentals of programming

Assessment Details

The following scenario is fictional, and not based on any real business. Purrfect Vets is a small veterinary clinic, working with domestic companion animals. Mostly they work with dogs, cats, and smaller animals such as hamsters and rabbits. Purrfect Vets is run by a team of two veterinarians, Angela and Bridget, and one administrative staff member, Claudia.

Team Hours
Team members work in the following shift in Purrfect Vets-

Angela works 6.5 hours on Mondays, Wednesdays and Fridays

Bridget works 6.5 hours on Tuesdays and Thursdays; and

Claudia works 3.5 hours every weekday.

Angela, being the most experienced veterinarian, costs $45 per hour to employ. Bridget, as a veterinarian, costs $38 per hour to employ. Claudia costs $30 per hour to employ. These rates take into account other costs related to employment, you don’t need to add any additional offsets. All staff are also entitled to four weeks of paid annual leave, during which casual replacements are required at a cost of $49 per hour for the veterinarians and $39 per hour for Claudia. During their leave weeks, Angela, Bridget, and Claudia continue to be paid. Fixed costs such as permits, rent, and insurance are $16384 per year, and monthly utility costs (such as electricity and gas) are $390 per month.

Task 1 Wages and Fixed Cost

Using Excel, create a spreadsheet that calculates the projected annual outgoing costs of running Purrfect Vets. Your spreadsheet should be configured such that the working hours, hourly rates, and annual and monthly costs can be varied easily.
History Data
This data includes a date, the consultation type, the animal type, the expenses incurred (such as tests, protective equipment, and so on) and the price charged.

Your First Order

Get 20% OFF!

Order Now

Task 2 Analysis

Support your claims using appropriate analysis or data visualisation (approximately 150-200 words).

Task 3 History Visualisation

Describe your approach and your findings in your report (approximately 200-300 words). Include your visualisations as images. Be sure to use appropriate titles and labels.

Task 4 Price Consistency

Using Excel, analyse the historical data you have available, and create a spreadsheet that allows Claudia to enter the animal type and consultation type, and gives a quote amount. Ensure that your spreadsheet is usable – it should be simple and include appropriate text and formatting to make your spreadsheet easy to use by a member of the Purrfect Vets team It is up to you to determine an appropriate quoting method, however it’s vital that the new system doesn’t lose money compared to the previous approach. Describe and justify your approach in your report (approximately 150 words).

Deliverd orders
Client Ratings

Task 5 Process Improvement

Research the consultation process used in a typical veterinary clinic. Make sure you reference any sources, or indicate if you are basing your work on personal knowledge. Using BPMN swimlane diagrams, show how the spreadsheet you created in Task 4 can be applied to improve the processes at Purrfect Vets. Justify your approach in your report.

Your First Order

Get 20% OFF!

Subscription Form

Share Follow Us

Quick Assignment Hub Offer Scaled

Quick Assignment Hub opened an office in London & Sydney, on the premise that students are frequently too busy with their daily responsibilities.

© Copyright Quick Assignment Hub All rights reserved.