MicroGrade Online is designed to allow administrators to upload data to the system from text files, including staff members, students and classes. If you can export student data from your school information system (SIS) into Excel, you can easily export that data from Excel into a text file for upload to MicroGrade Online.

To export a text file from Excel:

1. Open an Excel file containing the student data you wish to import.

2. Make sure the file only contains the following information and is displayed in this order: Student ID, First Name,Last Name,Email (optional), Password (optional). Note that the student ID MUST be unique for every student uploaded. If a student with that ID already exists in the system, their profile will be updated with the new student information you are uploading. If passwords are not assigned, the system will automatically generate a random password for each student.

3. Go to the File menu and click on Save As

4. The Save As dialog will appear. Enter a name for your file, such as "Students", then click the "Save As Type" drop-down menu at the bottom and select "Text (Tab Delimited)(*.txt)

5. Click the Save button to save your text file.

To upload a text file of students to MicroGrade Online:

1. Click the Manage Students link that appears on the right-hand side of the page under the My School header.

2. The Manage Students page will appear. Click on the Upload Students tab.

3. The Upload Students page will appear. Click the Browse button.

4. The File Upload dialog will appear. Locate the file you wish to upload and click on it to select it, then click the Open button to proceed.

5. Click the Field Separator drop-down and select the field separator that corresponds to your file (Pipe, Tab or Comma). In our example we created a tab-delimited file, so we will select Tab from the drop-down menu.

6. Click the Upload button and an upload progress page will display. The records uploaded will be displayed, along with any errors encountered. When the upload is completed, a button labeled "Click here to continue" will appear. Clicking this button will return you to the MicroGrade Online home page.