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.
  1. Make sure the Class Screen has a Course Number matching the one assigned by your school.
  2. Click on the Toolkit tab and then click the Import link that is displayed under the Toolkit tab. When you click the Import link, all of your students are automatically imported.
What the Import Screen does for teachers who are not in groups with a Master Student List
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:

  • Krist,Vincent
Each row should be on a separate line.

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:
  1. Each row in your file must contain exactly the same number of columns.
  2. You must have at least a LAST NAME and a FIRST NAME column in the file you are uploading. In addition, the LAST NAME and FIRST NAME values for each student you are importing must have a value (cannot be blank).
  3. The maximum lengths for each column are shown below.
    • ID 15 characters.
    • FIRST NAME 20 characters.
    • MIDDLE NAME 20 characters.
    • LAST NAME 20 characters.
    • PASSWORD 10 characters.
    • ENROLLMENT DATE 10 characters in the date format used by the country you specified in the Internationalization Preferences section of the My Account screen. Based on your current settings, you would use mm/dd/yyyy.
    • DROP DATE 10 characters in the date format used by the country you specified in the Internationalization Preferences section of the My Account screen. Based on your current settings, you would use mm/dd/yyyy.
    • EMAIL ADDRESS 50 characters.
    • HOME PHONE 15 characters.
    • FATHERS NAME 30 characters.
    • FATHERS PHONE 15 characters.
    • FATHERS EMAIL 50 characters.
    • MOTHERS NAME 30 characters.
    • MOTHERS PHONE 15 characters.
    • MOTHERS EMAIL 50 characters.
  4. The class you are trying to import students into must not have students in it.
  5. The maximum number of students you can import into a class is 150.
  6. Dates should be in the date format used by the country you specified in the Internationalization Preferences section of the My Account screen. Based on your currently specified country, you would use the mm/dd/yyyy format. For example, 08/10/1999 is valid. Any invalid dates in your file are imported as blanks.
Notes on Importing Data from SASI
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


Privacy | Terms of Use | Link To Us | Help | Contact Us
© 1999 - 2017 KMKVGK Inc. All rights reserved
Ver 11.66 - GB - Page generated in 0 seconds