Exporting/Importing Key Stage marksheets to Excel and Mapping aspects

Importing data from a “Formatted” spreadsheet will import back into the original aspects and result sets that were contained when the data was previously exported. Importing data from an “Un-formatted” spreadsheet will require user input to map the columns of the spreadsheet to the aspects and result sets in SIMS. If the spreadsheets are exported…

Changing The Font In An Individual Report Which Is Using PoS Information

When you pull through information from Programme of Study (PoS) you are not able to change the font to match the rest of the report just by selecting the information and then selecting the font or colour you would prefer. The steps to change the formatting in these columns is :- Change the style of…

Profiles – splitting on two pages

To avoid tabled report comments splitting across the page.  Within the Word template; Select the paragraph or section of text you want to keep together. On the Home tab in Word 2010 or Word 2007, click the Paragraph group’s dialog launcher (the small arrow at the bottom-right. In Word 2003 (and earlier), choose Paragraph from…

Unable to format dates in Excel reports

To format the date in the report as required after export to excel, please follow the below mentioned steps: Select the column with the dates in the Excel spreadsheet. Select Data tab on the menu bar and click the button that says ‘Text to Columns’. A wizard will now appear. Select ‘Delimited’ in Step 1 click ‘Next’,…

How to securely clean a Hard Drive using Data Wipe disk

USE THIS AT YOUR OWN RISK – DATA WILL NOT BE RECOVERABLE AFTER FOLLOWING THIS FAQ.   If you need to securely remove all data from a computers hard drive before reusing or disposing you can use the DataWipe CD-ROM.   Download the zipped ISO DataWipe for burning to disk Or The latest version can be…