CLASS 12 COMPUTER SCIENCE

TOPICS

UNIT - 1 Computational Thinking and programming 2

1.  Functions
2.  File Handling
3.  Text file (Absolute /Relative path) and pickle module
4.  Binary File (Absolute /Relative path) and pickle module
5.  CSV file (Read/Write/Open/Close File)
6.  Python Libraries 
7.  Data structure (List / Stack / Queue)
8. Interesting Example in Recursion (Removed from Syllabus 2020-21)
9. Python MODULES, PACKAGES, LIBRARIES & FRAMEWORK

UNIT-2 Computer Network

1. Evolution of Networking (ARPANET/Internet/Circuit and packet Switching)
2. Data communication technology
3. Transmission media (Twisted pair cable/coaxial cable/optical fibre)
4. Computer Network LAN, MAN, WAN
5. Network Devices (Modem/Connector/Router/Switch/Gateway)
6. Network Topologies 
7. Network Protocol 
8. Mobile Telecommunication
9. Network security concept
10. Web services (WWW/HTML/XML/HTTP)

UNIT 3 Database management

1. Database Concept
2. Relational database model/Relation/tuple/attributes
3. Database Keys (Primary key/Candidate key/Alternate key/Foreign key)
4. SQL/DDL/DML
5. SQL Aggregate functions (SUM(),AVG()/COUNT(),MAX(),MIN())
6. Group by, Having
7. Order by
8. SQL Joins (Equal Join/Natural Join)
9. Python-MySQL Connector (Download, install, and Use)