PG TRB RECRUITMENT 2021 | COMPUTER INSTRUCTOR STUDY MATERIALS AVAILABLE NOW | SYLLABUS |EXAM PATTERN | NEED STUDY MATERIALS CONTACT WHATSAPP 6382 367 314
NEED STUDY MATERIALS CONTACT WHATSAPP 6382 367 314
COMPUTER INSTRUCTOR SYLLABUS
COMPUTER SYSTEMS ARCHITECTURE
- THE COMPUTER SYSTEM Marks: 10
System buses: Computer Components, Computer function, Interconnection Structures. |
Internal Memory: Computer Memory System Overview, Cache Memory.
Input/ Output: External Devices, Direct Memory Access, The External interface.
_ Operating System Overview. |
- THE CENTRAL PROCESSING UNIT |
Computer Arithmetic: The Arithmetic and Logic Unit (ALU), Floating-Point Arithmetic. |
instruction Sets: Types of Operands, Types of Operation, Register Organization, The Instruction Cycle.
OPERATING SYSTEMS | Marks: 10 |
Introduction: System software, OS Strategies; multiprogramming, batch.
Operating System Organization: basic OS function, kemels, device drivers.
Device Management: buffering.
Process Management: resource abstraction, process hierarchy.
Scheduling: Strategy selection.
Synchronization Principles: deadlock, semaphores, multiprocessors.
. Deadiocks: hold and wait, Banker’s Algorithm, consumable resources. :
Memory Management: memory allocation strategies, variable partition.
Protection and Security: internal access authorization.
DIGITAL ELECTRONICS Marks: 10
Fundamental Concepts: NAND, NOR and Exclusive-OR operation, Boolean Algebra.
Number system and Codes: Primary, Octal, Hexadecimal, Signed Numbers Codes.
Combinational Logic Design: K-map representation of logical functions and simplification using K-map of 4 and 5
DATA STRUCTURES Marks: 15
Abstract data types and objects, graphical user interfaces; language support and OOP: Inheritance, classes and
subclasses, header files, overloading.
Programming with Data structures: Stacks, queues, lists, trees and balanced binary trees, algorithms for searching
and sorting and open office.
PROGRAMMING IN C++ Marks: 20
- Object Oriented Programming: Data hiding, Data encapsulation, Class and Object, Abstract class and Concrete
class, Polymorphism (Implementation of polymorphism using Function overloading as an example in C++):
Inheritance, Advantages of Object Oriented Programming over earlier programming methodologies.
- Implementation of Object Oriented Programming concepts in C++: Members of a class-Data Members AND
Member Functions (methods), inside class definition and outside class definition using scope resolution operator
(::) Objects as function arguments-pass by value and pass by reference:
Constructor and Destructor: a
Constructor: Declaration and Definition of a constructor, Default Constructor, Overloaded Constructors
.Destructor: Declaration and definition of destructor, ; ~
Inheritance (Extending Class): Concept of Inheritance, Base Class, Derived Class, Defining derived classes, Multilevel
inheritance and Multiple inheritance,
Data File Handling:
Reading and Manipulation of text from an already existing text File (accessing sequentially):
- Pointers: |
Declaration and Initialization of Pointers: Dynamic memory allocation/ deallocation operators: new, delete; Pointers
and Arrays: Array of Pointers, Function retuming a pointer. Deference operator. *,->; self referential structures,
Python, PHP; |
RELATIONAL DATABASE MANAGEMENT SYSTEM Marks: 10.
- Database Management System
Introduction to database concepts: Relation/ Table, Data, Concept of String Candidate key, Alternate key, Primary
Key, Foreign Keys; Data Normalization-first, second, third, BCNF normal form:
Examples of Commercially available Database Management System’s (Back-End) -MySQL,
Examples of Front End Software’s Visual C++
- RDBMS Tools: Oracle |
Classification of SQL Statements: DML (SELECT, INSERT, UPDATE, DELETE),
SQL SELECT Statement: SQL SELECT statement, Selecting All the Columns, Selecting Specific Column, Column
_ SELECT Statement Continued: Limiting Rows during selection (using WHERE clause), Logical Operators, Use
Operators (AND/OR/NOT Operators), Logical Operator Precedence, ORDER BY Clause, Sorting in. Ascending/
Descending Order, ;
Functions: SQL Functions, Types of SQL Function (Single Row/ Multiple Row), Character Functions UPPER (]
TRIM 0, SUBSTR (, (ROUND 0), TRUNC (0, MOD(Q ), Working with Dates [LAST_DAY(Q, MONTHS_BETWEENO,
ROUND(, Implicit and Explicit Conversion, |
a Grouning Reais: Tynes Dt noun Weetisns MAX 0, MIN 0, AVG 0, SUMO, COUNT 41, using AVG and SLIM
Functions, Group By Ciause, Grouping By More than One Coiumn, Having Ciause.
Sub Queries: Guidelines for Using Sub Queries, Types of Sub-Queries (Single Row and Multiple Row)
Database Objects: DDL (Data Definition Language), , Creating Synonyms, Querying a View, Modifying a view.
Including Constraints: UNIQUE KEY, PRIMARY KEY, FOREIGN KEY, FOREIGN KEY .
Creation of a Table/ Relation: CREATE TABLE Statement, Creating a Table by Using a Sub-Query:
Managing Existing Tables and other Database Objects: The ALTER TABLE Statement, Adding a New Column
BUSINESS COMPUTING Marks: 15
integration of User Interface and Database;
More application areas of Databases:
Inventory control, Financial Accounting, Fees Management System, Result Analysis System, Admission Management
System, Income Tax Management System;
Advance Program Development Methodology: System Development
Life Cycle, Data Models (Entity Relationship Model), Attributes (Single, Composite and Multi- Valued), Relationship
(One-to-One, One-to-Many and Many-to-Many SQL Statements,
Data Dictionary, Data Warehousing, Data Mining,
WEB DEVELOPMENT Marks: 10 |
Introduction, Objectives, Introduction to Universal Resource Identifier (UR!) |
Basic Tags of HTML: HTML, HEAD, TITLE, BODY, Ordered List-OL (L1, Type-1, 1, A, a; START, VALUE),
_” “Unordered List-UL (Bullet Type- Disc, Circle, Sqtare,-DL, DT, DD), Web Page Authoring Using HTML ~
Tables: Creating Tables, Border, WIDTH, CAPTION, ALIGN,
Frames: Frameborder, height and width,
Forms: Definition, MS-Access or Oracle,
Form Tags: FORM, METHOD, Document Object Mode!
- Active Server Pages (ASP) |
Active Server Pages (ASP): Concept of ASP, features of ASP, .
| Variables: Explicit and Implicit Declaration;
Functions: | | | |
String Manipulation Functions: Ucase (), Lcase (), Len 0), Left 0, Right 0, Mid Q, Ltrim Q, InStrQ
Time & Date Functions: Date 0, Day(, Hour 0, Left 0, Len (0, Minute 0, Month 0, Monthname (0), Now 0; ,
Arrays: Declaration and use of 1 dimensional and 2 dimensional arrays;
Procedures and Functions, Passing parameters/ arguments;
Connecting with Databases: Creation of DSN, using OLEDB.
WEB SCRIPTING Marks: 10
- Java Script |
Event handling, Adding Java Script in an HTML Page
MULTIMEDIA AND AUTHORING TOOLS
TIFF, BMP, JPG/ JPEG, GIF, IC, POF, PSD: |
Image Scanning with the help of scanner: Setting up Resolution, Size, File formats of images; image preview
Significance of PDF-creation, modification; Animation, Morphing and Applications
Graphic Tools: Image Editing Software (Photoshop/ CorelDraw)
Image Handling: Cronoing an image, adiustina imaae size, saving an imaae; | ~
Layers: Adding layers, dragging and pasting selections on to layers, moving and copying layers, duplicating
layers, deleting layers, merging layers. Opacity.
| Concept of Multimedia: Picture/ Graphics, Audio, Video;
Sound: Recording Sound using Sound Recorder (Capture), Sound editing, Effect enhancement:
Voice Recognition Software Philips/ Dragon, MIDI Player, Sound Recorder.
Sound Quality: Radio Quality,
- Movie File Formats: AVI, MPEG.
Movie Frames: Concept of Frame, Frame Buffer: |
- Multimedia Authoring Using Macromedia Flash
Making of Simple Flash Movie, |
COMMUNICATION AND NETWORK CONCEPTS Marks: 20
Evolution of Networking: Internet:
Data Communication terminologies: Bandwidth (Hz, KHz, MHz) and Data transfer rate (bps, kbps, Mbps, Gbps,
Network devices: Modem, Ethemet Card, Hub, Switch, Router,
Different Topologies- Bus, Tree: Concepts of LAN, WAN, MAN;
Protocol: TCP/IP, Internet, Wireless/ Mobile Communication, GSM, Electronic Mail, Chat, Video Conferencing;
Network Security Concepts: Cyber Law, Hackers and Crackers;
ee Neb oes Hyer TEXT markup Language (HTML), Hyper Text Transfer Protocol (HTTP); Website, WebSrowser, .
SYLLABUS PDF LINK HERE