Alphabetizing Excel files from PointSolutions
considering
C
Chris Gordon
The only issue I have constantly is that the PointSolutions data that I export as an Excel file is not alphabetizing common names. For example, I have three "Smiths" in one class and the exported data is not alphabetized. I have to manually reorder the names to past the data into my Excel gradebook. Uploading the grades to Canvas is no problem, but I do not let Canvas average grades. Instead, I use Excel to average and drop grades, so I need the data alphebetized properly. It would be easier if there was some way to add a number to the end of a name to always keep it in the proper order. This was possible when I used the iClicker" devices in class. I also liked the option in iClicker of being able to toggle back and forth during polling whereby I can show the number of students choosing the different choices on a quiz, but then making the chart disappear before the end of the time allocation. Is getting the names alphabetized and having this last option possibilities for the PointSolutions clicker?
Hannah Petty
Merged in a post:
Sync Point Solutions with my Canvas course
R
Roger Kugel
Class roster came up in Point Solutions alphabetized by FIRST names. I don't know how to correct that or to get started with the polling software in class.
Hannah Petty
Merged in a post:
Alphabetizing rosters
C
Chris Gordon
"One question I have relates to correctly alphabetizing the names when downloading Excel files to my computer. Every semester I have students with the same last name, but the data is not always alphabetized properly. I assumed the clicker data would be ordered the same way the names show up in Canvas since the names are taken from Canvas. This has been an issues for quite a few years. When I used iClicker, I was able to add numbers to the beginning of names when there were multiple students with the same last name. Representatives from Echo360 have been told this for several years but the problem still persists."
Hannah Petty
considering
Chris Patrone
Merged in a post:
Not alphabetizing respondents
C
Chris Gordon
I am enjoying using the PointSolutions clicker but am still wondering why my students' names cannot be alphabetized properly when downloading grades in an Excel spreadsheet. This has been a problem for several years where I have students with the same last name, and although Canvas alphabetizes the names properly, about half the time PointSolutions does not. Any updates on this? Thanks.