Pages

Saturday, 12 May 2018

CBSE class 11 Computer Science New Syllabus 2018-19

Computer Science (New)CLASS-XI Code No. 083(Optional for the academic year 2018-19 and mandatory for the academic year 2019-20 onwards)

1. Prerequisites
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
1. Develop basic computational thinking. Learn how to reason with variables, state transitions,
conditionals, and iteration.
2. Understand the notion of data types, and higher order data structures such as lists, tuples,
and dictionaries.
3. Appreciate the notion of an algorithm, and understand its structure, including how algorithms
handle corner cases.
4. Develop a basic understanding of computer systems - architecture, OS, mobile and cloud
computing.
5. Learn basic SQL programming.
6. Learn all about cyber safety.3. Distribution of Marks

5.1. Programming in Python: At least the following Python concepts should be covered in the labsessions: expressions, conditionals, loops, list, dictionary, and strings. The following are somerepresentative 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 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 coveredduring the labs: create, insert, delete, select, and join. The following are some representativeassignments.

Create a student table with the student id, name, and marks as attributes where the student idis 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 (studentid, date of birth).

Create a new table (order ID, customer Name, and order Date) by joining two tables (orderID, customer ID, and order Date) and (customer ID, customer Name, contact Name, country).