Syllabus for class 11 - Computer Science(Practical)

Theory 70 Marks:

Practical 30 Marks:

Sl	Unit Name	Marks (Total 30 Marks)
1	Lab Test (12 marks)
	Python program (60% logic + 20% documentation + 20% code quality)	8
	SQL program (at least 4 queries)	4
2	Report File + viva (10 marks)
	Report file: Minimum 20 Python programs and 8 SQL commands	7
	Viva voce (based on the report file)	3
3	Project (that uses most of the concepts that have been learnt) (See CS-XII for the rules regarding the projects)	8

Possible Task for practical:

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.

• 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 xand n, compute x n .
• 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.

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.

• 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 (studentid, 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).

3. Project

                      The aim of the class project is to create something that is tangible and useful. This should be done in groups of 2 to 3 students, and should be started by students at least 6 months before the submission deadline. The aim here is to find a real world problem that is worthwhile to solve. Students are encouraged to visit local businesses and ask them about the problems that they are facing. For example, if a business is finding it hard to create invoices for filing GST claims, then students can do a project that takes the raw data (list of transactions), groups the transactions by category, accounts for the GST tax rates, and creates invoices in the appropriate format. Students can be extremely creative here. They can use a wide variety of Python libraries to create user friendly applications such as games, software for their school, software for their disabled fellow students, and mobile applications, Of course to do some of this projects, some additional learning is required; this should be encouraged. Students should know how to teach themselves.

If three people work on a project for 6 months, at least 500 lines of code is expected. The committee as also been made aware about the degree of plagiarism in such projects. Teachers should take a very strict look at this situation, and take very strict disciplinary action against students who are cheating on lab assignments, or projects, or using pirated software to do the same. Everything that is proposed can be achieved using absolutely free, and legitimate open source software.

Reference:
1. http://cbseacademic.nic.in/curriculum.html