Instructors
This page will also have ability to show hide columns like other pages. Not shown in this prototype.
| FULL NAME | Mem ID | CELL | City | State | Course ABBR | Cert# | Notes | ||
|---|---|---|---|---|---|---|---|---|---|
| Affonce, Travis | 4985 | 206-426-0934 | taffonce@nwlett.org | Kingston | WA | GENCON | |||
| Affonce, Travis | 4985 | 206-426-0934 | taffonce@nwlett.org | Kingston | WA | PRECON | |||
| Baker, Bob | 10394 | 360-348-2762 | gonefishin27@gmail.com | CHEHALIS | WA | PRECON | |||
| Belger, Dan | 33754 | 253-370-3527 | db9631@comcast.net | Port Orchard | WA | ASB.W | |||
| Belger, Dan | 33754 | 253-370-3527 | db9631@comcast.net | Port Orchard | WA | HAZ.A | |||
| Belger, Dan | 33754 | 253-370-3527 | db9631@comcast.net | Port Orchard | WA | GENCON |
Goals
- There will be an entry for each class an instructor teaches. This corrects need to have cert # of instructor with the class when certification cards need to be printed. Instructor cert# is on the card
- By default instructors with an active member record will show automatically
- If an instructor member record is made inactive it would no longer show in active instructor list. But could be accessed by the sort list under the gear icon on the top right.
- Easier ability to view instructors by course using sort
- UI should make it easier to keep instructor list up to date
- Ability to add instructor note for each course. It will be connected with the class.
Background notes
Current Instructor Management screen
Issues Current management screen
- Tax Identifier Field has never been used
- An AGC ID field is in the database as well, it has never been used.
- Cert number field is also in this table... is rarely used. And there is no means to list multiple certs.
- Comments/notes are lumped together not by a specific course. They are called comments but not pulled into comments list. Suggest rename field to notes for clarity.
Current Data Base Tables Related to Instructors
List: tblInstructor info; tblClassInstructor; tblInstructorClasses
