XI Practical

Std. XI INFORMATION TECHNOLOGY SCIENCE (97)
Practical List

1. Daily Computing (Liber Office)

1. Create a Resume

2. By using mail merge send an invitation for your birthday party.

3. Create a mark list. The mark list should display

4. Create an informative presentation on your college.

2. Web Designing (HTML – 5)

1. Write a program using HTML with following specifications.

2. Create a web page with following specification.

3.  Create a web page with following specification.

4. Write a program using HTML with following specification.

3. Client Side Scripting (JavaScript)

1. Create JavaScript program for the following using appropriate variables, JavaScript inbuilt function and control structures.

·        To accept integer and display the result by multiplying it with 3.

·        To accept two integers and display large number of them.

·        To check whether, users entered number is positive or negative.

2. Create JavaScript program for the following using appropriate variables, JavaScript inbuilt function and control structures.

·        To accept two positive or negative numbers and check whether they are equal or not.

·        To accept number and display square of it.

·        To check whether accepted integer is multiple of 3 or multiple of 7.

3. Create JavaScript program for the following using appropriate variables, JavaScript inbuilt function and control structures.

·        To accept string and calculate its length.

·        To accept string and display it into lowercase and uppercase.

·        To check whether the length of string is 4 or greater.

4. Create Event driven JavaScript program for the following using appropriate variables, JavaScript inbuilt functions and control structures.

·        To accept number and validate if the given value is a number or not by clicking on the button.

·        To calculate addition and division of two numbers.

4. DBMS (PostgreSQL)

1. Create a database, Using PostgreSQL named hospital.

·        In this database, create a table of patients with the following fields Patient_ID, Patients_Name, Address, Room_number and Doctor’s_name.

·        Give appropriate data type for each field.

2. Create a database using postgreSQL named School-master.

·        In this database create a table of students with the following fields student_ID, student_name, Address, Phone_number, Date_of_Birth.

·        Give appropriate data type for each field. Enter at least 5 records.

3. Given the list of fields : EmpId, EmpName, EmpDepartment, SalaryId, SalaryAmount, Bonus in the tables Employee and Salary respectively. Define primary key, foreign key and segregate for above fields into employee and salary table. Also create one-to-one relationship between Employee and Salary table.