Web Technologies and Multimedia

Microsoft Word: To familiarize with parts of Word, to create and save a document, to set page settings, create headers and footers, to edit a document and resave it, to use copy, cut and paste features, to use various formatting features such as bold face, italicize, underline, subscript, superscript, line spacing, etc. To use spelling and grammar checking feature, to preview print a document. To create a table with specified rows and columns, to enter data in a table, to select a table, a row, a column or a cell, to inset new row and/or a column, to delete a row and/or a column, to split and merge a row, column or a cell. To understand the mail-merge and to use mail merge feature of MS-Word.

Microsoft Excel: To familiarize with parts of Excel window, to create and save a workbook with single and/or multiple worksheets, to edit and format text as well numbers, to apply operations on range of cells using built-in formulae, to preview and print a worksheet, to insert new row and/or column in a worksheet, to delete a row and/or column in a worksheet, to create a variety of charts, to import and export data to or from worksheet.

Microsoft PowerPoint: To familiarize with parts of PowerPoint, to create and save a new presentation, to apply design templates to a presentation, to insert, edit and delete a slide, to use different views of slides, to use slide show from beginning or from the current slide, to preview and print a presentation, to check spellings in a presentation, to add clip art and pictures in a slide, to add chart, diagram and table in a slide, to set animation for a selected slide and/or for entire presentation, to create slide master and title master, to create a custom show.

Task 1: Used of CREATE, ALTER, RENAME, DROP, INSERT INTO, DELETE and UPDATE statement in the database tables (relations)

Task 2: Use of simple select statement, select query on two relations, nesting of queries, aggregate functions, substring comparison & order by statement

Task 3: Write a PL/SQL code to add two numbers and display the result. Read the numbers during run time.

Task 4: Write a PL/SQL code to find sum of first 10 natural numbers using while and for loop.

Task 5: Write a program to create a trigger which will convert the name of a student to upper case before inserting or updating the name column of student table.

Task 6: Write a PL/SQL block to increase the salary of all doctors by 1000.

Task 7: Write a PL/SQL code to multiply two numbers using procedure inside the block.

Task 8: Design database for Student Management System for your college using E-R model and Normalization.

Task 9: Design and Develop Conceptual Data Model (E-R Diagram) for Library Management System with all the necessary entities, attributes, constraints and relationships. Design and build Relational Data Model for application specifying all possible constraints.

Task 1: Write a program to perform following operations on two numbers input by the user: Addition 2) subtraction 3) multiplication 4) division

Task 2: Write a Java program to print result of the following operations. 1. -15 +58 * 45 2. (35+8) % 6 3. 24 + -5*3 / 7 4. 15 + 18 / 3 * 2 - 9 % 3

Task 3: Write a Java program to compute area of: Circle, rectangle, triangle & square.

Task 4: Write a Java program to convert temperature from Fahrenheit to Celsius degree.

Task 5: Write a program through Java that reads a number in inches, converts it to meters.

Task 6: Write a program to convert minutes into a number of years and days.

Task 7: Write a Java program that prints current time in GMT.

Task 8: Design a program in Java to solve quadratic equations using if, if else

Task 9: Write a Java program to determine greatest number of three numbers.

Task 10: Write a program to sum values of an Single Dimensional array.

Task 11: Calculate the average value of array elements through Java Program.

Task 12: Write a Java program to test if an array contains a specific value.

Task 13: Write a Java program to remove a specific element from an array.

Task 14: Design a program to copy an array by iterating the array.

Task 15: Write a Java program to insert an element (on a specific position) into Multidimensional array.

Task 16: Write a program to perform following operations on strings:
Compare two strings, Count string length, Convert upper case to lower case & vice versa, Concatenate two strings & Print a substring.

Task 17: Compute the average of three numbers through a Java Program.

Task 18: Write a Program & design a method to count all vowels in a string.

Task 19: Write a Java method to count all words in a string.

Task 20: Write a method in Java program to count all words in a string.

Task 21: To represent the concept of all types of inheritance supported by Java, design a program.

Task 22: Write a program to implement Multiple Inheritance using interface.

Task 23: Construct a program to design a package in Java.

Task 24: To write and read a plain text file, write a Java program.

Task 25: Write a Java program to append text to an existing file.

Task 26: Design a program in Java to get a list of all file/directory names from the given.

Task 27: Write a Java program to check if a file or directory has read and write permission.

Task 28: Write a Java program to check if a file or directory has read and write permission

Detailed contents

Contact hours

Unit-I:
Introduction to PHP: Basic Syntax, Integrating PHP with HTML, Defining variable and constant, PHP Data type.
Operators & Expressions: Arithmetic, Assignment, Comparison, Logical Operators, Concatenation, Bitwise, Error Suppression, Increment & Decrement operators, Ternary operator.
Working with Flow Control through Control Statement: If statement, If–else statement, If–else ladder statement, If–else statement, Switch statement.
Working with Flow Control through Loop Statement: For, While, Do–while statement, For & For each statement, Nesting of Loops statement.

10

Unit-II:
PHP Functions: Defining functions, Using built–in functions, Defining User functions, Returning a value from a function, Using variables in functions, Passing values to a function, Nesting of Functions, Anonymous Functions, Recursion, Passing parameter(Call By Value & Call By Reference) & return value, Trends of PHP Functions(Missing Parameter, Formal parameter declaration), Importing content of one page into another.
Handling HTML form with PHP: Capturing Form Data, Dealing with Multi–value filed, Generating File uploaded form, Redirecting a form after submission.

8

Unit-III:
Using Arrays in PHP: Anatomy of Arrays, Creating index based and Associative Arrays, Storing Data in Arrays, Accessing array Element, Looping with Index based Arrays, Converting Strings to & from Arrays, Splitting & Joining Arrays.
Using Strings in PHP: Introduction to string, creating & working with String, Creating string, Viewing string, Modifying string, String Function & their working.

8

Unit-IV:
The core Logics & Techniques: Introduction HTML Form Elements and Fields, Understanding Functions, Important PHP Functions, What are the Scope of variables, String and Math functions in PHP, Usage of Include and require statements, Accessing PHP, HTTP Data, Query Strings and Hyperlinks, Describing Pre–Defined Variables – Super Global Arrays.

6