Welcome to Computers for School.
A Website for 11th and 12th Computer science Subject,Based on CBSE Syllabus and CBSE Recommended practicals.
Initially we are presenting practicals for both the classes, these are CBSE recommended practicals in Syllabus. we are also planning to add Project ideas for students.
Suggested Practicals for XIth Class
Marks (Total=30)
1. Lab Test (12 marks) Python program (60% logic + 20% documentation + 20% code quality) 12
2. Report File + Viva (10 marks) Report file: Minimum 20 Python programs 7 + Viva voce 3
3. Project (that uses most of the concepts that have been learnt) 8
Suggested Practical List Python Programming
● Input a welcome message and display it.
● Input two numbers and display the larger / smaller number.
● Input three numbers and display the largest / smallest number.
● Determine whether a number is a perfect number, an Armstrong number or a palindrome.
● Input a number and check if the number is a prime or composite number.
● Display the terms of a Fibonacci series.
● Compute the greatest common divisor and least common multiple of two integers.
● Count and display the number of vowels, consonants, uppercase, lowercase characters in string.
● Input a string and determine whether it is a palindrome or not; convert the case of characters in a string.
● Find the largest/smallest number in a list/tuple
● Input a list of numbers and swap elements at the even location with the elements at the odd location.
● Input a list/tuple of elements, search for a given element in the list/tuple.
● Create a dictionary with the roll number, name and marks of n students in a class and display the names of students who have marks above 75.
12th Cass Practical
Suggested Practical List: Python Programming
● Read a text file line by line and display each word separated by a #.
● Read a text file and display the number of vowels/consonants/uppercase/lowercase characters in the file.
● Remove all the lines that contain the character 'a' in a file and write it to another file.
● Create a binary file with name and roll number. Search for a given roll number and display the name, if not found display appropriate message.
● Create a binary file with roll number, name and marks. Input a roll number and update the marks.
● Write a random number generator that generates random numbers between 1 and 6 (simulates a dice).
● Write a Python program to implement a stack using list.
● Create a CSV file by entering user-id and password, read and search the password for given userid.
Database Management
● Create a student table and insert data. Implement the following SQL commands on the student table:
o ALTER table to add new attributes / modify data type / drop attribute
o UPDATE table to modify data
o ORDER By to display data in ascending / descending order
o DELETE to remove tuple(s)
o GROUP BY and find the min, max, sum, count and average
● Similar exercise may be framed for other cases.
● Integrate SQL with Python by importing suitable module.