If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Excel or Access to keep track of students/records?
Any CFI's here use Excel or Access on their computer to keep a log of
their students and information on them and what you've covered with them? IF so, can you provide some tips on what a good starting ground would be for designing a spreadsheet to do this. Thanks |
#2
|
|||
|
|||
I think I would approach this by duplicating one of those student folders
used by the Jeppesen Guided Flight Discovery System. Then I would re-arrange the columns to match the syllabus that I am actually using. I would use one spreadsheet for each student, keeping a blank template to create new students and a final spreadsheet that shows the totals from all students. |
#3
|
|||
|
|||
Thanks for the input
On Mon, 29 Sep 2003 07:57:17 -0700, "C J Campbell" wrote: I think I would approach this by duplicating one of those student folders used by the Jeppesen Guided Flight Discovery System. Then I would re-arrange the columns to match the syllabus that I am actually using. I would use one spreadsheet for each student, keeping a blank template to create new students and a final spreadsheet that shows the totals from all students. |
#4
|
|||
|
|||
Check the one on my web page
(http://home.att.net/~jm.price/docs/tr_hist.xls)... Think you'll find it is just what you're looking for.... John Price CFII/AG/IGI http://home.att.net/~jm.price "BoDEAN" wrote in message ... Any CFI's here use Excel or Access on their computer to keep a log of their students and information on them and what you've covered with them? IF so, can you provide some tips on what a good starting ground would be for designing a spreadsheet to do this. Thanks |
#5
|
|||
|
|||
John:
Thanks a lot! Is this something you use/used before? DO you keep one of these for each student, and update it frequently? On Wed, 01 Oct 2003 11:07:06 GMT, "john price" wrote: Check the one on my web page (http://home.att.net/~jm.price/docs/tr_hist.xls)... Think you'll find it is just what you're looking for.... John Price CFII/AG/IGI http://home.att.net/~jm.price "BoDEAN" wrote in message .. . Any CFI's here use Excel or Access on their computer to keep a log of their students and information on them and what you've covered with them? IF so, can you provide some tips on what a good starting ground would be for designing a spreadsheet to do this. Thanks |
#6
|
|||
|
|||
Yes... I keep detailed sheets with notes while giving a lesson,
then every Sunday night I sit down and do my logbook and update the training histories for each student... Been using them since I started teaching... John Price CFII/AGI/IGI http://home.att.net/~jm.price "BoDEAN" wrote in message ... John: Thanks a lot! Is this something you use/used before? DO you keep one of these for each student, and update it frequently? On Wed, 01 Oct 2003 11:07:06 GMT, "john price" wrote: Check the one on my web page (http://home.att.net/~jm.price/docs/tr_hist.xls)... Think you'll find it is just what you're looking for.... John Price CFII/AG/IGI http://home.att.net/~jm.price "BoDEAN" wrote in message .. . Any CFI's here use Excel or Access on their computer to keep a log of their students and information on them and what you've covered with them? IF so, can you provide some tips on what a good starting ground would be for designing a spreadsheet to do this. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
The battle for Arlington Airport begins? | Paul Adriance | Home Built | 45 | March 30th 04 11:41 PM |
Downloading GPS track data and overlaying charts | John Galban | Instrument Flight Rules | 2 | July 25th 03 03:15 PM |