CBSE syllabus for class 12 informatics practices 2014 -2015
Class XII (Theory)
Unit Topic Period Marks
Theory | Practical | Theory | Practical | ||
1 | NETWORKING AND OPEN STANDARDS | 20 | 4 | 10 | 2 |
2 | PROGRAMMING | 42 | 40 | 25 | 16 |
3 | RELATIONAL DATABASE MANAGEMENT SYSTEM | 42 | 36 | 30 | 8 |
4 | IT APPLICATION | 6 | 20 | 5 | 4 |
110 | 100 | 70 | 30 | ||
UNIT 1: NETWORKING AND OPEN STANDARDS
Computer Networking:
• Networking : a brief overview.
• Communication Media: Wired Technologies - Co-Axial,Ethernet Cable, Optical Fiber, Wireless
Technologies - Blue Tooth, Infrared, Microwave, Radio Link, Satelite Link.
• Network Devices : Hub, Switch,Repeater, Gatewayand their functions
• Types of Network: LAN, MAN, WAN, PAN
• Network Topologies: Star, Bus, Tree
• Network Protocols: HTTP, TCP/IP, PPP
• Identifying computers and users over a network:Basic concept of domain name, MAC (Media
Access Control), and IP Address, domain name resolution.
• Networking Security: denial of service, intrusion problems, snooping.
Open Source Concepts:
• Open SourceSoftware (OSS), commonFOSS/FLOSS examples (e.g.GNU/Linux, Firefox, OpenOffice, Java, Netbeans,MySQL), common open standards (WWW, HTML, XML, ODF, IP, TCP).
• IndianLanguage Computing: Character encoding, UNICODE, different types of fonts (open type vs true type, static vs dynamic),Entering Indian Language Text - Phonetic Inscript and key map based.
UNIT 2: PROGRAMMING Review of Class XI; Programming Fundamentals
(Refer to Appendix A for sample guidelines of GUI Programming, and Appendix B for Swing components, Methods &Properties)
Basic concept of Access specifier for classes, Members and methods
Basic concept of Inheritance.
Commonly used libraries: String class and methods: toString(), concat(), length(), toLowerCase(), to
UpperCase(), trim(),substring() Math class methods:pow(), round()
Accessing MySQL database using ODBC/JDBC to connect with database.
Web application development: URL, Web Server, Communicating with the web server, conceptof
Client and Server Side.
HTML based web pages covering basic tags - HTML, TITLE,BODY, H1..H6,Paragraph (P), Line
Break (BR), SectionSeparator (HR), FONT, TABLE, LIST (UL, OL), IMG, FORM; Creating and accessing static pages using HTML and introduction to XML
UNIT 3: RELATIONALDATABASE MANAGEMENT SYSTEM Review of RDBMS from Class XI
Database Fundamentals
Concept of Database Transaction, Committing and cancelling a Transaction using COMMIT and
ROLLBACK.
Grouping Records: GROUP BY, Group functions- MAX(), MIN(),AVG(), SUM(), COUNT();
using COUNT(*), DISTINCT clause with COUNT, Group Functionsand Null Values,
Displaying Data From Multiple Tables: Cartesian product, Union, concept of Foreign Key, Equi- Join
Creating a Table with PRIMARY KEY and NOT NULL constraints, ViewingConstraints, Viewing the Columns associated with constraints using DESC Command;
ALTER TABLE for deletinga column, modifyingdata type of a column, adding constraints, enabling constraints, and dropping constraints.
DROP Table for deleting a table;
UNIT 4: IT APPLICATIONS
Front-end Interface - Introduction; content and features; identifying and using appropriate component (Text Box, Radio Button, CheckBox, List etc. as learnt in Unit-2 (Programming) for data entry, validation and display;
Back-end Database - Introduction and its purpose; exploring the requirement of tables and their essential attributes;
Front-End and Database Connectivity - Introduction, requirement and benefits
Demonstration and development of appropriate Front-end interface and Back-end Database for e- Governance, e-Business and e-Learning applications
Impact of ICT on Society : Social and Economics benefits and Infomania.
Class XIIClassXII (Practical)
S.No. Description Marks
1 2 3 4 | Problem Solving using Java SQL Queries Practical Record • Simple Problems using IDE Java • SQL Queries • IT Applications Project Work | 10 4 6 4 | |||
5 Viva Voce 6Total 30
Evaluation of Practical Examination
1. Problem Solving using Java
Studentis required to solve programming problems based on all concepts covered in theory throughout the year and maintain a recordof these in the practical file.
Studentwill be given a problemto be solved using Java during final practical examination to be conductedat the end of the academic session.
2. SQL Queries
Studentswill be trying out SQL queries using MySQL throughout the year alongwith course coverage in theory.
Student will be asked to write 4 queriesbased on one or two tables during final practical examination to be conductedat the end of the academic session
3. Practical Record File
A practical record file is required to be created during the entire academic session. It should be duly signed by the concernedteacher on regular basis and is to be produced at the time of Final PracticalExamination for evaluation. It should include the following:
• At least 12 solutions of simple problemsand 2 IT applications usingIDE based Java
(refer to Appendix 'A' & 'B')
• At least 24 SQL queries based on one and/or two tables
• Solution of at least 2 simple problems incorporating Java Application & Database connectivity
4. Project File
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 in any one of the followingdomains: e-Governance, e-Business and e-Learning with GUI front- end and corresponding database at the back-end.
5. Viva Voce
Studentswill 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
CBSE Curriculum 2014
Appendix 'A'
Sample Guidelinesfor GUI Programming
1. Display a messageusing Label, TextBox,MessageDialog using simple GUI applications
2. Concatenate two text entries and display the result.
3. Perform a simplearithmetic operation (+,-,*,/) and display the result in MessageDialog or TextBox
4. Make simpledecision making (if statement) solution and display relevant message using GUI application (Example - Problemsrelated to Eligibility for a givenvalue of Age, "Profit" or "Loss" messages for givenvalues of Cost Price and Sale Price,Grade Display for given valuesof Marks of students etc.)
5. Createa GUI application to perform both arithmetic and logical operation together (Example - Total, Average and Grade calculation for given marks, Salary Calculation on different criteria)
6. Create a GUI application to perform an operation based on the criteria input by the user in a
CheckBox or a RadioButton.
(Example 1: Find the Discountof an item on the basis of Category of item [Electrical Appliance/ Electronic Gadget/Stationary specified using a Radiobutton] and its Cost [Below 1000/Above
1000/Equal to 1000 specified using a Radio button]).
(Example 2: Calculate the incentive of a Sales Personon the basis of his Sales Amount, Customer
Feedback, Count of Customer specified using CheckBox)
7. Create a GUI application to change the property of a swingelement based on the selection made by the user
(Example 1: To change the background or Foreground color of any of the Swing elements of the form based on the color selectedfrom a list)
(Example 2: To changethe foreground and background color of a label based on the values input/stored in a combo box)
8. Createa GUI application for repeatedly doing a task based on the user input. (Example: To display the multiplication table of a number input by the user)
9. Store the data (Admission No., Name, Date of Birth, Class and Section) of 10 studentsin a table (Table) and find total numberof students in each class and section.
Sample Guidelines for Connectivity Problems
10. Createa GUI application that counts and displays the number of records present in a database table.
11. Create a simpleGUI application that displays the records of a databasetable in a tabularformat
(using jTable) on the GUI form.
12. Create a simpleGUI application that displays the records of a databasetable in a tabularformat
(using jTable) on the GUI form based on a criteriainput by the user.
13. Createa simple GUI application to perform a calculation based on a value retrievedfrom database tableand a valueentered by the user in a GUI application.
Swing Components:
Appendix 'B'
Class Swing Control Methods Properties | jButton jButton1, jButton2, jButton3, ... (default) getText (), setText () Background, Enabled, Font, Foreground, Text, Label |
Class Swing Control Methods Properties | JLabel jLabel1, jLabel2, jLabel3, ... (default) getText (), setText () Background, Enabled, Font, Foreground, Text |
Class Swing Control Methods Properties | JTextField jTextField1, jTextField2, jTextField3, ... (default) getText (), isEditable (), isEnabled (), setText () Backgorund, Editable, Enabled, Font, Foreground, Text |
Class Swing Control Methods Properties | JRadioButton jRadioButtonl, jRadioButton2, jRadioButton3, .. (default) getText (), setText (), isSelected (), setSelected () Background, Button, Group, Enabled, Font, Foreground, Label, Selected, Text |
Class Swing Control Methods Properties | JCheckBox jCheckBox1, jCheckBox2, jCheckBox3, ... (default) getText (), setText (), isSelected (), setSelected () Button Group, Font, Foreground, Label, Selected, Text |
Class Swing Control Methods Properties | J Button Group J Button Group1, .................. (default) Add |
Class Swing Control Mehtods Properties | JComboBox jComboBox1, jComboBox2, jComboBox3, ... (default) getSelectedItem (), getSelectedIndex (), setModel () Background, ButtonGroup, Editable, Enabled, Font, Foreground, Model, SelectedIndex, SelectedItem, Text. |
Class Swing Control Methods Properties | JList jList1, jList2, jList3,... (default) getSelectedValue () Background, Enabeld, Font, Foreground, Model, SelectedIndex, SelectedItem, Selection Mode, Text |
Class Swing Contorl Methods Properties | JTable jTable1, jTable2, jTable3, ... (default) addRow (), getModel () model |
Class Methods | JOptionPane showMessageDialog (), showInputDialog (), showConfirmDialog () |
Class Methods | DefaultTableModel getRowCount (), removeRow (), addRow, () |
Commonly used Methods
Class | Methods |
Integer | parsoInt (), toDouble (), toString () |
String | concat (), length (), substring (), toDouble (), toLowerCase, (), toUpperCase (), trim () |
Double | parseDouble (), toString (), toInt () |
Math | pow (), round () |
Database Connectivity Mehtods
Class | Methods |
Connection | createStatement (), close () |
DriverManager | getConnection () |
Statement | executeQuery () |
ResultSet | next (), first (), last (), getString () |
Exception | getMessage () |
System | exit () |
Note: The visual properties of any of the elements and Data connectivity methods (the properties/ methods, which are not highlighted in the above tables) will not be tested in the Theory examination but may be used by the studentin the Practicals and Projects.
References
TEXTBOOKS:
1. INFORMATICS PRACTICES (CLASS XI), CBSE
2. INFORMATICS PRACTICES (CLASS XII), CBSE ReferenceBooks
Introduction to Computer System
1. Rajaraman, FUNDAMENTALS OF COMPUTERS 4th Edition, Prentice Hall of India.
2. Peter Norton, INTRODUCTION TO COMPUTER 4th Edition, Tata McGrawHill
Introduction to Programming
1. Heiko Böck, The Definitive Guide to the NetBeans Platform 6.5, Apress
Relational Database Management Systemand SQL
1. Lerry Ulman, MYSQL Database, Pearson Education, 2008
Computer Network
1. A.S. Tanenbaum,Computer Network 4th Edition, Prentice Hall of India P. Ltd.
2. WilliamsStalling, Data Communication and Networks 5th Edition, Prentice Hall of India P. Ltd.
Suggested Websites on e-Governance
• bhoomi.kar.nic.in
• aponline.gov.in
Suggested Websites on e-Business
Suggested Websites on e-Learning
• portal.unesco.org
Appendix 'C'
Tentative Inventors and their salient contributions in the field of Information Technology
Name | Contribution / Field of Contribution |
Alan Turing | Turing Machine |
Andrew S. Tanenbaum | Operating Systems, MINIX |
Bjarne Stroustrup | C++ |
Claude Shannon | Information Theory |
Dennis Ritchie | C (Programming Language), UNIX |
Edgar F. Codd | Formulated The Database Relational Model |
George Boole | Boolean Logic |
James Gusling | Jvl |
James Hendler | Semantic Web |
John Hopcroft | Compilers |
John von Neumann | Early Computers, Von Neumann Machine |
Leonard Kleinrock | ARPANET, Queueing Theory, Packet Switching, Hierarchical Routing |
Linus Torvalds | Linux Kernel, Git |
Peter Wegner | Object-Oriented Programming, Interaction (Computer Science) |
Raj Chandel | Hacking |
Raj Reddy | Artificial Intelligence, Robotics |
Richard Stallman | Gnu Project |
Robert E. Kahn | TCP/IP |
Sabir Bhatia | Hotmail |
Seymour Cray | Cray Research, Supercomputer |
Tim Berners-Lee | World Wide Web |
Vinod Dham | Pentium Processor, AMD K6 Processor |
Vinton Cerf | Internet, TCP/IP |
Appendix 'C'
Contribution by EminentComputer Scientists
S.No. | NameContribution / Field of Contribution |
John Backus | FORTRAN, Backus-Naur form |
Tim Berners-Lee | World Wide Web |
George Boole | Boolean logic |
Vinton Cerf | Internet, TCP/IP |
Seymour Cray | Cray Research, supercomputer |
Vinod Dham | Pentium processor, AMD K6 Processor |
Edsger Dijkstra (programming), | algorithms, Goto considered harmful, semaphore |
James Hendler | Semantic Web |
John Hopcroft | compilers |
Robert E. Kahn | TCP/IP |
Brian Kernighan | Unix, the 'k' in AWK |
Carl Kesselman | grid computing |
Leonard Kleinrock | ARPANET, queueing theory, packet switching, hierarchical routing |
Bjarne Stroustrup | C++ |
Gordon Moore | Moore's law |
John von Neumann | early computers, von Neumann machine |
Raj Reddy | AI |
Dennis Ritchie | C (programming language), UNIX |
Raj Chandel | Hacking |
Claude Shannon | information theory |
Richard Stallman | GNU Project |
Andrew S. Tanenbaum | Operating systems, MINIX |
Linus Torvalds | Linux kernel, Git |
Alan Turing | Turing Machine |
Jeffrey D. Ullman | compilers, databases, complexity theory |
Peter Wegner | object-oriented programming, interaction (computer science) |
Wiederhold | database management systems |
Sabir Bhatia | Hotmail |
Edgar F. Codd | formulated the database relational model |
Christopher J. Date | proponent of database relational model |
No comments:
Post a Comment