Little improvements in My Evaluation Performance Graph (DxGraph) files and Caseload Data Tools

I recently noticed that there was a few formatting issues (e.g., bold cells) from my personal use in my some of my files.  A user also brought to my attention a problem with the Highlighted Evaluation Performance Graph file. The age calculation didn’t work in a previous version and the highlighted region wasn’t adjustable.  All of these problems have been fixed in my new version you can download below  (My Microsoft Office Files post, ge.tt and Google Drive have the updated files also).

Evaluation Performance Graph

Click here to download my evaluation performance graph (dxgraph)

Highlighted Evaluation Performance Graph

Click here to download my Highlighted Evaluation Performance Graph

Caseload Data Tools (with macros): find and download CaseloadDataTools.xlsm from ge.tt when you click the picture

Click here to download Caseload Data Tools from ge.tt

Advertisements

My Microsoft Office Files

I think I lost some people in my move to WordPress.  So I thought I would link to all 5 of the Microsoft Office files I am sharing for free.  With WordPress all of these files can be downloaded directly from me except for Caseload Data Tools because it has macros.  Even if my blog gets shutdown, my files will always be saved on ge.tt at http://ge.tt/9pvrztX?c.  I know that many schools block access to blogs, but you should be able to download them from ge.tt anywhere.

If anyone would like me to share these files in Google Drive, comment on this post with your email address. I approve all of my comments before they become public.  If you give me your email address, I will add it to my share list on Google Drive and then delete the comment.

Click on the file picture to download it and the file name to go to the post with more information.

Evaluation Performance Graph

Click here to download my evaluation performance graph (dxgraph)

Highlighted Evaluation Performance Graph

Click here to download my Highlighted Evaluation Performance Graph

Caseload Data Tools (with macros): find and download CaseloadDataTools.xlsm from ge.tt when you click the picture

Click here to download Caseload Data Tools from ge.tt

Excel Student Data Sheet

Click here to download my Excel student data sheet

Word Student Data Sheet

Click here to download my Word Student Data Sheet

In addition I have created a list of Android apps in the Amazon Appstore in Excel

Check back here in April to get a free flashcard Excel file.

Individual Client Tracking Sheets

I was cleaning out and reorganizing all the files in my computer and found two sheets I used track client data before I created my Caseload Data Tools.  One file is in Microsoft Word and can be downloaded here.
The other is an Excel file and can be downloaded here.
I figured out how to put all of my files in one folder (album) on ge.tt.  They are all here, but all the download counts have been reset to zero.  

Caseload Data Tools an Excel file with Macros

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! 

Using Macros in Excel 101

If you have downloaded my Evaluation Performance Graph, you have seen what I can do without macros (little programs within Excel that automate tasks).  I am almost done with my Student Data file, so soon you can see what I can do with macros.  I have used macros to simplify complex and tedious tasks in my personal files for years.  Macros can contain virus, so you need to be careful and make sure you trust your sources of .xlsm files. I promise my files do not have viruses. I would rather create useful programs instead of destructive ones.  I have password protected the programming to prevent others from adding a virus.

With that said, if you are still interested in using my .xlsm files, you will need to enable the macros.  In Excel 2010 this is usually easy; click on ‘Enable Content’ the first time you open the file and you are good to go. If this doesn’t work your Trust Center Settings need to be changed. Comment below this post if you run into this problem and need help. I will explain further. 


In Excel 2007 things are more complicated.


You will need to click on this ‘Options’ button, select ‘Enable this Content’ and then click ‘ok’ every time you open the file or . . .


you can select ‘Open the Trust Center’, find  and select the ‘Add new location button’ 
then add the location of your file.  Note:  It is best not to have my file in main folder such as “My Documents” for this option. It is better to have it in another folder within “My Documents” like “rwslp”. Hopefully at least some of this makes sense. If anyone needs help with an older version of Excel let me know.  If your company/school is like where I work you can’t access blogs while at work so you may need to print this post off at home. I should probably put a disclaimer so I don’t get sued or anything.  These Excel files are not intended to cause harm, but use at your own risk.

Got ge.tt, Updated Evaluation Performance Graph, and Still Finishing Other File

After spending more hours than I care to count, I finally found an easy way for me to share my files. I switched from Google Drive to ge.tt, so I can now see how many people are downloading my files. I also updated my Evaluation Performance Graph again fixing a few minor things and adding some comments. If you have plan on using this file, download DxGraph.xlsx in my other posts or here.  It will print better.

I am still working on finishing my data collection file which should be done soon. This excel file will use macros to make graphing student data easy. It will include an attendance and student goal sheets that funnel data from a main worksheet and a lot of other features I use daily.If you are interested in beta-testing comment below.

Updated Evaluation Performance Graph

Well the world did not end yesterday, so I have updated my Evaluation Performance Graph (DxGraph.xlsx) with a few minor improvements. This is my Christmas gift to all the other SLPs who work so hard to improve other people’s lives.  I decreased the side margins, creating more room to type in the test names.  In addition, very long test names will now auto adjust to the size of the cell, this will hopefully prevent the chart from overflowing into a second page. You are welcome to remove the footer and modify the file for your own personal use. If you unprotect the worksheet from the Review menu in the ribbon (menus at the top), you can make a lot more modifications, but be careful not to change the column widths of the cells under the Normal Distribution Curve.   In my personal file, I have filled the columns on both sides of the standard score 70 with a different color to emphasis my qualification cut-off area.  I didn’t include this in the file I shared, because of the variations in our qualification scores. If you are interested in instructions on how to do this let me know.
Please send others to my blog or ge.tt (http://ge.tt/9pvrztX?c) for downloading this file instead of sharing your copy, so I have an idea of how many people are using it. I am working on adding automated graphing to a data collection Excel file I have been using with my caseload for the past few years.  I will be posting this in a few weeks, so check back if you are interested.
Merry Christmas!

Evaluation Performance Graph in Excel

I have created an Excel file which provides a visual of standard and scale scores for evaluations.  I have a lot of parents who find all the scores from tests confusing, so I made this to help them understand. All you have to do is enter the student information and then enter the test name and standard or scale score and Excel will graph the score beside it. The student’s age will be automatically calculated from the date of birth and report. You can download this file DxGraph.xlsx from ge.tt here. Comment if you have any suggestions.