Google Sheets: Innovative Teaching and Assessment Tool for Clinical Treatment Planning

PA-007 - Google Sheets: Innovative Teaching and Assessment Tool for Clinical Treatment Planning (NEW IDEA SESSION)

Sunday, March 20, 2022

1:30pm – 1:50pm EST

CE: .25 Hr.

Designation: SoTL

Presenter(s)

Zaher Jabbour, D.M.D.

University of California, Los Angeles, School of Dentistry

PDF Handouts
JC

Justin Carreon

University of California, Los Angeles, School of Dentistry
MT

Minh C. Tran, Ph.D.

University of California, Los Angeles, School of Dentistry

We designed a Google Sheet with data validation formulas that contain all Dental Procedures and Nomenclature codes used in predoctoral clinic. This tool includes a dynamic search function with a drop-down menu that allows students to quickly find procedure codes.

Students were given this tool with a complete dental case (medical history, chart, pictures, radiographs) to practice comprehensive treatment planning by identifying a sequence of procedure codes.

Instructors can extract data from this tool to assess students ability to diagnose and prescribe treatments, and to easily grade complex treatment plans as if they were short-answer exam questions.

Learning Objectives:

Create and use Google Sheets to make custom tools for assessing students' thought process and ability in clinical treatment planning.
Use simple innovative methods, (e.g. Google Sheets), as a tool to allow students to practice clinical treatment planning and decision making.
Aggregate data into data visualization and analysis tools, (e.g. Excel Pivot Tables, SPSS, or Tableau) to probe students' knowledge, ability and areas of weakness in clinical treatment planning.
Create and use Google Sheets to make custom tools for assessing students' thought process and ability in clinical treatment planning.