Page 71 - PlusGPT_V2.1_C8_Flipbook
P. 71

teCh PraCtiCe                                                                    Subject Enrichment


                     1.  Creating and Saving a New Google Sheet:
                        ·    Click on the Google apps button.
                        ·    Click on the Sheets icon to open a new spreadsheet.
                        ·    Rename the sheet as My First Spreadsheet.
                        ·    Enter the following data in the sheet:












                        ·    Use the SUM function to calculate the total marks.

                        ·    The spreadsheet will be saved automatically in Google Drive.
                     2.  Working in Google Sheet:
                        ·    Open a new spreadsheet.
                        ·    Rename the sheet as Student Records.
                        ·    Enter the following data in the sheet:













                        ·    Use the AVERAGE function to calculate the average score.
                     3.  Sharing a Google Sheet:
                        ·    Click on the Share button in the top-right corner.
                        ·    Enter the email addresses of the people you want to share the file with.
                        ·    Choose the access level: Viewer, Commenter, or Editor.
                        ·    Click Send to share the sheet.

                     4.   Learn about the best practices for organising large datasets efficiently in Google
                        Sheets.


                                                        For The Teacher


                       Illustrate how to use formulas and functions (SUM, AVERAGE, COUNT) for quick calculations.
                       Demonstrate how to create and save a new Google Sheet in Google Drive.
                        Explain  the process  of sharing a  Google  Sheet  with  different  permissions  (Editor,  Viewer,
                      Commenter).




                                                                                                   Google Sheets   69
   66   67   68   69   70   71   72   73   74   75   76