Surveys can be added to Leaver Survey Lists one at a time (see previous page) or in a batch upload (see below). Demographics do not need to be reviewed/confirmed for surveys that are added by LV and DM users. .

Instructions

Navigate to your school’s Leaver Survey List page.
Under the Review and Edit Leaver Survey List heading, click on the Add multiple surveys by file upload button.
On the Add Multiple Leaver Surveys page, follow the instructions to prepare the Batch Upload spreadsheet.
Once the spreadsheet is complete, email it to ccts@seattleu.edu.
Spreadsheets will be reviewed by CCTS and, if there are no errors, uploaded within one business day. CCTS will contact you when the upload is complete, or if there are issues uploading the surveys to the site.

Demo with Screenshots

If I have many former students that need to be added to my Leaver Survey List, I can include all of their information in one spreadsheet and email it to CCTS to upload to the site for me.

Leaver Survey List page

Start on the Leaver Survey List page. Under the Review and Edit Leaver Survey List heading, click the Add multiple surveys by file upload button.

screenshot of Leaver Survey List page, Add multiple surveys button highlighted

Add Multiple Leaver Surveys page

That takes me to the Add Multiple Leaver Surveys page. From here, I need to download the TSF2 Batch Upload spreadsheet, add my leaver data, and email it to CCTS.

Screenshot of Add Multiple Surveys page, link to download template highlighted

Download Template

Under Prepare Spreadsheet, click the Download the TSF2 Batch Upload Excel Template link. Be sure to save the file to a secure location on your computer.

Spreadsheet Template - Sheet 1 (Demographics)

The spreadsheet template is an Excel workbook that contains two sheets.

The first sheet is where I’ll enter all the information for my two missing leaver surveys.

Row 2 includes an example to use as a guide when filling out the template. For some of these fields, numerical codes are entered. A key to numerical codes is found on the second sheet.

Screenshot of the first page on the Batch Upload Spreadsheet

Spreadsheet Template - Sheet 2 (Codes)

The second sheet in this workbook includes a guide to the numerical codes that are entered in the demographics columns.

Screenshot of Batch Upload Spreadsheet sheet 2

Save Spreadsheet and Email to CCTS

Once the spreadsheet is complete with the demographic information for Former Student 4 and Former Student 5, I’ll save it to a secure location on my computer.

To have it imported to the TSF2, I’ll email it to CCTS. If I entered everything correctly, my leaver surveys will populate in the TSF2 within one business day. CCTS will follow up with an email when they’re uploaded, or if there was a problem with uploading any information.

Screenshot of Batch Upload Spreadsheet with the first two rows completed

Log in to the TSF2 and Return to Leaver Survey List

After I receive an email confirmation from CCTS, I can log back into the TSF2. Former Students 4 and 5 are now on my Leaver Survey list.

Screenshot of Leaver Survey List that includes the leavers imported from the batch upload spreadsheet

Next: Guide - Verify the Leaver Survey List