Townsend's Excel VBA Code Recognized

One of the most well-known websites for learning Excel, contextures.com, has recognized Lee Townsend, assistant professor of mathematics in CETA, for the Excel VBA code she has developed.

The code written by Townsend documents the structure of the VBA code in an Excel workbook, thus allowing an easy method for tracking procedural calls.

She has written the code for several Excel workbooks over the last few years that work in both the Mac and Windows environments. Her code assists in the following areas:

•  Identifying the prerequisite grade history of students enrolled in a particular course based on reports from the Registrar.

•  Taking the data from Registrar reports, and then creating a worksheet for the Academic Standings Committee that contains GPAs, course completion rates etc. for the over 800 CETA students (created in collaboration with Professor Patricia Mellodge).

•  Taking the University schedule as generated by Class Search and reformatting it for usability. A few of its features are presentation of room and faculty schedules on a UHart weekly schedule form, identification of conflicts for both faculty and rooms, identification of required course availability for students in a given major and semester, and the ability to present in a graphical format the schedules for a set of given CRNs.  

If you are interested in seeing the codes in action for use by your college, please e-mail Professor Townsend.

Read about the code as published on the Contextures blog.