Tell Me
There are some assignments that instructors distribute that are collected in person, and can't be submitted electronically through Blackboard. Instructors should still record the grades for these assignments through the Gradebook. This process may become tedious for instructors who teach multiple sections of a course with distinctly different groups of students. Downloading the Gradebook and re-uploading the Gradebook simplifies this process when working with Excel.
...
2. Under Details & Information in the Assignment Settings ensure that you have the box Collect offline submissions checked off
4. Under Data ensure that Select columns is checked off, then click on the assignment you are collecting offline. Note, if you don't see your assignment in the list, click Show more.
Optional: if you want to provide feedback in the Excel workbook, check Include feedback for the selected column. Click Download
5. Open the file in Excel and edit the grades. Save the file as either .xls or .csv.
| Warning | ||
|---|---|---|
| ||
Excel's native filetype, .xlsx is not compatible to be uploaded into the Gradebook. It is important to upload either an .xls or .csv file type |
6. Upload the .xls or .csv file to the Gradebook
7. Ensure that the column being uploaded is the name of the offline assignment you wish to assign grades. Click Upload
8. Find the assignment in the Gradebook and Post grades
...
2. Under Data ensure that Full gradebook is checked off.
3. Open the file in Excel.
4. Click on Column A then hold the SHIFT key on your keyboard, and click on Column B, and Column C. All of the data in Columns A, B, and C (Last Name, First Name, Username) should be highlighted.
5. Click on the Edit menu, then Copy
6. Create a new Excel worksheet. Click on the File menu, then New
7. With the new worksheet open, click on the Edit menu, then Paste
8. With Row 1 as column headers, create assignment names in cell E1, F1, G1, etc. Award points to students per desired assignments. Save the new workbook as a .csv.
9. Upload the .csv file to the Gradebook
10. Ensure that the column being uploaded is the name of the offline assignment you wish to assign grades. Click Upload
11. Find the assignment in the Gradebook and Post grades
| Info | ||
|---|---|---|
| ||
By default, offline assignments are worth 100 points. This can be changed before the instructor posts grades by locating the assignment in the Gradebook, clicking on the three dots on the far right, then clicking Edit. The category weight of the assignment can be changed from this menu as well. Click Save when finished.
|
| Info | ||
|---|---|---|
| ||
| Info | ||
|---|---|---|
| ||
Suppose a lecture course with multiple lab sections have the same assignment that is turned in as a physical copy at the beginning of the lab that is graded by TAs. After Creating an offline assignment in Blackboard and/or Uploading new offline assignment scores from Excel, the TA can delete the rows of students not enrolled in their section from the Excel workbook, and upload the grades to the Gradebook. The Gradebook will be ready to post the grades of the students that were uploaded from the Excel file. These steps can be repeated by the other TAs of the other sections. Then, all of the grades can be posted at once, using Post grades. |
...
| title | Warning: Don't Overwrite Your Grades! |
|---|
If the rows of student names are not deleted, the grades will be overwritten when a new file is uploaded to the Gradebook.
If a student name appears in the workbook, they must be assigned a grade. If a grade is not entered for a student listed, they will receive a 0.
If a student name does not appear in the workbook, then no grade will be uploaded to the gradebook.
...
Collect submissions offline
You can create assessments that appear on the Course Content page that don't require students to upload submissions. You can add instructions, files, a rubric, and goals so students can prepare for the offline work. You can also enable conversations, but you can't add questions or grade anonymously.
Examples of offline work:
- Oral presentations
- Science fair projects
- Acting performances
- Artwork delivered in person
- Face-to-face team building exercises, panel discussions, and debates
Instructors who teach hybrid courses may find this type of assessment most useful. For example, you can use a rubric to grade an in-class presentation as a student presents. No need to take notes or add a score later.
When you create an assessment, you can choose to collect submissions offline in the settings panel. When students open this type of assessment, they're informed they can't submit work online. If you create groups to collect submissions offline, students can view their group members.
For submissions collected offline, you can't allow multiple attempts, allow a time limit, or use SafeAssign.
For grades that require students to be present outside of class, such as for a guest speaker or a field trip, you can add meetings to the attendance feature.
Grade offline submissions
When you're ready to grade offline submissions, open the submissions list page from the assessment page or the gradebook. Select a student's name to open the Create Attempt panel, provide the submission date and time, and save.
On the student's submission page, you can assign a grade and use a rubric if you associated one.
What do students see?
Students can view the assessment alongside other content on the Course Content page and on their global and course grades pages. Students are informed they can't submit work online. They can access other information, such as the instructions and a rubric if you added one. Students can participate in the assessment's conversations if enabled.