Page 49 - CG_v2.1_flipBooks_class_6
P. 49

Experiential Learning
                   Competency-based/Application-based questions                         Information Literacy
                   1.   John is preparing a list of students with their marks obtained in exams. He wants to arrange the
                      data in ascending order according to the students' names. Suggest him a feature of Excel that can
                      help him do his work quickly.
                   2.   Akriti was making a list of all the students in her class. She wishes to sort them alphabetically.
                      Which type of sorting can she use for this?



                                                                                          Experiential Learning
                     LAB Activity                                                         Information Literacy


                   A.  Create an Excel worksheet and enter the following data:













                         Create a column chart based on the above data. Title of the chart should be ‘Yearly Sales
                         Chart’. The chart should be look like this:






















                   B.   Do a poll/survey of students of your class on festivals of India. Visit https://utsav.gov.in/
                      and find the relevant information about each festival. Create an Excel sheet containing the
                      favourite festival of each student in the class and sort the data according to the name of the
                      student alphabetically.

















                                                                                             Charts in Excel  47
   44   45   46   47   48   49   50   51   52   53   54