Friday, January 25, 2013

Email to AbiTalk


Hello Abitalk,
On Tuesday, I purchased your Irregular Verbs – English Language Art Grammar App from the Amazon App Store.  After downloading it, I discovered that the app doesn't work properly on my tablet or phone.  The home screen of the app is cut off on both devices preventing access to the majority of menu.  I could enter into one of the areas I had access to and start an activity, but when I selected a verb the app entered into a continuous audio loop which only stopped after I shut off the device. I was unable to get a refund immediately after the purchase from Amazon.  Please fix these problems or refund my purchase.
Thanks,
Roger Wagner CCC-SLP

Thursday, January 24, 2013

Evaulation Performance Graph with an Adjustable Highlighted Region

At the request of multiple users, I have created another copy of my Evaluation Performance Graph with the average range highlighted. I used within 1 standard of deviation of the mean as average. I know what is considered average can vary and others may want different areas highlighted so the highlighted region (shape) can be adjusted.

Tuesday, January 22, 2013

Caution Purchasing This App

I hate to pick on a specific company selling Android apps, but if an app isn’t working I want to let others know!  I purchased and downloaded the ‘Irregular verbs - English Language Art Grammar App' today from the Amazon Appstore. It doesn’t work on my Lenovo A1 or my phone (LG DoublePlay); I couldn't figure out how to get a refund.  It does work on the first generation Kindle Fire.  If you don’t have a first generation Kindle, I don’t recommend downloading it or probably the 'Irregular Plurals - English Language Art Grammar App'. They may not work on your devices.  I will contact Abitalk this week and see if they can get it working.

Monday, January 21, 2013

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.


Friday, January 11, 2013

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.

Saturday, December 22, 2012

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) 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!

Wednesday, December 19, 2012

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.