CBSE 12th Class Multimedia and Web Tech Syllabus 2018-19
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, MS-SQL Server, Sybase etc.
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
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
Arithmetic operators: +, – (Unary and Binary), *, /, %, **
Assignment operators : =,+=,- =,*=,/=.%=
String operator: . , . =
Comparison operators: <, >, <=, >=, !=, ==,===.!===
Logical operators: !,&&,||;
Array Operators: union(+),equality ==,inequality <>,!=
Built In Functions:
String Manipulation Functions: strtoupper(), strtolower(), strlen(), ltrim(), substr(), rtrim(), trim() ,strrev(), strcasecmp(),strcmp(),stripslashes(), strchr(), strpos(), stripos()
Time & Date Functions: Date(),getdate(),gettimeofday(),Mktime(),strtotime(),
Arrays: Declaration and use of indexed arrays(1 dimensional), inbuilt functions sort(),rsort()
Conditional statements: if, if else, if…elseif….else, switch
Loops: while, do while , for, for each
Unconditional exit from loop /switch using break
User Defined Functions: Defining a function, calling/invoking a function,
Passing parameters/arguments, Pass by value, pass by reference, return value, default value
Global Variables – Superglobals
Elements of $_SERVER : PHP_SELF, SERVER_NAME, HTTP_HOST, HTTP_USER_AGENT
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
Working on Database: (Using MySQLi Procedural API)Connecting with Databases, opening and closing databases, Inserting, retrieving, modifying/updation , deleting of records from tables
Unit 4: Multimedia and Authoring Tools
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 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 telemedicine.
Duration: 3 Hours—————————-Total Marks: 30
1. Hands on Experience————15
A website based on a particular topic has to be to be developed by each student using various commands covered in HTML and PHP with at least 4 web pages.
Web page should be designed with following features:
HTML basic tags (html/head/title/body/B/I/U/BR/HR)
Conditional and control statements
Form Handling, Form Validation, E-mail Validation
Image editing using Photo Shop /Corel draw/GIMP
Merging layers /Moving and copying layers
Use of multimedia authoring (like Macromedia Flash)
2. Practical File ————05
The practical file should be made on a domain specific area (with supported documents and printouts):
Make a simple web page containing almost all the tags of HTML and view that web page on the browser.
Develop a home page for income tax department (simple and textual) and store it in the directory used for web services on the web-server.
Enhance the home page by providing links to other sample pages (e.g. Income Tax Zone).
Income Tax Detail form for an individual, Income Tax Notification, Income Tax News etc.).
Embed Time and Date on the home page.
Further enhance the website by providing User Registration Page. Collect the user details and Display a new web page showing “Thanks For Registration”. Also write appropriate functions to validate form inputs.
Give a login facility to the user with anonymous name and maintain the session till the user logs out.
For user log in attempts, maintain a visitor count.
Change the login module of the web page and now connect it to the IncomeTax User database on the server. This is to be done to store the registration detail and facilitate login to the user.
The login page is to be made in a way that it should also provide facility to change password, if user forget password.
Store some of the created or edited sound files on the web-server and provide links to play it.
Change the appearance of the web page using pictures at appropriate places (e.g. logo of income tax department, photograph of income tax building etc.)
Visit websites (State Govt./Local language newspaper) and get 5 different printouts in local language.
(Note: Student can also improve the case study from class XI and enhance it further with database and multimedia support. Also they can create a website on a new topic).
3. Project based on case study————05
Case Studies are to be divided into following parts:
Case study Part 1 (collection, editing and creation of website resources):
Create an electronic movie with various pictures, audio clipping, movie clippings, and factual text related to school / organization
Embedding video and audio in web pages.
An introduction to interactive walk-through.
Embedding walk-through into web pages.
Case Study Part 2 (development of web content with resources):
Case studies covered in class XI with database support with Login, Online Registration, Booking and/or ordering facility.
Sample Case Study
(Note: Other similar type of case studies can also be used for the project work)
Mr. Verma is the CEO of copsisoft drinks (I) Ltd. His company is having a wide network of distributors for copsibranded soft drinks. With the increase in sales and distribution network, it is required to adopt a new technological intervention in the existing system. He wants that the company should have a global presence over the widely popular medium, called world wide web. Assume that you are appointed as the senior person of the development team. You are required to collect the company information and its current requirement. For your easiness we had collected the details of the company which are as follows:
The company Information:
Name of the Company: copsisoft drinks (I) Ltd.
Zone: East, West, North and South
Distributors: All over the world.
Mr. Verma said that the web site should be able to reflect company in terms of :
Product & Promotion Page
Distributor Login Page / Password Recovery Page
Distributor Specific Details Page
Registration Page for Distributor-ship
Company News and Flashes
Web site Introduction is to be made in movie making software.
A proper database is to be maintained for the distributor information.
For developing the above sites/movies collect the actual information from various sources.
Teachers can provide alternative case studies also of similar kind.
4. Viva Voce—–05
During the final practical examination, oral questions will be asked from the syllabus covered and the project developed by the student(s).