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.

Term Dates:Term Starts 4th January 2021 and Ends 19th March 2021
Tutorial Times:TBC after registrations close on the 18 December 2020
Number of 
learning hours:
144 hours over 10 weeks
Students will attend two classes per week, each class will be 2-3 hours long.
Course MaterialsTextbooks will be provided, learning materials available online via MOODLE
Eligibility QualificationCandidate should have basic knowledge of computers.
Exit Profile:Data entry operator, office administrator, any office worker
Facilitator:Centre Head of CEIT, Mr. Jaibheem Gaikwad
Course Fee:NZD $420.00 
Course Fees will be paid under the Cook Islands Government “Free Fee Program” Economic Recovery Plan 2020

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

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
  • 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
  • CEIT will have an experienced Centre Head and one Trainer from CDAC deputed for two years for course delivery & center coordination
  • Free academic counselling by appointment only
  • Computer lab is equipped with digital smartboard, computers and high-speed internet

Certificate Course in Business Computing (CCBC)

Overview

The course aims to groom the students to enable them to work on current IT scenarios as well as prepare them to keep pace with the changing face of technology and the requirements of the growing IT industry.
These candidates will be trained in programming languages like C, C++, Database Technology, VB.NET and Management skills. They can start career as IT Support and VB.NET developer.

Term Dates: To Be Confirmed
Tutorial Times: 3pm – 5pm
Number of 
learning hours:
320 hours
Course Materials Textbooks will be provided, Classroom teaching.
Eligibility Qualification Any Graduate/Completed Diploma
Computing Fundamentals
Exit Profile: Software Analyst
Facilitator: Centre Head of CEIT
Course Fee: NZD $260.00 (TBC)

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.

Fundamentals of Computer and 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 Software other than OS
  • Setting up a printer
  • Uninstalling software

Advanced MS Office with Access (30 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 (16 Hours)

  • Software: A Process
  • Various Phases in software 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

  • 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 (54 Hours)

  • Event driven programming
  • Form object
  • Data Types and 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 and Abstract Classes
  • Delegates and Events
  • Intrinsic controls in VB.Net
  • Common controls in VB
  • User Interface Design(MDI and SDI Models)
  • Dates, Strings, Array, Collections
  • Structures
  • Working with Databases

Management Development Program

  • Introduction to communication
  • Barriers to communication
  • Kind of Communication
  • Confidence building Non-verbal Communication
  • Fluency and vocabulary
  • Synonyms, Antonyms, Grammar, Noun Pronoun, Verb, Adjective, Proposition, Conjuction, 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.

Certificate Course in Network Security (CCNS)

Overview

The Certificate Course in Network Security introduces students to essential Network fundamentals by developing an understanding of key network infrastructure, hardware devices and technologies. Students will learn about the various network types (LANs, WANs, MANs, etc), wired and wireless technology, TCP/IP overview, and internet/intranet architecture. In this information age when citizens are more connected via the internet, the protection, privacy, and security of our data is a critical concern. This course introduces students to Network Defense and Countermeasures and IT infrastructure management, increasing our understanding and developing the necessary skills to protect our organizations data from malicious attacks. Students will demonstrate learning through a practical skill based Project at the end of the course.

Term Dates:Classes begin Monday 30th September 2019
Semester Ends on 28th Feb 2020
Tutorial Times:3pm – 5pm (TBC after Registration period)
Number of
learning hours:
320 hours over 4 months (4 hours a day for 5 days a week)
Course MaterialTextbooks will be provided, classroom teaching
Eligibility Qualification Any Engineering /Science graduate with mathematics up to 10+2 level
Candidate should have basic knowledge of computers, operating systems, networking fundamentals
Exit Profile: Cyber Security Specialist, Networking Administrator,
Operations Engineer, Site Reliability Engineer, Security Engineer,
IT Infrastructure Engineer, Information Security Assurance.
Facilitator:Centre Head of CEIT
Course Fee: NZD $420.00

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.

Network Fundamentals: Introduction to computer Networking

  • Categories of Networking according to size (LAN,WAN,DAN,MAN)
  • Types of connections and Network classifications (Wired, Wireless )
  • Network Hardware Devices (Hub, Switch, Modem, Router, Bridge , Repeaters , firewall etc ) Overview
  • TCP/IP overview
  • IP addressing, Sub-netting, super-netting
  • IPv6 Planning and Implementing
  • Architecture of Internet and intranet
  • Port Security
  • Spanning tree Protocol 
  • Troubleshooting

Network Defense and Countermeasure

  • Security Fundamentals 
  • Firewalls
  • Define the Types of Firewalls
  • Application Layer Firewalls
  • Packet Filtering Firewalls
  • Hybrid
  • Intrusion Detection and Prevention
  • Intrusion definition, risks, setting up and managing IPS
  • Security policy
  • Monitoring traffic and open ports
  • Detecting modified files
  • Investigating and verifying detected intrusions
  • Recovering from, reporting and documenting intrusions
  • Understand Intrusion Prevention
  • Issues with Intrusion Prevention
  • IP Signature and Analysis 
  • Risk Analysis
  • Virtual Private Networks
  • Define Virtual Private Networks
  • Deploy User VPNs
  • Benefits of user VPNs
  • Managing User VPNs
  • Issues with User VPNs
  • Deploy Site VPNs
  • Benefits of Site VPNs
  • Managing Site VPNs
  • Issues with Site VPNs

IT Infrastructure Management

  • Introduction to ITIL
  • Service Strategy
  • Service Design
  • Service Transition
  • Service Operation
  • Continual Service Improvement
  • Data Centre Management
  • Introduction to DCM
  • Data Centre design
  • Best Practices in IT
  • Server Security
  • Storage area network

Management Development Program 

  • Introduction to communication
  • Barriers to communication
  • Kind of communication
  • Confidence building Non-verbal Communication
  • Fluency and vocabulary
  • Synonyms, Antonyms, Grammar, Noun Pronoun, Verb, Adjective, Preposition, Conjunction,
  • Words of Idioms & 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.