NEB Class 12 Computer Science Curriculum

Computer Science(Com. 332)
Syllabus

Full marks: 75 (Pass marks: 24)

Course Contents:

Unit 1: Database Management System (DBMS)

1. Introduction to data, database, Database system, DBMS
2. Field, Record, Objects, Primary Key, Alternate key, Candidate key
3. Advantages of using DBMS
4. DDL (Data Definition Language) and DML (Data Manipulation Language)
5. Database Model: Network Model, Hierarchical Model, Relational database model
6. Concept of Normalization: 1NF, 2NF, 3NF
7. Centralized Vs. Distributed Database
8. Database Security

 Unit 2: Data Communication and Networking

1. Basic elements of Communication System
2. Concept of Communication System
3. Block Diagram of communication System /Model
4. Elements of Data Communication/Transmission
5. Simplex, Half duplex and Full duplex communication mode
6. Concept of LAN and WAN
7. Transmission Medium: Guided and Unguided
8. Transmission impairments terminology (Jitter, Singing, Echo, Crosstalk, Distortion, Noise, Bandwidth, Number of receivers)
9. Basic concept of Networks Architecture: Client- Server and Peer-to-peer
10. Some Basic Terms and Tool Used in Computer Network: IP Address, Sub Net Mask and Gateway, MAC address, Internet, Intranet, Extranet
11. Network Tool: Packet tracer, Remote Login
12. Network Connecting Devices: NIC, Modem, router, switch
13. Network Topologies: Bus, Ring and star topology
14. Basic Concept OSI Reference Model
15. Internet Protocol Addressing

Unit 3: Web Technology II

1. Introduction
2. Server side and Client Side Scripting
3. Introduction of internet technology
4. Adding Java script to HTML page
5. Java script fundamental
6. Java Script Data types
7. Variables and operators
8. Functions and control structure if-else, if-else- if, switch-case, for, while, do while loop
9. Object based programming with Java Script and Event handling
10. Image, event and form objects
11. Form validation, JQuery
12. Server Side Scripting using PHP
13. Introduction to PHP: Hardware and Software Requirements
14. Object oriented programming with server side scripting
15. Basic PHP syntax
16. PHP data types
17. Basic Programming in PHP
18. Image, event and form objects
19. Operators (Arithmetic, logical, comparison, operator precedence)
20. Variables Manipulation
21. Variables Manipulation
22. Database Connectivity
23. Connecting server side script to database
24. Making SQL queries
25. Fetching data sets getting data about data
26. Creating SQL database with server side scripting
27. Displaying queries in tables

Unit 4: Programming in C

1. Review of C programming concept
2. Functions
   1. Concept of library and user defined functions and advantages
   2. function definition, prototype, call and return statements
   3. Accessing a Function by passing values
   4. Concept of storage: automatic and external
   5. Concept of Recursion: factorial and Fibonacci problems
3. Structures and Unions
   1. Structure: Definition, Declaration, Initialization and Size of Structure.
   2. Accessing member of structure
   3. Array of structure
   4. Union: Definition, Declaration
   5. Difference between union and structure.
4. Pointers
   1. Definition of Pointer
   2. Address (&) and indirection (*) operator
   3. Pointer Expression and Assignment
   4. Call by values and call by reference
5. Working with Files
   1. Concept of Data File
   2. Sequential and Random File
   3. File manipulation function: putw, getw, putc, getc, fscanf, fprintf
   4. Opening, Reading, Writing and Appending data file

Unit 5: Object-Oriented Programming (OOP)

1. Programming paradigms: procedural, structural and object oriented
2. Features of OOP: Class, Object, Polymorphism and Inheritance
3. Advantages of OOP
4. Application of OOP

Unit 6: Software Process Model

1. Software Project Concept
2. Concept of software development process
3. Concept SDLC life cycle
4. System Analyst Vs Software Engineer
5. Requirement Collection Methods
6. Concept of system design
7. Software and quality
8. Software development model: waterfall, prototype, agile

Unit 7: Recent Trends in Technology

1. Concept of Artificial Intelligence(AI)and Robotics
2. Concept of Cloud Computing
3. Concept of Big Data
4. Concept of Virtual Reality
5. Concept of e-com, e-medicine, e-gov.
6. Concept of Mobile Computing
7. Concept of Internet of things(IoT) of Big Data