Click below for Class 11 Computer Science worksheets, assignments, syllabus, ncert cbse books, ncert solutions, easy to learn concepts and study notes of all chapters
Please refer to the most updated syllabus for Class 11 Computer Science
No major prerequisites are required for this course other than basic Mathematical skills. However, it will be helpful if the student has a basic knowledge of Computer Applications.
2. Learning Outcomes
a) Develop basic computational thinking. Learn how to reason with variables, state transitions, conditionals, and iteration.
b) Understand the notion of data types, and higher order data structures such as lists, tuples, and dictionaries.
c) Appreciate the notion of an algorithm, and understand its structure, including how algorithms handle corner cases.
d) Develop a basic understanding of computer systems - architecture, OS, mobile and cloud computing.
e) Learn basic SQL programming.
f) Learn all about cyber safety.
3. Distribution of Marks
Programming and Computational Thinking - 1
Computer Systems and Organisation
Data Management - 1
Society, Law and Ethics - 1
4.1 Unit 1: Programming and Computational Thinking (PCT-1) (80 Theory + 70 Practical)
a) Familiarization with the basics of Python programming: a simple “hello world" program, process of writing a program, running it, and print statements; simple data-types: integer, float, string Introduce the notion of a variable, and methods to manipulate it (concept of L-value and R- value even if not taught explicitly)
b) Knowledge of data types and operators: accepting input from the console, assignment statement, expressions, operators and their precedence.
c) Conditional statements: if, if-else, if-elif-else; simple programs: e.g.: absolute value, sort 3 numbers, and divisibility.
d) Notion of iterative computation and control flow: for, while, flowcharts, decision trees and pseudo code; write a lot of programs: interest calculation, primarily testing, and factorials.
e) Idea of debugging: errors and exceptions; debugging: pdb, break points.
f) Lists, tuples and dictionary: finding the maximum, minimum, mean; linear search on list/tuple of numbers, and counting the frequency of elements in a list using a dictionary. Introduce the notion of accessing elements in a collection using numbers and names.
g) Sorting algorithm: bubble and insertion sort; count the number of operations while sorting.
h) Strings: compare, concat, substring; notion of states and transitions using state transition diagram
4.2. Unit 2: Computer Systems and Organisation (CSO) (20 Theory + 6 Practical)
a) Basic computer organisation: description of a computer system and mobile system, CPU, memory, hard disk, I/O, battery, power.
b) Types of software: application, OS, utility, libraries.
c) Language of Bits: bit, byte, MB, GB, TB, and PB.
d) Boolean logic: OR, AND, NAND, NOR, XOR, NOT, truth tables, De Morgan’s laws
e) Information representation: numbers in base 2, 8, 16, unsigned integers, binary addition
f) Strings: ASCII, UTF8, UTF32, ISCII (Indian script code)
g) Execution of a program: basic flow of compilation – program à binary à execution
h) Interpreters (process one line at a time), difference between a compiler and an interpreter
i) Running a program: Notion of an operating system, how an operating system runs a program, idea of loading, operating system as a resource manager.
j) Concept of cloud computers, cloud storage (public/private), and brief introduction to parallel computing.
4.3. Unit 3: Data Management (DM-1) (30 Theory+ 24 Practical)
a) Relational databases: idea of a database and the need for it, relations, keys, primary key, foreign key; use SQL commands to create a table, keys, foreign keys; insert/delete an entry, delete a table.
b) SQL commands: select, project, and join; indexes, and a lot of in-class practice.
c) Basics of NoSQL databases - Mongo DB.
4.4. Unit 4: Society, Law and Ethics (SLE-1) - Cyber safety (10 Theory)
a) Cyber safety: safely browsing the web, identity protection, confidentiality, social networks, cyber trolls and bullying
b) Appropriate usage of social networks: spread of rumours, and common social networking sites (Twitter, LinkedIn, and Facebook) and specific usage rules.
c) Safely accessing web sites: adware, malware, viruses, Trojans
d) Safely communicating data: secure connections, eavesdropping, phishing and identity verification.
Lab Test (12 marks)
Python program (60% logic + 20% documentation + 20% code quality)
SQL program (at least 4 queries)
Report File + viva (10 marks)
Report file: Minimum 20 Python programs and 8 SQL commands
Viva voce (based on the report file)
Project (that uses most of the concepts that have been learnt) (See CS-XII for the rules regarding the projects).
5.1. Programming in Python: At least the following Python concepts should be covered in the lab sessions: expressions, conditionals, loops, list, dictionary, and strings. The following are some representative lab assignments.
a) Find the largest and smallest numbers in a list.
b) Find the third largest number in a list.
c) Test for primarily.
d) Find whether a string is a palindrome or not.
e) Given two integers x and n, compute xn.
f) Compute the greatest common divisor and the least common multiple of two integers.
g) Test if a number is equal to the sum of the cubes of its digits. Find the smallest and largest such numbers.
5.2. Data Management: SQL Commands At least the following SQL commands should be covered during the labs: create, insert, delete, select, and join. The following are some representative assignments.
a) Create a student table with the student id, name, and marks as attributes where the student id is the primary key.
b) Insert the details of a new student in the above table.
c) Delete the details of a particular student in the above table.
d) Use the select command to get the details of the students with marks more than 80.
e) Create a new table (name, date of birth) by joining two tables (student id, name) and (student id, date of birth).
f) Create a new table (order ID, customer Name, and order Date) by joining two tables (order ID, customer ID, and order Date) and (customer ID, customer Name, contact Name, country).
Latest NCERT & CBSE News
Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning
Some of the schools in Noida have decided to shut for 3 Days because father of two students in Noida was traced to be infected with the contagious Coronavirus. The internal exams have also been cancelled in those schools after the virus alarm. A 45 year old male who is...
The CBSE board examinations will start from 15 February 2020. The CBSE Board issued admit cards, and all schools start distributing copies of the admit cards. All students should read their admit card details correctly. CBSE admit card details the examination centre,...
The Central Board of Secondary Education (CBSE) announced on Saturday, the 29th of February’2020 that the Board examinations for standard X and XII will be executed according to the decided schedule from 2nd March’2020 onwards. This announcement also includes the areas...
CBSE board exams are just around the corner. Students of CBSE class 10th and class 12th are preparing hard to appear in the CBSE board examination 2020, they are looking for last-minute tips and tricks to get good score in the board exam. However, during examination,...
CBSE has announced a significant change in the CBSE 10th and 12th mark sheet of the results to be given to the students. The CBSE board also decided to end the use of the words “failed” or “compartmental” given to students in the CBSE Board Report 2020 mark sheet....
The Central Board of Secondary Education (CBSE) released the Date sheet of Class 10 and Class 12th 2020 examination on the official website cbse.nic.in. The board examination of Class 12 will be conducted from 15 February to 30 March 2020, while the board examination...