Lessons Learned for H-1B Grantees - Using Excel to Manage Data and Track Participants
About
If your organization is considering using Excel to track participant data, this session covered best practices, common challenges, and lessons learned to maximize the effectiveness of Excel for tracking participant data and outcomes. The event featured tips from an H-1B grantee who uses Excel as a case management tool to prepare data files for submission into in the Workforce Integrated Performance System (WIPS).
Moderator
Kristen Milstead, Program Lead, Nursing Expansion Grants
Dani Abdullah, Program Support, Nursing Expansion Grants
Gregory Scheib, Program Lead, Building Pathways Grants
Hannah Jenuwine, Program Support, Building Pathways Grants
Presenter(s)
Darryl Grayson, Clark State Community College, One Workforce Grants
The event covered best practices, common challenges, and lessons learned to maximize the effectiveness of Excel for tracking participant data and outcomes. Current H-1B grantee, Darryl Grayson from Clark State Community College in Springfield, OH joined us and shared his experience with managing participant data and uploading files into the WIPS system.
Relevant resources from this session include:
- Event Recording
- Lessons Learned- Using Excel to Manage Data and Track Participants PowerPoint Slides
- Lessons Learned- Using Excel to Manage Data and Track Participants Tip Sheet
- Sample Case Management and PIRL Data File
Important Note: Beginning April 1, 2026, Nursing Expansion grantees began using the H-1B PIRL (Participant Individual Record Layout) 2025 to report performance data. The information presented in this resource was prepared prior to the transition to the H-1B PIRL 2025. Principles and concepts still apply, but information related to specific PIRL data elements or the QPR (Quarterly Performance Report) may no longer be accurate. Refer to the PIRL 2025 community page for details about the changes and impacts.
Frequently Asked Questions
Comments
Content Details
Topics:
Target Populations:
Programs:
Geographic Locations:
Industry Sectors:
- Last Updated:
- Created:
- Posted by: Margaret Lamb
- Posted in: Nursing Expansion Grant