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
   308   309   310   311   312   313   314   315   316   317   318