Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Dropping scores in the Grade Center

From: Blackboard 9.x Essential Training for Instructors

Video: Dropping scores in the Grade Center

So we have got a Grade Center with four quizzes, four term papers, a midterm and final and class participation. We are going to talk about dropping scores and since that can get kind of confusing I actually went through and cleared out the Grade Center, so there is no grades in here right now. What I am going to do right now though is for jabrown I want to give him some scores. So it turns out that Jay never actually showed up for quiz number 1, so he doesn't have a score for that. We will leave it blank for now. For Quiz number 2, well, he showed up but didn't do very well. He got a 50.

Dropping scores in the Grade Center

So we have got a Grade Center with four quizzes, four term papers, a midterm and final and class participation. We are going to talk about dropping scores and since that can get kind of confusing I actually went through and cleared out the Grade Center, so there is no grades in here right now. What I am going to do right now though is for jabrown I want to give him some scores. So it turns out that Jay never actually showed up for quiz number 1, so he doesn't have a score for that. We will leave it blank for now. For Quiz number 2, well, he showed up but didn't do very well. He got a 50.

I am going to scroll over to the right and he on Quiz number 3 did much better. Actually hit the ball out of the park. He got 100. Scroll over a little further and quiz number 4 he got 100 as well. So those are his grades. Let's just say that for the sake of argument I've decided that for all the students in my class I'm going to allow them to drop the lowest quiz grade. So I have got four quizzes. I want to drop the lowest quiz grade.

It turns out that dropping scores, dropping them well, is a four-step process. Step number 1 is you need to create categories in your Grade Center or use some of the categories that are already built-in. We talked about that in a previous movie. The next thing you need to do is assign your grade columns to those particular categories, and we actually did that in a previous movie. What you need to do now is we need to create a new score column which is going to add up all the quiz scores and do the sort of arithmetic necessary to drop the lowest grade.

You might be tempted to click on Create Column. Don't do that. Create Column is where you enter grades. We want to have Blackboard figure this out for us. So I am going to click on Create Calculated Column and I am going to create a new total column. In this case, I can going to call it-- let's call it CUMQUIZ. Make a note for myself. 3 highest quiz scores. Primary Display of Score. Secondary Display of let's say Percentage.

I am not going to assign it to a grading period. Now right now we were creating a column and this column is going to create a sort of total for everything in the course and we don't want to do that. We only want the quizzes. So in this case, I am going to choose Selected Columns and Categories. I am going to scroll down. I could if I wanted to go and take Quiz 1, I am going to Shift+Click Quiz 2, Shift+Click Quiz 3, Quiz 4, and move those over. But the reason why I had to do categories is I want you to notice if I scroll down and click on Test, it already has Quiz 1, Quiz 2, and Quiz 3 and Quiz 4.

So I can just click and move that over to the right. I click on the greater than sign. So I don't have to manually choose individual columns. If I have done categories, it just makes it a little easier at this step. So it's now going to ask me, okay, am I going to be playing around with grading periods? Nope. And I've got two choices. I can drop grades or I can only use the lowest value, if you want to penalize your students, or calculate just the highest value. In this case, I'm going to drop grades. I don't want to drop the highest grades. Again, I don't want to penalize my students. In this case, I want to drop the lowest grades.

I am not dropping the three lowest grades. I'm only dropping the one lowest grade, but I could do any number here if I wanted to. So if I had 16 quizzes I could drop five of the lowest quizzes. So far so good, so what I've done is I've chosen the columns. In this case, I did it through Categories. Scroll down. And now let's talk about this Calculate as Running Total, because this can get a little confusing. You remember that Jay has four grades. Actually he only has three.

He has nothing for the first test, which you and I would consider to be zero. He's got a 50, 100 and 100. Because that first score column is empty, Calculate as Running Total, if it's set to Yes, doesn't count it. It is if the student never needed to take the test. So when we go to drop Jay's lowest quiz scores we are not dropping the lowest four quiz scores. We are dropping only those scores that have grades in them right now.

So he has nothing for the first one. It's empty. He is got a 50, 100 and 100. If I have Calculate as Running Total as Yes, Jay is going to have 100 because it's going to drop the 50 and its going to take the 100 and 100, average them together, and Jay's grade is going to be 100 for all the quizzes. That could be a problem for some people. My recommendation is say No. No means that all the columns count. There is no such thing as an empty column being forgiven.

If the student doesn't have a grade it counts it as a zero if I set it as No. And in this case zero and 50 and 100 and 100, if I drop to 0, 50 plus 100 plus 100 divided by 3, that's an 83%. Again, if I set this as Yes, Jay's got 100% average on the quizzes. However, if I set it as No, he's going to have an 83 because it counts that first column as a zero because it's empty. I am going to scroll down a little further. It's going to say, Include this Column in the Grade Center Calculations? Sure.

Show it to students? Sure. And then Show Statistics, Yes or No. I am going to click on Submit. So step number one, create or find a category for the Grade Center column. Step number two, assign the columns. Step number three, create a new calculated column. You are not going to create a column; you are going to create a calculated column, in this case, a total column. You have to choose what particular columns are going to be calculated. You have to decide whether or not you are going to allow excused absences.

Now it almost looks like we are done, but we are not. There is one more step. It's a huge step. I'm actually going to scroll over and I want you to see something. It sure does look like the Total column is right, but it's wrong. It's absolutely quite wrong, because the Total column is counting the quizzes twice and that's a problem. What I need to do is I need to tell the Total column no longer count those four quizzes. Count the CUMQUIZ column instead.

So what I am going to do is I am going to go in to the Total column. I am going to click on Edit Column Information. I am going to scroll down and instead of having the Total column count every column in the Grade Center, I'm only going to have it choose specific columns. In this case, I'm only going to include the CUMQUIZ column. I am going to include the Midterm. I am going to include the Final. I am going to include Classroom Participation. I'm also going to include the four term papers.

I'm not including the quizzes. The reason why is the quizzes already count in the CUMQUIZ category. So that fourth step, going back here and modifying the total column, if you are going to be dropping scores remember you don't want to count these grades twice. So you want to go and exclude the columns that are no longer being counted and use the new Total column. Calculate as Running Total? In this case No. In other words, if you didn't do it you get a zero. Include it in the grade columns? Do I want to show this to students? We actually turn this off earlier in an earlier movie.

I will turn it back on here so the students can see their final grade. I am going to click on Submit. And now everything is fine. If I want to move that CUMQUIZ to another place, I can go and do Manage Column Organization. So when we are talking about dropping scores, dropping them well, it's a four-step process. Step number one, create or find a category for the grades center columns you wished to drop. Step number two, assign the columns to that category. Step number three, create a new calculated score column, figure out which columns you are going to count, which grades you are going to drop, whether or not an empty cell count is zero or is just ignored.

And then finally, modify the total column to include this new column, the new calculated column, rather than the old ones.

Show transcript

This video is part of

Image for Blackboard 9.x Essential Training for Instructors
Blackboard 9.x Essential Training for Instructors

84 video lessons · 11696 viewers

Patrick Crispen
Author

 
Expand all | Collapse all
  1. 7m 51s
    1. Welcome
      1m 9s
    2. Using the exercise files
      35s
    3. What is an LMS?
      4m 15s
    4. Understanding Blackboard 9.X versions and campus customizations
      1m 52s
  2. 28m 38s
    1. The new graphical user interface
      5m 53s
    2. Exploring course-to-course navigation
      2m 20s
    3. Using course themes
      2m 15s
    4. Looking at course structures and the Quick Setup Guide
      6m 56s
    5. Using new and improved assessments
      7m 24s
    6. Looking at temporary obstacles and workarounds
      2m 36s
    7. Finding more Blackboard information
      1m 14s
  3. 26m 27s
    1. Logging in to Blackboard
      2m 9s
    2. Accessing your course and uploading files
      5m 40s
    3. Creating announcements
      4m 15s
    4. Sending emails
      4m 57s
    5. Viewing your roster
      3m 50s
    6. Downloading the Grade Center
      3m 17s
    7. Setting course availability
      2m 19s
  4. 14m 9s
    1. Understanding the tabs and sub-tabs
      5m 51s
    2. Working with modules
      3m 25s
    3. Personalizing the My Institution page
      1m 40s
    4. Editing the My Courses module
      3m 13s
  5. 12m 38s
    1. Understanding the course layout and breadcrumbs
      5m 13s
    2. Toggling the Edit Mode
      1m 26s
    3. Hiding and unhiding the Course Menu
      1m 9s
    4. Touring the Control Panel
      4m 50s
  6. 23m 53s
    1. Renaming, reorganizing, and deleting
      4m 58s
    2. Adding new menu items
      6m 4s
    3. Managing tools
      3m 40s
    4. Customizing a course
      9m 11s
  7. 16m 17s
    1. Viewing the course roster
      4m 55s
    2. Enrolling students and others
      7m 31s
    3. Why not to unenroll
      3m 51s
  8. 53m 34s
    1. Organizing content into folders
      5m 24s
    2. Uploading files
      11m 49s
    3. Using the Text Editor
      6m 19s
    4. Inserting a multimedia file
      9m 56s
    5. Linking to an external web resource
      4m 25s
    6. Linking to an internal course file
      6m 3s
    7. Making content available to students
      2m 2s
    8. Using the Content Collection
      3m 35s
    9. Copying and moving content
      4m 1s
  9. 24m 24s
    1. Exploring how students view course grades
      4m 1s
    2. Optimizing the Grade Center
      1m 36s
    3. Changing the default letter grading schema
      4m 24s
    4. Creating score columns
      6m 37s
    5. Entering grades
      5m 19s
    6. Viewing grade histories
      2m 27s
  10. 56m 19s
    1. Creating text columns
      3m 1s
    2. Managing columns
      4m 52s
    3. Creating grading periods
      5m 34s
    4. Creating categories
      5m 42s
    5. Dropping scores in the Grade Center
      9m 3s
    6. Weighting grades in the Grade Center
      6m 4s
    7. Downloading grades and editing in Excel
      7m 51s
    8. Uploading student grades
      4m 29s
    9. Changing grades
      3m 37s
    10. Changing a final grade
      6m 6s
  11. 16m 26s
    1. Creating assignments
      6m 22s
    2. Downloading assignments
      5m 16s
    3. Grading assignments
      4m 48s
  12. 37m 51s
    1. Best practices for using online assessments
      4m 21s
    2. Creating an empty test and choosing the Question Settings
      5m 29s
    3. Creating multiple choice questions
      7m 57s
    4. Creating true/false questions
      2m 48s
    5. Creating essay or short answer questions
      4m 5s
    6. Creating fill-in-the-blanks questions
      3m 39s
    7. Creating opinion scale/Likert questions
      5m 51s
    8. Reusing questions
      3m 41s
  13. 30m 28s
    1. Setting test availability and deploying the test
      13m 13s
    2. Assisting students with common testing obstacles
      8m 16s
    3. Viewing the student results
      6m 40s
    4. Reviewing the differences between surveys and tests
      2m 19s
  14. 16m 43s
    1. Sending emails
      6m 20s
    2. Creating announcements
      7m 14s
    3. Using the Course Calendar
      3m 9s
  15. 33m 15s
    1. Creating discussion forums and threads
      13m 1s
    2. Facilitating discussions
      9m 32s
    3. Moderating forums
      3m 36s
    4. Rating posts
      2m 47s
    5. Grading discussions
      4m 19s
  16. 9m 2s
    1. Creating groups
      7m 57s
    2. Adding members to groups
      1m 5s
  17. 4m 32s
    1. Next steps
      4m 32s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Blackboard 9.x Essential Training for Instructors.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.