Class 12 Computer Science Syllabus WBCHSE

নিচে Computer  Science Class 12 Syllabus  টি দেওয়া হলো । এই syllabus টি West Bengal Council দ্বারা নির্মিত । চ্যাপ্টার থেকে নিচে কিছু video link দেওয়া হলো তোমাদের বোঝার জন্য ।আশা করি এটি তোমাদের কাজে লাগবে ।

 A. Sequential Logic Circuits:       (10 Marks)

• Concept of Asynchronous and Synchronous Circuits.
• Positive and Negative Edge triggers
• Concept of Latch and Flip-flops.
• SR Flip-flops using NAND and NOR Gate.
• D,JK,T and Master Slave Flip-flops
• Serial and parallel Registers
• SISO,SIPO,PIPO,PISO.
• Concept of Asynchronous and Synchronous Counters.
• Block diagram and working of Asynchronous Counter(UP/DOWN Ripple counter)
• Block diagram and working of Decade Counter.
• Block diagram and working of Asynchronous Counter.
• Block diagram and working of Ring Counter.
• Block diagram of Jhonson Counter.

B. Programming in C and Data structure     (20 Marks)

• Pointer C definition,pointer and Arrays,Array of Pointers,Pointer to an array,Pointer and Strings,Pointer and 2D array,Pointer and structure,Pointer and functions,Dynamic memory allocation.
• Command line arguments.
• I/O file handling in C (text files and Binary files).
• Concept of File pointer.
• Modes of opening files.
• Use of function Open, close, put, puts, print, fgetc, gets, scan, tell, seek, rewind,write,read.
• Data structure in C.(Both algorithm and program)
• Single linked list - Create,display,add,delete nodes from link list. search from list ,reverse a list(physically reverse a list,display list in reverse order)
• stack using Arrays - Push and Pop operation.
• Queue using Arrays - Store and retrieve operations(only simple linear Queue)
• Application of stack
• Infix,Prefix,post-fix notation
• Infix to post-fix conversion(only conversion using rules,program not required)
• Evaluation of Post-fix expression (only evaluation using rule, program not required)

C. Networking     (15 marks)

• Introduction to Networking (Definition, Advantage, disadvantage, Application)
• Analogue and digital communication.
• Modes of Communication: Simplex, half Duplex, Full Duplex Communication.
• Types of Network: - LAN,MAN,WAN.
• Network Architecture:client server and Peer to Peer Networks.
• Serial and parallel communication.
• Bandwidth. Channel capacity,Baud.
• Synchronous and Asynchronous Mode.
• Base band and Broadband network.
• Components of Networks
• Servers(file Server,Communication Server,Print server) and workstations.
• NIC
• Guided Media
• Cables: UTP, STP,Coaxial,Fiber Optics
• Unguided Media: Infrared,Radio & Microwave communication.
• Network Operating system and Characteristic.
• Network Topologies: Bus, Ring, Star, Mesh.
• Network Connecting Device: Hub, Repeater ,Bridge, Switch, router, Gateways.
• LAN Protocols:Ethernet(CSMA/CD) and Token Ring Protocol.
• Switching Technique: Circuit,Message and Packet switching.
• Use of MODEM
• TCP/IP protocols.
• TCP,IP,UDP,Telnet.
• IP addressing
• Domain Name system: URL
• Introduction to internet: 
• Basic Requirement for connecting to the internet ISP
• Service provided by the internet - WWW,browser,e-mail,Search engine, social networking.
• Network Security: Computer Virus,concept of Firewall, password.
• HTML:Basic page design using ordered and unordered list, Using image, Hyperlink, Tables.

D. Database Management System:    (15 marks)

• Introduction to Database:
• Definition of Database.
• Database Languages:(DDL,DMl,DCL)
• DBMS  and its Components.
• Various data model - ER model,Hierarchical model,Network model,Relational model (only Concepts)
• Relational Model:
• Concept of Relation,Tuple Attribute, Domain, Degree, Cardinality. 
• Concept of Keys - key, Super Key, Candidate key,Primary Key, Alternate key.
• Concept of Relationship:1:1,1:N,N:M Relationship
• Database Constrain: Integrity Constrain, Domain Constrain, Referential Integrity Constrain and concept of Foreign Key
• Functional Dependency - Full, partial , Transitive and Trivial Dependencies.
• Database Anomalies: Insertion, Deletion, Updation Anomaly.
• Normalization: Definition, Different Normal forms ( Normalizing relation up to 3NF)
• Relational Algebra: Selection Operation , Projection operation, Set operation, Cartesian Product, Natural join Operation.
• SQL
• CREATE TABLE, ALTER TABLE, DROP TABLE.
• INSERT , DELETE, UPDATE
• SELECT( DISTINCT, FROM, WHERE, AND, OR, IN, NOT IN, BETWEEN, LIKE, GROUP BY, HAVING, ORDER BY)
• SUM,AVG, COUNT, MAX, MIN 
• GRANT, REVOKE , ROLLBACK 

E.  Introduction to Object oriented Programming:   (10 Marks)

• Basic concept of OOP: Data Abstraction, Encapsulation, Inheritance, Polymorphism.
• Implement OOP using C++ : Basic Input/Output, branching, Looping, Definition of Class, Member of Class - Data member and Member function, Concept of Constructor and Destructor (programming not required), Object creation and accessing members of a class (simple programs)

F. Practical      (30 marks)

• Programming in C (coding and Execution)   (10 Marks)
• One programming Problem in C to be developed and tested in computer during the  examination. Marks are allotted on the basis of the following:
• Logic (5 marks)
• Documentation (2 Marks)
• Output Presentation ( 3 Marks) 
• Types of Problem to be given will be of application type from the following topics: Linked List manipulation, stack using array, Queue using array and linked implementation (only Linear queue), Text and binary file operations ( creation , display, searching and modification)
• Web page design using HTML and SQL( Command as per theory syllabus)         (5 Marks)
• Project Work (one project using C and one project using HTML)           (5 marks)
• Suggestive Topic:Problem related to Numerical Analysis - Bisection method, Trapezoidal rule, creation and manipulation telephone index using concept of files, creation and addition of polynomial using Linked list.
  
• Web page design using HTML (minimum 5 linked pages): Travel and tourism, Festivals, Pollution and pollution control
• Laboratory Copy      (5 marks)
• Viva Voce                (5 marks)