Page 49 - ThinkGPT_V2.1_C6_Flipbook
P. 49

Critical Thinking
                    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 is creating a chart in Excel. She wants to put emphasis on a significant element in
                      the chart. Which type of chart should she use to achieve this?



                                                                                          Technology Literacy
                    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.

















                                                                                              More on Excel   47
   44   45   46   47   48   49   50   51   52   53   54