IT Officer New Syllabus by Loksew Aayog

Computer Officer Syllabus

1. Computer Fundamentals

• Computers, Kinds of Computers in respect of size and function,
• Generation of Computers,
• Components and Architecture of Computers, Connecting the Components,
• Getting started: Orientation to personal computers, System unit, Starting the computers
• Input Devices: keyboard, mouse, other input devices
• Processing: CPU, Memory
• Storages devices: Overview of Storage Devices, Floppy Disk Drive, Hard Drive, Universal Serial Bus (USB) Devices and Other Storage Devices
• Output devices: Monitors, Printers, Modems, Soundboards
• Dos survival guide: Using Command Prompt, Creating and using AUTOEXEC.BAT and CONFIG.SYS
• Windows survival guide: Windows Desktop, Program Manager, Organizing the Desktop, File Manager
• Application software: Using Application Software
• Windows Explorer, E-mails, Internet, Intranet, Extranets, Ethernet, HTTP
• Computer Viruses, Antivirus

2. Data Structure and Algorithms

• Fundamental of Data Structures, Abstract Data types,
• Lists, Linked Lists, Stacks,
•  Queues, Priority Queue,
• Trees: Traversal, Implementations, Binary Trees, Binary Search Trees, Balanced Search Trees, AVL Trees.
• Indexing Methods. Hashing Trees, Suffix Trees
• Worst-Case and Expected time Complexity.
• Analysis of Simple Recursive and Nonrecursive Algorithms.
• Searching, Merging and Sorting.
• Introductory Notions of algorithm design: Divide-and-Conquer, Dynamic Programming, Greedy Methods, Backtracking
• Graph algorithms: Depth-first Search and Breadth-first Search, Shortest Path Problems, Minimum Spanning Trees, Directed Acyclic Graphs.

3. System Analysis and Design

• 3.1 Defining the System, System Owner, System User, System Designers and system Builders, System Analysts, Variations on the System Analyst title, System life Cycle,
• 3.2 Joint Application Development (JAD): JAD definition, JAD purpose, JAD Philosophy, JAD Scope,
• 3.3 Involved in a JAD: Sponsor, Business Users, System Analyst
• 3.4 Roles of JAD Group Member: Project Leader, Record Keeper, Time Keeper
• 3.5 System Design Environment: Development Process, Management Process, System Structure, Basic Component of Computer based Information System, Personal/ Centralized/Distribution System.
• 3.6 Concept formations: Introduction, Finding the Problem, Evaluating the Proposal, Technical Feasibility, Operational Feasibility, Economic Feasibility.
• 3.7 Requirements analysis: Representing System Analysis Model, Requirement Model, Design Model,
• 3.8 Development Process: Design Method
• 3.9 Entity Relationship Diagram (E-R Diagram): Notations, Entities: Strong Entities, Weak Entities, Attributes: Simple and Composite, Single Valued and Multiple Valued, Null and Derived Attribute.
• 3.10 Relationship Sets: Degree of Relationship and Cardinality Relationship, Specialization, Generalization, Aggregation.
• 3.11 Data Flow Diagrams (DFDs): Introductions, Data flow Diagram, Symbol, Files or data store, External entities, Data flows,
• 3.12 Describing System by Data Flow Diagram: Context diagram, Top level DFD, Expansion Level DFD, Conversions of Data.
• 3.13 Object Modeling: Object -Oriented Concept, Object Structure, Object Feature, Class and Object.
• 3.14 Representation: Association and Composition, Inheritance, Multiple Inheritances
• 3.15 Modeling: Use Case Diagram, State Diagram, Event Flow Diagram
• 3.16 Documentation: Automatic and Manual System

4. Operating Systems

• 4.1 Definition, Developments and Functions of Operating Systems,
• 4.2 Basic components of the Operating Systems, Understand Information Storage and Management Systems,
• 4.3 Disk Allocation and Scheduling Methods, Basic Memory Management strategies, Virtual Memory Management Techniques, Define a Process and the features of the Process Management System
• 4.4 Features of Process Scheduling; Features of Inter-Process Communication and Deadlocks,
• 4.5 Concepts of Parallel and Distributed Processing, Security Threats to Operating Systems
• 4.6 Overview of the MS-DOS Operating System
• 4.7 Introduction to the Windows Family of Products, Unix Family of Products, Linux Family of Products
• 4.8 Introduction to Windows Networking
• 4.9 Windows Architecture, Linux Architecture
• 4.10 Troubleshooting Windows, & Linux
• 4.11 Managing Network Printing
• 4.12 Managing Hard Disks and Partitions
• 4.13 Monitoring and Troubleshooting Windows
• 4.14 Users, Groups and Permission Linux and Windows

5. Database Management System and Design

• 5.1 Introduction, Database Model, Relational Database Model, Integrity, RDBMS
• 5.2 SQL and Embedded SQL
• 5.3 Writing Basic SQL SELECT Statements
• 5.4 Restricting and Sorting data 5.5 Single Row Functions
• 5.6 Displaying Data from Multiple Tables
• 5.7 Aggregation Data Using Group Functions
• 5.8 Sub Queries, Manipulating Data and Creating & Managing Tables
• 5.9 Creating Views and Controlling User Access
• 5.10 Using Set Operators, Date-time Function
• 5.11 Database Design: Logical Design, Conceptual Design, Mapping Conceptual to Logical, Pragmatic issues, Physical Design, Integrity and Correctness, Relational Algebra, Relational Calculus.
• 5.12 Normalization: 1NF, 2NF, 3NF, BCNF, 4NF,5NF, DKNF
• 5.13 Architecture of DBMS: Client-server, Open Architectures, Transaction Processing, Multi-User & Concurrency, and Backup & Recovery Database.
• 5.14 Basic Concept of major RDBMS products: Oracle, Sybase, DB2, SQL Server and other Databases.

6. Programming Language

• 6.1 Overview of Programming Language: History, Programming Paradigms, The role of Language translates in the Programming Process
• 6.2 Fundamental Issues in Language Design
• 6.3 Virtual Machines, Code Generation, Loop Optimization
• 6.4 Concept of Procedural Programming, Structural Programming, Object-Oriented Programming
• 6.5 Concept of C programming, C++ Programming,
• 6.6 Java Programming for Declaration, Modularity and Storage Management Software Development

7. Networking

• 7.1 Basic Network Theory: Network Definition, Network Models, Connectivity, Network Addressing
• 7.2 Network Connectivity: The Data Package, Establishing a Connection, Reliable Delivery, Network Connectivity, Noise Control, Building Codes, Connection Devices
• 7.3 Advanced Network Theory: The OSI model, Ethernet, Network Resources, Token ring, FDDI, Wireless Networking.
• 7.4 Common Network Protocols: Families of Protocols, NetBEUI, Bridge and Switches, TCP/IP Protocol, Building TCP/IP Network, TCP/IP Suite
• 7.5 TCP/IP Services: Dynamic Host Configuration Protocol, DNS Name Resolution, NetBIOS support, SNMP, TCP/IP Utilities, FTP
• 7.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.7 Network WAN Infrastructure: WAN Environment, Wan Transmission Technologies, Wan Connectivity Devices, Voice Over Data Services
• 7.8 Remote Networking: Remote Networking, Remote Access protocols, VPN Technologies
• 7.9 Computer Security: Computer Virus, Worm, Trojan Horse
• 7.10 Network Security: Introduction, Virus Protection, Local Security, Network Access, Internet Security.
• 7.11 Disaster Recovery: Need for Disaster Recovery, Disaster Recovery plan, Data backup, Fault Tolerance
• 7.12 Advanced Data Storage Techniques: Enterprise Data Storage, Clustering, Network Attached Storage, Storage Area Networks
• 7.13 Network Troubleshooting: Using Systematic Approach to Troubleshooting
• 7.14 Network Support Tools: Utilities, Network Baseline
• 7.15 Network Access Points (NAP), Common Network Component, Common Peripheral Ports

8. Computer Architecture & Organization

• Evaluation of Computers, Design Methodology, Set Architecture, MIPS ISA, ALU Design
• Datapath Design: Single and Multiple Cycle Implementations, Pipelining, Memory Hierarchy, Input / Output System: Bus & Role of Operating System

9. Complier Design

• Introduction to Compiling,
• Logical Analysis, Syntax Analysis, Semantic Analysis,
• Run Time environment,
• Intermediate Code Generation, Code Optimization,
• Compiler Generation Tools.

10. E-Commerce Technology

• Introduction to E-Commerce
• Electronic Commerce Strategies
• Electronic Commerce Security Issues
• Success Models of E-Governance
• E-Business: b2b, b2c, b2e, c2c, g2g, g2c
• Principles of Electronic Payment, Strategies & Systems
• E-marketing, Reverse Engineering
• E-Banking, EDI Methods, SWIFT
• Encryption and Decryption Methods, XML, Layout Managers, Event Model

11. MIS and Web Engineering

• Information Systems, Client-Server Computing.
• Information Systems and Decision Making.
• Database Design issues, Data Mining, Data Warehousing
• Knowledge Management, The strategic use of Information Technology.
• Work Process Redesign (Reengineering) with Information Technology, Enterprise Resources Planning Systems, Information Systems Security, Information Privacy, and Global Information Technology issues.
• Software Supported Demonstrations including advanced Spreadsheet topics, Software Component Based Systems (CBSE),
• Multimedia
• Object-Oriented Programming with COMS & DECOMS,
• Group Decision Support Systems
• Basics of Website Design

12. Legislations and IT in Nepal

• The Constitution of Nepal (From Part 1 to 5, 13, 14, 15, 16, 17, 18, 19 & 20; and Schedules)
• History of IT in Nepal,
• IT Policy of Nepal, 2072 B.S.
• Electronic Transaction Act, 2063 B.S.
• Copyright Act, 2059 B.S.
• Uses of Computers and Software Development
• Nepali Unicode, Nepali Fonts
• Licensing Issues
• Local Government Operation Act, 2074 (Provisions related to ICT)

Download the IT Officer Syllabus in PDF