Course Outline

ICT705 Data and System Integration

Course Coordinator:Damian Hills (dhills1@usc.edu.au) School:School of Science, Technology and Engineering

2021ATMC Semester 1

USC Sydney

USC Melbourne

Blended learning Most of your course is on campus but you may be able to do some components of this course online.

Please go to usc.edu.au for up to date information on the
teaching sessions and campuses where this course is usually offered.

What is this course about?

Description

Enterprises generally own various operational systems and data storage across departments and locations. The integration of their processes and data becomes vital to achieve the goal of "Intelligent Enterprise" and gaining competitive advantage. This course helps you to learn the foundational knowledge and best practices in enterprise application and data integration. You will gain experience in creating strategic business solutions using Web services and integrators to integrate the functionality and data of an organisation's existing applications and future plans.

How will this course be delivered?

Activity Hours Beginning Week Frequency
Blended learning
Lecture 1hr Not applicable Not Yet Determined
Laboratory 1 2hrs Not applicable Not Yet Determined

Course Topics

Week Topic
1 Introduction
2 Enterprise information architecture
3 Service oriented computing
4 Web services & SOAP
5 In class Exam
6 RESTful services & mashups
7 Cloud computing
8 Application integration
9 Data warehousing
10 Extract Transform and Load
11 Schema manipulation
12 Wrappers and query processing

 

What level is this course?

700 Level (Specialised)

Demonstrating a specialised body of knowledge and set of skills for professional practice or further learning. Advanced application of knowledge and skills in unfamiliar contexts.

What is the unit value of this course?

12 units

How does this course contribute to my learning?

Course Learning Outcomes On successful completion of this course, you should be able to... Graduate Qualities Completing these tasks successfully will contribute to you becoming...
1 Discuss the recent developments in theory, issues and practice relating to application and data integration. Knowledgeable
2 Investigate, evaluate, and plan the lifecycle of data through an organisation Creative and critical thinker
Engaged
3 Use scripting languages and tools to manipulate, analyse and transform big data, including cloud-based solutions. Creative and critical thinker
Empowered
4 Apply discipline specific knowledge and skills to problems. Knowledgeable
Empowered
5 Demonstrate advanced written communication skills in a business context. Engaged

Am I eligible to enrol in this course?

Refer to the UniSC Glossary of terms for definitions of “pre-requisites, co-requisites and anti-requisites”.

Pre-requisites

Enrolled in a Postgraduate Program

Co-requisites

Not applicable

Anti-requisites

Not applicable

Specific assumed prior knowledge and skills (where applicable)

Not applicable

How am I going to be assessed?

Grading Scale

Standard Grading (GRD)

High Distinction (HD), Distinction (DN), Credit (CR), Pass (PS), Fail (FL).

Details of early feedback on progress

Task 1 will be an opportunity to give students feedback on their understanding of their knowledge of enterprise information architecture at a business level.

Assessment tasks

Delivery mode Task No. Assessment Product Individual or Group Weighting % What is the duration / length? When should I submit? Where should I submit it?
All 1 Examination - not Centrally Scheduled Individual 20%
1hr
Week 5 Online Test (Quiz)
All 2 Examination - not Centrally Scheduled Individual 40%
2 hours
Week 9 Online Test (Quiz)
All 3 Artefact - Technical and Scientific, and Written Piece Individual 40%
Working code and application plus 750 word report
Week 12 Online Assignment Submission with plagiarism check
All - Assessment Task 1:Mid Sem Exam
Goal:
This assessment task will demonstrate your knowledge of Enterprise Information Architecture and Service Computing covering material from weeks 1 to 4 inclusive.
Product: Examination - not Centrally Scheduled
Format:
This one-hour examination consists of a set of multiple-choice questions and short answer questions to test the understanding and application of concepts. This is an individual assessment.
Criteria:
No. Learning Outcome assessed
1
Relevancy and synthesis of theory and practice relating EIA and Service Computing
4
2
Application of specific knowledge and skills to business enterprise problems
4
All - Assessment Task 2:Week 9 Exam
Goal:
This assessment task will demonstrate your knowledge of all material covered in this course
Product: Examination - not Centrally Scheduled
Format:
This two-hour examination will consist of a set of multiple choice questions and short answer questions to test understanding and application of concepts. This is an individual assessment.
Criteria:
No. Learning Outcome assessed
1
Your responses on the exam questions will be assessed on the basis of your demonstration of knowledge from the workshop activities, lectures and readings specified during the lecture series.
1 4
All - Assessment Task 3:Systems Integration in Practice
Goal:
You will demonstrate your ability to integrate heterogeneous systems into a cohesive application.
Product: Artefact - Technical and Scientific, and Written Piece
Format:
You will be given a case study and will develop an application to suit the case study's functionality needs. You will use tools developed in computer workshops to achieve the application and data integration requirements. Beside the runnable application, you also need to present your design and analysis in the form of a written report. A guideline structure will be provided on Blackboard.
Criteria:
No. Learning Outcome assessed
1
Presentation of a cohesive application - including user interface, code structure and readability
3
2
Design and analysis to suit the case study
2 4
3
Demonstrate advanced written communication skills in a business context
5

Directed study hours

A 12-unit course will have total of 150 learning hours which will include directed study hours (including online if required), self-directed learning and completion of assessable tasks. Student workload is calculated at 12.5 learning hours per one unit.

What resources do I need to undertake this course?

Please note: Course information, including specific information of recommended readings, learning activities, resources, weekly readings, etc. are available on the course Canvas site– Please log in as soon as possible.

Prescribed text(s) or course reader

Please note that you need to have regular access to the resource(s) listed below. Resources may be required or recommended.

Required? Author Year Title Edition Publisher
Required AnHai Doan, Alon Halevy, and Zachary Ives 2012 Principles of Data Integration Morgan Kaufmann
Required Mario Godinez, Eberhard Hechler, Klaus Koenig, Steve Lockwood, Martin Oberhofer, Michael Schroeck 2010 The Art of Enterprise Information Architecture: A Systems-Based Approach for Unlocking Business Insight n/a IBM Press

Specific requirements

Not applicable

How are risks managed in this course?

Health and safety risks for this course have been assessed as low. It is your responsibility to review course material, search online, discuss with lecturers and peers and understand the health and safety risks associated with your specific course of study and to familiarise yourself with the University’s general health and safety principles by reviewing the online induction training for students, and following the instructions of the University staff.

What administrative information is relevant to this course?

Assessment: Academic Integrity

Academic integrity is the ethical standard of university participation.  It ensures that students graduate as a result of proving they are competent in their discipline.  This is integral in maintaining the value of academic qualifications. Each industry has expectations and standards of the skills and knowledge within that discipline and these are reflected in assessment.

Academic integrity means that you do not engage in any activity that is considered to be academic fraud; including plagiarism, collusion or outsourcing any part of any assessment item to any other person.  You are expected to be honest and ethical by completing all work yourself and indicating in your work which ideas and information were developed by you and which were taken from others. You cannot provide your assessment work to others. You are also expected to provide evidence of wide and critical reading, usually by using appropriate academic references.

In order to minimise incidents of academic fraud, this course may require that some of its assessment tasks, when submitted to Canvas, are electronically checked through Turnitin.  This software allows for text comparisons to be made between your submitted assessment item and all other work to which Turnitin has access.

Assessment: Additional Requirements

Eligibility for Supplementary Assessment

Your eligibility for supplementary assessment in a course is dependent of the following conditions applying:

The final mark is in the percentage range 47% to 49.4%
The course is graded using the Standard Grading scale
You have not failed an assessment task in the course due to academic misconduct

Assessment: Submission penalties

Late submission of assessment tasks may be penalised at the following maximum rate: 
- 5% (of the assessment task's identified value) per day for the first two days from the date identified as the due date for the assessment task. 
- 10% (of the assessment task's identified value) for the third day - 20% (of the assessment task's identified value) for the fourth day and subsequent days up to and including seven days from the date identified as the due date for the assessment task. 
- A result of zero is awarded for an assessment task submitted after seven days from the date identified as the due date for the assessment task. Weekdays and weekends are included in the calculation of days late. To request an extension you must contact your course coordinator to negotiate an outcome.

SafeUniSC

UniSC is committed to a culture of respect and providing a safe and supportive environment for all members of our community. For immediate assistance on campus contact SafeUniSC by phone: 07 5430 1168 or using the SafeZone app. For general enquires contact the SafeUniSC team by phone 07 5456 3864 or email safe@usc.edu.au.

The SafeUniSC Specialist Service is a Student Wellbeing service that provides free and confidential support to students who may have experienced or observed behaviour that could cause fear, offence or trauma. To contact the service call 07 5430 1226 or email studentwellbeing@usc.edu.au.

Study help

For help with course-specific advice, for example what information to include in your assessment, you should first contact your tutor, then your course coordinator, if needed.

If you require additional assistance, the Learning Advisers are trained professionals who are ready to help you develop a wide range of academic skills. Visit the Learning Advisers web page for more information, or contact Student Central for further assistance: +61 7 5430 2890 or studentcentral@usc.edu.au.

Wellbeing Services

Student Wellbeing provide free and confidential counselling on a wide range of personal, academic, social and psychological matters, to foster positive mental health and wellbeing for your academic success.

To book a confidential appointment go to Student Hub, email studentwellbeing@usc.edu.au or call 07 5430 1226.

AccessAbility Services

Ability Advisers ensure equal access to all aspects of university life. If your studies are affected by a disability, learning disorder mental health issue, injury or illness, or you are a primary carer for someone with a disability or who is considered frail and aged, AccessAbility Services can provide access to appropriate reasonable adjustments and practical advice about the support and facilities available to you throughout the University.

To book a confidential appointment go to Student Hub, email AccessAbility@usc.edu.au or call 07 5430 2890.

Links to relevant University policy and procedures

For more information on Academic Learning & Teaching categories including:

  • Assessment: Courses and Coursework Programs
  • Review of Assessment and Final Grades
  • Supplementary Assessment
  • Central Examinations
  • Deferred Examinations
  • Student Conduct
  • Students with a Disability

For more information, visit https://www.usc.edu.au/explore/policies-and-procedures#academic-learning-and-teaching

Student Charter

UniSC is committed to excellence in teaching, research and engagement in an environment that is inclusive, inspiring, safe and respectful. The Student Charter sets out what students can expect from the University, and what in turn is expected of students, to achieve these outcomes.

General Enquiries

  • In person:
    • UniSC Sunshine Coast - Student Central, Ground Floor, Building C, 90 Sippy Downs Drive, Sippy Downs
    • UniSC Moreton Bay - Service Centre, Ground Floor, Foundation Building, Gympie Road, Petrie
    • UniSC SouthBank - Student Central, Building A4 (SW1), 52 Merivale Street, South Brisbane
    • UniSC Gympie - Student Central, 71 Cartwright Road, Gympie
    • UniSC Fraser Coast - Student Central, Student Central, Building A, 161 Old Maryborough Rd, Hervey Bay
    • UniSC Caboolture - Student Central, Level 1 Building J, Cnr Manley and Tallon Street, Caboolture
  • Tel:+61 7 5430 2890
  • Email:studentcentral@usc.edu.au