ANGEL Community Hub

I have been having a really hard time with importing grades from an Excel Spreadsheet. A professor has the grades for his first exam in an excel spreadsheet. He has his grade book set up properly on ANGEL. First I tried importing the xls file, and following the directions I found on a previous blog posting (setting the column values). Unfortunately every column only gives me the option to skip. Then I tried saving the spread sheet in CSV format...same thing. Next I tried exporting the grades into a CSV file, and then simply copying and pasting them over from the xls file. Then when I tried re-importing this file, it wouldn't take the new grades. I can't think of anything else to try. Any ideas?

Hello everyone,

In one of my courses I had to make a duplicate copy of the lesson quizzes and assign them to just one student. So basically, the rest of the class has access to the original lesson quizzes, and then that one student has access to the duplicate copy. Now I'm not quite sure how to set up the gradebook. Say for Lesson 1 Quiz, should I create two assignments in the gradebook? However that means the rest of the class can see two Lesson 1 Quiz in their Grades report. I thought of in the Assignment advanced settings, link Lesson 1 Quiz assignment to both copies, and set the "Calculation Type" to be "Maximum score." That way, the gradebook should only record the quiz that a student actually took, but there is no Preview Tool for me to tell if this works.

I ran into an issue in a course today where the total number of points in the gradebook for a drop box assignment was 10. When the instructor graded the assignment in the drop box, she used a total of 100 points. If she gave someone 97 points in the drop box, it showed up as 970% in the gradebook because the grade is based on 10 points rather than 100. After much trial and error, I was able to correct the problem...sort of. It seems like this would have been much easier if I could have set the points to 100 and automatically regraded the drop box submissions the way you can quizzes. Has anybody else ever dealt with the type of issue?

Students have two options if they want to see grades on ANGEL:

Option 1: Report tab -- choose Grades under Type . This option displays the overall but not the class average of each assignment.
Option 2: Report tab -- choose Learner Profile under Type , and Gradebook under Select Data. This option displays the class average ("course average") but not the overall grade.

If an assignment is hidden ("Do not allow users to view this item" checked under Edit - Access ), students will not be able to see their grades if they use Option 2, however, Option 1 won't be affected.

Is there a way to let the professor decide whether class average should be displayed in Option 2? I have a few faculty members not wanting to show the class average.

By default the gradebook factors in everyone's scores when calculating category and overall averages. This means there is the potential to inadvertently skew class averages because, depending on the gradebook settings, scores for course editors, assistants, and authenticated guests are factored into the category and overall average calculations. This is true even if you select the "Only Students" option to view grades. However, there is a way to remove all non-students from the average calculation.

The following notice was sent out by ANGEL Support. Please note that the problem has been corrected and all course editors have been notified.

Notice to Instructors and Course Editors that grades are now correct and
being properly calculated when using the "Treat Ungraded Items as Zero"
Option in the ANGEL Course Gradebook.

Grades were not properly calculated when all of the below options were
selected:

1. Your gradebook mode is percentage,

2. You have selected the "Treat Ungraded Items as Zero" option, and

3. You are dropping grades, e.g. drop the lowest score in a category.

The problem has been fixed and in these instances the gradebook is now
correctly dropping the lowest score for the student. If you have any
questions or concerns, please contact ANGEL Support.

Please see the following announcement:

http://tlt.its.psu.edu/news/index.html#ANGELGBpoints