1. Information & Communication Technology |
|
Course Type | Full Time |
Prerequisite | NVQ Level 4 Certificate in ICT or SLGTI Bridging Programme in Information & Communication Technology |
Medium | English Language |
Course Duration | 1 year, plus 6 months On-the-Job-Training (SIT) |
Course Certificate | National Vocational Qualification Certificate – NVQ Level 5 (National Diploma) |
Course Objective (Purpose Of this Qualification) To gain theoretical knowledge, skills and competencies in Information & Communication Technology, e.g. to operate and maintain IT-Infrastructures, to code and to test software programs (Software program development), to program in C#, HTML5, CSS3, Bootstrap and PHP to perform database maintenance and trouble-shooting, and to gain deeper knowledge in computer networking. |
Module Structure
The student will be able to:
- Explain the basic concepts of DBMS
- Explain database architecture & modeling
- Design Entity Relationship models
- Use normalization process
- Design a database
- Manipulate data using SQL
- Manipulate data using relational algebra
- Implement a database using suitable DBMS
- Perform database maintenance and troubleshooting
The student will be able to:
- Design database queries
- Design a database for given requirement
- Handle performance issues
- Create user accounts security levels
- Explain data recovery and backup procedure
- Design hardware and operating software requirements for a given database
- Install a database in a given environment
- Configure database and install application packages
The student will be able to:
- Explain Graphics applications
- Describe the hardware dependency and requirements for graphic software
- How different platforms(Apple, Windows ) effects graphic quality
- Differentiate Raster & vector graphics
- Select suitable layout
- Apply correct Drawing tools
- Select suitable color types (RGB and CMYK)
- Design the suitable art work
- Edit an image using correct editing tools
- Use the correct file formats
- Select the suitable printing material
- Print the design using suitable method
- Able to manage graphic project
- Able to prepare cost estimate
- Observe ethics & norms in graphic industry
The student will be able to:
- Explain data structures and algorithms
- Identify Object Oriented Concepts
- Identify difference between structured programming and OOP
- Explain GUI principles and design
- Explain Error handling techniques
- Explain Database connectivity techniques
The student will be able to:
- Identify Test needs
- Identify Basic test process
- Identify Software Test life cycle
- Perform Test design technique
- Perform Test design and administration
- Perform Testing using test supportive tools
The student will be able to:
- Definition of a system
- Introduction to System Analysis and Design
- Requirement gathering and fact finding techniques
- Data Modeling Techniques
- Object oriented system design
- System Requirement Specification
The student will be able to:
- Create static and dynamic web pages
- Develop web pages using scripting languages
- Insert multimedia contents to web sites/pages
- Develop form based interactive web pages
- Manipulating records using database connectivity
- Role of a web server
- Install, configure and maintain web server
- Publishing a web site
The student will be able to:
- Functionality of LAN
- Analyze hardware and software requirements for Local Area Networks
- Develop and design Local Area Network Structure
- Prepare hardware and software specifications
- Create a final proposal for a LAN
The student will be able to:
- Explain the importance of ICT tools in promoting the productivity of the organization
- Describes the purpose of establishing ICT tools and strategies in enhancing the performance at workplace
- Apply Information skills to enhance the productivity of the organization
The student will be able to:
- Identify the essential components of an efficient communication system
- Identify and overcome barriers to effective communication
- Use all channels of communication equally well
- Use common computer applications to collect, analyze and maintain essential data and information required to perform and enhance day to day activities of the organisation
- Contributes to the overall growth and productivity development of the organization
The student will be able to:
- Prepare a work schedule for a given work situation
- Determine work priorities as per predetermined criteria such as goals, targets and organizational requirements
- Develop a plan (process) to complete work to be done in a given situation
- Assess competencies of individual workers before assigning work