Python in CBSE Board 11th & 12 Class

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.