SES Student Address Collection - School User Manual
Contents
1. 5 0 5 10 3deoxe sJejoeJeuo Aue JO ue seyoue 31819 018 59 oJaz BuipeoeJd y ay ou sepoojsod N e si siy L 9P09 S04 J3PIO sad 191981849 uoneue dx3 OWEN pJ9lJ E Pm SseJppe ue jsisse 0 SjueuJulo s apeleyd sqe pue sejonb ejqnop sejonb ejBuis Aue Jo 2 pue apnye speod 55010 jseJeeu Lx 44 SV 3 uenis UO IN 048 SUEN Unon COLT 66644 6666 aw zs S Sp 1 187 IN 228 Aled LOLZ 66644 6666 m IN 008 Gl 2002 6666 te 1500 16666 __ N 1 106 1100 _________6666 Aieipisqns pue 10 sassaippe JUIPNIS zo snduie ve 9 JUD IN 078 AOUEN UNON 2012 66644 als ei comete __ ___ wea Toon S sr 1 187 IN 228 JeN LOLZ 66621 Ajuo A e p sqns 10 sassaippe juapnjs Jo 2 sndwiey2. Bal 5 mai a me REED gt imur Drinn ELE Eur Esc RE indi he 1 pam in ri nidi A an pa REGN Ka ase Wee irren MEX e Her T r M m E mm mu lee b Tem HE i m e A 5 Ss kara lra t ZR 1 i bree bue _ i e View School page provides an overview of the selected client in SES e View System page provides an overview of the system School system identified by client number and name Options available to Head School System o Select Head School or Campus o Return to Head School or System 11 Upload Student Addresses ABS 35930 SES Test School 8 DIRRANBANDI 1009 2014 Funding Quadrennium This facility you to subrnit address data DEST Data will only be loaded for the sebected quadrennium This process consista of the folloveing Sheps 1 Transfer fila to DEST This includes 6 sup to validate the file structure 2 Load the dom into SES You can downoad a copy of the i tay or TEI ee t ume for Magis your data The File Farrrat Requirement Specification can also be nccessed vi
3. This page is designed for maintaining details of a Student s address aba dez Plenie ensure prese Ese seve bution when adding er editing any informador ims view address dela held by DEST Click on contact cst To enter en address of a student with unusual ereumstanees click here hep SES pricacy netica Student Record Humber Fang Education Level Primary WI Secondary Boarding Yes Ne only DEST bomer pogo Lot Section Portion or RAB No ce Unit or Flat No Gromer House Ho Property or Community Hare Street Hanse Siret Suburh Locality State Postcode Cross Road or Comments zur e Add or edit individual addresses Accessed from View School or the left side bar 288 ntry e All mandatory fields ymust be entered for successful submission of addresses to the database e Interactive messages occur if mandatory fields are not completed e Additional rules also apply if a street name is provided then a House Number or Lot Section Portion or RMB Number are also mandatory Save a e You must click on ELEA after each address for it to be added to the DEST database 17 Data Entry Address with Queries 0 fae Pre 2 3 A DA P Home You have entered a Street Hare Please enter either House Humber or Lot Section Portion er RMB Humber or both for
4. Australian Government Usu Department of Education Science and Training SES Student Address Collection School User Manual acm 1 AA ay ge um Australian Government Department of Education Science and Training Australian Government Funding Arrangements for Non government Schools 2009 2012 SES SIUDENT ADDRESS COLLECTION CONTENTS Te JIREGISTERING o es ea ss at dnd 1 WVEIRTIS RESISTRATION 2 sen eta ee eect DELIA M ei 2 WHO CAN REGISTER TO USE THE SES APPLICATION IN SSP 2 HOWTO REGISTER das patito edidit ii ee 2 THE REGISTRATION PROCESS RE 3 2 WORKING THROUGH THE SES ananas anda eee 5 GUIDE TO USING THE SES WEBSITE FOR ADDRESS SUBMISSION HII Ire re re re remettre trei 6 SIENON TOS SE RE D Rm 7 SELECT THE SES FUNDING 0 00 1 8 WELCOME PACE a D 9 VIEW E _ 10 VIEW SCHOOL MULTIPLE CAMPUSES OR 5 11 WIPEOGAD STUDENT ventis ____ _ ties 12 UPEOAD STUDE
5. 25910 200917 1 1 DEST Schoo 25930 mU tte oes EY contact DE 57 COMMONWEALTH OF AUSTRALLA SES privacy noce lag an Statutory Declaration _ DEST hama page P DEST privacy graternant asciaimor DEST t J 2 authored by the Approved SES Eh Schon 8 DIRRANBANDI QLD To the Desz of my anc Deu tra number of re fier bebe cormeioonds with tha numer of anroled at thi dite Dscince Education ver students whe not obs for Australgn Govrammart Gane Recurrent Funding and the are the residenti of the studarts at the sho Total Humber of Addresses 16 lumber of Unusual Circumstances 22 12 2008 8 44 15 AH AUS Eastern Sunde Te 4 a the P gay Hite de t t5 Ls Echo Beo TEE at OF Paina hy mc 3 CEST ns Dee Ale to guardan of each pudent far whom 3 repdentel ag beer meted to DES 1 Ser ig eng a g a Ac and bebe that the staterante in the are tros n every girua a e The Statutory Declaration can only be accessed when you certify that your address data submission is complete and correct Scroll down to view the entire form e The Statutory Declaration will be identified by your school sys
6. 34 DISPEAVING THE DATAIN NOTEPAD sfc casei ee een 34 4 HANDY HINTS 35 INTERNET BROWSER us aaa naar 35 BROWSERS 35 ACCESS TONES MAE 36 SE WUEBSITES 37 SES WEBSITE WELCOME 8 38 MEW SCHOOL m 39 40 DO ra E 40 DON 40 TROUBLESHOOTING i M LEE 40 5 FORMATTING AND FIELD SPECIFICATIONS FOR THE STUDENT ADDRESSES 41 FIELD NAMES AND 42 EXAMPLE OF HOW ADDRESS DATA MAY LOOK IN SPREADSHEET PROGRAMME SUCH AS MICROSOFT EXCEL 45 01285 Having problems accessing the Internet or submitting your data Callus 1800 677 027 Email us grantsanddata help dest gov au 1 REGISTERING FOR SSP What 15 Registration Registration is the process whereby You identify yourself You identify the School or system that you represent You request access to the SSP applications you need to use Your registration details are checked in the SSP System and You are sent a logon and password for SSP via email that will allow you to logon
7. Low nna BRADDON 2601 Elder BRADDON 2612 BRADDON 2912 2812 Tarens Tomang rs Jer 5 Elder E Braddon 2612 6 FARRER BRADDON 2512 4 e View all addresses submitted to DEST Accessed by selecting 20922588 from the left side bar Y highlights addresses with queries e By clicking on the SRN hyperlinked for the student address you can view edit or delete the address as it is linked to the Data Entry Page You can download the student addresses by selecting the lick here link e You can also print the addresses shown on the screen by selecting File and Print from the menu bar of the browser o Before printing your report make sure you have chosen LANDSCAPE orientation for your paper in Page Set Up 20 Statutory Declaration Step 1 Q O BQ Pre 2 WAR omy DEST homa poge DF ST lien coperihit SES Test School 8 DIRRANBANDI 2009 2012 Funding Quadrennkum Incomplete Data Entry Unlocked Statutory Declaration The Statulory Declaration must be completed only after all the address data for a school are subenfted correctly Please confirm that all addresses have been entered for the school To enter more addresses you may choose to upload another file or enter addresses throggh the dela entry feature Fatal number of addresses
8. Oc a arm DN 8 EZ 491 ua ETT em ee Arial TEE ES an eas Chart E 2001 Joe Function reet Makara 810 NT 2002 Name circuit Anula 812 2003 Jo gt gt gt Pach Road Damen 900 2004 Su Picture Pd Berrimah a20 2101 Ste Hyperlink CK lesion Daly River 822 NT 2102 Jar v Community Alice Spri aro NT 2103 Tim Jones ection 34 stuart Close Katherine as 2104 Jenny Black RSO 622 Ross Highway Alice aro Address Suburb Postcode State 2001 Joe Bloggs 55 60 Giffe Street 910 2002 Mary Smith Anula 912 2005 John Citizen 3 75 Dinah Beach Road Darwin 500 004 Sue Brown Lot 9 Farrar Rd Berrimah od 2101 Steve Green Daly River Mission Daly River 822 2102 Jane White Mount Nancy Community Alice Springs 2103 Tim Jones Section 34 Stuart Close Katherine 850 2104 Jenny Black RSD 622 Ross Highway 1 Alice Springs Bru Figure 4 28 Converting Text to Columns If the address is in one column it can be split into separate columns by using a feature called Text to Columns To convert text to columns 1 Select the column to be converted See Figure 5 2 Choose the Data menu then Text to Columns See Figure 6 3 Click on the Delimited option See Figure 7 Choose Next Click in the box next to the Space Delimiter See Figure 8 Choose Next Observe
9. discisimer DE ET copyright Uiir oe TEN S E Ri an Pure ce We j p 4 E ain uU m 45930 SES Test School 8 DIRRANBANDI 2009 2012 Funding Quadrennkum Incomple te Data Entry Unlocked SRN Search This screen Allows you b search for the address of a particular student Ta search for a siudent address enter thei Student Record Humber then cick the Search button or press Enter Student Record Number earch eri 10 22 10 search for the address of a particular student Accessed from the left side bar 288701 To search for a student address enter the student SRN When entered click Having problems accessing the Internet or submitting your data Call us 1800 677 027 Email us grantsanddata help dest gov au 19 View Student Addresses Page SES Test School 8 DIRRANBANDI SES Horus Incomplete Data Entry Unkrcked View Student Addresses You may need to use the scrolliar to view addresses on the page prnl a eetect Fee and Print fram the menu bar of Ehe browser you print this report be wee to choose the landscape onenlabon for your paper in Fage Setup download the student addresses click here Total number of addresses 18 Total mmber of Unusual Circumitenc s Hunter of addresses wath queries 2 heat ory 51 hame page GEST privacy DE T copyright Logon User
10. contact DEST help preview Ware you are already a registered user me internet ist year you wi nat neon In order to access any of the functionality Financial Accountability vou must regist Registered users can lagon here Click here to access the online registration farm The Registration Process The registration process involves several steps Step 1 Register for Access to SSP The first step of registration involves you Someone on your behalf going to the online registration page and entering your personal details into the Online Registration Form This information will be used to create your user account and to determine what type of access you require SSP will guide you through the process and will return appropriate messages These messages will be displayed at the top of the online registration form when you click on the Save Registration button located at the bottom of the screen SSP will then check to see if you are already a registered user If you are it will advise you to use 55 5 Forgotten your Logon facility lf you are a new SSP user a new user account will be created SSP will send you an email confirming that the registration process was successful and advise you of your logon ID Step 2 Validation of Your Request All new registrations are validated by SSP Security Administrators When a new registration request has been received DEST may contact your school or system t
11. 18 Total number of Unusual Circumstances D lumber of addresses with queries 0 To proceed with the Statutory Declaration please cick on tha next button um A Statutory Declaration is required to complete the data submission process Accessed from the link on the View School page 212 dec or the left side bar dee when there are no queries associated with any of the addresses submitted To continue the Stat Dec process click on the button 21 Statutory Declaration Select a Signatory Step 2 oS Se 15930 SES Test School 8 DIRRANBANDI 2009 2012 Funding Quadrennium Incomplete Data Entry Unlocked pn pear alr contact DE ST SES privacy mite ling att Of ST name page DEST privacy seiaimaer DEST cxpyrighi Logon User Statutory Declaration Select a Signatory The tabutury ation wall be completed for the Tallaveimg schools DEST Humber Total Number o Addresses SES Test School 3 1 records found An authorised signatory mus be authorised to act on behalf of the Appragved Authority by the Approved Authority and by DEST in matters Hee Thes person must be listed vit the artmient nz signalory The Denartment can only accept a tatulpny Declaration by an approved Flense select a signaipry contact DEST if this
12. Areipisqns 491995 Y Py 828 6 107 008 6666 uoeeg 008 uiwJe peoy Gl 2002 6666 p N d X 0 00 2002 666 N 8 101541 062 6666 snduieo zo sndwey Locality Property or Community Name Number Campus Number DEST No Street Name Primary P or Secondary S Nearest Cross Road or Comments Suburb or Street Type House Number Flat Number Lot Section Portion or RMB Student Record Number SRN Client Number d c 5 n D gt 5 O tn dom 9 99X3 se uons jeeuspeoauds e ui y00 ejep moy jo NOTES 46 NOTES 47 NOTES 48
13. SES Funding Application Eemernmeni ea the ef han ILLIS Hem jng po SSP Home EI my contact DEST hip eft selec an application from the lus below Chch here to access Socioeconomic Status Funding text only DE ST page DE ST privacy ran og From phe Hinagabian Bar on the left you may sebect Legon riy dete Mig and Armend pour deta Change your password Request additional access text only The text only version diet not hae all Ehe colours and design elements of he graphict venum buf faster to derribos and can be used if your connection rs sigo e School Systems and multi campus schools will be able to access all their schools and Campuses e Please keep a record of the time spent preparing and submitting address data A Time Box is available at the end of the process e The text only version of the website is faster to download and can be used if your connection is slow Welcome Page Welcome to the SES Website Australian Government funding afrengements lor non govammaent schools are based on the Socioeconomic Status SES of a schools community This appheaton has been designed to be interactive and ntutive enablmg Chants to submit thar studenty residential addresses to the Department of Education Sciance and Traimng DEST Users Hon governmant and systems ar
14. down arrow next to Save in to navigate to the correct drive and folder 3 Click on the drop down arrow next to Save as type Choose txt tab delimited or csv comma delimited Type ina name See Figure 13 6 Choose Save Save As Save in E Uploaded Data t E Tools Sras on Fmtand4 fia F Deskto File name School Address Data Formatted csv b Web Folders Save as 05 Comma delimited Cancel Template xlt Text Tab delimited txt Unicode Text txt Microsoft Excel 5 0 95 Workbook xls SY rcomma delimited 1 Figure 13 33 Opening the Data in Notepad Once the data has been formatted as txt or csv it can then be opened in Notepad if you wish to view the data To open the data in Notepad 1 Open Notepad 2 From the File menu choose Open 3 Click on the drop down arrow next to Look in to navigate to the correct drive and folder 4 Click on the drop down arrow next to Files of type and choose files See Figure 14 select the file 6 Choose Open Look in Uploaded Data je ce File name gt Files of type E Files Cancel 5 Figure 14 Displaying the Data in Notepad Figure 15 shows how the data looks when saved as a csv file NOTE The extra commas in Figure 15 depict the fields that do not contain information Do not delete them as it will put the r
15. ihis SES address upmas 42930 SES Test School 8 DIRRANBANDI 2009 2012 Funding Quadrennium Incomplete Data Entry Unlocked Ties page is designed for maintaining derads of a student s address comers at ensure you press the save button when adding or editing amy information address data held by DEST click on view addresses SES privacy notice e To enter an address of a student with unusual circumstances cick here hog att Student Record Number 18 txt onfy Education Level Primary secondary DEST hoa page DE ET priva Boarding Oves Gm ee Lot Section Portion or RMB o DESC ONCE Unit or Flat No Legen Usar House No Property or Community Name Street Type St _ Suburb Locality Braddon p State ACT Postcode z512 lienrest Cross Road or Comments e Data Entry page for entering editing or deleting individual addresses Accessed from View School left side bar 999 SRN Search Page or View Addresses Page e highlights the field with a query save lt e Addresses with queries can be changed before re submitting 18 SRN Search Page Q O 55 Home SES Hou vea schon HEBGN amy anm atat des contact DEST SEE onec nodes hog ott txt only DE ST page DF ST piracy
16. om the folowing tasks s reading irrsirurtaurs obtained information collecting your udeni ac resset submittina your the procedures required to complete the student address dota process the Emi nent enllechna and parida dis e Accessed from the Statutory Declaration Select Signatory step of the Statutory Declaration process e The authorised person signing the Statutory Declaration is declaring that all three requirements have been met e access the Statutory Declaration the certification box must be ticked This certifies that the data collection process is complete and correct and that a Privacy Notice has been provided to the parent or caregiver of each student for whom a residential address has been submitted submit declaration lt gt To complete the Statutory Declaration form click on the submit declaration lt 7 button e Please record an estimate of the time taken by all your staff to complete the data collection process Include in your estimate the time spent reading instructions obtaining information collecting submitting and finalising your data submission 23 Statutory Declaration Form 25930 SES Test School 8 DIRRANBANDI 2009 2012 Funding Quadrennium Completed Data Entry Locked print Bi re SES Statutory Declaration Form gane E va oes Statutory Declaration
17. the error responsible for the unsuccessful transfer here may be more errors than the initial one identified It is essential that you consult the Field Names and Specifications to determine the cause of the error see page 42 If there are multiple errors select the Download Errors link to download a file containing a description of all errors e Amend the error s in your address data on the Excel spreadsheet e Save again as comma or tab delimited text file e Resubmit amended file through the File Transfer Process by selecting the option on the Upload Student Addresses page 15 Upload Student Addresses Feedback Successful but with Queries LJ A IN af Fey dewschos 42930 SES Test School 6 DIRRANBANDI 2009 2012 Funding Quadrennium Incomplete Data Entry Unlocked Upload Student Addresses TE aba dez mv Thani vau ta file fanta IEH been succes ef ul conmimct DEST help umber of previously submitted addresses D Humber of previautty quened addresses 0 SES privacy noticea of ailsmi ted addresses after Humber al queried addresses after upload 2 hog a Address Quenes xt only There are queries in poor address submersion on the nest to the student address pou wish te view eda or deleti DE homar page EEE DF 5T DEST Campars Immer LA
18. to SSP Who can Register to use the SES application in SSP Registration is limited to e staff members who will be processing the school s student addresses and e approved signatories of the Approved Authority for your school or system lf you already use other applications within SSP Financial Questionnaire Financial Accountability Census on the Internet then you are already registered as a SSP user and you should not attempt to register again Instead please refer to the Help Section on Requesting Additional Access in SSP Please note however that if you want additional access and you already have access in respect of more than one school or system you won t be able to use the Request Additional Access facility Please contact the HelpDesk on 1800 677 027 or ssp dest gov au to arrange access How to Register To register you must fill in the Online Registration Form You can find the online registration form by clicking on the register button located in the top left corner of SSP s logon page see diagram below For information on filling out the Online Registration Form please refer to the Help Section Filling out the Online Registration Form lf you are attempting to re register because you have forgotten your Logon ID and or Password please refer to the Help Sections Forgot Your Logon or Forgot your Password for information on how to be reminded of your password or your logon register
19. A HOT 35930 SES Test School 8 DIRRANBANDI 2009 2012 Funding Quadrenniem Incomplete Data Entry Unlocked wales heed View School This page provides avene of the school detis and the school s status in SES a upload a text containing multipla student addresses click on To manually enter student addresses one at a me click on dela entry To view ir dovenioed all addresses dick on addresoes complete the data collechon process complete the statutory declaration uing SENE des This is andy posable ance all address queries have heen retabeed DEST Number 25930 School 525 Test School Location Address School Ava DIRRANBAND OLD 4406 fon Dernoninabonal Signatories Latitude 0 Longitude 0 SES Hot yet allocated SES Status Incomplete Data Entry Unlocked Munber ol Student Records 0 Humber of Addresses Humber of Addresses with Queres Humber of Unusual Circumstances 0 e View School page provides an overview of the selected client in SES e View System page provides an overview of the system School system identified by client number and name e Options available Upload Data Entry View Addresses SRN Search Statutory Declaration Help O O OOOO 10 View School Multiple Campuses or System LLL EN EHE Rom 3
20. N 250 i House Number or cu have entered a Street Hame Please enter eaher a House dia cisimer Let Section Humber or Lect Section Portion er Number or both for DE T Fatin of address Logon Usar 2 Howse Number have entered Street Hare Plasye enter a House Number or Lol Section Portion or Number both tor wtion oc this address F EE Australian Coaovennment E Department of Education Science and Training e Part 3 of File Transfer Feedback Successful but with Queries e Notifies that the file has been successfully added to the database or has successfully replaced all addresses previously submitted e Notifies the number of submitted addresses after transfer e Queries with your data are identified eg o Postcode may be incorrect or o No street or lot number is attached to a Street Name e These queries should be checked and if necessary corrected before moving to the View Student Addresses page or completing the data submission process with a otatutory Declaration 16 Data Entry Page i i Ti uris ae a I x ae Fey III ree l a SSF 25990 SES Test School DIRRANDANDI 2009 2012 Funding Quadrennium SES Hon Incomplete Data Entry Unlocked paas Data Entry anys
21. NT ADDRESSES PART _ _ _ _ _ 13 UPLOAD STUDENT ADDRESSES FEEDBACK 14 UPLOAD STUDENT ADDRESSES FEEDBACK UNSUCCESSF UL 15 UPLOAD STUDENT ADDRESSES FEEDBACK SUCCESSFUL BUT WITH 16 DATA ENTRY PAGE oo een eh u nehme 17 DATASNTRY ADDRESS WLITHAOUERIES4 2 5 His reparieren 18 SRN SEARCH PAGE ut ee ee 19 VIEW STUDENT ADDRESSES 20 STATUTORY DECLARATIONSSTER Tess een RS ESLE ea nee 21 STATUTORY DECLARATION SELECT A SIGNATORY STEP 2 22 STATUTORY DECLARA TON STEPS E 23 STATUTORY DECLARA TON FORM ee ee lee SR epo ue 24 VIEW SCHOOL PAGE _ 25 3 PREPARING YOUR STUDENT ADDRESS RECORDS IF USING 27 SELES TING ads 27 INSERTING COLUMN S eu A ee Rear 28 CONVERTING TEXT TO COLUMN Sages SEE ee en mean 29 BE TE TONG len nee 31 DELENG ROWSAND GOLUMN SA ae eto lacie ntt ee 32 SAVING THE DATA IN THE CORRECT FORMAT 33 OPENING THE DATA IN
22. a required to submit the repderitial addresses of all students for whom the school recens Aaustradan Government General Recurrent Grafts funding other than full ome Distance Education students Full fes paying everceas mudents and pre school students are not eligible for Australian Government funding ahd should not be included in the collection The Schools Resourcing Group of DEST manages the collection of student addresses and uses this information to calculate an SES score for each non government school Note Please keep a record of the time you spend preparing and submitting address data This is part of an Australian Government commitment to reduce the burden of form completion The Time de available at the end of the submission process access data for a different quadrennium select the quadrennium below 2001 2004 Funding Cuadras locked for data entry 4005 2008 Funding Ounadrennium 2008 2012 Funding Quadrenmum currently selected Note Informabon provided through this sg and recened in confidence e School identified by client number and name in top left corner e Selected Quadrennium shown in top right corner Options for working with data o 2001 04 Funding Quadrennium view address data only no changes o 2005 08 Funding Quadrennium o 2009 12 Funding Quadrennium e Note Information provided through this site is given and received in confidence View School 2 06 L
23. ata is Delimited IF this is correct choose Next or choose the data type that best describes your data Original data type Choose the File type that best describes your data Delimited Characters such as commas or tabs separate each field Fixed width Fields are aligned columns with spaces between each Field Preview of selected data Figure 7 Convert Text to Columns Wizard Step 2 of 3 This screen lets you set the delimiters your data contains You can see how your text is affected in the preview below Delimiters Treat consecutive delimiters as one Tab Semicolon Comma Space Other Text qualifier i Data preview E Finish Figure 8 30 Convert Text to Columns Wizard Step 3 of 3 This screen lets you select each column and set alumn data format the Data Format General converts numeric values to numbers date Text values to dates and all remaining values to text om Advanced Do not import column skip Destination 041 Cancel Back gt _ Figure 9 Best Fitting Data some of the columns may not be wide enough to display all of the data in the column The columns can be best fitted to display the widest piece of information To best fit the columns 1 Select the column s 2 Rest the mouse on the on the right hand side of the selected column heading s double headed ar
24. ce Point portal https schools dest gov au SSP The first screen you will see when you access the site is i undralian done Cab aan Banane si ot Feiner SETWCE Poimi ges af regains T atari DE 51 SSP Logon Links t 9 Other Services it i dir P fn order to mccess amy of the functionality that provided under Schools Service Pont eg Census Financial Guestionnmre CGDEP and Faancial Accountability you rmust be a registered user you aren t a user and regunt access you usd eh Cache Dan DEST hane SES funding DEST prreacy n sisternent H m CR users con furi Ex s copyright teagan Fed IOP ini Enry EIE Sch Password 3 ay 3 Octmher 06 Compliance Certifcates FIRST COMPLIANCE CERTIFICATE DUE MARCH 2007 Register now to Fill out and submit your system s school s first Compliance Certificele for 2005 Y you already hien access lo SSP log un go to Details in belt hand cde manu select Request Mew Access and update Addibonal Access Detads Further details are in our October letter bo all systems and non systemic schools eur freecall help line an 1000 677 027 you need assistance 36 SES Website When you select the SES Funding application th
25. e Welcome Page will appear with a series of hyperlinked buttons on the left side bar menu Where these take you is explained below Sign On Page SSP Home SES Home select quadrennium select client contact DEST help SES privacy notice log off text only DEST home page DEST privacy Statement contact DEST Allows you to navigate back to the Schools Service Point Homepage Allows you to navigate to the SES Welcome Page Allows you to select a quadrennium to work with Note The 2001 2004 quadrennium is restricted to viewing only if data is available Available to systems and multicampus schools Allows you to select a school or campus to work with Provides you with contact details for the Schools Grants and Data Section for example the Schools Grants and Data Help Desk Facsimile Email and Post details Provides you with on line help and useful information about the SES funding arrangements including all publicly released documents Provides you with a copy of the SES Privacy Notice which must be sent to all parents legal guardians of eligible students attending your school s at the time of the address submission Allows you to log off and end your session in SES or SSP The text only option allows you to view pages without downloading images Takes you to the Department s homepage Provides you with DEST s website Privacy Statement Note this is not the Privacy Notice that must be sent to all par
26. eleting or moving of data To select a column 1 Move the mouse onto the column heading to be selected 2 Click on the mouse The whole column will become selected see Figure 2 E F 1 SRN Address Suburb Postcode State 2 001 Joe Bloggs 55 Giffe Street Makara Bid 2002 Mary Smith PO Anula 912 NT 4 2003 John Citizen 3 75 Dinah Beach Road Darwin 300 2004 Sue Brown Lot 8 Farrar Rd Berrimah oo b 2101 Steve Green Daly River Mission Daly River f 2102 Jane White Mount Nancy Community Alice Springs aro B 103 Tim Jones Section 34 Stuart Close Katherine 950 9 2104 Jenny Black RSD BAA Ross Highway Springs Figure 2 2 Inserting Columns lt may be necessary to insert extra columns to allow for the way the data will be broken up is suggested that an extra five columns be inserted for the break up of the address To insert extra columns 1 Select the column to the right of where the new column will be positioned For example if column D is selected a new column D will be created and the original column D will become column E 2 Choose the Insert menu then Columns See Figure 3 3 Continue this process until enough columns are inserted See Figure 4 TIP If more than one column is selected when inserting columns the number of columns selected will be inserted E File Edit views Insert Format Tools Data Window Help
27. emaining information into the incorrect fields Edit Search Help 145279 2881 55 68 Griffe Street Hakara 818 HT 145279 2882 21 Exmauth Circuit nula 812 HT P H 154279 2883 3 75 Dinah Beach Road Darwin 866 HT P H 14279 208604 Lot 9 Farrar Rd Berrimah 828 HT Farrar Rd 8 Secrett 20 5 14279 2161 Daly River Hission Daly River 822 HT Lat 13 45 Long 138 41 3 N 14279 2162 Mount Nancy Community Alice Springs 878 HT Cnr Stuart Hwy amp Basso Road P H 14279 2183 Section 35 5tuart Close Katherine 8566 NT Stott Terrace H 14279 2184 R5D 622 R055 Highway Alice Springs 8788 HT Undoolya Road P H Figure 15 34 101296 4 HANDY HINTS Internet Browser The Internet browser is the software used to view the SES Website To open it you can either double click on the Internet Icon on your desktop or go through your Start menu Browsers Supported The minimum browser versions supported in the Schools Service Point SSP are e Microsoft Internet Explorer v5 01 and above Netscape v7 0 and above and e Safari 2 01 DEST recommends that you use the most recent browser version your equipment will support and that schools seek independent advice about the loading of new browsers DEST takes no responsibility for the impact of new browsers on the school s computing environment 35 Access to SES Website The SES Website can be accessed through the Schools Servi
28. ents legal guardians of eligible students attending your school s at the time of the address submission Provides contact details for General Recurrent Grants Funding for example the Schools Grants and Data Help Desk Facsimile Email and Post details 3 SES Website Welcome Page When you Sign On the Welcome Page will appear From this page you will be able to access the student residential addresses and SES scores used to calculate your school s SES score for the 2001 2004 or 2005 2008 funding quadrennium and submit student residential addresses that will be used by DEST to calculate your school s SES score for the 2009 2012 funding quadrennium Fea Sreia s 3 Incomplete Data Entry Unlocked hog This appkeaten has been desigrod ta be interactre and enabling cents to submit thee students residential addresses to the Department of Education Seance and Tr ning DEST fen government schools and systems are required to suben the residential addresses of oll students for whom the school recewves elatemert Australian Government General Recurrent Grants funding other than full bma Distance Education students Full fee paying Parar and pre school students are not for Australian Government funding and should not be included in the collection This information is collected through the SES Website The Schools Resourang Group
29. er 822 E Fill Community Alice Springs 0 O Clear Fl 34 Stuart Close Katherine 050 NT 9 Delete Ross Highway Alice Springs BAD 10 Delete Sheet Figure 11 Any data that is in the incorrect column will then need to be moved to the correct position In Figure 12 below notice that the second record which is invalid because it contains a PO Box number has been corrected and replaced with the street number and address The student names have been deleted and several other pieces of information have been included such as the DEST number See Figure 12 D J K L M 1 14279 2001 55 B Griffe Street Makara 610 14279 2002 21 Exmouth Circuit Anula 812 3 14279 2003 3 75 Dinah Beach Road Darwin 800 4 14274 2004 Lot 9 Farrar Berrimah 828 MT Farrar Rd amp Secrett Rd Sw 5 14279 2101 Daly River Mission Daly River 822 MT Lat 13 45 Long 130 41 14274 2102 Mount Nancy Community Alice Springs 870 NT Cnr Stuart Hwy 8 Basso Road MN 14274 2103 Section 34 Stuart Close Katherine 8500 Stott Terrace 5 8 14279 2104 RSD 622 Ross Highway Alice Springs Undoolya Road Figure 12 32 Saving the Data in the Correct Format The spreadsheet needs to be saved as a tab delimited file or a comma delimited file To Save the Excel data in the correct format 1 Choose the File menu then Save As 2 Click the drop
30. euo GZ z e aq Jo oouos ay Ag paubisse NYS JequinN juepnis plooay Juapn s Sjoouos o sal dde SIUL 66644 69 sybip jeujo Aq pamojjo 27 Jequunu siu 0005 e 1630 enbiun y sndue JOQUNN 1830 JO Jequnw 00 se ON 1630 9 osje 1009 e Ajnuepi SIA Aq euo enbiun y JOQUINN 1 919 J3PIO sad 1 P9MO Y uoneue dx3 OWEN 4 Suoneoyioodg pue ev y Juapn s Bulpseog uou e 10 N JO A JUSpnis 1 N JO A A Juapnis Hulpseog e si juepnis e JeujeuM sajouag N JO A JO y S AlePU099S S Alepuooas J9joeJeuo 04 JO spuaye 1uepnis e Jeyleym JO Jo ejDuis y JO 4 9 sdojs n 10 Aue se YONS UOIEWJOJUI sseJppe Jajua sjooyos pasn eq ueo 514 55010 sqe pue sajonb ejqnop sJojoeJeuo
31. ew addresses Allows you to view all addresses submitted for the currently selected school or campus help Will allow you to find out more about the online facilities accessible through the SES Website log off Will return you to the SSP Logon page An additional hyperlinked button will appear if you Logon as a Head Campus or as a school System select client Will allow a Head Campus or School System to select and data for individual schools campuses select campus 39 Hints and Tips e Full Screen feature of the browser F11 recommended for viewing SES Website he Toolbar should always be displayed e Screen resolution 800 x 600 pixels is recommended e If you notice colour changes or white patches minimise then maximise window or scroll down and back e Window size use maximised e Use fextonly mode which provides faster performance for users with a slow internet connection Do s e Use the mouse to scroll up and down and to select buttons e Use the keyboard to enter data e Printing reports click in the part of the screen you want to print then click on the printer icon in the toolbar of the browser e Always log off and shut down the browser e Preferably use higher soeed modem e Read all message windows carefully Don ts e Disclose your Sign On or Password to unauthorised personnel e Use Back and Forward icons on your toolbar e Use non Frame supported browsers e Hide Toolbar of you
32. he upload proteases and add the addresses lo Ehe DEST databace click submit addresses DF 5T eisciaimer EB mkirassas Logo Australian Government of Fducalion Ncienor Tralaleg e Part 2 of the address Upload process e Notifies that the file has arrived at DEST e When file arrives at DEST you may submit your file to the database by selecting submit addresses e If you have previously submitted an address file successfully to the DEST database you may replace all your previously submitted addresses by selecting Note This will delete all of your previously submitted addresses 13 Upload Student Addresses Feedback Successful 8 pA utis aerer E AU oof Fey OF PR oe 2 5 8 18 Home SES Hoi vun scnom any 23930 SES Test School DIRRANBANGI Incomplete Data Entry Unlacked Upload Student Addresses 2008 2012 aba des err contact ST SES privacy hag atr ont DE ST hoary pogo DF ST DE ET coprihit Logon Usar Thank you the file transfer has been successful liumber of previously submitted addresser Humber ef previous guered addresses 0 lumber ef submitted ad re
33. how the data changes choose Finish See Figure 9 O E F G H J SRN Name Address Suburb Postcode State 2001 Joe Bloggs 55 BU Street 910 MT 2002 Smith BOX B Anula 812 2003 John Citizen 57 Dinah Beach Road Darwin 500 2004 Sue Brown Lot 8 Farrar Rd Berrimah 528 NT 2101 Steve Green River Mission Daly River 822 2102 Jane White Mount Nancy Community Alice Springs 570 2103 Jones Section 34 Stuart Close Katherine 950 2104 Jenny Black RSD 622 Ross Highway Alice Springs 570 Figure 5 687 File Edit wiew Insert Format Tools Data Window Help Oe d d Ta 87 Ba 21 Sort Arial ic Uu Address B Jp Address Subtotals suburb Postcode State 2001 Joe Bloggs 55 60 validation Makara 810 2002 Mary smith BOs Anula 1 NT 2003 John Citizen 3 75 Ding Table Darwin 800 NT 2004 Sue Brown Lot 8 Farr Text to Columns Berrimah 828 NT 2101 Steve Green Daly River consolidate Daly River 822 2102 Jane White Mount iron PCENA Alice Springs aro 2103 Tim Jones Sectian 3 Katherine 850 2104 Jenny Black RSO 622 PivatTable and PivotChart Report Alice Springs aro NT Get External Data b Pata Figure 6 29 Convert Text to Columns Wizard Step 1 of 3 The Text Wizard has determined that your d
34. ligt Es incorract sgnatones changed and you i schol plesse al Ihe mare nsn the original Declarate dmn te bE fon nam ste Current to Ett on behalf of me e nproved Authonty of th Foo sheud be printed completed and the original sent b DEST wath An Asp Mare Auntratian evernimnent Department of Education Sclence and Training e Accessed from Step 1 of the Statutory Declaration process e Select an authorised person from the list Please note that the names of authorised persons listed on this page have been approved by DEST e Ifthe names listed on this page not up to date an updated Approved Authority form signed by the current Approved Signatory must be attached to the Statutory Declaration that you post to DEST he Approved Authority form can be accessed by selecting the link Form Approved Authori To complete the Stat Dec process click on the button 22 Statutory Declaration Step 3 O0 m 2 2 cx d ah xr 7 4 1 i Ted ce E SSP Home un 4 ire 30 SES Test School 8 DIRRANBANDI 2009 2012 Funding Quadrennkum SES Incomplete Data Entry Unlocked Submit Declaration amy IE 7 abi deze Name Approved Authority mw anne pers
35. n the ng link Format nt rilir PRE Step 1 Mote recommended Hast you save the file to a bd formal and remove the header row Type the poth and file name in the box below or select the address by using the Browse button Transfer the address file to DEST by clicking on the sand file to DEST button Mete 1 a button labelled Browse does not appear below your brovwder does not support File Uploading Selected file Browse send file 10 DEST 22 Submitting a file containing multiple addresses Accessed from View School or left side bar 292 gt e Transfer file to DEST o Step 1 type the path and name of the file to be submitted or use the feature send file to DEST 5 gt Step 2 Sant file to DEST xa 12 Upload Student Addresses Part 2 2 ico rp j 7 DS Home Return to Furious Fade SES Hoven wewschog 25930 SES Test School DIRRANDANDE 2009 2012 Funding Quadrennkum Incomplete Data Entry Unlocked Upload Student Addresses i22 L aba dee B 4 i vr Wann your file contains the folleveng comect DEST hein lumber of Schools In File mariber of Addresses in file Number of Addresses Mready on DEST System Number of Duplicate Addresses SES piracy 1 18 0 0 E Step 2 bat ory ST hora page L complete t
36. o confirm the registration request Step 3 Approval or Rejection of Your Request lf your registration is approved SSP will send you an email advising you that your registration request has been approved and will provide you with a password If rejected SSP will send you an email advising you that your request was rejected In this instance you should contact the HelpDesk on 1800 677 027 or ssp dest gov au Once you have received a password you can log on to SSP to access the services you requested For more information on logging on to SSP refer to the Help Section Logging On to SSP for the First Time 2 0 1285 2 WORKING THROUGH THE SES WEBSITE Guide to using the SES Website for address submission manual data entry individual address data entry file upload multiple addresses upload create upload file submit individual address upload file to DEST database submit another address submit replace all addresses addresses submission complete resolve queries certify addresses submitted to DEST are complete and correct tick box submit statutory declaration stat dec Sign On to SSP 86 irr Schools B Point sl therein ane radia regii m renee naci DEC Logon ta Other Service
37. of DEST manages the collection of student addresses and uses thes information to calculate an SES score for each n on g osvernment Srl Hote keep a record of the time you spend preparing and submitmng address dara This is part of an Australian Government comenitmant to reduce the burden of form completion Tha Time Box ig available at the and of the submission proce Ta access date for a different quadrennium select Hee quadnenniam below Finden m locked for data entry 2005 2000 Funding Ouadesraium 2002 2012 Funding Quadrannium Currenty selected Mote Bafarmatien prinided through this site es gien Ani in confidence 38 View School Page Once you have selected a funding quadrennium to work with a series of hyperlinked buttons will be available on the side bar menu Where these menu options take you is explained below View School Page Buttons SSP Home Will return you to the SSP Home Page SES Home Will return you to the SES Home Page view school Allows you to access an overview of your school or system details relevant to SES upload Will allow you to submit a file s containing multiple addresses to DEST by file upload data entry Will allow you to manually enter addresses one ata time to the DEST database stat dec Will allow you to complete the data collection sm search Will allow you to search for the address of a particular student by their Student Record Number SRN vi
38. on authorised sign an behalf of the Aporoved Authority of the school required to declare by Statutory Declnralian that conmimct DEST hein T A r P 1 r m di mu Fa F T number 05 recorde submitted to DEST cCorrespand the number e enrol at hie school M This Gale eyida SES privacy notice suden and er are net lor Australian Government General Recurrent hanidenig hog The Addresse Me residential amp d recsses dl studente enrcelled at Ehe and AFA Hote has been proviced he parent er qu ardian Ol each studeant Tor wien a residential hos Deer PITA El Pie aro click thes box to certify that you are satishicd that the addresses submitted to DEST are complete and correct Your dais vell hie Ipcked immediately once you click on the submit declaration button Your access will then be restricted to v evang your data only No Further editing will DEST homa pogo be pasable undesa vie an Ln sck Regra lo BEST DEST privacy Semen Mete fs recommended that you print report of all y et ta BEST belme disclaimer Fraser mmni of Ehe fime ien tn completo the FS address data callectinn proces Legon Usar n i Include the total time spent
39. oue OWEN 199 19 OWEN sqe pue ejqnop seyonb ajBuis ue ue si aJay lessegau sJojoeJeuo og sdojs nj 10 daoxa Aue SI siu JO Auedoud e jo sejoueg Jo n sqe pue ejqnop seyonb aj u s sJojoeJeuo sdojs n 10 3deoxe sJejoeJeuo Aue Jo esnou e jo Jequinu enbiun ay sejoueq JequinN esnoH sqe pue seyonb ejqnop JequinN sJojoeJeuo sdojs n 10 3deoxe sJejoeJeuo Aue yun e jo enbiun ay seyoue 10 Up epis ASY 10 gis UOHOd JequinN sqe pue ejqnop seyonb oog 401 asay sseJppe ue uM pejeroosse Jequinu esnou jo eouesqe 10 sJojoeJeuo Gz sdojs nj 10 daoxa Aue s uaym euonppe Jo javed pue sejoueq uonoeg 101 Y m m SJo oeJeuo 1104 JO eJnjxiuJ e Jo 0 sndujeo Jo OOUDS ay ui juepnis e enbiun NYS JoqunN SJojoeJ
40. r browser Troubleshooting You can t get started o Check your Internet connection and browser are working o Check your platform and browser version Internet connection failure or Internet connection busy o Wait 2 3 minutes until message disappears or shut down browser and retry You lose the buttons on the left hand side o Minimise then maximise the window to restore You selected SESHelp but the page did not come up o Some features such as SES Info and Help open in a second window Minimise the current window to view the second window Having problems accessing the Internet or submitting your data Callus 1800 677 027 Email us grantsanddata help dest gov au 40 5 FORMATTING AND FIELD SPECIFICATIONS FOR THE STUDENT ADDRESSES 41 sqe pue seyonb ejqnop ajbuis Ayyeo07 sJojoeJeuo 5 0 5 10 3deoxe sJejoeJeuo Aue Jo diusuwo Aj eoo eu sajouag Jo qunqng sqe pue seyonb ejqnop sJojoeJeuo sdojs nj 10 daoxa Aue 1925910 JO e jo ad ay 10 ad 199 19 sqe pue sajonb ejqnop sajonb sJojoeJeuo og sdojs nj 10 daoxa 5 Aue 10 e ay sey
41. row appears 3 Double click All of the data in the columns is now visible see Figure 10 B E F H K TSEN Mame Address Suburb Postcode State 2 2001 Joe Bloggs 55 Giffe Street 910 3 2002 Mary Smith BOX Anula 812 NT 4 003 John Citizen 3 Dinah Beach Road Darwin 500 5 2004 Sue Brown Lot 9 Farrar Rd Berrimah BAS b 2101 Steve Green Daly River Mission Daly River Baz 2102 Jane White Mount Nancy Community Alice Springs 8 2103 Jones Section 34 Stuart Close Katherine 850 9 2104 Jenny Black ESO Ross Highway Alice Springs SFU NT 10 Figure 10 31 Deleting Rows and Columns The data may contain column headings such as name and address This row will need to be removed as will any extra rows or columns It is preferable to delete all column headings before saving To delete a row or column 1 Select the column or row 2 Choose the Edit menu then Delete See Figure 11 File Edit View Insert Format Tools Data Window Help O Undo Column width Ctrl z or Mr 8 Arial Sho B E Redo Delete Ctrl Y cur eux LE JE IHL pr Es 2 a Suburb Postcode State 2 conv u ED Giffe Street Nakara 810 NT 3 Bosse 812 NT 4 Paste Special 75 Dinah Beach Road Darwin 800 E Paste as Hyperlink 9 Farrar Rd Berrimah 828 MT E 2 EF Mission Daly Riv
42. s tn order to access any of the functionalay that t provided under Schools Service Point eg Census Financial Questionnaire and Fnanciel eee you must be a registered user DP you aren t a user and require acces you mud CGDEP Capes Coach 5 Paring rg UEST heme page SES funding DEST privacy infa sistemani gana Pini ipte RE japana hiini users can hanam here UFSI Foren Fel 1005 2 pube Schr Password ias Forgotten your Legon Latest News 30 Oecher 2006 Compliance Certifcates FIRST COMPLIANCE CERTIFICATE DUE MARCH 2007 Register now to Fill out and submit your system s or school s first Compliance Contificate for 2008 TI you already have access lo SSP log un go to Details in the belt hand sde menu Select Request Mew Access and update Addibonal Access Detads Further details in our October letter bo all systems and non systemic schools eur freecall help line an 1000 677 027 you need assistance e The address for the Schools Service Point SSP portal is https schools dest gov au SSP e Full Screen F11 recommended contact DEST e Hyperlinks eg or click here appear throughout the SES website Security Logons and Passwords are unique and are issued to individual schools and oystems by DEST see Section 1 e Change Password recommended Select the
43. tem DEST Number e The address of your school will also appear e When certified the number of addresses submitted including unusual circumstances and the date and time will be shown e You must POST the original signed Statutory Declaration to DEST LCN 1M1 GPO Box 9880 CANBERRA ACT 2601 24 View School Page Locked ix do PA t 4 A SSP NOT 2930 Test School 8 DIRRANBANDI 2009 2012 Funding Quadrennium SES Completed Data Entry Locked View School important This school locked from making any further changes fo address The dala can b whacked for further editing by sending an Unlock tT view or all student addresses click on des addresses GEST Number 25930 hog ort School Name SES Test 57021 8 Location Address School Ave DIRRANBANDI OLD 4484 Hor Dee errr een Aram DEST homar page en atatacvend Latitude 0 copyrihit School SES Details SES Score Hol yet allocated SES States Completed Data Entry Locked Number of Student Records 15 Humber of Addresses 15 Legen User umber of Unusual Circumstances 0 Denartraenmi of Ficatlan Science and Trginim e When the Statutory Declaration has been submitted the data are locked and restricted to viewing only Locking the data prevents any further changes to addresses and ensures the integrity of the Statutory Declara
44. tion e f you wish to have your data unlocked for further editing please send an email link provided on the Welcome Page to DEST In this event another Statutory Declaration will need to be completed and posted to DEST 25 Having problems accessing the Internet or submitting your data Callus 1800 677 027 Email us grantsanddata help dest gov au 26 01285 3 PREPARING YOUR STUDENT ADDRESS RECORDS IF USING EXCEL The data in Excel need to be formatted in a particular way for the DEST SES Website to be able to read it and store it correctly By having the data in the correct format it will enable the information to be submitted successfully to this site The table on page 45 provides an example of how address data may look in a spreadsheet programme such as Microsoft Excel Figure 7 is an example of how your data may currently be displayed in Excel Name Address suburb Postcode State 001 Joe Bloggs 55 Giffe Street Makara Bid NT 2002 Mary Smith PO BOXE Anula 812 2003 John Citizen 3 75 Dinah Beach Road Darwin 300 004 Sue Brown 10 9 Farrar Berrimah 028 NT 2101 Steve Green Daly River Mission Daly River Bag 2102 Jane White Mount Nancy Community Alice Springs Bid 103 Jones Section 34 Stuart Close Katherine 950 NT 2104 Jenny Black RSD b22 Ross Highway Alice Springs aro Figure 1 Selecting Columns Being able to select columns or rows allows for quick formatting d
45. zpes iter upload 18 Humber of quinto orar upad 0 Stalulory must be completed after all the address dala for Ihe school Are submitted cornecthy Austral lan Government e Part 3 of File Transfer Feedback Successful e Notifies that the file transfer has been successful e Options available Submit another address file using the upload function Add edit or delete single addresses using the data entry function Complete the submission with a Statutory Declaration by selecting the stat dec function 14 Upload Student Addresses Feedback Unsuccessful SES Howe view schon 15930 sts Test School 6 DIRFUANBANDI 2009 2012 Funding Quadrennkum Incomplete Data Entry Unlocked Upload Student Addresses Bii Sau aba ve our upload was unsuccessful due to the following errors Piense ensure that all errors listed below are resolved before resuhmitting your DEST scdresss cata SES privacy hog 25330 TH ERZABCDE Student Record Tha Record SAH cam anb contara ahaha Number SRM character 2 2 AE numenc characters 0 9 or a mixture of iat omy bath characters DEST hose le cards found DF 5T privacy stel disciaimer Logon Liar e Part 3 of File Transfer Feedback Unsuccessful e Notifies that the file transfer has been unsuccessful e Notifies you of
Download Pdf Manuals
Related Search