Page 76 - iPro_trackGPT_V5_Class7
P. 76

SDG Activity




                     Create a worksheet to record daily or weekly water usage. Use formulas
                     to calculate average water usage and identify trends. Apply conditional
                     formatting to highlight days with unusually high water usage. Discuss
                     how  monitoring  water  usage  can  contribute  to  sustainable water
                     management practices.






                       Digital Drills                                               #Digital Literacy
                                                                                    #Creativity & Innovativeness


                        Create a marksheet of students as shown below and perform the following:




























                       •  Merge cells A1 to G1 to display MARK SHEET
                       •  Merge cells C2 to G2 to display UNIT TEST MARKS.
                       •  Use Auto fill to fill the roll numbers.
                       •  Give cell borders as ALL BORDERS to the table.
                       •  Use SUM function to display total marks.
                       •  Insert a row below roll no. 10 to add a new admission and change the roll numbers.
                       •  Insert a column between Science and Computer to add Hindi Marks.
                       •  Highlight the cells with total marks greater than 90 (after adding Hindi)
                       •  Highlight the cells with total marks less than 50 (after adding Hindi)



                  Teachers' Turf


                  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.



                    74    TrackGPT iPRO (V5.0)-VII
   71   72   73   74   75   76   77   78   79   80   81