IT assignment
COIT11226 Assignment 1 Term 1, 2019 Systems Analysis Page 1 of 4 COIT11226 Assessment 1 — Written Assessment Due date: 9am AEST Mon 22 Apr 2019 (Week 6) ASSESSMENT Weighting: 20% 1 Length: N/A Instructions This assignment has two parts, i.e. Part A (12.5 marks) and Part B (87.5 marks). This is an individual assignment, and it is expected students answer the questions themselves. Discussion of questions is allowed (and encouraged), however each student should develop and write- up their own answers. See CQUniversity resources on Referencing and Plagiarism. Part A (12.5 marks) Part A consists of two tasks: • Complete all online quizzes weeks 1-5. Unlimited attempts. Highest score will be recorded as your mark. (6.25 marks) • Complete all tutorial activities and tasks during all physical tutorial classes within weeks 1-5 for marking. Distance students will discuss and complete tutorials via online zoom classrooms. (6.25 marks) • Note that the unit coordinator will consolidate your marks of all your online quizzes. Your tutor will consolidate all your tutorial work marks. Part B (87.5 marks) Part B requires all students to complete all Part B tasks and submit the following on Moodle: • One (1) MS Word report containing answers for each task. The report must include unit name, unit code, student full name, student ID, campus (or distance), lecturer (or tutor) on the front page. • One (1) MS Project file for Task 2. A screenshot or copy-and-paste of the Gantt chart must also be included in the MS Word report. • One (1) MS Excel spreadsheet for Task 3. A screenshot or copy-and-paste of the spreadsheet must also be included in the MS Word report. • For successful submissions on Moodle, include only the acceptable file types as required as above. Case Study – SolarPower (For both Assignments 1 and 2) Consider a project involving development of an Online SolarPower System for Bob Sparks. The following System and Personnel Information is to be used in Tasks 1 and 2. The Financial Information is to be used in Task 3. System Information Bob Sparks is a professional electrical engineer who works part time for a local coal-fired electricity power station. With the recent advent of government rebates, it has now become affordable for ordinary people to install solar power cells on the roof of their home to generate electricity and sell https://www.cqu.edu.au/?a=14032 https://www-search.cqu.edu.au/s/redirect?collection=policy&url=https%3A%2F%2Fwww.cqu.edu.au%2Fpolicy%2Fsharepoint-document-download%3Ffile_uri%3D%257BBE8380F3-F86D-4C55-AC0D-84A81EAFD6A2%257D%2FAcademic%2520Misconduct%2520Procedure.pdf&index_url=https%3A%2F%2Fwww.cqu.edu.au%2Fpolicy%2Fsharepoint-document-download%3Ffile_uri%3D%257BBE8380F3-F86D-4C55-AC0D-84A81EAFD6A2%257D%2FAcademic%2520Misconduct%2520Procedure.pdf&auth=WEUrq0f7sZCx%2FFw6lIoA3w&profile=_default&rank=1&query=Plagiarism+Policy COIT11226 Assignment 1 Term 1, 2019 Systems Analysis Page 2 of 4 unused power back to the local electricity provider. Bob recently decided that he has the time and expertise to start a small business supplying and installing the solar panels and has registered the business name as SolarPower. To date you have helped Bob through the planning and analysis phases of a computerised information system for his new business. Now Bob has asked you to help him with the design and implementation phases. You have agreed with Bob that the system should be largely ‘form-driven’. For example, a potential customer may, through SolarPower’s website, complete an online request for a free consultation and quote. Or they may apply by phone or in person, in which case one of the staff will complete the form. One of Bob’s staff members will arrange a mutually convenient date and time for Bob to call on the customer. Bob will discuss the customer’s needs with them and supply the customer with a written quote for the desired system. SolarPower currently have four systems on offer, based on the average amount of power they generate: 1.5 kilo-watts (kW), 2.3kW, 3.4kW and 4kW. If the customer is willing to go ahead with a type of system, they are required to sign a ‘Solar Power Supply and Installation Agreement’ form. When installation is complete SolarPower leave an invoice/statement with the customer, which must be paid in full within 7 days. Part payments are not allowed. Payment may be by cash, eftpos or credit card and customers are given a receipt. Bob requires the system to provide him with regular reports showing: • Appointment details for consultations • Quotes accepted • Job schedule (when installation at premises is to be carried out) • Outstanding accounts (installation completed but not yet paid for) You may be able to suggest other more appropriate reports to Bob. Personnel Information The project is to develop an Online SolarPower System, a web-based system for Bob Sparks. You are in the development team that consists of 4 members. During the project, each team member may take on different roles, but only one role at a time. For example, one person may take the role of ‘analyst’ and ‘programmer’, but not at the same time. Financial Information The customer and the oversight committee of the project indicated that the technology investment cost of the project is $25,000.00. They foresaw a consistent recurring cost of $7,500 in using the technology with an expected discount rate of 11% within a 5-year period. They also worked out their forecasted benefits as $30,000.00, $35,000.00, $40,000, $45,000.00 and $50,000.00 in the 5-year period. Assessment Criteria Please note the maximum marks that may be awarded to you for each task that you perform in this assignment as in the table below. Please also cross-read more task details in the next section. For some tasks, marks are distinguished between “Content” and “Format”. That is: COIT11226 Assignment 1 Term 1, 2019 Systems Analysis Page 3 of 4 • Content refers to the information provided in the write-up, diagram, chart, or table. The content should be relevant for the specific task/scenario. For example, with a cost/benefit analysis the information or content is the numbers, calculations and required discussions. • Format refers to the layout and syntax used in the diagram or table. The format should follow that recommended in the Style Guide on Moodle (or if not covered in the Style Guide, then that used in lectures or the textbook). For example, with a cost/benefit analysis the spreadsheet must be laid out in a specific way by adopting the given template on Moodle, making it very easy and clear to read to assist in marking. Task Marks Part A (12.5 marks) • Task 1 Online quizzes weeks 1-5 6.25 • Task 2 Tutorial activities and tasks in weeks 1-5 6.25 Part B (87.5 marks) • Task 1 (28 marks) Description of methodology 1 7.5 Description of methodology 2 7.5 Comparison of methodologies 13 • Task 2 (29 marks) Project Gantt Chart Content 15 Project Gantt Chart Format 7 Clear full Gantt chart in text 3 Explanation of Gantt chart 2 Explanation of assumptions supporting the project Gantt chart 2 • Task 3 (30.5) Cost/Benefit Analysis Content 7.5 Cost/Benefit Analysis Format 3 Correct breakeven period 3 Correct ROI 3 Clear Excel spreadsheet in text 3 Explain what breakeven period is (2.5 marks) and how your answer is doing what it does (2.5 marks) 5 Explain what ROI period means (2.5 marks) and what your answer means (2.5 marks) 5 Whether project is a worthwhile investment for project continuation 1 Assessment Total 100 Note: Your mark out of 100 will be scaled to 20% weight. COIT11226 Assignment 1 Term 1, 2019 Systems Analysis Page 4 of 4 The Tasks Task 1. System Development Methodology Provide a short description of each of the following system development methodologies, and then compare the two. The comparison should describe the advantages and disadvantages of one methodology versus the other. • Modified Waterfall Model • Extreme Programming Note that this question is not specific for the Scenario. What to include in your report for this task? 1. Description of both methodologies 2. Comparison of the methodologies Task 2. Project Gantt Chart For the Online SolarPower System project, create a Gantt chart for all iterations of the project. You must include allocation of personnel. Also provide an explanation of the Gantt chart, including any assumptions that were made in preparing it. What to include in your report for this task? 1. A screenshot or copy-and-paste of the full Gantt chart. You MUST also submit the original MS Project file 2. Explanation of Gantt chart and any assumptions Task 3. Economic Cost Feasibility/ Project Budgeting Conduct a 5-year cost/benefit analysis by completing all the following items: 1. Create an Excel spreadsheet in common format. 2. Explain the breakeven period for the project, including a. What breakeven period means, b. What different types values are obtained for this project, and c. What these values mean to the customer (Explain what breakeven period is and how your answer is doing what it does for the customer). 3. Explain the return on investment for the project, including a. What return on investment means, b. What its value is for this project and how the value means to the customer, and c. Whether the project is a worthwhile investment and the project should be continued or not. What to include in your report for this task? 1. A screenshot or copy-and-paste of the cost/benefit analysis spreadsheet. You MUST also submit the original MS Excel file. 2. Answers about the breakeven period 3. Answers about the return on investment COIT11226 Assessment 1 — Written Assessment Instructions Case Study – SolarPower (For both Assignments 1 and 2) Assessment Criteria Task 1. System Development Methodology Task 2. Project Gantt Chart Task 3. Economic Cost Feasibility/ Project Budgeting