Skip to main content

Skyward Tech Tip: Exporting Student Names from Skyward to a Spreadsheet

Sometimes you need to quickly get a list of your students names in order to add them to a spreadsheet.  Luckily there is a very simple way to do this in Skyward.  Here we go...

Step 1: Login to Skyward and select the blue gradebook for the class you want to get the names from - elementary staff, you can just select any of your gradebooks.


Step 2: Go to the reports menu at the top of the screen and select Class Roster.

Step 3: Choose Student Name & Student Info, then select Clone Template.

Step 4: Give your new template a name, such as Student Names.  Click Save.

Step 5: Select how you want the Names to Display, select None for the ID Display, then UNCHECK all the boxes.   Click Export to Excel.

Step 6: The report will open the Print Queue and it will look like the report is running to print.  Then the file will appear as a .csv at the bottom of the window. 

Step 7: Open Excel, or Google Sheets.
In Google Sheets: Click the File Menu.  Select Open.  Choose Upload and select the file.

Optional: If you want to separate the first from last names in Google Sheets, click the column where the names are (ex: A).  Go to the Data menu.  Select Split Text to Columns.  This will put the first names in one column and the last names in another.

Once the names are how you want them, you can now copy and paste them into any other spreadsheet.

Popular posts from this blog

Google Docs: Fonts for Early Elementary

Sample of search results from fonts.google.com A couple weeks ago, I was sitting in a training with a bunch of my favorite lower elementary teacher friends, and several of them were lamenting the fact that it is hard to find "good" Google fonts for the little people they work with on a daily basis.  Specifically, it is a challenge to find the single story lower case a and the open 4 .  This conversation, of course, sent me out on a mission to remedy this for these fantastic people.  So, the next day I put on my headphones, turned up the tunes on Spotify, and dived into the website fonts.google.com .  This website lists all the Google fonts available.  It also allows you to type in your own letters and numbers and see them in all the various fonts.  For my purpose, I typed in "abckgy 1234 This is the font."  From here I could see all 877 fonts, and look specifically for the a   and the 4.  It was quite an adventure, and I came across a lot of really awesome font

It's time to change your password!

There are several times a year when it is important to change your password.  Your password will expire every 90 days. When your windows computer informs you that your password will be expiring soon, CHANGE IT THEN! It is also always a good idea to change your password before going on break so that you do not get locked out of your computer, email or gradebook.  Here is how you change your password from the school windows computers. On your Windows desktop/TEC computer , press the Alt, Ctrl and Delete buttons at the same time. Click on "Change a Password" on the menu below: Enter your username, if needed, and follow the directions on screen. If you are off site or working solely on a Chromebook , you can use the VDI (Virtual Desktop) to change your password.   Simply go to vdi.portageps.org.  Click "VMware Horizon HTML Access."  Click "Accept."  Login with your portage username (leave off the @portageps.org) and password.  Click "Login."  Cli

Skyward Tech Tip: Unlocking a Closed Grade Period

Have you recently attempted to change a grade from last quarter only to be met with the statement “ This Grade Period is closed for Grade Entry “? This occurs because the date for the end of a marking period or quarter has past and that grading period has been locked in the Skyward Gradebook. Below you will find the process for changing term grades, assignment scores, and other information from past grading periods. Google Docs Version Go to your gradebook Let’s start with the gradebook for the class where you need to make a change. In this example, we will be adding a score to a missing assignment and removing the incomplete grade from the quarter grade. (Note: The process to open or unlock the gradebook is the same regardless the change you need to make.) This change will be made for marking period three, Q3. In that marking period column, click on the “Options” dropdown button. From the Options dropdown, choose “Grade Posting Status for Term QX”, whe