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 XXXXXXXXXXmarks)
• 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 XXXXXXXXXXmarks)
• 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
edirect?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
usiness 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 a
ange 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 cu
ently 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 ca
ied 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, XXXXXXXXXXThey foresaw a consistent recu
ing 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
enefit
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
enefit 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 XXXXXXXXXX
• Task 2
Tutorial activities and tasks in weeks XXXXXXXXXX
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 XXXXXXXXXXmarks)
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 XXXXXXXXXX)
Cost/Benefit Analysis Content 7.5
Cost/Benefit Analysis Format 3
Co
ect
eakeven period 3
Co
ect ROI 3
Clear Excel spreadsheet in text 3
Explain what
eakeven 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
enefit analysis by completing all the following items:
1. Create an Excel spreadsheet in common format.
2. Explain the
eakeven period for the project, including
a. What
eakeven period means,
. What different types values are obtained for this project, and
c. What these values mean to the customer (Explain what
eakeven 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,
. 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
enefit analysis spreadsheet. You MUST also
submit the original MS Excel file.
2. Answers about the
eakeven 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