回到网站

University of Technology Sydney 22574

22574: ACCOUNTING INTELLIGENCE

· 案例展示

University of Technology Sydney
UTS Business School
Accounting Discipline Group
The Government HEALTH Project
CASE STUDY – GROUP ASSIGNMENT
22574: ACCOUNTING INTELLIGENCE
(SPRING 2020)
Group Letter: ________
Group Name: ___________________________
Note: Books, course notes, individual notes, the WWW., etc may be consulted.
22574 AI Case Study: The Government Health Project Spring 2020
© ML Ossimitz 2
1. General Information
1.1. Task Overview
The 22574 Accounting Intelligence Spring 2020 group assignment refers to the case study specification
below.
The ability to design and implement a database, generate reports and work as a team reflects the practice
of accountants in this assignment, which contributes to the graduate attributes, business knowledge and
concepts, analytical skills, communication, and interpersonal skills, attitudes and values, as well as
business practice-oriented skills.
The group assignment requires students to discuss/solve problems, design/implement a database and
generate reports using a mainstream database software (MS Access). Each group also has to submit a
Project Management Report.
1.2. Deliverables
1.2.1. MS Access File and Reports
Each group has to design a database and is responsible for the quality of implementation. The lecturer will
assess the performance of the groups based on the design, implementation, process, and quality of
reports that have to be produced. The formal quality of the reports does have an impact on the mark. The
case study assignment also assesses students' problem-solving capacity and teamwork capability.
The final database and additional legacy files (MS Excel/Word, etc.) created have to be submitted through
UTSOnline.
1.2.2. Group Assignment Report
Each group has to prepare and submit a Project Management Report (1,500 to 2,000-word exclusive (a)
(d) and (e)) which consists of:
(a) a signed cover sheet which includes the standard content like subject name, subject number, date,
group letter, etc . as well as a word count and the following statement of plagiarism and copyright
I have read and understood the statement of plagiarism and copyright in the subject outline. I'm fully
aware that plagiarism and other breaches of academic integrity will be penalised when proven,
following the UTS Student Rules. I declare solemnly that my contribution to this group assignment is
neither copied nor plagiarised.
Student ID – Student Name – Student Signature
(b) a response to the specific tasks /documentation requirements/questions raised in the case study
specifications
(c) assumptions made, anything notable, problems encountered and solutions found,
(d) any team management issues occurring during the project, the experience of each team member /
the whole team of doing the group assignment (“lessons learned” statement), what worked well in
your team (at least 3 items) and what would you change/improve next time (at least 2 items) and
contribution of each team member to the overall project, and
(e) an appendix which contains screenshots of all query definitions and the first two pages of all report
outputs.
22574 AI Case Study: The Government Health Project Spring 2020
© ML Ossimitz 3
1.2.3. Submission and Due Dates
a) Submission
All documents, database, and files have to be submitted through UTSOnline. In the subject 22574 AI, under
Assignment and Case Study folders are set up for the submission of (i) Database and files, (ii) Project
Management Report. The plagiarism software TurnITin is used to evaluate the authenticity of the work,
and (iii) Google Form (Teamwork). The MS Access Database and Project Management Report are group
submissions, the Google Form is an individual submission. Each student will need to fill it out at the end
of the group assignment.
A penalty of 10% of the overall marks per day will apply for late submissions.
b) Due Dates
MS Access File, Group Assignment Report and Google Form (Teamwork)
The MS Access file (including additional files created), and the Project Management Report are due at
10:00 pm on Thursday 8 October 2020.
Please Note:
• Submission per email will not be accepted.
• Each group member has to contribute adequately to the case study assignment.
• Each group member has to sign the cover sheet.
• The subject coordinator reserves the right to adjust the group members’ case study marks in case
of clearly unequal contributions.
1.2.4. Procedure – Notes - Protocol
Groups of 3 to 4 students have to be formed by week 4. Students are free to choose their group members
themselves, and the lecturer will only intervene in case of problems (incl. students ‘left-over’ by week 5).
The group work assignment instruction will be distributed in class in week 5.
Group work and group assignments are an important part of business education. The purpose of group
work goes beyond the requirement of the group project itself. Group work is also intended to develop an
awareness of the dynamics of teamwork and your role in a team environment. In undertaking group work
it is expected that each team member will communicate with other team members professionally and
courteously. Resolving any conflict or difficulties that arise within the team is also part of the group
dynamics that may emerge during the project. It is expected that each team member will take
responsibility for managing and resolving any conflict that may arise. If the team members are unable to
resolve tensions or conflicts then this MUST be discussed with the lecturer as soon as it becomes obvious
that a resolution within the team cannot be reached.
In the learning environment of group work, we are seeking to ensure that you develop and demonstrate
both academic skills and important group work skills such as:
• Commitment to working with others (e.g. undertaking a fair share of the work, sharing ideas, doing
the tasks allocated, attending meetings).
22574 AI Case Study: The Government Health Project Spring 2020
© ML Ossimitz 4
• Collaboration and inclusiveness (e.g. encouraging and supporting others, respecting others.
recognising the skills and valuing the contribution of others, helping resolve conflicts).
• Contribution to establishing and working towards a common outcome (e.g. establishing and
supporting team goals, plans, rules, roles, decisions).
Group case study assignments typically address problem-solving skills within teams, the capability to reach
an agreement on possible interpretations of the case scenario, etc. Therefore, only limited questions on
the case study content will be answered by the client (lecturer/tutor) unless they refer to typographical
error or understanding of the case/data provided.
Students not participating in the group work have to be reported at an early stage, i.e. 14 days after case
study distribution so that appropriated arrangements can be made.
Students may choose to submit a draft Project Management Report for review by the lecturer up to 7 days
before the due date. Team members will receive verbal feedback from the lecturer during consultation
times.
After the final submission, feedback on the assignment will be provided and a breakdown of the scores
will be published individually on UTSOnline under 'myGrades'.
Marking Scale Summary:
a. MS Access transaction and data files (task 2 and 3): 55%
b. Project Management Report (task 1, 2,3,4,5,6): 45%
= Group Assignment Score: 100%
Deduction per day for late submission: -10%
Please note: Each student has also to submit a Google Form (“Strength & Weakness about
Teamwork”). If not all group members hand this form in, the group assignment marks cannot be
determined.
1.3. Guideline for Project Management Report
1.3.1. Purpose
The purpose of the Project Management Report is to document and to comment on the tasks
completed in the case study and answer additional questions. Further to document ‘lessons learned'
from the teamwork. The report will become part of the systems documentation at the case company.
1.3.2. Format
The recommendations, which are given in the Faculty of Business “Guide to Writing Assignments”, do
apply. Some further hints:
• The report should have an introduction and main part. A summary/conclusion is optional. An
executive summary is not required.
• The use of resources (references) other than the provided the assignment specification is required
as well as appropriate quoting/referencing when using knowledge from other authors than the
group members.
• The formal quality of the report does contribute to the mark.
22574 AI Case Study: The Government Health Project Spring 2020
© ML Ossimitz 5
• The format should be as outlined in 1.2.2.
1.3.3. Resources
The required resources for this assignment are:
• The Case Study Group Assignment Specification (this document)
• Legacy files (MS Excel) (available at UTSOnline).
• The required Software (MSAccess) is available in all general access computer labs at UTS.
This assignment is open book, i.e. groups can consult books, courses notes, individual notes, and the
world wide web, but must cite correctly.
Additional resources:
• Faculty of Business (current version), Guide to Writing Assignments, Faculty of Business,
University of Technology, Sydney (available online).
https://www.uts.edu.au/sites/default/files/2018-07/UTS-Business-School-Writing-Guide.pdf
• Emerson, L. (2009), Writing Guidelines for Business Students, 4th Edition, Cengage Learning
Australia.
1.4. General Remark on Case Study
a. There may be information in the Case Study Specification (see below), which is not required to complete
the case study.
b. There may be information missing in the Case Study Specification. Please make reasonable assumptions
and justify them in the Project Management Report (see 1.2.2).
c. You can work through the tasks in any order you think is appropriate.
d. This assignment reflects a real-world scenario: At work….
(i) not all instructions maybe 100% clear to start with!
(ii) not all information is neatly in one place! You need to look for information!
(iii) you might need to make reasonable assumptions – use common sense.
(iv) you need to work in groups, co-ordinate time and manage the group.
(v) your success depends on the effort of all group members and what you deliver as a team.
e. Remember – you are a team member of a consulting company working for a client!
22574 AI Case Study: The Government Health Project Spring 2020
© ML Ossimitz 6
2. The Case Study Specification
The Australian Department of Health (NSW) provides a multitude of medical services to people in NSW; e.g.
public hospitals. The NSW government is considering using MS Access for getting faster and better information
for decision support. The data for MS Access comes from a legacy file system.
The government has no experience with MS Access, so it engages a consulting company to plan and implement
it. You have to take on the role of employees of the consulting company and each group of students is in charge
of this project. The first business process the government will implement in MS Access is the hospital admission
process.
The government looks after many public hospitals with a range of medical officers (MO) within different
medical fields (=speciality). Whenever a patient is admitted a record is created with an admission number
(EpisodeNo), date and time, the urgency of admission as well as hospital, the patient number, and other patient
data. During the stay, all the procedures performed and costs are recorded. When patients are discharged,
again the date and time, as well as the status, get recorded.
At this stage, the government is providing you with test data only. The spreadsheet includes different
worksheets in which data are explained further.
Your project consists of a range of tasks, beginning with designing the database (task 1) (ER Model -conceptual
model), implementing it in MS Access (task 2), creating queries and reports in MS Access (task 3), documenting
the design (task1), implementation steps (task2), query and reports (task3), answer clients’ questions (task1,4)
and provide feedback about the project work (task5). The documentation (Project Management Report) has
to be presented in a professional manner (tasks1-6).
Task 1:
(25 marks) Conceptual Model (ER Model)
In task 1, your group has to design a conceptual model (ER Model) for the given admission data. The aim is that
you design the database which you will then implement in MS Access and explain it in brief; including the
reasoning for your choices of entities. (Hint: Check your legacy file/available data. Think how the attributes in
the admission file can be grouped. Which data do and/or do not change with the business event? Which
existing attribute identifies records uniquely?)
Furthermore explain for the client the terms master data, transaction data, normalisation, referential integrity,
the primary key in your own words and provide examples from your HEALTH data (legacy file).
Task 2:
(30 marks) Implementation
In task 2, each group has to implement the hospital admission data in MS Access according to the design of
their ER Model and document some aspects of the implementation.
Implementation Requirements:
• The table names start with the group letter followed by “_”, e.g. “Z_customer”
• The implementation part of the project includes the table specification, data entry/load, and
documentation. The legacy/test file has been made available at UTSOnline.
• Primary keys have to be taken from the existing data, no new keys must be generated.
• All provided data must be loaded/entered into MS Access.
• Stick to the implementation procedures as practiced in class! Do not make any other changes.
(e.g. field size, all fields are required fields, index, etc.).
22574 AI Case Study: The Government Health Project Spring 2020
© ML Ossimitz 7
Documentation requirements: In your Project Management Report, please write down:
• The most important steps you have performed during the implementation
• For each data set (table) you create, the method of creation (imported/manually created) and data
entry method (manual or loaded);
• The number of records in each table;
• If you have used the test files provided (original) only or not; if not please note down what and why
you have changed the files or created new files. Please also attach new or alternated files.
• Any assumptions made/problems encountered during the implementation process, as there was
no/not enough specification given.
Task 3:
(18 marks) MS Access Reporting
In task 3, each group has to generate three out of the five requested reports and answer the additional
question. The chosen reports need to be implemented in MS Access. To do so, groups need to define and
save a query first and then generate a report.
General specifications:
a) Save all queries under the name ‘Zn_y’. X stands for the group letter, n stands for the report number
and y stands for the report name. (e.g. Z1_Admission by hospital, speciality & time)
b) Save all reports with the same naming convention as the queries. (e.g. Z1_Admission by hospital,
speciality & time).
c) Include sorting, grouping, and summary/count when it makes sense.
d) In reports, including the description of attributes, not only the ID, if possible.
e) If you cannot put all data into one report, generate a second one (e.g. 4a, 4b) and/or indicate in the
Project Management Report which part of the reporting requirement could not be fulfilled.
f) Format your MS Access reports professionally (professional layout, including report name, date, time,
and logo if you have one.)
Reports of the hospital administration would like to have:
(1) Admission count per hospital, by speciality, in a certain period (e.g 1st quarter 2018)
(2) The average length of stay by a hospital, by class, by a medical officer (doctor)
(3) Average cost by a hospital, by class, by age, by age group (age groups are 0-16, 17-39, 40-59, 60 and
above)
(4) List of a medical officer by a hospital, by speciality; include information on attendance patterns;
(5) Elective and Emergency (urgency of admission) admission count by a hospital, by sex, indigenous
status
Documentation requirements: In your Project Management Report, please provide (as an appendix):
• Screenshots for all query definitions,
• Pint first two pages of each report and include them as ‘appendix’ to the Project Management Report.
(Please format the printout in a way that is meaningful/readable/ includes information.)
• Assumptions made/problems encountered during this reporting phase & solution found.
22574 AI Case Study: The Government Health Project Spring 2020
© ML Ossimitz 8
Task 4:
(12 marks) ERP
An employee of NSW HEALTH, Ms. Great, followed all steps you have done during the design and
implementation process. She is very interested and asks you a lot of questions during the implementation Ms.
Great has heard about ERP but does not know what this acronym means and what it is used for including a
description of three different modules. Explain also the technology. Which type of companies are using it and
would it be something, NSW Health could use? Include reasoning, why or why not you think NSW Health should
use it.
Task 5:
(8 marks) Teamwork – lessons learned / contribution
Task 5 is all about the process of working together as a team and a brief reflection.
Please document anything notable, problems encountered and solutions found. Any team management issues
occurring during the project. If there were none, please note this down in the Project Management Report.
Furthermore, include the experience / brief reflection / “lessons learned” statement of each team member or
the whole team of doing the group assignment and the contribution of each team member to the overall
project. What did work well in your team (3 items) and what would you change/improve in your next project
(2 items)?
Task 6:
(7 marks) Project Management Report – presentation/overall ‘impression’
The Project Management Report (PMR) is the documentation of the work you have done for the client and is
part of the implementation project. The PMR includes a cover page, an introduction, page numbers, references,
and bibliography but a conclusion is optional.
The content of the PMR has outlined above and the marks assigned for this task are for formal requirements
and presentation/overall ‘impression’ only.

所有文章
×

快要完成了!

我们刚刚发给你了一封邮件。 请点击邮件中的链接确认你的订阅。

好的