Professional Development Tracking

[bighop]

Hello,

I'm starting a new job next week: Instructional Technology Specialist, I'll be working with teachers in my school district in training and helping staff integrate technology into the classroom.

I'm looking for ideas to keep track of:

My hours spent where (Conducting staff training or pushing into a classroom to work with staff and students)
Where I am (building, room and which teacher I'm with)
Content (Long range plan of what I hope to train in over the school year, and short day to day what i covered.)
Also with content, I need to know what information was covered with each staff member.

So I was thinking something like this:

Date | Time | Building | Staff | Content (Look up ) Content details (Notes)

Making an entry every time I did something..

Question: Is there a way to associate the Staff name to the training received? For example: If I train John, Bob and vicky on Google Docs, I would like something to appear next to their name that they completed that training.

Any help would be great,

Andy

[humdingaling]

Status?
completed, in progress, not started?

[bighop]

That's good, thank you!

I should also mention I'm using Excel 2011 for Mac.

[bighop]

So it's looking like this:

Date | Time in | Time out | Total Time (Calculation)| Building (Look up)| Staff (Look up)| Topic | Look up | Notes (Text) | Status

Now, I would like to have a more detailed list of what staff completed what training. Is it possible that when an entry is made on one sheet, (I worked with a staff member on this date... a running list will put a check mark or a date next to that staff members name on another sheet. This way I can quickly see if I have or have not worked with anyone.

[humdingaling]

sounds feasible
knock up some sample data with examples of what you want to have and what you expect the result will be and can move forward from there