C.I.C.
Certificate in Computing
Course Syllabus
FUNDAMENTALS OF COMPUTER
- Introduction of Computer
- Definition of Computer
- Data, Information, Database
- Uses of Computer
- Functions of Computer
- Features of Computer
- Concept of INPUT, PROCESS and OUTPUT
- Block Diagram of Computer
- Anatomy of Computer, Hardware and Software
- Units of Computer
- Input, System and Output Units
- Data Representation
- Binary Digits, Byte, Kilobytes, Megabytes, Gigabytes Terabytes etc.
- Number System
- History and Generations of Computer
- Computer Devices -The Hardware
- Input, Storage and Output Devices
- Driving the Computer- The Software
- Digital Computer, Analog Computer
- Hybrid Computer, Super Computer, Mainframes Computer,
- Mini Computer, Micro Computer
- System Software
- Applications Software
TYPING SKILLS
• Introduction to Computer Keyboard
• Understanding Different Types of Keys (Alphabet Keys, Number Keys, Function Keys, Special Keys)
• Introduction to Touch Typing Method
• Correct Sitting Posture and Hand Position on Keyboard
• Home Row Keys Practice (A S D F J K L 😉
• Finger Placement and Basic Typing Exercises
• Practice of Top Row Keys and Bottom Row Keys
• Typing Practice with Letters, Words and Sentences
• Typing Practice with Numbers and Symbols
• Use of Shift Key and Special Characters
• Speed Typing Practice
• Accuracy Improvement Techniques
• Typing Practice using Paragraphs and Passages
• Typing Practice using Official Letter and Application Format
• Introduction to Typing Software and Tools
• Basic Knowledge of English Typing Tests
• Typing Speed Test Preparation (WPM – Words Per Minute)
• Accuracy and Error Correction Practice
• Practical Typing Exercises and Daily Practice Sessions
MICROSOFT WINDOWS
• Introduction of Operating System
• Definition of Operating System
• Types of Operating System
• What is Windows?
• Desktop, Wallpaper, Icon, Taskbar, Start Menu
• Windows Accessories- Paint, WordPad, Notepad, Calculator
• Control Panel – Programs and Features, Keyboard, Mouse, Power Options, Fonts, Sounds etc.
• Windows Explorer
• File Management, File and Folder Operations
• Creating Files and Folder
• Copy, Move, Rename and Delete files and Folders
• Recycle Bin
• Searching Files and Folders
• System Settings
• Installing and Uninstalling Software
• User Account
• Disk Management
• Disk Defragmentation
• Disk Clean up
• Disk Management
• Basic Troubleshooting and many more.
MICROSOFT WORD
• Introduction of Microsoft Office
• Introduction of Word Processing Software Microsoft Word
• Creating and Saving Documents
• Opening and Closing Documents
• Editing Text
• Page Setup – Paper Size, Orientation, Margins, Gutter
• Moving around the document with keyboard shortcuts
• Protect Documents with password
• Text Formatting with keyboard shortcuts
• Advance Text Formatting
• Advance Paragraph Formatting
• Find, Replace and GoTo
• Change Case – Upper case, Lower case, Sentence case, Capitalize Each Word case, toggle case
• Headers and Footers
• Bullet and Numbering
• Borders and Shading
• Inserting Images, Shapes, 3D Model, SmartArts, Charts, Screenshot, WordArt
• Page Colour and Watermark
• Tabs
• Columns
• Spelling and Grammar
• Page Break and Section Break
• Table
• Table Keyboard Shortcuts
• Hyperlink, Cross Reference
• Mail Merge
• Printing Documents and many more.
MICROSOFT EXCEL
• Introduction of Microsoft Excel
• Introduction of Worksheet or Spreadsheet or Sheet
• Parts or Components of Excel Window
• Moving around the Worksheet with keyboard shortcuts
• Inserting Row, Column and Sheet
• Deleting Row, Column and Sheet
• Formatting Cells, Row, Column and Sheet
• Hide and Unhide Row, Column and Sheet
• Rename Sheet, Change Tab Colour of Sheet
• Data Entry and Editing
• Creating and Managing Databases
• Protecting Worksheet with password
• Formula or Functions in Excel
• Mathematical Function
• Text Function
• Date and Time Function
• Logical Function
• Financial Function
• Inserting and Formatting Charts and Graphs (Column, Pie, etc.)
• Conditional Formatting
• Sorting and Filtering Data
• Auditing – Trace Precedent, Trace Dependent, Remove All
• Pivot Tables
• Data Validation
• Page Setup and Printing and many more.
MICROSOFT POWERPOINT
• Introduction of Presentation Software
• Features of Microsoft PowerPoint
• Creating and Showing Presentation
• Creating Slides, Slide Layouts and Themes
• Inserting Text, Images, Shapes, SmartArts and Charts
• Slide Formatting
• Slide Transitions and Animations
• Slide Show, Custom Show
• Inserting Audio and Video in presentation
• Presentation Design Techniques
• Printing Handouts
• Exporting Presentation in mp4 video Format and many more.
CONCEPT OF INTERNET AND INTRANET
• Introduction to Internet and Intranet
• History and development of the Internet
• Basic concepts and working of the Internet
• Difference between Internet, Intranet and Extranet
• Types of Computer Networks – LAN, MAN, WAN
• Network devices – Modem, Router, Switch and Hub
• Internet Service Provider (ISP) and Internet connection types
• Web Browser and its features
• Popular Web Browsers – Google Chrome, Mozilla Firefox, Microsoft Edge
• Internet Browsing and searching information on the web
• Understanding Website, Web Page, URL and Hyperlink
• Search Engines and their use – Google, Bing, Yahoo
• Downloading and uploading files from the Internet
• Online communication and collaboration
• Introduction to E-mail (Electronic Mail)
• Creating and managing an E-mail account
• Sending, receiving, replying and forwarding E-mails
• Using CC, BCC and attaching files in E-mail
• Internet safety and security basics
• Safe browsing practices and protection from viruses
• Basic awareness of cyber security and online privacy