Kerala PSC Junior Assistant Syllabus 2022 | Kerala PSC EDP Assistant Computer Application Syllabus
Computer Application Syllabus for the post of
- Junior Assistant in Kerala State Backward Classes Development Corporation Limited
- Assistant Grade II in Overseas Development and Employment Promotion Consultants Limited
- Junior Assistant in Kerala State Industrial Enterprises Limited
- EDP Assistant in Kerala State Co-Operative Rubber Marketing Federation Limited
| Computer Fundamentals & Informatics | |
| Hardware components | Hardware-Definition, Components – Control unit, ALU, I/O devices, Memory, Motherboard-functions of each. Types of PCs – Desktop, Laptop, Note book, PDA, Special Purpose computers, Super Computers – Characteristics and area of use Memory – Comparison – Primary vs Secondary memory, RAM and ROM variations, Various Magnetic and Optical Storage Devices – examples. Input Devices – Keyboard, Mouse, trackball, joystick, scanners, Digital camera, OCR, OMR, MICR, Light pen, bar code readers, QR code, Voice recognition and touch screen – Characteristics. Output Devices – Monitors, Printers, Plotter, Sound cards and speakers – Characteristics. |
| Software Concepts | Types of software- system software and application software, System software- definition and examples. Functions of OS application software – definition and examples – Number systems – decimal, octal, hexadecimal and binary – Representation concepts only. Computer coding systems – EBCDIC, ASCII and Unicode-definitions. |
| Office Automation | |
| Introduction to MS-Word | Introduction to Word Processing, Introduction to MS Word – features, Creating, saving and opening documents in word, Interface, Toolbars, Ruler, Different Menus, Keyboard shortcut. Editing a document. Opening Multi document windows, Editing Text- selecting, inserting, deleting, moving text, Previewing documents, Printing documents. Formatting Documents- Paragraph formats, Aligning Text and Paragraph, Borders and Shading, Headers and Footers, Multiple Columns. |
| Introduction to MS-Excel | Worksheet basics – Creating worksheet, Definition of Cell, columns and rows. Saving & protecting worksheet. Opening and moving around in an existing worksheet. Toolbars and Menus-Functions, keyboard shortcuts. Cell formatting, changing alignment, character styles, column width, date format, borders & colors. Working with formulas & Cell referencing. Functions. Previewing & Printing worksheet – Page setting, Print titles, Adjusting margins, Page break, headers and footers. |
| Introduction to MS-PowerPoint | Purpose of Power Point. Working with different views and menus of power point. Working with slides – Make new slide, move, copy, delete, duplicate, designing and lay outing of slide. Editing and formatting text, Printing presentation – Print slides, notes, handouts and outlines. Inserting Objects- Drawing and inserting objects using Clip Art’s pictures and charts, Adding graphics, multimedia and special effects. Custom Animation – slide transition effects and other animation effects. |
| Programming Languages | |
| OOP Concepts | Principle of Object-oriented Programming –
Object-Oriented Programming paradigm, Basic Concepts of Object Oriented Programming, Benefits of OPPs, Object-Oriented Languages, Essentials of OOP (Objects, Class, Encapsulation, Data Abstraction, Inheritance, Reusability, Polymorphism, Delegation, Message Communication), Structure of C++ Program, Creating the Source File, Compiling and Linking. C++ Basics – Preprocessors, comments, Data types, Operators, Expressions, Identifiers, Key words, Symbolic constants, Variable declaration and dynamic initialization, C++ statements, Control structures, Arrays and string handling, Specifying a Class, Defining Member Functions, its scope |
| Visual Basic.Net | Introduction to .NET –
.NET Framework features & architecture, CLR, Common Type System, MSIL, Assemblies and class libraries, Introduction to Visual studio, Project basics, types of project in .NET, IDE of VB.NET – Menu bar, Toolbar, Solution Explorer, Toolbox, Properties Window, Form Designer, Output Window, Object Browser. Visual development & event driven Programming – methods and events. The VB.NET Language – Variables – Declaring variables, Data Type of variables, Forcing variables declarations, Scope & lifetime of a variable, Constants, Arrays, types of array, control array, Collections, Subroutines, Functions, Passing variable, Number of Argument, Optional Argument, Returning value from function. Control flow statements : conditional statement, loop statement. GUI programming with Windows Forms, Msgbox & Inputbox, TextBox, Label, Button, Listbox, Combobox, Checkbox, Radio button tc. |
| Data Base Management Systems | |
| Introduction to Database concepts | Need of database, Flat database, Database Management Systems, Characteristics of DBMS, Relational Database, Entity and Referential Integrity, Primary Key, Foreign key, Database elements- Tables, records, Query, Form, Report, Client-server paradigm |
| Database Query commands | Different DDL, DML, DCL commands, Creating, deleting, updating and manipulating tables using SQL commands, Applying constraints on tables, filtering using WHERE, LIKE etc. Joining tables, grouping data using Group By. Data aggregation functions. |
| Web Designing | |
| World Wide Web (www) | History, Working, Web Browsers – functions, Concept of Search Engines, Searching the Web, HTTP, URLs, Web Servers, Web Protocols, HTML , Design tools, HTML editors, Image editors |
| HTML | Concepts of Hypertext, Versions of HTML, Elements of HTML, Syntax, Head & Body Sections, Building HTML Documents. Inserting Texts, Images, Hyperlinks, Backgrounds and color controls, different HTML tags, table layout and presentation, use of font size & Attributes, List Types and Its Tags, Use of Frames and Forms in Web pages. |
| JavaScript | Overview, syntax & conventions. Variables, Expressions, Branching& Looping statements, Functions, Arrays Objects, Events & Document Object Model – on Click, on Mouse Over, on submit, on focus, on change, on blur. On Load, on Unload, Alerts, Prompts & Confirms. |
| Data Collected By – K. Jeyanthi | |
| Published on – 13th April 2022 | |
Leave a Reply