Multimedia and Web Technology Class 12 CBSE (Commerce) CBSE Topics and 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

1. Arithmetic: +, - (Unary and Binary),* , I , %, **
2. Assitnment Operators =, +=, - =, *=, /=.%=
3. String Operator(concatenation) .,.=
4. Comparison: <, >, <=, >=, !=, ==,===.!===
5. Incrementing/Decrementi ng Operators:++, --
6. Logical:AND, OR, !,&&, | |;
7. Array Operators :union(+),equality =,identity ===,inequality <>,!=,nonidentity !===
8. Operator precedence;

1. String Manipulation Functions: strtoupper(), strtolower(), strlen(), ltrim(), substr(), rtrim(), trim(), strrev(), strcasecmp(), strcmp(), stripslashes()
2. 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.