CLASS XII-IP- (2014-15) (THEORY)-SYLLABUS
COURSE DESIGN
CLASS XII-IP- (2014-15) (THEORY)
Unit Topic Period Total Periods
Theory
Practical
1.
Networking and Open Standards 20 4 24
2.
Programming 46 44 90
3.
Relational Database Management System 50 40 90
4. IT
Applications 10 26 36
Unit 1: Networking and Open Standards
10 Marks (20 Theory+4 Practical) Periods
Computer Networking:
Networking: a
brief overview;
Communication
Media: Wired Technologies - Co-Axial, Ethernet Cable, Optical Fiber; Wireless
Technologies
- Blue Tooth, Infrared, Microwave, Radio Link, Satellite Link;
Network Devices:
Hub, Switch, Repeater, Gateway - and 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;
Network security:
denial of service, intrusion problems, snooping;
Internet
Applications: SMS, Voice Mail, Electronic Mail, Chat, Video Conferencing;
Wireless/Mobile
Communication: GSM, CDMA, WLL, 3G, 4G;
Network Security
Concepts: Cyber Law, Firewall, Cookies, Hackers and Crackers.
Open Source Concepts:
Open Source
Software (OSS), common FOSS/FLOSS examples (e.g., GNU/Linux, Firefox,
OpenOffice,
Java, Netbeans, MySQL), common open standards (WWW, HTML, XML,
ODF, TCP,
IP).
Indian Language
Computing: character encoding, UNICODE, different types of fonts (open
type vs
true type, static vs dynamic), Entering Indian Language Text - phonetic and key
map
based.
Unit 2: Programming 25 Marks (46
Theory+44 Practical) Periods
Review of Class XI;
Programming Fundamentals
(Refer to
Appendix A for Swing Control Methods & Properties, and Appendix B for
sample guidelines
of GUI Programming)
Basic
concept of Access specifier for class members (data members and methods).
Basic concept of
Inheritance.
Commonly used
libraries:
- String
class and methods: toString(), concat(), length(), toLowerCase(),
toUpperCase(),
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,
concept of
Client and Server Side.
HTML based web
pages covering basic tags - HTML, TITLE, BODY, H1..H6, Paragraph
(P), Line
Break (BR), Section Separator (HR), FONT, TABLE, LIST (UL, OL), FORM.
Creating
and accessing static pages using HTML and introduction to XML.
Unit 3: Relational Database Management
System
30 Marks (50 Theory+40 Practical)
Periods
Review of RDBMS from Class XI
Database Fundamentals
Concept of
Database Transaction, Committing and revoking a Transaction using COMMIT
and
ROLLBACK.
Grouping Records:
GROUP BY, Group functions - MAX(), MIN(), AVG(), SUM(),
COUNT();
using COUNT(*), DISTINCT clause with COUNT; Group Functions and
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,Viewing Constraints,
Viewing
the Columns Associated with Constraints using DESC command.
ALTER TABLE for
- deleting
column(s), modifying data type(s) of column(s),
- adding a
constraint, enabling constraints, dropping constraints.
DROP Table for
deleting a table
Unit 4: IT Applications 05 Marks (10
Theory+26 Practical) Periods
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
its
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 Economic benefits.
In each of
the above domains, identify at least two real-life problems, list the expected
outputs and the
input(s)
required for the output, and describe the problem solving approach and develop
relevant
front-end
interface and back-end database.
COURSE DESIGN
CLASS–XII: (PRACTICAL) (2014 – 15)
S.No Description Marks
1 Problem
SQL queries 4
3
Practical Records: 5
Simple problems
using IDE Java
SQL Queries
IT Applications
4. Project
Work 5
5 Viva
Voce 6
Total: 30
Evaluation of Practical Examination
1. Problem Solving using Java
Student is
required to solve programming problems based on all concepts covered in theory
throughout the
year and
maintain a record of these in the practical file.
Student
will be given a problem to be solved using Java during final practical
examination to be conducted
at the end
of the academic session.
2. SQL Queries
Students
will be practicing SQL queries in MySQL throughout the year alongwith course
coverage in
theory.
Student
will be asked to write 4 queries based on one or two tables during final
practical examination to be
conducted
at 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
concerned teacher on regular basis and is to be produced at the time of Final
Practical Examination
for
evaluation. It should include the following:
At least 12
solutions of simple problems using IDE based Java (refer to Appendices 'A'
& 'B').
Solution of at
least 2 simple problems incorporating Java Application & Database
connectivity.
At least 24 SQL
queries based on one and/or two tables .
At least two web
pages using HTML.
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 domains - e-
Governance,
e-Business and e-Learning - with GUI front-end and corresponding database at
the back-end.
5. Viva Voce
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.
APPENDIX 'A'
Swing Control Methods & Properties
Class: Jbutton
Swing Control: jButton
Methods: getText(), setText()
Properties: Background,
Enabled, Font, Foreground, Text, Label
Class: Jlabel
Swing Control: jLabel
Methods: getText(), setText()
Properties: Background,
Enabled, Font, Foreground, Text
Class: JtextField
Swing Control: jTextField
Methods: getText(), isEditable(),
isEnabled(), setText()
Properties: Background,
Editable, Enabled, Font, Foreground, Text
Class: Jradio Button
Swing Control: jRadio Button
Methods: getText(), setText(),
isSelected(), setSelected()
Properties: Background,
Button Group, Enabled, Font, Foreground, Label, Selected, Text
Class: JcheckBox
Swing Control: jCheckBox
Methods: getText(), setText(),
isSelected(), setSelected()
Properties: Button Group,
Font, Foreground, Label, Selected, Text
Class: Button Group
Swing Control: jButtonGroup
Methods:
Properties: Add
Class: JcomboBox
Swing Control: jComboBox
Methods: getSelectedItem(),
getSelectedIndex(), setModel()
Properties: Background,
ButtonGroup, Editable, Enabled, Font, Foreground, Model, SelectedIndex,
SelectedItem,
Text
Class: Jlist
Swing Control: jList
Methods: getSelectedValue()
Properties: Background,
Buttom Group, Editable, Enabled, Font, Foreground, Model, Selected Index,
Selected
Item, Text
Class: Jtable
Swing Control: jTable
Methods: addRow(), getModel()
……………………………………………………………………………………………………………………………..
APPENDIX 'B'
Sample Guidelines for GUI Programming
1. To
display a message using Label, TextBox, MessageDialog using simple GUI
applications.
2. To
concatenate two text entries and display using simple GUI application.
3. To
perform a simple arithmetic operation (+,-,*,/) and display the result in
MessageDialog or TextBox
using
simple GUI application.
4. To
perform simple arithmetic operation (+,-,*,/) and display the result in TextBox
using simple GUI
application.
5. To make
simple decision making (if statement) solution and display relevant message
using GUI application
(Example -
Problems related to Eligibility for a given value of Age, "Profit" or
"Loss" messages for given
values of
Cost Price and Sale Price, Grade Display for given values of Marks of students,
etc.).
6. To
create a simple GUI application to perform both arithmetic and logical
operation together (Example -
Total,
Average and Grade calculation for given marks, Salary Calculation on different
criteria).
7. To
create a simple GUI application to perform an operation based on the criteria
input by the user in a
CheckBox
or a Radio Button.
(Example 1: Find the Discount
of an item on the basis of Category of item [Electrical Appliance/Electronic
Gadget/Stationary
specified using a Radio button] and its Cost [Below 1000/Above 1000/Equal to
1000 specified
using a
Radio buttoM
