Mizoram PSC Recruitment 2016 for Computer Operator ( Contract Basis )
Mizoram PSC Applications are invited for filling up of the undermentioned vacant posts in Mizoram Information Commission. Last date fixed for submission of application is 25th May, 2016. The prescribed application forms are available in the office of Mizoram Public Service Commission, New Secretariat Complex, Aizawl and Offices of Deputy Commissioners Office Lunglei, Saiha, Champhai, Kolasib, Serchhip, Lawngtlai and Mamit during office hours 10:00 A.M. to 3:00 P.M. on cash payment.
Name of the Post : Computer Operator ( Contract Basis ).
No. of Mizoram PSC Computer Operator Post : 1 ( One ).
Name of the Department : Secretariat Administration Department.
Mizoram PSC Computer Operator Pay Scale 2016 : PB-2,9,300 – 34,800 + GP4,400/- P.M.
Mizoram PSC Computer Operator Educational Qualification 2016 :
- HSSLC with Government approved one year Diploma in Computer Application ( DCA ) or HSSLC with DOEACC ‘O’ level or equivalent qualification from recognised Institute.
- Working Knowledge of Mizo language of at least Middle School standard.
Mizoram PSC Computer Operator Desirable Qualification 2016 :
Knowledge of Computer hardware maintenance and operations, Desktop Operating System for Windows, Basic internet / internet technologies, office automation software like Word processing, spreadsheet, Power Point presentation and Database.
Age Limit for Mizoram PSC Computer Operator 2016 : A candidate must have attained the age of 18 yrs and must not have attained the age of 35 years on the 25.05.2016. The upper age limit is relaxable by 5 years in case of candidates belonging to SC / ST.
Mizoram PSC Computer Operator Application fee of 310/- ( or 270/- for SC / ST applicants ) should be paid by cash at the Reception Counter of Mizoram Public Service Commission Office or by depositing into the Treasury under the Head- 0051-PSC, 102-State PSC ( Examination Fee. etc ) or by uncrossed Indian Postal Order ( IPO ) drawn in favour of Secretary, Mizoram Public Service Commission. Applicant must submit certified copies of all Certificates and Mark-sheets of academic record from H.S.L.C. and above and Caste Certificate ( for SC / ST if claimed ).
Syllabus for Mizoram PSC Computer Operator Exam Under Secrectariat Adminstration Department 2016 :
General English :
( Full Marks : 100 )
(a) Essay Writing ( Conventional ) – 20 Marks
(b) Idioms & Phrases ( Objective Type ) – 16 Marks
(c) Comprehension of given passages ( Objective Type ) – 16 Marks
(d) Grammar ( Objective Type ) – 16 Marks
Parts of Speech : Nouns, Adjective, Verb, Adverb, Preposition, etc.
(e) Composition ( Objective Type ) – 16 Marks
- Analysis of complex and compound sentences
- Transformation of sentences
- Synthesis of sentences
(f) Correct usage and vocabularies ( Objective Type ) – 16 Marks
Technical Paper – I ( 150 Marks )
Unit – I Fundamentals of Computer – 64 Marks
Unit – II Operating Systems – 24 Marks
Unit- III Word Processing – 24 Marks
Unit- IV Electronic Spreadsheet – 24 Marks
Unit- V Presentation Software – 14 Marks
Technical Paper – II ( 150 Marks )
Unit – I Computer Networking – 16 Marks
Unit – II Database Management System – 50 Marks
Unit- III Web Development using HTML – 50 Marks
Unit- IV Business Communication skills – 14 Marks
Unit- V Aptitude Test – 20 Marks
Paper I ( Full Mark – 150 )
Unit-I Fundamentals of Computer ( 64 Marks )
What is a Computer ( Analog Computers, Digital Computers ), Characteristics of Computers, The Evolution of Computers. Computer Generations [First Generation ( 1942-1955 ), Second Generation ( 1955-1964 ), Third Generation ( 1964-1975 ), Fourth Generation ( 1975-1989 ), Fifth Generation ( 1989-Present )].
2. Basic Computer Organization
Input Unit, Output Unit, Storage Unit, Arithmetic Logic Unit, Control Unit, Central Processing Unit, The System Concept.
3. Processor and Memory
Central Processing Unit (Control Unit, Arithmetic Logic Unit, Instruction Set, Registers, Processor Speed, Types of Processors), Main Memory (Storage Evaluation Criteria. Main Memory Organization, Main Memory Capacity, Types of Memory Chips, Cache Memory).
4. Secondary Storage Devices
Sequential and Direct-Access Devices, Magnetic Tapes, Magnetic Disks, Optical Disks, Memory Storage Devices – Flash Memory : Flash Drive / Pen Drive & Memory Card, Data Backup, On-line, Near-line, and Off-line Storage, Hierarchical Storage System (HSS), Flash Memory.
5. Input-Output Devices
input Devices ( Keyboard Devices, Point-and-Draw Devices, Data Scanning Devices, Digitizer, Electronic-card Reader, Speech Recognition Devices, Vision-Input System ), Output Devices ( Monitors, Printers, Plotters, Screen Image Projector, Voice Response Systems ).
6. Computer Software
What is Software, Relationship between Hardware and Software, Types of Software ( System Software. Application Software ), Logical System Architecture, Firmware, Middleware, Acquiring Software ( Buying Pre-written Software, Ordering Customized Software, Developing Customized Software, Downloading Public-domain Software ), Software Development Life Cycle ( SDLC ), Software Engineering ( What is Software Engineering, Need for Software Engineering, Goals of Software Engineering, Principles of Software Engineering, CASE Tools ).
7. Computer Languages
Machine Language, Assembly Language, High-Level Language, Object-Oriented Languages, Some High-Level Languages ( FORTRAN, COBOL, BASIC, PASCAL, C and C++ ), Some More High-Level Languages ( Java, C#, RPG, LISP, SNOBOL ), Characteristics of a Good Programming Language, Sleeting a Language for Coding an Application, Subprogram.
8. Classification of Computers
Notebook Computers ( Laptops ), Personal Computers ( PCs ), Workstations, Mainframe Systems, Supercomputers, Client and Server Computers, Handheld Computers ( Tablet PC, PDA/Pocket PC, Smartphone )
9. Information Technology And Society
Indian Information Technology ( IT ) Act, The Information Technology ( Amendment Bill ), Intellectual Property Rights ( IPR ) Issues, Information Technology Applications in Air Lines and Railway Ticket Reservation, Computer in Banks, Inventory Control, Financial System, Hotel Management, Computers in Education, Video Games, Telephone Exchanges, Mobile Phones, Information Kiosks, Special Effects in Movies.
Unit-II Operating Systems ( 24 Marks )
What is an Operating System, Main Functions of an Operating System.
2. Microsoft Windows
An Overview of Different Versions of Windows, Main Features of Windows Operaling System.
3. Basic Elements of Opening Screen of Windows
The Desktop, Icons and their Types, The Taskbar, Elements of a Window.
4. File Management in Windows
File. Folder, Folder Tree, Selecting Files and Folders, Creating Files and Folders, Naming and Renaming Files and Folders.
5. Windows Start Menu
All Programs, My Recent Documents, Control Panel, Printers and Faxes, Help and
Support. Search, Run, Log Off, Turn off Computer.
6. Windows Shortcuts
Creating a Shortcut, Renaming a Shortcut, Deleting a Shortcut.
7. Essentials Windows Accessories
System Tools. Entertainment, Calculator, Notepad, Paint, WordPad.
8. Command Prompt And Ms-Dos Commands
The D1R Command, MD, RD, REN, ATTRIB, TREE, PATH.
Unit-III Word Processing ( 24 Marks )
1. An Introduction
Introduction, The Word Screen, Creating documents, Editing documents, Printing documents. quieting documents
2. Formatting a Document
Text style. Changing the font type and size, Alignment of text, Formatting paragraphs with line of paragraphs with line of paragraph spacing, Adding headers, footers and page numbers
3. Using Auto Correct
Introduction to Auto Correct. Using Auto Corrcct
4. Proofing a Document with Spell and Grammer Check
Spell and grammer check the entire document, Readability statistics, Using the thesaurus, Using word count
5. Finding and Replacing Text
Replacing occurances of text, Finding and replacing formatting
6. Improving the Look of a Document
Adding borders and shading, Bullets and numbering, page setting, Format painter, Inserting symbols. Using supersript and subscript
7. Inserting Graphics
Inserting a graphic, Inserting Word Art
8. Inserting Table
Understanding tables, Table Auto Format
9. Mail Merge
The basic concept of merging documents, Working with master documents, Merging documents
Unit-IV Electronic Spreadsheet ( 24 Marks )
1. Introduction to Spreadsheets
Getting Started. The worksheet, saving the worksheet, closing a worksheet, exiting Excel
2. Using Formulas in Excel
Opening a worksheet, entering formula, copying formula, some more calculations using formula, concept of worksheets and workbook
3. Understanding Cell Referencing in Excel
Relative referencing. Absolute referencing, Mixed referencing
4. Editing a Worksheet, Formatting and Printing a Worksheet
Formatting a worksheet, printing a worksheet
5. Use of Simple Statistical Functions
Statistical functions, Adjusting the worksheet size, Conditional function
6. What-if Analysis and Data Tables in Excel
What-if analysis. Data tables, Creating a one-variable data table, Creating a two-variable data table
7. Working with Graphs and Charts
Creating charts using ChartWizard, Sizing and moving charts. Updating charts, changing the chart type, previewing and printing charts
Unit-V Presentation Software ( 14 Marks )
1.Introduction to Powerpoint
An introduction to presentation graphics, Basic elements of a slide, Different types of slide layouts, Getting stated, Creating a presentation
2.Different Views of a Presentation
Opening an existing presentation. Switching views
3.Editing a Presentation
Adding slides, Deleting slides, Rearranging slides, Changing the presentation design, Changing slide layouts, Printing a presentation
4.Adding Special Effects in a presentation
Inserting pictures from files. Animating slides, Adding sound effects, Setting slide timings, Rehearse timings, Grouping and ungrouping pictures
Paper-II ( Full Mark-150 )
Unit-I Computer Networking ( 16 Marks )
1. Networking Fundamentals
What is Computer Networking ( Advantages of Networking, Types of Networks ), Client / Server Method of Connecting Computers, Peer to Peer Computer Network (How Peer-to-Peer Network Works. Comparison of Client / Server Architecture with Peer-to-Peer Architechture), Local Area Network (LAN), Baseband vs Broadband, Media Access Control, LAN Hardware, LAN Operating Systems, Transmission Media (Twisted Pair, Coaxial Cables). Implementing LAN, Fast LANs, Nonstandard LANs, Extending LAN (Fiber Optic Extension, Repeaters, Bridges, Routers, Gateways, Wi-Fi Router, Hubs, Switches. Switching Hub), Virtual LANs, Metropolitan Area Network (MAN), Wide Area Network (WAN). Using WAN and Network Services, Network Management, Network Elements, IP Address, Network Interface Cards, Cabling Concepts, Transmission Media, Guided Media, Unguided Media, Fiber Optics Communication, Transmission Modes, Network Topologies, Logical Types of Topology, Wireless LAN, Open System Inter Connection (OSI), Network Architectures, Protocol, Layering the Communication Process, Open System Inter Connection (OSI) Model, TCP/IP Protocol (Internet Protocol (IPv4), Services provided by TCP), MAC Address (MM-MM-MM-SS-SS-SS), Subletting (How does Subnetting Work).
2. Network Administration
Introduction to Windows NT, Introduction to Windows 2000, Windows 2003 and XP Operating Systems, Windows NT/2000/2003/XP Start Up, Configuring a Windows 2000/XP System as a Client to Windows 2000/2003 XP Network (Verifying Network Configuration, Joining a Domain, Configuring Windows 2f)()()/2()()3 Professional Workstations, Connecting Windows 9x and Windows ME Workstations), Creating of User and Groups, Rights Assigned to Built-in Groups, File Sharing (Sharing Permissions, Creating Shares. Hidden Shares, Administrative Shares), Windows 2000/2003/XP Policies, Printer Sharing ( Setting Printer Permissions ).
Unit-II Database Management System ( 50 Marks )
1. An Overview of the Database Management System
What is Database, Why Database, Characteristics of Data in Database ( Field, Record, File. Database, Key Field), Database System, Database Management System ( DBMS ), Types of DBMS ( Hierarchical DBMS, Network DBMS, Relational DBMS, Object Oriented Database, Distributed DBMS ), Advantages of DBMS.
2. An Architecture of the Database System
Three Levels of Architecture, Database Models, Mapping, Database Design, Role of DBA (Database Administrator), E-R Model, Components of E-R Model, Symbols of E-R Model, Superclass and Subclass Types, Attribute Inheritance, Generalization,
Specialization, Aggregation, Categorization, Three Approaches of DBMS.
3. Relational Database Management System (RDBMS)
Introduction, RDBMS Terminologies, Relational Data Integrity, Relational Model. Base
Tables. Relational Data Manipulation. Codd’s Rules. Keys.
4. Database Application Using Microsoft Access
Using Access (Basic Concepts, Components of a Database, Concept of Database Management System, An Introduction to Access, What can Access Do?, Getting Started with Access, Creating a Database using Wizard, Opening an Existing Database, Using Table Wizard to Create a Table), ADVANCE ACCESS FEATURES (Opening a Table, Opening a Table in Datasheet View, Opening a Table in Design View, The Field Grid Pane, The Field Properties Pane, Input Mask. Creating a Caption, Default Value, Data Validation, Required, Allow Zero Length, Indexed), QUERIES, REPORTS AND FORMS (Opening a Table, Queries •- Asking Database a Question, Displaying Data Using Reports, Entering Data using Forms)
Unit-III Web Development Using Html ( 50 Marks )
1. Web Publishing And Browsing
Overview of WWW, SGML, Web Hosting, HTML, Documents Interchange Standards, Components of Web Publishing, Maintaining a Web Site, Document Management, Web Page Design Consideration and Principles, Web Site Planning, Search Engines, HTTP, Publishing Tools.
2. Html Programming Basics
Introduction, Heading Element, Block Oriented Elements, Lists, Inline Elements. Visual Markup, HTML Links, Creating Tables, Table Attributes, Frames,
3. Interactivity Tools
Untt-IV Business Communication Skills ( 14 Marks ) Office
Receipt and Dispatch of Mail, Noting on the Files, Filing Systems, Classification of Mail, Role & Function of Correspondence, Types of Correspondence.
Letter Components and Layout, Planning a Letter, Process of Letter Writing, resume
What is a Resume? Creating the First Impression, Does Your Resume Stand Out? Resume Tips. Resume Mistakes, Cover Letters.
What is an Interview? Preparing for an Interview, Interview Questions, General
Questions, How to nail the behavioural interview, Situational Questions, Asking the Interviewer Questions, Dressing for the Interview, How to Nail the Telephone Interview, Top 10 Job Interview Blunders, How to Answer Illegal Interview Questions, Following Up From the Interview.
Unit-V Aptitude Test ( 20 Marks )
1. Numerical and Figure work Test
These tests are reflections of fluency with numbers and calculations. It shows how easily a person can think with numbers. The subject will be given a series of numbers. His / Her task is to see how the numbers go together to form a relationship with each other, He / She has to choose a number which would go next in the series.
2. Verbal Analysis and Vocabulary Tests
These tests measure the degree of comfort and fluency with the English language. These tests will measure how a person will reason with words. The subject will be given questions with alternative answers that will reflect his / her command of the rule and use of English language
3. Visual and Spatial / #-D Ability Tests
These tests are used to measure perceptual speed and acuity. The subject will be shown pictures where he / she is asked to identify the odd one out; or which comes next in the sequence or explores how easily he / she can see and turn around objects in space
4. Abstract and Reasoning Test
This test measures the ability to analyze information and solve problems on a complex, thought based level. It measures a person’s ability to quickly identify patterns, logical rules and trends in new data, integrate this information, and apply it to solve problems