project

ICTSAD502 – Assessment Task 2 Practical Project Activity

Task summary

The purpose of this assessment task is to assess the student’s knowledge essential to applying broad principles of originate and develop concepts in the ICT (Information and Communications Technology) industry. It includes understanding how client requirements are evaluated, developing creative approaches, refining concepts, and implementing those concepts. This assessment is to be completed in the simulated work environment in the ECA (Education Centre of Australia) College.

Required

· Access to textbooks/other learning materials

· Computer with Microsoft Office and internet access

· Meeting space with a presentation projector and screen

Adobe acrobat/reader

Learning management system

Excel

Modelling tools

Email template

Organisational standards for data dictionary

Timing

Your assessor will advise you of the due date of these submissions.

Submit

1. ICTSAD502 task 2 project portfolio section 1 and 2

Assessment criteria

All questions must be answered correctly for you to be assessed as having completed the task satisfactorily.

Assessment Task 2 Instructions

Carefully read the following scenario:

EGI College is a private Registered Training Organisation (RTO) with a campus based in Sydney CBD, it offers over 40 certificate and diploma level qualifications in the Vocational Education and Training (VET) sector for many subject areas including business, community services, education, information technology, health, hospitality, and many others.

Students select from one of two study shifts (morning or afternoons) to undertake study, which is self-directed in nature or trainer led, and to undertake assessments.

There are currently 450 students that attend the institute across a wide range of classrooms. Depending on their studies, students who require access to a computer are given access Windows 10 desktop machine and a word processor, spreadsheet, presentation, and other software applicable to their studies plus access the internet.

Student management is undertaken on a bespoke application called “Student Manager.” Student Manager is a tool used to record student attendance, unit completion, student’s notes, and other applicable student management tasks.

EGI College use a mixture of laptops and desktop machines which all have Windows 10 and Microsoft Office 2016 installed on them. The network is managed by two servers:

• Admin server has Windows Server 2016 installed on it and is used by the employees of EGI College. It includes active directory, DNS (Domain Name Service), DHCP (Dynamic Host Configuration Protocol), and acts as the gateway to the internet. It also asks as an application server for the Student manager application and its associated database.

• A Student server also has Windows Server 2016 installed on it and is used by the students for study purposes. It also has active directory on it, and a separate domain implementing DNS and DHCP services.

Network Attached Storage is used for accessing both staff and student files. A UPS is used to protect the network from power loss and electrical surges.

The current network diagram of how the network components fits together is shown as follows:

The strategic goals which is a part of the organisation’s Strategic Plan as follows,

Mission

To provide quality education.

Vision

To become Australia’s number one education provider using modern technologies and teaching platforms.

Objectives

The current objectives are:

• To deliver first-class education using modern technologies

• To provide customer service excellence beyond expectations

• To implement sustainable practices

Strategic Goals

The current goals are:

• To offer students new ways of learning

• To expand throughout Australia

• Increase student numbers for the 2019 year

You work in the information technology department at EGI College at its campus in Sydney.

Employee

Position

Hourly rate

Yourself

IT (Information Technology) Technician

$35

Kim Brown

Networking Administrator

$45

Stephan Curry

Web Developer

$35

Murphy O’Shea

Web Designer

$35

Renju Chalakudy

LMS Specialist

$38

John Smith

Database Administrator

$45

Mary Jones

Business Analyst

$50

Penny Taylor

Trainer/assessor

$30

This case study includes information about the qualifications/Course timetable of EGI.

Below are the business rules for this college.

1. For each Qualification, the following information is recorded

a. a Qualification Code,

b. name of the course, duration,

c. name of the teacher assigned to teach the course,

d. the number of classes each week.

2. A Teacher can teach multiple classes.

3. Each class is only taught by one teacher.

4. For each teacher, the following information is recorded:

a. Employee Number, name,

b. name of the department he/she works with,

c. skills,

d. the hourly rate.

5. For each class, the following information is recorded:

a. class number,

b. weekdays,

c. starting time,

d. ending time.

e. One qualification can have many classes.

6. For each room, the following information is recorded:

a. room number,

b. room type (classroom, office, auditorium, and computer lab),

c. capacity.

d. One room can have multiple classes.

The above information is used to make the right assignment of a teacher that teaches a particular course to a class and a classroom.

Above diagram is IEEE 1016, which need to be followed as organisational standard for the modelling development.

Note: To continue the below task, please make sure to complete the ICTSAD501 assessment task 2 activity. It is a continuation of ICTSAD501 task 2 activity.

Part 2 (ICTSAD502)

Task 3.

Develop scope of model as per the identified ER in the case study using minimum 3 information gathering methods and document the model with required process detail. Perform the following tasks (3.1, 3.2, 3.3) and u
se ICTSAD502 task 2 project portfolio Section 1 to document the following tasks.

· Task 3.1 Identify relevant data processes and sources of information.

· Task 3.2 Identify information gathering method and modelling method to be used in this scenario.

· Task 3.3 Document modelling information gathered

Task 4

Gather the process data as per the case study and describe the business function, external events, procedures, and outcomes as per the scenario. Complete the following tasks (4.1,4.2,4.3). Use ICTSAD502 task 2 project portfolio Section 2 to document the following tasks.

· Task 4.1 Identify business functions and collect process data using chosen method.

· Task 4.2 Identify external events, procedures, and results.

· Task 4.3 Identify processes and required decomposition and create context diagram

Task 5

Develop DFD (Data Flow Diagrams) and validate data model as per the case study. Save this document as “__DFD and upload.

· Task 5.1 Model process data according to modelling method DFD diagram.

Copyright© ECA College RTO 45012 v20.0​ Page
2 of
9

image1

image2

image3

ICTSAD501 – Model data objects

Section 1: Analyse and Identify entities and relationships

Develop the Entity Relationship (ER) diagram using opensource ER Design tool/VISIO. Attach the ER design screenshot including the below task answers in the word document.

Business Requirements

Provide an outline of the client’s business and their specific requirements.

Analyse business data
Summarise the operations by listing the entities and data required by these entities from this case study.

.

Identify the boundaries
Identify and list the boundaries of the system as per the case study.

ER Diagram

Identify entities, attributes, data types and relationships of data by documenting an entity relationship diagram (ERD).

Relationship cardinality
Introduce and confirm the relationship cardinality in the ERD as per the business rule stated in the case study.

Section 2: Normalisation Table

Data Types

Identify the suitable business data and list the fields with data types as per the information provided.

1NF

Perform the normalisation on the above table using the first normal form(1NF) and document the results

2NF

Perform the normalisation on the above table using the second normal form(2NF) and document the results

3NF or Final normalisation

Perform the normalisation on the above table using the third normal form(3NF) and document the results

Compare normalised table with ERD

Compare the normalisation results with ERD and write your comments.

Differences between NF data and ERD

Identify the differences between data and ERD with relevant explanation.

ECA College RTO 45012 v21.0​ Page
2 of
2

image1