Importing Grades to SIS from an External Gradebook

Importing Grades to SIS From an External Spreadsheet

By Nick Manning

Some teachers may find it a hassle to enter student grades one by one. So to help all you Teachers out, here is a blog showing you all how to import grades to SIS from an external spreadsheet.

Step One: Log into Tyler SIS. This can be accessed from the homepage of the school’s website (ashgrove.k12.mo.us)

Step 2: From the View/Maintain tab, select “End of Term Grading”.

Step 3: Click on Actions > Import Grades from External Gradebook.

sis-import

Step 4: Click the “Choose File” button to browse for the grade file to be uploaded.

The file should be tab-delimited with the following columns (but no headings):

Student ID Regular State ID

Course Code Subject+Section all together, for example H502003 (forH5010-03).

Term Code P=Progress, T or Q=Term, X=Exam, S=Semester

Letter Grade For example, A, B-, P, etc.

screenshot-2016-10-04-at-10-29-56-am

Step 5: Click the “Upload” button, a message will appear at the top left state the file was successfully Uploaded.

screen-shot-2016-09-23-at-10-31-24-am

Step 6: Click the “Import” button to complete the import.

Now you have successfully imported grades from an external gradebook and saved yourself a great deal of time.

Bio – Nick Manning

20160830_102530Nick (@ManningHelpDesk) is a Junior at Ash Grove High School and a student in the ASSIST help desk. He is brother to Lindsay Buckley, (@Lbuckley08) the Librarian at the Ash Grove School District in southwest Missouri. His dream is to attend college for computer science and make innovations in the computer and technology industry. His Google Apps Jam is working with Google Forms and creating polls and tests.

 

How to Efficiently Use Google Drive

How to Efficiently Use Google Drive

By: Nick Manning

Google Drive – Folders

Using Folders in Google Drive are an essential tool to staying organized and avoiding clutter.

  1. To do this, you would go to your Google Drive, (by going to drive.google.com in chrome) and click the new button on the left tab bar. When you do this, a pop-up should show up and you would click folder.
  2. After you do that, a pop-up will show up where it prompts you to name the folder.
    1. Tip: I recommend having a folder for each class, so do this for each of your classes.
  3. Now once you have those, whenever you make a document for a class, you simply right click on the document and choose, “move to” and then specify the folder.

ezgif.com-video-to-gif (3)

When finished, your folders should look something like this

Screenshot 2016-08-15 at 10.35.02 AM

Google Drive – Deleting Old Files

This is a fairly easy and common step in keeping your google drive orderly.

  1. When you think you do not need an old file anymore, all you have to do to delete it is right click on the file and choose remove.

    ezgif.com-video-to-gif.gif
    Tip: To delete multiple files at once, just click off of a file and drag your mouse across the files you wish to delete. This selects multiple files allowing you to interact with multiple files at once.

Google Drive – Starring Important Files

Starring important projects or files is very similar to deleting files

1. The only difference is that you choose, “add star” instead of remove.

ezgif.com-video-to-gif (2)

Google Drive – Recent Tab

Now over time, you’ll most likely to forget to put a document in one of your folders. So instead of spending precious time looking for said file, you can use your recent tab to better locate those lost files.

1. This tab will be in the left tab bar, and once you click on it, it will take you to the recent page. This page has the files sorted by date accessed, the most recently accessed files at the top and descending by last accessed.

ezgif.com-video-to-gif (1)

Google Drive – Name Files

In Google Drive, naming files are an important part of staying organized.

  1. To name a file you need to open/make a file
  2. Next no matter the file, the Title/name of the file will be in the top left of the page. To change it, all you have to do is click on the, “untitled” and type in your desired name.

    ezgif.com-video-to-gif (4).gif
    Tip: Name files intelligently by abbreviating class names for easy searching. For example, abbreviate English to Eng. or Algebra to Alg.

Bio – Nick Manning

20160830_102530

Nick (@ManningHelpDesk) is a Junior at Ash Grove High School and a student in the ASSIST help desk. He is brother to Lindsay Buckley, (@Lbuckley08) the Librarian at the Ash Grove School District in southwest Missouri. His dream is to attend college for computer science and make innovations in the computer and technology industry. His Google Apps Jam is working with Google Forms and creating polls and tests.