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. If a student name appears in the workbook, they must be assigned a grade. If a grade is not entered, they will receive a 0. If a student name does not appear in the workbook, then no grade will be uploaded to the gradebook.
If you are using this tool, make sure you delete student rows to prevent from losing your grades!Instructors can create assessments that appear on the Course Content page that don't require students to upload submissions. Instructors can add instructions, files, a rubric, and goals so students can prepare for the offline work. Instructors can also enable conversations, but can't add questions or grade anonymously.
Examples of offline work:
Oral presentations
Acting performances
Artwork delivered in person
Face-to-face team building exercises, panel discussions, and debates
Offline assignments also support the grading process. For example, instructors can use a rubric in Blackboard to grade an in-class presentation as a student presents. This assignment type eliminates the need to take notes outside Blackboard or add a score later.
| Info |
|---|
Offline Assignments vs. Manually-Created Gradebook ColumnInstructors also have the option to create gradebook columns manually. However, creating an offline assignment allows instructors to provide assignment details and use the same feedback options for Ultra assignments that are submitted online, including using a rubric to grade the assignment. |
Create an offline assignment
Tell Me
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.
Create a new Assignment. Include assignment instructions or details and attach files (if applicable).
Select the Assignment Settings (gear) icon.
Select "Collect submissions offline."
Configure other assignment settings, such as setting a due date and associating a rubric.
Grade offline submissions
Tell Me
When you're ready to grade offline submissions, open the submissions list page from the assessment page of the gradebook.
Select a student's name, which will open the Create Attempt panel.
Provide a submission date and time, and select "Save."
On the student's submission page, you can assign a grade, use a rubric if you associated one, and provide assignment feedback.
| Info |
|---|
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. |