eAIR July 2019

eAIR-banner

eAIR is the monthly newsletter of the Association for Institutional Research (AIR). From its start in October 1987 to today, eAIR remains one of the most important tools for providing news to the higher education community. This valuable resource includes web-based resources which are available at any time. eAIR is delivered on the third Thursday of each month.

Subscribe to eAIR

Create a free account or update your communication preferences to receive the eAIR newsletter.




  • Job Board

View all open positions or post a new one on AIR's Job Board.


    • Changing Scene
    • 07.12.19

    Colleague News

    • by eAIR
    Jeff Seybert, a longtime AIR member, passed away on June 19. Jeff was a giant in the field of institutional research, especially as it affected community colleges. He was a past recipient of the John Stecklein Distinguis...
    Read Moreabout: Colleague News
    • Journal News
    • 07.12.19

    Latest Journal News

    • by eAIR
    Keep current with the latest news from influential IR, assessment, and higher education journals. This month, you'll find a call for the Editor of the Community College Review (CCR) journal and the latest breaking articl...
    Read Moreabout: Latest Journal News

  • TT-July-2019-page
    • Tech Tips
    • 07.12.19

    Using the Listagg Function in SQL

    • by Jinny Case, Senior Research Analyst and Ashwin Jayagopal, Institutional Research Analyst, University of Texas at San Antonio
    Our institutional research analysts frequently extract data and modify the structure of data using SQL to suit the needs of data consumers or to ease analysis. Often, we need to aggregate tables containing multiple rows ...
    Read Moreabout: Using the Listagg Function in SQL