Course Overview:

This Class 12 Computer Science course aims to provide students with a solid foundation in computer science principles, programming concepts, and practical skills. Through a combination of theory and practical sessions, students will learn about programming languages, data structures, algorithms, database management systems, and more. The course is designed to prepare students for further studies in computer science or related fields and to equip them with essential skills for the modern digital world.

Course Duration:

• Total Duration: 8 Weeks (typically 6-12 Weeks)
• Sessions: 2 sessions per week
• Session Duration: 2-3 hour per session

Unit 1 

• Revision of Python basics of Class 11
• Scope and usage of functions involving tuples, list, default and positional parameters, passing parameters, libraries, return values, etc.
• Types of files and handling.
• Basic operations are performed on text files like open, close, manipulate, read data and append into a text file along with absolute and relative paths.
• Basic operations performed on binary files open, close, read, search, write and use csv.reader() and csv.writerow() functions.
• Importing libraries using python
• Data structures like lists and stacks, including push and pop.

Unit 2 

• ARPANET and Internet about the evolution of networking.
• Terminologies used in data communication.
• Twisted pair cable, coaxial cable, optical fibre, microwave, radio, infrared, and satellite link used as transmission media.
• Introduction and types of network topologies.
• Network protocols, mobile telecommunication technologies and mobile processors.
• Protocols for video conferencing and chats.
• Concept of network security.
• Web services like WWW, HTML, XML, http, URL  and domain names.
• Websites, web hosting, web browser and web 8 servers.

Unit 3

• Concept of the database.
• Relational data model including the concept of domain, tuple, relation, attribute, degree and cardinality
• Types of keys (primary, foreign, candidate and alternate)
• Concept, advantage, data manipulation and definition language in Structured Query Language (SQL).
• Types of data (number, character, decimal, varchar, varchar 2 and date)
• Revision of SQL commands that were studied in class 11th.
• Equi-join and natural join.
• The interface of python with an SQL database.

Additional Components:

• Practical sessions to reinforce theoretical concepts
• Hands-on programming exercises and assignments
• Regular assessments (tests, quizzes) to evaluate understanding
• Guest lectures from industry experts to provide real-world insights
• Access to computer labs and online resources for further study

Prerequisites:

• Basic understanding of mathematics and logical reasoning
• Interest in computer science and programming
• Familiarity with using computers and basic software applications

Assessment:

• Regular quizzes, tests, and assignments to assess understanding of concepts
• Practical programming exams to evaluate coding skills
• Evaluation of project work and presentations

Instructor: Qualified and experienced computer science educator with expertise in teaching high school students will lead the sessions, providing guidance, support, and mentorship throughout the course.