This long-running eAIR feature is a resource for simplifying and streamlining IR activities. Often supported by step-by-step instructions, each tip provides solutions to common software or data issues of interest to IR and assessment professionals.
All submissions are peer reviewed by volunteers before being published in eAIR. To submit a Tech Tip
or suggest a topic for consideration, please contact eAIR@airweb.org
Shawn LaRoche, Research Analyst, Mount Wachusett Community College, shared information on spinner controls in Excel and their practical applications in this tip: Excel Indexing and Spinner Controls.
Terry McCamish, Accountability Data Analyst, Office of Technical Education Accountability & Institutional Effectiveness Division, Technical College System of Georgia shared this tip on creataing an Easy Excel Data Entry Form.
Past Tech Tips
Excel's SUMPRODUCT Function
Introduction to Google Script
Qualtrics Drill Down.
Using REXCEL to Reshape or Aggregate Data
Using Macros in Microsoft Word to Export Notes and Codes
Lookup in Excel Using Multiple Criteria
Excel Combining Rows Wizard
Essential Excel Shortcuts
Creating a Thermometer Chart in Excel
Tiger Line Shapefiles
Using the FRED Excel Add-In
Using Reference Management Software
Installing and Using RExcel
Using Excel SUBTOTAL Functions
Specifying Output in SAS