For a better view on University College of the Cayman Islands, Update Your Browser.
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