Computer Science HSC Science Class 12 Tamil Nadu Board of Secondary Education Syllabus 2024-25

Type of Function

• Function Specification
• Parameters (and arguments)

1. Parameter without Type
2. Parameter with Type

•  Characteristics of interface

• Impure functions
• Side-effects (Impure functions)
• Chameleons of Chromeland problem using function

• List
• Tuple

• Local Scope
• Global Scope
• Global and local variables

• Output

• Local Scope
• Global Scope
• Enclosed Scope
• Built-in Scope

• Characteristics of Modules
• The benefits of using modular programming
• Access Control

• Characteristics of an Algorithm
• Writing an Algorithm
• Analysis of Algorithm

• Time Complexity
• Space Complexity

• Method for determining Efficiency 
• Space-Time tradeoff
• Asymptotic Notations
• Best, Worst, and Average ease Efficiency

• Introduction to searching 
• Linear search 
• Binary search

• Introduction to Sorting 
• Bubble Sorting 

• Steps to do Dynamic programming
• Fibonacci Series – An example
• Fibonacci Iterative Algorithm with Dynamic programming approach

• Interactive mode Programming

• Invoking Python IDLE

• Script mode Programming

1. Creating Scripts in Python
2. Saving Python Script
3. Executing Python Script

• The print() function
•  input() function

• Introduction of Tokens
• Literals
• Identifiers
• Assignment
• Operators
• Punctuators
• Separators
• Keywords

• Number Data type
• Boolean Data type
• String Data type

• Introduction
• Sequential Statement
• Alternative or Branching Statement
• Types of alternative or branching statements

1. Simple if statement
2. if..else statement
3. Nested if..elif...else statement

• Iteration or Looping constructs

1. while loop
2. for loop
3. Nested loop structure

•  Jump Statements in Python

1. break statement
2. continue statement
3. pass statement

• Types of Functions

1. User-defined Functions
2. Built-in Functions
3. Lambda FunctionsRecursion Functions
4. Recursion Functions

• Syntax for User defined function
• Advantages of User-defined Functions

• What is anonymous function?
• What is the use of lambda or anonymous function?
• Syntax of Anonymous Functions

• Syntax of return

• Local Scope
• Global Scope
• Global and local variables

• Built-in and Mathematical functions
• Composition in functions

• What is Composition in functions?

• Concatenation (+)
• Append (+ =)
• Repeating (*)
• String slicing
• Stride when slicing string

• Escape sequence in python
• Escape sequences supported by python

• Create a List in Python
• Accessing List elements

1. Accessing all elements of a list
2. Reverse Indexing

• List Length
• Accessing elements using for loop
• Changing list elements
• Adding more elements in a list
• Inserting elements in a list
• Deleting elements from a list
• List and range ( ) function

1. Creating a list with series of values

• List comprehensions
• Other important list funcion
• Programs using List

• Introduction to Tuples
• Creating Tuples

1. Creating tuples using tuple( ) function
2. Creating Single element tuple

• Accessing values in a Tuple
• Update and Delete Tuple
• Tuple Assignment
• Returning multiple values in Tuples
• Nested Tuples
• Programs using Tuples
• Accessing Elements in a Tuple
• Tuple is Immutable

• Creating a Set
• Creating Set using List or Tuple
• Set Operations
• Programs using Sets

• Creating a Dictionary
• Dictionary Comprehensions
• Accessing, Adding, Modifying and Deleting elements from a Dictionary
• Difference between List and Dictionary

• Global Object
• Local Object

• Data
• Information

• Types of Data Model

1. Hierarchical Model
2. Relational Model
3. Network Database Model
4. Entity Relationship Model
5. Object Model

• Types of DBMS Users

• One-to-One Relationship
• One-to-Many Relationship
• Many-to-One Relationship
• Many-to-Many Relationship

• What is Relational Algebra?

• Data Definition Language
• Data Manipulation Language
• Data Control Language
• Transactional Control Language
• Data Query Language 

• Introduction of Data Types 
• Primitive Data Types
• Non-Primitive Data Types

• DDL Commands
• Type of Constraints

1. Unique Constraint
2. Primary Key Constraint
3. Default Constraint
4. Check Constraint
5. Table Constraint 

• DML Commands

1.  INSERT command
2. Delete Commond
3. DML Commond 
4. Update Commond

• Some Additional DDL Commands

1. Alter Commands
2. Truncate command 
3. Drop Table command

• DQL COMMAND– SELECT command

1. DISTINCT Keyword
2. ALL Keyword
3. BETWEEN and NOT BETWEEN Keywords
4. IN Keyword
5. ORDER BY clause
6. WHERE clause
7. GROUP BY clause 
8. HAVING clause

• TCL commands

1. COMMIT command
2. ROLLBACK command
3. SAVEPOINT command

• Creating CSV Normal File
• Creating CSV File That contains Comma With Data 
• Creating CSV File That contains Double Quotes With Data
• Rules to be followed to format data in a CSV file

• Microsoft Excel to open a CSV file

• Read a CSV File Using Python

1. CSV file with default delimiter comma (,)
2. CSV files- data with Spaces at the beginning
3. CSV File-Data With Quotes
4. CSV files with Custom Delimiters

• Read a specific column In a File
• Read A CSV File And Store It In A List
• Read A CSV File And Store A Column Value In A List For Sorting
• Sorting A CSV File With A Specified Column
• Reading CSV File Into A Dictionary
• Reading CSV File With User Defined Delimiter Into A Dictionary

• Creating A New Normal CSV File
• Modifying An Existing File

1. Adding new row

• CSV Files With Quotes
• CSV Files With Custom Delimiters
• CSV File With A Line Terminator
• CSV File with quote characters
• Writing CSV File Into A Dictionary

1. Writing Dictionary Into CSV File With Custom Dialects

• Getting Data At Runtime And Writing It In a CSV File 

• Difference between Scripting and Programming Languages

• MinGW Interface
• Executing C++ Program through Python

• Module
• How to import modules in Python?

1. Python’s sys module
2. Python's OS Module
3. Python getopt module

•  C++ program to implement Multilevel Inheritance 

• Creating a Table
• Adding Records

• SELECT Query

1. Displaying all records using fetchall()
2. Displaying A record using fetchone()
3. Displaying all records using fetchone()
4. Displayingusing fetchmany()

• CLAUSES IN SQL

1. SQL DISTINCT CLAUSE
2. SQL WHERE CLAUSE
3. SQL Group By Clause
4. SQL ORDER BY Clause
5. SQL HAVING Clause

• COUNT() function
• AVG()
• SUM()
• MAX() AND MIN() FUNCTIONS