Category Archives: Uncategorized

Instructions on Sending final grades to Banner

Upload Final grade to Banner

With a Final Grade column in Blackboard’s Grade Center you can submit final grades directly to Banner (InfOSU).  That sure beats keying them in again.

Create Final Grade Column

1.     From the full grade center click Create Column

2.     Name the column “Final Grade”

3.     Primary display should be set to “Text” (not letter because + and – are text)

4.     Category must be set to “Final Grade.” This is crucial as this category is what Banner searches for to “upload” grades from Blackboard.

5.     Points Possible: Enter total points possible for the course grade. It can be “0” because the Calculation function will be turned off.

6.     Include this Column in Grade Center Calculations: No.

7.     Show this Column to Students: No (this ensures that students do not see their final grade until they have completed the eSET course evaluation)

8.     Show Statistics (average and median) for this column to Students in My Grades: No.

9.     Submit

10.  Manually enter grades for each student

Upload the grades to InfOSU (Banner)

Log on to OSU Online Services (InfOSU) via the My Oregon State tab in Blackboard:

Follow the links:

·         Faculty & Advisors >

·         Final Grades Menu >

·         Final Grades – Upload from Blackboard >

·         Select a Term >

·         Select a Blackboard course (course will show only if you have a Final Grade column set up as above) >

·         Submit.


And here’s a link to 5 Essential things new users need to know about getting started with  a Bb course site:



Creating Average Columns on Blackboard

Average Calculated Column

An Average Grade column displays the average for any number of quantities. An Average Grade Column can include any of the following non‐text columns:

  •  All Grade Columns: All individual Grade columns added to the Grade Center.
  •  Grade Columns in a Grading Period: All Grade columns that have been added to a Grading Period.
  •  Selected Gradable Columns and Categories: Any Grade columns and any or all Categories.

For example, you can display the average for all Reading Tests and writing tests, or display the average grade for each student for a grading period.

Any categories that contain items that are set to No for the Include in Grade Center calculations setting will ignore those items when figuring the Average Grade.

To create an Average Grade and its column in the Grade Center, follow these steps:

1. Access the Grade Center: from the Control Panel Menu, click Grade Center | click Full Grade Center.  


2. Hover over the Create Calculated Column button in the Action Bar of the Grade Center | click Average Column from the menu.


3. In Section 1, enter the Column Information as follows:


1. Column Name – A required field, Column Name is formal name for the Item, and is displayed in the Grade Center and My Grades (student view). This field displays a maximum of 15 characters in the column header.

2. Grade Center Display Name – The purpose of this field is to allow you to shorten the Column Name without editing the original name. This field replaces the Column Name in the Grade Center and in My Grades (student view). This field displays a maximum of 15 characters in the column header.

3. Description – A description is an optional field. It can help Instructors and other graders identify

the Column. The description is visible to students in My Grades; they access it by clicking the Details button.

4. Primary Display – This is the format of the grade displayed in both the Grade Center and My Grades (student view). This field defaults to Percentage for the Average column, but you can choose from Score, Letter, Text, Percentage or Complete/Incomplete. Additional letter schemas can be added; see Add a Grade Schema.

5. Secondary Display – This selection displays a secondary format for a column in the Grade Center. The Secondary Display is denoted by parentheses and is only visible by Instructors.

4. In Section 2, the Creation Date of the column is displayed. If Grading Periods have been created, you will have the option to choose a Grading Period from a drop‐down list which will designate to what Grading Period the column is associated. Using a Grading Period is optional.

5. Section 3 is where you Select Columns that will be included in the Average column. Possible selections include the following:


All Grade Columns – This selection will automatically include all gradable columns that are set to” Yes” for Include this column in Grade Center calculations. Please note that this option will ignore all columns set to zero possible points (i.e. – Extra Credit). See Extra Credit for more information.

All Gradable Columns in a Grading Period (not shown) – select a Grading Period from the drop-down menu. This field will not display unless a Grading Period has been created.”

Selected Columns and Categories – You have the option to choose individual columns or categories to calculate the total grade. A combination of individual columns and categories can be used as well. Note: if you use categories, any assignments that have been submitted but not

graded will results in a zero in the calculation. To avoid this issue, use All Grade Columns or

individual columns in the calculation.

When a Category has been selected, several other options appear:

* Select a Grading Period for the Category using the drop-down menu. This will only be available

if a Grading Period has been created.

* Select how to weigh Columns within the Category “Equally” or “Proportionally”. Choosing “Equally” applies equal value to all gradable items within a Category. Choosing “Proportionally” applies the appropriate value to a Grade Item based on its points compared to other Columns in the Category.

* Decide whether to drop high or low grades within the Category or use the lowest or highest value in the category.

* To remove a selected item from consideration, click the red “x”.

6. Calculate as a running total –  Select “Yes” to calculate the weight as a running total to include only the Columns that have been submitted and/or graded. Select No to include all items, which will place a zero for any items not completed yet; this results in a low grade.

7. Section 4, Options, is where you choose access for users:


Include this column in Grade Center calculations – Makes the column available for use in other calculations. Important: Please note that choosing Yes to this option does not duplicate scores. It simply makes the item visible in the Columns to Select box.

Show this column in My Grades – Shows the column in the student Grade view

Show Statistics (average and median) for this column in My Grades – Shows the Total

Points column statistics in My Grades. Note: Instructors with small enrollment (i.e. – 4 GE students) may not wish to enable statistics as students may be able to deduce who received what grade

8. Click Submit to Save.

InterSection: Harmony in ESP Practice with Computers, Video and Digital Media. Saturday, March 23, 3:00-4:45 in the Tech Showcase.

I was honored to be part of this exciting forum at TESOL in Dallas, Texas.  You can listen to the presentations and view them by following the link.

Pecha Kucha is a wonderful way to share many ideas in a short space of time and as this session demonstrated, it can lead to rich and exciting discussion on a variety of topics.

Many thanks to Dr. Najma Janjua

ESP-IS Immediate Past Chair  and Professor of Graduate School of Research

Kagawa Prefectural University of Health Sciences in Japan.

Tagged ,

How to Post Starboard Lessons on Blackboard

Starboard to Blackboard

If you would like to have students view all of the content of your Starboard lessons, you can easily upload these as pdfs by following the directions in this Jing.  Saving Starboard files in this way also includes all of the additional documents or Powerpoint slides that you may have shown in class – a great way to make available any incidental vocabulary or photographs from lessons!  Why not give it a try…

MyLabs = No Homework (for you)

ImageSome of the classes here are using MyLabs from Pearson. It is an online learning management system that accompanies some of their textbooks. It can be a little tricky to get started (help documents here), but can minimize the amount of homework the teacher has to grade while simultaneously giving students more practice and explanation. Simply put: it seems to be a win-win.

Michelle Scholz and I will be working on a project to more closely review such online components. We will be presenting our findings at the CALICO conference in May. It will be interesting to see exactly what these types of programs have to offer. Computer-graded homework is nice, but we will look at the pedagogical approach, design, and technology more closely. Until then, enjoy the little bit of extra free time MyLabs provides.


QR Code Scavenger Hunt

We talk a little bit in the iBook about QR codes. QR codes are quick response codes, similar to barcodes. Mobile devises can scan the codes and connect users to a webpage or content. This week, I used the QR codes to make a scavenger hunt around INTO OSU. I posted QR codes around the building and groups were set out to find and scan them. When people scanned the QR codes, the groups were connected to a survey with a simple quiz question. (One question per QR code.) At the end, everyone met back in the classroom, hopefully having found all ten QR codes, and we reviewed the answers. It was a blast and is a good review or formative assessment activity.

I first tried to make the scavenger hunt using QR Code Treasure Hunt Generator. It was very user friendly and would be perfect for places that have limited wifi, but it has some disadvantages. Most notably, it only gives students the questions, but doesn’t give them a place to record their answers. That seemed a little tricky.  Instead, I used Fluid Surveys which is similar to Survey Monkey except that it automatically generates a QR code when it publishes the survey. So, each QR code linked to a survey with one quiz question. Using this method was still very easy, and it allowed people to enter their responses into the survey and for the teacher to electronically collect all the responses in real time.

I’ll certainly be doing it again and let me know if you do it too.

Tagged ,

“iPads in ESL Classrooms”

We recently completed a report on INTO Oregon State University’s iPad pilot. Here is a section of the introduction:

“In Fall 2011, INTO OSU invested in a classroom set of thirty iPads. Michelle Scholz and Jim Jamieson made the initial proposal, which was successfully funded by INTO. The project came at a time when according to the PEW Research Center (2011) approximately 11% of Americans were using iPads. People were using iPads to check email, read news, check social networking sites, play games, and to a lesser extent read books and watch videos. The average user was not using the iPad as a learning aide. However, the iPad group at INTO OSU saw numerous features which could be exploited for the purpose of language learning. Mitchell (2012) explained the features as follows:

+ Portability— This allows us to bring class materials and activities into settings that might be more interesting or authentic.
+ Connectivity— This allows us to access materials from around the web, simplifying dictionary searches, research, and so forth. It also allows us to publish on the web more easily.
+ Multimodality—This allows students to escape their black and white books for a world of interactive videos, pictures, and multimedia authorship. These features can help create meaningful learning opportunities, including creating multimodal digital flashcards and analyzing sources found online.”

The book outlines how these features were utilized in a variety of iPad activities and presents over 40 app reviews. If you’re interested in downloading it, it’s available in the iBook store here.