Grade Level: Senior Secondary (Classes XI & XII)
Objective: The course is designed to impart knowledge of computer systems, data management, and networking concepts to help students apply these in real-world situations, develop problem-solving skills, and understand the fundamentals of data and information technology.
Key Topics:
Python Programming:
Basics of Python programming: variables, data types, operators, control structures (if-else, loops)
Functions, modules, libraries, and file handling
Data structures: lists, dictionaries, tuples
Data Handling:
Introduction to data handling using Python (NumPy, Pandas)
Data visualization techniques using libraries like Matplotlib
Importing and exporting data from CSV files
Database Management:
Relational database concepts: tables, rows, columns, keys
SQL commands: DDL, DML, DCL (SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP)
Handling database queries, relationships (one-to-one, one-to-many)
Networking:
Basics of computer networking, types of networks (LAN, WAN, MAN)
Introduction to the internet, cloud computing, and cyber security
Protocols, IP address, and the OSI model
Societal Impacts:
Ethical issues, digital footprints, and legal aspects of using technology
Responsible use of social media and data privacy
Assessment:
Practical programming assignments
Database creation and management tasks
Python-based projects and data visualization tasks
Written exams covering theoretical aspects
Computer Science - Teaching Description
Grade Level: Senior Secondary (Classes XI & XII)
Objective: The Computer Science curriculum aims to provide students with an in-depth understanding of computer systems, algorithms, data structures, and programming paradigms. It builds strong computational thinking and problem-solving skills.
Key Topics:
Python Programming:
Introduction to Python and advanced Python concepts
Object-oriented programming: classes, objects, inheritance, encapsulation
Exception handling and recursion
Data Structures and Algorithms:
Arrays, linked lists, stacks, queues, and trees
Searching (linear, binary) and sorting (bubble, selection, merge) algorithms
Algorithmic complexity (Big-O notation)
Database Management:
SQL concepts: CREATE, SELECT, INSERT, DELETE, UPDATE, JOIN
Normalization, database transactions, and keys
Using SQL queries to retrieve and manipulate data
Computational Thinking and Problem Solving:
Developing algorithms and flowcharts for problem-solving
Writing pseudocode and debugging Python programs
Recursion, backtracking, and dynamic programming
Computer Networks and Internet Technology:
Introduction to networking concepts, topologies, and protocols
Cybersecurity principles: encryption, firewall, malware, and hacking
Internet of Things (IoT) and emerging technologies
Programming Project:
Creation of a complete software solution using Python (or any other language prescribed)
Database connectivity, user interfaces, and file handling
Assessment:
Regular coding assignments and algorithm problems
Hands-on database management tasks
Projects demonstrating the application of software development principles
Unit tests and theory exams
These courses provide a foundation for students interested in pursuing higher education and careers in computer science, IT, data analysis, or related fields.