NEB Class 12 Computer Science: Complete Syllabus & Notes

Class 12 Computer Science: The Ultimate Syllabus Guide

This guide provides a complete overview of the Class 12 Computer Science curriculum, syllabus, and practical works as per the National Curriculum Framework, 2076.

A visual representation for Class 12 Computer Science concepts.

1. Course Description

Secondary Education Curriculum 2076 – Computer Science

Subject code: Com. 428 (Grade 12)

Credit hrs: 5 | Working hrs: 160

Introduction

The curriculum of computer science for Grades 11 and 12 has been developed to address the radical change in Information and Communication Technology (ICT). This course will provide a basis for students to pursue further study in the field and enter the job market. The Class 12 Computer Science curriculum covers advanced topics building on the foundation of Grade 11. It includes Database Management Systems, advanced networking, server-side web technology, advanced C programming, Object-Oriented Programming, software process models, and recent trends in technology. For more details, students can refer to the Ministry of Education, Science and Technology resources.

Level-wise Competencies

Upon completion of the course, students will be able to:

  1. Relate principles of computer systems including input, process, output, storage, Boolean logic, and number systems.
  2. Use operating systems, word processors, and spreadsheets in real-life contexts.
  3. Design websites using new web technologies.
  4. Demonstrate programming concepts and logic in the software development process.
  5. Use Database concepts at a basic SQL level.
  6. Apply networking concepts to LAN and wireless networks.
  7. Define OOPs concepts and trace recent technological trends.

2. Detailed Class 12 Computer Science Syllabus

1. Database Management System (DBMS)
  • 1.1 Introduction to data, database, Database system, DBMS
  • 1.2 Field, Record, Objects, Primary Key, Alternate key, Candidate key
  • 1.3 Advantages of using DBMS
  • 1.4 DDL (Data Definition Language) and DML (Data Manipulation Language)
  • 1.5 Database Model: Network Model, Hierarchical Model, Relational database model
  • 1.6 Concept of Normalization: 1NF, 2NF, 3NF
  • 1.7 Centralized Vs. Distributed Database
  • 1.8 Database Security

2. Data Communication and Networking
  • 2.1 Basic elements of Communication System
  • 2.2 Concept of Communication System
  • 2.3 Block Diagram of communication System/Model
  • 2.4 Elements of Data Communication/Transmission
  • 2.5 Simplex, Half duplex and Full duplex communication mode
  • 2.6 Concept of LAN and WAN
  • 2.7 Transmission Medium: Guided and Unguided
  • 2.8 Transmission impairments terminology
  • 2.9 Basic concept of Networks Architecture: Client-Server and Peer-to-peer
  • 2.10 Some Basic Terms and Tool Used in Computer Network
  • 2.11 Network Tool: Packet tracer, Remote Login
  • 2.12 Network Connecting Devices: NIC, Modem, router, switch
  • 2.13 Network Topologies: Bus, Ring and star topology
  • 2.14 Basic Concept OSI Reference Model
  • 2.15 Internet Protocol Addressing

3. Web Technology II
  • 3.1 Introduction to Server side and Client Side Scripting
  • 3.2 Introduction of internet technology
  • 3.3 Adding Java script to HTML page
  • 3.4 Java script fundamental, Data types, Variables and operators
  • 3.5 Functions and control structure
  • 3.6 Object based programming with Java Script and Event handling
  • 3.7 Image, event and form objects
  • 3.8 Form validation, JQuery
  • 3.9 Server Side Scripting using PHP
  • 3.10 Introduction to PHP, Basic PHP syntax, data types, operators, variables
  • 3.11 Object oriented programming with server side scripting
  • 3.12 Database Connectivity: Connecting script to database, SQL queries, fetching data

4. Programming in C
  • 4.1 Review of C programming concept
  • 4.2 Functions: Library and user defined functions, prototype, call, return, recursion.
  • 4.3 Structures and Unions: Definition, Declaration, Initialization, Accessing members, Array of structure, Difference.
  • 4.4 Pointers: Definition, Address (&) and indirection (*) operator, Pointer Expression, Call by values and call by reference.
  • 4.5 Working with Files: Sequential and Random File, File manipulation functions, Opening, Reading, Writing and Appending data.

5. Object-Oriented Programming (OOP)
  • 5.1 Programming paradigms: procedural, structural and object oriented
  • 5.2 Features of OOP: Class, Object, Polymorphism and Inheritance
  • 5.3 Advantages of OOP
  • 5.4 Application of OOP

6. Software Process Model (SPM)
  • 6.1 Software Project Concept
  • 6.2 Concept of software development process and SDLC life cycle
  • 6.3 System Analyst Vs Software Engineer
  • 6.4 Requirement Collection Methods
  • 6.5 Concept of system design
  • 6.6 Software and quality
  • 6.7 Software development model: waterfall, prototype, agile

7. Recent Trends in Technology
  • 7.1 Concept of Artificial Intelligence (AI) and Robotics
  • 7.2 Concept of Cloud Computing
  • 7.3 Concept of Big Data
  • 7.4 Concept of Virtual Reality
  • 7.5 Concept of e-com, e-medicine, e-gov.
  • 7.6 Concept of Mobile Computing
  • 7.7 Concept of Internet of things (IoT)

3. Practical and Project Works

a) Practical Works

1. DBMS Concept

  1. Install latest DBMS software (MySQL, PostgreSQL, etc.).
  2. Work with CREATE, DROP, ALTER DDL SQL statements.
  3. Work with SELECT, INSERT, UPDATE, DELETE DML SQL statements.

2. Concept of network and data communication

  1. Demonstrate ipconfig, ping.
  2. Construct twisted pair cable (Straight through and crossover).
  3. Demonstrate basic router Configuration.
  4. Demonstrate server based OS.
  5. Share file, folder and printer in network.
  6. Assign private IP Address in LAN network.

3. Web Technology II

  1. Perform tasks in JavaScript: Functions, control structures, Event handling, Form validation in JQuery.
  2. Perform tasks in PHP: Basic syntax, data types, operators, variables, Database Connectivity, Making SQL queries.

4. Programming II (C Programming)

  1. Factorial and Fibonacci problems.
  2. Programs using Array, Union and Structure.
  3. Programs using Pointers.
  4. Programs using File manipulation functions.

b) Suggested Project Work

  1. Study Wi-Fi network available in your area and identify the security features.
  2. Prepare a document for data collection method to develop software.
  3. Conduct a mini research to identify most recently used technologies and uses.

4. Chapter-wise Notes

Unit Chapter Name Notes
1Database Management System (DBMS)
2Data Communication and Networking
3Web Technology II
4Programming in C
5Object-Oriented Programming (OOP)
6Software Process Model (SPM)
7Recent Trends in Technology

5. Class 12 Computer Science Micro-Syllabus

1. DBMS Concept

  1. 1.1 Introduce Database Management System (DBMS) with its aspects.
  2. 1.2 State the advantages of using DBMS.
  3. 1.3 Define Data Definition Language (DDL) and Data Manipulation Language (DML).
  4. 1.4 Introduce and use database model.
  5. 1.5 State the concept of normalization.
  6. 1.6 Compare between centralized and distributed database.
  7. 1.7 Introduce database security and apply it.

2. Concept of Network and Data Communication

  1. 2.1 Describe the communication system with its basic elements and model.
  2. 2.2 Describe the data communication with its elements and mode.
  3. 2.3 Define and apply LAN and WAN.
  4. 2.4 Describe transmission medium and use it.
  5. 2.5 Define terminologies for transmission impairments.
  6. 2.6 Introduce network architecture.
  7. 2.7 Define basic terms and tools used in computer network.
  8. 2.8 Define network tools, devices and topologies and use them.
  9. 2.9 State the concept of OSI Reference Model and Internet Protocol Addressing.

3. Web Technology II (CSS, JavaScript, PHP)

  1. 3.1 Introduce internet technology.
  2. 3.2 Introduce Server side and Client Side Scripting.
  3. 3.3 Introduce and use java script fundamental and java script data types and add java script to HTML page.
  4. 3.4 Introduce and use variables and operators in java script.
  5. 3.5 Use functions and control structure in java script.
  6. 3.6 Apply object based programming with java script and event handling.
  7. 3.7 Introduce basic programming concept in PHP.
  8. 3.8 Use operators and variables in PHP.
  9. 3.9 Introduce and use data base connectivity.
  10. 3.10 Use SQL queries and create SQL database.

4. Programming II

  1. 4.1 Review the concept of C programming.
  2. 4.2 Introduce functions with prototype, call and return statements.
  3. 4.3 State the concept of library and user defined functions and their advantages.
  4. 4.4 State the concept of storage and recursion and apply them.
  5. 4.5 Introduce and differentiate between structure and union.
  6. 4.6 Define pointers and apply them.
  7. 4.7 State the concept of data file with sequential and random file.
  8. 4.8 Apply the file manipulation function.
  9. 4.9 Open, read, write and append the data file.

5. OOP Concept

  1. 5.1 Introduce object Oriented Programming (OOP) with programming paradigms and features.
  2. 5.2 State advantages and applications of OOP.

6. Software Process Model (SDLC, Software Process only)

  1. 6.1 State the concept of software project, software development process and SDLC.
  2. 6.2 Compare between system analyst and software engineer.
  3. 6.3 State the concept of system design.
  4. 6.4 Show the relation between software and quality.
  5. 6.5 Explain the software development model.

7. Recent Trends in ICT

  1. 7.1 Describe the recent trends in ICT.
Scroll to Top