Introduction to database concepts and its need;
Database Terminology:
Data, Record/Tuple, Table, Database;
Concept of Keys:
Candidate key, Primary key, Alternate key, and Foreign key ;
Database Tool:
Using any tool creating and saving table, defining primary key, inserting and deleting column, renaming
column, inserting records, deleting records, modifying records, table relationships;
Computer Networking:
Evolution of Networking: ARPANET, WWW, Internet;
Network Topologies:
Bus, Star, Tree;
Types of Network:
PAN, LAN, WAN, MAN;
Wired Technologies:
Twisted pair cable, coaxial cable, optical fiber;
Wireless Technologies:
Bluetooth, infrared, radio link, microwave link, radio link and satellite link;
Network devices:
Hub, switch, repeater, gateway - and their functions;
Identifying computers and users over a network: Basic concept of domain name, MAC (Media Access
Control) and IP Address, domain name resolution;
Wireless/Mobile Communication:
GSM, CDMA, GPRS, WLL, 3G, 4G;
Internet Applications:
sms, voice mail, email, chat and video conferencing;
Network Security Concepts:
Cyber law, firewall, cookies, hackers and crackers;
Open Source Concepts:
Proprietary and open source software (OSS), common FOSS/FLOSS examples (e.g. Gnu/Linux,
Firefox, OpenOffice, Linux, Mozilla web browser, Apache server, MySQL, Postgres, Pango, Tomcat,
PHP, Python);
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;
[Note: Teacher can introduce the students to these websites www.sourceforge.net, www.openrdf.org,
www.opensource.org, www.linux.com, www.linuxindia.net, www.gnu.org.]
Review of HTML/DHTML, VBScript covered in Class XI;
Installation and Managing WEB-Server:
Internet Information Server (IIS) / Personal Web Server (PWS);
Active Server Pages (ASP):
Concept of ASP, features of ASP, other equivalent tools - JSP, PHP;
Constants:
String and Numeric;
Data types:
Variant data type and its subtypes(integer, single, double, string, date, boolean, currency, variant,
object);
Variables:
Explicit and Implicit Declaration of variables;
Operators:
Arithmetic: +, - (Unary and Binary), *, /, \ (integer division) mod, ^;
Comparison: <, >, <=, >=, <>, =;
Logical: AND, OR, NOT;
String Operator: & or + (for Concatenation);
Operator precedence;
Functions:
Conversion functions: Abs(), CBool(), CByte(), CInt(), CStr(), CSng(), CLng(), CDate();
String Manipulation Functions: UCase(), LCase(), Len(), Left(), Right(), Mid(), LTrim(), InStr(), RTrim(),
Trim(), strreverse();
Time & Date Functions: Date(), Day(), Hour(), Minute(), Month(), Monthname(), Now();
Arrays:
Declaration and use of 1 dimensional arrays;
Controls:
If ..Then ..End if, If ..Then ..Else ..End If, If ..Then, Else If ..Then ..Else ..End If Select ..Case ..End Select;
For ..Next, For Each .. Next, Do While ..Loop, Do.. Loop While, Do Until.. Loop, Do..Loop Until;
Procedures and Functions:
Passing parameters/arguments;
Concept of object model structure:
(client to server and server to client);
ASP Objects:
Response, Request, Application, Session, Server, ASPError;
Properties, methods, events, setting object properties, retrieving object properties, calling objects/
methods;
Response Object:
Write, Add Header, Append To Log, Binary Write;
Using shortcuts <%=value/expr%>;
Controlling information: using Buffer, Flush Clear, End;
Request Object:
Request object collection: Query String, Form, Server Variables, Cookies, Client Certificate;
Server Variables:
HTTP_USER_AGENT, REMOTE_ADDR, REMOTE_HOST, SERVER_NAME;
Server Object:
Execute, transfer, createobject;
Application Object:
Contents, lock, unlock, remove, remove all;
Session Object:
Contents, remove, remove All, abandon;
ASP Components:
AD Rotator, Content Rotator, Counters, Page Counter, Permission Checker;
Text Files:
Open, Read and display content from a text file;
Working on Database:
Connecting with Databases: Creation of DSN, using OLE DB;
Inserting, retrieving, modifying/updation of records from tables in databases using server objects
(ADODB.Connection, ADODB.Recordset);
Movie File Formats:
AVI, MPEG, SWF, MOV, DAT;
Embedding:
Audio/Video on the web page;
Multimedia Authoring Using Macromedia Flash:
Making of simple movie, setting properties, frame rate, dimensions, and background color;
Movie Frames:
Concept of frame, frame buffer, and frame rate, creating a key frame; Inserting text into the frame,
inserting graphical elements into the frame, converting text/graphics to symbol, inserting symbol into
the frame, setting symbol property (graphics/button/movie), inserting blank key frame, selecting all/
specific frames of a layer, copying/pasting selected frames;
Scene:
Concept of scene, duplicate scene, add scene, delete scene, and navigating between scenes;
Layers:
Concept of layer, layer properties, layer name, show/hide/lock layers, viewing layer as outline,
adding/deleting a layer;
Types of Layer - normal/guide/mask;
Special Effects:
Motion Tweening, Shape Tweening, Inserting Sound Layer;
Testing a Scene and Movie;
Import/Export (Movie/Sound and other multimedia objects);
Publishing:
Publishing a movie, changing publish settings, producing swf(flash movie), html page, gif image, jpeg
image (*.jpg), png image, windows projector (*.exe), macintosh projector (*.hqx), quick time (*.mov),
real player (*.smil);
Testing with Publish Preview;
Multimedia Application:
Education (use of CAL tool), entertainment, edutainment, virtual reality, digital libraries, information
kiosks, video on demand, video phone, video conferencing and health care.