How to use Google Sheets on WeSchool

From a WeSchool Module, you can work with Google Sheets and collaborate online with your learners to create a spreadsheet. For example, you can add corrections to a learner’s spreadsheet or allow multiple learners to enter different data records for a project directly from the WeSchool Group.

To share Google Sheets and take advantage of all the functions for collaborative activities, proceed as follows. 

  • log into Google Sheets and click on the Share button in the top right:

Help_Desk___Knowledge_Base___Screenshot_Editor_-_Google_Drawings_Template_-_2022-10-14T115723.035.png

  • in the following dialog box, edit the sharing settings. Under General Access, open the dropdown menu in the bottom left and select Anyone with the link:

Help_Desk___Knowledge_Base___Screenshot_Editor_-_Google_Drawings_Template_-_2022-10-14T115645.498.png

  • from the same box, you can allow users to edit the spreadsheets, if you want to. Open the dropdown menu in the bottom right and select the option Editor:

Help_Desk___Knowledge_Base___Screenshot_Editor_-_Google_Drawings_Template_-_2022-10-14T115622.987.png

PLEASE NOTE: to prevent your learners from editing the spreadsheets, you can select the option Viewer from the same dropdown menu.

  • once the sharing settings have been edited, you can copy the link to your spreadsheet. Click on Copy link

Help_Desk___Knowledge_Base___Screenshot_Editor_-_Google_Drawings_Template_-_2022-10-14T115548.704.png

  • now log in to WeSchool and go to the Modules section; click Add resource and then select Google Sheets:

Help_Desk___Knowledge_Base___I_Tool_di_Google__Eng__12_.png

  • paste your Google Sheets link in the URL bar and select Preview:

Help_Desk___Knowledge_Base___Screenshot_Editor_-_Google_Drawings_Template_-_2022-10-14T115428.428.png

  • finally, click Attach to insert your Google Sheets presentation into the Module:

Help_Desk___Knowledge_Base___I_Tool_di_Google__Eng__11_.png

Now all Group members – learners and instructors – can access the Google Sheet from the Module and work together directly from WeSchool.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request