case study

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

Unit Code and Title: BIS2002 Systems Analysis and Design / SBM4201 Systems Analysis and

Design

Assessment Overview

Assessment Task Weighting Due Length ULO

Assessment 1: Case Study -1 Covers the following topics Systems Development Life Cycle (SDLC), Work Breakdown Structure (WBS), PERT/CPM chart, NPV, ROI and payback period

30% Week 5 2500 words ULO1 ULO2 ULO3

Assessment 2: Case Study -2 Covers the following topics: use case diagram, ER diagram Class diagram, Sequence diagram, Activity diagram, user and system interfaces, and system testing, deployment and maintenance

30% Week 12 2500 words ULO1 ULO2 ULO3 ULO4

Assessment 3: Project Design Every two weeks exercises assess students’ ability to understand theoretical materials

40% Weekly N/A ULO1 ULO2 ULO3 ULO4 ULO5

Assessment 1: Case Study-1

Due date: Week 5

Group/individual: Group

Word count / Time provided: 2500 words

Weighting: 30%

Unit Learning Outcomes: ULO-1, ULO-2, ULO-3

Assessment Details:

In this assignment, you have to perform a system analysis and design for the Natural Best Health

store (NBH) case study provided at the case study section.

Case Study: Natural Best Health store (NBH)

Natural Best Health store is a chain of health stores provides different herbal supplements. The company wants to develop and deploy new ordering and delivery online System (OROS). The OROS required to install and configure email, web, database and management servers to provide the required services such as emails for staff and customers and suppliers, web page and database management system. In addition, the IT infrastructure must be established to provides the

Assessment Details

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

communication and networking facilities with the required security and system availability. Different types of network devices and supporting servers including switches and routers must be installed and configured with all the required cabling services. Security devices and backup services must be used to improve the system performance.

The institute wants to use two online ordering and delivery systems, Domestic Ordering and Delivery System (DODS) and International Ordering and Delivery System (IODS). The software developer staff at the IT department assigned the task of developing both Ordering and Delivery System from scratch.

The head of the company wants to conduct a complete testing procedure to the whole system to find any bug and problem prior to the final system deployment.

The database system of the new system must allow each customer in each order to be assigned with an advisor. The advisor helps customer to order right herbal supplement. Each customer should have an account before ordering any supplement. Hoverer, if the customer finds difficulty for creating account, the advisor should support them. The system must keep track of customers, the assigned advisor for each, by recording the name of the advisor that support customer ordering for each time.

The institute uses several methods to evaluate the investments in this project. Table 1 shows the information the accountant provided to the system analyst to calculate Net Present Value (NPV), Payback Period and Return on Investment (ROI).

Table 1: Five-year investment evaluation

Year

No. Category 0 1 2 3 4 5

1 Value of benefits $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00 $ 8,000.00

2 Development Cost -$ 20,000.00 $750.00 $800.00 $770.00 $750.00 $730.00

3 Annual expenses -$ 2,000.00 -$ 2,000.00 -$ 2,000.00 -$ 2,000.00 -$ 2,000.00

4 Net benefit/costs $ 10,000.00

5 Discount factor 1.00

6 Net present value -$ 10,000.00

7 Cumulative NPV -$ 10,000.00

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

Tasks:

1. Develop your introduction and clearly define the aims and objectives of the report.

2. The Systems Development Life Cycle (SDLC) identifies all the activities required to build, launch,

and maintain an information system. Discuss the six core processes of the SDLC required to

develop the NRS project in detail.

3. Develop a Work Breakdown Structure (WBS) description supported with a table for the NRS

project explaining the ID, description, and duration for each task.

4. Develop PERT/CPM chart explaining the early and late start for each task. Identify the critical

path and the total time to finish the project.

5. Use the information in Table 1, calculate the net present value, the payback period, and the

return on investment by using a discount rate of 6 percent. The development costs for the

project were $20,000. Do a five-year return on investment.

You may need to make some assumptions as required. Whenever you make assumptions, please

state these clearly.

Marking Criteria and Rubric: The assessment will be marked out of 100 and will be weighted 30%

of the total unit mark.

Marking Criteria Not satisfactory

(0-49%) of the criterion mark)

Satisfactory

(50-64%) of the criterion mark

Good

(65-74%) of the criterion mark

Very Good

(75-84%) of the criterion mark

Excellent

(85-100%) of the criterion mark

Introduction (10 marks)

Poor introduction with irrelevant details

Introduction is presented briefly and is missing the report outline

Introduction is generally presented along with the report outline

Introduction is well written, and the report outline is also discussed

Introduction is very well written, and the report outline is also discussed

Systems Development Life Cycle (SDLC) (25 marks)

Poorly discussion of the six core processes of the SDLC required developing the NRS project.

Brief discussion of the six core processes of the SDLC required developing the NRS project.

Good discussion of the six core processes of the SDLC required developing the NRS project.

Well discussion of the six core processes of the SDLC required developing the NRS project.

Excellent discussion of the six core processes of the SDLC required developing the NRS project.

Work Breakdown Structure (WBS) (15 mark)

Poor description with no poor table for the NRS project to include the ID, description, and duration for each task.

Brief description with brief table for the NRS project to include the ID, description, and duration for each task.

Generally good description with good supported table for the NRS project to explain the ID, description, and duration for each task.

Very clear description with good supported table for the NRS project to explain the ID, description, and duration for each task.

Very good description with very good supported table for the NRS project to explain the ID, description, and duration for each task.

PERT/CPM chart (20 mark)

Lack of evidence of understanding of PERT/CPM chart with no identification of critical path and the total time to finish the project.

Evidence of basic understanding of PERT/CPM chart with no clear identification of critical path and the total time to finish the project.

Evidence of good understanding and identification of PERT/CPM chart with clear identification of critical path and the total time to finish the project.

Very clear understanding and identification of PERT/CPM chart with clear identification of critical path and the total time to finish the project.

Has excellent understanding and identification of PERT/CPM chart with clear identification of critical path and the total time to finish the project.

Table-1 (20 mark)

Table-1 is missing or most of the required fields do not correct

Some fields of the table not correct or missing

All fields are available but many of them not accurate.

All field are available and some not very accurate

All fields are available and accurate

Summary (5 marks)

Summary not relating to the report

Brief summary of the report with some relevance

Generally good summary of the report

A section clearly summarizing the overall contribution

A section very clearly summarizing the overall contribution

References using Harvard style

(5 marks)

Lacks consistency with many errors.

Unclear referencing/style

Generally good referencing/style

Clear referencing/ style

Clear styles with excellent source of references.

5

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

Assessment 2: Case Study-2

Due date: Week 12

Group/individual: Individual

Word count / Time provided: 2500

Weighting: 30%

Unit Learning Outcomes: ULO-1 ULO-2 ULO-3 ULO-4

Assessment Details:

The Case Study-2 assessment covers the following topics: information system development, system

development approaches, data modeling, IS project management, system requirements, user and

system interfaces, and system testing, deployment and maintenance.

This assessment allows students to apply theoretical concepts to practice by analysing case studies

and proposing a suitable design. The Case Study-2 assessment covers the following topics:

information system development, system development approaches, data Modeling, IS project

management, system requirements, user and system interfaces, and system testing, deployment

and maintenance.

Case Study: Training Incorporated

Training Inc. conducts training seminars in major U.S. cities. For each seminar, the logistics

department must make arrangements for the meeting facilities, the training consultant’s travel, and

the shipment of any seminar materials. For each scheduled seminar, the bookings department

notifies the logistics coordinator of the type of seminar, the dates and city location, and the name of

the consultant who will be conducting the training. To arrange for the meeting facilities, the logistics

coordinator gathers information on possible meeting sites in the scheduled city. The meeting site

location decision is made based on date availability, cost, type of meeting space available, and

convenience of the location. Once the site is decided, the coordinator speaks with the sales manager

of the meeting facility to reserve the meeting room(s), plan the seating arrangement(s), and reserve

any necessary audio-visual equipment. The coordinator estimates the number and size of meeting

rooms, the type of seating arrangements, and the audio-visual equipment needed for each seminar

from the information kept in a logistics database on each type of seminar offered and the number of

anticipated registrants for a particular booking. After negotiations are conducted by the logistics

coordinator and the sales manager of the meeting facility, the sales manager creates a contract

agreement specifying the negotiated arrangements and sends two copies of it to the logistics

coordinator. The coordinator reviews the agreement and approves it if no changes are needed. One

copy of the agreement is filled and the other copy is sent back to the sales manager. If changes are

needed, the agreement copies are changed and returned to the sales manager for approval. This

approval process continues until both parties have approved the agreement. The coordinator must

also contact the training consultant to make travel arrangements. First, the coordinator reviews the

consultant’s travel information in the logistics database and researches flight schedules. Then the

consultant is contacted to discuss possible travel arrangements; subsequently, the coordinator

books a flight for the consultant with a travel agency. Once the consultant’s travel arrangements

have been completed, a written confirmation and itinerary are sent to the consultant. Two weeks

before the date of the seminar, the coordinator determines what, if any, seminar materials (e.g.,

transparencies, training guides, pamphlets, etc.) need to be sent to the meeting facility. Each type of

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

seminar has a specific set of materials assigned to it. For some materials, the coordinator must know

how many participants have registered for the seminar in order to determine how many to send. A

request for materials is sent to the material-handling department where the materials are gathered,

boxed, and sent to the meeting address listed on the request. Once the requested materials have

been shipped, a notification is sent the logistics coordinator.

Tasks:

• Draw use case description for scheduled seminar.

• Draw use case diagram

• Identify all entities and their attribute and draw an E-R (Entity-Relationship) diagram.

• Draw the class diagram

• Draw a Sequence diagram

• Draw activity diagram

• Design a data entry screen for entering seminar spesification.

• Design a screen for coordinator to determine for seminar materials which includes the

transparencies, training guides, pamphlets, number of participants, etc.

• Plan suitable testing and deployment activities.

if you believe that you need to make additional assumptions, clearly state them for each situation

*You can use Microsoft Visio or Microsoft Word to present your design.

Marking Criteria and Rubric: The assessment will be marked out of 100 and will be weighted 30%

of the total unit mark.

Marking Criteria

Not satisfactory

(0-49%) of the criterion mark)

Satisfactory

(50-64%) of the criterion mark

Good

(65-74%) of the criterion mark

Very Good

(75-84%) of the criterion mark

Excellent

(85-100%) of the criterion mark

Introduction (5 marks)

Poor introduction with irrelevant details

Introduction is presented briefly and is missing the report outline

Introduction is generally presented along with the report outline

Introduction is well written, and the report outline is also discussed

Introduction is very well written, and the report outline is also discussed

Use Case description (10 marks)

Poorly discussion of the use case description

Brief discussion of the use case description

Good discussion of the use case description

Well discussion of the use case description

Excellent discussion of the use case description

Use Case diagram (10 mark)

Lack of evidence of understanding of use case diagram

Evidence of basic understanding of use case diagram

Evidence of good understanding of use case diagram

Very clear understanding of use case diagram

Has excellent understanding of use case diagram

Entities, Attributes and ER diagram

(10 mark)

Poor identification and description of Entities, Attributes and ER diagram

Brief identification and description of Entities, Attributes and ER diagram

Generally good identification and description of Entities, Attributes and ER diagram

Very clear description identification and description of Entities, Attributes and ER diagram

Excellent identification and description of Entities, Attributes and ER diagram

Class Diagram (10 mark)

Lack of evidence of understanding of Class Diagram

Evidence of basic understanding of Class Diagram

Evidence of good understanding and identification of Class Diagram

Very clear understanding and identification of Class Diagram

Has excellent understanding and identification of Class Diagram

Sequence diagram (10 mark)

Poor identification and description of Sequence diagram

Brief identification and description of Sequence diagram

Generally good identification and description of

Very clear description identification and description of

Excellent identification and description of

7

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

Assessment 3: Project Design

Due date: Weekly

Group/individual: Individual

Word count / Time provided: N/A

Weighting: 40%

Unit Learning Outcomes: ULO-1, ULO-2, ULO-3, ULO-4, ULO-5

Assessment Details:

A project has been developed for the students to work on that throughout the semester. Students

will need to do various activities every week and will be required to provide answers and achieve

identified outcomes.

Students will not be assessed on work that the tutor has not seen them produce in class so that

attendance is required as part of this assessment. Students are required to submit the work that

they have completed during the tutorial session.

Project Design: Golden Training company

Sequence diagram Sequence diagram Sequence diagram

Activity diagram (10 mark)

Poor identification and description of activity diagram

Brief identification and description of activity diagram

Generally good identification and description of activity diagram

Very clear description identification and description of activity diagram

Excellent identification and description of activity diagram

Design a data entry screen (10 mark)

Poor design of data entry screen

Brief design of data entry screen

Good design of data entry screen

Well design of data entry screen

Excellent design of data entry screen

Design a booking appointment input

screen (10 mark)

Poor design of booking appointment input screen

Brief design booking appointment input screen

Good design booking appointment input screen

Well design of booking appointment input screen

Excellent design of booking appointment input screen

Testing and deployment

activities (10 mark)

Poor description of testing and deployment activities

Brief identification and description of testing and deployment activities

Generally good identification and description of testing and deployment activities

Very clear description identification and description of testing and deployment activities

Excellent identification and description of testing and deployment activities

Summary (5 marks)

Summary not relating to the report

Brief summary of the report with some relevance

Generally good summary of the report

A section clearly summarizing the overall contribution

A section very clearly summarizing the overall contribution

References using Harvard style

(5 marks)

Lacks consistency with many errors.

Unclear referencing/style

Generally good referencing/style

Clear referencing/ style

Clear styles with excellent source of references.

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

Nuk is the senior manager for Golden Training company. Three managers report to him: Sara

McGregor, finance manager; Jerry Fong, sales and marketing manager; and Tracy Xia, operations

manager. The managers run the 12 existing centers all report to Tracy.

Nuk wants the new center which includes a broad selection of personal services and special

programs for members. If the new center approach is successful, it will become the model for

Golden Training future growth. Nuk personally selected Danial Rogers, a manager with three years of

fitness center experience, to run the new facility. The new center will have a large exercise area and

the latest equipments, a swimming pool, a sporting goods shop, a health food store, and a snack bar.

In addition, the center will offer child care with special programs for various ages, a teen center, and

a computer café. Nuk also wants members to have online access to customized training programs

and progress reports. Personal Trainer currently uses QuickBook, a popular accounting package, to

manage its receivables, payables, and general ledger. Membership lists and word processing are

handled with Microsoft Office products. Nuk believes the new center will require additional data

management capability, and she decided to hire you as an IT consulter to help Golden Training

Company to develop an information system for the new operation.

You have just completed your Bachelor’s studies and got an opportunity to work in this project. You

need to produce a design for this application based on the University's requirements.

Task:

• Week1: a) Create an organization chart for Golden Training Company using Microsoft Word

or a similar program.b) Develop the six core processes of the SDLC required to develop the

project.

• Week2: Explain the responsibilities of the project manager for this project?

• Week3: Write a System Vision Document.

Further Information:

You would like to create work breakdown structure which includes the below tasks:

➢ First, you need to meet with fitness center managers at other Golden Training locations (10

days).

➢ After these meetings, you can conduct a series of interviews (8 days).

➢ When the interviews are complete, two tasks can begin at the same time: You can review

company records (2 days) and observe business operations (7 days).

➢ When you have reviewed the records and observed business operations, you can analyze

the QuickBook accounting software (3 days) and study a sample of sales and billing

transactions (1 day).

• Week4: a) Create a Work Breakdown Structure that lists all the steps to complete the

project. b) Develop PERT/CPM chart explaining the early and late start for each task. Identify

the critical path and the total time to finish the project.

Further Information:

For gathering requirements for the new system, you met with various managers in at several Golden

Training locations. They performed interviews, reviewed company records, observed business

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

operations, analyzed the QuickBook accounting software, and studied a sample of sales and billing

transactions. They wanted to develop a list of system requirements for the proposed system.

Fact-Finding Summary

• A new center has 400–600 members, with two membership options: full and partial. Full members

have access to all activities. Partial members are limited to activities they have selected, but they can

participate in other activities by paying a usage fee. All members have charge privileges. Charges for

merchandise and services are recorded on a charge slip, which is signed by the member. At the end

of each day, cash sales and charges are entered into the QuickBook accounting software, which runs

on a computer workstation at each location. Daily cash receipts are deposited in a local bank and

credited to the corporate Golden Training account. The QuickBook program produces a daily activity

report with a listing of all sales transactions. At the end of the month, the local manager uses

QuickBook to transmit an accounts receivable summary to the Golden Training head office in New

York, where member statements are prepared and mailed. Members mail their payments to the

Golden Training head office, where the payment is applied to the member account.

• The QuickBook program stores basic member information, but does not include information about

member preferences, activities, and history.

• Currently, the QuickBook program produces one local report (the daily activity report) and three

reports that are prepared at the head office location: a monthly member sales report, an exception

report for inactive members and late payers, and a quarterly profit and-loss report that shows a

breakdown of revenue and costs for each separate activity.

During the interviews, you received a number of “wish list” comments from local managers and staff

members. For example, many managers wanted more analytical features so they could spot trends

and experiment with what-if scenarios for special promotions and discounts. The most frequent

complaint was that managers wanted more frequent information about the profitability of the

business activities at their centers.

To enhance their business, managers wanted to offer a computerized activity and wellness log, a

personal coach service, and e-mail communication with members. Managers also wanted better

ways to manage information about part-time instructors and staff. Several staff members suggested

a redesign for the charge slips or scannable ID cards.

• Week5: a) Draw Activity diagram for purchase or cancel membership. b) Draw the use case

diagram for the purchase or cancel membership.

• Week6: a) Draw the Class diagram for the purchase or cancel membership. b) Draw an

entity-relationship diagram for the purchase or cancel membership.

• Week7: a) Complete a fully developed use case description for Purchase membership,

Cancel membership and Add memebership. b) Draw the System Sequence diagram (SSD) for

the purchase or cancel membership.

• Week8: a) Draw a network diagram that will support this configuration.

• Week9: Design the complete User & System Interfaces for membership input screen.

• Week10: Plan suitable testing and deployment activities.

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

Marking Criteria and Rubric: The assessment will be marked out of 100 and will be weighted 40%

of the total unit mark

Marking Criteria Not satisfactory

(0-49%) of the criterion mark)

Satisfactory

(50-64%) of the criterion mark

Good

(65-74%) of the criterion mark

Very Good

(75-84%) of the criterion mark

Excellent

(85-100%) of the criterion mark

Create an organization chart for Golden Training Company ( 5 marks)

Poorly illustration of the organization chart.

Brief illustration of the organization chart.

Good illustration of the organization chart.

Well illustration of the organization chart.

Excellent illustration of the organization chart.

Systems Development Life Cycle (SDLC) (5 marks)

Poorly discussion of the six core processes of the SDLC required developing the project.

Brief discussion of the six core processes of the SDLC required developing the project.

Good discussion of the six core processes of the SDLC required developing the project.

Well discussion of the six core processes of the SDLC required developing the project.

Excellent discussion of the six core processes of the SDLC required developing the project.

Project manager responsibilities (5 marks)

Poorly discussion of the Project manager responsibilities

Brief discussion of the Project manager responsibilities

Good discussion of the Project manager responsibilities

Well discussion of the Project manager responsibilities

Excellent discussion of Project manager responsibilities

System Vision Document (5 marks)

Poorly discussion of the System Vision Document

Brief discussion of the System Vision Document

Good discussion of the System Vision Document

Well discussion of the System Vision Document

Excellent discussion of the System Vision Document

Work Breakdown Structure (WBS) (5 mark)

Poor description with no poor table for the project to include the ID, description, and duration for each task.

Brief description with brief table for the project to include the ID, description, and duration for each task.

Generally good description with good supported table for the project to explain the ID, description, and duration for each task.

Very clear description with good supported table for the project to explain the ID, description, and duration for each task.

Very good description with very good supported table for the project to explain the ID, description, and duration for each task.

PERT/CPM chart (5 mark)

Lack of evidence of understanding of PERT/CPM chart with no identification of critical path and the total time to finish the project.

Evidence of basic understanding of PERT/CPM chart with no clear identification of critical path and the total time to finish the project.

Evidence of good understanding and identification of PERT/CPM chart with clear identification of critical path and the total time to finish the project.

Very clear understanding and identification of PERT/CPM chart with clear identification of critical path and the total time to finish the project.

Has excellent understanding and identification of PERT/CPM chart with clear identification of critical path and the total time to finish the project.

Activity diagram (5 mark)

Poor identification and description of activity diagram

Brief identification and description of activity diagram

Generally good identification and description of activity diagram

Very clear description identification and description of activity diagram

Excellent identification and description of activity diagram

Use Case diagram (5 mark)

Lack of evidence of understanding of use case diagram

Evidence of basic understanding of use case diagram

Evidence of good understanding of use case diagram

Very clear understanding of use case diagram

Has excellent understanding of use case diagram

Class Diagram (10 mark)

Lack of evidence of understanding of Class Diagram

Evidence of basic understanding of Class Diagram

Evidence of good understanding and identification of Class Diagram

Very clear understanding and identification of Class Diagram

Has excellent understanding and identification of Class Diagram

Entities, Attributes and ER diagram (5 mark)

Poor identification and description of Entities, Attributes and ER diagram

Brief identification and description of Entities, Attributes and ER diagram

Generally good identification and description of Entities, Attributes and ER diagram

Very clear description identification and description of Entities, Attributes and ER diagram

Excellent identification and description of Entities, Attributes and ER diagram

Use Case description (10 marks)

Poorly discussion of the use case description

Brief discussion of the use case description

Good discussion of the use case description

Well discussion of the use case description

Excellent discussion of the use case description

Sequence diagram (10 mark)

Poor identification and description of Sequence

Brief identification and description of

Generally good identification and

Very clear description identification and

Excellent identification and description of

Asia Pacific International College Pty Ltd. Trading as Asia Pacific International College PRV12007; CRICOS 03048D Approved: 2/10/2020

diagram Sequence diagram description of Sequence diagram

description of Sequence diagram

Sequence diagram

Network Diagram (5 mark)

Lack of evidence of understanding of Network Diagram

Evidence of basic understanding of Network Diagram

Evidence of good understanding and identification of Network Diagram

Very clear understanding and identification of Network Diagram

Has excellent understanding and identification of Network Diagram

User & System Interfaces (10 marks)

Lack of evidence of understanding of User & System Interfaces

Evidence of basic understanding of User & System Interfaces

Evidence of good understanding and identification of User & System Interfaces

Very clear understanding and identification of User & System Interfaces

Has excellent understanding and identification of User & System Interfaces

Testing and deployment activities (10 mark)

Poor description of testing and deployment activities

Brief identification and description of testing and deployment activities

Generally good identification and description of testing and deployment activities

Very clear description identification and description of testing and deployment activities

Excellent identification and description of testing and deployment activities

9