Case study. Please refer to the files attached.
Microsoft Word - MIS201_Assessment 1 Brief_Case Study_1_Module 2_Final.docx MIS201_Assessment_1_Brief_Case Study_Module 2.2 Page 1 of 5 ASSESSMENT 1 BRIEF Subject Code and Title MIS201 Database Fundamentals Assessment Case study Individual/Group Individual Length 1200 words (+/‐ 10%) Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data. Submission Due by 11:55pm AEST Sunday end of Module 2.2 (Week 4) Weighting 25% Total Marks 100 marks 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. MIS201_Assessment_1_Brief_Case Study_Module 2.2 Page 2 of 5 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. MIS201_Assessment_1_Brief_Case Study_Module 2.2 Page 3 of 5 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. MIS201_Assessment_1_Brief_Case Study_Module 2.2 Page 4 of 5 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% Subject Learning Outcome: a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data. Task 2 ➢ 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 ➢ 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. 50% 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% MIS201_Assessment_1_Brief_Case Study_Module 2.2 Page 5 of 5 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. Microsoft Word - MIS201_Assessment 1_Case Scenario_1_Final.docx MIS201_Assessment 1_ Case Scenario Page 1 of 2 Assessment 1 Case Scenario ABC University currently employs a paper‐based manual process for managing academic misconduct cases. The process is detailed below: - Learning facilitators are responsible for identifying and reporting academic misconduct cases to the subject coordinators. - When reporting an academic misconduct case, the learning facilitator has to identify the breach type, which can be one or more of the following: o Plagiarism o Collusion o Cheating in exams o Contract Cheating o Other forms of cheating - An academic misconduct case may involve one or more students. - The learning facilitator also needs to record and report the trimester in which the alleged academic misconduct occurred to the subject coordinator including the campus location, the student name and student ID, as well as whether the student in question is studying a postgraduate or undergraduate degree, the subject code and name in which the alleged academic misconduct occurred, the type of assessment, the assessment number, the assessment weighting, and the name of the subject coordinator and of the learning facilitator. - Once the subject coordinator receives an academic misconduct report, they will decide whether to dismiss the case or to further investigate it. If the case is dismissed at this stage, no further action is required. - If the subject coordinator decides to further investigate the case, they will request a meeting with the student in question. - During the meeting, the subject coordinator will record the date and the time of the meeting as well as the meeting minutes. - After the meeting, the subject coordinator will make a decision and assign an outcome to the academic misconduct case. The outcome can be one of the following: o No breach o Minor breach o Significant breach - A penalty will also be imposed on each student involved in the academic misconduct depending on the outcome of the case. If there is no breach, no penalty will be imposed. - For a minor breach, one or a combination of the following penalties will be imposed if it is the first time the student has been involved in academic misconduct: o Mandatory education in academic integrity o Downgrade the mark for the assessment o Zero marks for the assessment - For a minor breach, one or a combination of the following penalties will be imposed if this is the student’s second or subsequent offence: o Mandatory education in academic integrity o Downgrade the mark for the assessment o Zero marks for the assessment o Fail grade for the subject - For a significant breach, one or a combination of the following penalties will be imposed if this is the student’s first offence: o Mandatory education in academic integrity MIS201_Assessment 1_ Case Scenario Page 2 of 2 o Downgrade the mark for the assessment o Zero marks for the assessment o Fail grade for the subject - For a significant breach, one or a combination of the following penalty will be imposed if this is the student’s second or subsequent offence: o Fail grade for the subject o Academic probation of up to 2 years o Suspension for one or more study periods o Exclusion from the course o Exclusion from the University Three designated Academic Integrity Officers have been appointed to process the paperwork related to academic misconduct cases. They use a collection of Microsoft Excel spreadsheets stored on a network drive to record all academic misconduct cases. Once a person opens the spreadsheets to edit, others can only open the spreadsheets under the “read‐only” mode. As a standing agenda item, the Academic Board receives detailed reports on academic integrity cases in every meeting. The Board meets every three months. The reports include, but are not limited to, the following statistics about academic misconduct cases: - Number of academic misconduct cases since the last Academic Board meeting, - the top ten subjects with most number of academic conduct cases reported, - the average number of students involved in an academic misconduct case, - the most commonly reported breach type, - the number of academic misconduct cases that have been identified as a “significant breach”, - the number of investigation meetings held since the last Academic Board meeting, - and the number of students who were found guilty of academic misconduct more than once.