Page 149 - Trackpad_V4.0_c7_Flpbook
P. 149

Practical Assessment










                 Excel                                                                            21 st  Century   #Technology Literacy
                                                                                                      Skills
                                                                                                          #Critical Thinking
                  1.   Create the following spreadsheet in Excel and perform the operations given below:

                                          Name             Age           Gender           Score

                                      Rahul           12              Male           85

                                      Priya           14              Female         92

                                      Aryan           13              Male           78

                                      Nisha           11              Female         95

                                      Vikram          15              Male           80

                                      Ananya          16              Female         88
                                      Rohit           10              Male           75

                                      Sneha           12              Female         90


                     a.   Apply conditional formatting on the column Age to display the students age in red colour who are below
                        13.

                     b.  Sort the records in ascending order of the basis of Score column.

                     c.  Display the records of Female students only.                             21 st  Century   #Technology Literacy
                                                                                                      Skills
                                                                                                          #Creativity
                 HTML

                  1.  Create the following table in HTML. Also apply border style and colour to decorate it.

                                                                                           Price
                        Product                       Description                                        Quantity
                                                                                       Unit    Total
                      Pencils       HB pencils, pack of 12                            2       75       50

                      Pens          Ballpoint pens, assorted colors, pack of 10       2       60       30
                      Notebooks College-ruled notebooks, pack of 3                    4       70       20

                      Markers       Highlighter markers, assorted colors, pack of 6   5       68       15














                                                                                            Practical Assessment   147
   144   145   146   147   148   149   150   151   152   153   154