ICTNWK548 – Model preferred system solutions
Section 1: Organise the team meeting with assessor to review and confirm information requirements and existing models
Review information requirements
Review information requirements and clarify at-least 4 areas that are not understood.
Organisational standards
Identify organisational standards for developing models and check the model
Assumptions
Identify assumptions and incorporate into modelling process.
WBS (Work breakdown Structure)
Identify goals and resolve into tasks required to be performed to obtain goals by creating WBS (Work breakdown Structure) for new system development.
Internal tasks
Define internal tasks needed to perform identified goals for modelling data objects ERD.
Organise meeting:
Use the email template to draft the meeting invitation to the team. You could attach as separate file or past the drafted message here.
Meeting Outcome
Summarise the meeting discussion here.
Section 2: Problem Solving – Outline the issues identified and resolving methods to handle the conflicts and inconsistencies
Missed Opportunity
Identify missed opportunities arising from previous and current model development
Bottlenecks, overlooked functionalities and other issues
Identify bottlenecks, overlooked functionalities and other issues, and resolve with client input as required.
Section 3: Build and test model
Model
Develop model based on existing architecture by creating the use case model.
Validate the Model
Document details of model, according to agreed project or organisational standards by creating the data dictionary based on the ERD diagram of Task 1.3 & Task 1.5 from ICTSAD501 Project.
Data Dictionary
Develop data dictionary. Please follow the organisational standards for Data dictionary that is provided under the assessment template.
Test Model
Test model against the test plan by preparing the checklist items to be checked in the database.
Test procedure
Document test data to ensure that test procedures validate performance of the model.
Section 4: Review and sign off
Email Draft for final review and sign off
Develop Email Draft for final review and sign off
Communication technology
Ensure a consensus view of key information and communications technology (ICT) of stakeholders which is represented in data, process, and system model by discussing with stakeholders in a team (Trainer-Project Sponsor)
Project Sponsor confirmation
Ensure that object, process, and system model is checked by key ICT stakeholders (Trainer-Project Sponsor) to confirm common knowledge of the models and the proposed solution by revising these models if necessary.
Approval request as per the feedback update
Submit revised data model, process model and system solutions to the approvers (Trainer-Project Sponsor) for sign-off by writing and email with necessary attachments.
ECA College RTO 45012 v21.0 Page
2 of
2
image1
ICTSAD502- Model data processes
Section 1: Develop scope of model
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.
Data process
Identify relevant data processes and sources of information.
Methods
·
Identify information gathering method to be used in this scenario.
·
Identify modelling method to be used in this scenario.
Modelling information
Document modelling information gathered.
Gather the process data as per the case study and describe the business function, external events, procedures, and outcomes as per the scenario.
·
Identify business functions and collect process data using chosen method.
·
Identify external events, procedures, and results.
Context Diagram
Identify processes and required decomposition and create context diagram
Section 2: Data Flow Diagram (DFD)
DFD
Model process data according to modelling method DFD diagram.
Validate Data model
Confirm the Data model meets the requirements as per the case study.
ECA College RTO 45012 v21.0 Page
2 of
2
image1
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
This document is organisational standards for Data dictionary.
It is part of the supporting assessment resources for Assessment Tasks 2 for ICTSAD
5
01-ICTSAD502-ICTNWK548
|
How to Make a Data Dictionary? A data dictionary is critical to making your research more reproducible because it allows others to understand your data. The purpose of a data dictionary is to explain what all the variable names and values in your spreadsheet really mean. Variable names The first column should contain your variable names exactly as they appear in your spreadsheet. Readable variable name This column should contain short but human-readable variable names · For instance, if ‘VAR1’ is a variable name referring to weight, then an appropriate readable variable name for VAR1 is ‘weight’. · You can use spaces, characters, and capital letters. · This is the name that you would use to label graphs and other figures. Measurement units · This column should contain the measurement units for the variable. · For instance, if a column contains measurements of time, it should be clear whether they are measured in hours, minutes, or seconds. Allowed values · A column should contain the range of values or accepted values for the variable. |
|
· This helps identify data entry errors. · Minimum and maximum values should be included. · Chosen values (e.g., “male”, “female”) should be included and detailed, if needed, in the description column. Definition of the variable This column should contain a definition of the variable. The variable definition reflects the way you use the term and intend the term to be used by others who wish to understand your work. Synonyms for the variable name (optional) · This column should contain, if relevant, one or more words that could be substituted for the variable name. · These synonyms should reflect the meaning of the variable name as you use it, and not merely as the variable name might be used in a different context. · Again, the purpose is to convey the meaning of the variable term you use in your data. Description of the variable (optional) The final column should contain, where needed, a longer explanation of the variable. · This is a human readable description with enough information for others to understand what the variable refers to. · It should also explain terms in the variable’s definition in more depth if needed. For instance, a description of the variable might clarify what is intended by ‘disposition’ in the above definition. · It could provide sources for definitions if those definitions are not the researcher’s own. Other resources · The Data Documentation Initiative (DDI) is an international standard for describing the data produced by surveys and other observational methods in the social, behavioural, economic, and health sciences. Learn more at: · Example data dictionaries provided by the · USGS: https://www2.usgs.gov/datamanagement/describe/dictionaries.php |
5
Copyright© ECA College RTO 45012 v20.0
image1
image2
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 “
· 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
ICTNWK548 – 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. ICTNWK548 task 2 project portfolio section 1 to 4
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 and ICTSAD502 assessment task 2 activity. It is a continuation of ICTSAD501 task 2 activity.
Part 3 (ICTNWK548)
Task 6.
Organise the team meeting with assessor to review and confirm information requirements and existing models. Use the email template to send the meeting invitation to the team. Before the meeting analyse the design and prepare the meeting item as per the following tasks (6.1,6.2,6.3,6.4,6.5), Use ICTNWK548 task 2 project portfolio Section 1 to document the following tasks.
· Task 6.1 Review information requirements and clarify at-least 4 areas that are not understood
· Task 6.2 Identify organisational standards for developing models and check the model development method for consistency with organisational goals by listing the rules from the diagram given in the case study.
· Task 6.3 Identify assumptions and incorporate into modelling process.
· Task 6.4 Identify goals and resolve into tasks required to be performed to obtain goals by creating WBS (Work breakdown Structure) for new system development.
· Task 6.5 Define internal tasks needed to perform identified goals for modelling data objects ERD.
Task 7.
Outline the issues identified and resolving methods to handle the conflicts and inconsistencies by answering the tasks 7.1 and 7.2. Use ICTNWK548 task 2 project portfolio Section 2 to document the following tasks.
· Task 7.1 Identify missed opportunities arising from previous and current model development
· Task 7.2 Identify bottlenecks, overlooked functionalities and other issues, and resolve with client input as required.
Task 8.
Build and test model by completing the tasks 8.1 to 8.5. Use the organisational standards for Data dictionary document available in the assessment template as a guideline to prepare the data dictionary. Complete the following tasks and use ICTNWK548 task 2 project portfolio Section 3 to document the following tasks.
· Task 8.1 Develop model based on existing architecture by creating the use case model.
· Task 8.2 Document details of model, according to agreed project or organisational standards by creating the data dictionary based on the ERD diagram of Task 1.3 & Task 1.5.
· Please follow the organisational standards for Data dictionary that is provided under the assessment template.
· Task 8.3 Develop model according to project deliverables and acceptance criteria within determined timeframe and project constraints by creating the database based on the data dictionary created in the task 8.2. Submit the screen shots of your database including relationship.
· Task 8.4 Test model against the test plan by preparing the checklist items to be checked in the database.
· Task 8.5 Document test data to ensure that test procedures validate performance of the model.
Task 9.
Send email using Email template to team (Trainer-Project Sponsor) for final review and sign off.
Conduct the meeting to verify the data model to ensure that the model represents a workable solution. Complete the following tasks (9.1,9.2,9.3). Use ICTNWK548 task 2 project portfolio Section 4 to document the following tasks.
· Task 9.1 Ensure a consensus view of key information and communications technology (ICT) of stakeholders which is represented in data, process, and system model by discussing with stakeholders in a team (Trainer-Project Sponsor)
· Task 9.2 Ensure that object, process, and system model is checked by key ICT stakeholders (Trainer-Project Sponsor) to confirm common knowledge of the models and the proposed solution by revising these models if necessary.
· Task 9.3 Submit revised data model, process model and system solutions to the approvers (Trainer-Project Sponsor) for sign-off by writing and email with necessary attachments.
Copyright© ECA College RTO 45012 v20.0 Page
2 of
9
image1
image2
image3
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
