Your roadmap · आपका रोडमैप
- 1
Admission & first meetingप्रवेश और पहली मुलाकातEnquire at your nearest NDSS centre, meet the teacher, fix the batch time and get your study material.
- 2
Term 1 (April – September)प्रथम सत्र (अप्रैल – सितंबर)First half of every subject, with a unit test every month.
Python Revision TourFunctions in PythonException Handling in PythonFile Handling in PythonData Structure: Stack
- 3
Half-yearly examअर्धवार्षिक परीक्षाHalf-yearly test on the first-term chapters, with a report to parents.
- 4
Term 2 (October – January)द्वितीय सत्र (अक्टूबर – जनवरी)Second half of every subject, with unit tests.
Computer NetworksDatabase ConceptsStructured Query Language (SQL)Interface of Python with MySQL
- 5
Revision & mock testsरिवीजन और मॉक टेस्टFull-syllabus revision, sample papers and board-pattern mock tests.
- 6
Annual / board examवार्षिक / बोर्ड परीक्षाClass 12 annual / board exam.
- 7
Online tests & resultऑनलाइन टेस्ट और रिज़ल्टTake the tests online; your marks and result show in your student login and at the centre.
Syllabus · पाठ्यक्रम
1 subject · 9 chapters · 45 topics
01Python Revision Tour
5 topics+
- Tokens, data types and operators
- Conditional and looping statements
- Strings and string slicing
- Lists, tuples and dictionaries
- Mutable and immutable types
02Functions in Python
5 topics+
- Types of functions
- Defining and calling functions
- Positional, default and keyword arguments
- Returning values
- Scope of variables: local and global
03Exception Handling in Python
5 topics+
- Syntax errors and exceptions
- Built-in exceptions
- try and except blocks
- else and finally clauses
- Raising exceptions
04File Handling in Python
5 topics+
- Text files: open modes, read and write methods
- seek() and tell()
- Binary files with pickle: dump and load
- Searching, appending and updating records
- CSV files with csv.writer and csv.reader
05Data Structure: Stack
4 topics+
- Concept of a stack (LIFO)
- Push and pop operations
- Implementation using a Python list
- Applications of stack
06Computer Networks
6 topics+
- Evolution of networking
- Data communication terms and transmission media
- Network devices: modem, hub, switch, router, gateway
- Network types and topologies
- Protocols: HTTP, FTP, SMTP, PPP, TCP/IP
- Introduction to web services
07Database Concepts
4 topics+
- Need for a database
- Relational data model: relation, attribute, tuple, domain
- Degree and cardinality
- Keys: candidate, primary, alternate, foreign
08Structured Query Language (SQL)
6 topics+
- DDL and DML commands
- Data types and constraints
- SELECT with WHERE, ORDER BY, DISTINCT, LIKE, BETWEEN, IN
- Aggregate functions and GROUP BY, HAVING
- ALTER, UPDATE and DELETE
- Cartesian product, equi-join and natural join
09Interface of Python with MySQL
5 topics+
- Connecting with mysql.connector
- Creating a cursor and executing queries
- fetchone(), fetchall() and rowcount
- Inserting and updating with commit()
- Using format strings and parameters in queries
About this course
You will be able to
- Write Python programs using strings, lists, tuples, dictionaries and user-defined functions
- Handle exceptions with try, except, else and finally
- Read and write text, binary (pickle) and CSV files in Python
- Implement a stack using a Python list with push and pop operations
- Explain network types, topologies, devices, protocols and web basics
- Design relational tables and write SQL queries with joins, GROUP BY and aggregate functions
- Connect Python to MySQL to insert, update and fetch records
Who it is for
- Class 12 students of CBSE (Computer Science 083) and UP Board
- Students who need help with Python programs and SQL queries
- Students planning B.Tech / BCA after Class 12
What you need
- Class 11 Computer Science (Python basics) is recommended
- A computer with Python 3 and MySQL installed for practice
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
Questions
Which syllabus is followed?
The current CBSE Computer Science (083) syllabus with Python and MySQL; UP Board students are taught the matching topics of their syllabus.
Will I get lab practice?
Yes. Python programs, file handling, stack and SQL queries are practised on computers at the centre.
Is the practical file and project guided?
Yes. Students get help with the practical file programs, the Python-MySQL project and the viva.
How often are tests held?
A test after each chapter, monthly cumulative tests and board-pattern mock papers.
