Use Excel to Grade
The simplest way to upload grades to BbLearn is to first download the Grade Center so that you have the correct format. You may then edit and print your grades offline, having full access to Excel's advanced formula calculations before uploading the modified grades back into BbLearn. Customized formula calculations are not offered as an option in BbLearn's Grade Center and must be done offline.
(2:39 min video)
Step 1: Create Columns
It is a little easier, but not required, to create columns in BbLearn prior to downloading the Grade Center scores for use in Excel. Columns added externally to BbLearn must be edited after they are uploaded to a) change the primary display from Text to Score and b) enter the Points Possible.
- From the Control Panel, click on Grade Center.
- Select the Full Grade Center.
- Click the Create Column button.
- Enter a Column Name (e.g., Participation).
- Select your Primary Display option as Score, Letter Grade, Text, Percentage or Complete/Incomplete or your own Letter Grade Schema.
- You may set a Secondary Display for your own use in the Grade Center. This will not display to the students. more...
- If you plan to weight your columns or calculate your grades within BbLearn, you may want to categorize your column as well.
- Set the Points possible, or select a Rubric. more...
- Select Yes if you want to Include the column in Grade Calculations.
- Select Yes if you you'd like to Show the column to your students.
- Press Submit to finish.
- BbLearn will display a Success message indicating the column has been created.
- Using the Scroll bar at the bottom of the Grade Columns, scroll to the far right to locate the new column.
- If you plan to work in Excel throughout the sememster and upload columns of grades into BbLearn for students to view, download BbLearn's Grade Center at the beginning of the semester in order to add BbLearn's required elements (Username Column, Header Row) to your Excel spreadsheet.
- Under Data, select Full Grade Center.
- Under Options, select Tab next to Delimiter Type. (Comma will also work.)
- Under Options, select Yes next to Include Hidden Information (optional).
- Under Save Location, select My Computer.
- Press Submit.
- Press the Download button.
- If you'd like to Open the file in Excel you can. Otherwise, select Save File, and select where you'd like to save the file.
- TIP: Take note of where you save the file for future reference.
Step 3: Work in Excel
- When you open the downloaded Grade Center file in Excel, you may receive a warning about file type. Click Yes.
- Required elements of the Excel spreadsheet can be distilled down to a Username (UI Account) column and a Header Row as follows:
- USERNAME column MUST contain the BbLearn Account for each student (e.g., smit1234).
- HEADER ROW MUST be the first row in the spreadsheet and MUST contain a valid column name for each column in use (e.g., use 'Username' for the student username column). If a corresponding column already exists in BbLearn, the column name should contain a column ID number which is required during import to correctly sync with its corresponding BbLearn column ( e.g., 'Assign1 [Total Pts: 10] |88423' ).
- Whenever you add a new column to your spreadsheet, we recommend also creating a new column in BbLearn's Grade Center because any Excel columns that do not exist in BbLearn will be imported as text columns with incorrect settings. Once the new columns are built in BbLearn, download the grade center data to obtain the corresponding column ID number's for your new columns. Add these column ID numbers to your Excel spreadsheet before you attempt to upload your data.
- Save this file as an Excel Spreadseet (.xls or .xlsx).
- You may do some or all of your grading using this Excel spreadsheet throughout the semester. You may even use Excel's advanced formula calculation capabilities, if needed, to manipulate your grades.
Step 4: Save as TXT file
- When you wish to upload your Excel spreadsheet data back into BbLearn, Save the spreadsheet as a Text Tab Deliminated (.txt) file.
Step 5: Print Grades (Optional)
The instructions below for printing are Optional, and can be modified to best suite your needs.
- You can quickly expand all the columns to fit their content by clicking the top left gray cell in the spreadsheet. This will automatically select all cells in the spreadsheet.
- Under the Home tab, click on Format, select AutoFit Column Width.
When printing a large spreadsheet it's useful to repeat the top header rows, and even side columns so that you can figure out what the data means on each sheet of paper. Here's how:
- Click on the Page Layout tab in Excel.
- Click Print Titles.
- From the Page Setup pop-up window, under the Sheet tab, click the button on the right side of the Rows to repeat at top.
- Click on Row 1 of your spreadsheet.
- Press the button on the right side of the Rows to repeat at top field. It will automatically load the $1:$1 into the Page Setup field.
- From the Page Setup window, Sheet tab, click the button to the right of the Columns to repeat at left.
- Then click on Column A (use shift key to select multiple columns).
- Press the button on the right side of the Columns to repeat at left field.It will automatically load the $A:$-- into the Page Setup field. In the example below, I selected the first three columns, A, B, and C.
- Press the Print button.
- Change to Landscape Orientation.
- Press Print.
Step 6: Upload Grades to BbLearn
- From the Control Panel, expand the Grade Center.
- Click Full Grade Center.
- On the upper right side of the screen, hover over the Work Offline button.
- Select Upload.
- Click Browse My Computer to locate the Excel Spreadsheet.
- Locate the Excel spreadsheet which has been saved as a Text Tab Deliminated .txt file.
- Press Submit to upload the file.
- BbLearn will display the columns it's uploading, and show you a preview of the data it will be adding.
- Press Submit to finish importing the data.
- BbLearn will display a message indicating the number of Total Grades Uploaded or modified.
- Review the columns that you changed to ensure they are correct.