CBSE Class 12 Multimedia and Web Tech Syllabus

Learning Outcomes:

1 Ability to develop proficiency in Webpage Development and website management

2 Ability to develop proficiency in creating dynamic Web Interface

3 Ability to write server and client sides scripts and manage websites

4 Ability to design a web page using Image, Audio and Video editing tools

5 Ability to understand the basic concepts of Open Source Standards and Open Source softwares

6 Ability to understand the basic concepts of networking

Unit 1: Introduction to Database Management

Introduction to database concepts and its need

Database Terminology: Data, Record/Tuple, Table, Database, field/attribute

Concept of Keys: Candidate key, Primary key, Alternate key, and Foreign key

Examples of common Database Management System: MySQL, Ingres, Postgres, Oracle, DB2, MSSQL Server, Sybase etc.

Database Tool:

Introduction to MySQL: Using MySQL creating Database and table, defining primary key, inserting records, displaying records using SELECT command, WHERE clause, modifying records using UPDATE, deleting records

Unit 2: Networking And Open Standards

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: MODEM, 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, e-Mail, 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.]

Unit 3: Web Page Development

Review of HTML/DHTML, JavaScript covered in Class XI

Installation and Managing WEB-Server: IIS/XAMPP/LAMP;

PHP: Concept of PHP, features of PHP, other equivalent tools – JSP, PHP

Including PHP in web page

Data types: integer, double, string, boolean, null, array, object

Variables: Using variables in PHP

Constants: Using constants in PHP, constant() function

Output data to Screen: echo and print statements

Operators:

Arithmetic operators: +, - (Unary and Binary), *, /, %, **

Assignment operators : =,+=,- =,*=,/=.%=

String operator: . , . =

Comparison operators: <, >, <=, >=, !=, ==,===.!===

Incrementing/Decrementing operators:++,--

Logical operators: !,&&,||;

Array Operators: union(+),equality ==,inequality <>,!=

Operator precedence

Built In Functions:

String Manipulation Functions: strtoupper(), strtolower(), strlen(), ltrim(), substr(), rtrim(),

trim() ,strrev(), strcasecmp(),strcmp(),stripslashes(), strchr(), strpos(), stripos()