Page 49 - Digicode_AI_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
               byte TASK                                                             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