For a better view on University College of the Cayman Islands, Update Your Browser.
Fall 2023 IT Academy Registration is Now Open!LEARN MORE
Fall Registration is Now Open!LEARN MORE
Fall 2023 Main Registration Week - August 21-25!LEARN MORE
Apply Now

Computer Applications Part 1 (First 7 weeks)

COMPUTER APPLICATIONS I

THEORY

Fundamentals of Computing

  • Definition and function of a computer
  • Types of Computers
  • Input andInput Devices
  • Output and Output devices
  • Storage and Storage devices
  • Definition of files, folders and drives
  • File and folder Creation and File Management
WORD PROCESSING UsingMicrosoft Word

Microsoft WordBasics

  • Useful Word Processing terminologies
  • Parts of the Word Window
  • Opening, saving and closing a document
  • Formatting (font and paragraph) and Editing a document
  • Headers and Footers
  • Page numbering
  • Paragraph and Page breaks
  • Tables (creation, inserting and deleting rows and columns, sorting, merging cells)
  • Page layout(Setting margins, page size and orientation)
  • Tabbing (Setting tab stops)
  • Columns (Breaking a paragraph into the desired amount of columns and lines basics using Microsoft Microsoft between)
  • Bullets and numbering
SPREADSHEET usingMicrosoft Excel

Microsoft Excelbasics

  • Useful Spreadsheet terminologies
  • Parts of the Microsoft ExcelWindow
  • Navigating the Spreadsheet
  • Populating a Spreadsheet
  • Simple Spreadsheet formulas (Addition, Subtraction, Multiplication and Division)
  • Formatting Cells
  • Widening Columns and Rows
  • Merging cells
  • Inserting and deleting rows and columns
  • Functions (Sum, IN-DEPTHMax, Min, Average)


 

 

THEORY

IN-DEPTH CONCEPTS

  • Categories of storage devices
  • Categories of input devices
  • Categories of output devices
  • Fundamentals of Networking and the Internet
  • Data storageAdvanced representation basics
  • Applications and Implications of IT in everyday life
WORD PROCESSING using Microsoft Word

Advance WordProcessing Concepts:

  • Superscript and subscript
  • Footnotes and Endnotes
  • Find and Replace
  • Format painter
  • Embedding shapes, Smart art and images in documents
  • Inserting Textboxes and WordArt
  • Tables (Inserting Formulas, text direction, Split cells and table, Table Styles)
  • Managing Columns (Inserting column and continuous breaks, Increasing decreasing column width, left and right columns)
  • Tab (Tab alignment, leaders)
  • Mail Merge
  • Adding and deleting  comments
SPREADSHEET using Microsoft Excel

Advance Spreadsheet concepts

  • Text Direction
  • Alignment (Top, middle,bottom)
  • Headers and Footers
  • Freeze and unfreeze Columns and Rows
  • Absolute and relative addressing
  • Creating graphs and charts
  • Simple and custom sorting
  • Simple and advanced Filtering
  • If statements
DATABASE MANAGEMENT using Microsoft and input Access

Basic Database Management concepts

  • Database Management terminologies
  • Designing a table (Datasheet view or Design view)
  • Datatypes and Field sizes
  • Populating a Table
  • Simple queries


 

 

 

This site uses cookies: Find out more
Okay, Thanks