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
Enter the password to open this PDF file:
File name:
-
File size:
-
Title:
-
Author:
-
Subject:
-
Keywords:
-
Creation Date:
-
Modification Date:
-
Creator:
-
PDF Producer:
-
PDF Version:
-
Page Count:
-
Preparing document for printing…
0%
Σχόλια 0
Συνδεθείτε για να κοινοποιήσετε σχόλιο