Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 81 - 2619_PlusGPT V2.1_C-7
P. 81

    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).

                                                                                           Introduction to Google Sheets  79

| 76 77 78 79 80 81 82 83 84 85 86 |