Monday, November 20, 2017

Public Service Commission Computer Operator Exam - Syllabus

Public Service Commission Computer Operator Exam
Syllabus and Chapters Introduction

Operating System (OS)
Operating System software is a set of programs that are designed to control and manage the operations of a computer system. OS software helps computer hardware to work together and controls all internal operations like reading data from input devices, transmitting information to output devices, checking the components of a computer, etc. OS is essential for the development of applications software.

OS controls and manages the hardware present in the computer like microprocessor, input and output devices, storage devices, etc. It manages computer memory. It assigns the memory to various programs when required and then makes the memory free after the program is not in use. It manages files of application programs on a variety of storage media. It performs file related operations such as copying, deleting, moving, and so on. It manages software resources of the computer system. It creates the environment to run other software like MS-Word, MS-PowerPoint, Macromedia Flash, MS-Excel, MS-Access etc. It notifies the user about system errors or errors that encounters during program execution. Microsoft Disk Operating system (MS-DOS), Microsoft Windows 95, Microsoft Windows 98, Windows XP, Windows 7, Windows 8, Windows 10, Apple Macintosh, IBM OS/2, UNIX and LINUX are some examples of operating systems. Some smart phone OS are Android, iOS, Lollypop etc.

Microsoft Office Package
Microsoft provides the office package software that includes MS-Word, MS-Excel, MS-PowerPoint, MS-Access etc. 

MS-Word
It is word processing software which is designed for preparing documents, reports, letters and so on. It performs other varieties of task like paragraph formatting, page formatting, inserting image, tables, grammar checking etc. 

MS-Excel
It is spreadsheet software which is designed for calculation, accounting, preparing budget sheet and so on. It supports statistical analysis, financial analysis, accounting, charts and diagrams.

MS-PowerPoint
It is presentation software which is designed to present the information in attractive and interactive way to the viewers. It provides the feature of slides with sound, images, animations, transitions, hyperlink, hotspots, plain text and navigation bars to present the information in attractive way.

MS-Access(Database)
MS-Access is the Relational Database Management System Software (RDBMS) that allows us to manage data stored in multiple tables. MS-Access allows us to link multiple tables on the basis of a key field (primary key) and information can be retrieved from the multiple tables. MS-Access provides a set of Objects in order to manage databases. These all components of  MS-Access are stored in a single file called Database file. The main objects of MS-Access are table, form, query, report, macro, modules and pages.

Data types of MS-Access
The data type determines the kind of data to be stored in field of a database table. The data types of MS-Access are text, memo, number, autonumber, date/time, yes/no, hyperlink, OLE-Object, currency and Lookup wizard.

Computer Networking
The interconnection of two or more than two computers is known as computer network. It provides us a lot of advantages like data sharing, softeare sharing, hardware resource sharing among the computer on the network. It has different types on the basis of geographical location are as LAN, MAN and WAN.

E-mail and Internet

MS-DOS(Microsoft Disk Operating System)

Practical Exam (Typing English and Nepali)

0 comments:

Post a Comment