Friday, February 23, 2024 at 12:00 PM
This grand round has already taken place.
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
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 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