NCS Learning and Training Institute
OFFICE OF THE ACADEMIC AFFAIRS
Head Office
FACULTY SESSION PLAN
Subject : Basic Computer Software
Hours : 3 hours
Days : 5 Days Session
Learning Outcomes:
This course is designed to equip the student with adequate knowledge and understanding as to what computers are uses and limitations. The
computers role in the society. An overview is also provided to basic computer elements and how each element functions and coordinates with other
elements in conducting data processing operations. An introduction to the Windows Operating System and Microsoft Office Applications are
incorporated to the arm of the student
A. INTRODUCTION
The key points of the lessons are:
To understand what are the function of computers
To understand data processing fundamentals
To develop skills in using Microsoft Windows Operating System
To create files using the MS Office ( MS WORD & MS EXCEL)
B. LEARNING ACTIVITIES
LO 1: Computers Fundamental
Learning Content Presentation Practice/Assessment Feedback Resources Time
Computer Definition
Desktop Computer • Understanding
Parts and Its
• Examination
Functions • Lectur • Appreciation
• Computer
e/ Discussion D:\Modules\Basic
Laboratory
Hardware and • Logical thinking Computer 3 hours
• Hands-On
Software • Demonstration [Link]
Exercises,
• Analytical
Shortcut Keyboard thinking
Keys and Windows
XP Tour
LO 2: Introduction to Microsoft Word 2007
Learning Content Presentation Practice/Assessment Feedback Resources Time
• Examination • Understanding D:\Backup\MODULES 3hours
• Lect • Computer - BASIC COMPUTER
Getting Started ure/ Laboratory • Appreciation SOFTWARE\msword
Discussion • Hands-On [Link]
• Microsoft Office Exercises, • Logical thinking
Button • Demonstration
• The Ribbon • Analytical
(Formerly the thinking
Toolbars)
• Quick Access
Toolbar
Working With Documents
• Creating a New
Document
• Open an Existing
Document
• Saving a
Document
• Save As or
Renaming
Documents
• Working on
Multiple
Documents
• Document Views
• Close a Document
Customize the Word
Environment
• Popular
• Display
• Proofing
• Save
• Advanced
• Customize
Editing a Document
• Typing and
inserting Text
• Selecting Text
• Inserting
Additional Text
• Rearranging
Blocks of Text
• Deleting Blocks of
Text
• Search and
Replace Text
• Undo Changes
Formatting Text
• Styles
• Changing Font
and Size
• Font Styles and
Effects
• Change Text Color
• Highlight Text
• Copy Formatting
• Clear Formatting
Formatting
Paragraphs
• Change
Paragraph
Alignment
• Indent Paragraphs
• Add Borders and
Shading
• Apply Styles
• Create Links
• Change Spacing
Between
Paragraphs and
Lines
Styles
• Apply a style
• Create New Styles
o New Style
o New Quick
Style
• Style Inspector
Adding Tables
• Create a Table
• Enter data in a
Table
• Modify the Table
Structure and
Format a Table
LO 3: MS Word 2007 Con’t
Learning Content Presentation Practice Feedback Resources Time
Graphics • Understanding 3 hrs
• Lectur ..\Modules\msexcel
• Symbols and e/ Discussion • Appreciation [Link]
Special
Characters • Demonstration • Logical thinking
• Equations
• Illustrations, • Analytical
Pictures, and thinking
SmartArt
• Watermarks
Proofing a Document
• Spelling and
Grammar
• Thesaurus
• Customize
AutoCorrect
• Create a New
Default
Dictionary
• Check Word
Count
Page Formatting
• Modify Page
Margins and
Orientation
• Apply a Page
Border and Color
• Insert Common
Header and
Footer
Information
• Create a Page
Break
• Insert a Cover
Page
• Insert a Blank
Page
Macros
• Recording a
Macro
• Running a Macro
Table of Contents
• Mark TOC
Entries
• Create a Table
of Contents
• Update Table of
Contents
• Delete Table of
Contents
Creating Web Pages
• Entering Text
• Hyperlinks
• Saving Web
Pages
Lists
• Bulleted and
Numbered Lists
• Nested Lists
• Formatting Lists
References and Citations
• Style
• Citations
• Placeholders
• Manage Sources
• Bibliography
• Insert Footnote
Track Changes
• Begin Track
Changes
• Document Views
•
• Accept or Reject
Changes
• Comments
LO4: Introduction to MS Excel
Learning Content Presentation Practice Feedback Resources Time
Getting Started • Examination • Understanding ..\Modules\msexcel 3 hrs
• Lectur • Computer [Link]
• Spreadsheets e/ Discussion Laboratory • Appreciation
• Microsoft Office • Hands-On
Button • Demonstration Exercises • Logical thinking
• Ribbon
• Quick Access • Analytical
Toolbar thinking
• Mini Toolbar
Customize Excel
• Popular
• Formulas
• Proofing
• Save
• Advanced
• Customize
Working with a
Workbook
• Create a
Workbook
• Save a
Workbook
• Open a
Workbook
• Entering Data
Manipulating Data
• Select Data
• Copy and Paste
• Cut and Paste
• Undo and Redo
• Auto Fill
Modifying a Worksheet
• Insert Cells,
Rows and
Columns
• Delete Cells,
Rows and
Columns
• Find and
Replace
• Go To Command
• Spell Check
Performing Calculations
• Excel Formulas
• Calculate with
Functions
• Function Library
• Relative,
Absolute, &
Mixed Functions
• Linking
Worksheets
LO5: MS EXCEL 2007 Con’t
Learning Content Presentation Practice Feedback Resources Time
Macros • Examination • Understanding 3hrs
• Lectur • Computer Computers: Electronic
• Recording a e/ Discussion Laboratory • Appreciation Tool for an Information
Marco • Hands-On Age Complete 8th
• Running a Macro • Demonstration Exercises, • Logical thinking Edition, H.L Capron
• Recitation and J.A Johnson,
• Group work • Quizzes, • Analytical Pearson Prentice Hall
Assignments thinking Publishing
Sort and Filter • Seat work Windows XP
• Project.
Pzrofessional:
• Basic Sorts Complete Sybex
• Custom Sorts Publishing
• Filter [Link]
[Link]/
Graphics Microsoft Office 2000
for Dummies
• Adding a Picture
• Adding Clip Art
• Editing Pictures
and Clip Art
• Adding Shapes
• Adding SmartArt
Charts
• Create a Chart
• Modify a Chart
• Chart Tools
• Copy a Chart to
Word
Formatting a Worksheet
• Convert Text to
Columns
• Modify Fonts
• Format Cells
Dialog Box
• Add Borders and
Colors to Cells
• Change Column
Width and Row
Height
• Hide or Unhide
Rows and
Columns
• Merge Cells
• Align Cell
Contents
Developing a Workbook
• Format
Worksheet Tabs
• Reposition
Worksheets in a
Workbook
• Insert and
Delete
Worksheets
• Copy and Paste
Worksheets
Page Properties and
Printing
• Set Print Titles
• Create a Header
and a Footer
• Set Page
Margins
• Change Page
Orientation
• Set Page Breaks
• Print a Range
Customize the Layout
• Split a
Worksheet
• Freeze and
Unfreeze Rows
& Columns
• Hide and Unhide
Worksheets
D. TEACHER’S SELF-REFLECTION OF THE SESSION