CBSE Class 11th Computer science Syllabus 2018-19
(Optional for the academic year 2018-19 and mandatory for the academic year 2019-20 onwards)
CBSE Practical Syllabus
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.
Find the largest and smallest numbers in a list.
Find the third largest number in a list.
Test for primarily.
Find whether a string is a palindrome or not.
Given two integers x and n, compute xn.
Compute the greatest common divisor and the least common multiple of two integers.
Test if a number is
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.
Create a student table with the student id, name, and marks as attributes where the student id is the primary key.
Insert the details of a new student in the above table.
Delete the details of a particular student in the above table.
Use the select command to get the details of the students with marks more than 80.
Create a new table (name, date of birth) by joining two tables (student id, name) and (student id, date of birth).
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).