12th Computer Science - TamilNadu State Board (English Medium)

12th Computer Science - TamilNadu State Board (English Medium)

Computer Science 12th Std - 12th Computer Science

UNIT I: Problem Solving Techniques

Chapter 1: Function

1. Function: Introduction - Computer Science
2. Function with respect to Programming language - Computer Science
3. Interface Vs Implementation - Computer Science
4. Pure functions - Computer Science
5. Points to remember - Problem Solving Techniques : Function - Computer Science
6. Function: Book Back Questions and Answers - Computer Science

Chapter 2: Data Abstraction

1. Data Abstraction - Introduction
2. Abstract Data Types
3. constructors and selectors
4. Representation of Abstract datatype using Rational numbers
5. Lists, Tuples
6. Data Abstraction in Structure
7. Data Abstraction : Points to remember
8. Data Abstraction: Book Back Questions and Answers

Chapter 3: Scoping

1. Scoping
2. Variable Scope
3. LEGB rule
4. Types of Variable Scope
5. Module - Characteristics of Modules
6. Scoping: Points to remember
7. Scoping: Book Back Questions and Answers - Computer Science

Chapter 4: Algorithmic Strategies

1. Introduction to Algorithmic strategies
2. Complexity of an Algorithm
3. Efficiency of an algorithm
4. Algorithm for Searching Techniques
5. Sorting Techniques
6. Dynamic programming
7. Algorithmic Strategies: Points to remember
8. Algorithmic Strategies: Book Back Questions and Answers - Computer Science

UNIT II: Core Python

Chapter 5: Python Variables and Operators

1. Python Introduction
2. Key features of Python
3. Programming in Python
4. Input and Output Functions - Python
5. Comments in Python - Python
6. Indentation - Python
7. Tokens - Python
8. Python Data types - Python
9. Python Variables and Operators: Points to remember - Python
10. Python Variables and Operators: Book Back Questions and Answers - Python

Chapter 6: Control Structures

1. Introduction of Python Control Structures - Python
2. Python Control Structures - Python
3. Python Control Structures: Points to remember
4. Python Control Structures: Book Back Questions and Answers

Chapter 7: Python Functions

1. Python Functions
2. Types of Python Functions
3. Defining Functions in Python - Python
4. Calling a Function - Python
5. Passing Parameters in Functions - Python
6. Function Arguments - Python
7. Anonymous Functions - Python
8. The return Statement - Python
9. Scope of Variables - Python
10. Functions using libraries - Python
11. Python recursive functions - Python
12. Python Functions: Points to remember
13. Python Functions: Book Back Questions and Answers

Chapter 8: Strings and String Manipulation

1. Strings and String Manipulation - Introduction - Python
2. Creating Strings - Python
3. Accessing characters in a String - Python
4. Modifying and Deleting Strings - Python
5. String Operators - Python
6. String Formatting Operators - Python
7. Formatting characters - Python
8. The format( ) function - Python
9. Built-in String functions - Python
10. Membership Operators - Python
11. Programs using Strings - Python
12. Python Strings and String Manipulation: Points to remember - Python
13. Python Strings and String Manipulation: Book Back Questions and Answers - Python

UNIT III: Python Modularity and OOPS

Chapter 9: Lists, Tuples, Sets And Dictionary

1. Introduction to List - Python
2. Python Programs using List - Python
3. Introduction to Tuples - Python
4. Programs using Tuples - Python
5. Dictionaries - Python
6. Python Lists, Tuples, Sets And Dictionary: Points to remember
7. Python Lists, Tuples, Sets And Dictionary : Book Back Questions and Answers - Python

Chapter 10: Python Classes and Objects

1. Python Classes and Objects
2. Defining classes - Python
3. Creating Objects - Python
4. Accessing Class Members - Python
5. Class Methods - Python
6. Constructor and Destructor in Python
7. Public and Private Data Members - Python
8. Sample Python Programs to illustrate classes and objects
9. Points to remember - Python Classes and Objects
10. Python Classes and Objects: Book Back Questions and Answers - Python Classes and Objects

UNIT IV: Database concepts and MySql

Chapter 11: Database Concepts

1. Database Concepts
2. DataBase Management System (DBMS) - Characteristics, Components, Advantages of DBMS
3. Database Structure - Computer Science
4. Data Model - Types, DBMS Users
5. Difference between DBMS and RDBMS
6. Types of Relationships in a database - Database Concepts
7. Relational Algebra in DBMS - Database Concepts
8. Database Concepts: Points to remember - Computer Science : Database concepts and MySql
9. Database Concepts: Book Back Questions and Answers - Database concepts and MySql

Chapter 12: Structured Query Language(SQL)

1. Introduction to SQL(Structured Query Language)
2. Role of SQL in RDBMS
3. Processing Skills of SQL - Structured Query Language(SQL)
4. Creating Database - Structured Query Language(SQL)
5. Components of SQL - Structured Query Language(SQL)
6. Data Types - Structured Query Language(SQL)
7. SQL Commands and their Functions - Structured Query Language(SQL)
8. DDL Commands - Structured Query Language(SQL)
9. DML COMMANDS - Structured Query Language(SQL)
10. Some Additional DDL Commands - Structured Query Language(SQL)
11. DQL COMMAND- SELECT command - Structured Query Language(SQL)
12. TCL commands - Structured Query Language(SQL)
13. Points to remember: Structured Query Language(SQL) - Structured Query Language(SQL)
14. SQL: Book Back Questions and Answers - Structured Query Language(SQL)

Chapter 13: Python and CSV Files

1. Python and CSV Files
2. Difference between CSV and XLS file formats
3. Purpose of CSV File
4. Creating a CSV file using Notepad (or any text editor)
5. Create A CSV File Using Microsoft Excel
6. Read and write a CSV file Using Python
7. Writing Data Into Different Types in Csv Files
8. Points to remember - Python and CSV Files
9. Python and CSV Files: Book Back Questions and Answers

UNIT V: Integrating Python with MySql and C++

Chapter 14: Importing C++ Programs In Python

1. Importing C++ Programs In Python
2. Difference between Scripting and Programming Languages
3. Applications of Scripting Languages
4. Features of Python over C++
5. Importing C++ Files in Python
6. Python Program to import C++
7. Python program Executing C++ Program using control statement
8. How Python is handling the errors in C++
9. Python program Executing C++ Program Containing Arrays
10. Python program Executing C++ Program Containing Functions
11. Python program to Illustrate the inheritance of a Class
12. Points to remember - Importing C++ Programs In Python
13. Importing C++ Programs In Python: Book Back Questions and Answers

Chapter 15: Data Manipulation Through SQL

1. Data Manipulation Through SQL
2. SQLite
3. Creating a Database using SQLite
4. SQL Query Using Python
5. The SQL AND, OR and NOT Operators
6. Querying A Date Column
7. SQL Aggregate Functions - Data Manipulation Through SQL
8. Updating A Record - Data Manipulation Through SQL
9. Deletion Operation - Data Manipulation Through SQL
10. Data input by User - Data Manipulation Through SQL
11. Using Multiple Table for Querying - Data Manipulation Through SQL
12. Integrating Query With Csv File - Data Manipulation Through SQL
13. Table List - Data Manipulation Through SQL
14. Points to remember - Data Manipulation Through SQL
15. Data Manipulation Through SQL: Book Back Questions and Answers - Data Manipulation Through SQL

Chapter 16: Data Visualization Using Pyplot: Line Chart, Pie Chart and Bar Chart

1. Data Visualization Definition
2. Getting Started - Data Visualization Using Pyplot
3. Special Plot Types - Line Chart, Bar Chart, Pie Chart
4. Data Visualization Using Pyplot: Book Back Questions and Answers - Line Chart, Pie Chart and Bar Chart