XII IP PRACTICAL SYLLABUS

Informatics Practices
Class XII -Practical (Code 065)

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 e-
business 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