| MyGradeBook Help Menu |
|
Import Roster
Teachers that are in groups that are integrating with their schools Student Information System do not need to create and maintain their class lists. Teachers who are in a Group Account that has created a Master Student List instead of using full integration with their Student Information System can use the Import screen to automatically import students for their classes. Teachers who are not in a group account that has created a Master Student List must have a file on their computer that contains a comma separated list of students. Teachers in Group Accounts that have a Master Student List Group Account teachers can automatically import students into an empty class by using the following two steps.
The Import Screen allows you to import student demographic data into your class from a file located on your computer. The data in the file must be in a Comma Separated Value (CSV) format (a comma between each piece of data/column). If you can easily obtain a file from your school districts Information Systems department, the Import Screen can save you the time required to manually add the students. Importing a file Click the Browse button. A window should appear that allows you to locate your file. Once you have found your file, double-click it or click it and then click the Open button. The pop up window will automatically close and the name of your file should be listed to the left of the Browse button. Click the Upload File button to upload your file to the server. Terminology Row A row is one record (or line) in your file. A row represents the data for a single student. For example, a row in a file that has student Last Names and First Names would be represented as:
Column A column is a single piece of data about a student. In the example shown above, Krist is a column representing the students last name. Do NOT put a comma after the last column in a Row. The following lines represents what could be in a file of student Last Names and First Names you are importing into your class: Krist,Vincent Smith,John Edion,Thomas Crow,Mary Jones,Tracy Schaeffer,Molly Short,Sam Type of data you can import Every field (Last Name, First Name, Student DID, etc.) except citizenship grade and effort grade you see on the Student Screen can be imported from a file on your computer. Since the import screen eventually asks you to specify the order of the fields in the file you are uploading, the order of the fields within does not matter as long as the order is consistent for each row. File Format Restrictions These restrictions were put in place to help safeguard your data:
If your school district uses SASI, you can use the "Query" atom in SASI to create a comma separated file containing your student demographic data that you can import into your class at mygradebook.com. Middle or High School SASI query You need to know your section ID to run this query. EXPORT ASTU ACLS AMST PERMNUM FIRSTNAME MIDDLENAME LASTNAME IF SECTIONID = "your section ID" After you click the "DO" button, the Sasi EXPORT screen comes up. Change the field-delimeter from "TAB" to "Comma" and click the "Export" button. A dialog box will pop-up and ask you where to save the file and what you want to call the file. You can save the file anywhere on you hard drive. Elementary School SASI query You need to know your teacher number to run this query. **To ensure proper linking, make sure you drag and drop the "Advisor" column from ASTU to ATCH** EXPORT ASTU ATCH PERMNUM FIRSTNAME MIDDLENAME LASTNAME IF TCHNUM = your teacher number |
|