National Records of Scotland

Preserving the past, Recording the present, Informing the future

Quick Guide to Using SuperTABLE

Quick Guide to Using SuperTABLE

SuperTABLE

1.To analyse the 1999 small area population estimates, you will first need to download and install SuperTABLE from the Space-Time Research website. Downloading SuperTABLE takes approximately 20 minutes and installation a further 10 minutes.

Accessing the 1999 small area population estimates

2. The estimates have been created in a SuperCUBE which enables you to create tables from a set of fields. It also enables you to manipulate that data by grouping or selecting values within fields, or creating derivations within fields such as sub totals and percentages. An example of a table has already been completed and is available for downloading.

3. The SuperCUBE is available for downloading and takes approximately 12 minutes. Once downloaded, the SuperCUBE should be installed within the SuperTABLE catalogue. To do this, double click on your SuperTABLE icon, right click on catalogue and click on Install SuperCUBE. Browse to where you have saved your SuperCUBE and select 99 sape and click on OK. Click on Install and you will receive the message 'The specified database directory does not exist. Do you want it created?' Click on Yes. To install the sample table, right click on catalogue again and select Add Tables etc. Browse to where you have saved the sample Table, select the Council Areas Estimates file and click on OK. Once installed, to open the SuperCUBE or sample table from the catalogue, simply double click on the relevant filename.

4. On opening the SuperCUBE, a screen will appear showing a Fields box on the right hand side, which will contain the following fields;

  1. Summation Options

  2. Geography

  3. Sex

  4. 5yr age groups

(The technical names for each area of the table are listed in Chapter 5 - Creating Tables in the User Guide).

Adding fields to the table

5. To create a table and view the data you must add a field or fields to the table. Note that Geography must always be included in the table as a geographical area is required on which to calculate the estimated population. Within the Fields box, clicking on Geography and the Recode button allows you to choose which range or level of geography you want to see data for. The Geography field is split into Health Board by postcode sector, Council Area by postcode sector and Scotland by postcode sector.

6. Let's try Aberdeen City as an example. Click on the Geography field and then the Recode button. Double click on the Scotland Council Area PC Sector (2) Postcode value to view the Scotland hierarchy. Double click again on the arrow from where a list of the individual councils can be accessed. Select Aberdeen City and then click on the Singly button. Aberdeen City is added to the right hand side of the box. At the top of the box, delete Geography, type Aberdeen City and click on OK.

7. You will see that the Fields box has added Aberdeen City as a 'Recode' of the Geography Field. Basically you have made a sub set of the geography field to select data for Aberdeen City only. Fields are added to the table using the drag and drop method.

8. Hold down the Control button on your keyboard and select Aberdeen City. Drag it to the Row on the extreme left of the table, just under the horizontal line that splits the entire screen, and release the mouse button. If you attempt to drag and drop without holding down the control button, the 'Aberdeen City' label will be hidden. If you have done this, click on the Aberdeen City recode label in the field box and click on Remove. This will remove the recode from the table (not delete it) and you can start again. Removing any Geography field will trigger a box stating that Geography is a mandatory field (see 5. above). Click on Cancel to ignore.

9. Aberdeen City should now appear in the table with the population estimate appearing automatically to the right. You may wish to split this estimate by postcode sector within Aberdeen City. To do this, point the mouse at the Aberdeen City label, right click and select Drill then Down. This will automatically show the postcode sectors within Aberdeen City and their individual population estimate. To reveal the Aberdeen City label again, right click and select Spanner label. This will show 'Aberdeen City Drill Down'. This label can be edited by pointing the cursor at the label and double clicking on left mouse button. You can also drill back up if you wish to return to the Aberdeen City total by pointing the cursor at any postcode sector, clicking the right mouse button and selecting Drill then Up.

Age & Sex Fields

10. Both the age and sex fields should be dragged and dropped into the right hand column of the table above the horizontal line separating the screen. This is the best way to layout the table to view as much as possible on screen. You can recode these fields to select either sex individually or to select a different age group from those provided as default. For example, we can recode the age groups to select persons aged 0-49.

11. Click on the 5yr age groups field and click the Recode button. Highlight the range of ages 0-4 to 45-49. Click on the Singly button and these age groups will be added to the right side of the box. Name your recode '0-49' and click on OK.

12. To view both age and sex data in the same table, drag and drop the 0-49 recode to the table as described at 11. Above, this time not holding down the Control button on your keyboard. Now click on the Sex field and drag and drop it into the same area (not above or below) you added the 0-49 recode to. You will now have a separate total for Males aged 0-49 and Females aged 0-49.

13. Note that all the age groups within the 0-49 recode are displayed automatically. You may however want to view just the 0-49 total, especially if you are adding other age groups to your table. To do this, click on the 0-49 recode in the fields box and click the Recode button. Select the 0-49 age groups in the right hand side of the box and click on the Remove button. Now select the 0-49 age groups again but this time click on Group name and type 0-49. Now click on the Group button and the age groups will be added to the right side of the box. Click on OK. You will now get a single figure for the 0-49 recode. From here you also have the option of drilling down to reveal the lower level age groups.

Removing fields from the table

14. If you want to change your age recode from 0-49 to something else, click on the 0-49 recode name within the fields box and click on Recode. Remove from the right hand side of the box as at 12. above and choose your new variables. To delete recodes, first remove them from the table and then click on the recode name within the fields box and click on Delete. If you try to remove the geography field from the table a box will appear stating that geography is a mandatory field. If however you want to create a fresh table, just click on Cancel when this message appears to clear the existing table.

Axis and field derivations

15. Once you have added your fields to the table, you can also perform a series of calculations, called derivations in SuperTABLE, on the data. For example, you can create a derivation to add together a range of postcode sectors within Aberdeen City or you can create a derivation to calculate the population in this range of postcode sectors as a percentage of the total population for Aberdeen City.

16. In your table, make sure that Aberdeen City has been drilled down to include postcode sectors. To add together all the AB25 postcode sectors, right click on the last of these in the table and select Derivations then Add field derivation. A box will appear from which you can select your variables. First of all you should add a derivation label so type 'Total for AB25' in the Derivation label box. In the Values box, highlight the 3 AB25 postcode sectors and click on Add to Expression and then click on OK. The derivation should be inserted after the last postcode sector.

17. For more advanced calculations you can click on the Check button within the derivations box which will highlight any errors in your proposed calculation. More information on derivations etc is contained at Chapter 7 - Table Calculations of the SuperTable in the User Guide.

Exporting data to other formats

18. Once you have the data you require in your table, you can save it to another location and in a range of formats. To save your table, click on File the Save As. A standard Windows box will appear from where you can choose the location and the format of your file.

All statistical publications