Instructor Online
Through Instructor Online, via eBear, you
have access to class
rosters. These rosters list Barnard and
Columbia students in your classes. You can also see a list of all students with email addresses, and you can send email to all students in the
class, to a group you select, or to individual students. There is also a grid to which you may add columns, to use for
grading.
The information about Barnard enrollments will be updated five
days a week; the information about Columbia enrollments will be updated less frequently.
Please note that
rosters are frozen during the program filing period.
You
must use eBear for Instructor Online
Once
you are in eBear, click on the STUDENTS tab, and then, just
below the tabs, on the green INSTRUCTOR on the horizontal blue
bar.
In the left-hand frame you
will see your courses, by semester. Click on a course,
and another menu will appear in the left-hand frame.
COURSE ROSTER
The course roster lists all
students in your course, both Barnard and Columbia. Listed for each student
are: class (e.g., FR, SR); Name; College ID (for each BC student this is the Barnard
System ID; for each CU student this identifies her/his specific school, e.g., CC, GS,
SEAS); and Box No. (Altschul box for BC students, Lerner Hall box for CU students).
If you would like to
download this information into an Excel spreadsheet, click here for
instructions.
COURSE EMAIL
Note: To
use class email, you must have a windows email program, such as
Eudora, Outlook, or Netscape Mail. If you need to have
an email program set up, the Help Desk,
x4-7172, can assist you.) Please note that Microsoft Internet Explorer has difficulty handling email
lists of more than fifty students.
The email addresses used in
this application are the ones provided by Barnard (for BC students) and Columbia (for CU
students). If you are planning on using this email application, you may wish to tell
your students that you cannot accommodate their use of other email addresses. They
can set up their BC and CU email accounts to forward to their preferred email addresses.
Emailing the entire
class:
At the top of the email list is an
identifier for class email. It will be something like: class[callno]@barnard.edu.
If you click on this link, your
windows email program will start a new email message, with the email address of all
students in the class entered on the bcc: line.
Emailing individuals:
If you click on an individual email
address, your windows email program will start a new email message, with the email address
of the individual student on the to: line.
Emailing groups of students:
If you want to email more than one
student, click the check boxes next to each selected student's name, then click the SELECT
button at the bottom of the column of check boxes. This will create a temporary
Selected Group at the bottom of the email list. Clicking on group[callno]@barnard.edu will start a new email message, with the email
addresses of the selected students on the bcc: line.
PRINT GRID
This application allows you to print out
a class roster, with as many columns as you need to enter assignment and/or exam grades.
Scroll to the bottom of the screen and
enter the number of columns you want, then click NEXT.
A new DESIGN GRID window will open.
You will see a roster with empty boxes at the top of the fourth column and any
subsequent columns. You may type headings (e.g., EXAM 1, REPORT 1, MIDTERM, FINAL)
at the top of the columns. When you have finished, scroll down and click BUILD.
The DESIGN GRID window will become a SHOW ROSTER window. You can now print
your roster by clicking on File, Print, OK.
When you are done printing your roster,
close the SHOW ROSTER window.
DIFFICULTY
REPORT
You will be
asked to sue the university-wide Mid-Semester Monitoring
website to report students in difficulty, rather than using
eBear.
COURSE
GRADE
At the end of
the semester, you will click here in order to submit grades
for all your students, Barnard and Columbia. (Please
note that pop-up blockers must be disabled for online
grading.)
DOWNLOADING TO
EXCEL
If you prefer to keep your grading
records in Microsoft Excel, it is possible to download from the Class Roster.
Click on Class Roster, then click on
File, Save As. Give the file a name that ends in .txt, making sure that you know to
which folder you are saving your file.
Now open Microsoft Excel. (These
instructions are for Excel '97. You may need to follow different import procedures
for other versions of Excel.)
Click File, Open. Then, in Look In,
select the folder to which you saved the roster file. In Files of Type, select Text
Files. Select the text file that you just created from rosters. Click Open.
Select Fixed width. Start import at
row 12. Click Next.
On the data preview screen, you will
probably need to adjust the column markers, then click next.
On the next data preview screen (step 3
of 3), make sure that the College Id column (the one after name) is formatted as a TEXT
column. Click finish.
What you want to do with your spreadsheet
now is up to you.
.jpg)
