About the Course 🎓

Join our Standard 12 Computer Science Course designed for CBSE students! This comprehensive program covers essential topics in programming, data structures, and database management, equipping students with practical skills and theoretical knowledge necessary for success in the digital age.

Syllabus Overview 📖

Units:

Unit I: Computational Thinking and Programming – 2 💻

• Revision of Python Topics Covered in Class XI: Review of previously learned Python concepts.
• Functions: Types of functions (built-in, user-defined), creating user-defined functions, arguments and parameters, flow of execution, and variable scope.
• Exception Handling: Introduction to exception handling using try-except-finally blocks.
• Introduction to Files: Types of files (Text, Binary, CSV), file paths.
• Text Files: Opening, closing, and manipulating text files using various modes and methods.
• Binary Files: Basic operations on binary files, using the pickle module for serialization.
• CSV Files: Working with CSV files using the csv module.
• Data Structures - Stacks: Introduction to stacks and their operations.

Unit II: Computer Networks 🌐

• Evolution of Networking: Historical evolution of computer networks (ARPANET, INTERNET).
• Data Communication Terminologies: Key concepts, components, and measuring communication media capacity.
• Transmission Media: Wired (Twisted pair, Co-axial, Fiber-optic) and Wireless media (Radio waves, Microwaves).
• Network Devices: Overview of devices like Modem, Router, Switch, etc.
• Network Topologies and Types: Types of networks (PAN, LAN, MAN, WAN) and topologies (Bus, Star, Tree).
• Network Protocols: HTTP, FTP, TCP/IP, and others.
• Introduction to Web Services: Basics of WWW, HTML, XML, domain names, and web hosting.

Unit III: Database Management 📊

• Database Concepts: Introduction to databases and their significance.
• Relational Data Model: Key concepts like relation, attribute, keys (primary, foreign).
• Structured Query Language (SQL): Introduction to SQL, DDL, DML, data types, constraints, and various SQL operations.
• Interface of Python with an SQL Database: Connecting Python with SQL databases and performing queries.

Assessment Structure 📝

• Theory Exam: Total of 70 marks distributed across the three units.
  • Unit I: 40 marks
  • Unit II: 10 marks
  • Unit III: 20 marks
• Practical Exam: Total of 30 marks based on Python programming and SQL queries.

Practical Syllabus 🛠️

1. Python Programming:

   • Read a text file and display each word.
   • Analyze a text file for character counts.
   • Create and manipulate binary files.
   • Implement a stack using a Python list.
   • Create and read CSV files.

2. Database Management:

   • Create a student table and perform various SQL commands.
   • Integrate SQL with Python.

Project Work Guidelines 📁

• Projects should address real-world problems and can be done in groups of 2-3 students.
• Encourage creativity and the use of Python libraries for applications.
• Emphasize the importance of originality and avoiding plagiarism.

Requirements ✅

• Basic understanding of computer operations and familiarity with programming concepts.
• A personal laptop or computer for practical sessions.

How to Apply 🖱️

To enroll in the course, please visit our website and fill out the application form. For any inquiries, feel free to contact us.

Fees and Funding 💰

The course fee starts from ₹ 6500/-. Financial assistance may be available for eligible students. Please inquire for more details.