Certificate in Computer Operations and Applications

The Certificate in Computer Operations and Applications is to produce graduates who will become proficient in carrying out basic data processing applications including word processing, spread sheet operations, presentation slides, graphic design and photo editing as well as mobile applications. This course introduces students to the fundamental applications of computer in private and public organisations. It is suitable for clerical staff, professionals and individuals that wish to be proficient in the current applications of computer for purposes that may include self-actualization, job prospect and/or career progression.

Admission Requirements

5 O’L Credit passes with at least a Pass in English Language. Basic computer skills (opening files, folders, and applications, copying and pasting); Access to personal or home computer for practice. Experienced/matured candidates that demonstrate sufficient background knowledge by passing entrance examination and interview may also be considered for admission.

Duration

Two Semesters of Three Months per Semester.

1^ST Semester (3 Months)

2^nd Semester (3 Months)

Course Contents

CCA 101: Computer Appreciation

Characteristics of Computers, Input, Output, Storage units, CPU, Computer System;  Computer Organization; Some fundamental DOS commands; Memory- Secondary Storage Devices; Multimedia Application.

CCA 103: GUI Operating System

Operating system, basics of Windows, The User Interface: Using Mouse and Moving Icons on the screen, The My Computer Icon, The Recycle Bin, Status Bar, Start and Menu. Running an Application, Windows Explorer Viewing of File. Creating and Renaming of files and folders,

CCA 105: Communication and Computer Network

Data communication; communication protocols; Internet and Intranet; satellite communication; Basic of Computer networks; LAN, WAN; Applications of Internet; connecting to internet; Domain name; IP Address; Basics of electronic mail; Getting an email account; Sending and receiving emails.

CCA 107: Microsoft Office Application

Introduction to Office applications: Word, Excel, PowerPoint, Outlook, OneDrive, OneNote, SharePoint, Microsoft Teams. Access, Bookings, Exchange, MilelQ, MyAnalytics, Planner, PowerApps, Power BI, Project, Publisher, Skype for Business, Server, StaffHub, Stream, Sway, Visio, Whiteboard, Yammer.

CCA 109: Mobile Applications

Introduction to mobile phones, Generations of mobile phones, FHSS networks, GSM, Spread spectrum, CDMA, TDMA & Basic electronics components; Educational Mobile Apps; Mobile Operating Systems and App Development;  Mobile Wireless Communications; Mobile Financial Services; Mobile Commerce.

CCA 111: Microsoft Power Point Application

Modify slide masters, handout masters, and note masters; Change the slide master theme or background; Modify the handout master; Modify the notes master; Change presentation options and views; Configure media playback  options; Animate slide content; Animate text and graphic element.

CCA 102: Microsoft Excel Application

Manage and format data: Fill cells based on existing data. Manage workbook options and settings, reference data in other workbooks; enable macros in a workbook; Prepare workbooks for collaboration. Apply advanced conditional formatting and filtering:

CCA 104: Microsoft Outlook Application

Navigate Outlook on the web interface; See notifications; Customize the interface and Contextual commands .Organize your inbox: Easily see contacts email, or categories that are important. Manage your inbox; Sort and Filter; Flag for Follow up; Work with your email; Reply to mail; Preview attachments;

CCA 106: Multimedia Operations

Photoshop: Photoshop Interface, Raster graphics & Vector graphics, Image formats, Operations on image; Manipulation of Image; Transformation & Retouching.  The pen tool. Adobe Premiere: Basics of Adobe Premiere, Creating a new project, video formats, aspect ratio, the Interface, Project window, Monitor, Timeline.

CCA 108: Visual Basic for Application

Visual BASIC environment; Steps in Developing Application Project; Integrated Development Environment (IDE); Menu Bar.  Form Designer; Properties Window; Project Explorer Window; Form Layout Window; Code Editor Window; Environment options (SDI, MDI); Visual Basic Controls

CCA 199: Long Essay

Students are to write a minimum of 5,000 words on contemporary application of computers for personal, corporate or national interest. Example includes entrepreneurial topic like ‘running a computer business centre’.

Scoring and Grading System

The marks obtained shall be converted into letter grades and transformed to grade points as follows:-

Thus, to obtain a pass grade in a course, a student must score at least 50%