Change Worksheet

Document Sample
Change Worksheet Powered By Docstoc
					                              DO NOT CHANGE WORKSHEET NAMES OR ORDER!                                                                 This page may be printed.
          Purpose: to place a new column into your existing Excel grade sheet that contains each student’s Blackboard Vista user name. Blackboard requires this
                   name for Coast District Colleges in order to import grades from the spreadsheet into Blackboard.

   One Time Step: From the File menu select Save As…, Selecting Template(.xlt) from the Save as type: dropdown box. Close the current Excel File.
           Step 1 From the File menu select New…, from the New pane (the pane should appear to the right after clicking New…) select On my computer…, from the
                  Templates window select BbV Upload.xlt
           Step 2 On your grade sheet, name the column that contains banner student id numbers: ID and the "letter grade" column: Final
                         Note: If your spreadsheet comes from a ParScore download you do not need to rename the ID column as the ParScore default will also work.
             Step 3 Copy your Excel grade sheet into the Scores worksheet (Green Tab)
             Step 4 Copy the full Banner class roster that includes emails (downloaded as an excel file) into the Class Roster worksheet (Yellow Tab).
                       DO NOT MAKE CHANGES TO THIS ROSTER.
             Step 5 Run the macro. Click the button below. (Alternative: Select Tools\Macro\Macros\Format_4_BlackboardVista and click the run button)
             Step 6 Save as *.CSV From the File Menu perform a Save As, selecting CSV (comma delimited) (*.csv) from the dropdown box.
                       Import into Blackboard

  Important Note: An error message displayed at the conclusion of the macro means one or more student user names must be hand entered into the scores
                  worksheet (error will be the current user name). Find the student’s email from the Banner download. The user name is the portion before the @
                  sign. If there is no email name listed you may later check to see if the user name is listed in Blackboard. If blackboard has no user name, the
                  student’s scores will not be imported. Remember to hand enter these scores.)

About Blackboard: Every class has a Blackboard account even if never accessed. For a new class you must pass two initial screens. On the first screen press
                  continue (set up blank course). On the second screen scroll to the bottom and select Save (no need to add anything). Open the Blackboard
                  account for the class. Select the “Teach” Tab near the top of the screen. Select Grade book from the choices on the side. (See below for onetime
                  set-up of Final Grade Column.) Look for the button near the middle, top of the grade book that says “Import from Spreadsheet”. After import the
                  grades will not yet appear in the grade book. Click “Grade Book Options” at the upper right of the grade book. Then select column settings. The
                  easiest way to display many columns at the same time will be to check the select all box at the left end of the gray/blue title bar then scroll to the
                  bottom and select “release”. If you really are not ready for students to see these yet, repeat the process by checking the select all box but then
                  select “do not release” from the bottom. You may return to your grade book to see your import results by clicking the “back” arrow (under the
                  “teach” tab). Verify your results then follow other instructions you have received on submitting grades from Blackboard.

   Onetime Set-Up Go to the Blackboard Grade Book. Note that the column labeled "Final" is a calculated column. This must be changed to an alphanumeric column.
Blackboard "Final" Select "Gradebook Options" from the top right above the columns. Select "Column Settings". Under "Final" click on "Calc". The box lets you select
          Column a "new value" from a drop-down menu. Select Alphanumeric and SAVE. Scroll to the bottom of the displayed chart and select APPLY.

Description: Change Worksheet document sample