The Lunch-and-Learn Ends, the Data Entry Begins
The presentation went well. Now someone has to turn a sign-in sheet into an attendance upload, line by line, before the window closes.
- Member numbers copied off a clipboardOne smudged digit and an architect's learning units go nowhere.
- Course numbers and session codes looked up againFor every program, by whoever happens to be doing it this week.
- A reporting deadline in the middle of project workThe upload waits behind client deadlines until it's urgent.
- Architects asking where their credits wentUsually just before their license renewal.
Your Attendance File Is Waiting Every Week
Start from AIA CES's Format
Choose "Start from a board's format" and pick AIA CES. The columns, file name and weekly schedule are set for you.
Ask for the AIA Member Number Once
Pick the registration question that holds it, or let the setup create one. The number is checked as the architect types it, so the file starts clean.
Add the Course Number and Session Code
Type them on the course's credit once, and they ride on every attendee's row.
Open Your Inbox
Last week's completions arrive Monday morning in AIA's bulk attendance layout, ready to upload as is, with a big week already split into uploads AIA accepts.
- Column 1, header: Course Number, from: Credit field › AIA course number Formatting:Trim spaces
- Column 2, header: Session Code, from: Credit field › AIA session code Formatting:Trim spaces
- Column 3, header: Member Number, from: Registration field › AIA member number Formatting:Digits only
- Column 4, header: Date Completed, from: Completion › Completion date Formatting:Write the date as
%m/%d/%Y
Standardized Reporting for Every Program
Every Attendee Reported Once
Each completion goes into exactly one file. Nobody reported twice, nobody left out.
Never Miss the Window
The file comes to you on schedule, whether the program was a firm lunch-and-learn or a chapter conference.
Live and On Demand
Webinar attendance syncs from Zoom and GoToMeeting, and on-demand courses report the same way.
A Preview Before It Goes
See the next file's real rows before it goes, every member number already checked at registration.
Every File on Record
Send History keeps each file for a year, with a download and Resend.
Certificates for Every Attendee
AIA members go into the file by member number, and every attendee, member or not, downloads a certificate the moment they finish.
Questions from AIA CES Providers
How long does setup take?
One short sitting. Choose "Start from a board's format" in a Spreadsheet Report and pick AIA CES, choose the registration question that holds the AIA member number or let LecturePanda create one, and add each course's AIA course number and session code to its credit. We're glad to set it up with you on a call.
What do we need to have ready?
Your AIA course numbers and session codes from the CE Provider Dashboard, and the email address of whoever signs in to upload. LecturePanda takes care of the columns, the headings, the dates and the schedule.
What if an architect types their member number wrong?
The member number question takes digits only, so stray letters, spaces and symbols are fixed on the spot by the architect who knows the number. The preview shows the next file's rows before it goes, and Send History keeps every file, with its rows, so a fix starts from the exact file you sent.
Does it work for a firm's in-house training and free chapter programs?
Yes. A firm's lunch-and-learn for its own staff, an AIA chapter's free member program, a manufacturer's webinar and a paid conference all report the same way, and Spreadsheet Reports are part of the LecturePanda subscription. See pricing.
Can we choose when the file arrives?
Yes. The AIA CES report starts with a weekly send early Monday morning. Switch to daily, pick another day, or add a Google Drive folder alongside the email whenever you like.
Can we still change the file?
Yes. Once it's set up, the AIA CES report is an ordinary Spreadsheet Report: change the schedule, add a recipient or adjust a column whenever you need to. Send a test shows you the result first.
Looking for the AIA CES provider website?
AIA's resources for continuing education providers are at aia.org.
Also for Design and Construction CE
IDCEC
Interior designers' attendance files, IDCEC numbers checked at registration.
Florida DBPR
Attendance files for Florida contractors and building code professionals.
Spreadsheet Reports
Completions in any recipient's columns, on a schedule.
Teaching Architects?
Bring one of your AIA courses to a demo and we'll set up its attendance file with you, so next week's upload is ready when you are.
Request a Demo