Assessment Information Subject Code: Subject Name: Assessment Title: Weighting: Total Marks: Due Date: ACCM 4100 Management Accounting Excel Team Assignment (15%) and Individual Self Reflection (10%) 25% 60 marks Friday of Week 8 – 15th May 2015 by 00:00 PM (AEST). Note: Brisbane and Adelaide students must allow for time difference. . Assessment Description  Learning Outcome 4: Formulate and recommend possible solutions using management accounting techniques and tools, in a given scenario, working in teams in some instances.   Objective: The objective of this assignment is to effectively work in teams to formulate and recommend possible solutions in practical scenarios using management accounting techniques and tools, especially excel spreadsheets Required: This assignment comprises two parts as follows: Part 1 (15%): Work in teams (groups) of 3 members to complete the four case studies using the excel spreadsheet program as noted in the details of assignment. Part 2 (10%): Individual self-reflection on team work; as noted in part 2 below. Please check the marking rubric for each part to ensure that you have followed all the guidelines for presenting your work. The assignment will need to be submitted electronically on the portal. There will be two separate links– one for the team assignment, the excel spreadsheet(s) and the other for your individual written self reflection on team work. Your attention is also drawn to study support skill resources which can be located under Academic Success Centre/Library on the KBS student portal and please make sure you follow the guidelines noted in your subject outline especially those relating to the presentation of written work, late assignment policy and academic integrity.  PART 1: Technical competency (Assessable Value 15%) Students are required to complete the following questions taken from the prescribed textbook; Management Accounting, Information for Creating and Managing Value 6th Edition by Langfield-Smith K, Thorne H and Hilton R. Please note that you are required to use an excel spreadsheet file in which at least 4 separate worksheets (1 for each question) should be created to answer each question. You may have more than 4 worksheets in your file if you wish to. Each question carries a total mark of 15; 3 of these marks will be allocated for spreadsheet design and the remaining 12 marks per question to the technical content. The questions required to be completed are: Case Study 1: Chapter 9 - Problems: P9.42 using an excel spreadsheet answer all requirements (pages 461 - 466) 15 Marks Case Study 2: Chapter 2 - Problems: P2.38 using an excel spreadsheet answer all requirements (page 71) 15 Marks Case Study 3: Chapter 18 - Cases: C18.37 using an excel spreadsheet answer all requirements (pages 886 – 887) 15 Marks Case Study 4: Chapter 6 - Cases: C6.45 using an excel spreadsheet answer all requirements (pages 279 -280) 15 Marks Points to follow when creating your team excel workbook: 1. Create your excel workbook for the assignment - It is best to create one workbook and name each worksheet in the workbook with the question number, instead of creating many different files for each question. This will create consistency in submission and only one file per team per assignment will need to be submitted 2. Naming the workbook and worksheets - Name the workbook with a student name in the group and their number and save under this name. Name the worksheet in the workbook with the question number. 3. Each question must begin on a fresh worksheet not continued from the previous question. 4. Minutes of the meeting must be attached for group assignment separate on a word document. 5. Cover page for assignment – make sure you have a cover page with a list of the student names and numbers in the team. 6. Use the excel formulas in your worksheet. Do not use calculators to arrive at the answer. Team Meetings The team should have a minimum of three meetings (the team may have as many meetings as they need to) and should maintain minutes of those meetings which should be included with the team assignment as an attachment. The minutes of meetings should (at the very least) contain - 1) Where and when the meeting was held 2) People present; absent; apologies 3) What was discussed, any disagreements/conflicts, points that were agreed on; 3) The follow up action relating to each member of the team; 4) Any other relevant matters, anything else that is significant to the successful completion of the assignment. An agenda template and a template for minutes of meeting are attached (after Part 2 of the assignment information) for your team to use.  PART 2: Professional Competency Skills (Assessable Value 10%) Individual Reflection on Team work Word count: 750 words Aim: The content task in this assignment is completed in teams. It is important that you reflect on this experience to learn about the ways that teams work and the ways that you work in teams. Refer to the content in the power point presentation on team work and check management and communication text books for further detail on team communication. Your reflection should incorporate the information from your reading as you will use relevant theory to critically reflect on your team experience. Task: Write your reflection on the team experience. Your reflection must incorporate the following headings. Group description e.g. members (use pseudonyms), meetings (e.g. times, locations, attendance) My role Others' roles Group stages Conflict in group and, if applicable, how the conflict was resolved Leadership and decision making in the group Ways that the group experience worked well and ways it could have been improved What You Need to Do: 1. Refer to the content in the powerpoint presentation and communication text books on teamwork 2. Read the guide below on reflective writing style 3. Check the marking rubric to see how marks are allocated for this assignment 4. Incorporate relevant theory to critically reflect on your experience. Ensure you include the information under all of the headings listed above. Ensure you reference a minimum of three sources 5. Edit your work carefully to ensure it is well written and error free. If you would like any help with this, see Academic Success Centre staff. Reflective Writing Guide: Reflective writing is: • your response to experiences, opinions, events or new information • your response to thoughts and feelings • a way of thinking to explore your communication practice • an opportunity to gain self-knowledge • a way to achieve clarity and better understanding of the ways you communicate • a chance to develop and reinforce writing skills • a way of making meaning out of what you study Good reflective writing usually involves four key elements: 1. reporting and responding to a critical issue or experience; 2. relating this issue or experience to your own knowledge in this field; 3. reasoning about causes and effects of this issue/experience according to relevant theories or literature and/or similarities or differences with other experiences you've had; and 4. reconstructing your thinking to plan new ways to approach the issue or engage in similar experiences in the future Reflective writing is different from other university styles, such as academic essays. It uses 'I' and 'we' and has the following language features: 1. People are added to the writing when the writer is expressing personal experiences or opinions e.g. I, me, you, we, us. 2. People (i.e. I, me, you, we, us) are removed when referring to the theory. 3. The actions (verbs) are usually those of feeling and thinking e.g. feeling, felt, considered, experienced, wondered, remembered, discovered, learned. 4. When reflecting the language is usually modified e.g. may, perhaps, might. QUT library (2014) Reflective writing (http://www.citewrite.qut.edu.au/write/reflectivewriting.jsp, accessed 4 June 2014)