Task Summary
Based on the case scenario provided, (1) developing a collection of spreadsheets on a file system to manage a business process, (2) identifying and discussing the problems of using a collection of spreadsheets on a file system, (3) discussing the benefits of using a database system and (4) drawing an ERD and developing a database table design for the information system proposed in the case.
Context
This assessment aims to develop your understanding of the challenges involved in collecting, storing and managing data in an organisational context. It assesses your ability to effectively identify the benefits of a database system as well as your ability to build data models to simplify complex subject matters.
Task Instructions
1. Please read the attached MIS201_Assessment 1_Case Scenario.
2. Based on the case scenario provided, please complete the following tasks:
Task 1 (10 marks)
Design and create as many Microsoft Excel spreadsheets as you deem necessary to manage and store academic misconduct cases as detailed in the case scenario. Note one Microsoft Excel file may contain many spreadsheets.
Task 2 (50 marks)
A collection of spreadsheets created by the Academic Integrity Officers shared on a network drive may experience many problems. Identify and discuss the problems with examples related to the case scenario with respect to data redundancy, data independence, data consistency, data integrity, data security and the scale of data sharing.
Also, discuss whether — and if so how — a database system could solve most of the problems that a collection of spreadsheets on a file system would encounter. Please note that your response to this task should be 1200 words +/-10%.
You do not need to use a Report format for your answer. Use headings (e.g. Data redundancy, Data independence, Advantages of a database system) to structure your answer.
Task 3 (25 marks)
The University Management decides to develop an information system (the ‘System’) to process the large number of academic misconduct cases, and you have been asked to design the database for the System. The System shall facilitate the management of academic misconduct cases and shall generate reports for the Academic Board or other academic governance committees. Draw an Entity Relationship Diagram (ERD) to model the data that would be used in the System given the case scenario above.
Task 4 (15 marks)
Based on the ERD you completed in the previous task, design database tables for the System. Provide the following information for each database table. Please note that ERD must be drawn using LucidChart or an equivalent professional diagramming software package.
TABLE_NAME
COLUMN NAME PRIMARY KEY/FOREIGN KEY FORMAT SAMPLE DATA
For example,
ACADEMIC_MISCONDUCT_CASE
COLUMN NAME PRIMARY KEY/FOREIGN KEY FORMAT SAMPLE DATA
CASE ID PRIMARY KEY AUTO-
INCREMENT 1
STUDENT ID FOREIGN KEY 123456T
DATE RECORDED DATE 14/6/2019
Referencing
It is essential that you use the appropriate APA style for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing
Submission Instructions
Please submit ONE MSWord document (.doc or .docx) via the Assessment 1 section found in the main navigation menu of the subject’s Blackboard site. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
Academic Integrity Declaration
Individual assessment tasks:
I declare that except where I have referenced, the work I am submitting for this assessment task is my own work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure viewable online at http://www.torrens.edu.au/policies-and-forms
I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly.
Assessment Rubric
Marking Criteria F P C D HD
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 1
? Design and creation of Microsoft Excel spreadsheets to manage and store data as detailed in the case scenario.
10%
a) collectio
Task 2 ? Subject Learning Outcome:
Analyse specific organisational needs that can be addressed by n, storage and management of organisational data.
Identify and discuss the problems with examples related to the case scenario with respect to data redundancy, independence, consistency, integrity, security and the scale of data sharing
?
50% Discuss whether — and if so how — a database system could solve most of the problems that a collection of spreadsheets on a file system would encounter.
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 3
? Draw an Entity Relationship Diagram (ERD) to model the data that would be used in the System given the case scenario. 25%
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 4
? Based on the ERD, design database tables for the System.
15%
Fail
(Unacceptable)
0-49% A Fail grade will be awarded if a student is unable to demonstrate satisfactory academic performance in the subject or has failed to complete required assessment points in accordance with the subject’s required assessment points.
Pass
(Functional)
50-64% Pass is awarded for work showing a satisfactory achievement of all learning outcomes and an adequate understanding of theory and application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged.
Credit
(Proficient)
65-74% Credit is awarded for work showing a more than satisfactory achievement of all learning outcomes and a more than adequate understanding of theory and application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged.
Distinction
(Advanced)
75 -84% Distinction is awarded for work of superior quality in achieving all learning outcomes and a superior integration and understanding of theory and application of skills. Evidence of in-depth research, reading, analysis and evaluation is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged.
High
Distinction
(Exceptional)
85-100% High Distinction is awarded for work of outstanding quality in achieving all learning outcomes together with outstanding integration and understanding of theory and application of skills. Evidence of in-depth research, reading, analysis, original and creative thought is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged.
