Python , A New Subject in CBSE Board 11th & 12th Standard
Change is the law of nature it becomes true in CBSE pattern also . As per the changing technologies Central Board of Secondary Board of Education changed the pattern for computers in 11th and 12th standard. Now students has to give exam on python instead of C/C++ etc.
Python is much more demand for future technologies like Data science, machine learning ,automation, Artificial intelligence etc. Keeping this CBSE board included this language in its syllabus .
IT experts are saying its good move to make the foundation of school students at initial level. It will also help to make their interest in programming. But as for the first time it has some challenges as well . So below we are trying to give some our point of view about new added subject.
How we see python language as compared to traditional language like c/c++ etc
a. Python is more easy to learn as compared to C , Java etc.
b. No License needed to use python as its is freeware.
c. Rich & dynamic library support is there .
d. Very less code as compared to other languages
To Learn Python easily Visit our website tutorial
https://www.sharptutorial.com/python-home/
Python syllabus for class 11.
1 Computer System and Organisation 10 Marks
2 Computational Thinking and Programming 35 Marks
3 Data Management-1 15 Marks
4 Society , Law and Ethics-1 10 Marks
Total Marks=70
1 Lab Test For Python Programs 8 Marks
2 Lab Test for SQL Queries 4 Marks
3 File Report (Minimum 20 Python Programs and 8 SQL queries) 7 Marks
4 Viva 3 Marks
5 Project Report 8 Marks
Total Marks=30
Total Marks (Theory+Practical) = 70+30 = 100
Detailed Syllabus on All Theory Units
Unit 1 -Basic Computer Organisation:
Description of a computer system and mobile system, CPU, memory, hard disk, I/O, battery.
• Types of software: application, System, utility.
• Memory Units: bit, byte, MB, GB, TB, and PB.
• Boolean logic: OR, AND, NAND, NOR, XOR, NOT, truth tables, De Morgan’s laws
• Information representation: numbers in base 2, 8, 16, binary addition
• Strings: ASCII, UTF8, UTF32, ISCII (Indian script code), Unicode
• Basic concepts of Flowchart
• Concept of Compiler & Interpreter
• Running a program: Notion of an operating system, how an operating system runs a program, idea of loading, operating system as a resource manager.
• Concept of cloud computing, cloud (public/private), introduction to parallel computing.
Unit 2 -Computational Thinking And Programming:
Basics of Computational Thinking: Decomposition, Pattern Recognition/ Data representation, Generalization/ Data Abstraction and algorithm.
Familiarization with the basics of Python programming: a simple “hello world” program, process ofwriting a program (Interactive & Script mode), running it, and print statements; simple data-types: integer, float, string
• Features of Python, Python Character Set, Token & Identifiers, Keywords, Literals, Delimiters, operators.
• Comments: (Single line & Multiline/Continuation statements), Clarit & Simplification of expression.
• Introduce the notion of a variable, and methods to manipulate it (concept of L- value and R-value evenif not taught explicitly).
• Knowledge of data types and operators: accepting input from the console, assignment statement,expressions, operators and their precedence.
• Operators & types: Binary operators-Arithmetic, Relational operators, Logical
Operators, Augmented Assignment operators.
• Conditional statements: if, if-else, if-elif-else; simple programs: e.g.: absolute value, sort 3 numbers,and divisibility.
• Notion of iterative computation and control flow: for(range(),len()), while, flowcharts, suggested programs: interest calculation and factorials, etc.
• Idea of debugging: errors and exceptions; debugging: pdb, break points.
• Lists, tuples and dictionary: finding the maximum, minimum, mean; linear search on list/tuple ofnumbers, and counting the frequency of elements in a list using a dictionary. Introduce the notion ofaccessing elements in a collection using numbers and names.
• Sorting algorithm: bubble and insertion sort;count the number of operations while sorting.
• Strings: Traversing, compare, concat, substring.
• Introduction to Python modules: Importing math (sqrt, cell, floor, pow, fabs, sin, cos, tan, random (random, randint, randrange), statistics (mean, median, mode) modules.
Unit 3 -Data Management
Relational databases: Concept of a database, relations, attributes and tuples, keys- candidate key, primary key, alternate key, foreign key;Degree and cardinality of a table.
• Use SQL – DDL/ DML commands to CREATE TABLE, INSERT INTO, UPDATE TABLE , DELETE FROM, ALTER TABLE,MODIFY TABLE, DROP TABLE, keys, and foreign keys; to view content of a table: SELECT-FROM- WHERE-ORDER BY alongwith BETWEEN, IN, LIKE, (Queries only on single table)
• Aggregate functions – MIN, MAX, AVG, COUNT, SUM
• Basics of NoSQL databases.
Unit 4 -Society, Law And Ethics (Cyber Safety):
Cyber safety: safely browsing the web, identity protection, confidentiality, social networks, cyber trollsand bullying
• Appropriate usage of social networks: spread of rumours, and common social networking sites (Twitter, LinkedIn, and Facebook) and specific usage rules.
• Safely accessing web sites: adware, malware, viruses, Trojans
• Safely communicating data: secure connections, eavesdropping, phishing and identity verification.
Python syllabus for class 12.
Theory Syllabus.
1 Programming and computational thinking 30 Marks
2 Computer networks 15 Marks
3 Data Management-2 15 Marks
4 Society , Law and Ethics-2 10 Marks
Total Marks=70
Practical Syllabus.
1 Lab Test For Python Programs 7 Marks
2 Lab Test for SQL Queries 3 Marks
3 File Report (Minimum 20 Python Programs and 8 SQL queries) 7 Marks
4 Viva on Report File 2 Marks
5 Project Report 8 Marks
4 Viva on Project Report 3 Marks
Total Marks=30
Total Marks (Theory+Practical) = 70+30 = 100
Detailed Syllabus on All Theory Units
Unit 1 –Programming and computational thinking:
Revision of the basics of Python Functions: scope, parameter passing, mutable/immutable properties of data objects, pass arrays to functions, return values, functions using libraries: mathematical, and string functions. File handling: open and close a file, read, write, and append to a file, standard input, output, and error streams, relative and absolute paths. Using Python libraries: create and import Python libraries Recursion: simple algorithms with recursion: factorial, Fibonacci numbers; recursion on arrays: binary search Idea of efficiency: performance defined as inversely proportional to the wall clock time, count the number of operations a piece of code is performing, and measure the time taken by a program. Example: take two different programs for the same problem, and understand how the efficient one takes less time. Data visualization using Pyplot: line chart, pie chart, and bar chart. Data-structures: lists, stacks, queues.
Unit 2 -Computer Networks
Structure of a network: Types of networks: local area and wide area (web and internet), new technologies such as cloud and IoT, public vs. private cloud, wired and wireless networks; concept of a client and server. Network devices such as a NIC, switch, hub, router, and access point. Network stack: amplitude and frequency modulation, collision in wireless networks, error checking, and the notion of a MAC address, main idea of routing. IP addresses: (v4 and v6), routing table, router, DNS, and web URLs, TCP: basic idea of retransmission, and rate modulation when there is congestion (analogy to a road network), Protocols: 2G, 3G, 4G, WiFi. What makes a protocol have a higher bandwidth? Basic network tools: traceroute, ping, ipconfig, nslookup, whois, speed-test. Application layer: HTTP (basic idea), working of email, secure communication: encryption and certificates (HTTPS), network applications: remote desktop, remote login, HTTP, FTP, SCP, SSH, POP/IMAP, SMTP, VoIP, NFC.
Unit 3 -Data Management II
Write a minimal Django based web application that parses a GET and POST request, and writes the fields to a file – flat file and CSV file. Interface Python with an SQL database SQL commands: aggregation functions – having, group by, order by.
Unit 4 -Society , Law and Ethics II
Intellectual property rights, plagiarism, digital rights management, and licensing (Creative Commons, GPL and Apache), open source, open data, privacy. Privacy laws, fraud; cyber-crime- phishing, illegal downloads, child pornography, scams; cyber forensics, IT Act, 2000. Technology and society: understanding of societal issues and cultural changes induced by technology. E-waste management: proper disposal of used electronic gadgets. Identity theft, unique ids, and biometrics. Gender and disability issues while teaching and using computers.