Menu +

Search Posts

Export Pilot Grades to Banner

Step 1:  Grade Settings

Click on Grades on the Navigation bar and then on Settings, found in the upper, right corner of the screen.

On the Grade Settings page, click on the Calculation Options tab.

Under the Final Grade Released section, select Adjusted Final Grade. If the Adjusted Final Grade is already selected, you don’t have to change this setting.

If the Grade Calculations option is set to “Drop Ungraded Items”, be sure that you have filled in zeroes in all of the grade columns that don’t contain grades. Or you could change the setting to “Treat ungraded items as 0”.

Click Save at the bottom of the page.

Step 2: Change Scheme to a Letter Grade

The final grades you submit to Banner must be letter grades. If your final grades display as percentages, as they will by default, you must change the “Grade Scheme.”

On the “Manage Grades” page, click the triangle next to “Final Adjusted Grade” and choose “Edit Grade Item.”

On the “Edit Adjusted Final Grade” page, change the “Grade Scheme” to “Organizational Letter Grade,” (or to a custom letter grade scheme, if you have one).

Click “Save and Close.”

Step 3: Transfer Final Calculated Grades to Final Adjusted Grades

Open the Enter Grades view in the Grades tool.

In the Final Calculated Grade column, click on the down arrow and select Enter Grades.

Click on the down arrow beside Final Grades (at the top of the page) and select Transfer All.

Step 4: Adjust Final Grades (Optional)

You can adjust grades in the Final Adjusted Grades column. Note that Pilot does not round up when calculating a grade that ends in .5, so you will have to make that adjustment manually.

Step 5: Release Final Adjusted Grades

When you are satisfied with the grades in the Final Adjusted Grade column, go back up to the top of the page and, again, click on the down arrow beside “Final Grades”. This time, select Release All from the menu. This action releases the final grade to the students.

Click Save and Close at the bottom of the page.

A Confirmation window will pop up. Click on Yes to release the grades.

To verify that the grades have been released, open the Enter Grades view. In the Final Adjusted Grade column, an icon next to each grade indicates that the grade has been released. If you see this icon with a line through it, go back and repeat Step 4.

Step 6: Export Final Adjusted Grades to Banner

The final step is to Export the grades to Banner. From the “Enter Grades” view, in your Gradebook, click on Export Grades to Banner. If you don’t see this option, verify that you are the faculty of record in Banner for this course. Only the faculty of record can submit final grades.

A list of your students with their Adjusted Final Grades will be displayed. Check over the grades. If you need to make any changes, enter them under the Override Grade column,

Also, please note that there are three columns on the Export Grades screen that for the time being should be ignored: Last Attendance Date, Default Incomplete Grade, and Incomplete Extension Expiry Date.

To complete the grade submission to Banner, click on Export in the bottom left corner of the page.

When the grade transfer is complete, an Export Details page will appear and in the Result column it should say “Accepted by SIS.”

You can also verify that the grades were submitted by logging into Wings Express and, under the “Faculty” tab, open “Faculty Grade Summary.”  You have one hour to change any grades that you have submitted. After that time, you’ll have to click on “Change Grade” beside the student’s grade and complete and submit the form.

If you have any problems with grade submission, or if you have questions, call the CTL at 937-775-2885 and someone will assist you.