neil27

Thanks, I have done all that and I have now imported one set of exam results from 2009. Unfortunately, while they show up correctly when I open the marksheet for the correct group of pupils when I open an individual pupils assessment results it shows my newly imported results as being on the 1st March when i imported them - rather than 6th june 2009 when they sat them. Can you tell me what i have done wrong? I couldn't see anywhere on the result set to fix a date for the results - there was one on the exported marksheet, but as that part was read only I couldn't change it. Thanks

I am thinking hat i need to scrap the template/marksheets I have made and redo the template (after creating suitable result sets) associating the aspects I use to the appropriate result set. I will then use the new template to create new marksheets and export them to Excel. I have previously checked the names from SIMS/Excel against each other and they look ok. I will then copy and paste the exam results nad import it back into SIMS setting the result date as part of the process. Does this soubnd ok?

I am trying to import historic internal school exmaination results which are currently held on Excel spreadsheets. For any one spreadsheet there are columns for the names of the pupils and results for maths, english .... I want to import these results into SIMS so that they are accessible from there ( and cn then be viewed in Discover - but that's my next part of the task!). To this end I have: 1. Set up aspects for exam results in each subject 2. Set up an examination template which has columns using the aspects in the same order as the excel spreadsheet. 3. Set up a test marksheet for one year group - I used year 6. 4. Opened the marksheet and changed the groups dates so that it picked up the pupils from the correct dates ( Sept 2008 to July 2009 ) 5. Exported this into Excel as a formatted marksheet ( I think) 6. Copied and pasted the appropriate results from the school's Excel result sheet into my imported marksheet I now want to Import this back into SIMS but I am concerned that SIMS might not have sufficient info to store it correctly. I started the Import process but stopped midway as I couldn't tell how SIMS would recognise the dates the data was associated with: Does the Import screen have an option to set the date the data refers to? Does the fact that the marksheet was formatted mean that it carries with it the dates I set? I have now read the info about creating result sets but haven't found a way of associating my template with a particular result set. Can anyone point me the right direction at this point. Thanks

Thanks, I'll see if I can get hold of a copy.

Thanks for your help. I'm sorry but I'm not sure what you mean by " a resultset in you column". All the columns have results in them, I just can't see how Sims will associate them with the correct date when I import them. Will it pick it up form the original marksheet which I exported to Excel? Thanks

Hi, I have previously asked for ( and received ) help in my quest to import data from excel into SIMS assessment manager. I have set up the aspects, Templates and empty marksheets in SIMs and exported the formatted markseets to Excel and populated them with the appropriate information. I now want to import these formatted markseets back into SIMS. SIMS help say i should use Routines-Data in -Assessment Import from spreadsheet. I started to do this but stopped when I noticed that it had included on the head of my columns todays date. I can't see how SIMS will put this data into the appropriate year for the boys concerned. The result sheets are from several years ago. Can anyone tell me how to ensure that the data will be allocated correctly in the SIMS assessment manager database. Thanks

I have tried this, but when i set up the marksheet and select the effective dates for 1/9/2009 to 1/9/2010 I can't choose the correct boys - I selected year 5, but it gave me this year's year 5 boys not the ones who were year 5 in 2009/2010. Do you have any idea what i am doing wrong

Hi, I have been asked to re-create a lost results sheet from 2009. I have set up the aspects for the marksheet but I don't konw how to get the correct children attached to it - I want SIMS to find the classes from 2009 so that I can import the results into the correct column/aspects. Can anyone explian to me how to do this. Thanks. Neil

I have been asked to transfer all our PIPS. KS1, KS2 and MidYs results from EXCEL into SIMS (and then make it available in Discover). I have tried to follow the method given in the SIMS information but nothing gets transferred. Has anyone else previoulsy done this and might suggest what i am doing wrong or what the correct method might be? Thanks

Does anyone know if there is an INTEGER function which can be applied to a marksheet in SIMS? I have some percentages which I want to change into whole numbers out of 10 - so 72% becomes 7 and88% becomes 9. I can do this easily in EXCEL but want my SIMS marksheet to do it with a calculated column. Does anyone know if this is possible. Thanks