MIS602 Assign1 Page 1 of 3 ASSESSMENT BRIEFSubject Code and NameMIS602 Data Modelling & Database DesignAssessmentOne – Peer Assessment of File-based Database DesignIndividual/GroupIndividualLengthSee below for detailsLearning OutcomesBSubmissionThursday 11:59 PM AEST/AEDT of Module 2 (week 4)Sunday 11:59 PM AEST/AEDT of Module 2 (week 4)Weighting25%Total Marks25 marks Context:The MIS602 Data Modelling & Database Design subject is designed for you to progressively add toyour understanding of data and database management and its relevance with in business context. Italso introduces you to some of the key features of database management system and designingdatabase systems that will feature in later modules of this topic. In order for you to do well in thissubject, it is imperative that you undertake all of the learning activities in the modules. The learningactivities are presented as a way of scaffolding your learning so that you can attempt the buildingblocks of the assessments and be in a safe environment to fail and to learn from them. Therefore,doing your learning activities and seeking feedback from them from peers and from the learningfacilitator is the single best way of preparing for doing well in this assessment.Instructions:There is an imperative requirement in this assessment; you must submit different versions of thefiles by Thursday of week 4 at midnight (Sydney time). The files should ideally be of excel format.The data in the files should be composed based on the following scenario:Torrens University Australia (TUA) is interested in a new Student record managementsystem. This system needs a database to manage students enrolled, courses studentsenrolled in and staff facilitating the course. You will need to store and manage the data forthe enrolled students, courses and the staff assigned to the courses. The system is intendedto be built in-house. The university has a very strong information systems suite of programsand the students of that program are showing great insight and promise. It has signalled itsintention to seek input from those students in a consulting arrangement.MIS602 Assign1 Page 2 of 3The system should allow the staff to add, update and delete the records of students, staffallocated to course and courses. In addition, University staff should be able to see the list ofstudents enrolled in a particular course facilitated by a particular learning facilitator.Based on this scenario, you should identify key data objects and their attributes and define them ascolumns in the spreadsheet. Create multiple versions of the spreadsheet file as per belowinstruction:• Version 1 (V1.0) with all possible database objects and attributes and create 30 rows of data.• Version 2 (V1.1) of the file should update last 2 records and add 5 additional records• Version 3 (V1.2) of the file should add 2 new attributes• Version 4 (V1.3) of the file should remove 5 existing attribute and add 5 more rows of dataWhen you are finished this, combine the four versions of the Excel database solution with adocument that in more than 1000 words, describing your experience. On the morning followingsubmission, the learning facilitator will allocate you another student’s spreadsheets and summarydocument to assess. It is then your turn to assess another student’s work. You will have three daysto assess the other student’s work and to upload your response to Blackboard.In no more than 500 words, provide a critique of that student’s work to them. You can choosewhether to identify yourself but you should provide constructive feedback, balancing good pointsand points where the student can improve. You should use the scenario and provide feedback tothe other student on their list of data objects, data attributes and summary document. You are freeto use whatever framework you like and the following should be minimum inclusions:• Comment on the overall suitability of the data objects and attributes as an input fordatabase design and the summary document• Provide constructive criticism on how the other student can improve their data objects andattributes in future• Provide some useful readings the other student may peruse that helps them develop theirunderstanding of data and data attributesSubmission Instructions:Your spreadsheets and summary should be submitted by Thursday at midnight (Sydney time) ofweek 4. Do not include any identifying information on your submission (i.e. not your studentnumber, name or anything else that might identify you). This is important because the peer reviewis to be done anonymously. Non-submission or lateness will be treated in accordance with the lateassessment policy of the university.Please note that late submissions mean that another student will effectively have less time to dotheir peer assessment of your work.MIS602 Assign1 Page 3 of 3Learning Rubric: Assessment One Assessment CriteriaFail(Unacceptable)0-49%Pass(Functional)50-64%Credit(Proficient)65-74%Distinction(Advanced)75 -84%High Distinction(Exceptional)85-100%Understanding of theData and Dataattributes30%Demonstrates limitedunderstanding of Dataand Data attributes.Fair understanding of Dataand Data attributesdemonstrated. Mayneglect to provideresources or that these arecursorily provided withoutreference to specific areasin the source.Good understanding ofData and Data attributesdemonstrated. Mayprovide a limitednumber of sources thepeer can use to developtheir technique from.Very good understanding ofData and Data attributesdemonstrated. Makesrecommendations to otherexternal sources the peer canaccess to develop theirunderstanding.Outstanding understanding ofData and Data attributesdemonstrated throughrecommendation of othersources with specificreferences to components ofit that the peer will benefitfrom.Application andEvaluation of the Filebased databasemanagement system40%Limited understanding ofthe databasemanagement system andits applicability toorganization.Understands the contextand impact the databasemanagement system in anorganization and provides acritique for the peer.Understands the contextand impact the databasemanagement system inan organization.Identifies logical flowsand questions theviewpoints of the peer.Evaluates the databasemanagement system,providing a critique of thepeer’s work, relevant to thescenario. Identifies logicalflows and presentssuggestions the peer can useto develop their technique.Expertly evaluates thedatabase managementsystem presented by the peer.Provides a thoughtful critiquein the context of the scenariothat the peer can use andgenuinely develop from.Effectivecommunication30%Difficult to understand foraudience, no logical/clearstructure, poor flow ofideas, argument lackssupporting evidence.Audience cannot followthe line of reasoning.Information, arguments andevidence are presented in away that is not always clearand logical. Line ofreasoning is often difficultto follow.Information, argumentsand evidence are wellpresented, mostly clearflow of ideas andarguments. Line ofreasoning is easy tofollow.Information, arguments andevidence are very wellpresented; the presentation islogical, clear and wellsupported by evidence.Demonstrates culturalsensitivity.Expertly presented; thepresentation is logical,persuasive, and wellsupported by evidence,demonstrating a clear flow ofideas and arguments. Engagesand sustains audience’sinterest in the topic,demonstrates high levels ofcultural sensitivity.
