Using Apps Script to Update a Standards sheet on each student sheet that had an incorrect version

About this lesson

@redtailfanschool In this example I wanted to share how we used apps script to push out a new updated version of a standards sheet to each student sheet that had already been distributed with a set of incorrect standards. Good old apps script to the rescue! We already had the URL to each student sheet so we had apps script perform the function of copying a sheet to an existing spreadsheet, first removing the sheet named 'standards'. This allowed us to update in a matter of minutes a set of student sheets. To do this task manually would have taken quite a bit of time. One issue we had to solve was matching the correct tab from the source sheet to update the correct grade level standards. Worked great!

Original Description