splitup-IP-2012.doc

Sp
l
it
-
up

S
yllabus for Informatics Practices

Class XII

Session 2012
-
13


Month

Content

Theory

Practical

April
2012

UNIT 1: NETWORKING AND OPEN STANDARDS

Computer Networking:

•
Networking:

a brief overview.

• Communication Media: Wired Technologies
-

Co
-
Axia
l,
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.

• Networking Security: denial of service, intrusion proble
ms,
snooping.

Open Source Concepts:

• Open Source Software (OSS), comon FOSS/FLOSS
examples (e.g. Gnu/Linux, Firefox,

OpenOffice, Java, netbeans, MySQL), common open
standards (WWW, HTML, XML, ODF,

IP, TCP).

• 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.

18

periods

6

periods

The
practical
classes
should be
engaged in
creating
GUI
applications
in Java
Swing

April
2012


May
2012




June
2012


July

2012

UNIT 2: PROGRAMMING

Review of Class XI:

Review of NetBeans IDE, RAD, Basic controls, their uses,
important events, properties and methods: jFrame, jLabel,
jTextField, jTextArea, jButton, jRadioButton, jCheckBox,
jComboBox
,

jListBox,

jTextArea, jTable, jOptionPane.


Monthly test I for class XII

(
Only one test suggested during April
-
May)


Programming Fundamentals: Tokens, Control structures (if
-
else,
switch
-
case, iteration), parse methods.

(
These are suggested and not
actua
lly mentioned in the syllabus in details
)


4
periods
of April


1
2

periods

of May


6
periods
of June

6
periods
of July

8

periods

The
practical
classes
should be
engaged in
practicing
conditional
statement
based
problems


July
2012












Programming
Fundamentals

(Refer to Appendix A for sample guidelines of GUI Programming,
and Appendix B for Swing Control

Methods & Properties)

Basic concept of Access specifier for classes, Members and
methods

Basic concept of Inheritance.

Commonly used libraries: Str
ing class and methods: toString(),
concat(), length(), toLowerCase(),

toUpperCase(), trim(), substring()

Math class methods: pow(), round()

Monthly test I
I

for class XII


18
periods












6
practical
periods














Aug
2012

Accessing MySQL data
base 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

Bre
ak (BR), Section Separator (HR), FONT, TABLE, LIST (UL,
OL), FORM;

Creating and accessing static pages using HTML and introduction
to XML

Distribution of Projects to students

Monthly test I
II

for class XII



25
periods


8
practical
periods



Sep
2012

UNIT

3: RELATIONAL DATABASE MANAGEMENT
SYSTEM

Review of RDBMS from Class XI:

Database concepts, SQL concepts, SQL queries:

DDL, DML, SELECT
queries using single table excluding GROUP BY clause and aggregate
functions, MySQL functions

Database Fundamentals

Conc
ept of Database Transaction, Committing and revoking a
Transaction using COMMIT and

REVOKE,

Monthly test IV

for class XII

2
3

periods

8
practical
periods




Oct
2012



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

Monthly test
V

for class XII

(May be half yearly)

17
periods







6
practical
period
s


Nov
2012

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 a column, ALTER TABLE for
modifying data types of a column

For addi
ng a constraint enabling constraints, dropping constraints.

Dropping 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 lear
nt 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 benef
its

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 and
Infomania.


Finalization

of
Project


Revision a
nd remedial classes

4

periods










4
periods















12
periods

6
practical
periods

Dec
2012

Comprehensive Revision and remedial classes

Submission of Project

Pre
-
Board 1

18
periods

6
practical

Jan
2013

Revision and remedial classes

Pre
-
Board I
I

25
periods

8
practical

Feb
201
3

AISSCE Practical Examination