Instead of entering grades via an "online final grade form," it's also possible to upload a specially-formatted Excel file (with column limitations) containing your final grades. This method will be recommended for larger classes. Note: the process may be somewhat complicated for novice and intermediate users of PeopleSoft, so instructors of medium/small classes may find it more time-expedient to individually enter grades electronically with the online final grade form instead.
1 |
Log in |
http://my.UCF.edu |
2 |
Select |
Faculty/Advisor Self-Service |
3 |
Select |
Instructors |
4 |
Select |
View My Teaching Schedule |
5 |
Click on icon |
My Grade Roster |
6 |
Click |
"Upload Grade Roster" (word link at the top of the page) |
7 |
Click |
Download (next to the class you want) |
8 |
Click |
"Save as" and CTRL simultaneously. Save file to desktop. |
9 |
Open |
File saved in step 8 with Excel |
10 |
Copy and paste |
Final grades from your Excel, myUCF, or Webcourses gradebook to the roster opened in step 9 |
11 |
Save |
As .csv file to your desktop (Mac users: you must save as filetype "Windows Comma Separated" csv for it to work) |
12 |
Click |
YES when asked about lost functionality |
13 |
Click |
UPLOAD next to the class (still open from step 6) |
14 |
Click |
BROWSE to locate file you saved in step 11 |
15 |
Click |
UPLOAD |
16 |
Monitor |
Progress of upload by clicking STATUS repeatedly until finished |
17 |
Review |
Each student grade status in the window near the bottom |
18 |
Click |
GO TO APPROVE |
19 |
Correct |
Errors or omissions using the electronic final grade form (you may want to "display unassigned roster only") or by correcting the .csv file and uploading it again |
20 |
Switch |
Roster Approval status to Approved (at top) |
21 |
Click |
SAVE (at bottom) |
22 |
Click |
Export grades to Excel (or "Printer Friendly Version" near the bottom) |
23 |
Save |
Excel file of the submitted grades for your records |
Click here to read the detailed instructions (where these 23 steps are explained in more detail), as well as a list of common problems and frequently asked questions.
There is no direct download from Webcourses to PeopleSoft. However, it is possible to download the grade book from Webcourses to your local computer, and also download the official grade roster to your local computer, and then use the grade book to (very carefully!) paste just the final grade into the grade roster for re-uploading as per the instructions above.
Note that you can export the gradebook in CSV format, but you must be cautious about matching up lines of students with your grade roster. Students with W's will *not* be listed in these gradebook downloads; you must manually insert a line and add the student name (just paste from the end-of-semester grade roster, complete with W). You will also need to check whether your downloaded gradebook includes a line for TEST STUDENT. If so, it will need to be deleted to make your students line up. At the end of the spreadsheet, you will see three columns (Current Score, Final Score and Final Grade). The final letter grade will correspond to the value in the Final Score column, which may not be the same as the value in the Current Score column. Different values in the Current Score and Final Score columns indicate ungraded assignments in the gradebook.
Instead of pasting (which can be dangerous), we recommend that you electronically "match the NIDs" and cause the correct grade to be dropped in. This can be done via Excel (see below), but is even more convenient using the "UCF Grades Transfer" program.
If you lack Microsoft Access, you can accomplish NID-Match by Excel ("vlookup" table) rather than the downloadable program, using these steps:
A new procedure for incomplete grades was instituted in Summer 2008. Paper forms are no longer used, and a fully-electronic form has taken their place. Faculty members initiate the online I-grade form. Go to "View My Class Rosters" and find a link for Incomplete Grade Form below the list of your classes. The next page has two tabs (one for finding an existing form, and one for generating a new one). If making a new one, enter the student's ID number (which is their PID minus the initial letter). For Spring 2009, the term is 1350. The five-digit Class Nbr can be found under "class detail" on the list of your classes (i.e., the underlined link of your class name).
A form will be created. When you complete the sections and save the form, an email will be sent to the student (but not to your department). Your College does have access to these forms. Check with your department or College to see if they request additional action from you.
This video shows you the grade uploading process to PeopleSoft from start to finish.
Contact the Registrar's Office (grades@ucf.edu; 407-823-5510) for online grading assistance, such as missing rosters or missing students, and questions about policy. Contact the Faculty Center (fctl@ucf.edu; 407-823-3544) for questions about how to use the tools for online final grade submission.
Suha Saleh
College of Health and Public Affairs
As a teacher, I learned that students are motivated not only by enthusiasm but also by organization, clarity, scholarship, and good teaching techniques of classroom conduct. Motivation is as important as intelligence in influencing student learning. Studies have found that motivation ranks above intellect, peer ...
Kimberly Renk
College of Sciences
Teaching is a critically important part of my position at the University of Central Florida. Whether I am teaching undergraduate-level courses, working with students through independent study, or mentoring students in their Honors research, I feel strongly that students deserve to learn in a respectful and non-th...
Ernest Smith
College of Arts and Sciences
When I began my full-time teaching career, the first text I taught was from Paulo Freire's Pedagogy of the Oppressed, where the Brazilian educator contrasts "problem-posing education" and "the banking concept of education." According to Freire, the key to education is dialogic learning, rather than the one direct...