Page 82 - iPlus_Ver_2.0_class_7
P. 82

#Communication
                                                                                      #Collaboration & Teamwork
                            Be Creative


                     Anaya is making a list of marks of her classmates and their total percentage after her teacher
                     asked her to do so. After completing it, she shared the Excel with her best friend without telling
                     the teacher. Is this act of her ethically correct? Write your views.






                                                                                              #Creativity & Innovativeness
                                                                                              #Digital Literacy

                         Practical Time


                      Create a marksheet for ten students. Now, follow these instructions:
                        •   Insert a row after the fifth record.

                        •   Insert a column to the right of the third column.
                        •   Using AutoFill features, fill in the roll numbers 1 to 11 for the students.

















                       Add the following records to the Excel worksheet and apply the cell styles as per the following
                        rules:

                        •   The  cells  containing  marks
                          greater  than  or  equal  to  80
                          should be highlighted with Good
                          cell style.

                        •   The cells containing marks greater than or equal to 70 and less than 80 should be highlighted
                          with a Neutral cell style.
                        •  The cells containing marks less than 70 should be highlighted with Bad cell style.






                      Teacher’s Corner

                  1.  Do a detailed walk-through with students on all the topics presented in the chapter.
                  2.  Provide some tasks which make use of the functional facilities discussed in the chapter.



                    80
                         iPlus (Ver. 2.0)-VII
   77   78   79   80   81   82   83   84   85   86   87