The Program Ends, the Attendance Work Begins
The CLE went well. Now someone copies bar numbers off a sign-in sheet, matches them to names and works out every attendee's credits before a single one can be posted.
- Bar numbers copied off sign-in sheetsOne unclear digit and an attorney's credits never reach their record.
- General and ethics credits keyed one by oneThe same attorney typed in again for every credit type.
- An attendance list assembled after every programRebuilt by hand for the lunch session, the webinar replay and the annual institute alike.
Your Attendance List Arrives on Schedule
Start from the Oregon State Bar Format
Choose "Start from a board's format" and pick Oregon State Bar MCLE. The columns and the Excel file are set for you.
Ask for the Bar Number Once
Pick the registration question that holds it, or let the setup create one. The bar or LP number is checked as the attorney or licensed paralegal types it.
Type the Event ID and Credit Type
Each credit carries its OSB Event ID and credit type, typed once, and its credits come from the credit itself.
Post From One Clean List
On the schedule you set, the list lands in your inbox, every licensee's credits on it and every row naming its program. Posting is quick, and nobody gets missed.
- Column 1, header: Sponsor name, from: Fixed text : Cascade CLE Institute Formatting:Trim spaces
- Column 2, header: Program title, from: Course › Course title Formatting:Trim spaces
- Column 3, header: Event ID, from: Credit field › OSB Event ID Formatting:Trim spaces
- Column 4, header: Original program date, from: Course › Course start Formatting:Write the date as
%m/%d/%Y - Column 5, header: Last name, from: Registration field › Last name Formatting:Trim spaces
- Column 6, header: First name, from: Registration field › First name Formatting:Trim spaces
- Column 7, header: OSB bar number, from: Registration field › Oregon State Bar number Formatting:Trim spaces, thenUPPER CASE
- Column 8, header: Credits, from: Credit › Credit hours Formatting:Number with decimals
0.00 - Column 9, header: Credit type, from: Credit field › OSB credit type Formatting:Trim spaces
- Column 10, header: Completion date, from: Completion › Completion date Formatting:Write the date as
%m/%d/%Y
Attendance Lists Nobody Has to Assemble
Bar Numbers From Registration
Asked once on your form and checked while the attorney is still on it, licensed paralegals' LP numbers included.
Program Details on Every Row
Every completion on one list, with the program's title, Event ID and date on every row, ready to post.
Every Credit Type Listed
A program with general, ethics and access to justice credits gives each licensee a row per credit, credits and credit type filled in.
Oregon Licensees Only
Only attorneys and licensed paralegals with an Oregon number go on the list, and everyone still gets their certificate.
On Your Schedule
Weekly, or daily in a busy CLE season, so posting stays a quick job and no completion slips through.
Every List on Record
A preview before each send, and Send History with a download and Resend for a year after.
Questions from Oregon CLE Sponsors
How long does setup take?
One short sitting. Choose "Start from a board's format" in a Spreadsheet Report and pick Oregon State Bar MCLE, type your sponsor name, add any colleague who posts your attendance as a recipient, choose the registration question that holds the bar number or let LecturePanda create one, and type each program's Event ID and credit type on its credit. We're glad to set it up with you on a call using one of your own programs.
What do we need to have ready?
Each program's Event ID from the OSB Program Database and the credits and credit types it was accredited for. LecturePanda takes care of the columns, the dates, the email to your team and the schedule.
Our program carries general and ethics credits. Does that work?
Yes. Give the program a credit for each type, such as 2.0 General and 1.0 Ethics. Every licensee gets a row for each credit they complete, all on the same list.
Do licensed paralegals work too?
Yes. The bar number question takes a licensed paralegal's LP number as well as an attorney's six digits, and both go on the same list.
What about recorded programs and on-demand replays?
They work the same way as live programs. Each licensee's row carries the date they completed the program, so a replay watched weeks later lands on that week's list.
What if an attorney types their bar number wrong?
The bar number question checks it as it's typed, so a missing digit or a stray letter is fixed on the spot by the attorney who knows the number. The preview shows the next list's rows before it goes, and Send History keeps every list, with its rows, for a year.
Does it work for in-house CLE and free programs?
Yes. A law firm's in-house CLE, a free bar section lunch program and a paid annual institute all report the same way, and Spreadsheet Reports are part of the LecturePanda subscription; see pricing.
Who receives the list?
You do, and anyone else who posts your attendance on your OSB dashboard once you add them as a recipient. Every list arrives ready to work from, with a download in Send History if it's needed again.
Can we still change the list?
Yes. Once it's set up, the Oregon State Bar 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 Oregon State Bar's MCLE pages?
OSB's MCLE pages are at osbar.org.
Also for Continuing Legal Education
Nebraska MCLE
A ready-to-upload attendance file for every program, Nebraska bar numbers from registration.
Maine CLE
Attendance rosters for the Board of Overseers of the Bar, sent on schedule.
Professional Associations
Bar associations and sections running CLE all year.
Teaching Oregon Attorneys?
Bring one of your accredited programs to a demo and we'll set up its attendance report with you, from the bar number question to the list your team posts from.
Request a Demo