SCORE 2013 User Guide - Drake Lane Associates
Contents
1. Fa Change course definitions Allows you to define courses based on the any character combination of the ProviderSpecLearnDelMon ILR file XML elements Course definitions are set in the same way as in previous years You select which XML elements and which characters contain the course code In the example below the first 6 characters of the first XML element are selected as identifying the course code There is no restriction on how many of the available XML elements you can select to define your courses Course definitions O em Course codes from your course file can be mapped to specific character combinations in the ProviderSpecLearnDelMon XML element occurences in the single ILR Use Occurence Characters 1 to 12 it V 2nd 3rd SCORE 2013 User Guide 15 of 29 drakelaneassociates gt Import course file Import a course file in CSV comma separated values format The format is the same as in previous years A course file provides the link between the course codes and other provider specific information A course file can be imported to obtain descriptive and hierarchical information consisting for example of aggregate course and Department data which can be used to group and provide summary data in reports The course file is a comma separated csv file consisting of 5 fields Course code Aggregate code Aggregate title Department code Department title Each course should be on a separate line2. drakelaneassociates SCORE SCORE 2013 User Guide Version 13 08 24 June 2014 Innovative Solutions for Education Management www drakelane co uk drakelaneassociates SV re PUM SNS TNS RE EE Ge RE ER ee Ee A EIE ie sig AE N N N EE cere a 5 Special notes for SQL Server 2008 R2 EXDIESS uses sesse sesse ee oe See ee oe ee ee oe ee ee oe ee ee oe ee ee ee ee ee eg 9 deel RR EE RE ae ees EER AEI ent ER OE ET EE EE EE LE ORDER OE nes 11 MEE ie SE AA RE eis 12 Unlocking TINS SOME EE OE N OE EE EE OE EE Ie 13 PTO UMN A Did se oe Ee EE ER EE GE ee E OK EE EE ee ee ee Ee EK ERG ee ee ie 14 se de Kakie US EE EE EE E 14 ele eetet tteeeessssss eette teteeessssseettteeeeesssssssseeteeeet 14 Oue je EEEE ET 14 PU NOUS SAN AAA 14 OPtiONS eT TTT 14 COU OS 15 PIN E eee eee EG GE Ge GE Ge 16 REDES oes se GE GE KG ER ke AK Ak NE ee ke AE ke ae 17 WONO WIU Hie reDor sasie up acct scetseg epee eucoccecuceueceaenvaeevaceneceiegeanctaeetnscuenceancencss 18 BEEE DA cere cesses AAA AA A AN nantes 18 Report navigation and selection un cesssesssssssesssecsssccsseccssecesueccssecessccsssccsssccsuscesuecesuccessecsssecsssecsuscesucesuccessccsssceessecsaseesueessucesseeesseeet 18 Be Ese aka ees OR 18 Bo ST alate ren Cove id OE SR Ge eee 18 dl tett teteeesssss teete tteeeeessss setete eteeeeesss ssent 19 Se Re 19 See n TO 19 NE VU ON EE EE EE nee 19 TT 19 ACIONS See ee eT eT 20 FSO iS OE EE EE EE N EE 21 Printed TEDO ee ER Ee couse area aai Ooa ENE
3. Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown SESS 8888888888888 oP Click the button below to import a course file if required Import course file The import file needs to be in a comma separated text format For further information please see the existing user guide The course codes are generated from your course definitions The other fields are taken from your imported course file Exclusions This shows and allows removal of individual learner and enrolment level exclusions Removing the exclusion here affects all reports for a particular learner or enrolment Notes This shows and allows removal of individual learner and enrolment level notes Removing the notes here affects all reports for a particular learner or enrolment Open reports This set of buttons performs actions on all currently open reports gt Ly Export PDF Export to PDF Export Excel Export to Microsoft Excel in the file format selected in the drop down box r Close all Closes all reports Help Online help Click or press F1 to go to www drakelane co uk and view the latest help documentation Email support Click to send an email to support drakelane co uk using your default email client Don t forget there s also the feedba
4. each field should be separated delimited by a comma and each field may optionally be enclosed qualified in quotation marks Build Start the build and view progress To start the build do any of the following e Click the gauge e Press F8 e Click the Build button Overall progress is shown on the green horizontal bar During the build the current optimisation figures are represented on the optimisation gauge The gauge is designed to convey several elements of optimisation at one time For example this gauge indicates a probable 60k under claim and a possible 40k over claim giving an overall 20k under claim Overclaim The probable and possible indicators always cover exactly half the circumference of the gauge Tota OP ae and their size shows the relative absolute values UUU of each Underclaim Probable S Possible The digital display shows the total calculated optimisation in Positive indicates an overall under claim SCORE 2013 User Guide 16 of 29 drakelancassociates Negative indicates an overall over claim Zero indicates neither overall Probable optimisation is shown in green Possible optimisation is shown in orange Under claims positive are shown below the horizon Over claims negative are shown above the horizon S Reports Investigate view and output reports For further information see the reports list section 176 O
5. corresponding exclusion gt Restores all notes for the report to those at the end of the last build Maintenance For maintaining notes on all reports select notes from the maintenance section of the main menu ribbon toolbar SCORE 2013 User Guide 26 of 29 drakelaneassociates Main menu ribbon The main application menu is in the style of a modern Microsoft Office ribbon toolbar Grid Tr Clear filters Removes any filters applied to the reports list grid x Export Excel Exports the reports list grid to Microsoft Excel Wizard Welcome FIS Current year FIS export database selection Sy Previous year LIS database file selection Options Courses Build Reports For further information on each wizard stage please see the section on performing a build in this document Maintenance WA Course data Opens the form to manage and maintain course file data The course data is presented in a datasheet view similar to the reports list 3 Individual record can be deleted by using the delete icon or highlighting the row and pressing Del on your keyboard Cells shown in light orange are editable SCORE 2013 User Guide 27 of 29 drakelaneassociates cormans E Drag a column header here to group by that column Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown Unknown
6. select the required cell with the mouse or use the keyboard cursor page up and page down keys gt The record selector on the left of the screen shows the current record and it is highlighted To open specific reports on screen do any of the following f Click the icon to open the printed report view yl Click the icon to open the interactive chart view Click the icon to open the spreadsheet like datasheet view Click the icon to open the form utility view N Double click the row to open the default view for that report You can open more than 1 report at a time and switch between report windows in the usual way on the Windows taskbar Favourites and selections You can mark specific reports as favourites or selections for easy access to frequently used reports y Click the favourites column to toggle on and off P Click the selections column to toggle on and off Column layout and order You can decide which columns are shown by clicking the field selector button at the top left corner To simply remove a field you can also drag the column heading away from the datasheet SCORE 2013 User Guide 18 of 29 drakelaneassociates To change the order of fields simply drag and drop the column headings into the position you require To change the width of a column place the mouse between headings then click and drag to the required width Double click between columns to automatically fit the widest entry Filter
7. server will normally be in the format NAMEOFYOURCOMPUTER SQLEXPRESS SCORE 2013 Setup X SQL Database Configure SQL Connection f C ORE te Server NAMEOFYOURCOMPUTER DRAKELANE Port 1433 Database SCORE2013 9 Windows trusted Username SQL server login Password ET You may see network servers on the list but this product is designed as a standalone desktop application so we recommend using a local server Login credentials are set to Windows trusted by default but you may wish to use the SOL server login To avoid any potential issues caused by insufficient user permissions we recommend using the sa System Administrator SQL server login rather than the Windows trusted The connection login credentials are stored in an encrypted format If you are using the default server with the DRAKELANE instance you may be able to use the username sa and password DrakeLan3 If you do not know the login credentials please ask your System Administrator SCORE 2013 User Guide 7 of 29 drakelaneassociates Once everything is ready click Install score 2013 Setup Les Ready to Install The Setup Wizard is ready to begin the SCORE 2013 C RE installation ia Click Install to begin the installation If you want to review or change any of your installation settings click Back Click Cancel to exit the wizard When the installation is complete click Finish with the option to subscribe on our website for email ne
8. AN aaia E OEE 21 AEE AT A TATTA 21 Page Setup eee ens ee ee eu em ere em eee 21 DERE dee EE 21 A E eT 22 Page background sessescssssscsessssscsssccsseccssecessecessecessecsssccssscesuscessccessecsssecssscesuscesuscesuccessecsssecsuscesuseesuccessecessecsaseesucesuccessccessceeaseesnessneesses 22 Boe E T T E E O T E E T E ETAT 22 Else EE AEE EE EE ee ee Ee 22 BE Ma E A E E MOE EL E N EE E ET 22 dl sette tteeesssssssetteteeeessssss stette ett 23 EIS NING PS 23 AOIN nT 23 Field i cee OE EE AE EE EE EE 23 O E E 23 ACET NI g A 24 sl ER EES EIS EEEPAEEE EFEFEF NEEE FEEEE EEFE FFERI E EERE 24 NGS E O O O O OO O O O O O E O O O TS 24 CA S OE N EE EE N N 24 GrOUPpINg cc seseczcscresseseeesseseseseesaessesasesecsasessesneesseansesssasvesssaavesssconessosasessesosess scones qsusetsssessssssesnssssenysssseaysssseanssaseasssuseasssuseasssuseasstssesssseeunsnieatis 24 Ole Eis ae Re Oe 24 erf TOR ett tteeeeessssseettetneeesssssssettteeteeeesss 24 ZOO Ge dees 24 O E 24 ECSU OWNS RE N E E E E E E EE E A E E E E EE 25 MENA eevee ER EE ER ER EE 25 De RE EE E EE E N EN 26 ATCT a ta Es ER ER Ere STO VET PT Pere OPORTO eT eT 26 MERRIE eel old N einen eeA EEEE ARNEE EERE EAEE E ARNEE EEE ESA EAEE AENEA EE EAEE EEEE AARAA EEREN EEES 27 GO E E E E tre mrt tote 2 Mid oe ee ee oe oe ee oe ee oe oe eo ee oe oe eo oe ee eo ee eo ee 21 SCORE 2013 User Guide 2 of 29 drakelaneassociates An EN ee ee N Ee eases EE N Ge 2 sege je erent er et er ent E er
9. at some of the Prerequisites needed to run SCORE are missing This wizard will assist you in getting and installing those prerequisites Click Next to continue to the list of prerequisites In most circumstances the default settings can be accepted but System Administrators should read the SQL Server Express R2 section of this document Click Finish at any time to completely skip the Installation of prerequisites and jump to the Installation of the main program Click Cancel to Cancel the installation and exit the Setup Wizard SCORE 2013 User Guide 4 of 29 drakelaneassociates Installation The installation package is distributed for download from our website as a zip file Download the zip file extract all files to a folder on your PC and run setup to begin the installation If you are using Windows Vista or above you will probably see a User Account Control warning similar to that shown below w User Account Control Do you want to allow the following program to make changes to this computer Program name SCORE 2013 Verified publisher Drake Lane Associates Ltd File origin Hard drive on this computer iv Show details Change when these notifications appear The files are digitally signed by us the verified publisher so you can click Yes Once setup begins simply follow each of the wizard stages through as shown SCORE 2013 Setup Welcome to SCORE 2013 es Setup Wizard The Se
10. ation Close Kaa Click this button or press F3 to close the report Chart dm Where available the chart view shows summarised report source data as an interactive chart To drill down to a specific subset of data just hover over the chart and click You will then be taken to the data grid view filtered for the specific subset of data selected The chart formats are predefined but numerous settings may be adjusted via the ribbon menu Grouping The data grouping allows you to select how to categorise the chart data Format You can select from the available chart types and where to position the legend Show data labels Hide data labels lts Show in 3D lis Show in 2D Gridlines Set the visibility of both horizontal and vertical gridlines major or minor on the chart Zoom Drag the slider controls to zoom in or out horizontally or vertically Check the box to maintain the existing aspect ratio Export SCORE 2013 User Guide 24 of 29 drakelaneassociates Exclusions Exclusions allow you to exclude data from individual reports at learner or enrolment level They are not applicable to all reports and where they are the exclusions work at learner or enrolment level not both In this way you can prevent data being reported which you don t want shown For example it may be that action has already been taken or you are aware of the reasons for it showing on the report On some reports we cannot say with cer
11. by clicking on the pin shown in the column header Frozen columns remain in place when scrolling left and right e Exclusion related columns are always fixed at the left Some items on the ribbon menu are common to the report view but those relating specifically to the datasheet are shown below Filters W Saves the current filter Applies a saved filter Ye Clears all current filters Exclusions s Removes all exclusions for the report I Restores all exclusions for the report to those at the end of the last build Notes Toggles viewing the notes field Removes all notes for the report gt Restores all notes for the report to those at the end of the last build Layout H Shows the column chooser so you can select which fields are shown on the datasheet x Automatically sizes all columns to fit the widest content Saves the current layout amp Applies a layout that has already been saved Resets any changes made to the current layout since it was last saved CS Sets the current layout to be your favourite layout for the report Your favourite layout is used as the default Export Export to PDF Export to Microsoft Excel with the file format currently selected on the ribbon menu as default SCORE 2013 User Guide 23 of 29 drakelaneassociates Report Print the printed report view Help Click this button or press F1 to go to www drakelane co uk and view the latest help document
12. ck option SCORE 2013 User Guide 28 of 29 drakelaneassociates Logs Feedback Opens the online feedback form to allow you to e Send us general feedback on the software e Make a suggestion to change existing features or functionality e Request a new feature that would help you or other customers e Report a software bug e Send some other kind of feedback You can also add attachments to any feedback you send You can still call sometimes it s more appropriate or email but this way makes sure we can easily track the many responses we get Check for updates Click to check manually for application updates Application updates are also normally checked for automatically each day About Shows software version and licensing information We may request log files file to assist with any support cases you have open N we 5 i Exit Build Opens the latest build log file Application Opens todays application log file Exit Click this button or press F3 to exit the application Drake Lane Associates Click to visit our website www drakelane co uk SCORE 2013 User Guide 29 of 29
13. e Report optimisation 114 307 Probable 0 Possible 114 307 Learner exclusions Yes The additional chart and utility views are available where indicated for specific reports Printed report The report view shows the report as it will appear when printed Standard navigation print export and other commands are on the ribbon If a filter is applied via the datasheet then this is shown on the first page Depending on the report it may not be possible to reflect the datasheet filter on the printed report For example you may filter for a specific course code but the report identifies its source data at learner level and a learner may be enrolled to several courses If there are exclusions then they are indicated in the page footer Print LO Print t Select a printer number of copies and other options before printing ta Quick print t Send the document directly to the default printer without making changes Page setup Scale al Stretch or shrink the printed output to a percentage of its actual size Margins H Select the margin sizes for the entire document a Orientation L Switch the pages between portrait and landscape layouts a Size Choose the paper size of the document Navigation H Find Show the Find dialog to find text in the document I First page Navigate to the first page of the document lt q Previous page Navigate to the previous page of the document SCORE 2013 User Guid
14. e 21 of 29 drakelaneassociates gt Next page Navigate to the next page of the document gt I Last page Navigate to the last page of the document Show the mouse pointer gt J Invoke the Hand tool to manually scroll through pages Invoke the Magnifier tool LJ Many pages Choose the page layout to arrange the document pages in preview LI Zoom out Zoom out to see more of the page at a reduced size f Zoom Change the zoom level of the document preview f Zoom in Zoom in to get a close up view of the document Page background Di Page colour Choose a colour for the background of the document pages gt Watermark 2 Insert ghosted text or image behind the content of a page Export a Export the current document in one of the available formats and save it to the file on a E disk ga Export the current document in one of the available formats and attach it to the email LM Close a Click this button or press F3 to close the report Data grid The data grid view shows the report source data in a grid format with similar functionality to the reports list in that you can change column layout and order apply filters sort columns and group data There are however some important differences e Multiple layouts can be saved for each report SCORE 2013 User Guide 22 of 29 drakelaneassociates e Multiple filters can be saved for each report e Columns can be frozen in position
15. figuration Specify Database Engine authentication security mode administrators and data directories Setup Support Rules Account Provisioning FILESTREAM Feature Selection AE EE Rode Specify the authentication mode and administrators for the Database Engine Instance Configuration Authentication Mode Disk Space Reguirements Windows authentication mode Server Configuration a E Re F Mixed Mode SQL Server authentication and Windows authentication Database Engine Configuration Error Reporting Specify the password for the SQL Server system administrator sa account Installation Configuration Rules Enter password eoccccecce Installation Progress i eeccccce Complete Confirm password Specify SQL Server administrators Test PC Test Test SQL Server administrators have unrestricted access to the Database Engine SCORE 2013 User Guide 9 of 29 drakelaneassociates The database used for data analysis and reporting needs to reside on SQL Server 2008 R2 or above The product is designed as a standalone desktop application so we recommend that one of the SQL Express editions is used on the client If you do not have SQL Server installed locally on your computer then the application installer can download this for you Although it is technically possible for the database to reside on a network SQL server instance the application is currently not designed to operate in a shared multi user env
16. ing Filtering allows you to see just the reports you are interested in The top 2 rows of the grid coloured light blue are used for filtering m Contains vi To apply a filter select a filter rule from the drop down list and enter criteria in A v the box below or select from a list of existing values where applicable A The clear filter button on the far left removes the filter for the entire scenario or filters can be removed for individual columns q 7 Alternatively just select the remove filters button from the grid section of the main menu 16 ribbon Sorting To sort a column just click on the column heading The direction of the arrow shows whether it is sorted ascending or descending Hold down Shift to select multiple columns for sorting Grouping Grouping the reports provides an alternative view of the datasheet by arranging records into groups which have the same value in specified columns Drag a column header here to group by that column To group by a column click and drag the column heading to the box at the top left You can group by multiple columns by continuing to add column headings as required Each group can be sorted as required 4 Individual groups can be expanded and contracted by clicking the and buttons x To remove a grouping click and drag the column heading away until the X is shown Navigation pane In addition to the datasheet there is a Microsoft Outlook style navigation pane to the lef
17. ironment SCORE 2013 User Guide 10 of 29 drakelaneassociates Updates Software updates will be checked for automatically when an internet connection is available By default updates are checked for every day but you can change this and other settings by selecting configure options on the screen below lo ss J Found Updates for SCORE 2013 Updates for SCORE 2013 are available Please select the next course of action Download and install now gt Remind me tomorrow gt Disable the automatic updates check Configure Options Alternatively software updates can be checked for manually by selecting check for updates Bi from the main menu ribbon SCORE 2013 User Guide 11 of 29 drakelaneassociates Uninstallation To uninstall the client application software go via Windows Control Panel a N Re To completely remove the SCORE database from the SQL server instance connect using SQL Server Management Studio and delete the database 7 Use Programs and Features y Use Add Remove in Windows 7 16 Programs in Windows XP ESE i Please note that this guide is written with reference to SQL New Query Server 2012 but similar processes apply to other versions Script Database as Expand the Databases node right click the appropriate database and select Delete from the context menu Tasks gt Policies gt Facets Start PowerShell Reports gt Rename Refre
18. ptimisation summary 1 Learning aims with achievement rates lt 25 4 Results not yet known 22 Remission not claimed inconsistencies TY 23 Remission not claimed 16 18 year olds oO O H gn O OOOOO HO 24 Remission not claimed 19 but 16 18 years at start of course 48 Duplicate enrolments same aim P 49 Duplicate learners same family name and date of birth P 53 Learners with incomplete postcodes Y gt 8888888 SCORE 2013 User Guide 17 of 29 drakelaneassociates Working with the reports list Datasheet The list of available reports is presented in a datasheet view similar to that in previous years but with much more flexibility This grid view is deliberately designed to look feel and behave like a familiar Microsoft Excel style spreadsheet If you already use our 4cast curriculum planning solution then this type of view will be very familiar to you Show gt You will find datasheets used in many places throughout the software They may have a right click context menu associated with them too which replicates many commands available elsewhere to provide you with different ways of performing the same task Actions r Open reports Changes can be made to the report list datasheet layout including applied filters and sort order and they will remain in place next time you start the application Report navigation and selection To move between and within records you can
19. sh Properties SCORE 2013 User Guide 12 of 29 drakelaneassociates Unlocking the software You will not be able to use the software until an unlock code is entered You unlock the software the first time it is run by contacting us with your UKPRN and computer fingerprint We can then provide you with an unlock code F lll OOOO SCORE licensing lo amp Please email support drakelane co uk for an unlock code or call 01756 797211 drakelaneassociates Provider est Provider do not use for real data UKPRN 99999999 Fingerprint 02B5 D003 Unlock code Your licence is for your specific UKPRN and each computer where the software is installed will require a different unlock code The unlock codes consist of 2 separate 8 character sections separated by a dash hyphen for example 0123ABCD 456789EF They are of a shorter simpler format than those issued in previous years When entering your unlock code the dash hyphen is entered automatically so there is no need to type it in Any alpha characters entered are converted to UPPERCASE automatically SCORE 2013 User Guide 13 of 29 drakelaneassociates Performing a build You will need to perform a build to process your data before viewing reports and other information VA The build is managed by a wizard that will lead you through the necessary steps You don t have to follow the wizard through every step To skip to a specific step jus
20. t click on the appropriate tab or select it from the main menu ribbon though some steps must be completed in order for example you can t complete a build without first selecting a current year FIS export database file To move between the wizard steps do any of the following e Click on the appropriate tab e Click the Back or Next buttons e Type B back or N next on your keyboard Build wizard stages vat Welcome This is just a simple introductory page FIS Current year Select the 2013 14 FIS export database for the current academic year A list of more recent available database files is shown for convenience Sy Previous year Select the 2012 13 LIS 20 export database for your organisation A list of more recent available database files is shown for convenience se Options Set options 9 Include only learner aims generating FE funding in appropriate reports EF Ensures only funded aims are included on reports where appropriate for example some reports deal specifically with non funded aims Remove exclusions from all reports You can exclude specific data from reports at aim or learner level Selecting this option permanently removes all previously set exclusions data for all reports SCORE 2013 User Guide 14 of 29 drakelaneassociates 2 Courses Set course definitions or import a course file Once you have defined course code structures the build and process will automatically generate course codes
21. t of the reports list datasheet that allows quick access to specific groups of reports and other commands Show Items in this group allow you to show specific categories of report Any filters you have already applied to the reports list datasheet are removed E Shows all reports Ww Favourites Shows reports you have marked as favourites SCORE 2013 User Guide 19 of 29 drakelaneassociates Tees meti Selections Shows reports you have marked as selected Optimisation Shows reports that have a funding impact calculated Chart available Shows reports that have an associated interactive chart view Utility available Shows reports that have a from based utility Already open Shows reports that are already open CJ Have data Shows reports that have data Actions Items in this group allow you to perform actions on the reports currently shown in the reports list datasheet eS Batch PDF Exports all of the reports to PDF Batch Excel Exports all of the reports to Microsoft Excel in the file format currently selected on the ribbon menu SCORE 2013 User Guide 20 of 29 drakelaneassociates Report views A standard report has 2 default views when opened the datasheet and printed report shown by default views Each view is available on a separate tab Both views also show summary information toolbar at the top of the screen with optimisation and exclusion information where applicabl
22. t rere tr ert er te ee eT 28 FU acces EE EO EE EE ER EE Ee 28 Ee EE EE EE N EE EE EE EE OE OE OE OE OE OE OE T 29 EER EE ER OE A OR RE OR OO N N etait 29 Drake Lane ASSOCIATES EE EE EE EE ee ne ee nr 29 SCORE 2013 User Guide 3 of 29 drakelancassociates System requirements e SCORE 2013 is designed as a standalone PC based application e t consists of a NET client application attached to a local SQL database e It requires Administrative rights to install but not to run the application An overview of the system requirements are shown below Minimum Recommended Windows XP SP3 Windows 7 or above 32 bit graphics with 1024 768 32 bit graphics with1280 800 resolution resolution SQL Server Express 2008 R2 or above Note this is downloaded as part of the install if necessary NET Framework 4 Client Profile Microsoft Excel or equivalent Note this is downloaded as part of the install if Adobe Acrobat Reader or equivalent necessary Note that these are optional but will facilitate the viewing of exported data 2013 14 Funding Information System FIS export database 2012 13 Learner Information Suite LIS export database SQL Server Express R2 and the NET Framework 4 Client Profile must be installed as a minimum If unavailable then the prerequisites wizard will download and install these components for you SCORE 2013 Setup s3 Welcome to the SCORE Prereduisites Wizard es The setup has determined th
23. tainty that data is wrong or requires correction just that further investigation may be required on your part Exclusions are stored permanently and are retained between different builds so they only have to be set once Exclusions are set at report level on the datasheet view The exclude flag is fixed in place and is always the leftmost column on the datasheet Exclude 2 Notes A Learn ref number Equals A S A Starts with A Starts with OE TE TE EE Paes a ERG EER dd EE EE gr EE ER ETER gr EES ee MEd 7 da Myl EE Once excluded the records affected are coloured yellow When excluding a learner all records for that learner on the report are excluded as shown in the above example Learner exclusions When an individual report has exclusions set it is indicated in the report information bar below the report ribbon menu The number of exclusions is also shown on the page footer of the report Exclusions Yes For an overall view when exclusions are set on any report it is also shown on the information bar below the main menu ribbon The numbers of exclusions are also shown in a separate column on the reports list datasheet The setting or removing of exclusions is reflected in the learner and enrolment counts in addition to the optimisation calculations both overall and at individual report level immediately There is no need to perform the build again S Select remove exclusions from the report datasheet ribbon
24. toolbar to remove all exclusions for the report or just use the excluded flag on individual datasheet rows I Restores all exclusions for the report to those at the end of the last build Maintenance P For maintaining exclusions on all reports select exclusions from the maintenance section of the main menu ribbon toolbar SCORE 2013 User Guide 25 of 29 drakelaneassociates Notes Notes are optional and can be entered against records on individual reports at learner or enrolment level Though separate from exclusions they could for example indicate the reason why specific records are excluded Notes operate in a similar way to exclusions they are not applicable to all reports and may be entered at learner or enrolment level not both 4 Once a note is added the pencil icon is shown against the record Clicking the pencil icon also toggles viewing the notes field J Clicking the column next to the exclude flag or selecting show or hide notes from the datasheet ribbon menu toggles viewing the notes field When excluding a learner the note is automatically repeated against all records for that learner on the report Select remove notes from the report datasheet ribbon toolbar to remove all notes for the report You can remove just notes that have an exclusion notes without and exclusion or both Remove notes DS Please select the notes you wish to remove Notes with corresponding exclusion l Notes without
25. tup Wizard will install SCORE 2013 on your computer Click Next to continue or Cancel to exit the A Setup Wizard O WA SCORE 2013 User Guide 5 of 29 drakelaneassociates Once you have read the licence agreement if you accept the terms click Next to continue SCORE 2013 Setup Cx End User License Agreement Please read the following license agreement carefully f C RE Copyright 1999 2013 Drake Lane Associates Ltd All Rights Reserved END USER LICENCE AGREEMENT FOR SCORE 2013 This End User Licence Agreement EULA pertains to the SCORE 2013 product called the Software in this Agreement in the package containing CD ROMs 1accept the terms in the License Agreement Ido not accept the terms in the License Agreement tea Wees Select the installation folder the default is recommended SCORE 2013 Setup Select Installation Folder This is the folder where SCORE 2013 will be installed To install in this folder click Next To install to a different folder enter it below or click Browse Folder C Program Files Drake Lane Associates SCORE 2013 SCORE 2013 User Guide 6 of 29 drakelaneassociates Configure the SQL database connection by selecting the server and login e If you installed SQL express as part of the setup then by default the server will be in the format NAMEOFYOURCOMPUTER DRAKELANE e If you have FIS Funding Information System software installed then the
26. ws recommended SCORE 2013 Setup wW 2 Q s d Completing the SCORE 2013 Setup Wizard Click the Finish button to exit the Setup Wizard IVI Subscribe on our website for email news SCORE 2013 User Guide 8 of 29 drakelaneassociates Special notes for SQL Server 2008 R2 Express If this prerequisite is required then in most circumstances the default settings can be accepted System Administrators may wish to note the following settings specific to the SQL Server 2008 R2 Express installation The default instance is named DRAKELANE z SQL Server 2008 R2 Setup z Em Instance Configuration Specify the name and instance ID for the instance of SQL Server Instance ID becomes part of the installation path Setup Support Rules Default instance Feature Selection Installation Rules Named instance DRAKELANE Instance Configuration Disk Space Requirements eee DRAKELANE Server Configuration Database Engine Configuration Instance root directory C Program Files Microsoft SQL Server Error Reporting HEER NEELS AE EE EE SQL Server directory C Program Files Microsoft SQL Server MSSQL10_50 DRAKELANE Installation Progress Complete Installed instances Instance Name Instance ID Features Edition Version The authentication mode is mixed by default The system administrator account sa has the default password DrakeLan3 G SOL Server 2008 R2 Setup Database Engine Con
Download Pdf Manuals
Related Search