Importing and Exporting Class Lists and Students (User Guide, pp</ti= tle> <o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"place"/> <o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"City"/>  <style>  </style>  </head> <body lang=3DEN-US style=3D'tab-interval:.5in'> <div class=3DSection1> = Importing and Exporting Class Lists and Students (User Guide, pp. 42-46)<o:p></o:p></= span> = <o:p> </o:p> Class lists can be imported from <i= >Qwizdom Teaching Assistant (TA), Excel or grade book programs in .CSV= or .txt file format. <o:p></o:p> Importing a .CSV File into Interact= <o:p></o:p> 1. Open Qwizdom Interact and= click on the Students tab; or if Interact is already open, click on= the<o:p></o:p> Students tab.<o:p></o:p> 2. Go to the Class menu and = select New Class.<o:p></o:p> 3. Type in the name of the class al= ong with filling out other necessary information and click Done.<o:p></o= :p> 4. Go to the File menu and s= elect Import, then Students.<o:p></o:p> 5. Search for the file (should be i= n .CSV file format-comma delimited or it can be in a .txt file format).= <o:p></o:p> 6. Select the file and click Ope= n. The Student Import window will appear.<o:p></o:p> 7. You are able to drop down the fi= elds to select the information that will be imported. Be sure the<o:p></o:p></sp= an> fields on the right match up to the information on the left. See image below for example.<o:p></o:p> 8. Uncheck the 'First Record is = Header' if the first record aren't headers. As you will see the images<o:p></o:p></= span> above, the first record is not a he= ader. If the first record is a header, the information on the left<o:p></o:p></sp= an> will not have student information. = It will have the column heading information from where you are<o:p></o:p></spa= n> importing the file from (e.g., F= irst name, Last name, etc.). See image below.<o:p></o:p> 9. Click on Import. The crea= ted class will appear.<o:p></o:p> You have successfully imported a cl= ass!<o:p></o:p> Exporting Students from Interact in= to Excel<o:p></o:p> You are also able to export student= s into Excel, other gradebook programs, or into Interact on another<o:p></o= :p> computer.<o:p></o:p> 1. Open Qwizdom Interact; or= go to the Students tab.<o:p></o:p> 2. Go to the Class drop-down= menu and select the class you want<o:p></o:p> to export. The class you selected w= ill open.<o:p></o:p> 3. Go to File and select = Export then Students.<o:p></o:p> 4. The Student Export window= will appear.<o:p></o:p> 5. Select Student Information </= i>under 'What would you like to Export?' and Comma Delimited.<o:p></o= :p> 6. What would you like to Export= ?<o:p></o:p> &middo= t; Student Information-exports Student ID, Full= Name, Email, Gender, Current Level, Ability, Birth= <o:p></o:p> Date, Group Number, Remote Number, Class Comments, and Generic Comments.<o:p></o:p> &middo= t; Contact Information-exports Contact Name, Ad= dress, Phone Number, Email, and Contact Method.<o:p></o:p></s= pan> &middo= t; Demographic Information<= span style=3D'font-family:Arial;color:black'>-exports Learning Disabled, = Physically Challenged, Exceptional, Speech,<o:p></o:p> Economically Challenged<= span style=3D'font-family:Arial;color:black'>, Migrant, ESL, Ti= tle 1 Math, Title 1 <st1:City w:st=3D"on"><st1:place w:st=3D"on">Reading</= st1:place></st1:City>, American-Indian, Asian,<o:p></o:p> Black, Hispanic, White, and Multi-Racial= .<o:p></o:p> Export Options<o:p></o:p></i= > &middo= t; Comma Delimited-exports as a .CSV file<o:p>= </o:p> &middo= t; Tab Delimited-exports as a .txt file<o:p>= </o:p> &middo= t; Quotes around Fields-uses quotation marks to separate f= ields<o:p></o:p> 7. Select the destination of where = the file will be saved and then click Export when finished. The file<o:p= ></o:p> will export and save to where it was directed to (e.g., My Documents, Desktop).<o:p></o:p> Exporting from Qwizdom TA (Teaching Assistant) Classes and Importing into Interact<o:p></o:p> Class lists must be exported from <= i>Qwizdom TA before you can import the class into Interact. If you<o:p></o= :p> already have class lists exported, = skip to the section where you begin importing the Qwizdom TA<o:p></o:p></= span> class into Interact. If you = do not have any classes created in TA, skip this section.<o:p></o:p>= Let's export a class list from Q= wizdom TA.<o:p></o:p> 1. Open Qwizdom TA and click= on the Students button.<o:p></o:p> 2. Double-click on the class you wo= uld like to export.<o:p></o:p> 3. Go to the File menu and s= elect Export.<o:p></o:p> 4. A prompt will appear asking '= Which do you want to export?'<o:p></o:p> 5. Select Students. The E= xport Students window will appear.<o:p></o:p> 6. Select the fields that have information such as Last and First Name, ID, Userna= me. Do not<o:p></o:p> export fields that are blank.<o:p><= /o:p> 7. Click on Export. An expor= t file window will appear.<o:p></o:p> 8. Find a location to save the clas= s and click on Save.<o:p></o:p> 9. It will save in a .txt fi= le format.<o:p></o:p> 10. Click the Quit button to= exit out of Qwizdom TA.<o:p></o:p> Let's import the Qwizdom TA = class into Interact.<o:p></o:p> 1. Open Qwizdom Interact; or= go to the Students tab.<o:p></o:p> 2. Go to the Class menu and = select New Class.<o:p></o:p> 3. Type in the name of the class al= ong with any other information you would like to fill out. <o:p></o:p></= p> 4. Click Done when class information entry is complete.<o:p></o:p> 5. Go to the File menu and s= elect Import, then Students. The Open window will appear.<o:p></o:p>= 6. Search for the exported class (i= t will be in a .txt file format) and select it.<o:p></o:p> 7. Click on Open. The Stu= dent Import window will appear.<o:p></o:p> 8. Select the appropriate columns f= or each field (e.g., Scott Jenkins; Scott goes into the First Name<o:p></o:= p> column, Jenkins goes into the La= st Name column). You only need to select the matching<o:p></o:p> columns for each field for one stud= ent to set all other students in the class. If you do not know or<o:p></o:p></span= > can't remember what the imported fi= eld is for, select it as 'None' in the Qwizdom Interact column.<o:p>= </o:p> 9. If the student's information app= ears under the Imported File column, uncheck the First Record is<o:p></o:p></= i> Header box. If there are heading names under the Imported File column, check the First Record<o:p></o:p> is Header box. The first record in the image = above is not a header so the box is unchecked.<o:p></o:p> 10. Click on Import when com= plete. The class will appear in the gradebook.<o:p></o:p> </div> </body> </html>

MIME-Version: 1.0 Content-Location: file:///C:/AC27B2D4/importing_exporting_class_list.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Importing and Exporting Class Lists and Students (User Guide, pp</ti= tle> <o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"place"/> <o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"City"/>  <style>  </style>  </head> <body lang=3DEN-US style=3D'tab-interval:.5in'> <div class=3DSection1> = Importing and Exporting Class Lists and Students (User Guide, pp. 42-46)<o:p></o:p></= span> = <o:p> </o:p> Class lists can be imported from <i= >Qwizdom Teaching Assistant (TA), Excel or grade book programs in .CSV= or .txt file format. <o:p></o:p> Importing a .CSV File into Interact= <o:p></o:p> 1. Open Qwizdom Interact and= click on the Students tab; or if Interact is already open, click on= the<o:p></o:p> Students tab.<o:p></o:p> 2. Go to the Class menu and = select New Class.<o:p></o:p> 3. Type in the name of the class al= ong with filling out other necessary information and click Done.<o:p></o= :p> 4. Go to the File menu and s= elect Import, then Students.<o:p></o:p> 5. Search for the file (should be i= n .CSV file format-comma delimited or it can be in a .txt file format).= <o:p></o:p> 6. Select the file and click Ope= n. The Student Import window will appear.<o:p></o:p> 7. You are able to drop down the fi= elds to select the information that will be imported. Be sure the<o:p></o:p></sp= an> fields on the right match up to the information on the left. See image below for example.<o:p></o:p> 8. Uncheck the 'First Record is = Header' if the first record aren't headers. As you will see the images<o:p></o:p></= span> above, the first record is not a he= ader. If the first record is a header, the information on the left<o:p></o:p></sp= an> will not have student information. = It will have the column heading information from where you are<o:p></o:p></spa= n> importing the file from (e.g., F= irst name, Last name, etc.). See image below.<o:p></o:p> 9. Click on Import. The crea= ted class will appear.<o:p></o:p> You have successfully imported a cl= ass!<o:p></o:p> Exporting Students from Interact in= to Excel<o:p></o:p> You are also able to export student= s into Excel, other gradebook programs, or into Interact on another<o:p></o= :p> computer.<o:p></o:p> 1. Open Qwizdom Interact; or= go to the Students tab.<o:p></o:p> 2. Go to the Class drop-down= menu and select the class you want<o:p></o:p> to export. The class you selected w= ill open.<o:p></o:p> 3. Go to File and select = Export then Students.<o:p></o:p> 4. The Student Export window= will appear.<o:p></o:p> 5. Select Student Information </= i>under 'What would you like to Export?' and Comma Delimited.<o:p></o= :p> 6. What would you like to Export= ?<o:p></o:p> &middo= t; Student Information-exports Student ID, Full= Name, Email, Gender, Current Level, Ability, Birth= <o:p></o:p> Date, Group Number, Remote Number, Class Comments, and Generic Comments.<o:p></o:p> &middo= t; Contact Information-exports Contact Name, Ad= dress, Phone Number, Email, and Contact Method.<o:p></o:p></s= pan> &middo= t; Demographic Information<= span style=3D'font-family:Arial;color:black'>-exports Learning Disabled, = Physically Challenged, Exceptional, Speech,<o:p></o:p> Economically Challenged<= span style=3D'font-family:Arial;color:black'>, Migrant, ESL, Ti= tle 1 Math, Title 1 <st1:City w:st=3D"on"><st1:place w:st=3D"on">Reading</= st1:place></st1:City>, American-Indian, Asian,<o:p></o:p> Black, Hispanic, White, and Multi-Racial= .<o:p></o:p> Export Options<o:p></o:p></i= > &middo= t; Comma Delimited-exports as a .CSV file<o:p>= </o:p> &middo= t; Tab Delimited-exports as a .txt file<o:p>= </o:p> &middo= t; Quotes around Fields-uses quotation marks to separate f= ields<o:p></o:p> 7. Select the destination of where = the file will be saved and then click Export when finished. The file<o:p= ></o:p> will export and save to where it was directed to (e.g., My Documents, Desktop).<o:p></o:p> Exporting from Qwizdom TA (Teaching Assistant) Classes and Importing into Interact<o:p></o:p> Class lists must be exported from <= i>Qwizdom TA before you can import the class into Interact. If you<o:p></o= :p> already have class lists exported, = skip to the section where you begin importing the Qwizdom TA<o:p></o:p></= span> class into Interact. If you = do not have any classes created in TA, skip this section.<o:p></o:p>= Let's export a class list from Q= wizdom TA.<o:p></o:p> 1. Open Qwizdom TA and click= on the Students button.<o:p></o:p> 2. Double-click on the class you wo= uld like to export.<o:p></o:p> 3. Go to the File menu and s= elect Export.<o:p></o:p> 4. A prompt will appear asking '= Which do you want to export?'<o:p></o:p> 5. Select Students. The E= xport Students window will appear.<o:p></o:p> 6. Select the fields that have information such as Last and First Name, ID, Userna= me. Do not<o:p></o:p> export fields that are blank.<o:p><= /o:p> 7. Click on Export. An expor= t file window will appear.<o:p></o:p> 8. Find a location to save the clas= s and click on Save.<o:p></o:p> 9. It will save in a .txt fi= le format.<o:p></o:p> 10. Click the Quit button to= exit out of Qwizdom TA.<o:p></o:p> Let's import the Qwizdom TA = class into Interact.<o:p></o:p> 1. Open Qwizdom Interact; or= go to the Students tab.<o:p></o:p> 2. Go to the Class menu and = select New Class.<o:p></o:p> 3. Type in the name of the class al= ong with any other information you would like to fill out. <o:p></o:p></= p> 4. Click Done when class information entry is complete.<o:p></o:p> 5. Go to the File menu and s= elect Import, then Students. The Open window will appear.<o:p></o:p>= 6. Search for the exported class (i= t will be in a .txt file format) and select it.<o:p></o:p> 7. Click on Open. The Stu= dent Import window will appear.<o:p></o:p> 8. Select the appropriate columns f= or each field (e.g., Scott Jenkins; Scott goes into the First Name<o:p></o:= p> column, Jenkins goes into the La= st Name column). You only need to select the matching<o:p></o:p> columns for each field for one stud= ent to set all other students in the class. If you do not know or<o:p></o:p></span= > can't remember what the imported fi= eld is for, select it as 'None' in the Qwizdom Interact column.<o:p>= </o:p> 9. If the student's information app= ears under the Imported File column, uncheck the First Record is<o:p></o:p></= i> Header box. If there are heading names under the Imported File column, check the First Record<o:p></o:p> is Header box. The first record in the image = above is not a header so the box is unchecked.<o:p></o:p> 10. Click on Import when com= plete. The class will appear in the gradebook.<o:p></o:p> </div> </body> </html>