Excel / SIMS import

Problem : After spending hours writing reports in excel for pupils I then need to copy and paste each one into the right columns in SIMS.  This also takes ages.

I always felt there was a way to import the entire data sheet – and there is.  It is actually pretty simple, and this blog is about how to do it.  This is the 10 stage process – it takes about 30 seconds in total after you write your reports.

Step 1 : Export the marksheet from SIMS into excel – as a formatted sheet.

1

Step 2 : Unprotect the sheet – to do this right click on the sheet name, then click unprotect

2

Step 3 : Write your reports

4

Step 4 : Protect the sheet (right click the tab name, click protect, ok)
56

Step 5 : Save your excel file as a xms file type

Step 6 : Go back into SIMS, go to Routines, Data In, Assessment and Import from Spreadsheet

7

Step 7 : Click the folder icon, find your file.

8

Step 8 : Click ok to the dialogue box confirming the names of the columns

9

Step 9 : Click next twice

Step 10 : The columns look like they are blank. Click out of the marksheet and load it up and they will be there.

I take no responsibility for this post!  It works for me but please check your reports and marksheets carefully!

 

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s