Preparation for computer operator for Lok Sewa aayog Nepal

Overview

The above picture is not just for any content. This is the success story of  MIT Park and Er. Chhatra Bhattarai. They all are computer operators and placed somewhere. Many of them are in Government jobs, some of them are in semi-government jobs and likewise. If you want to see you as a perfect Computer Operator and want to do Job in Government Sector Semi-Government sector, Corporation or somewhere else. Then You must visit Er. Chhatra Bhattarai in MIT park Bagbazar Kathmandu.

Preparation of computer operator for Lok Sewa aayog. If you are preparing for the computer operator for Lok Sewa aayog than you must have the knowledge of basic, database, and basic webpage designing if you are perfect in these three then you are a perfect candidate for Lok Sewa aayog. In the exam of Lok Sewa aayog, you will mainly ask 50 questions for the written exam. In that twelve questions will ask from computer fundamental(History of the computer) six-question form operating system, eight-question from word processing, eight-question from electronic spreadsheet, eight-question form database system, five-question from presentation system, and three question form webpage designing. Every question will for one mark and note that 20% of marks will deduct (less) for every mistake. The pass mark is 20.

Introduction To Teacher

Er. Chhatra Bhattarai is from Jhapa, Nepal. He has 27 years of teaching Experiences. He has completed his Graduation in Engineering field. he has done Engineering in Electronics & Communication from India. And also other courses like

• Post Graduate Diploma in Computer Application
• Diploma in Electronics maintenance and support-Chennai India
• Diploma in information system management-Chennai India
• Diploma in windows Programming-Chennai India.
• Diploma in Computer Maintenance-Kathmandu, Nepal

Secret tips and codes of Nepal Telecom

Professional Carrier

• Senior Program & System Analyst- G.G. software, Chennai, India
• Course coordinator-Computer skills center, Kathmandu, Nepal
• Course Coordinator-Computer concern, Kathmandu, Nepal
• General Director- National Microsystem Pvt ltd
• Lecturer- Kantipur Engineering college Kathmandu, Nobel Academy, Kathmandu
• Department Head-Kathamndu Community College. Kathmandu, Nepal
• Financial Head-G.N. Trading & smile Electronics, Kathmandu, Nepal
• CEO- Mit Park, Bagbazar, Kathmandu, Nepal

Patent Books

He has also written many Books for helping those students who can not or those who can not afford to read computer operators at Kathmandu because its an expensive place.

His books are

• Interactive Operator Guru
• Operative Encyclopedia
• Operative Guru and many more

Skills & Technique

Er. Chhatra Bhattarai is an excellent Teacher. He has got good commanding skills and Technique. He can motivate you in a minute with his taking technique, which he used in the classroom. He will share his all experiences and past activities which help students a lot with being computer operators. well, I just want to say that if you want to set your carrier in Computer then you must have to visit him.

The model question is as follows:-

1. which of the following is not the input device?

 a. Mouse 

b. Light pen 

c. Joystick 

d. Plotter. 

 2. What is the command to delete a directory? 

a. delete 

b. del 

c. rd 

d. all the above 

 3. 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 

 4. What is the short-cut key for ‘undo’?

 a. ctrl+v 

b. ctrl+p 

c. ctrl+a 

d. ctrl+z 

 5. what is the function of alt+f9? 

a. to insert the field code 

b. switching the field code 

c. run macro

 d. none of the above 

 6. To make directory 

a. MKD 

b. MKDIR 

c. CD 

d. All the above 

 7. The data bus is 

a. Bi-directional 

b. Uni-directional 

c. Multi-directional 

d. None of the above 

 8. Pico means 

a. 1 million part 

b. 1 billion part 

c. 1 trillion part 

d. 1 quillinarth part 

 9. The full form of PDA is

 a. Personal Digital Assistant 

b. Personal Diary Assistant 

c. Personal Data Assistant 

d. Professional computer operator 

 10. Which is an external command? 

a. Path 

b. Prompt 

c. Vol 

d. None

Practical Exam for computer Operator

In the Practical Exam, you will ask 7 questions. In that, you will ask English typing for 5 marks and you will get 5 minutes in this you will get a text of 225 words and you have to type within five minutes. You will get the following marks for your typing. 

 • Less than 8 words/ minute- 0 marks

 • More than 8 and less than 16 words/ minute – 1 marks

 • More than 16 and less than 24 words/ minute – 2 marks 

• Mote than 24 and less than 32 words/ minute – 3 marks 

• More than 32 and less than 40 words/ minute – 4 marks 

• More than 40 words per minute – 5 marks And you will get Nepali typing for 5 marks . in this you will get Nepali text of 225 words and you have to type within 5 minutes. You will get the following marks for your typing. 

• Less than 7 words/ minute- 0 marks 

• More than 7 and less than 14 words/ minute – 1 marks 

• More than 14 and less than 21 words/ minute – 2 marks

 • Mote than 21 and less than 28 words/ minute – 3 marks 

• More than 28 and less than 35 words/ minute – 4 marks

 • More than 35 words per minute – 5 marks # Note formula for calculation of correct word/minute =correct words/minute=(total words typed –wrong words)/5 From the word, excel and Acess you will ask for ten marks each and form Powerpoint you will ask for 5 marks . from webpage designing you will ask for 5 marks. you will be asked for a total of 5o marks and you will get a total of 45 minutes. The pass mark is 25.

You will be asked to form these model questions.

1. Computer Fundamentals 2. Operating System 3. Windows 4. Word processing 5. Electronic Spreadsheet (Excel) 6. Database system 7. Presentation system 8. webpage designing

1. Computer Fundamentals

i. Computer:- Definition, History, Generation, Characteristics, Types & Applications 

ii. Overview of a computer system:- 

iii. Data and data processing  

iv. Hardware 

1. Definition of Hardware

 2. Input Unit:- Keyboard, Mouse, Scanner, etc 

3. CPU:- Arithmetic Logic Unit (ALU), Control Unit (CU), v. Memory Unit (MU) a. Output Unit:- Monitor, Printer, etc Storage devices:- Primary & Auxiliary Memory (Floppy Disk, Hard Disk, Compact Disk, Super Disks, Zip Disks, Cartridge tape, etc.) 

1.2.2.6 Others:- Network card, Modem, Sound card, etc. 

1.2.3 Software 

1.2.3.1 Definition & Types of Software 

1.2.3.2 Programming Language 

1.2.4 Liveware 

1.2.5 Firmware and Cache Memory 

1.3 Setting & protection of Computer Room and Computer 

1.4 Concept of Computer Viruses and remedies 

1.5 Concept of Multimedia 

1.6 IT Policy of Nepal, 2000 1.7 Computer Networking

 1.7.1 Introduction to Networking 

1.7.2 Types of Network like LAN, MAN, WAN 

1.7.3 Concept about E-mail / Internet / Extranet/Intranet 

2. Operating System 

2.1 Introduction to Operating System

 2.2 Types of Operating System 

2.3 Functions of Operating Systems

 2.4 Disk Operating System(DOS) 

2.4.1 Introduction to DOS 

2.4.2 Different versions of DOS 

2.4.3 Physical Structure of the disk 

2.4.4 Types of DOS commands 

2.4.5 Use of common DOS commands

 2.4.6 Concept of File and Directory 

2.4.7 Wildcards and Pathname 

2.4.8 System files of MS-DOS and their functions 

2.4.9 Using AUTOEXEC.BAT and CONFIG.SYS files

2.5 Windows

2.5.1 Introduction to GUI 

2.5.2 Introduction of Windows Operating System

 2.5.3.1 Basic Windows Elements - Desktop, Taskbar, My Computer, Recycle Bin, etc. 

2.5.3.2 Starting and shutting down Windows 

2.5.3.3 File Management with Windows Explorer 

2.5.3.4 Windows applications: Notepad, WordPad, MS Paint, MS-DOS Prompt, Calculator, Character Map, Control Panel, etc

 2.5.3.5 Finding files of folders and saving the result

 2.5.3.6 Starting a program by using the Run command 

2.5.3.7 Changing window settings

 2.5.3.7.1 Adding/Removing programs to/from the start menu 

2.5.3.7.2 Clearing the contents of document menu 

2.5.3.7.3 Customizing the taskbar 

2.5.3.7.4 Control panel 

2.5.3.7.4.1 Date & Time 

2.5.3.7.4.2 Keyboard 

2.5.3.7.4.3 Mouse

 2.5.3.7.4.4 Multimedia 

2.5.3.7.4.5 Fonts 

2.5.3.7.4.6 Display 

2.5.3.7.4.7 Printer 

2.5.3.7.5 Creating shortcut(icons) on desktop

 2.5.3.7.6 System tools:- Scandisk, Disk Defragmenter, DriveSpace, Backup, Format 

3. Word Processing 

3.1 Concept of Word Processing 

3.2 Types of Word Processing 

3.3 Introduction to MS-Word 

3.3.1 Creating, Saving and Opening the documents 

3.3.2 Elements of MS-Word Environment (Menu, Toolbars, Status bar, Rulers, Scrollbars, etc.)

 3.3.3 Copying, Moving, Deleting and Formatting Text (Font, Size, Color, Alignment, line & paragraph spacing) 

3.3.4 Finding and Replacing Text

 3.3.5 Familiar with Devnagari Fonts 

3.3.6 Creating lists with Bullets and Numbering 

3.3.7 Creating and Manipulating Tables

 3.3.8 Borders and Shading 

3.3.9 Use of Indentation and Tab Setting 

3.3.10 Creating Newspaper Style Documents Using Column. 

3.3.11 Inserting Header, Footer, Footnotes, Endnotes, Page Numbers, file, page break, section break, Graphics, Pictures, Charts, Word Art & Symbols

 3.3.12 Opening & Saving different types of document 

3.3.13 Changing Default setting of the MS-Word 

3.3.14 Mail Merge

 3.3.15 AutoCorrect, Spelling and Grammar Checking, and Thesaurus

 3.3.16 Security Technique of Documents 

3.3.17 Concept of OLE (Object Linking Embedding)

 3.3.18 Setting Page Layout, Previewing and Printing Documents

4. Electronic Spreadsheet

4.1 Concept of Electronic Spreadsheet 

4.2 Types of Electronic Spreadsheet 

4.3 Organization of Excel Spreadsheet (Cells, Rows, Columns, Worksheet, Workbook, and Workspace) 4.4 Introduction to MS-Excel

 4.4.1 Creating, Opening and Saving Work Book 

4.4.2 Elements of MS-Excel Environment (Menu, Toolbars, Status bar, Rulers, Scrollbars, etc.) 

4.4.3 Editing, Copying, Moving, Deleting Cell Contents

 4.4.4 Familiar with Devnagari Fonts 

4.4.5 Formatting Cells (Font, Border, Pattern, Alignment, Number and Protection) 

4.4.6 Formatting Rows, Column, and Sheets 

4.4.7 Using Formula - Relative Cell and Absolute Cell Reference 

4.4.8 Using basic Functions 

4.4.9 Generating Series 

4.4.10 Changing the default option of the MS-Excel 

4.4.11 Sorting and Filtering Data. 

4.4.12 Summarizing Data with Sub Totals 

4.4.13 Creating Chart 

4.4.14 Inserting Header and Footer 

4.4.15 Spell Checking 

4.4.16 Importing from and Exporting into other Formats. 

4.4.17 Page Setting, Previewing and Printing

5. Database System

5.1 Introduction to Data, Database, and DBMS

 5.2 Basic Concept of Tables, Fields, Records, Relationships, and Indexing 

5.3 Introduction to Ms- Access 

5.3.1 Data Types 

5.3.2 Creating Tables and Formatting & Validating Field Data 

5.3.3 Creating & Using Simple Queries 

6. Presentation System and Internet 

6.1 Introduction to PowerPoint 

6.1.1 Creating, Opening, Saving Slides

 6.1.2 Formatting Slides

 6.1.3 Slide Show 

6.2 Internet 

6.2.1 Concept of Internet 

6.2.2 Wet Searching Technique 

6.2.3 Advantage of information available on the web and its application

Web page designing

Introduction to the web page. www, front page. Introduction to HTML -Html document a. Html document b. Tags c. Skeleton & Flesh -text -Hyperlinks -Images -Lists & forms -Tables -Frames

Important tips

• Do not mark on the examination question paper.
• Read the question carefully and check the answer one by one before writing an answer in the answer sheet.
• Do not strike or overwrite answer twice or more time
• Write the answer in Capital character with a simple script
• Write the answer in the proper column
• Be passion while writing your examination.