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 staff 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 staff data you wish to import.

2. Make sure the file only contains the following information and is displayed in this order: First Name,Last Name,Email,Staff Type. Note that the Staff Type must be spelled exactly the same as the corresponding Staff Type in MicroGrade Online. The default Staff Types in MicroGrade Online are: System Admin, Human Resources, Instructor, Grader, and Counselor.

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 "Staff", 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 staff members to MicroGrade Online:

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

2. The Manage Staff page will appear. Click the Upload Staff tab.

3. The Upload Staff page will appear. Scroll down to the bottom of the page and 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. If you like, you may also have MicroGrade Online send each new staff member their login information via email. Simply check the box labeled "Send password to new users" and an email will be automatically sent to the new staff members after they are uploaded.

7. 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.