How to create Synced Sheets

Hello there!

This article will show users how to create a Sync Sheet. Portal Synced Sheets allows you to access realtime Portal data from a Google Sheet. Note: The sync sheets can only be created with users using their GAFE account. The school admin (principal) has to add school users Google email to their profile on the User Management page in order for them to access Sync Sheet. Please reach out to schoolsupport@newvisions.org if you have any further questions.

Overview:

• Creating Synced Sheets

• Example Attendance Synced Sheet

• Accessing Created Sync Sheet for Review

Creating Synced Sheets

Follow these steps to create your Synced Sheet:

1. Click on Other tools from the main left sidenav.

2. Select Create new sheet

3. Provide sheet info. Sheet name: This will be the sheet title. Students to include allows you to specify which students appear in the sheet.

4. Click Next to select the columns you wish to include in your sheet

5. Click Next to choose your update frequency and set automatic daily updates by selecting Daily

6. The title for the sheet will appear on the Synced Sheets page, and will say Submitting Your Request until the process is complete. Note: In addition, an email with a link to the sheet will be sent to the user who created the sheet.

Example Attendance Synced Sheet

Follow these steps to create your Attendance Synced Sheet:

1. Click on Other tools from the main left sidenav.

2. Select Create new sheet

3. Enter sheet info:

   1. Sheet name - SY30-31 Attendance

   2. Student Status - Active Students

   3. Students to include - All Students

4. Click Next to select the attendance data points

   1. Count of Days Absent: Last 5 Days

   2. Attd Today

   3. Attd Last 20 Days vs. YtD

   4. Attd Last 20 Days

   5. Count of Days Absent: This Term

   6. Count of Days Absent: YTD

   7. Count of Days Absent: Last 10 Days

   8. Count of Days Absent: Last 5 Days

5. Click Next and set automatic daily updates by selecting Daily

6. The title for the sheet will appear on the Synced Sheets page, and will say Submitting Your Request until the process is cfrom Sync SysDaar (via Google Sheets) with a link to the sheet will be sent to the user who created the sheet.

Accessing Created Sync Sheet for Review

1. Click on Other tools from the main left sidenav.

2. Scroll to the school year you created the sync sheet in (i.e., SY2021-22)

3. Click on the created synced sheet to access or click on the three dots on the right of the synced sheet to edit the data points.

   Note: you can also access the created sync sheet via the email sent by Sync SysDaar (via Google Sheets) with the title of your synced sheet in the subject line.