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.