Page 313 - IT_V1.0_Class10
P. 313
Practical Work
1. Consolidate data of two sheets given below in third sheet of LibreOffice Calc.
21 st #Technology Literacy
Century
Name June Pocket Money Skills #Critical Thinking
Amit 1200
Sumit 1000
Naina 1500
Suman 1300
Kamal 1400
Sheet 1
Name July Pocket Money
Amit 900
Sumit 1100
Naina 1300
Suman 1200
Kamal 1250
Sheet 2
2. Consider the given table Student mentioning students’ details and perform the following:
Rollno Class Name Phone_no
1 XII Sumit 1234565
2 X Amit 3564583
3 X Anuj 1236589
4 XI Mini 5869542
Create the following query in Design View:
• Display all the records of table Student.
• Display record of student whose roll number is 3.
• Display record of students who are in class ‘X’.
• Display the record of ‘Sumit’.
3. You are working on a project report about the solar system for your science class.
• Insert an image of the solar system, a constellation, and a spacecraft.
• Resize the solar system image to fit half of the page width.
• Crop the constellation image to remove unnecessary background.
• Align the solar system image to the centre of the page.
• Place the spacecraft image in the top-right corner of the page with text wrapping around it.
Practical Work 311

