SCORE 2014 User Guide - Drake Lane Associates
Contents
1. a o LLLI Apply a layout that has already been saved Save the current layout ILILI O e Reset any changes made to the current layout since it was last saved SCORE 2014 User Guide 26 of 28 drakelaneassociates o CD Ca Set the current layout to be your favourite layout for the grid Your favourite layout is used as Yf the default Remove any filters applied to the reports list grid Export the reports list grid to Microsoft Excel L3 Exit the application or press F3 Drake Lane Associates Click to visit our website www drakelane co uk Help and support tab Logs We may request log files file to assist with any support cases you have open Open the latest build log file Open today s application log file G View the latest help documentation at www drakelane co uk or press F1 Send an email to support drakelane co uk using your default email client Don t forget there s also the feedback option SCORE 2014 User Guide 27 of 28 drakelaneassociates z Open the online feedback form 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 easily2. i Individual groups can be expanded and collapsed by clicking the and buttons X To remove a grouping click and drag the column heading away until the X is shown Dynamic department grouping iv Where available the data on individual reports can be optionally grouped on the printed report Select the Group by Department checkbox on the reports list grid The grouping is set at individual report level and is off by default SCORE 2014 User Guide 17 of 28 drakelaneassociates Viewing report content Report Data Chart A standard report has two default views when opened the datasheet m and printed report shown by default views Each view is available on a separate tab The additional chart and utility views are available where indicated for specific reports Both default views also show summary information toolbar at the top of the screen with optimisation and exclusion information where applicable Optimisation 271 970 Exclusions Last build 05 11 2014 15 18 03 Today 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
3. counts in addition to the optimisation calculations both overall and at individual report level immediately There is no need to perform the build again 3 Select remove exclusions from the report datasheet ribbon toolbar to remove all exclusions for the report or just use the excluded flag on individual datasheet rows Restores all exclusions for the report to those at the end of the last build Adding notes Notes are optional and can be entered against records on individual reports at learner or enrolment level Though they operate independently of 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 are available to be entered either at learner or enrolment level not both SCORE 2014 User Guide 24 of 28 drakelaneassociates d This image indicates that a record does not have an associated note Clicking the image toggles viewing the notes column allowing you to add a note This image indicates that a record has an associated note Clicking the image toggles viewing the notes column 4 In addition selecting show or hide notes from the datasheet ribbon menu toggles viewing the notes field When applying notes to a learner the note is automatically repeated against all records for that learner on the report d Select remove notes from the report datasheet ribbon toolbar to remove all notes
4. level and a learner may be enrolled to several courses Where available by selecting the checkbox on the reports grid printed reports can also be grouped dynamically by Department If there are exclusions then they are indicated in the page footer Print LO Print selects a printer number of copies and other options before printing a Quick print sends the document directly to the default printer without making changes um Page setup Scale stretches or shrinks the printed output to a percentage of its actual size Margins sets the margin sizes for the entire document Orientation switches the pages between portrait and landscape layouts Size chooses the paper size of the document Navigation eo Find shows the Find dialog to find text in the document SCORE 2014 User Guide 18 of 28 drakelaneassociates id First page navigates to the first page of the document Previous page navigates to the previous page of the document Next page navigates to the next page of the document Last page navigates to the last page of the document Show the mouse pointer Invoke the Hand tool to manually scroll through pages 4 Invoke the Magnifier tool Many pages to select the page layout to arrange the document pages in preview Zoom out to see more of the page at a reduced size z a Qj Zoom changes the zoom level of the document preview Zoom in to get a close up view of the document P 8 P Ba
5. track the many responses we get Application 7 Check manually for application updates Application updates are also normally checked for 4 automatically each day O Show software version and licensing information SCORE 2014 User Guide 28 of 28
6. End User License Agreement Please read the following license agreement carefully G 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 I accept the terms in the License Agreement Ido not accept the terms in the License Agreement Nea gt Select the installation folder the default is recommended SCORE 2013 Setup fol els Select Installation Folder This is the folder where SCORE 2013 will be installed G RE 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 Browse ITIN SCORE 2014 User Guide 5 of 28 drakelaneassociates Configure the SQL database connection by selecting the server and login e f you installed SOL 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 server will normally be in the format NAMEOFYOURCOMPUTER SQLEXPRESS If you are placing the SCORE database on the FIS SQL Express instance then you must be logged in to Windows with the same user account used when you installed FIS otherwise the correct permissio
7. 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 certainty 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 builds so they only have to be set once B Exclude q Notes A LearnRefNumber Exclusions are set at report level on the Eq A A Starts with A Starts with datasheet view The exclude flag is a T az fixed in place and is always the earm REO E EUER eee eee leftmost column on the datasheet ioe y ma pm Once excluded the records affected are v iE My learner exclusion coloured yellow When excluding a Vj E Mylearner exclusion learner all records for that learner on EET 7 e My learner exclusion the report are excluded as shown in Fr m 50166142 this example E 50166142 amp 50166142 Learner exclusions Yes 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
8. adings 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 SCORE 2014 User Guide 16 of 28 drakelaneassociates Filtering Filtering allows you to see just the reports you are interested in The top two rows of the grid coloured light blue are used for filtering m Contains v To apply a filter select a filter rule from the drop down list and enter criteria in vi the box below or select from a list of existing values where applicable g pp z The clear filter button on the far left removes the filter for the entire scenario or filters can be removed for individual columns 7 Alternatively just select the remove filters button from the grid section of the main menu 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 grid 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
9. ators should read Installation of the main program Click Cancel to the SQL Server Express R2 section Cancel the installation and exit the Setup Wizard of this document uy ec 1 j SCORE 2014 User Guide 3 of 28 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 5 User Account Control 93 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 show deta 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 te Setup Wizard The Setup Wizard will install SCORE 2013 on your i computer Click Next to continue or Cancel to exit the lt P Setup Wizard MA lt Back Next gt SCORE 2014 User Guide 4 of 28 drakelaneassociates Once you have read the licence agreement if you accept the terms click Next to continue SCORE 2013 Setup Eg
10. ckground S Page colour chooses a colour for the background of the document pages hdl Watermark inserts a ghosted text or image behind the content of a page Export Export the current document in one of the available formats and save it to the file on a disk m Export the current document in one of the available formats and attach it to the email LJ Close x Click this button or press F3 to close the report SCORE 2014 User Guide 19 of 28 drakelaneassociates Data grid LLLI 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 Columns can be frozen in position 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 gi Save the current filter amp Apply a saved filter Clear all current filters Exclusions 3 Remove all exclusions for the report 3 Restore all exclusions for the report to those at the end of the last build Notes 4 Toggle viewing the notes field d Remove all notes for the report Restore all notes for the repor
11. 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 2014 15 Funding Information System FIS export database 2013 14 Funding Information System FIS export database SCORE 2013 Setup SQL Server Express R2 and the NET Framework 4 Client Profile must be Welcome to the SCORE installed as a minimum If Prerequisites Wizard unavailable then the prerequisites wizard will download and install o has determi tl The setup has determined that some of the these components for you Prerequisites needed to run SCORE are missing This wizard will assist you in getting and installing those prerequisites Click Mext to continue to the Ex ol mere In most circumstances the default settings can be accepted but Click Finish at any time to completely skip the S is Installation of prerequisites and jump to the Sy stem Administr
12. drakelaneassociates SCORE SCORE 2014 User Guide Version 14 02 O5 November 2014 Innovative Solutions for Education Management www drakelane co uk drakelaneassociates OSU PUM gun 3 HVS CANO epin ienie in E 4 Special notes for SQL Server 2008 R2 Express sssssseceeeereeeeesssssssssssssssssseeecceeeereeeossssssssssssssssssseeeeeeereeeresssssssssssssssss 8 Bru z T 10 Susie 11 UNOC ANd CENO iei hipin 12 Peronin A DUN eseina E EE E E RN 13 EXtertial std OU CES ocn amr UNE ee ane aren UIN EI UII UI EU dU DIE 13 SN OP UON C 13 Organisation SUM COU i A 13 Bag 14 SEENE 1010 eee ea ee me M UMEN MEME UM MIU MM 15 wr C 15 Favourites and selections seescssecssecseecseecseccssecssecssccssecssecssccssecssecssecssecssecssecssecssecssecssecssecsseesuecssecssecssecssecsseesseessecssecaseeses 16 Column layout and OF Gel sssscceecescxstesseccensdencectvestasentevsectectssctsctovexsssussesenedesneciysttessy e
13. e 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 p SCORE licensing 28 Please email support drakelane co uk for an unlock code or call 01756 797211 drake aneassociates Provider SKIPTON GIRLS HIGH SCHOOL UKPRN 10033380 Fingerprint E631 142E Unlock code Your licence is for your specific UKPRN and each computer where the software is installed will require a different unlock code e The unlock codes consist of two separate 8 character sections separated by a dash hyphen for example 1234ABCD 567890EF e 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 2014 User Guide 12 of 28 drakelaneassociates Performing a build You will need to perform a build to process your data before viewing reports and other information 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 just 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
14. ectories Setup Support Rules Account Provisioning Data Directories FILESTREAM Feature Selection e ae Installation Rules Specify the authentication mode and administrators for the Database Engine Instance Configuration Authentication Mode Disk Space Requirements Windows authentication mode Server Configuration wae S UE Mixed Mode SQL Server authentication and Windows authentication Database Engine Confiquration Error Reporting Specify the password for the SQL Server system administrator sa account Installation Progress Complete Confirm password seseeee Specify SQL Server administrators Test PC Test Test SOL Server administrators have unrestricted access to the Database Engine lt Back Next gt J Cancel Help J SCORE 2014 User Guide 8 of 28 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 environment SCORE 2014 User Guide 9 of 28 drakelaneassociates Updates Software updates will be check
15. ed 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 e j amp jes Ww T 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 Disable the automatic updates check Configure Options Cancel 7 Alternatively software updates can be checked for manually by selecting check for updates E from the Help and support menu ribbon SCORE 2014 User Guide 10 of 28 drakelaneassociates Uninstallation To uninstall the client application software go via Windows Control Panel oa f Use Programs and Features Use Add Remove plf in Windows 7 Programs in Windows XP To completely remove the SCORE database from the SQL server instance connect using SQL Server Management Studio and delete the database New Database 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 Policies Facets Start PowerShell Reports b Rename Refresh Properties SCORE 2014 User Guide 11 of 28 drakelaneassociates Unlock and licenc
16. 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 After the introductory page there follows a series of simple steps that allow your data to be analysed and a series of reports produced External data sources 9j Select the external data sources For the current academic year the FIS export and LARS Microsoft Access databases are required Optionally you can also select the FIS export database for the previous year Doing so provides access to several additional reports that analyse data between the academic years Setting options Options set during the build can affect what data is shown on your reports Include only learner aims generating FE funding in appropriate reports 2 Ensures only funded aims are included on reports where appropriate For example some reports 9 deal specifically with non funded aims This option is selected by default Remove exclusions from all reports A You can exclude specific records from reports at aim or learner level as and where appropriate Selecting this option permanently removes all previously set exclusions data for all reports Remove notes from all reports You can add notes to specific report records at aim or learner level as and where appropriate Selecting this option removes all previously entered notes for all reports Organ
17. for the report You can remove just notes that have associated exclusions notes without associated exclusions or both a Remove notes es Please select the notes you wish to remove Notes with corresponding exclusion Notes without corresponding exclusion Cancel gt Update Restores all notes for the report to those at the end of the last build Maintaining exclusions and notes E A common screen manages exclusions and notes on an overall basis for every report Select exclusions and notes from the maintenance section of the home ribbon toolbar In addition to standard menu items the exclusions and notes data can be imported and a exported in CSV format if required wv SCORE 2014 User Guide 25 of 28 drakelaneassociates Ribbon menu The main application menu is in the style of a modern Microsoft Office ribbon toolbar split into two tabs Home tab Maintenance Access the definitions and maintenance for departments and courses within your organisation LJUJUL E Open the exclusions and notes maintenance screen Open reports This set of buttons performs actions on all currently open reports Export to the selected file format Close all reports Navigation am Navigate to the previous tab in the build process P Navigate to the next tab in the build process Filter Save the current filter Apply a saved filter Clear all current filters Layout
18. ic groups of reports and other commands Items in the show group allow you to view specific categories of report Any filters you have already applied to the reports list datasheet are removed t9 All shows all reports if Favourites shows reports you have marked as favourites Selections shows reports you have marked as selected 5 Optimisation shows reports that have a funding impact calculated jj Chart available shows reports that have an associated interactive chart view Utility available shows reports that have a form based utility Already open shows reports that are already open Have data shows reports that have data Items in the actions group allow you to perform actions on the reports currently shown in the reports list grid T Batch PDF exports all of the reports to PDF 3 Batch Excel exports all of the reports to Microsoft Excel in the file format currently selected on the ribbon menu Favourites and selections You can mark specific reports as favourites or selections for easy access to frequently used reports i Click the favourites column to toggle on and off 3 gt Click the selections column to toggle on and off Column layout and order t4 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 To change the order of fields simply drag and drop the column he
19. isation structure The structure of your organisation can be displayed or used to group data on many of the JDI reports A 2 tier hierarchy of department and course can be reflected by using the Learning Delivery Provider Specified elements of the ILR SCORE 2014 User Guide 13 of 28 drakelaneassociates Optionally you can also select the FIS export database for the previous year Doing so provides access to several additional reports that analyse data between the academic years Organisation structure 2 Bn Um gg Department Select Deselect Close names all all F3 Display Selection Exit Department codes mm Department codes can be mapped to specific character combinations in the ProvSpecDelMon XML elements in the ILR Use Occurence Characters 1 to 20 i a b Re ee 2nd 1 2 3 4 5 6 7 8 TEARS Reiss Sais CAE C HER Nous v INT D Sn 3rd 1 2 3 4 5 6 7 8 IIR e x itn AME CINE GS 1s E TC us Lester 4th 1 2 3 4 5 6 7 8 E LOON iR re LE SS Ms MNT EX rc DRET KB Cane M o Department and course definitions are set by selecting which XML elements and which characters contain the department or course code In the example above the first 3 characters of the ProvSpecDelMonB 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 organisation structure In addition departments also allo
20. nding is at learner level Department code as defined in organisation settings Not available for EFA as funding is at learner level iy Select the summary levels required from the grouping drop down lists and click refresh to see A your selections reflected in the grid A minimum of two builds with current year data must have been completed before the system functions as intended When new current year data is generated during the build a copy of funding and enrolment data is taken During subsequent builds this process is repeated with existing data from the previous build still stored A comparison can then be made between the two consecutive sets of data Data is presented in the familiar grid format with the standard sorting filtering and field selector functions available SCORE 2014 User Guide 22 of 28 drakelaneassociates Even without any changes the summary data is always shown at the bottom of the screen Select to display all records even Select to display only those records where those where there are no changes gt there is a change SCORE 2014 User Guide 23 of 28 drakelaneassociates Adjusting report content Excluding data S Exclusions allow data from individual reports at learner or enrolment level being discounted Though not applicable to all reports exclusions work at learner or enrolment level not both In this way you can prevent data being reported which you don t want shown
21. ns may not be assigned to the database SCORE 2013 Setup 3 SQL Database am Configure SQL Connection G YR E Server NAMEOFYOURCOMPUTER DRAKELANE Port 1433 Database SCORE2013 Windows trusted Username SQL server login Password rs es Games J 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 SQL 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 2014 User Guide 6 of 28 drakelaneassociates Once everything is ready click Install SCORE 2013 Setup es Ready to Install The Setup Wizard is ready to begin the SCORE 2013 G OR E installation E uu 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 news
22. o you Drag a column header here to group by that column i iD Report Favourite Selection EFA SFA Optimisation Learners Enrols Exclusions Exchusionslevel Group by department E E Starts with N E Es HN Egu E E Equ D Gaswih Equals m kills qq 176 Optimisation summary W oe qx 271 970 0 Hot applicable 1H i 712 Apprenticeships 19 with enhanced funding e Ld D 45 191 a Leamer E a BUT Apprenticeships actual duration less than 356 days rd 3 213 1 49 Leamer o P o g p Q 608 Apprenticeships planned duration bess than 366 days qi 853 i 4 a Leamer o e amp l 71 Q 04 Apprenticeships with level d prior attainment rd qe D i 7 Leamer o g g d g e e e Taal Q 706 Duplicate learners 2B e e 0 3907 3907 Leamer o 5 ad e Ed qu 730 Early completers a a su 311 Enral 433 705 FS errors and wamings d qi 117 207 a Enral E Qo 611 Funding adjustments qx 81 146 a Enrol o d o g Li ad gr ma 185 Funding changes between current and previous ILA qi qi Hot applicable g e e qi 158 Index of SCORE reports Ww 0 0 Not applicable o e e ad ad o e d B 73 P1 412 Large qualifications with short durations ae 113 113 Erral a Q 746 Leamers by delivery postcode rd qu a Leamer aim Q 609 Leamvers with a break in learning rod E 1 2 0 Learner amp 71 o 144 Learners with aims generating no funding e e m 2587 813 Leamer o d d d
23. recommended SCORE 2013 Setup 53 Completing the SCORE 2013 Setup Wizard Click the Finish button to exit the Setup Wizard V Subscribe on our website for email news WwW c 2 Q w SCORE 2014 User Guide 7 of 28 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 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 O Default instance Named instance DRAKELANE Installation Rules Instance Configuration Disk Space Requirements Instance ID DRAKELANE Server Configuration Database Engine Configuration Instance root directory C regram Files Microsoft SQL Senver Error Reporting a ee SQL Server directory C Program Files Microsoft SQL Server MSSQL10_50 DRAKELANE Installation Progress Instance Name Instance ID Features Edition Version The authentication mode is mixed by default The system administrator account sa has the default password DrakeLan3 HIL Server ZUG Put setup Ec I Database Engine Configuration Specify Database Engine authentication security mode administrators and data dir
24. rise to tue epe te Eve tee er tesi rte 16 2p m 17 cori 17 et X 17 Dynamic department SrOUPING cccssscscssscsssssscssecsssssccssscsssssscssscsscssccssecsscssccasseuscssccussesscssscassesscesccussssccasecssessccnsecsseses 17 VIEWING TERPOL CONLE Mi ocido e E EE E E e EEE E E E 18 PAETE POM e E T E E T E eee te ct E E E A 18 Dara O E A E E E EE 20 a 21 yg a 22 Funding changes between current and previous ILR 195 wccsssssscssssssssesscsssssssesscssssssssssessssssssescesssssssssesssssssseseessssssneeeeses 22 AGjUStng report CONTEN 24 Paine Oa eee a E E E er eee tet erm ee 24 Ading NOTOS siess cacesacccsseesieztssastcanessccusresnstsatos itii bn tatnen rue en erue one ier ict 24 Mamtaining exclusions ana dd DE Bicis usn ena aT E EEE UR OMM DUE 25 RIOD Oi IN Nga EE 26 HOG TAD e 26 Pop and Suppor Ca MW 27 SCORE 2014 User Guide 2 of 28 drakelaneassociates System requirements e SCORE 2014 is designed as a standalone PC based application e t consists of a NET
25. t to those at the end of the last build Layout 4 Show the column chooser so you can select which fields are shown on the datasheet Automatically size all columns to fit the widest content Save the current layout amp Apply a layout that has already been saved 4 Reset any changes made to the current layout since it was last saved Set the current layout to be your favourite layout for the report Your favourite layout is used as the default SCORE 2014 User Guide 20 of 28 drakelaneassociates Export gt Export to PDF 9j Export to Microsoft Excel with Excel 2007 xlsx format as default Report LO Print the printed report view a Help c View the latest help documentation at www drakelane co uk or press F1 Close x Close the report or press F3 Chart A Where available the chart view shows summarised report source data as an interactive chart ale 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 te Show in 3D ln Show in 2D Gridlines Set the visibili
26. ty of both horizontal and vertical gridlines major or minor on the chart SCORE 2014 User Guide 21 of 28 drakelaneassociates Zoom Drag the slider controls to zoom in or out horizontally or vertically Check the box to maintain the existing aspect ratio Export Export the graph directly to PDF B Utility 7 Where available the utility view presents information separately in a dedicated screen Utilities are primarily used to present summary financial or statistical data rather than information about individual learners or enrolments Once presented the data can normally be organised viewed and exported to different formats if required Funding changes between current and previous ILR 195 Continuous changes to the ILR mean that funding output can vary significantly between consecutive ILR files and it s not always obvious what has caused any change in funding This utility allows a comparison to be made quickly and easily between funding generated by the current ILR with that from the previous ILR summarised at different levels it is not designed to give a full audit trail of changes to individual ILR records Up to a maximum of three summary levels are available dependent on the funding model selected Notes Funding line type taken from the respective FIS data tables LearnerEFAFunding and LearningDeliverySFAFund Course code as defined in organisation settings Not available for EFA as fu
27. u Qo 732 Leamers with unknown prior attainment v e 0 452 1005 0 Learner o d d iU d d 1 of 82 Show gt You will find grids used in many places throughout the software They may Acorn s have a right click context menu associated with them too which replicates many commands available elsewhere to provide you with different ways of Open reports performing the same task Changes can be made to the report list grid layout including applied filters and sort order and they will remain in place next time you start the application Navigation To move between and within records you can select the required cell with the mouse or use the keyboard cursor page up and page down keys gt is also highlighted To open specific reports on screen do any of the following bl Click the icon to open the printed report view Click the icon to open the interactive chart view L Click the icon to open the form utility view SCORE 2014 User Guide Click the icon to open the spreadsheet like datasheet view The record selector on the left of the screen shows which record is currently selected The record 15 of 28 drakelaneassociates Double click the row to open the default view for that report You can open more than one report at a time and switch between report windows in the usual way on the Windows taskbar The navigation panel to the left of the reports list datasheet allows quick access to specif
28. w names to be entered manually against each department code generated Optionally a prompt can be shown at the end of the build to name any new departments generated by checking Prompt me to name new Departments on the Organisation tab of the wizard Any changes you make to course code definitions department code definitions of department names will take immediate effect If they are changed after a build has been done the changes will be applied retrospectively to the data generated during that build Build The build process allows SCORE to prepare data and reports based on the options selected To start the build do any of the following e Click the SCORE logo shown here on the left e Press F8 on your keyboard e Click the Build button Overall progress is shown on the green horizontal bar During the build the current optimisation figures are shown A potential under claim positive or zero is shown in black A potential over claim negative is shown in red Once the build is completed the reports grid becomes available to investigate view and output reports SCORE 2014 User Guide 14 of 28 drakelaneassociates Selecting reports The list of available reports is presented in a highly flexible grid view It 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 t
Download Pdf Manuals
Related Search