Ok, so I have decided I will probably never be done, tinkering with my Excel file named Caseload Data Tools, but I have decided to release what I have so far to the public. I first started using Excel to record the data of my students’ sessions over a year ago and this file has seen a lot of improvements since. This file includes macros (programs written inside Excel to automate tasks). With macros, I have hopefully simplified charting of student data and making individual worksheets for each student. For more information about macros with Excel, check out my post here. There are lots of cells with red spots in the upper right corners. When you scroll over these, they display comments to help explain what to do and where to do it. Here is some (ok a lot) of the information. All the names and information in the pictures are fictitious, and were fabricated to illustrate how the file functions. Any resemblance to real persons, living or dead, is purely coincidental. You will need to enable macros in Excel to use most the the file’s functions.
The file starts with four sheets. The most important sheet in the file is ‘Caseload’. Data entered into this sheet is copied into other worksheets. Goals, minutes etc. can be changed at any time here, and the information will automatically be changed in the other worksheets. At the bare minimum student first names need to be entered. After students’ names are entered click “Click to here to make new client sheets”.
Data can be entered into the client sheets (in Date, Target Area, and Percent and charted by clicking “Click here to make a Chart”.
A macro creates a pivot chart. Data can be filtered by selected by selecting “Target Area” or “Date”.
If one “Target Area” is selected, the chart can be changed to line graph by right clicking on the chart, selecting “Change Chart Type”, then selecting “Line with Markers”.
Line charts usually do not work, when there is more than one target area, because days when only one target area is tracked the other area is tracked as zero. “Cluster Column” works best with multiple target areas.
After you enter dates into the ‘Attendance’ sheet, minutes from the student sheets are automatically transferred into this sheet.
Goals from the ‘Caseload’ sheet are also in the ‘Goals’ sheet for easy printing.
The workbook also has a ‘Schedule’ sheet. Without using macros only the ‘Caseload’, ‘Schedule’, ‘Goals’, and ‘Attendance’ will work. I should probably include a disclaimer, so I don’t get sued or anything. Macros contained in this Excel file are not intended to cause harm, but use at your own risk. Hopefully you will find this file as useful as I do!