Utilizing VLOOKUP in Excel to Transfer Grades to CBase

Faculty Development

Friday, February 23, 2024 at 12:00 PM


This grand round has already taken place.


Online Streaming
February 23rd, 2024
1.00 AMA PRA Category 1 Credit Hours

Description

To go over the process of creating a VLOOKUP formula to match data
from grade results spreadsheets (i.e.: ExamSoft, NBME) to the grading template
provided in CBase. We will also review the process for writing a formula to create a
unique identifier that can be used in a VLOOKUP formula when a grade result sheet
does not contain an email address or SBID number.

Dates and Times

Start: 2/23/2024 12:00 PM
End: 2/23/2024 1:00 PM

Objectives

Help instructors that post grades in CBase. (Ideally, this feature is most
useful for classes of 20+ students but it can be applied to classes of any size).

Speakers

  • Kimberly Malamutt, BS
    • Utilizing VLOOKUP in Excel to Transfer Grades to CBase

Accreditation

The School of Medicine, State University of New York at Stony Brook, is accredited by the Accreditation Council for Continuing Medical Education to provide continuing medical education for physicians.

The School of Medicine, State University of New York at Stony Brook designates this live activity for a maximum of 1.00 AMA PRA Category 1 Credit(s) . Physicians should only claim the credit commensurate with the extent of their participation in the activity.

Need help with this Grand Round Session?

Please contact the Grand Round coordinator listed below:

Laurel Loh
Department: Office of Student Affairs
Phone: (631) 638-7807
Email: laurel.loh@stonybrookmedicine.edu

Give us a call
(631) 444-2094
Office of Continuing Medical Education
Renaissance School of Medicine at Stony Brook University
HSC, Level 2, Room 142
Stony Brook, New York 11794-8222