Page 422 - IT 402 v2.0 class 10
P. 422

13.

            •    he cells containing marks greater than or e ual to    should be highlighted with  ood cell style.
            •    he cells containing marks greater than or e ual to    and less than    should be highlighted with
              Neutral cell style.

            •  The cells containing marks less than 70 should be highlighted with Bad cell style.

                                                          Subjects
                 Student Name         Hindi      English       Maths         Science     Computer Science
                Amit                   67           77           90             85                98
                Divya                  87           65           80             98                73

                Chirag                 78           90           67             85                92
                Anshika                96           84           99             75                62

        14.

                                                          Date of             Marks
                     Reg No.            Name                                                     Grade
                                                        Submission          Obtained
                    T/121/15       Anshu Verma            11/07/15              18                 A
                    T/137/15       Anjali Kumari          12/07/15              20                A+
                    T/145/15       Deepak Kohli           14/07/15              17                B+

            •  Name the table as ‘Marks Distribution’.

            •  Enter atleast 3 records.
            •  Sort the data on the basis of grades.



                    Roll No.            Name           Date of Birth       Phone No.             Place
                      A001         Manan  upta          12/09/1987         2354667667      Delhi
                      A002         Ryansh Sharma        09/05/1986         3435555555      Chattisgarh
                      A003         Rahul John           02/05/1990         656554432       Mumbai


            •  Sort the place in decreasing order.
            •  Set Roll No as the primary key.

            •  Delete the record no. A002.
            •  Add another record.

        16.  Create the following table for the Library Management System.
                    Book ID            Books              Publication            Price          Quantity

                       1         Touchpad            Orange Education             296               10
                       2         Pratibha            Madhuban                     256               20
                       3         Cyber Olympiad      Orange Education             300               20
                       4          iving  orld         urdas                       275               20






         420       Touchpad Information Technology-X
   417   418   419   420   421   422   423   424   425   426   427