Certificate Course in Business Computing (CCBC)

CEIT is now accepting Registrations into the Certificate Course in Business Computing.

Semester Dates:Starts 9th August 2021
Ends 3rd December 2021
Tutorial Times:4:30pm – 6:30pm every Thursday
Number of learning hours:320 hours over 13 weeks plus 4 weeks to complete major assignment and final examination
Course MaterialsTextbooks will be provided, learning materials available online via MOODLE
Eligibility QualificationThis course is suitable anyone with intermediate level computer and programming skill. This course is suitable for IT Professionals
Exit Profile:Database administrator, VB.Net developer, IT Support
Facilitator:Rex Valoa
Course Fee:$420.00 NZD

Detailed Overview and Learning Objectives

The objective of this course is to provide the student with skills, knowledge and competency in basic programming and advanced Microsoft Office. This qualification has a strong focus on information technology, software development life cycle, database technology, and communication skills. Students will develop understanding and skills in C programming, Object Oriented programming, Entity Relationship models, SQL data manipulation, and database technology. The end of the course students will gain confidence in using MS Access to design, create and manage simple databases, and using simple queries to search for data records.

Students who will complete this course will be able to work in ICT industries as a software developer, IT Support, VB.NET developer, Database Administrator and Support. This qualification can complement professionals working in various other industries such as finance, marketing, management, administration, law enforcement. Prospective students must have a sound knowledge of computer basics, and fundamentals of programming language.

This qualification has been designed in consultation with industry and domain expert keeping in mind the need for a more information and digitally literate workforce. In addition to these learning objectives, students will also have in-lab practice in basic computer security practices pertaining to antivirus/malware scanning of storage devices, phishing, identifying secure websites online, and more.

By the end of the course (320 learning hours) students will have developed an understanding, and competency in the following modules.

Sl. No.Module NameHours
1Fundamentals of Computers & OS Concepts        20
2Advanced MS Office 60
3C Programming 30
4Software Development Life Cycle20
5Object Oriented Programming with C++ and DS40
6Database Management using Ms Access30
7VB.Net as Front End 60
8Major Project 60
Total320

Detailed Course Outline

The CCBC Curriculum is competency and skill based which ensures students are able to demonstrate their skill in practice in order to effectively achieve the course learning objectives. Assessments are a combination of theory and practical, including classroom discussions, presentations, projects, and written examinations. 

This qualification is accredited through the Centre for Development in Advanced Computing (CDAC) under the National Skills Qualification Framework of the National Skills Development Agency, Government of India, and in partnership with India European Union Skills Development Project.

Fundamentals of Computer & OS Concepts (20 Hours)

  • Computer Fundamental:  Uses of Computer, Hardware, Accessories,
  • Types of computer
  • Hardware and Software
  • Operating System
  • Process Management
  • Threads
  • Process Scheduling
  • Memory Management
  • Virtual Memory
  • Input Output Management
  • File Management
  • Deadlocks
  • Inter–process Communication 
  • Classification of Computers 
  • Introduction to windows operating systems
  • The desktop, The window, application window, document window, Dialog Window
  • The Icons, Explore Your Computer, The Start Button and Taskbar.
  • My Computer, Windows Explorer, Starting and Closing Programs,
  • Installing Operating System
  • Performing a New Installation for Windows
  • Installing a Software other than OS
  • Setting up a printer
  • Uninstalling software

Advanced MS Office with Access (60 Hours)

  • MS Office 2010
  • Installing MS Office 2010
  • MS Word 2010
  • MS PowerPoint 2010
  • MS Excel 2010
  • MS Access 2010

C Programming (30 Hours)

  • Introduction to Programming Language
  • C Fundamentals
  • Operators and Expressions
  • Data Input and Output
  • Control statement
  • Functions
  • Arrays
  • Pointers
  • Structures and Unions 

Software Development Life Cycle (20 Hours)

  • Software: A Process
  • Various Phases in s/w Development
  • Software life cycle agile model
  • Introduction to Coding Standards
  • Testing Strategies and Tactics
  • Writing Test Cases
  • Configuration management
  • Software Quality Assurance 

OOP with C++ with DS (40 Hours)

  • OOP concepts
  • Programming constructs
  • Functions
  • Access Specifiers
  • Classes and Objects
  • Overloading
  • Inheritance
  • Polymorphism
  • Templates

Database Technologies (30 Hours)

  • Introduction to DBMS
  • Types and Components of DBMS
  • Advantages of DBMS
  • Database Design
  • Codd’s Rules
  • Normalization Techniques
  • Introduction to Oracle
  • SQL* Plus
  • DDL, DML and DCL
  • Tables, Indexes and Views
  • PL/SQL
  • Cursors
  • Stored Procedures
  • Triggers

VB.NET as Front–End (60 Hours)

  • Event driven programming
  • Form object
  • Data Types & Operators in VB
  • User Interface and control names
  • Procedures and functions
  • Modules and scopes
  • VB.Net Objects and Methods
  • Exception Handling
  • Classes
  • Inheritance, Polymorphism
  • Class Libraries
  • Interfaces & Abstract Classes
  • Delegates and Events
  • Intrinsic controls in VB .NET
  • Common controls in VB
  • User interface design (MDI & SDI Models)
  • Dates, Strings, Array, Collections
  • Structures
  • Working with Databases

Learning Resources and Student Support Services

Students will have full access to all CEIT and USP facilities throughout the semester. 

  • Course materials available online via MOODLE
  • CEIT library for textbooks and reference materials
  • Highly qualified and experienced trainers
  • Free academic counselling by appointment only
  • Computer lab is equipped with digital smartboard, computers and high-speed internet

Click here for a copy of the CCBC Qualification File

Certificate Course in Advanced Web Technology (CCAWT)

CEIT is now accepting Registrations into the Certificate Course in Advanced Web Technology. This course a ideal for anyone interested in Web design and development, or website administration. This qualification has a strong focus on information technology, web programming (Ajax, HTML, CSS, PHP, Javascript), Database concepts, and management development program. This course demands a command of wide-ranging specialized theoretical and practical skills, involving variable routine and non-routine contexts. Students should already have some basic knowledge and understanding of basic programming and website management.

Semester Dates:Starts 9th August 2021
Ends 12th November 2021
Tutorial Times:4:30pm – 6:30pm every Tuesdays
Number of learning hours:260 hours over 14 weeks
Course MaterialsTextbooks will be provided, learning materials available online via MOODLE
Eligibility QualificationThis course is suitable for IT Professionals and aspiring website developers
Exit Profile:Website developer, Web Administrator
Facilitator:Rex Valoa, MBA, MIS, Dip Advanced Computing
Course Fee:$420.00 NZD

Detailed Overview and Learning Objectives

The CCAWT Curriculum is competency and skill based which ensures students are able to demonstrate their skill in practice in order to effectively achieve the course learning objectives. Assessments are a combination of theory and practical, including classroom discussions, presentations, projects, and written examinations.  This qualification is accredited through the Centre for Development in Advanced Computing (CDAC) under the National Skills Qualification Framework of the National Skills Development Agency, Government of India, and in partnership with India European Union Skills Development

By the end of the course (260 learning hours) students will have developed an understanding, and competency in the following modules.

Sl. No.Module NameHours
1Computer & Programming Concepts        40
2Web Programming I (HTML, CSS, Ajax) 60
3Web Programming II (PHP, JavaScript) 80
4Internet Terminologies 20
5Database Concepts 20
6Project 40
Total260

Detailed Course Outline

Module 1 Computer & Programming Concepts (40 Hours)

  • Fundamentals of Computers
  • Uses of Computer, Hardware, Accessories,
  • Interfaces and their functions, Computer hardware connectivity
  • Primary and Secondary storage
  • Input-output devices
  • Software, types of software, Operating Systems
  • Software used in Academic departments and other area.
  • Computer language, Different types of Programming Languages
  • Operating System 
  • Programming concepts
  • Algorithm
  • Flow charts
  • Introduction to loops, functions

Module 2 Web Programming – I (HTML, CSS, Ajax)  (60 Hours)

  • HTML 5.0 programming
  • Overview of Internet and Web Pages
  • Introduction to HTML Tags
  • Introduction to Web Browser / Composer
  • Introduction to HTML Editor
  • CSS Introduction
  • CSS Syntax
  • CSS Id & Class
  • CSS How To
  • CSS Styling
  • CSS Box Model
  • CSS Summary
  • Introduction to Ajax
  • Web services and Ajax
  • Ajax using HTML, CSS

Module 3 Database Concepts  (20 Hours)

  • Database Concepts
  • RDBMS Technologies
  • Codd’s Rules
  • Normalization Techniques
  • SQL and PL/SQL
  • Overview of OORD (Oracle)
  • Introduction SQL*Plus
  • DDL, DML and DCL
  • Tables, Indexes and Views

Module 4 Web Programming – II (PHP, Java scripts) (80 Hours)

  • Java Script Introduction
  • JS output
  • JS statement
  • JS Comments
  • JS Variable
  • JS data types
  • JS Switches, loops
  • JS Events
  • JS Built-in Functions
  • JS DOM
  • Introducing to jQuery
  • Bringing pages to life with jQuery
  • JQuery Events
  • Energizing pages with animations and effects
  • DOM with jQuery utility functions
  • Introduction of UI Scripting Framework
  • Introduction to PHP
  • Working with arrays
  • Functions
  • Forms
  • Handling date and Times
  • Making web forms
  • Working with cookies and Sessions
  • Storing information with databases
  • XML
  • Working with files
  • Command line PHP
  • Running Shell command
  • IMAP, POP3 and NNTP
  • Graphics, PDF
  • Sending and receiving mails

Module 5 Internet Terminologies (20 Hours)

  • Creating a windows web services
  • Web services and Ajax
  • Deployments of application on Internet
  • Installation of PHP application/Website in LAN
  • Maintenance of application
  • How to do maintenance work with affecting the other web pages

Module 6 Final Project

Click here for a copy of the CCAWT Qualification File

Certificate Course in Office Automation (CCOA)

CEIT is now accepting Registrations into the Certificate Course in Office Automation. This course a ideal for beginners and office workers looking to improve their confidence and productivity in the workplace.

Semester Dates:Starts 9th August 2021
Ends 12th November 2021
Tutorial Times:4:30pm – 6:30pm every Wednesday
Number of learning hours:144 hours over 10 weeks plus 4 weeks to complete major assignment and final examination
Course MaterialsTextbooks will be provided, learning materials available online via MOODLE
Eligibility QualificationThis course is suitable anyone with basic computer literacy and office workers. This course is not suitable for IT Professionals
Exit Profile:Data entry operator, Office Worker, IT Support
Facilitator:Mii Nimerota
Course Fee:$420.00 NZD

Detailed Overview and Learning Objectives

The objective of this course is to provide the student with skills, knowledge and competency in using Microsoft Office applications and tools for improved office productivity. Students will develop a better understanding of computer hardware and software fundamentals, including basic troubleshooting tips. Students will learn how to confidently navigate the Windows environment for file management, data storage, and software installation. Students will learn the very basics for Microsoft Word, Excel, Access and PowerPoint program, and develop an understanding of essential database concepts.

The end of the course students will gain confidence in using MS Access to design, create and manage simple databases, and using simple queries to search for data records.

In addition to these learning objectives, students will also have in-lab practice in basic computer security practices pertaining to antivirus/malware scanning of storage devices, phishing, identifying secure websites online, and more.

By the end of the course ( 144 learning hours) students will have developed an understanding, and competency in the following modules.

Sl. No.Module NameHours
1Fundamentals of Computer        14
2Operate Client Operating System – Windows Environment20
3Ms Office Tools60
4Database Concepts30
5Database Management using Ms Access20
Total144

Detailed Course Outline

Fundamentals Of Computers

  • Fundamentals of Computers,
  • Uses of Computer, Hardware,
  • Accessories, Interfaces and their functions,
  • Computer hardware connectivity
  • Primary and Secondary storage, Input-output devices,
  • Software, types of software,
  • Operating Systems, Software used in Academic departments and other area.

Operate Client Operating System ‐ Windows Environment

  • The Need of Operating System.
  • Functions of Operating System
  • Types of Operating System User Interface
  • Windows keys combinations Software installation

Ms Office Tools

  • Launch Word Processing Software
  • Work with the text formatting and editing features, save a document,
  • Add Bulleted and numbered lists,
  • Add clip art and auto shapes
  • Use page formatting (margins, size and orientation, header, footer, page numbers),
  • Use keyboard shortcuts
  • Launch Spread sheet Software and familiarize with the interface,
  • Save a workbook, Explore the Editing and Formatting cell features, Change width/height of rows and columns, Use basic formulae and functions and rename sheets in a workbook, Use Help feature and keyboard shortcuts
  • Getting Started with Presentation software,
  • Insert a New Slide,
  • Change the Title of a Slide,
  • Add an Image,
  • Add a Textbox, Set up a Master Slide,
  • Format the Master Slide,
  • Adding the animated images,
  • Resize an Image,
  • Slide Transitions,
  • Using help tools and features

Database Concepts

  • Introducing the Database Design
  • The Historical Roots of the Database: Files and File Systems
  • A File System Critique
  • Database Systems
  • Database Models

Database Management using Ms Access

  • Introduction to Access,
  • Create a Database,
  • Create a Table, Create a Table in Design View,
  • Create an Input Mask,
  • Add Data to Table,
  • Import Data from a CSV File,
  • Create a Relationship,
  • Create a Lookup Table
  • Create a Query, Create a Query with User Input,
  • How to use the Expression Builder,
  • Export Data to Excel (and XML),
  • Create a Form,
  • Add a Combo Box to a Form,
  • Create a Report,
  • Create a Macro,
  • Backup a Database

Learning Resources and Student Support Services

Students will have full access to all CEIT and USP facilities throughout the semester. 

  • Course materials available online via MOODLE
  • CEIT library for textbooks and reference materials
  • Highly qualified and experienced trainers
  • Free academic counselling by appointment only
  • Computer lab is equipped with digital smartboard, computers and high-speed internet

Certificate Course in Advanced Web Technology (CCAWT)

Overview

The course aims to prepare students and enable them to work on current web technology scenarios as well as prepare them to keep pace with the changing face of technology and the requirements of the growing IT industry. PHP is used by 82% of all websites using server-side programming language, such as Facebook, Wikipedia, Twitter, and others. Students will become familiar with basic programming concepts, HTML and CSS, Webservices and Ajax, Java Script and JS, and other web services. Students will be trained in Web designing, Database Technology and Management skills. They can start career as software Web Developer, Web Designer, and as IT Support staff.

Term Dates: Semester begins on the 30th September 2019
Ends on the 28th February 2020
Tutorial Times: 3pm – 5pm (TBC)
Number of 
learning hours:
320 hours classroom/lab learning
(4 Months, 4 hrs 5 days in a week)
Course Materials Textbooks will be provided
Eligibility Qualification Any Engineering / Science Graduate with mathematics u to level 10
Computing Fundamentals
Exit Profile: Website Designer, Website Developer, IT Support Staff
Facilitator: Centre Head of CEIT
Course Fee: NZD $420.00

Download Information Sheet

Detailed overview and learning objectives

By the end of the semester (320 learning hours) students will have developed an understanding, and competency in the following modules.

Computer and Programming Concepts (40 Hours)

  • Fundamentals of Computers
  • Uses of Computer, Hardware, Accessories
  • Interfaces and their functions, Computer hardware connectivity
  • Primary and secondary storage
  • Input output devices
  • Software, types of software, Operating Systems
  • Software used in Academic departments and other area
  • Computer language, Different types of Programming languages
  • Operating System
  • Programming Concepts
  • Algorithm
  • Flow charts
  • Introduction to loops, functions

Web Programming-I(HTML, CSS, Ajax) (60 Hours)

  • HTML 5.0 programming
  • Overview of Internet and Web pages
  • Introduction to HTML Tag
  • Introduction to Web Browser / Composer
  • Introduction to HTML Editor
  • CSS Introduction
  • CSS Syntax
  • CSS Id and Class
  • CSS How To
  • CSS Styling
  • CSS Box model
  • CSS Summary
  • Introduction to Ajax
  • Web services and Ajax
  • Ajax using HTML, CSS

Database Concepts

  • Database Concepts
  • RDBMS Technologies
  • Codd’s Rules
  • Normalization Techniques
  • SQL and PL/SQL
  • Overview of OORD(Oracle)
  • Introduction SQL*Plus
  • DDL, DML and DCL
  • Tables, Indexes and Views

Web Programming-II(PHP, Java scripts)

  • Java script introduction
  • JS output
  • JS statement
  • JS comments
  • JS variable
  • JS data types
  • JS switches, loops
  • Introduction to PHP
  • Working with arrays
  • Functions
  • Forms
  • Handling date and times
  • Working with Files
  • Working with database
  • PHP and AJAX

Internet Technologies(20 Hours)

  • Web services
  • Deployments of application on Internet
  • Maintenance of application

Management Development Program

  • Introduction to communication
  • Barriers of communication
  • Kind of communication
  • Confidence building non-verbal communication
  • Fluency and vocabulary
  • Synonyms, Antonyms, Grammar, Noun Pronoun, Verb, Adjective, Preposition, Conjunction
  • Words of Idioms and phrases
  • Sentence Construction
  • Fill up the blanks
  • Pronunciation
  • Conversation practice
  • Polite conversation, Greeting
  • Logical reasoning
  • General Aptitude
  • Writing: Covering letter, Resume, Email
  • Presentation Skill, Group discussion
  • Interview skills, Mock Interview

Final Project based on completion of the modules above.