Practical_2024-2025

RK SANATOMBI DEVI VIDYALAYA
HAOTAL, PANGEI
INFORMATION TECHNOLOGY(402)
AISSE
PRACTICAL FILE
Submitted by:- Submitted to:-
Name:- Madam Rajkumari Rasheswori
Class:- PGT(Information Technology)
Roll No:-
CONTENTS
1. Insert Image from the clipboard in OpenOffcie Writer

2. Prepare three worksheets as given below and do as directed:
a. Add Sheet4 in the file to calculate total of all 3 quarters due fee.
b. Rename all woksheets like sheet1-1st quarters, sheet2-2nd quarters, sheet3-3rd quarter and sheet4-final
due
c. Use sum function to add due fee data for 1st quarter, 2nd quarter, 3rd quarter and in respective cells
using consolidation.
3. Given below is the TEACHER table.
TEACHER
NUMBER NAME AGE SUBJECT DATE OF SALARY GENDER

JOIN
1 JUGAL 34 COMPUTER 10/01/2019 12000 M
2 PRATIGYA 31 SCIENCE 24/03/2019 20000 F
3 SANDEEP 32 MATHS 12/12/2019 30000 M
4 SANGEETA 35 SCIENCE 01/07/2020 40000 F
5 SATTI 42 MATHS 05/09/2020 25000 M
6 SHYAM 50 SCIENCE 27/06/2021 30000 M
7 SHIV OM 44 COMPUTER 25/02/2021 21000 M
8 SHALAKHA 33 MATHS 31/07/2020 20000 F
Write SQL commands:

a. Display the information of all teacher
b. Display the information of science teachers.
c. Display the details of all the teachers whose age is 40 to 50.
d. To display the subject of all the teachers whose salary is more than 25000.
e. To display the list of names of all the teachers order by date of join
4. Given below is the EMPLOYEES table
Write an SQL command

a. Display all the information of the EMPLOYEES table.
b. Display NAME and STATE from EMPLOYEES table where EMP_ID= 485
c. Display the information order by EMP_Id.
d. Display NAME and STATE from EMPLOYEES table.
1. Insert Image from the clipboard by performing the following steps:
Solution:-
Step 1: Open the document from where the image has to be copied and select the image.
Step 2: Press Ctrl+C and copy the image to the clipboard
Step 3: Now switch to the document in which graphic needs to be inserted
Step 4: Click to the place where graphic is to be inserted
Step 5: Press Ctrl+V to paste/insert the image

2. Prepare three worksheets as given below and do as directed:
a. Add Sheet4 in the file to calculate total of all 3 quarters due fee.
b. Rename all woksheets like sheet1-1st quarters, sheet2-2nd quarters, sheet3-3rd quarter and
sheet4-final due
c. Use sum function to add due fee data for 1st quarter, 2nd quarter, 3rd quarter and in respective
cells using consolidation.
Solution:- a. Add “Sheet4” in the file to calculate total of all 3 Quarters Due fee.
b. Rename all worksheets like Sheet1-1st Quarter, Sheet2-2nd Quarter, Sheet3-3rd Quarter and sheet4
Final due
Fig:- 1st Quarter
Fig:- 2nd Quarter

Fig:- 3rd Quarter
Fig:- Final Due

b. Use Sum function to add due fees data for 1st quarter, 2nd quarter, 3rd quarter and in
respective cells using consolidation.
Fig:- Consolidated Sum(1st Quarter)

Fig:- Consolidated Sum(2nd Quarter)
Fig:- Consolidated Sum(3rd Quarter)
3. Given below is the TEACHER table.

TEACHER
NUMBER NAME AGE SUBJECT DATE OF SALARY GENDER
JOIN
1 JUGAL 34 COMPUTER 10/01/2019 12000 M
2 PRATIGYA 31 SCIENCE 24/03/2019 20000 F
3 SANDEEP 32 MATHS 12/12/2019 30000 M
4 SANGEETA 35 SCIENCE 01/07/2020 40000 F
5 SATTI 42 MATHS 05/09/2020 25000 M
6 SHYAM 50 SCIENCE 27/06/2021 30000 M
7 SHIV OM 44 COMPUTER 25/02/2021 21000 M
8 SHALAKHA 33 MATHS 31/07/2020 20000 F
Write SQL commands:

a. Display the information of all teacher
a. Display the information of all teacher.

Ans:- SELECT * FROM TEACHER;
OUTPUT:-

Ans:- SELECT * FROM TEACHER WHERE SUBJECT='SCIENCE';
OUTPUT:-

Ans:- SELECT * FROM TEACHER WHERE AGE BETWEEN 40 AND 50;
OUTPUT
Ans:- SELECT SUBJECT FROM TEACHER WHERE SALARY>25000;
OUTPUT
Ans:- SELECT NAME FROM TEACHER ORDER BY DATE_OF_JOIN;
OUTPUT
Q 2. Given below is the EMPLOYEES table

Write an SQL command
Ans:- SELECT * FROM EMPLOYEES;
OUTPUT
Ans:- SELECT NAME, STATE FROM EMPLOYEES WHERE EMP_ID=485;
OUTPUT
Ans:- SELECT * FROM EMPLOYEES ORDER BY EMP_ID;
OUTPUT

Ans:- SELECT NAME, STATE FROM EMPLOYEES;
OUTPUT

Practical_2024-2025

Uploaded by

Copyright:

Available Formats

Practical_2024-2025

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Practical_2024-2025

Uploaded by

Copyright:

Available Formats

RK SANATOMBI DEVI VIDYALAYA

Submitted by:- Submitted to:-

Name:- Madam Rajkumari Rasheswori

Class:- PGT(Information Technology)

1. Insert Image from the clipboard in OpenOffcie Writer

NUMBER NAME AGE SUBJECT DATE OF SALARY GENDER

Write SQL commands:

4. Given below is the EMPLOYEES table

Write an SQL command

Step 2: Press Ctrl+C and copy the image to the clipboard

Step 3: Now switch to the document in which graphic needs to be inserted

Step 4: Click to the place where graphic is to be inserted

Step 5: Press Ctrl+V to paste/insert the image

Fig:- 1st Quarter

Fig:- 2nd Quarter

Fig:- Final Due

Fig:- Consolidated Sum(1st Quarter)

Fig:- Consolidated Sum(3rd Quarter)

3. Given below is the TEACHER table.

Write SQL commands:

a. Display the information of all teacher.

b. Display the information of science teachers.

c. Display the details of all the teachers whose age is 40 to 50.

Q 2. Given below is the EMPLOYEES table

a. Display all the information of the EMPLOYEES table.

Ans:- SELECT * FROM EMPLOYEES;

d. Display NAME and STATE from EMPLOYEES table.

You might also like