{"id":1875,"date":"2012-02-28T14:39:58","date_gmt":"2012-02-28T20:39:58","guid":{"rendered":"https:\/\/home.lps.org\/training\/?p=1875"},"modified":"2018-05-11T10:22:17","modified_gmt":"2018-05-11T15:22:17","slug":"download-student-data-to-a-spreadsheet","status":"publish","type":"post","link":"https:\/\/home.lps.org\/cs\/2012\/02\/28\/download-student-data-to-a-spreadsheet\/","title":{"rendered":"Download Student Data to a Spreadsheet (Synergy TeacherVUE)"},"content":{"rendered":"<p>Synergy TeacherVUE\u00a0allows you to download\u00a0a spreadsheet of information about\u00a0students assigned to you in each class period. This spreadsheet can be used to create labels, populate contact groups in LPS Google Docs and various other uses.<\/p>\n<div class=\"alert-box alert radius\" data-alert=\"\">\n<h3 style=\"font-size: 2em; color: #ffffff; font-weight: bold;\"><i class=\"fi-alert\"><\/i> Student Data<\/h3>\n<h6 style=\"color: #ffffff;\">Once you have downloaded this information to your computer, please take any necessary steps to secure it from unauthorized viewing and delete it when no longer needed. This information should not be shared with students or non-LPS staff members.<\/h6>\n<\/div>\n<p>&nbsp;<\/p>\n<h3>Downloading student data from\u00a0Synergy TeacherVUE<\/h3>\n<p class=\"p1\"><img fetchpriority=\"high\" decoding=\"async\" data-attachment-id=\"12713\" data-permalink=\"https:\/\/home.lps.org\/cs\/2012\/02\/28\/download-student-data-to-a-spreadsheet\/synergy-sis\/\" data-orig-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/synergy-sis.png\" data-orig-size=\"399,419\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"synergy-sis\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/synergy-sis-286x300.png\" data-large-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/synergy-sis.png\" class=\"alignright wp-image-12713 size-medium\" src=\"http:\/\/home.lps.org\/cs\/files\/2012\/02\/synergy-sis-286x300.png\" alt=\"\" width=\"286\" height=\"300\" srcset=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/synergy-sis-286x300.png 286w, https:\/\/home.lps.org\/cs\/files\/2012\/02\/synergy-sis.png 399w\" sizes=\"(max-width: 286px) 100vw, 286px\" \/>Login to the Synergy SIS and pull up the class\/period you are interested in.<\/p>\n<ol class=\"ol1\">\n<li class=\"li1\">Click the <b>Reports<\/b> tab.<\/li>\n<li class=\"li1\">For &#8220;Output Type&#8221; select <b>TXT<\/b><\/li>\n<li class=\"li1\"><b><\/b>Select the appropriate Report (<strong>STU608 &#8211; LPS\u00a0<\/strong><b>Class List<\/b>)<\/li>\n<\/ol>\n<p class=\"p2\">Your computer will download a text (txt) file to your computer that contains the information.<\/p>\n<p>&nbsp;<\/p>\n<h3 class=\"p2\">Using\u00a0the Download<\/h3>\n<p>This txt file contains your requested data. It can be used in many ways. Here are some\u00a0common approaches.<\/p>\n<p><strong><a href=\"https:\/\/home.lps.org\/training\/files\/2012\/02\/Handling-the-Download.png\"><img decoding=\"async\" data-attachment-id=\"6194\" data-permalink=\"https:\/\/home.lps.org\/cs\/2012\/02\/28\/download-student-data-to-a-spreadsheet\/handling-the-download\/\" data-orig-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/Handling-the-Download.png\" data-orig-size=\"451,344\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"SynergyReportDownloadMac\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/Handling-the-Download-300x228.png\" data-large-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/Handling-the-Download.png\" class=\"alignright size-medium wp-image-6194\" src=\"https:\/\/home.lps.org\/training\/files\/2012\/02\/Handling-the-Download-300x228.png\" alt=\"SynergyReportDownloadMac\" width=\"300\" height=\"228\" srcset=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/Handling-the-Download-300x228.png 300w, https:\/\/home.lps.org\/cs\/files\/2012\/02\/Handling-the-Download.png 451w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>Open the file in Excel<\/strong><\/p>\n<p>As the file downloads, you can have the computer &#8220;Open in Microsoft Excel&#8221; to see it right away.<\/p>\n<p>If the file is downloaded and saved to your computer, you can open the txt file with\u00a0Excel at any time.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Put the data in a Google Spreadsheet<\/strong><\/p>\n<p>1. As the file downloads, have the computer &#8220;Save File.&#8221;<br \/>\n2. Once it is on your desktop, double-click the txt file to open it. Select all of the text in the\u00a0document and copy it.<br \/>\n3. Open a blank Google Spreadsheet. Select cell A1.\u00a0Paste the text.<\/p>\n<p><a href=\"https:\/\/home.lps.org\/training\/files\/2012\/02\/PasteInGoogSheet.png\"><img decoding=\"async\" data-attachment-id=\"6196\" data-permalink=\"https:\/\/home.lps.org\/cs\/2012\/02\/28\/download-student-data-to-a-spreadsheet\/pasteingoogsheet\/\" data-orig-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/PasteInGoogSheet.png\" data-orig-size=\"317,290\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"PasteInGoogSheet\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/PasteInGoogSheet-300x274.png\" data-large-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/PasteInGoogSheet.png\" class=\"alignright size-medium wp-image-6196\" src=\"https:\/\/home.lps.org\/training\/files\/2012\/02\/PasteInGoogSheet-300x274.png\" alt=\"PasteInGoogSheet\" width=\"300\" height=\"274\" srcset=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/PasteInGoogSheet-300x274.png 300w, https:\/\/home.lps.org\/cs\/files\/2012\/02\/PasteInGoogSheet.png 317w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/home.lps.org\/training\/files\/2012\/02\/CopyData.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"6195\" data-permalink=\"https:\/\/home.lps.org\/cs\/2012\/02\/28\/download-student-data-to-a-spreadsheet\/copydata\/\" data-orig-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/CopyData.png\" data-orig-size=\"455,241\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"CopyData\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/CopyData-300x158.png\" data-large-file=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/CopyData.png\" class=\"alignright size-medium wp-image-6195\" src=\"https:\/\/home.lps.org\/training\/files\/2012\/02\/CopyData-300x158.png\" alt=\"CopyData\" width=\"300\" height=\"158\" srcset=\"https:\/\/home.lps.org\/cs\/files\/2012\/02\/CopyData-300x158.png 300w, https:\/\/home.lps.org\/cs\/files\/2012\/02\/CopyData.png 455w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Synergy TeacherVUE\u00a0allows you to download\u00a0a spreadsheet of information about\u00a0students assigned to you in each class period. This spreadsheet can be used to create labels, populate contact groups in LPS Google Docs and various other uses. Student Data Once you have downloaded this information to your computer, please take any necessary steps to secure it from [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[677,678],"tags":[140,303,591,172,622,47,590],"class_list":["post-1875","post","type-post","status-publish","format-standard","hentry","category-u","category-synergy","tag-data","tag-download","tag-sis","tag-spreadsheet","tag-ssi","tag-student","tag-synergy"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/posts\/1875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/comments?post=1875"}],"version-history":[{"count":10,"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/posts\/1875\/revisions"}],"predecessor-version":[{"id":12715,"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/posts\/1875\/revisions\/12715"}],"wp:attachment":[{"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/media?parent=1875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/categories?post=1875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/home.lps.org\/cs\/wp-json\/wp\/v2\/tags?post=1875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}