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. 

Go over the process of creating a VLOOKUP formula to match datafrom grade results spreadsheets (i.e.: ExamSoft, NBME) to the grading templateprovided in CBase.

Review the process for writing a formula to create aunique identifier that can be used in a VLOOKUP formula when a grade result sheetdoes not contain an email address or SBID number.

Speakers

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

Accreditation

This activity has been planned and implemented in accordance with the accreditation requirements and policies of the Accreditation Council for Continuing Medical Education (ACCME) through the joint providership of The School of Medicine, State University of New York at Stony Brook and Faculty Development. The School of Medicine, State University of New York at Stony Brook is accredited by the ACCME 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 Credits . 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