Computer Operator Syllabus of Lok Sewa Aayog Na Su Computer Operator
1. Computer Fundamentals
- Computer: – Definition, History, Generation, Characteristics, Types & Applications.
- Overview of a computer system: -
- Data and data processing
- Hardware
- Definition of Hardware
- Input Unit: – Keyboard, Mouse, Scanner, etc
- CPU: - Arithmetic Logic Unit (ALU), Control Unit (CU), Memory Unit (MU)
- Output Unit: - Monitor, Printer, etc
- Storage devices: - Primary & Auxiliary Memory (Floppy Disk, Hard Disk, Compact Disk, DVD, Flash disk etc.)
- Others: - Network card, Modem, Sound card, etc.
- Software
- Definition & Types of Software
- Programming Language
- Liveware
- Firmware and Cache Memory
- Setting & protection of Computer Room and Computer
- oncept of Computer related threats (virus, worms, Trojan, phishing etc) remedies and protection
- Concept of Multimedia
- File Management basic:
- Physical Structure of the disk
- Concept of File and folder
- Wildcards and Pathname
- Type of files and file extensions
- Computer Networking
- Introduction to Networking
- Types of Networks (LAN, MAN, WAN etc)
- Concept of E-mail / Internet / Extranet / Intranet, World Wide Web (WWW)
- Familiarity with internet browsers (e.g Internet explorer, Firefox, Opera, Safari, Google Chrome etc)
- Introduction to IP address, subnet mask and default gateway
- Introduction to Network Media, Topology and Protocol
- Setting Up Microsoft Network
- Dial-Up Networking
- Number Systems
- Introduction to binary, octal, decimal and hexadecimal number systems
- Introduction to ASCII and Unicode standards
- IT policy of Nepal
- Electronic Transaction Act 2008
- Overview of a computer system: -
2. Operating System
- Introduction to Operating System
- Types of Operating System
- Functions of Operating Systems
- Command line operation (e.g. copy command, move command, command to view and set different file attributes etc)
- Windows
- Introduction to GUI
- Introduction of Windows Operating System
- Basic Windows Elements , My Computer, Recycle Bin, etc.
- Starting and shutting down Windows
- File Management with Windows Explorer
- Windows applications: (e.g. Control Panel, Character Map, Paint etc)
- Finding files of folders and saving the result
- Starting a program by command line operation
- Changing window settings
- Adding/Removing programs
- Clearing the contents of document menu
- Customizing the taskbar
- Control panel items.
- Creating shortcut (icons) on desktop
- System tools: - disk scanning, disk defragmenter, backup, restore, format.
- Introduction of Windows Operating System
3. Word Processing
- Concept of Word Processing
- Types of Word Processing
- Introduction to Word Processor
- Creating, Saving and Opening the documents
- Elements of Word Processing Environment (Menu, Toolbars, Status bar, Rulers, Scrollbars, etc.)
- Copying, Moving, Deleting and Formatting Text (Font, Size, Color, Alignment, line & paragraph spacing)
- Finding and Replacing Text
- Familiar with Devnagari Fonts
- Creating lists with Bullets and Numbering
- Creating and Manipulating Tables
- Borders and Shading
- Use of Indentation and Tab Setting
- Creating Newspaper Style Documents Using Column
- Inserting Header, Footer, Footnotes, Endnotes, Page Numbers, File, Page break, Section break, Graphics, Pictures, Charts, Word Art, Symbols & Organization Chart
- Opening & saving different types of documents
- Changing Default settings
- Mail Merge
- AutoCorrect, Spelling and Grammar Checking, and Thesaurus
- Customizing menu & toolbars
- Security Technique of Documents
- Master Document, Cross Reference, Index, Table of Content.
- Setting Page Layout, Previewing and Printing Documents
4. Electronic Spreadsheet
- Concept of Electronic Spreadsheet
- Types of Electronic Spreadsheet
- Organization of Electronic Spreadsheet application (Cells, Rows, Columns, Worksheet, Workbook and Workspace)
- Introduction to spreadsheet application
- Creating, Opening and Saving Workbook
- Elements of Electronic Spreadsheet Environment (Menu, Toolbars, Status bar, Rulers, Scrollbars, etc.)
- Editing, Copying, Moving, Deleting Cell Contents
- Familiar with Devnagari Fonts
- Formatting Cells (Font, Border, Pattern, Alignment, Number and Protection)
- Formatting Rows, Column and Sheets
- Using Formula – Relative Cell and Absolute Cell Reference
- Using basic Functions
- Generating Series
- Changing default options
- Sorting and Filtering Data
- Summarizing Data with Sub Totals
- Creating Chart
- Inserting Header and Footer
- Spell Checking
- Customizing Menu & Toolbars
- Importing from and exporting into other Formats
- Pivot Table, Goal Seek, Scenario & Audit
- Page Setting, Previewing and Printing
5. Database System
- Introduction to Data, Database and DBMS
- Basic Concept of Tables, Fields, Records, Relationships and Indexing
- Introduction to database application
- Data Types
- Creating, Modifying & Deleting Tables and Formatting & Validating Field Data
- Creating, Modifying, Deleting & Using Simple Queries
- Creating, Modifying & Deleting Forms/Reports/Macros
6. Presentation System
- Introduction to presentation application
- Creating, Opening & Saving Slides
- Formatting Slides
- Slide Show
- Animation
- Inserting Built-in picture, Picture, Table, Chart, Graphs, Organization Chart etc.
7. Web page Designing
- Introduction to Web Page and CMS (Content Management System)
- Introduction to HTML
- HTML document
- Tags
- Skeleton & Flesh
- Text
- Hyperlinks
- Images
- Lists & forms
- Tables
- Frames
- Introduction to HTML
—The end—
(Sample questions)
- Which of the following is not the input device?
- Mouse B. Light Pen C. Joystick D. Plotter
- What is the command to delete a directory?
- delete B. del C. rd D. all of the above
- From where do you install Fonts?
- Font icon of Control Panel B. Font Option of Format menu
C. Options submenu of Tools menu D. None of the above
- What is the output if a cell containing a number 3245.45 is formatted to ‘#, ###’ number format?
A. 3245.45 B. 3245.450 C. 3245 D. 3,245
- What is the short-cut key of ‘Undo’?
- ctrl+v B. ctrl+p C. ctrl+a D. ctrl+z
