00113b9797f-ec9f-40e1-8b27-4bc8eca29225-0 Welcome to this demonstration of option 2, transferring existing data to an updated 13b9797f-ec9f-40e1-8b27-4bc8eca29225-1 SSR tool. adc1a6e7-181b-4718-aa99-9fea58a1f9ce-0 This video provides a clear step by step demonstration of the update process. d6fb411b-9f33-4b8b-b119-e5c79cfc224a-0 Its purpose is to visually guide users through each action, d6fb411b-9f33-4b8b-b119-e5c79cfc224a-1 confirm the correct sequence of steps, and support accurate implementation of d6fb411b-9f33-4b8b-b119-e5c79cfc224a-2 the Student Support Referral Tool updates. dbe8f9f3-67ee-4e9a-aff8-7c6ef4e75795-0 Users are encouraged to view the entire demonstration before completing the dbe8f9f3-67ee-4e9a-aff8-7c6ef4e75795-1 written steps to ensure confidence and accuracy when performing the required dbe8f9f3-67ee-4e9a-aff8-7c6ef4e75795-2 tasks. 9ae9d997-9753-4f1d-8806-100b0d7beadc-0 Let's start by making a copy of our existing Student Support Referral 9ae9d997-9753-4f1d-8806-100b0d7beadc-1 Tracking tool. 42b13a44-9be4-4ba1-ba85-4d2971159a8f-0 This ensures that we have a complete and accurate data set in the event that the 42b13a44-9be4-4ba1-ba85-4d2971159a8f-1 data becomes corrupted during the following steps. 85bd0af7-d94d-48c1-98d6-0ef5b68e109d-0 Now we will download the updated SSR tool from the TCSS
002website. 3f1f2a3b-6b24-452a-b47e-e8cbe37a5a0c-0 Click on the SCG Leads link and enter the password. a1d46301-a7ac-4eea-b1fc-5ad25dd4882f-0 Scroll down to the Student Referrals Reporting resource card and click the a1d46301-a7ac-4eea-b1fc-5ad25dd4882f-1 link. e6330fe5-2e4f-48bf-baf7-b4f17d28bf41-0 Scroll down to the 2526 Student Support Referral Optional Tracking Tool resource e6330fe5-2e4f-48bf-baf7-b4f17d28bf41-1 card and click the link to download the updated tool. 019161b1-89be-4ae8-b647-8b4195637e74-0 Navigate to your Downloads folder and move the updated tracking tool to your 019161b1-89be-4ae8-b647-8b4195637e74-1 preferred location. 876b628f-639c-45d1-b1b6-273c891c515b-0 Open your existing tool. 4fdd670f-2a41-490f-9f80-15bf9bb62073-0 Now open the updated tool. 096e0fa6-e8f2-4665-a5ec-3a2239523a14-0 Navigate to queue one new support referrals. 9e99c4ec-2d76-437c-9021-39150141cddd-0 In your existing tool, look at the last row of user entered data. 93e3c9fa-1b8d-48c2-98c8-8e395f08e3db-0 This example has data entered through row 10. 362968a4-dc1c-42ea-ae03-4cbf73d8d13f-0 Now navigate to the Queue One new Support Referrals tab. 9e9cd627-9e8b-498c-a7fc-98938941dd21-0 In the updated tool, ensure there are enough available rows 9e9cd627-9e8b-498c-a7fc-98938941dd21-1 for your existing data. 546157e9-4686-4b1a-b781-731dd5f0a973-0 With that
003verified, we are ready to transfer the data. 4f388320-d274-4f43-9083-2e83a6bfb3c9-0 The sheets in the updated tool are protected. 6bc54b9a-b476-4a8d-a3b8-ae8167f5ed47-0 To prevent unintended modifications, we need to remove the protection. ec1c3b8f-7042-4f1f-b847-4950088d4bd2-0 Navigate to the Review tab, then navigate to the Protect menu and ec1c3b8f-7042-4f1f-b847-4950088d4bd2-1 click Unprotect sheet. 0c9e7d01-6bef-4016-b0ce-4c4a0a53bfc5-0 Navigate back to your existing tool and ensure that you are starting with column 0c9e7d01-6bef-4016-b0ce-4c4a0a53bfc5-1 A and row 4. fcf2b865-43c1-45ac-8d56-8e13d3c124a3-0 Highlight all your existing user entered data in columns A through W. dccda4b1-6ee8-43cd-b504-7fd9b88b4827-0 Copy the data to the clipboard. aeecf0ee-8e0b-498e-9077-e949c0b53c82-0 Navigate back to the updated tool and ensure that you are in column A, row 4. 488e1275-74af-47fb-a536-1c8d43606f0d-0 Paste your copied data. a507489f-2af8-4c62-b7b5-0c70d11f51cc-0 We now need to restore sheet protection. ff17bea8-9075-46ee-bea4-34f35aec4e03-0 Navigate to the Protect menu and click Protect Sheet on the popup menu. 5b125682-915d-49b3-a7ba-ee332d7d43c1-0 Click OK. 24ed7d62-64a1-47d5-bb0f-0d78e18de9b6-0 There is an additional step that needs
004to be taken if your data extends beyond row 24ed7d62-64a1-47d5-bb0f-0d78e18de9b6-1 32. b46b9561-721c-4c99-8671-8aa17620fc29-0 Let's look at this now. e0f129eb-2b3b-4d3e-9871-6a4d9179aa32-0 On the Q2 New Support Referrals tab in the existing workbook, e0f129eb-2b3b-4d3e-9871-6a4d9179aa32-1 we have data that extends through row 37. 2568cb2c-4543-408f-9bd9-203b124498af-0 On the Q2 tab in the updated tool, there is only space available through row 2568cb2c-4543-408f-9bd9-203b124498af-1 32. c91e39f2-f7ca-4e77-8394-67abcdc17c1c-0 We need to add additional rows for our existing data. 7e9f70b1-7234-4816-b906-495bc41df167-0 To insert additional rows, highlight the number of rows you need to 7e9f70b1-7234-4816-b906-495bc41df167-1 add, right click, then select Insert. 868b1bab-a83e-4025-94be-80139d8b6c89-0 We now have enough available rows to transfer our data. 8f378e88-1b57-4bdf-ad92-30459249f5c2-0 Again, we need to unprotect the sheet. b0439477-158f-4ebf-a166-ef9991aa325e-0 In the updated tool, navigate to the Review tab, b0439477-158f-4ebf-a166-ef9991aa325e-1 select the Protect menu and click Unprotect sheet. 4bbd0bbc-5606-46ae-8170-7e2e223fcfc1-0 We are now ready to transfer our data. 68148c72-ef04-4132-84cf-65ae6554f923-0 Ensure that you start in
005the cell in column A, row 4. 33df3b04-9af5-44ff-81c6-c47455ad11c5-0 Highlight all user entered data in columns A through W. c6932573-60e3-49c6-b77a-5ff345292d05-0 Right click and select Copy. 833c436a-b284-490f-9886-cdffa88d4b51-0 Navigate back to the Updated tool. 1b53cd25-061d-4ae3-a3b6-3b0549404ea9-0 Ensure that you select the cell in column A, row 4. c0603c68-2e3e-4249-94c2-7f299725aad6-0 Right click in that cell and select Paste. fd234cb5-1c8e-4992-87c5-975a93545e3a-0 We now need to restore sheet protection to avoid unintended modifications. 2a17a2b7-7d6a-4483-9f11-b375e0cb8926-0 Navigate to the Review tab and select the Protect menu. e4368731-75a0-4da3-a85f-19d666406461-0 Click Protect Sheet on the popup, Click OK. a2262cd0-addf-4b20-b6eb-49d61700e2d3-0 You will need to repeat these steps for each of the tabs that contain user data. 0a364418-cf91-48df-b810-7b1417061366-0 SY25 Continuation referrals. e529ccea-427f-4069-8fa9-c7ce2dfb6de5-0 Q2 Continuation referrals, Q3 New support referrals, e529ccea-427f-4069-8fa9-c7ce2dfb6de5-1 Q3 continuation referrals and queue for new support referrals and continuation e529ccea-427f-4069-8fa9-c7ce2dfb6de5-2 referrals if they contain data. 7fb06e3d-3354-4604-beca-21c5b1d5494d-0 Once all your user data has been transferred,
0067fb06e3d-3354-4604-beca-21c5b1d5494d-1 we need to refresh the pivot table counts. 5f641933-ebed-4973-b1a6-da0b1592259a-0 Navigate to 1 of the counts pages. cf364ee9-1626-4e89-be85-2fbce72254f7-0 Queue 2 is shown here. 7c77fa04-52c2-46ce-bce2-70c128cf6f2d-0 The pivot table occupies this colored area seen here. c9437fc3-7b3e-4cf4-9eef-21c47f240695-0 Click directly inside the pivot table to activate it. acce18e1-b481-4b12-90a6-f750ee579c6d-0 Navigate to the Pivot Table Analyze tab, then select Refresh. 65dbc983-aac5-4a29-bf6b-178bfec62240-0 Click Refresh. 40bd1701-d66a-49ce-95a2-a5982981c77d-0 All the counts have been updated. ba461862-c269-4e96-a84d-160d0bb5ee12-0 You have now successfully transferred your data to the updated SY 2526 Student ba461862-c269-4e96-a84d-160d0bb5ee12-1 Support Referral Optional Tracking tool. f0da8eb8-d8c1-46e8-a31d-835bd0e281b5-0 This concludes the demonstration for Option 2. 40e8988c-b56f-40ca-9930-ffa0c1c97ce9-0 Each action you observed aligns exactly with the steps in the written guide. 60383e70-8958-4235-bcc8-c97f20586644-0 Completing these steps ensures that your data is accurately transferred into the 60383e70-8958-4235-bcc8-c97f20586644-1 updated tool and that your referral counts are displayed correctly.