Breakout Session

Using Excel to Create Individualized Student Assessments

Track: Assessment             

Breakout Session VII
Fri. 12:00pm-12:55pm

Use of formative assessment instruments can provide meaningful experiential learning, while simultaneously affording greater assurance of learning by each student. This workshop demonstrates use of the “VLOOKUP” function to personalize workbook assessment tools. Grading rubrics can be built into the workbooks using “IF” functions and the whole workbook can be protected to prevent student cheating.   Tips for maximizing Excel functions and minimizing effort for creating the assessment tools will be demonstrated, along with ways to protect the integrity of the instrument. The resulting workbooks provide experiential learning using professional tools, and far more accurate assessment of learning outcomes.


Vito, Marilyn         

Marilyn E. Vito is Associate Professor and Program Coordinator of Business Studies at Richard Stockton College of New Jersey. She teaches accounting, auditing, and financial management courses at both the graduate and undergraduate levels.  Vito completed her B.S. at Richard Stockton College, her MBA at Monmouth University and a CGM from the Stonier Graduate School of Banking at the University of Delaware. She holds licenses as a certified public accountant in both New Jersey and Pennsylvania and is also a certified management accountant.