IBPS Cwe IT Specalist Officers Syllabus(IT Officer Scale 1)

• Introduction and Fundamentals of Computers
  1. Computers, Kinds of Computers in respect of size and function,
  2. Generation of Computers,
  3. Components and Architecture of Computers, Connecting the Components,
  4. Getting started: Orientation to personal computers, The system unit, Starting the computers
  5. Input Devices: The keyboard, The mouse, Other input devices
  6. Processing: CPU, Memory
  7. Storages devices: Overview of Storage Devices, Floppy Disk Drive, Hard Drive, Universal Serial Bus(USB) Devices and Other Storage Devices
  8. Output devices: Monitors, Printers, Modems, Soundboards
  9. Dos survival guide: Using Command Prompt, Creating and using AUTOEXEC.BAT and CONFIG.SYS
  10. Windows survival guide: The Windows Desktop, The Program Manager, Organizing the Desktop, The File Manager
  11. Application software: Using Application Software
  12. Windows Explorer, E-mails, Internet, Intranet, Extranets, Ethernet, HTTP
  13. Computer Viruses, Antivirus
• Data Communication and Networking
  1. Basic Network Theory: Network Definition, Network Models, Connectivity, Network Addressing.
  2. Network Connectivity: The Data Package, Establishing a Connection, Reliable Delivery, Network Connectivity, Noise Control, Building Codes, Connection Devices.
  3. Advanced Network Theory: The OSI model, Ethernet, Network Resources, Token ring, FDDI, Wireless Networking.
  4. Common Network Protocols: Families of Protocols, NetBEUI, Bridge and Switches, The TCP/IP Protocol, Building TCP/IP Network, The TCP/IP Suite
  5. TCP/IP Services: Dynamic Host Configuration Protocol, DNS Name Resolution, NetBIOS support, SNMP, TCP/IP Utilities, FTP
  6. Network LAN Infrastructure: LAN Protocols on a Network, IP Routing, IP Routing Tables, Router Discovery Protocols, Data Movement in a Routed Network, Virtual LANs(VLANS)
  7. Network WAN Infrastructure: The WAN Environment, Wan Transmission Technologies, Wan Connectivity Devices, Voice Over Data Services 
  8. Remote Networking: Remote Networking, Remote Access protocols, VPN Technologies.
  9. Computer Security: Computer Virus, Worm, Trojan Horse.
  10. Network Security: Introduction, Virus Protection, Local Security, Network Access, Internet Security.
  11. Disaster Recovery: The need for Disaster Recovery, Disaster Recovery plan, Data backup, Fault Tolerance.
  12. Advanced Data Storage Techniques: Enterprise Data Storage, Clustering, Network Attached Storage, Storage Area Networks.
  13. Network Troubleshooting: Using Systematic Approach to Troubleshooting.
  14. Network Support Tools: Utilities, The Network Baseline.
  15. Network Access Points (NAP), Common Network Component, Common Peripheral Ports.
• Operating Systems 
• Database Management Systems
  
  1. Introduction, A Database Model, Relational Database Model, Integrity, RDBMS.
  2. SQL and Embedded SQL
  3. Writing Basic SQL SELECT Statements
  4. Restricting and Sorting data
  5. Single Row Functions
  6. Displaying Data from Multiple Tables
  7. Aggregation Data Using Group Functions
  8. Sub Queries, Manipulating Data and Creating &Managing Tables
  9. Creating Views and Controlling User Access
  10. Using Set Operators, Datetime Function
  11. Database Design: Logical Design, Conceptual Design, Mapping Conceptual to Logical, Pragmatic issues, Physical Design, Integrity and Correctness, Relational Algebra, Relational Calculus.
  12. Normalization: 1NF, 2NF, 3NF, BCNF, 4NF,5NF, DKNF
  13. Architecture of DBMS: Client-server, Open Architectures, Transaction Processing, Multi-User & Concurrency, and Backup & Recovery Database.
  14. Basic Concept of major RDBMS products: Oracle, Sybase, DB2, SQL Server and other Databases.
• System and Program Development Methodology
• Management Information System
  
  1. Information Systems, Client-Server Computing.
  2. Information Systems and Decision Making.
  3. Database Design issues, Data Mining, Data Warehousing
  4. Knowledge Management, The strategic use of Information Technology.
  5. Work Process Redesign (Reengineering) with Information Technology, Enterprise Resources Planning Systems, Information Systems Security, Information Privacy, and Global Information Technology issues.
  6. Software Supported Demonstrations including advanced Spreadsheet topics, Software Component Based Systems (CBSE),
  7. Multimedia
  8. Object-Oriented Programming with COMS & DECOMS,
  9. Group Decision Support Systems
  10. Basics of Website Design.
• Computer and Information System in Business  
  
  1. Introduction to E-Commerce.
  2. Electronic Commerce Strategies.
  3. Electronic Commerce Security Issues.
  4. Success Models of E-Governance.
  5. E-Business: b2b, b2c, b2e, c2c, g2g, g2c.
  6. Principles of Electronic Payment, Strategies & Systems.
  7. E-marketing, Reverse Engineering.
  8. E-Banking, EDI Methods, SWIFT.10.9 Encryption and Decryption Methods, XML, Layout Managers, Event Model.