Forum topic

3 posts / 0 new
Last post
mzirkle
Last seen: 3 years 5 months ago
Joined: 05/09/2019 - 14:14
Degree Track in Enrolled Student Report

Good morning,

When we run the enrolled student report, all degrees are showing up in the "Degree Track" column. So there are multiple degrees listed within one column, which makes it hard to sort. We recently "ranked" the degrees in their records, so is it possible to have multiple columns so that we don't have all of the degrees in just one column? For example, have degrees ranked "1" in one column, degrees ranked "2" in another, etc.

Thank you!

 

Megan Zirkle

Status: 
Answered
No votes yet
dparker
Last seen: 14 hours 45 min ago
Joined: 05/17/2019 - 21:42
@mzirkle

I will open a task and see if we can come up with a good solution.  

Dana

No votes yet

*GNECsis Support Specialist*

dparker
Last seen: 14 hours 45 min ago
Joined: 05/17/2019 - 21:42
Enrolled Student Report - Split out Multiple Degrees

The Process for updating the Enrolled Student Report to do what you asked would be a large change that can not be updated easily.  The process to move the values into columns is very easy in Excel and I am putting the instructions below. 

Here is a short video of Splitting the Degrees out into columns:  https://www.dropbox.com/s/9ojt9hq64xiefd9/Academics%20-%20Enrollment%20R...

 

Also here are the instruction steps for Excel:

  1. To the right of the Degree Column add 4 new columns.
  2. Highlight the column that contains the Degrees.
  3. Go to Data > Text to Columns.
  4. Choose Delimited. Click Next.
  5. Choose Comma. Click Next.
  6. Choose General or Text, whichever you prefer.
  7. Leave Destination as is, Click Finish.
  8. Press OK if you receive a warning about replacing data.
No votes yet

*GNECsis Support Specialist*