INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 1 of 9 Group Assignment Statement Problem Scenario You went to Barcelona in Spain for holidays, and you love the city so much that you wanted to stay in the city. You do not speak one word of Spanish, and you rely on the translator app on your phone and your PC. As the demand for skilled Information Technology personnel is high, you decided to apply for a few positions. Great news, you got a new job with the Barcelona City Council (The Barcelona website | Barcelona City Council) as a Senior Business Analyst. The second day in your role, the mayor asked you if you can examine the accident data (see Description of the accidents’ handled by the police in the city of Barcelona causality – Datasets – Open Data Barcelona) and present to him with recommendations of what actions to take, if any. The police chief will also be in your presentation. Note: you might need to translate from Spanish to English, and this is part of the assessment. Objectives The objectives of the project are: (1) Identify and report on any themes and/or trends for the accidents based on the data. (2) Identify potential causes of the accidents found in (1). (3) Propose recommendations for changes that might reduce accidents based on the data. Impact Statement (1) Prevent Accidents – to reduce the number of accidents in the city as part of the principal of ODS 3: Good health and well-being (2) Policies – currently some policies and education programs such as safety education service have been implemented to make the city a safer place. INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 2 of 9 Data and Resources The dataset (csv and xml) can be found on the website: Accidents managed by the local police in the city of Barcelona – Datasets – Open Data Barcelona. There are 12 years of data: 2010 to 2021.The amount of data needed for your assignment depends on the number of group members in your team. The rules are: If you have one or two group members in your team, then you need to download the six years of data, that is between 2016 to 2021 inclusive. If you have three group members in your team, then you need to download the nine years of data, that is between 2013 to 2021 inclusive. If you have four group members in your team, then you need to download the twelve years of data, that is between 2010 to 2021 inclusive. You can search and use other dataset from the same website, or you can search and use external dataset (not on the website) which you believe are important in your data analysis. Metadata The metadata can be found on the website under View complementary description and field definition. You might need to translate from Spanish before you can work on the data. INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 3 of 9 Project Presentation A maximum time of presentation is 10 minutes; 2-member group can present less than 8 minutes. You submit your presentation as a video. The video must be saved as a MP4 video format. PowerPoint Slides: o First slide – it should have your group number, names, and pictures, and the order of the presenters for the slides. We do not want to give mark to the wrong presenter. o Main slides – a maximum of 12 PowerPoint slides to be used for presentation. It is up to each group to decide how the slides are presented. o Please introduce yourself before presenting the contents. Again, we do not want to give mark to the wrong presenter. o Appendix slides – slide number 14 onwards are treated as Appendices, where you can put the SQL statements, data analyses not used in presentation, data cleaning output and other details you can put on the Appendix slides. All group members must present as individual mark will be given for an individual’s presentation. If an individual does not contribute to presentation, then s/he will get a zero mark for presentation. (a) [Mandatory] Each group must present one descriptive analysis using SAS Enterprise Guide to show the datasets you have selected. (b) [Mandatory] Each group member must create two outputs for two presentation slides. All the outputs must be created using SAS Enterprise Guide. (c) [Optional] Each group has an option to present one output not using SAS Enterprise Guide. If the group decides to exercise this option, then one of the group members can replace one of the outputs in (b) here. Furthermore, you must say what application you used, and how you achieve the output from the raw data. For example, a group of four can have seven outputs/slides created by SAS Enterprise Guide and one output/slide created by not using SAS Enterprise Guide. You are expected to add notes to the speaker notes, at least for the Main slides. However, you do not have to speak in exact wording as on the slides (like me in lecture). The number of words is limited to +/- 300 words. On the top of each slide, you must indicate who is responsible for writing and/or presenting the slide. However, the slides AND the presenter’s face (highly recommended) should be shown in the video. You can also do the same for the Appendix slides. The file name should be as follows: let’s say your Group ID is H18A_81, then “GroupID_Presentation.mp4” will be Group_H18A_81_Presentation.mp4 (You should only use .mp4 video format). For each slide, please include the name(s) of the group member(s) who wrote, and which group member presents on the corresponding slide. This slide wrote by: Vincent Pang and Silvia Lin This slide presented by: Silvia Lin Support for Oral Presentations | UNSW Current Students Present in PowerPoint Using PowerPoint | UNSW Current Students Tips: you can put individual recording to the PowerPoint slide (see How to Record Screen using Microsoft PowerPoint – Bing video) INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 4 of 9 Presentation Structure A possible structure but not limited for the video presentation could be: Clearly and briefly introduce your team, the presentation’s structure, and key points. Clearly detail the datasets you have selected and downloaded, and how you prepare the data for analysis. This includes how you clean the data, manage missing data, language translation, and how you organise tables that go into SAS. [Note: not more than 2 slides.] Business insights and recommendation- graphs and tables produced from SAS Enterprise Guide must look reasonable, that is, we can read the numbers, and the results made sense. It is recommended each group member presents his/her work. As time is limited, we accept if you do not have a conclusion. Deliverables (a) This project accounts for 30% of the total marks for this course. (b) Your project report is due in Week 10, Friday, 05 August 2022, 4pm (Sydney Time) on Moodle in two submission boxes: o One submission box for the Presentation Video mp4 file and o Another submission box for other files – PowerPoint, data files, and script files. (c) Only one member of each group needs to submit. (d) Only cleaned SAS dataset/tables you used in your data analysis (Please clearly labelled all the dataset/table) are needed to upload. (e) All SAS SQL scripts you used – please clearly indicate which script is related to which output on your slide. Use comments in your file to indicate what you are doing. (f) You need to include your metadata for all the data and tables you used. You can include the metadata in an Excel spreadsheet or a Word Document. You can include as part of the file in (g). (g) You have an Excel spreadsheet or a Word Document to say the purpose of each of the files you have uploaded. You can name this file as “Readme”. You can include (f) in this file. This will give me an idea what all the files are. (h) You do not need to submit a written report. INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 5 of 9 Marking Guideline Item (%) Description Data preparation (10%) Do you select any external datasets to support your data analysis Do you properly manage the missing data Do you properly process the tables used in SAS Enterprise Guide Quality of the data analysis (35%) Are your research questions or hypotheses meaningful to the business That is, can the data support your argument Have you properly analysed the data with the right functions or steps Have you provided proper data visualisation (for example, table or graph) to present and support your analysis [Note: graphs produced in SAS are not the best, but it is the numbers we look for, and not the prettiness of the graph.] How well have you written in the speaker notes in PP slides Quality of business insights obtained and recommendation (35%) Do you obtain business insights from the data Are your obtained insights helpful for business Do you provide proper recommendations to make use of the obtained insights How well have you written in the speaker notes in PP slides Presentation quality (15%) How well do you, as an individual, present in the video [It is expected the presentation times for the video are evenly distributed among the group members.] Teamwork (5%) How well your team conducted in teamwork Total (100%) Group Assignment QnA Channel (in Microsoft Teams) All questions must be posted in the group assignment (see https://teams.microsoft.com/l/channel/19%3a9276e2399b704a75942a2227f9791d53%40thread.t acv2/03%2520Group%2520Assignment%2520QnA groupId=e31cfcfa-09f0-494a-9946- c546a98cdc64&tenantId=3ff6cfa4-e715-48db-b8e1-0867b9f9fba3). Emailing questions related to the group assignment to LiC and tutors will not be answered. To be fair to all the students, we do not want to be seen as bias to one group by getting them information. Please note that we will stop answering questions after Monday 1 August 2022, 4pm. This is to ensure you plan ahead, and not panicking in the last minute. In the last few days, you probably just to finalise the PowerPoint and video presentation. INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 6 of 9 Private Group Channel (in Microsoft Teams) (a) A private group channel will be created in Microsoft Teams by the teaching team after the group formation. (b) The name of your private group channel is same as your group ID, e.g., H18A_81. (c) Only your group members and the teaching team will have access to your private group channel. That is, no member from outside the group can access to your private group channel. (d) All conversations and files saved in the private group channel remain in the private group channel. (e) The purpose of the private group channel is to work as an environment for you to meet, chat, leave messages, and upload/download files. Moreover, the teaching team can communicate directly with the group in this channel. (f) All the posts, files, meeting times and other group activities will be saved in the channel. (g) Another important factor of using the private group channel in Microsoft Teams is it is transparent to all the group members and the teaching team. When there is a dispute between the group members, the LiC will only examine evidence such as posts, meeting activities and uploaded files in the private group channel. The LiC will not examine other communication channels such as WhatsApp, Google Doc, Facebook, and WeChat. Planner Planner such as Microsoft Planner (if you have access) or a Weekly Chore Schedule template or something similar which can be found in Microsoft Excel can be used to improve planning of tasks. The whole team can access the planner so there will be no excuse such as, “I don’t know what’s going on”. Notifications can be used as a reminder task to be completed. Planner should be maintained by the team leader or an appointee. All other group members should also assist in managing the tasks in the Planner. INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 7 of 9 Teamwork One of the key PLOs is 4 Teamwork. We will examine the activities such as chat and planner in the channel as the means of assessing teamwork. Groups must plan, schedule, and conduct activities in due time. Groups must meet on a regular basis (at least twice per week) while the assignment is being undertaken and keep records (diaries, meeting minutes) of such meetings. The groups must ensure that all members are involved in the completion of the assignment. The work is to be divided equally among the group members. All group members are expected to behave professionally and work diligently. Group members should contribute in a useful and constructive way to the teamwork. Deadlines should be kept, and work should be delivered at a professional standard. If problems emerge in your group, then these problems should in the first instance openly be discussed in the group (different members might have different views) and resolutions should be agreed on. If internal arrangements repeatedly fail to remedy the situation, then you should bring the issues to the attention of the LiC. The LiC may call a meeting of the group in which each group member will be asked to describe in detail his or her input into the assignment and provide supporting documentation of this effort. If group members are found to be making inadequate effort or delivering poor quality, then they will be counselled to improve their effort. If sufficient improvement is not made despite group efforts and LiC interventions, then the mark of under-performing group member(s) may be moderated to reflect the relative lower input into the assignment. Note that the inability to resolve internal group conflicts without involving the LiC does not reflect well on the group’s project management and teamwork skills. An important part of a project is to record and to evaluate the teamwork. You need to keep all the communications such as meetings and chats, and upload/download of files in Teams. We can just view how the teamwork is performed. If one member consistently asks for parts from all the members, but no one responds until the last two days before the submission, then this is not a teamwork. The planner (assuming you use Excel) should be pinned on top of the tab, so everyone knows what to do. Keeping minutes of a meeting is critical, it must record the following details for each group activity: Record what the activity (meetings, work) entailed. Record location, time, date and duration of a group activity. Record who was present at the activity. For “next actions”: Specify who is doing what by when (Action plan) The team leader should post the meetings on Teams to all the members. The Team Leader is responsible for recording the minutes unless other arrangements are made within the group. INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 8 of 9 Self and Peer Assessments You are strongly recommended to do self and peer assessments in Review. Most of the times, the contributions are evenly distributed as shown below: However, occasionally, you might have a “free rider” (i.e. student who does not do any work but has his or her name on the front cover) or people who just want to do the minimum, then you might the contributions as shown below: The self and peer review assessment will allow you to rate your group members’ contribution. Rate your group members and your own contribution to the group assignment on a scale out of 5: 5 = Significantly above expectations (very strong contribution in terms of quality and quantity, leadership of the project) 4 = Slightly above expectation (strong contribution in terms of quantity and quality) 3 = Meeting expectations (did his/her fair share) 2 = Slightly below expectations (did some work, but could have been more and/or of better quality) 1 = Significantly below expectations (did very little work and/or of poor quality) 0 = Did not participate at all / free riding INFS5710 T2 2022 Group Assignment Barcelona Accidents Page 9 of 9 Equal contribution is expected. Please note that simply doing the final proof-reading or making a cup of tea does not count as equal contribution. Unequal contribution might lead to redistribution of the marks of the group assignment. You will be allocated a group channel in Microsoft Teams. You can record all your communication such as meetings. All the posts and uploading of files will be all date and time stamped. Conflicting/inconsistent/unfair peer contribution review will lead to the group being assessed by the Teaching Team. The Teaching Team will then examine the communication between the members including posts, date and time stamp of the posts, meeting minutes, files and so on in Microsoft Teams.
