ESiF User Guide Version 2.0 – September 2008
Contents
1. Ethnic group Categories All v Categories Custom Selection Gender Male Female Ethnic group White Mixed Black or Black Asian or Asian Move to row rBlack Asian or Asian Chinese and other Total a ae British British muse as Filter ish British ethnic group Remove from table Very satisfied 92 333 33 3 25 0 0 0 Fairly satisfied 47 4 667 33 3 Insert Calculation 25 0 3 0 0 Neither 289 00 i 0 0 100 0 372 00 50 0 100 0 Fairly dissatisfied 14 00 33 3 00 102 00 0 0 0 0 Very dissatisfied 34 00 0 0 0 0 19 100 0 0 0 0 0 Total 100 0 100 0 100 0 100 0 100 0 100 0 100 0 100 0 N 42 3 3 1 411 1 4 1 838 Type Column percentage x The illustration above shows that cross tabulations can also be changed by using dropdown boxes that work in just the same way as those for tables charts and maps This includes an option to remove variables from the table and to change the type of results displayed For example to view raw numbers as well as column and or row percentages Changing the type of data displayed There are four ways to display the survey data and these options are controlled by using the Type dropdown This allows you to look at the answers to survey questions in a number of different ways Column percentage Type Column percentage In this case the percentages are being calculated vertically ie maie Femaie tots Therefore the 9 6 in the Very satisfied Male box illustrates that Seielacien E Bersuah C2. fi Council tax band Click on the EM box to open the default view of the Dwelling projections House prices published table for any of the listed datasets This will A o appear in the main screen a Loot TEE housing register by size of dwelling required 2000 2007 districts You can click on the Description tab to view information about the dataset the metadata Once you have clicked on a t box to reveal the themes or sub themes beneath the expanded box turns orange Clicking on any orange box has the opposite effect closing all the layers beneath it This can be helpful to stop the navigation tree getting too cluttered The NEW symbol The S amp symbol indicates a dataset publication or survey that has been added to ESIF or edited and re published over the last 30 days Viewing metadata Metadata means information about the data and we have published comprehensive metadata with every dataset survey and publication in East Sussex in Figures This provides important background information about our published resources so that users know what data you re looking at You can view the metadata for any dataset survey or publication at any time by clicking on the description tab shown above To go back to the data click on the Tabulation tab There is more information and guidance on how to use metadata later on in this guide The default view for a table When publishing information
3. Back to contents Page 15 of 32 ESiF User Guide Released Version 2 0 September 2008 Area Selection Click and drag a box on the map The map will zoom to the area within the box drawn once you have released the mouse button Before After The map data table Select features Click the name of a geographic feature to select A selected geographic feature will be shaded orange see below Districts gt gt All claimants gt gt Number of claimants gt gt Jun 08 Clear Ke Crown copyright All nights reserved 100019601 and 100062160 2008 Ov Sort Columns Click a column header to sort the table ascending descending In the example below the Area Name is sorted in descending order arrow pointing up Note that associate values typically shown in columns to the right of indicator values always sort as if they were text Area name astboume Hastings Magnifying Glass Icon Click the magnifying glass icons to get the map zoom to i individual geographic features Horizontal and vertical scroll bars will be available if data cannot be viewed within the table dimensions Background boundary box You can select background mapping and boundaries by clicking the relevant buttons next to the titles the box will then go from clear to black In the example below Background mapping and Ward boundaries have been selected The underlying data is still mapping at district level Eastbourne has
4. Back to contents Page 22 of 32 ESiF User Guide Released Version 2 0 September 2008 The last analysis performed is automatically re executed To indicate that a weight variable is in use the message Weight is on appears below the results of any analyses or graphics By hovering over this message the label for the weighting variable will be displayed To remove weighting from an analysis 1 Click on the Weight icon 2 Click Clear to remove all weight variables 3 Click OK to return to the previous page Charting survey data You can very easily create charts of the tables of survey results you produce by clicking the hil chart icon Please refer to the section on Looking at tables in charts in this user guide for more information Additionally Pie charts can be created when there are two or more variables in the table but no measure variable Example of pie chart created in Surveys l Wery satisfied MFairty satisfied Wineither WFairty dissatisfied Wery dissatisfied Multiple response tables In some surveys respondees are asked to give a number of answers to a certain question For example what are the five most important factors that make a good place to live in In this case the survey results are published in the form of a dataset M along with the other survey data This dataset works in exactly the same as the ones published under Tables charts and maps However the detaile
5. E East Sussex East Sussex General User Survey 2006 7 Variable Description Code Frequency of all of walid Survey sample characteristics ae a zE b Gerdi Add to row Dataset East Sussex General User Survey 2006 7 Age Sr Add to column Use as filter Ler dd as measure Neither k esmentem oie area Housing tenure Broad housing tenure Very dissatistied Number of adults in household Sv ShtlS Employment status Broad employment status Disability Fairly satisfied Fairly dissatisfied Total H E E b b H b H E b e You should then have the question tabulated with the survey sample characteristics below in this case it is gender has been added to the column Back to contents Page 20 of 32 ESiF User Guide Released Version 2 0 September 2008 Satisfaction with East Sussex Cou Council Categories fender iiale Female Wern satisfied Fairly satisfied either Fairly dissatisfied Wern dissatisfied Total You can add more than one variable to the rows and columns of a table You can also use the Add to layers option to further filter the results being displayed For example you could analyse satisfaction with council services according to respondents ethnicity but also using gender as an additional filter Customising survey data using the dropdown menus Dataset Eastbourne General User Survey 2006 7 Satisfaction with Eastbourne Borough Council Categories Gender Categories _
6. The values displayed in any table represent the currently selected measure for the dataset Measures allow you to compare data from different geographies and may include percentage rate per population or rank To change the measure you are viewing just click in the box to open the full list of available measures and select one by clicking again Some tables only contain one measure Working with the dropdown boxes Apart from the measure box all the other dropdown boxes are structured in the same way with different types of option being separated in the dropdown list by a dashed line Details of the different elements contained in the drop down boxes are given in the table below You can return to the original default view of any table at any time by just clicking on its Ei button again or the recycle icon in the top button bar You can also use your web browser s back and forward buttons to undo or redo actions Back to contents Page 8 of 32 ESiF User Guide Released Version 2 0 September 2008 The structure and content of the dropdown boxes Districts Wards Super output areas Custom Selection Ci Move to column Use as Filter Insert Calculation 1 Title of the variable box 2 Different elements of the dataset hy ey hy Cy ox OW East Sussex M Eastbourne MV Hastings M Lewes M Rother OV Wealden ET Alfriston M Wealden 0184 Wealden 0185 ET Buxted and Maresfield M Wealden 0084A M
7. the ESIF Newsletter The ESiF newsletters are published in ESIF when they are released Hard copy versions of the newsletter are also available on request User guides There are two versions of the user guide available the Quick reference guide and this the more comprehensive version Other publications Contains guidance on the mechanics of data collection and dissemination The Which series of publications e g Which geography will tell you why ESiF publishes data for different geographies and how these geographies interact Published indicators Every month we publish a list of all of the datasets available on ESIF and the level of geographies they cover As of August 2008 there were over 300 datasets published on ESIF This figure may increase as we source additional data However a lot of datasets on ESIF are updated monthly in the case of JSA claimant counts or annually in the case of Key Stage attainment and so the number of datasets will slowly level out but become increasingly comprehensive Published maps There are over 50 maps available in ESIF some are boundary maps e g Wards in East Sussex and some are Thematic maps e g 2007 Indices of Multiple Deprivation The maps are high resolution and can be printed to A3 size without any loss of quality Opening a publication The instructions below show you how to open one of the LAA Performance Monitoring reports but the same principle applies when opening all
8. been selected and is coloured orange but the ward name now appears when you Back to contents Page 16 of 32 ESiF User Guide Released Version 2 0 September 2008 hover over a particular area If you chose to zoom into the map the background mapping detail will change accordingly To turn off any of the options just click on the blacked out button Note You can select more than one boundary to be displayed on a map but the names of the largest geographical areas are displayed Therefore to display lower super output area names the ward boundaries need to be turned off Legend Help Districts Fagg enoaks M20 i R igate gt ag gt gpu onbridge l A Equal interval legend N p a TOR ick Sgt 3 es 2 640 874 ns ka Or LN se A East ells A 875 1 107 1 108 1 341 1 342 1 574 i Ro PE or OR y 1 575 1 80 Th MW Ra Nes Map layers eat PY Cus soe oe tT Ward boundaries gt w LA ve we Hastings _ Parish boundaries aan r N Bexhill C Electoral division boundaries Brighton LES Eh f Super output area boundaries Newhaven Eastbourne Background mapping Beachy Head KE Crown copyright All nights reserved 100019507 and 100092160 2006 RP Histogram or bar chart Bars There is a bar representing each geographic feature listed in the data table The height of bars is proportional to indicator values Bars are displayed in ascending order and shading i
9. other themes such as Published maps Click on the i box next to Local Area Agreement LAA performance monitoring this opens the theme You will then see all of the publications available under that theme with Back to contents Page 24 of 32 ESiF User Guide Released Version 2 0 September 2008 a icon next to each publication Click on the icon this opens information about the publication its metadata in the main viewing pane 4 Click on Open resource in the main viewing pane this opens the publication Note Publication s metadata might also include web links to other related recourses Publications are normally only available in PDF format so you will need to have a copy of Adobe s free Acrobat Reader installed on your PC to view them Opening ESiF help guides You can open PDF versions of this ESIF User Guide and our initial guide to Getting Started with East Sussex in Figures by clicking on the box next to User guides in the main navigation pane and following the same procedure as for opening a publication see above Both guides can also be opened by clicking on the links given in our main Getting started page Area profiles This is where you can view and print summary profiles for different parts of the county When to use Area profiles Area profiles contain a number of pre determined tables charts and maps that present key information for different geographical areas Area profiles are
10. publications available in ESIF cccccscsccseseeseeeeeeseeeeeeeeeeeeseeaeeaeeeseeeeesannegs 23 Opening a UOC EON ection ecitn sean ENE EEEE EEE AEE EERE 24 Opening ESIF h lp gUiIdES siiriisrirsirsririnieriinreicrenkeneirnnnninn iin tk niarra Ka Nnnna AEAEE aiani 25 Per a E O E E E A EE A E E E E E E 25 When to use Area profiles n nsnenensnsnsnsnunununersnsrsrnrsnnnununsnsnnnnnnnnnnnnnnnnnsnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 25 opening an Area Drol G arsina T E EA A ETa ai 26 The Area profile breadcrumb trail cccsccsecececceconenecuececcecarenececueouececaesascnsarsueceeuesusensarsenenss 27 Printing Area ONO MCS srini ativan saetinsaansceenees canneesncaeeuenth ANEN ERENER NAN AAA SEENE EA AAAA 27 Oer Useful TCE ONS sar R EAER 27 LDA g Ghose ce acre E EA N EE A EEEE A ENN N 27 PAANO OyG MA e e E S EA E E E E 27 EONO PEO erara E A E E E E S 28 Using metadata when extracting data from ESiF ssssssssssssrersrsrsrsrnrnnnnnnsnnnnnnrnnnnnnnnenenenenene 28 DPO MNS EX O ara EEEE 28 Creating DoOkmMarkKS seriineiiiriienrianikitei inerneta a 29 OS ACPI e PETEA EEE E EE E E E E E 30 FY FS UNS aE E E EE EEEE E EA E EEE E a 30 COPYING earna ei E EE E E E AO E EE eee ee er 30 The main icons in ESIF and what they CO cccscscscsceseeeeeneneneseseeseneneneneneeseeeneneneneneeessenens 31 M re NFOrMaATIO I ssrin AAi 32 Back to contents Page 2 of 32 ESiF User Guide Released Version 2 0 September 2008 Introduction The
11. reS siriasi iia EEEE Eaa iaaii 18 Back to contents Page 1 of 32 ESiF User Guide Released Version 2 0 September 2008 Pining el Cle MD OFING Mal S cescccececacenesiessacnaccsseecewandasesancessuces EEEE AEA 18 EOE at survey daU ia isch aed sdaaemcnvacsantiadeneresusaciiavamerseusscubidiesndpersdsunerednsetmsdcnreriatvaaise 18 When to use SUV SYS asses wacaseaamitessunanscunnusatianacsnesiaueatnesqaueoasinesaensmncuacasontaanevieesuaaanasepqeaneseuaed 18 OD NNE SUN VOY ace cet contac tee ciape cia ce ctr ecieee wets see set cee teeta eee 18 The survey screen aiecdicccen seencarnctta ameaaecenenesucaeuaaecennaadeneananseraeecioninenienasaciniereeuanheiaronnnds 19 TGC el SU Oy E TE EEE A E PETE E EEE E A 19 AEE EET EEE E PN T ENA A A E EA EE E A A 19 Customising survey data using the dropdown mMenUsS s sssssssesessrsrsrnrnrnrnrernrernrnrnrnrnnnenrnrenne 21 Changing the type of data displayed ccccsesecsecercnccecuececcecarsnscncarsuececuecsesacarsuroneceseesasaesanses 21 Weiontung SUIVEYS cerca ateerconesancenensenanesenna Aai 22 Charting survey data sie ircascoascsictscsectncirsancmanion teres peeiieaneatgaunscennensuicdsttainisadesnuvsinevaneacaceunt ehatavenirdeneeiciass 23 Multiple response LADIES war tacts camevancaameneaaaseenmpaasteienenstsacqansiaseinpadeseensaanteenaian ashen smaaisepseanaeeey nine 23 Viewing publications published maps and user GUIGES ccscscceseensnenenenenensenenenenenseeenens 23 The main types of
12. screen Selecting the chart options DESCRIPTION BARS aye Dataset School pupils by year group in 2006 7 super output areas Geography Districts Year group Mixed fear group All pupils Huren schools Primary schools Secondary schools Sixth forms Feo grap hy Eastbourne 141 502 6 555 4 036 Hastings 12 742 6 o24 6 299 Lewes 10 366 6 143 4 446 Rother 10 073 4 540 4361 Wealden 17 971 9 873 6 916 Bar charts Dataset School pupils by year group in 2006 7 super output areas Clicking on the nll button enables you to chart the data for one point in time 37 500 nan and presents options to produce single 32 500 ae or multiple dataset charts for a e horizontal bar chart by clicking the F ai or button or a vertical bar chart mam m eiai by clicking on the all or Mil button ma iaoiai as shown in the example to the right 10 000 E Sixth forms 0 4 Geography Time series charts Dataset JSA claimant count 2006 2008 wards TO produce a chart of time series data Secaraptn Bites you need to click on the 2 button 4 00 When data tables are not published as time series the 2 symbol will be greyed out Eastbourne gt Hastings Claimant rate Lewes gt Rother oe To return to a table view of your data at any time just click on the button Back to contents Page 12 of 32 ESiF User Guide Released Version 2 0 September 2008 To change th
13. specifically for you from the web server Because of this it is not possible to damage the site of the data contained ESIF uses two applications 2 p v NEesstar Eo 3 unlocking data creating knowledge i FN Na a i instanta las Geowise Instant Atlas Nesstar Webview Specific help pages created by these organisations can also be obtained via ESiF by selecting the I rw gt or buttons respectively Back to contents Page 3 of 32 ESiF User Guide Released Version 2 0 September 2008 Getting into ESIF ESIF does not require users to log in You do not need a username or password and it is free for everyone to use ESiF s web address is www eastsussexinfigures org uk System requirements To get the most out of ESIF you will need e a broadband connection to the internet e to be running Version 6 or later of Internet Explorer e to have installed a copy of the Adobe Reader for viewing PDF files and e to also have installed Adobe SVG Viewer for viewing maps Note If you are using a networked pc that has restrictions on installing non standard software it would be advisable to contact you network administrator before attempting to install SVG Links for downloading all the above software are given on ESIF s Getting started page There is no charge for installing this software on your PC Screen layout When you enter the site you will see that the screen is made up of three frames East Susse
14. the options Dataset Occupations in 2001 super output areas Occupations Mixed M Measure Number M All people aged 16 74 Managers and Professional Associate professional Adminstrative and Skilled Personal Sales and Process plant and Elementary in employment senior officials and technical secretarial trades service customer service machine operatives 23 627 754 3 570 069 2 639 365 3 256 877 3 148 893 2 751 249 1 633 592 1 812 500 2 010 090 2 805 119 3 888 756 678 238 470 331 568 493 538 365 426 576 269 121 285 578 244 489 407 015 211 242 34 618 22 142 29 296 27 604 27 809 18 244 15 786 12 644 23 099 36 713 5 216 3 530 5 1035 4 577 4 640 3 422 3 329 2 196 4 768 35 498 4 732 3 084 4 544 4 394 4 696 3 443 2 904 2 759 4 442 41 137 6 557 4 768 5 740 5 553 5 244 3 353 2 968 2 630 4 324 33 380 5 721 3 401 4 539 4 290 4 710 2 958 2 311 1 805 3 595 64 514 12 392 7 359 9 388 2 290 3 519 5 068 4 274 3 254 5 970 The title and number of any other variable boxes like the occupations box in the example above will vary from one dataset to another according to the data contained For example if data is also available for a number of months or years rather than just one point in time there will also be a box for the user to select relevant time periods of interest All dropdown boxes all work in the same way You simply open a drop down list of options and then select one of those options by clicking on it The Measure dropdown box
15. the screen Printing and exporting maps There are a number of ways that you can export maps into other applications for reports etc Please refer to the section on Printing SVG maps later on in this guide for further information Looking at survey data ESIF also provides simple but very powerful tools for exploring the results of representative sample surveys Exploring survey results is easy and works in a very similar way to the methods used for looking at data in tables and charts When to use surveys Where tables charts and maps provide accurate data for specific geographical areas surveys contain subjective information about people s opinions The way that surveys are published in ESIF allows you not only to examine what answers were given but also who was giving the answer For example the gender age or ethnic group of the respondee person who answers the question Opening a survey Tables charts amp maps a Click on the box next to Surveys East Sussex Business Survey 2007 E BYPI General User Surveys 2006 7 Oe Click on the box next to the theme for the required survey Variable Description Survey sample characteristics How well the council performs gt Satisfaction with East Sussex County Click on the box to open brief details about the survey its Council metadata and further options My Council is making the local area a better place to live My Council is wor
16. to ESiIF we decide the content and dimensions of each table that users see when first clicking on the El icon This is known as the default view The default view may includes data for the county and each of its districts together with comparative information for the South East region and the country as a whole when comparative data is available The title of the table will tell you whether more detailed information is also available for the same dataset at sub district level Customising tables ESIF allows you to change the content of the table that you are looking at for example you can e view data for specific areas or levels of geography Back to contents Page 7 of 32 ESiIF User Guide Released Version 2 0 September 2008 e look at information for specific time periods e explore different measures for the same data such as percentage figures rather than absolute numbers and e Insert your own calculations and create your own geographies Dropdown boxes The screen example below shows that there are a number of dropdown boxes directly above each table You can use these to make different choices about what data you want to view and how you want this presented The structure and content of these dropdown boxes between datasets is very similar and you should get the hang of working with them quite quickly once you have gained experience with what they do Click on the down arrow next to the title in the box to view
17. when you are in a particular dataset publication or survey See TABULATION ANALYSIS You can use the information in the metadata to help you to put the data in context and give more meaning to the data for the user For example for the bar chart above you may want to add This chart shows East Sussex school pupils by type of school in 2006 7 it provides summary information on all pupils who live in East Sussex and also attend schools maintained by East Sussex County Council Note This dataset does not include information on all school pupils that live in East Sussex neither does it include data on all pupils in East Sussex schools The information Is taken from the School Census which is carried out three times a year and Is co ordinated by East Sussex County Council Source East Sussex in Figures Exporting to MS Excel You can very easily export any data table including cross tabulations of survey results to an Excel spreadsheet for further analysis etc by just clicking on the i spreadsheet button in the main toolbar In order to take the spreadsheet off the ESIF server simple select File and then Save As and then save the file in the desired personal folder Geographies on ESiF are always published in the same order e g the districts are always displayed in alphabetical order Eastbourne Hastings Lewes Rother Wealden Therefore you could export a number of datasets from ESiF to Excel and copy and paste into o
18. 9 j Very dissatisfied The answer options Summary Statistics Type Valid Valid cases 1216 The number of people Missing cases 62 who answered that option This variable is nupAeric Percent of total Number of responses Responses that for some reason could not be included in the results The actual survey In most cases a copy of the actual survey is published in PDF format with the survey data It can be found at the bottom of the survey options next to a Publications logo J See below for an extract from the East Sussex General User Survey 2006 7 that relates to question 16 see the Survey screen above O16 Taking everything into account how satisfied or dissatisfied are you with the way the authority runs things Please tick one box only LI Very satisfied LI Fairly satisfied C Neither satisfied nor dissatisfied L Fairly dissatisfied LI Very dissatisfied Analysing survey data As well as viewing the distribution of results for different survey questions ESiF allows you to analyse survey data in much more detail by producing cross tabulations where the results of one question are also related to the answers from another question Typically this is something that you might want to do analyse the results for any question according to certain key characteristics of respondents such as their age or sex or where they live Back to contents Page 19 of 32 ESiIF User Guide Released Version 2 0 Se
19. County Hall Lewes BN7 1UE 01273 482030 tim carpenter eastsussex gov uk Or use the electronic feedback form available on the Contact us Page Back to contents Page 32 of 32 ESiF User Guide Released Version 2 0 September 2008
20. Ee tua i Leto they will be returned in alphabetical order Lewes Castle ward Lewes Lewes Priory ward Lewes Click on the area you require select your profile You then have an option to select the type of area profile you require VYard profile for Lewes Bridge Please select the type of profile you want to view Please select x Please select Economy profile General profile Housing profile Population and households profile The resulting area profile always starts with a contextual map of the selected area Economy profile for Lewes Bridge ward Lewes ke amseyZ ys er Geli ea f i J ameni gr 188 S ug 7 Na daenna if Ye N 2 a I PA A Wy T r ey P k ZEN Fol i A Y ANS LON Pa F AR TY ge Ny WAP Ris Barn AN x The Brooks YN x Oe 4 N Back to contents Page 26 of 32 ESiF User Guide Released Version 2 0 September 2008 The Area profile breadcrumb trail Select your area Search results Select your profile Economy profile for Lewes Bridge ward Lewes Just above the Area profile dashboard you will see a breadcrumb trail This allows you to go back a step without having to start another area profile creation from scratch For example if you clicked back on Select your profile stage 6 above you could then create another profile for same area in this case Lewes Bridge ward Printing Area profiles There is a separate sectio
21. Wealden 0086 Wealden 0134A ET Chiddingly and East Hoathly l Wealden 013B Wealden 013C ET Cross in Hand Five Ashes M Wealden 0114 Wealden 010A ET Crowborough East M Wealden OO6A zi cee RP ONCE jc Internet A 4 Move to column or row 5 Use as filter For example Geography or Year group Clicking on an option here enables you to look at one particular subset of the overall dataset For example you could choose Ward from the Geography box to view data for all the wards in East Sussex This enables you to select different categories of data For example to view information for one district and all its wards or for a complete mixture of different types of geographies Selecting Custom selection opens another window with a list tree in it that is similar to the main navigation pane If a category can be expanded to reveal further options below it will be shown against a sign which you click on to expand once a category has been expanded this changes to a E sign Within this view you select elements that you may or may not want by clicking the tick boxes to add or remove items At the top of the window are options to Select all or Deselect all items in the dataset Once you have made your selections you click on OK to see your choices reflected in the table Note it is often better to revert to the default view for any table before using this option This option enabl
22. Z Insert Calculation Microsoft Inte Biim Ea Type of calculation A E 1 Click on the Insert calculation box Search for categories amaA 2 Select the required variables you wish to add in this case ET East Sussex districts Click on the box next to the names of the variables cancel to tick the box i 3 Select the type of calculation you would like to make in this M Rother case Add M Wealden 4 In this example constant is blank and the there will be no decimal points To include decimal points in your calculation enter the number of decimal points you require in the ooo Decimals box decimas Bd sd Type the name you would like to give the calculation Label 6 Press OK top right button Done Internet j s z 7 The calculation result will be returned at the bottom of the table Dataset School pupils by year group in 2006 7 super output areas Geography Mixed v Year group Mixed M Measure Number x Year group All pupils Nursery schools Primary schools Secondary schools Sixth forms Geography East Sussex 63 454 607 34 924 26 057 1 866 Eastbourne 11 802 191 6 535 5 036 40 Hastings 12 742 204 6 824 5 299 415 Lewes 10 866 114 6 143 4 445 164 Rother 10 073 45 5 549 4 361 118 Wealden 17 9714 53 9 873 6 916 1 129 All districts in East Sussex 63 454 607 34 924 26 057 1 866 This is a simple example to demonstrate how this function
23. ain icons in ESiIF and what they do Listed below are the main icons used in ESiF Each one of these icons is described in detail in the User guide The home button effectively re sets ESiF but will remove any dataset you are currently looking at H Opens themes and sub themes in ESiF Closes themes and sub themes in ESiF Go Allows the user to carry out a single word search on all of the content in ESiF aes Allows the user to tab between the metadata data on data and the dataset or survey fe Opens a dataset Opens a survey i Opens a publication z Takes the user form a chart or map back to a table view nll Creates a bar chart from the data aal Creates a time series chard from the data when available cy Creates a map from the tabled data amp Takes the dataset back to its default view Sel Allows the user to weight survey data surveys only a Converts the table on view into MS Excel format ard Converts the table chart or area profile into PDF format Bl Sends the table chart or area profile to the user s selected printer a Creates a bookmark select browser bookmark ra Opens the help page Back to contents Page 31 of 32 ESiF User Guide Released Version 2 0 September 2008 More information For more information about East Sussex in Figures please contact Tim Carpenter East Sussex in Figures Co ordinator Research and Information Team Transport and Environment Department East Sussex County Council
24. ata ESiF tables are pre formatted for ease of use but the data in the tables can be exported if required see the section on exporting data to MS Excel There are over three hundred datasets on ESiF containing very detailed information on all aspects of the county When available comparative information is published This allows the user to compare trends and performance between East Sussex and its component geographies and other areas in the rest of country Once you have created a table you can graph or map the information How Tables charts and maps are organised Available datasets are currently organised under eleven headings or themes These themes are access to services community satisfaction crime and community safety deprivation economy education learning and skills environment health housing population and households transport Under these eleven main themes the available datasets are organised under a number of more detailed sub themes to make it easier for users to find the information that they are particularly interested in Table titles Our naming convention for the titles of tables provides important information about what time period s the dataset covers and most importantly the different administrative geographies that the data is available for Generally our aim is to publish information at the lowest geographic scale that is appropriate given confidentiality constraints etc and the data that is
25. available The last part of each table s title always indicates the lowest level of geography that the particular dataset covers Typically lower levels of geography nest within the next level up in a hierarchy that as far as ESiF is concerned extends upwards from e super output areas wards districts gt county gt region gt nation or from parishes gt districts county gt region gt nation Because there is not a consistent relationship or perfect fit between the borders of parishes and super output areas and wards we cannot publish data for all these geographies in the same table or hierarchy This means that there are often two versions of the same dataset presenting the same data in the two hierarchies outlined above Comparative data is sometimes published for statistical neighbours i e areas that have a similar area or demography to East Sussex for this particular dataset Back to contents Page 6 of 32 ESiIF User Guide Released Version 2 0 September 2008 Opening a dataset table Click on the box next to Tables charts and maps Search Go Click on the box next to one of the eleven themes to E Tables charts amp maps Access to services open a list of more detailed sub themes E Crime and community safety E Economy i Click on the amp box next a particular topic to reveal the Education learning and skills Environment available datasets under this sub theme E Housing
26. available for every ward and parish in East Sussex as well as for each district and for the county as a whole This allows you to obtain a large amount of key data in very little time You can search on an area by either entering a postcode or the name of the particular area you require data on Back to contents Page 25 of 32 ESiF User Guide Released Version 2 0 September 2008 Opening an Area profile Click on the box next to Area profiles and select the select you area profile hyperlink select your area Please select your area from the options below In the fist box enter the name of the area or its l full postcode this is useful when you are not First enter the name of the area or its full postcode i sure of the name of the ward or parish you e g Devonshire or BN21 3AB require data for You can also enter the first few Then select the type of area you want a profile for letters of a particular area e g entering S and Please select selecting Wards will return all wards that start t Ti with the letter S In the second box you have a choice of selecting either the Local authority including the county Ward or Parish Make your selection and then click on Search ESIF will then search on your criteria and return search results all areas that match the search If more than To view a profile choose your area from the search results below one area matches your sea rch as in this example aries
27. bulation and Analysis in the case of surveys click on the tab to make active Description Displays the metadata the data about the data for the dataset or survey Tabulation Displays the actual data table survey or map Analysis Is an advanced statistical function only available for surveys see Nesstar help Se ee TABULATION ANALYSIS An active tab has a dark blue background and white font An inactive tab has a grey background and black font The Tabulation and Analysis sections are only available when a dataset is open and are not displayed in the sections for Publications and User guides Generally if any option is unavailable at any time the associated icon button will be greyed out The top frame The top frame allows the user to navigate through the Home About ESiF Getting started Links contact us and Help pages in ESIF Welcome page of ESIF This button also allows you to reset ESIF any time Peewee Background detail on the concept of ESIF PESSE Guidance on the applications you need to run ESiF plus links Links to other data sources and key partners Sy 5 Contact details if you have any questions in ESiF and a feedback form Link to the Nesstar help facility Back to contents Page 5 of 32 ESiF User Guide Released Version 2 0 September 2008 Opening data in tables When to use tables Tables are the simplest way of displaying and ordering data they provide concise and structured d
28. d analysis functions listed above for survey results are not available for multiple response tables Viewing publications published maps and user guides ESiF can also provide users with immediate access to useful publications that are closely related to the main content and purpose of the site The main types of publications available in ESIF Listed below are the most common types of publications available on ESIF However this list is not exhaustive and we recommend that you browse though the publications in ESiF or use the search facility to find the most useful sources of information You can access published resources Back to contents Page 23 of 32 ESiF User Guide Released Version 2 0 September 2008 via the links on the main pages of ESiF the Surveys Published maps and Use guide themes as well as of course under Publications In briefs These publications are commentaries on specific datasets e g JSA claimant counts or Average earnings The In briefs are published under three headings Economy and employment Population and housing and Transport and environment and are published regularly You will find In briefs useful when you require additional contextual information on specific datasets or topic areas Performance monitoring reports Some statistics are not easily published in table or survey form e g the Local Area Agreement LAA reports In this case the information is published on ESiF in PDF format In touch
29. e scale of a graph you can enter your preferred minimum and maximum values in the boxes below the chart and click Change Use the Reset button to revert to automatic scaling The drop down variable boxes used to customise table views of data are retained when you switch to a chart view This means that you can customise the data that the chart is displaying in exactly the same way as you do for tables Any changes that you make to the chart will be retained and reflected in the associated table which can easily returned to by just clicking on the table icon Looking at data in maps Producing a thematic map of a dataset for East Sussex is done by clicking on the Ml map button Note SVG must be installed on your pc in order to view maps See system requirements When to use maps As maps are visual they can make complicated datasets a lot easier to interpret It allows you to identify concentrations and where they are in relation to the county of East Sussex Note Unlike charts it is only possible to produce a themed map for a single category of each variable such as the overall unemployment rate The initial map view opened presents a dashboard made up of a number of inter related elements as illustrated below The map dashboard Dataset JSA claimant count 2006 2008 wards Geography Districts Month Jun 08 x Gender All claimants M Measure Number of claimants M ES l F dro pdown menus Districts gt gt All dai
30. er of classes Geographic features in the same class are given the same shade The administrator may have configured the report so that the class breaks are the same across all indicators in the report Standard Deviation Legend Class breaks reflect the number of standard deviations from the data average or mean Geographic features are classified according to how many standard deviations above or below the average their indicator value falls Geographic features in the same class are given the same shade You cannot change the number of classes for this legend type Number of Classes You can increase or decrease the number of classes by clicking the Increase or Decrease options in the legend menu Change Shading You can change the shades used to shade geographic features in the map by clicking on a new palette Highlighting and Selecting Hold your mouse pointer over a class in the legend to highlight the geographic features that fall into that class Click a class to select the geographic features that fall within that class Takes you to the help page for atlas The Company that provides the Hel E mapping software for ESIF Q Zoom in Click on this icon to fixed zoom into the map Q Zoom out Click on this icon to fixed zoom out of the map Q Reset Zoom to original map extent reset map Resize Open the map in a larger window press again to toggle back L Move map North east north west south east south west etc
31. es you to move different elements of the table around The dropdown list for any variable currently shown in the rows of a table will give you the option to move this data to its columns and vice versa This option enables you to focus in on one particular aspect of the dataset as it already appears on your screen For example if you are looking at data for all the wards in the county this option works as a filter to display the information for just one single ward if required Once you have selected this filter option all the other single categories or wards in this example subsequently become available for selection through the same drop down list Back to contents Page 9 of 32 ESiIF User Guide Released Version 2 0 September 2008 geography or layer name and you can drill down through the hierarchy of the dataset see below Geography East Sussex r Year group Mixed r Measure Number _ Fitter b Eastbourne Devonshire Hastings Hampden Park Lewes Langney Move to row Rother Meads Custom Selection Move to column Wealden Old Town Ratton St Anthony s Sovereign Upperton Insert Calculation FT FF FSF F F F F F 6 Insert calculation This option can be used to do things like e adding data for different areas together to create new information for the combined area and e calculating absolute and percentage change figures for time series data To add the data from the five districts
32. fied 399 Neither 128 290 Fairly dissatisfied 51 93 Wery dissatisfied 14 24 N 453 883 Miale Female Total Row and column percentage Type Row and column percentage gt In this case the percentages for each cell are displayed as a percentage of all of the people who responded to this question ESTES in this case 883 respondees Therefore 4 9 in the Very H satisfied Male box illustrates that 4 9 percent of all of the Neither 5 183 a2 respondees to this question were Male and Very satisfied VETA ERAR 43 833 x 100 Total Male Female Total N N Weighting surveys Survey datasets may include one or more weighting variables These typically correct for unequal selection probabilities or to match the profile of the survey population to population estimates To apply a weighting variable Select the Weight option and any predefined weighting variables will be displayed Click on the weighting variable you want to apply Click on the arrow between the boxes to move it to the box on the right If you click on an icon or tab above the weighting page the weighting will be automatically applied 5 Alternatively click on OK kad pal Note It is also possible to use a variable that is not pre defined as a weight in the dataset In this case at point 2 above select a variable from the browse list and choose to Add as weight The variable will then appear in the box on the right as in point 3 above
33. from the geography or other variable and measure dropdown boxes above the map dashboard Once the new geography or data has been selected from the dropdowns shown below the map will automatically re generate to reflect the changes Dataset JSA claimant count 2006 7006 wards Geography Districts Month Jun 05 Gender All claimants Measure Claimant rate The map dashboard buttons and icons Listed below are the buttons and controls available on the dashboard Clear Clear Button Click this button to clear any geographic features that have been selected Legend Legend Button Click this button to display the available legend options below Legend Help COT Standard Deviation PELTIER E re e A EE ESTESE Legend Options The items available in the legend menu may vary depending on the data in the report and the way the report has been configured Continuous Legend Each geographic feature is shaded a different shade using a continuous scale Back to contents Page 14 of 32 ESiF User Guide Released Version 2 0 September 2008 Quantile Legend Each class in the legend contains an approximately equal number of geographic features Class breaks are calculated and will update if you change the number of classes Geographic features in the same class are given the same shade Equal Interval Legend The intervals between class breaks are equal Class breaks are calculated and will update if you change the numb
34. his method fs Legend Help Bocca ye Seveno wa gt i t Districts i vd e Equal interval legend A ies onbridoes i Cote b adgas 640 874 a 4 x A 875 1 1 do r ia e rer ioe IT L KERT 1 108 1 34 Grine 1 342 1 574 CLG 1575 128 i Be Brightdt AR 5 1 808 zJ Map layers ae Ward boundaries M Parish boundaries Electoral division boundaries Super output area boundaries H K Eastbourne Background mapping Beachy Head KE Crown copyright All nights reserved 1000719507 and 1000G2160 2008 JA a Back to contents Page 27 of 32 ESiF User Guide Released Version 2 0 September 2008 Exporting to PDF You can save any table or chart as a PDF file by selecting the E button from the main toolbar The resulting PDF can be easily stored electronically or e mailed You can save the PDF in the desired personal folder Another use for converting tables and charts into PDF is that you can then copy certain elements of the PDF and import them into reports or documents Select the snapshot tool from the PDF reader a camera icon draw a box around the required part of the PDF and paste the resulting image into the desired application An example of this is given below Using metadata when extracting data from ESiF It is advisable to check the metadata of any dataset you wish to obtain information from This can be done by clicking the Description tab
35. iceneurseianenacssenssaeuesns a 7 PE COGOW DOKO paos rasanadenaeedailanaatesauaaedeanidaaieaaaiaoestnceaeiteciedinaavunsatedirubelanieeteaaeius 8 The Measure dropdown DOK cacheceicatencan cite scsacarcioepercnse acaacecacenscatsnacteicesssaeanens ences aeicenneeeieas 8 Working with the dropdown DOXES ccccceceeeeeeeeeeeeeeeeeeeeeeeeseeeeeaeeeeaeeaeeaesesaesaesesaeeaeseeaesenangenas 8 The structure and content of the dropdown DOXES csccecseeseeeeeseeeeeeeeeeeeeeaeeeeeeeseeeeesaeeeesensaetaes 9 Other ways of CUSTOMISING tables iisiiicitscncsnceccteccpnnnsdcccdsnsteninencusesscurnenedenvecndnannnoncnandsnnaen 11 GSTS TEKU en E E 11 SORTON S a CON aa E E gua eeaeeivees 11 LOOKING at data In charts sgiminea E 12 Selecting the Chart OptionS ssssssssssssssnssrnnrnrnnnnrnrnnnrnrnrnrnrnnnrnrnrnnnrnrnnnrnrnnnrnnnnnnnnnnnnnnnnnnn nenne 12 SEEE TT A E EA PE A NE asf EE A 12 WINGS TLCS CIV acted rts tte sre ness eee assent N ute dete I A T E T E 12 L okmg at data iN MAPS incasasteredacancnsderandiasuniieavdestiaderendersecuincederaeusnewiadaserecreetauncntianpaans 13 When to Use MaDS cas sceaisge snare atesanssunciaedecnantnsssavaaaeis iniaa anaE ninna 13 the map Gal DOG essiri EE EEE A REEE EiS 13 Changing variables on the map dashboard using the dropdown DOXES cccecseceeeeseeeesseeeeetaees 14 The map dashboard buttons and ICONS cccscceccecseeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeeeeaeeeesseeeeseeseeteeseesaees 14 other Mapping Teat
36. imary schools Secondary schools Sixth forms Devonshire 1 244 Eastbourne 010A 137 Eastbourne 0108 132 Eastbourne 010C 112 Eastbourne 005A 257 Eastbourne OOF A 243 Eastbourne OO7B 206 Eastbourne 010D 157 Sorting rows and columns ESIF can also sort data in any table in ascending or descending order by value To access this feature e click once on the column heading that you want to use to sort the data In the example below All pupils has been selected e the option appears in the column heading and the whole column is highlighted e clicking on the symbol gives you the option to sort ascending sort descending or apply no sort e The selected column will then be sorted according to the selection made All associated data in this case Nursery schools Primary schools etc will remain with the relevant geography Dataset School pupils by year group in 2006 7 super output areas Geography Wards Year groun Wied gt Measure Number_ ear group All alll ails Murer schools Priman schools Secondan schools Sixth forms Geography Sort Ascending Devonshire 4 Sort Descending 710 494 Hampden Fak q Mo sort 787 Langney 2 134 56 g6 Back to contents Page 11 of 32 ESiF User Guide Released Version 2 0 September 2008 Looking at data in charts You can present the data that you have selected as a chart by clicking on one of the two chart icons in the row of icon buttons towards the top right of the
37. king to make the area safer gt My Council is working to make the area cleaner and greener gt My Council is efficient and well run gt My Council provides good value for money gt My Council is trustworthy My Council is remote and impersona gt My Council promotes the interests of local residents gt My Council acts on the concerns of local residents gt My Council treats all types of people fairly Improvements in how the authority runs things aNd th af life im tha lanal sran Click on the 4 box next to Variable Description to open the list of themes for all the survey questions asked Click on the box next to one of the themes to open a list of all the related survey questions Click on the arrow symbol to open a frequency table and histogram a kind of bar chart for a specific question Back to contents Page 18 of 32 ESiIF User Guide Released Version 2 0 September 2008 The survey screen ro Tabs Dataset East Susse xGeneral Ilse i i Name of survey Variable 16 Satisfaction with East Sussex County Council The number and title of Literal Question the question on the survey Taking everything into account h Sw satistied or dissatisfied are you with the way the authority runs things Values Categorie NH HW Very satisfied zidi 36 Fairly satisfied GOEL 594 6 48 3 The actual question that Neither 407 426 4 34 6 was asked Fairly dissatisfied 122 131 0 10 6 i i 34 35 1 2
38. mants gt gt Number of claimants gt gt Jun 08 Map title a faoa 3 Eastboume 7 3786 4 Q QQ a str _ e084 val interval lege Legend kT M Map of the data Data table showing values Background boundary table Histogram or bar chart showing the distribution of values Time series chart only Rohe i available for time series data instantatlas The map elements are inter related in such a way that if you select any area in either the data table or the map or the bar chart it will automatically be highlighted in all the other elements of the dashboard Similarly if you place your mouse pointer so that it hovers over one interval in the map s legend all of the areas falling within that range of values or class will be highlighted Back to contents Page 13 of 32 ESiF User Guide Released Version 2 0 September 2008 In the map window the boundary of a particular area is highlighted initially in yellow as you move the cursor over it You can select different areas by clicking on them or their associated values in the bar chart which turns the fill of the geography orange Selected areas remain orange until deselected To deselect any area you just click on it again to deselect all areas click on the cer O Hutton just above the data table Changing variables on the map dashboard using the dropdown boxes Just as with tables and charts you can change the data being mapped by choosing different options
39. n on printing in this guide but it s worth noting that there are 2 options for printing area profiles The icon will create a printout of the selected Area profile This is very useful for creating a hard copy that can be filed or circulated Whereas the PDF version option creates a copy that can be easily stored electronically or e mailed To do this save the PDF in the desired personal folder Area profiles can not be bookmarked The Bookmark function is explained later in this guide Other useful functions Printing To print a table or chart you use the print button in ESiF s main toolbar This will open the print dialogue box for your own printer If the output is too big to print onto a single page you should use the print dialogue options to change the orientation of the page and scale as necessary The printout will include the name of the dataset the row variable the column variable and the filter variable Printing SVG maps Maps created using the 4 icon can not be printed using the icon However there is a simple way that you can print out maps or include them in documents and publications When you have the view of the map that you require press the Print screen key on your keyboard This function captures the current view on your PC You can them paste the image into the relevant application MS Word or PowerPoint etc and crop and re size the image accordingly The image below was created using t
40. ne spreadsheet The dimensions would be the same providing the table has not been sorted or customised Back to contents Page 28 of 32 ESiF User Guide Released Version 2 0 September 2008 School pupils by year group in 2006 7 super output areas School pupils by gender in 2006 7 super output areas Year group Tall pupla Nureery scheols Primary schoole Secondary schooleSikth forms Gender TAllpupiis_Males _ Femmales 11802 _ __ __191 _8835 _o036 _40 Eastboune_ 11802 Hastings re anal nat sa aia sings j are eral ae Rother e as sao asf re patie ara sas ar Wealden J 17971 S 9887B TG 1129fWealden 17971 9202 8769 Creating bookmarks If you have spent time customising a table chart or map etc so that it displays the data in the desired way you can save that view by creating a bookmark to ensure it will automatically open like that for you in future To create a bookmark click on the bookmark DESCRIPTION E7 mi2 Dataset Electoral register 2001 2007 districts button In the main toolbar ane Select Browser bookmark Ke Internet Explorer will add this page to your Favorites list oe this will Save it to the Make available offline Customize Cancel Favo u rites fo d er n you r 6 205 985 browser 9 Name Bookmark Create in lt lt ES l Create in EES ea 73 530 Give your bookmark d 6 5 6 eel name and consider lt hen creating a special folder in are Favo
41. ovel 9 6 percent of all of the males surveyed marked very satisfied to Very satistied 9 5 7 3 3 7 Fairly satisfied aa 3 2 the relevant question on the survey You will see that the three Neither 28 3 37 7 328 oe us ss ws total percentages columns all add up to 100 Very dissatistied 3 1 2 3 if Total 100 0 100 0 100 0 N 463 430 883 Back to contents Page 21 of 32 ESiF User Guide Released Version 2 0 September 2008 Row percentage Type Row percentage gt In this case the percentages are being calculated horizontally Therefore the 55 8 in the Very satisfied Male box illustrates that Gender Male Female Total H Sere 55 8 percent of all of the people who marked very satisfied to eee pgs ree eaan Daraa ere adista CLOT wit Eastbourne Borough Council Very satisfied se 442 100 77 the relevant question on the survey were males You will see Fairly satistied S44 466 100 0 209 ane vai sea too that the total percentages columns for the five question options Faiy dissatisfied sas a2 400 9 and total are all 100 The last column N shows the number of pea 3 air 1 1 people who gave the relevant responses Total 51 3 48 7 100 0 883 Raw numbers Type Raw numbers This option displays the actual number of respondees i e the people who answered the question by category in this case P CREE aaa gender Therefore in this case 43 males answered Very ooa 7 satisfied to this question Fairly satis
42. ptember 2008 To analyse survey results in more detail having already opened the survey as outlined above you first click on the Tabulation button at the top of the main viewing frame You then have the option to add results from any of the survey questions to either the rows or the columns of the table that you are going to create e To add any variable to the rows of a table click on the relevant question and choose Add to row from the drop down list of four options which is opened Search O2 amp l DESCRIPTION PURINE AT analysis Tables charts amp maps Dataset East Sussex Gaueral User Survey 2006 7 Surveys East Sussex Business Survey 2007 BYPI General User Surveys 2006 7 E East Sussex TEONE East Sussex General User Survey 2006 7 Variable Description H Survey sample characteristics How well the council performs E Caticfactian with Fact SuUSsex County Add to row j Add te column Use as filter the local area a Add as measure to make the area Click the tabulation safer H My Council is working to make the area button cleaner and greener My Council is efficient and well run H My Council provides good value for money b Soci worth e To add any variable to the columns of a table you repeat this process with another question and then choose Add to column DESCRIPTION BRIE Ten me ANALYSIS Tables charts maps E Surveys East Sussex Business Survey 2007 BVPI General User Surveys 2006 7
43. publications in ESIF Search Leaner amp maps Title LAA Performance Monitoring Report Quarter 4 Year 2 part 1 User Guides E Publications Pride of Place ESIF Newsletter Focus on East Sussex Description In brief notes P E Local 4rea Agreement LAA performance l monitoring The Local Area Agreement LAA for East Sussex is delivered and monitored by the East Sussex Strategic LAA Performance Monitoring Report Quarter Partnership It is an action plan for implementing the East Sussex Community Strategy Pride of Place The 4 Year 2 part 1 NEW Partnership receives quarterly Performance Monitoring Reports on progress against all the LAA indicators and lt 4 LAA Performance Monitoring Report Quarter targets which are set out under four main themes _4 Year 2 part 2 NEW LAA Performance Monitoring Report Quarter Children and Young People 3 Year 2 part 1 Exception Report Healthier Communities and Older People l LAA Performance Monitoring Report Quarter Economic Development and Enterprise and 49 Year 2 part 2 wae Safer and Stronger Communities LAA Performance Monitoring Report Quarter 2 Year 2 part 1 Exception Report hoe os E LAA Performance Monitoring Report Quarter The attached report covers Quarter 3 year 2 Performance Monitoring of Outcomes Indicators within Outcome Click on the box next to Publications note that published material is available in
44. purpose of this user guide This User Guide provides a straightforward introduction to what you can do with East Sussex in Figures ESiF By following the simple instructions and examples given you will quickly learn how to e open tables of data on different topics e customise tables to meet your own requirements e view data in charts and maps e look at survey results and produce your own cross tabulations e open related publications including commentaries data notes and contextual maps e Produce area profiles on specific geographical areas within the county to ward parish and district level and e save print and export your work This guide will not only show you how to obtain information from ESiF but also provide some advice on the best way to display and interpret the information What is ESiF The East Sussex in Figures data observatory is a comprehensive web based information system It has been developed by the County Council s Research and Information Team with the support of all the Local Strategic Partnerships LSPs in the county and districts of East Sussex ESIF aims to improve access for everyone to detailed information about the county and all its communities It provides reliable and up to date information on many different topics such as economy housing and education in the county of East Sussex How does ESIiF work With the exception of some static pages all of the data you obtain from ESIF is created
45. resource 1 Enter the search term or terms in the box above the browse list 2 Press Return or click Se If you enter the words farm land the search will look for any occurrence of the word farm and the word land If you type in the words Farming of land no hits will be returned as the stop word of has been included in the search If any stop words are used no hits will be returned and a message will be displayed asking for the stop words to be removed Please remove the listed words and try again Examples of Stop words are and the in of Search Results The results of a search are listed at the end of the browse list under the heading Searching for followed by the search term and the number of hits The results are displayed under their relevant catalogue headings Browsing search results e Click H to view a table cube e Click to open a survey dataset e Click to view the metadata for other types of resources e g Publications Click Open this publication to open the actual resource Copyright The Legal information page on ESiF contains very detailed information on how data from ESiF can be used and published The link for this page can be seen in dark grey at the bottom of the ESIF site The link is http www eastsussexinfigures org uk webview static legal pdf Back to contents Page 30 of 32 ESiF User Guide Released Version 2 0 September 2008 The m
46. s linked to the legend Hold your mouse pointer over a bar to display a text box with the geographic feature name and value illustrated below Rother 713 Select a Geographic Feature Click a bar to select the corresponding geographic feature A selected bar will be shaded orange Rother 713 Time series chart Trends The time series chart below shows change in indicator values over time Hold your mouse over a geographic feature in the map data table or bar chart to view a trend in the time series chart Click a feature in the map data table or bar chart to select it and freeze the trend in the time series chart Hold your mouse pointer over the line or points for any frozen trend in the time series chart to display a text box with geographic feature name and value illustrated below Hastings Aug 07 1692 Comparison Trends The time series chart may display trends for comparison geographies Hold your mouse pointer over the line or points for any comparison geography in the time series chart to display a text box with the name and value for the comparison geography Back to contents Page 17 of 32 ESiF User Guide Released Version 2 0 September 2008 Sings dad Hastings Aug 07 1692 Hea pT 1 288 gza pF 2 _ oe ae i h EN 434 4 ht aa anos AR a ato Os oe age Sn ants 560 Other mapping features You can also open the map in a new window so that the dashboard fills
47. sAn East Sussex in Figures ESIF User Guide Version 2 0 September 2008 Table of contents PORN TON oaa stated acennn teens 3 The purpose OF this user guide ives ccccacavsecnnsieexcanunvesscamsacaesieanssiaasonsiacnssnesciaesnenneysansseetereeacernens 3 AA ESI ara E E par eeeueennerne ie aeeine cases aneeneinedamsasunes 3 How does ESIF work sassnicanstacvansnaaneaesenouwsnldeinadnuiesantsatacensesninnecteneeeleanenieinstasaiehiuadeuioieanedentaaat 3 CSS CG O E E esege expec sence ees cadence estestecneascensenmecssessstcceenws S E E EES 4 System reguiremMeNtS sesura S EA EEE E AEG 4 Screen FAV ONE soris a EE A AA 4 WS ORE Bi NS crete scene E E E 4 THE right faM ss crnsrstecccteccasscuamutesanncubaieeneammntueennoieaaesuetarsauganieananeunaieencanmtaecenusitiaeonennseiaanaaniias 5 TINE TOD Fi NING ainera EE EAEE 5 Opening data IN CARI CS ssrin 6 VV PIG GO ISS TADES rE E E E a 6 How Tables charts and maps are organised cceceeceeeeeseeseeeeeeeaeeeeaeeaeeseseeaeeaeseeaeegeneeeeeaesanags 6 Tabe CSS eE EE E EE EE EEE EA EE EE EEE 6 Opening a dataset table siinivnisdeinceseiritiasveerssliiniiriesii i 7 Viewing MECCA Ae cawinssnewenessecsanietadancadian danavetnenieisataanwasssanacindvanasavdeeniusasdesturaeneasetsdeindeaaiiebeanten 7 The default View for a table cccccsccsccsseceusecusceceecessecuseeuusecuueesauesueeusuearsecuueesausesseeusuueenseanees 7 CUSTOR ISIC ODIO ccc acagpsicantanseimnerausnehannewesnotasaacsconcqs
48. tricts Latest published indicators View full details of all our indicators Published maps view and download boundary and thematic maps of East Sussex The left frame The grey left frame contains a search facility and presents the four main sections in ESiF for working with Tables charts and maps Surveys User guides Publications Area profiles Back to contents Page 4 of 32 ESiF User Guide Released Version 2 0 September 2008 e Published maps The frame presents a navigation tree that works in a similar way to Windows Explorer you select options by clicking on expanding the tree to reveal the information or data you might want to open Clicking the symbol will take you into the next level or theme and clicking the title Tables charts and maps etc will return background information on the theme selected The right frame The right frame is the main viewing pane for looking at and analysing data and for customising exactly what data you choose to view At the top and to the right of this frame are a number of context specific icon buttons for performing certain key functions like switching between table chart and map views and for exporting or printing data etc A description of each icon pops up when you hover of it Also at the top of this main viewing frame in the left corner you will see either two or three tabs either Description and Tabulation with Tables charts and maps or Description Ta
49. urites for all your ESiF Ne Fol bookmarks timates Click OK icts To open any saved bookmark you select it from your Favourites folder you can also use bookmarks as a way of opening ESIF When you re open the bookmark you will see the ESIF has created a unique address URL in the address box of your browser Z ESiF Microsoft Internet Explorer File Edit view Favorites Tools Help Bak gt A GQsearch GyFavorites media CH G 3 SI a Address http www eastsussexinfigures org uk webview index jsp study http 34 2F 2FesfiguresO1s escc gov uk 3480 2Fobj 2FFStudy 2F4 1 8 amp mode cubemy 2 amp cube http 34 2F 2FesfiquresOls escc goyv uky Y You can copy this URL and use it as a link in other applications However the URL may be extremely long To compress this URL go to Tiny URL http tinyurl com paste in the long URL when prompted and Tiny URL will create a more compact link for you so http www eastsussexinfigures org uk webview index jsp study http 3A 2F 2FesfiquresO1s e SCC gOV UK 3A80 2Fobj 2FfStudy 2F418 amp mode cube amp v 2 amp cube http 3A 2F 2Fesfigures O1s escc gov uk 3A80 2Fobj 2FfCube 2F418 C1l amp top yes Becomes http tinyurl com 5t6rf Tiny URL is a free service Back to contents Page 29 of 32 ESiF User Guide Released Version 2 0 September 2008 Searching The search option can be used to find a search term or terms in the metadata of a published Nesstar
50. works As you can see the calculation field returns the same value as the East Sussex row The following types of calculation are available Add Aggregate Subtract Multiply Divide Percent Percent of total Average Percent growth Where cells contain average values the aggregate function aggregates the values of two or more cells to create an aggregated average The formula used to calculate the new aggregated value takes into account the characteristics of the Back to contents Page 10 of 32 ESiF User Guide Released Version 2 0 September 2008 selected measure e g the sum and count values of the average cell However Aggregate can be used for aggregating sum count values To remove all calculations from a tabular cube dataset and return to the default view of the table select 3 Note selecting this icon when using survey data will clear all information and return an empty table Other ways of customising tables Underlined text If any variable has been published in a hierarchy and can be broken down into more detailed variables the variable is shown as blue underlined text In the example below the underlined Devonshire ward has been selected returning the SOAs that make up Devonshire along with the data associated with these SOAs Dataset School pupils by year group in 2006 7 super output areas Year group Mixed v Measure Number M Year group All pupils Nursery schools Pr
51. x in Figures Search Go Bow A E Tables charts amp maps H Surveys E User Guides H Publications we CO l e In fact RES E Area profiles Published Published maps The East Sussex population is projected to grow by 20 to reach 606 800 people in 2031 Welcome to the East Sussex in Figures ESiF data observatory a free and very flexible information system about the county and all its local communities ESiF provides open access for everyone to a wealth of key statistics and other information on a wide range of issues Topics covered include population economy and employment education health and social care housing community safety deprivation and the environment ESiF provides you with a range of easy to use interactive tools for analysing and presenting data and information You will be able to manipulate tables create thematic maps and generate graphs You can also explore survey data and download related publications To find out more about ESIF including helpful hints about getting started please explore the links at the top of this page ESIF is provided and managed by East Sussex County Council If you have any comments or questions about the site please contact us in brief Read our most recent briefing notes Indices of Deprivation 2007 Births and Deaths Household incomes More in briefs inside Area profiles are now available for all wards parishes and dis
Download Pdf Manuals
Related Search