CBSE Class 12 Informatics Practices syllabus 2011

Informatics Practices

Class XII (Practical)

Problem Solving using Java 10 marks

Student will be given a problem to be solved using Java during practical Examination to be conducted at the end of the course

SQL Queries 5 marks

Student will be asked to write 5 queries based on one or two tables during practical Examination to be conducted at the end of the course

Practical Record File

A practical record file is required to be created during the entire academic session. It should be duly signed by the concerned teacher on regular basis and is to be produced at the time of Final Practical Examination for evaluation. It should include the following:

• Solution of at least 15 problems using Java based IDE 2 marks
• At least 25 SQL queries based on one and/or two tables 2 marks
• Solution of at least 2 simple problems incorporating Java Application & Database connectivity 1 marks

Project File (3+2) marks
Students in group of 2-3 are required to work collaboratively to develop a project using Programming and Database skills learnt during the course. The project should be an application with GUI front-end based on any one of the following domains - e-Governance, e-Business and e-Learning

Viva Voce (1+2+2) marks
Students will be asked oral questions during practical Examination to be conducted at the end of the course. The questions will be from the entire course covered in the academic session

References
Introduction to Computer System:
V. Rajaraman, Fundamentals of Computers, Prentice Hall India, 2006
Rustam Shroff, Computer systems and applications, Himalaya, Delhi, 2004

Introduction to Programming:
Herbert Schildt , Java : the complete reference, Tata MacGraw Hill, 2005
Geary David M, Graphic java Mastering the JFC, Addision Wesley, 2006

Relational Database Management System:
Lerry Ulman, MYSQL Database, Pearson Education, 2008
George Reese, Database programming with JDBC and Java, O’Reilly, 2004

Computer Networking:
William Stallings, Computer Networking with Internet Protocols and Technology, Prentice Hall India, 2008

Open Standard and Multi-Lingual Computing:
www.w3c.org
www.bhashaindia.com/Patrons/LanguageTech/InnovationCentre.aspx

IT Applications:
e- governance:
www.Informatics.nic.in
www.india.gov.in/govt/national_egov_plan.php

e-Business:
Eden Remme Watt, Don Denoncourt, Scott Lee, Rick Stevens, Bob Cancilla, Understanding ebusiness application integration, MC Press, 2008
www.itcportal.com
www.apdip.net/publications/iespprimers/eprimer-ecom.pdf
www.portal.unesco.org
www.comminit.com

e-Learning:
www.moodle.org
www.w3schools.com