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. 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 aca emic 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 b 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 only. - 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. 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 aca emic 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 b 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 only