Course Syllabus

COMPUTER BASICS

• Credit Hours: 3
• Location of Classroom: School Computer lab
• Time Slot: 45 Hours

Teacher: Mr. UWIHANGANYE Augustin

ICT Manager @ Rwamagana School of Nursing and Midwifery (RSNM)

E-mail:augu83@yahoo.fr ; augu83@gmail.com

Phone No.: +250785284477

1. Overall objectives of the course

At the end of the course the students will be able to:

1. Define the basic concepts in link with computer tools
2. Describe the various components of the computer and their utility
3. Specify principal computer programs
4. Describe the functionalities of the MS Office programs (MS Word, MS Excel)
5. Use MS Word 2007, MS Excel 2007 in their different class activities
6. Use Internet to search information and to communicate

2. Competency Areas

• Knowing basics of a Computer (Definition of terms, Parts of a computer, different applications used)
• Treat text using MS Word 2007
• Enter, Computer and Analyze Data using MS Excel 2007
• Make presentations using MS PowerPoint 2007
• Search information and communicate with others using Internet

3. Student Learning Outcomes

At the end of the course, students will be able to:

• Use the basic application programs (MS Word, MS Excel and MS PowerPoint).
  
• Save the file on portable and non-portable storage devices.
• Create an e-mail address account and exchange e-mails.
• Use search engines.
• Use Moodle as a Content Management System.

4. Topics, Duration and Objectives

Topic I: Computer Basics

Duration: 5 hours

General concepts

• Hardware, Software and Information Technology
• Understand the terms hardware, software, Information Technology
• Type of Computer
• Understand and differentiate different types of computer
• Main parts of a personal computer
• Understanding the main parts of a personal computer and peripheral devices
• Computer performance
• Understanding the factors which impact on a computer’s performance

Hardware

• Central Processing unit
• Understanding the functions of the CPU
• Memory
• Understanding different types of computer memory
• Understanding how computer memory is measured
• Input devices
• Understanding the main devices for input data into a computer
• Output devices
• Understanding common output devices
• Input /output devices
• Understanding that some devices are both input/output devices
• Storage devices
• Comparing the main types of memory storage devices in terms of speed, cost and capacity

Software

• Type of software
• Differentiate operating systems and applications software
• Operating system software
• Understanding the main functions of an operating system
• Graphical user interface (GUI)
• Understanding the term GUI

 

Topic II:  Windows 7 Environment

Duration:   5 hours

Concepts and definitions of file and folder

• The computer environment
• Getting started
• The desktop
• Working with desktop
• Working with windows
• Managing files and folders
• Definition of file and folder
• Working with folders/directories
• Saving files
• Duplication and moving files
• Deleting and restoring files/folders
• Searching
• Compressing files

• Information and settings
  • System information
  • Changing the desktop theme
  • Changing the date and time
  • Changing the keyboard language
  • Changing the volume settings

 

Topic III:  Microsoft Office Word 2007

Duration: 15 hours

Concept and definition of Word Processing

• Getting started
• Steps of starting Word processing
• Adjusting settings
• Main operation
• Insert data
• Selecting data
• Editing data
• Duplicating, moving and deleting text
• Search and replace
• Formatting
• Formatting text
• Formatting paragraphs
• Formatting documents
• Objects
• Tables
• Pictures, images and charts
• Table of content
• Preparing outputs
• Proofreading and preparation
• Printing

Topic IV: Microsoft Office Excel 2007

Duration: 5 hours

Concepts and definition of spreadsheets

• Using Excel
• About MS Excel
• Settings
• Working with cells
• Moving within a spreadsheet
• Inserting data
• Selecting cells
• Rows and columns
• Editing data
• Manipulating data
• Copying and moving
• Working with formulas and functions
• Creating a basic formula
• Working with functions
• Cell referencing
• Working with the logical IF function
• Special symbols and characters
• Error message
• Formatting
• Basic formatting
• Formatting numbers
• Managing spreadsheet data
• Sorting data
• Using find and replace
• Freezing row and column title
• Relative and absolute referencing
• Multiple spreadsheets and worksheets
• Handling worksheets
• Chart and graphs
• Using chart and graphs
• Preparing output
• Worksheet set-up
• Print settings/options

 

Topic V: Microsoft Office PowerPoint 2007

Duration: 5 hours

Concept and definition of Ms Power Point

• Getting started
  • How to start MS PP
  • Adjusting settings
  • Developing a presentation
    • Presentation views
    • Working with slides
    • Using design template
    • Manipulating tools
    • Text and images
      • Inputting and formatting text
      • Working with pictures and images
    • Charts, graphs and drawn objects
      • Using charts and graphs
      • Working with organization charts
      • Drawn object
    • Slide shows
      • Animation
      • Transition
      • Delivering a presentation
    • Preparing the outputs
      • Preparation
    • Master slides
      • Master slides
      • Adding text and numbering to the footer

Topic VI: Introduction to Internet

Duration:  10 hours

Concepts and definition of Internet and E-mail

• Information
• Internet concepts and terms
• Security consideration
• Steps with Web Browser
• Adjusting settings
• Web Navigation
• Working with the Web
• How to explore the Internet

 

Networks Information

• LAN and WAN
• Understanding the terms, Local Area Network, Wide Area Network and client/server
• Understanding some of advantages with group working
• Intranet and Extranet
• Understanding what the internet is and know some of its main uses
• Understanding what the World Wide Web is and distinguish its from the Internet
• Understanding what is Hypertext transfer protocol (http)
• The telephone network in computing
• Understanding the use of the telephone network in computing
• Understanding the terms analogue, digital, and modem and data transfer

• Communication
• E-Mail
• Security consideration
• Steps with E-Mail
• Adjusting settings
• Messaging
• Mail Management