Blackboard's Grade Center is a great tool for keeping track of student grades, but it has a few limitations. By downloading course data from the Grade Center and importing it into Microsoft Excel 2007, we can excelerate its capabilities and create tools to use throughout the semester.
Today we will explore tools that you can utilize throughout the semester...
* Semester Start: Create a Sign-in Sheet
* During the Semester: Identify the Most-Frequently-Missed Questions
* End of Semester: Find Missing Student Submissions
* During the Semester: Identify the Most-Frequently-Missed Questions
* End of Semester: Find Missing Student Submissions
Knock it out with a one-two punch!
All of the following involve two steps:
1. Download Grade Center data.
2. Manipulate data in Excel.
1. Download Grade Center data.
2. Manipulate data in Excel.
Semester Start: Create a Sign-in Sheet
To create a daily Sign-in Sheet:
1. Download Bb Grade Center User Information. Instructions
2. Use the Excel template to format and print your Sign-in Sheet. Template
Let's practice. Use the sample download file and template to create a Sign-In Sheet. Sample download file
1. Download Bb Grade Center User Information. Instructions
2. Use the Excel template to format and print your Sign-in Sheet. Template
Let's practice. Use the sample download file and template to create a Sign-In Sheet. Sample download file
During the Semester: Identify the Most-Frequently-Missed Questions
To create a most-frequently-missed questions report:
1. Download Bb assessment results. Instructions
2. Use Excel to generate the report. Instructions
Let's practice. Use one of the sample download files to create a report.
Quiz 1 Sample Quiz 2 Sample Quiz 3 Sample
1. Download Bb assessment results. Instructions
2. Use Excel to generate the report. Instructions
Let's practice. Use one of the sample download files to create a report.
Quiz 1 Sample Quiz 2 Sample Quiz 3 Sample
End of Semester: Find Missing Student Submissions
To find missing student submissions:
1. Download Bb Full Grade Center. Instructions
2. Use Excel to identify missing items. Instructions
Let's practice. Use the sample downlad file to identify missing student submission. Sample download file
1. Download Bb Full Grade Center. Instructions
2. Use Excel to identify missing items. Instructions
Let's practice. Use the sample downlad file to identify missing student submission. Sample download file