INTERNATIONAL TRAINING COLLEGE - LINGUA

Towards Educational Excellence

NCHE Reg. No: R0014

NQA Accreditation No: 000244

 

DEPARTMENT OF INFORMATION TECHNOLOGY

 

Computer Studies Course Outline

 

Course Title

Computer Studies

Description

This course is designed to equip candidates with essential computer literacy skills. By the end of the course, participants will be able to perform basic computer operations, demonstrate a fundamental understanding of computer hardware, and effectively use key software applications. These include word processing programs, spreadsheet tools, presentation software, internet browsers, and email applications. The course is structured into five comprehensive units: Introduction to Computers, Word Processing, PowerPoint, Spreadsheets, and Internet/Email, ensuring a well-rounded foundation in digital skills.

Prerequisites

None

Standard Type (Core, fundamental, elective)

Fundamental

Learning Outcomes/Specific Outcomes

Upon successful completion of this course, candidates will be able to confidently operate a computer and utilize essential software tools for various tasks. Specifically, they will be able to:

1.    Perform basic computer operations and navigate the operating system efficiently.

2.    Use word processing software to create, edit, format, and manage documents.

3.    Utilize spreadsheet applications to organize data, perform calculations, and generate charts.

4.    Design and deliver effective presentations using PowerPoint or similar presentation tools.

5.    Navigate the internet for research and communication purposes, and effectively manage email communications.

 

Course Content

1. Introduction: Computer Operations
1.1 Computer components
1.2 Hardware and Software
1.3 Desktop navigation

2. Word Processing
2.1 Introduction to Word Processing
2.2 Creating and Editing Documents
2.3 Formatting Text and Paragraphs
2.4 Inserting Tables, Images, and Charts
2.5 Using Styles and Templates
2.6 Mail Merge and Label Creation
2.7 Document Review and Collaboration
2.8 Printing and Exporting Documents

 

3. Spreadsheets
3.1 Introduction to Spreadsheet Software
3.2 Entering and Formatting Data
3.3 Using Formulas and Functions
3.4 Creating Charts and Graphs
3.5 Sorting and Filtering Data
3.6 Using Pivot Tables
3.7 Spreadsheet Formatting and Layout
3.8 Printing and Sharing Spreadsheets

 

4. Presentation Graphics
4.1 Introduction to Presentation Software
4.2 Creating and Structuring Slides
4.3 Formatting Text and Objects
4.4 Inserting Multimedia Elements
4.5 Using Transitions and Animations
4.6 Delivering and Printing Presentations
4.7 Presentation Tips and Best Practices

 

5. Internet and Email
5.1 Introduction to Internet Basics
5.2 Using Web Browsers
5.3 Searching for Information Effectively
5.4 Using Email and Online Communication Tools
5.5 Understanding Online Safety and Security
5.6 Accessing Cloud Storage and Online Applications
5.7 Responsible Digital Citizenship

 

Methods of Facilitating Learning

The course can be inter alia facilitated through the following learning activities:

·         Lectures

·         Assigned readings

·         Discussions (all learners are expected to participate)

·         Individual or group class presentations

·         Assignments and tests

·         Case Studies

·         Simulations

·         Power point presentation

  • Videos and audio recordings
  • Peer to peer teaching

Assessment Strategies

The course will be assessed using a combination of Continuous Assessment and an examination at the end of the training. Continuous Assessment is made up of the following:

 

Continuous Assessment: 40%

 

·         Tests

·         Assignments/Projects

·         Exercises

·         Quizzes

·         Worksheets

·         Practical exercises

 

Final Examinations: 60%

Time allocation per question paper: between 2 and 3 hours

 

·         The final examination will test the knowledge, understanding and skills outcomes in any given year on the course content covered.

·         The intention of the examination in its formulation is to avoid predictability and encourage students to prepare for all syllabus outcomes.

·         The intention of the examinations is to assess the following objectives:

Ø  Knowledge and Understanding

Ø  Application

Ø  Analysis

Ø  Evaluation

·         The examinations may include a range and balance of question types, such as multiple-choice questions, short-answer free response questions, open-ended questions and extended responses including essays. These will be determined by the Department in which the subject resides and with the approval of the Examinations Committee.

·         The demands of the examination in terms of the number and length of student responses required, the amount of reading time provided and the complexity of the questions will be appropriate for the time allocated for the examination.

Prescribed Textbooks 

·         Lambert, J. (2022). Microsoft Word Step by Step (Office 2021 and Microsoft 365). Microsoft Press.

 

·         Frye, C. (2022). Microsoft Excel Step by Step (Office 2021 and Microsoft 365). Microsoft Press.

 

·         Lambert, J. (2022). Microsoft PowerPoint Step by Step (Office 2021 and Microsoft 365). Microsoft Press.

 

·         Alexander, M., & Kusleika, R. (2022). Excel 2021 Bible. Wiley.

 

·         Rusen, C. (2022). IC3 Internet and Computing Core Certification Study Guide: Global Standard 5. Wiley.

 

·         Wempen, F. (2022). Digital Literacy For Dummies. Wiley.