Units and Topics
# | Unit/Topic | Marks |
---|---|---|
100 | Introduction to Database Management | - |
200 | Networking and Open Standards | - |
300 | Web Page Development | - |
400 | Multimedia and Authoring Tools | - |
Total | - |
Syllabus
Data, Record/Tuple, Table, Database;
Candidate key, Primary key, Alternate key, and Foreign key;
Using any toolcreating and saving table, defining primary key, inserting and deleting column, renaming column, insert ng records, deleting records, modifying records, table relationships;
Evolution of Networking:ARPANET, WWW, Internet;
Bus, Star, Tree;
PAN, LAN, WAN, MAN;
Twisted pair cable, coaxial cable, optical fiber;
Bluetooth, infrared, radio link, microwave lnk, radio link and satellite link;
Hub, switch, repeater, gateway - and their functions;
Identifying computers and users rNer a network: Bas c concept of domain name, MAC (Media Access Control) and IP Address, domain name resolution;
GSM, CDMA, GPRS, Wll., 3G, 4G;
sms, voice mail, email,chat and video conferencing;
Cyberlaw, 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.]
Internet Information Server (IIS);
Concept of PHP, features of PHP, other equivalent tools - JSP, PHP Including PHPin web page;
integer, double, string,boolean, null,array, object, resources;
Using variables in PHP; Explicit and Implicit declaration of variables;
Using constants in PHP, constant() function:;
echo and print statements
- Arithmetic: +, - (Unary and Binary),* , I , %, **
- Assitnment Operators =, +=, - =, *=, /=.%=
- String Operator(concatenation) .,.=
- Comparison: <, >, <=, >=, !=, ==,===.!===
- Incrementing/Decrementi ng Operators:++, --
- Logical:AND, OR, !,&&, | |;
- Array Operators :union(+),equality =,identity ===,inequality <>,!=,nonidentity !===
- Operator precedence;
- String Manipulation Functions: strtoupper(), strtolower(), strlen(), ltrim(), substr(), rtrim(), trim(), strrev(), strcasecmp(), strcmp(), stripslashes()
- Time & Date Functions: Date(), getdate(), gettimeofday(), Mktime(), strtotime(), cal_days_in_month()
Declaration and use ofindexed arrays(1 dimensional); sort(),rsort() inbuilt functions;
if else,if ...elseif....else, switch
While, Do While , For, For each;
Uncondftfonal exft fromloop /swftch Break;
$GLOBALS, $_SERVER, $_REQUEST, $_POST, $_GET, $_FILES, $_ENV, $_COOKIE, $_SESSION
Passing parameters/arguments; Pass by value, pass by reference,return value,default value
Form Handling,Form Validation, Form URL/E-mail
Opening a file,Reading a file,Writing a file,Closing a file
PHP File Upload, Cookies, Sessions(start, modify and destroy), Error Handling
Connecting with Databases: opening and closing database
Inserting,retrieving,modifying/updation of records from tables in databases
AVI,MPEG, SWF, MOV, DAT;
Audio/Video on the web page;
Making of simple movie, setting properties, frame rate, dimensions, and background color;
Concept of frame, frame buffer, and frame rate, creating a key frame;
Inserting text into the frame, insert ng 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;
Concept of scene, duplicate scene, add scene, delete scene, and navigating between scenes;
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;
Motion Tweening, Shape Tweening, Inserting Sound Layer;
Testing a Scene and Movie;
Import/Export (Movie/Sound and other multimedia objects);
Publishing a movie, changing publ sh sett ngs, 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;
Education (use of CAL tool), entertainment, edutainment, virtual reality, digital libraries, information kiosks, video on demand,video phone, video conferencing and telemedicine.