Manipur State Board has published subject wise syllabus for this year Class 12 students in its official portal cohsem.nic.in Here we have published Class 12 COHSEM Syllabus 2024-25 for Computer Science subject. For more information regarding Council of Higher Secondary Education (COHSEM) Class 12 2024 Exam Date, Exam Pattern, Time, Date, How to prepare follow our website.
Board |
Council Of Higher Secondary Education (COHSEM) |
Topic |
Syllabus |
Subject |
Computer Science |
How to download Manipur Class 12 Syllabus 2024-25 – Computer Science?
- Step 1: Open your browser
- Step 2: Type cohsem.nic.in
- Step 3: Go to the Syllabus link active on the left panel of the home page of the website (Syllabus for Classes XI – XII).
- Step 4: Click on Class 12 Syllabus link 2024
Class 12 Computer Science
Computer Science (Theory)
Unit No. | Name of Unit | Marks |
1 | Data Structure Using Python | 30 |
2 | Database Management System and SQL | 25 |
3 | Communication and Network Concepts | 15 |
A minimum of 180 periods including practicals
Unit 1: Data Structure Using Python
Chapter 1: Exception and File Handling in Python
Exception Handling: syntax errors, exceptions, need of exception handling, user-defined exceptions, raising exceptions, handling exceptions, catching exceptions, Try – except – else clause, Try – finally clause, recovering and continuing with finally, built-in exception classes.
File Handling: text file and binary file, file types, open and close files, reading and writing text files, reading and writing binary files using pickle module, file access modes.
Chapter 2: Stack
Stack (List Implementation): Introduction to stack (LIFO Operations), operations on stack (PUSH and POP) and its implementation in python. Expressions in Prefix, Infix and postfix notations, evaluating arithmetic expressions using stack, conversion of Infix expression to postfix expression
Chapter 3: Queue
Queue (List Implementation): Introduction to Queue (FIFO), Operations on Queue (INSERT and DELETE) and its implementation in Python.
Introduction to DQueue and its implementation in Python.
Chapter 4: Searching
Searching: Sequential search, Binary search, Analysis of Sequential and Binary Search. Dry run to identify best, worst and average cases. Implementation of searching techniques in Python
Chapter 5: Sorting
Overview of sorting techniques, Bubble Sort, Selection Sort and Insertion Sort. Dry run to identify best, worst and average cases. Implementation of sorting techniques in Python. Hashing: Hash Functions, Collision Resolution, Implementing the Map Abstract Data Type.
Unit II: Database Management System and SQL
Chapter 6: Understanding Data
Data and its purpose, collection and organization; understanding data using statistical methods: mean, median, standard deviation, variance; data interpretation; visualization of data.
Chapter 7: Database Concepts
Introduction to database concepts, difference between database and file system, relational data model: concept of domain, tuple, relation, keys – candidate key, primary key, alternate key, foreign key;
Relational algebra: selection, projection, union, set difference and cartesian product;
Chapter 8: Structured Query Language
Advantages of using Structured Query Language, Data Definition Language, Data Query Language and Data Manipulation Language, Introduction to MySQL, Creating a database using MySQL, Data Types
Data Definition: CREATE TABLE, DROP TABLE, ALTER TABLE, Data Query: SELECT, FROM, WHERE
Data Manipulation: INSERT, UPDATE, DELETE Math functions: POWER (), ROUND (), MOD ().
Text functions: UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/ SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME ().
Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).
Querying and manipulating data using Group by, Having, Order by.
Operations on Relations – Union, Intersection, Minus, Cartesian Product, JOIN
Communication and Network Concepts
Chapter 9: Computer Networks
Introduction to computer networks, Evolution of networking,
Network types: LAN, WAN, MAN
Network devices: Modem, Ethernet Card, Repeater, Hub, Switch, Router, Gateway. Network
Topologies: Mesh, Ring, Bus, Star, and Tree topologies
Basic concept of MAC and IP Address Difference between Internet and web
Chapter 10: Data Communication
Concept of communication, Types of Data Communication, switching techniques
Communication Media: Wired Technologies – Twisted pair cable, Co-axial cable, Ethernet Cable, Optical Fibre;
Introduction to mobile telecommunication technologies Wireless Technologies – Bluetooth, WLAN, Infrared, Microwave
Network Protocol: Need for Protocol, Categorization and Examples of protocol, HTTP, FTP, IP, PPP; electronic mail protocol
Concept of Channel, Bandwidth (Hz, KHz, MHz) and Data Transfer rate (bps, Kbps, Mbps, Gbps, Tbps)
Chapter 11: Security Aspects
Threats and prevention: Viruses, Worms, Trojan horse, Spam, Cookies, Adware, Firewall, http vshttps
Network Security Concepts: Firewall, Cookies, Hackers and Crackers Antivirus and their workings
Network security threats: Denial of service, Intrusion problems, Snooping, Eavesdropping
Design of Question Paper
Class 12 Practical
(1) Programming in Python
One programming problem in Python to be developed and tested in Computer During the examination. Marks are allotted on the basis of following:
Logic: 5 Marks
Documentation/Indentation : 2 Marks
Output presentation : 3 Marks
Notes : The types of problems to be given will be of application type from the following topics
- Lists
- Stack using Lists
- Queue using Lists (circular)
- Searching and sorting
- Binary File operations (Creation, Displaying, Searching and modification)
- Text File operations (Creation, Displaying and modification)
(2) SQL Commands
Five Query questions based on a particular Table/Relation to be tested practically on Computer during the examination. The command along with the result must be written in the answer sheet.
(3) Project Work
The project has to be developed in Python language and also should have use of Data files.
- Presentation on the computer
- Project report (Listing, Sample, Outputs, Documentation)
- Viva-Voce
(4) Practical File
Must have minimum 20 programs from the following topics
- Lists
- Stack using Lists
- Queue using Lists (circular)
- Searching and sorting
- Binary File operations (Creation, Displaying, Searching and modification)
- Text File operations (Creation, Displaying and modification)
15 SQL commands along with the output based on any table/relation:
(5) Viva Voce
Viva will be asked from syllabus covered in Class-XII and the project developed by student.
Guidelines for Projects (Class XI and XII)
(1) Preamble
(1.1) The academic course in Computer Science includes one Project in each year. The Purpose behind this is to consolidate the concepts and practices imparted during the course and to serve as a record of competence.
(1.2) A group of two/three students a steam may be allowed to work on one project.
(2) Project content
(2.1) Project for Class-XI can be selected from one of the topics given in event programming.
(2.2) Project for Class-XII should ensure the coverage of following areas of curriculum:
(a) Problem Solving
(b) Data Structure
(c) Programming in Python
(d) Data File Handling
Theme of the project can be
- Any subsystem of a System Software or Tool
- Any Scientific or a fairly complex algorithmic situation
- Business oriented problems like Banking, Library in formation system. Hotel or Hospital management system, Transport query system
- Quizzes/Games;
- Tutor/Computer Aided Learning Systems
(2.3) The aim of the project is to highlight the abilities of algorithmic formulation, modular programming, optimized code preparation, systematic documentation and other associated aspects of Software Development.
(2.4) The assessment would be through the project demonstration and the Project Report, which should portray Programming Style, Structured Design, Minimum Coupling, High Cohesion, Good documentation of the code to ensure readability and ease of maintenance.
Here on this page we have uploaded Computer Science subject syllabus 2024. You can download the complete syllabus from the link mentioned below: