CBSE ExamCBSE SyllabusCBSE Class 12 Computer Science Syllabus 2023- 2024

CBSE Class 12 Computer Science Syllabus 2023- 2024

In the last year of school, Class 12, students face big challenges. This year sets the stage for college life where they get to study what they love. But before that exciting step, they need to work really hard and stay dedicated to do well in the Class 12 board exams.

    Fill Out the Form for Expert Academic Guidance!



    +91


    Live ClassesBooksTest SeriesSelf Learning




    Verify OTP Code (required)

    I agree to the terms and conditions and privacy policy.

    Computer Science is super important for these exams. To do great in this subject, students must completely understand the CBSE Class 12 Computer Science Syllabus. They’ve got to know all the topics in the CBSE Syllabus really well.

    Also Check: CBSE Class 12 Physical Education Syllabus

    CBSE Class 12 Computer Science Syllabus

    CBSE Class 12 Computer Science Syllabus 2023-24 – Unit-Wise

    Unit I: Computational Thinking and Programming – 2

    Topic Content
    Revision of Python topics covered in Class XI Review of previously learned Python concepts and topics from Class XI.
    Functions Types of functions (built-in functions, functions defined in a module, user-defined functions), creating user-defined functions, arguments and parameters, default parameters, positional parameters, functions returning values, flow of execution, scope of a variable (global scope, local scope).
    Exception Handling Introduction to exception handling, handling exceptions using try-except-finally blocks.
    Introduction to Files Types of files (Text file, Binary file, CSV file), relative and absolute paths.
    Text Files Opening and closing text files, text file open modes (r, r+, w, w+, a, a+), working with text files using write() and writelines(), reading from text files using read(), readline(), and readlines(), seek and tell methods, data manipulation in text files.
    Binary Files Basic operations on binary files, file open modes (rb, rb+, wb, wb+, ab, ab+), import pickle module, dump() and load() methods, read, write/create, search, append, and update operations in binary files.
    CSV Files Importing the csv module, opening and closing csv files, writing to csv files using writer(), writerow(), writerows(), reading from csv files using reader().
    Data Structures – Stacks Introduction to stacks, stack operations (push and pop), stack implementation using lists.

     

    Also Check: CBSE Class 12 Math Syllabus

    Unit II: Computer Networks

    Topic Content
    Evolution of Networking Introduction to computer networks, historical evolution (ARPANET, NSFNET, INTERNET).
    Data Communication Terminologies Communication concepts, components (sender, receiver, message, communication media, protocols), measuring communication media capacity (bandwidth, data transfer rate), IP address, switching techniques (Circuit switching, Packet switching).
    Transmission Media Wired communication media (Twisted pair cable, Co-axial cable, Fiber-optic cable), Wireless media (Radio waves, Microwaves, Infrared waves).
    Network Devices Overview of network devices (Modem, Ethernet card, RJ45, Repeater, Hub, Switch, Router, Gateway, WIFI card).
    Network Topologies and Types Types of networks (PAN, LAN, MAN, WAN), networking topologies (Bus, Star, Tree).
    Network Protocols HTTP, FTP, PPP, SMTP, TCP/IP, POP3, HTTPS, TELNET, VoIP.
    Introduction to Web Services WWW, Hyper Text Markup Language (HTML), Extensible Markup Language (XML), domain names, URL, website, web browser, web servers, web hosting.

    Unit III: Database Management

    Topic Content
    Database Concepts Introduction to database concepts and their significance.
    Relational Data Model Key concepts in the relational data model: relation, attribute, tuple, domain, degree, cardinality, keys (candidate key, primary key, alternate key, foreign key).
    Structured Query Language (SQL) Introduction to SQL, Data Definition Language (DDL) and Data Manipulation Language (DML), data types (char(n), varchar(n), int, float, date), constraints (not null, unique, primary key), database operations (create, use, show, drop), table operations (create, describe, alter, drop), data manipulation (insert, delete, select, update), operators, aliasing, distinct clause, where clause, in, between, order by, null, like, aggregate functions, group by, having, joins (cartesian product, equi-join, natural join).
    Interface of Python with an SQL Database Connecting Python with an SQL database, performing insert, update, delete queries using cursor, data retrieval using connect(), cursor(), execute(), commit(), fetchone(), fetchall(), rowcount, creating database connectivity applications, using format specifiers to perform queries.

    CBSE Class 12 Computer Science Practical Syllabus

    Students have the opportunity to review the complete syllabus for CBSE Class 12 Computer Science Practical below:

    Also Check: CBSE Class 12 Chemistry Syllabus

    1. Python Programming

    • Open a text file and read it line by line. For each line, show each word separated by a ‘#’. Count the vowels, consonants, uppercase, and lowercase letters in the file.
    • Remove any lines in the file that have the letter ‘a’ and save the updated content to a new file.
    • Make a file with student names and roll numbers. Look up a roll number and display the associated name.
    • Create a file containing roll numbers, names, and marks. Enter a roll number and update the marks.
    • Make a random number generator that works like a dice, producing numbers from 1 to 6.
    • Build a stack using a Python list.
    • Prepare a CSV file with user IDs and passwords. Read it and find passwords using the user ID.

    2. Database Management

    • Set up a table for students, add information, and try different commands in SQL like changing, updating, arranging, removing, and grouping data with functions that combine details.
    • Connect SQL with Python using a fitting tool.

    Also Check: CBSE Class 12 Physics Syllabus

    CBSE Class 12 Computer Science Syllabus with Marks Distribution

    The syllabus for CBSE Class 12 Computer Science Theory for the 2023-24 academic year is listed below. It shows how many marks each unit carries and how long each part lasts.

    Unit No. Unit Name Marks Periods
    Theory Practicals
    1. Computational Thinking and
    Programming – 2
    40 70 50
    2. Computer Networks 10 15
    3. Database Management 20 25 20
    Total 70 110 70

    Also Check: CBSE Class 12 Biology Syllabus

    CBSE Class 12 Computer Science Practical Syllabus 2023-24

    S.No. Unit Name Marks
    (Total=30)
    1. Lab Test
    Python program (60% logic + 20% documentation + 20% code quality) 8
    SQL queries (4 queries based on one or two tables) 4
    2. Report File
    Minimum 15 Python programs
    SQL Queries – Minimum 5 sets using one table / two tables.
    Minimum 4 programs based on Python – SQL connectivity.
    7
    3. Project (using concepts learnt in Classes 11 and 12) 8
    4. Vice Voce 3

    CBSE Class 12 Computer Science Syllabus FAQs

    What is the syllabus of English CBSE Class 12?

    The CBSE Class 12 English syllabus includes sections on reading comprehension, writing skills, literature, and grammar.

    What is the syllabus of Class 12 English 2023?

    The Class 12 English syllabus for 2023 remains similar to previous years, covering prose, poetry, grammar, and writing skills.

    How many chapters are there in English Class 12 CBSE?

    CBSE Class 12 English typically comprises chapters from novels, poems, essays, and supplementary reading materials, totaling around 10-12 chapters.

    How to prepare for Term 1 exam Class 12?

    Prepare for the Class 12 Term 1 exam by focusing on understanding key concepts, practicing sample papers, and revising thoroughly from prescribed textbooks.

    What are the topics for English Grammar Class 12?

    English Grammar for Class 12 covers topics like tenses, clauses, direct and indirect speech, active and passive voice, and sentence structures.

    Chat on WhatsApp Call Infinity Learn