Course Content
1. Computer Fundamentals
0/13
1.1 Computers, Kinds of Computers in respect of size and function,
1.2 Generation of Computers,
1.3 Components and Architecture of Computers, Connecting the Components
1.4 Getting started: Orientation to personal computers, System unit, Starting the computers
1.5 Input Devices: keyboard, mouse, other input devices
1.6 Processing: CPU, Memory
1.7 Storages devices: Overview of Storage Devices, Floppy Disk Drive, Hard Drive, Universal Serial Bus (USB) Devices and Other Storage Devices
1.8 Output devices: Monitors, Printers, Modems, Soundboards
1.9 Dos survival guide: Using Command Prompt, Creating and using AUTOEXEC.BAT and CONFIG.SYS
1.10 Windows survival guide: Windows Desktop, Program Manager, Organizing the Desktop, File Manager
1.11 Application software: Using Application Software
1.12 Windows Explorer, E-mails, Internet, Intranet, Extranets, Ethernet, HTTP
1.13 Computer Viruses, Antivirus
2. Data Structure and Algorithms
0/10
2.1 Fundamental of Data Structures, Abstract Data types,
2.2 Lists, Linked Lists, Stacks,
2.3 Queues, Priority Queue,
2.4 Trees: Traversal, Implementations, Binary Trees, Binary Search Trees, Balanced Search Trees, AVL Trees.
2.5 Indexing Methods. Hashing Trees, Suffix Trees
2.6 Worst-Case and Expected time Complexity.
2.7 Analysis of Simple Recursive and Nonrecursive Algorithms.
2.8 Searching, Merging and Sorting.
2.9 Introductory Notions of algorithm design: Divide-and-Conquer, Dynamic Programming, Greedy Methods, Backtracking
2.10 Graph algorithms: Depth-first Search and Breadth-first Search, Shortest Path Problems, Minimum Spanning Trees, Directed Acyclic Graphs.
3. System Analysis and Design
0/1
Lesson
4. Operating Systems
0/1
Lesson of OS
5. Database Management System and Design
0/1
Lesson of DBMS
6. Programming Language
0/1
Lesson of Programming Language
7. Networking
0/1
Networking
8. Computer Architecture & Organization
0/1
Lesson of COA
9. Complier Design
0/1
Lesson of Compiler Design
10. E-Commerce Technology
0/1
Lesson of E-commerce Technology
11. MIS and Web Engineering
0/1
Lesson of MIS and Web Engineering
12. Legislations and IT in Nepal
0/9
12.1 The Constitution of Nepal (From Part 1 to 5, 13, 14, 15, 16, 17, 18, 19 & 20; and Schedules)
12.2 History of IT in Nepal,
12.3 IT Policy of Nepal, 2072 B.S.
12.4 Electronic Transaction Act, 2063 B.S
12.5 Copyright Act, 2059 B.S
12.6 Uses of Computers and Software Development
12.7 Nepali Unicode, Nepali Fonts
12.8 Licensing Issues
12.9 Local Government Operation Act, 2074 (Provisions related to ICT)
Sample questions
0/2
MCQ
Syllabus
IT Offcer
About Lesson

5.1 Introduction, A 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, Datetime 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.

Previous
Next
About

Empowering future IT officers and computer engineers with expert guidance and comprehensive preparation for Loksewa success.

Facebook-f Youtube Instagram
Explore
Portfolio
Contact Us
Bank Marg(Near Bhaktapur Bus Park), Baghbazar, Kathmandu
© Copyright 2025 by DIT Solution