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