Smart Response 2009 - Importing Assessment Results

[Jill Denny]

Hello everybody, I'm REALLY hoping I can get some help with this.  

I have Smart Response 2009 software (with LE clickers) installed and I use it quite frequently with my special needs groups that I work with.  I also teach the visually impaired, and I have one young man who is completely blind.  I do not use the clickers with him, but I would really like to keep track of the assessments I give to him (based on his goal work) within the Smart Response Teacher Tools.   I have read in more than one place that I can import assessment results that I performed without using the clickers either from an Excel file or a CSV file.  I followed the Smart Tech website's Help Center here:  

http://onlinehelp.smarttech.com/english/windows/help/responsele/1_0...

I formatted my Excel document with "ID Number and Marks" and when I try to import it, it won't let me and I get a window that tells me I need to make sure that the top row has the following information: Student ID, First Name, Last Name, Grade. So then I change it so it has this information, but it still will not let me import the assessment results. I get a window that states: "Teacher Tools encountered an error during import. Your data was not imported." I don't know what I'm doing wrong.

Please help, I have assessment results that I would love to import so that they will be included along with the assessments that I've actually done using the clickers with my other classes.  I called Smart Tech yesterday and the lady was NO help at all.  I don't think she even understood exactly what I was trying to accomplish.  She kept giving me instructions on how to import student names from Excel.  I already have my student's names in the program!  *sigh*

Thanks in advance for your help,

Jill

[Randy Tran]

Hi Jill,

Firstly, could you tell me who it was you spoke to when you called in to support?

Next up, I think a better way to go about this is to manually edit the marks for your student, since it appears you only need to bring in grades for one student.  All you would need to do is select the class the student resides in, then select the student.  Once selected, you should be presented with 3 tabs on the bottom half of your Teacher Tools (Properties, Performance, Results).  You want to click on the results tab.  In  the results area, you are then able to double-click on the Mark field and edit it manually.  Refer to the image below for a better idea what I am talking about.

If in case you still feel like importing a file to bring in the results, please make sure your file has formatting that looks something like the attached csv file.  Even though I have attached a csv file, the format is exactly the same as Excel.  In fact, due to incompatibility issues with Office 2010, I would highly recommend that imports and exports utilize the CSV format.  Last thing to note, you can also take the attached file, delete the student information that's already in there (names were randomly generated if anybody cares) and use the file as a template for your own importing.

I hope this helps you out.

#R

[Jill Denny]

First of all, thank you for your reply!  :)  I do not know the name of the person I spoke with.  The only information I wrote down was what she told me to do, but then I pitched it because I realized she was telling me to do something totally different than what I wanted, no matter how many times I tried to explain to her what I wanted to do.  

I think your suggestions will work, however this young man (let's call him James) is in a class all by himself.  Because I teach special education and the visually impaired, I do not take all my students at once, I see them either individually or in very small groups.  I do have one class that has 3 students in it, and I use assessments with them and it works out well because I'm using Smart Response created lessons and the results automatically go in.  James is not in this group.  I see him individually.  So James is not listed in this class, he's all by his lonesome in my "VI Class".  Thus, I do not have a list of assessments as you do in the screenshot you included.  I need to be able to get the assessments that I do into the "Results" area so that I can actually do what you are suggesting.  I wish I could just type into all the fields instead of having to import assessments one by one!  Grr...

I have Office 10 and I did not know about the incompatibility issues.  I do have a question though:  the computer that I'm trying to do this on is NOT the computer that I use when I have the kids actually do assessments with the clickers.  It is on my school laptop so I can work on this stuff at home.  Do you think this might have something to do with it?  

Thanks again for your help, I truly appreciate it.

Jill

[Randy Tran]

If that's what you're looking for, then I have good news for you.

You can use the assessments tab to manually fill in the names of the tests.  Do that first, and then go into results to fill in the grade. (See Picture)

As for the incompatibility question, the library files Excel 2010 uses is what causes the incompatibility.  As long as your file is made with Excel 2010, or you have Excel 2010 installed, you're going to run into problems.  I recommend CSV because all it is, is a text file.  It's no different from a text file created from Notepad, and  you can even open up CSV files using Notepad or Wordpad (though opening in Excel makes it much easier to digest the data since its more organized).

Hope that helps!

#R