Diploma in Computer Technology (AAT Training Hub)

• At least 18 years old at the start date of the course
• Minimum 3 GCE ‘O’ level at grades C6 and above including English or equivalent qualifications like IGCSE or SPM
• or
• Matured candidates who are at least 30 years old and minimum 8 years of working experience
• Minimum C6 grade in GCE ‘O’ Level English or equivalent qualifications

Note: SPM Grades A+ to C are equivalent to GCE ‘O’ Level Grades 1 to 6

Information not available

Curriculum

Computing 101

• Knowledge of basic computing concepts, security measures and the ability to use popular software applications to produce documents, spreadsheets and presentations.

Database systems

• Describe the fundamental elements of relational database management systems
• Explain the basic concepts of relational data model, entity-relationship model, relational database design, relational algebra and SQL
• Design ER-models to represent simple database application scenarios
• Convert the ER-model to relational tables, populate relational database and formulate SQL queries on data
• Improve the database design by normalization.
• Familiar with basic database storage structures and access techniques: file and page organizations, indexing methods including B tree, and hashing.

HTML and CSS

• Understand the principles of creating an effective web page, including an in-depth consideration of information architecture.
• Become familiar with graphic design principles that relate to web design and learn how to implement theories into practice.
• Develop skills in analyzing the usability of a web site.
• Understand how to plan and conduct user research related to web usability.
• Learn the language of the web: HTML and CSS.
• Learn CSS grid layout and flexbox.

PHP and MySQL

• Utilize CRUD statements in SQL – Create, read, update and delete records in a database.
• Simple authentication and security – Logging in and out, handling unauthorized users and restricting access.
• Simple time and date manipulation – Displaying time and date postings and monitoring your posts.
• Displaying public and private data – Simply display information for logged-in users only and for the public

JavaScript

• Develop basic programming skills using Javascript and jQuery.

Web Application Development

• Practice implementation of the various tools to build an app
• Implement a testing process

 Project

• Create a turnkey web application from a design brief

Learning Methodology

Courses will be delivered through a mixture of face to face and online learning

Assessment Methods

• Written Examination (in person)
• Project Grading (in person)

Course Duration

This course is delivered through a part time basis over 344 hours

The schedule is distributed into 9 hours a week:

• Wednesday (3 hrs: 7pm to 10pm) – Online
• Saturdays (6 hrs: 9am to 3pm) – Mix of Online and Face to Face sessions

Expected completion

9 months (part time)

Contact hours

100 hours 

Location

• Online class (Zoom) and face to face (Farrer Park)
• The typical lecturer/student ratio is 1 : 20 (for lectures)
• The typical lecturer/student ratio is 1 : 10 (for tutorials/labs)