Driving Evaluation Spreadsheet

The goal of today’s session is collect data from the past years driving evaluations from the driving evaluation notebook.

You should find out each person’s diagnosis (DX), then record the results of their evaluation as to whether they:

• Passed
• Failed
• Need a road test
• Other recommendation

There are 8 pages of data to analyze. The dates the data was collected is from 9/29/06 – 1/11/07. However, you should only record data from the months of October, November and December of 2006.

Each page of the data has 6 columns:

MD

DX

Restrictions

Completion Date/Initials

Driver’ Training Needed

Scheduled w/ Terri

However, the data you need to collect is from only 2 columns: 1) DX 2) Restrictions

1) DX - (diagnosis: what was the person’s medical problem)

You need to record the person’s medical problem (DX) into 1 of 4 groups:

• BI ( this group also includes TBI, SAH, CHI)
• CVA (this group also includes stroke, ICH, Aneurysm)
• Alzheimer’s (this group also includes Dementia, Memory loss)
• Other (this includes any problem not listed in the groups above)

2) Restrictions (what was the result of the evaluation)

You need to collect the “results” data by putting it into 1 of 4 groups:

• Passed
• Road Test ( this group also includes “Recommend road test, OTR,”)
• Failed ( this group also includes “Did not pass”)
• Other (this group also includes any result not listed in the other 3 groups)

Collect the data by looking through the information and totaling up the results by using hash marks

	Passed	Road Test	Failed	Other
Alzheimers	| | | |	| |	| | | | | |	| | |

After get the total in all of the categories you need to enter it into the spreadsheet program Microsoft Excel.

After you have entered the data into the spreadsheet, you need to produce a pie graph showing how the people with a diagnosis (DX) of CVA performed on their driver evaluation.

Make sure the pie graph shows the difference between the number of people who passed, failed, need a road test or other results.