TableBuilder: Childhood Education and Care, Australia

Provides data on child care arrangements, early childhood education, families' requirements for formal care, working arrangements of parents

Introduction

This product provides a range of information about the release of microdata from the Childhood Education and Care Survey (CEaCS), Australia, June 2017 including details about the survey methodology and how to use the TableBuilder. Data item list and information on the conditions of use and the quality of the microdata, as well as the definitions used, are also provided.

Microdata are the most detailed information available from a survey and are generally the responses to individual questions on the questionnaire or data derived from two or more questions and are released with the approval of the Australian Statistician.

The CEaCS is collected every three years and is designed to provide a range of information about children aged 0–12 years and their families. The information collected includes the child care arrangements used by parents to care for their children, use of formal and informal care, cost and duration of the care and the attendance of children at preschool programs and other early childhood learning activities.

Further information about this product, and other information to assist users in understanding and accessing microdata in general, is available from the Microdata Entry Page. Before applying for access, users should read and familiarise themselves with the information contained in the TableBuilder, User Guide.

Apply for access

To apply for access to TableBuilder, register and apply in the Registration Centre.

Further information on access steps can be found in How to Apply for Microdata.

Further information

Further information about the survey and the microdata can be found in the various pages associated with this product, including:

  • A detailed list of data items for the 2017 CEaCS TableBuilder, available in the Data downloads section.
  • The Quality Declaration and Abbreviations sections.

Support

For further support in the use of this product, please contact Microdata Access Strategies on 02 6252 7714 or via microdata.access@abs.gov.au.

Data available on request

Data collected in the survey but not included in TableBuilder may be available from the ABS, on request, as statistics in tabulated form.

Subject to confidentiality and sampling variability constraints, special tabulations can be produced incorporating data items, populations and geographic areas selected to meet individual requirements. These are available, on request, on a fee for service basis. Contact the National Information and Referral Service on 1300 135 070 or client.services@abs.gov.au for further information.

Privacy

The ABS Privacy Policy outlines how the ABS handles any personal information that you provide to us.

Survey methodology

General information about the 2017 Childhood Education and Care survey, including key findings, are available in the publication Childhood Education and Care, Australia, June 2017 (cat. no. 4402.0).

Detailed information about the survey including scope and coverage, survey design, data collection methodology, weighting, estimation and benchmarking, estimate reliability and a glossary can be accessed from the Explanatory Notes page of that publication. All published summary tables, in Excel spreadsheet format, can be accessed from the Data downloads.

File structure and content

This 'File Structure and Content' section provides important information that will assist in understanding the CEaCS TableBuilder.

It is recommended that the 'File Structure and Content' and 'Using TableBuilder' sections are read in full prior to using the CEaCS TableBuilder.

File structure

The 2017 CEaCS TableBuilder is structured across four levels. The levels are:

  1. Income Unit level
  2. Income Unit Care level
  3. Child level
  4. Child Care level

The Income Unit level represents households consisting of a single income unit, which in CEaCS is a proxy for the family. All data items at this level relate to the household, the family, or to the parents (father/mother) in the family. Each family is represented as one record on this level. The next level, Income Unit Care level, is linked to the Income Unit level by a one-to-many relationship, and is comprised of a record for each different summary type of care used by the children aged 0-12 years in the family. Therefore, a family may have multiple records on this level dependent on how many types of care are used by the child(ren). This level is organised by the summary care index item 'Type of care used by the family', which has been derived using items relating to types of care used by selected children (on the Child Care level) and aggregate items relating to types of care used by other children in the family. This level includes one or more records for each family - a single record will be present for a family where 'no care or preschool' was used.

The Child level is linked to the Income Unit level in a one-to-many relationship. The Child level provides a record for each child aged 0-12 years selected for the CEaCS survey (up to two children per family), for which detailed information related to their education and care has been collected. The lowest level, Child Care level, is linked to the Child level in a one-to-many relationship, and provides a record for each type of care used by each child on the Child level. Therefore, a child may have multiple records on this level dependent on how many types of care they use. The Child Care level is organised by the care index item 'All types of care', which includes separate formal and informal care types as well as summary care type categories (which are sub-totals or totals of the separate care categories). This level includes one or more records for each selected child - a single record will be present for each child where 'no care or preschool' was used.

For further detail on how the terms household, family and income unit are used in CEaCS, please see the Glossary. Further information about each level is provided below.

File content

Income Unit level

Information available on the Income unit level includes age, country of birth, labour force status, income and educational attainment of parent(s). It also includes household and family characteristics, and geographic identifiers, such as state/territory of usual residence. Families may comprise:

  • couple family with children aged 12 years or younger, or
  • one parent family with children aged 12 years or younger.

Each family is represented as one record, and the counting unit is 'families'.

Income Unit Care level

The Income unit care level includes the type(s) of care used by the family, the cost of care to the family, the number of children in the family who use care, and whether care was used 'in the last week' and/or 'in a usual week'. All families are represented on this level (a single record will be present for a family where 'no care or preschool' was reported) and the counting unit is 'care instances for families'.

Child level

The Child level contains the demographic characteristics of each selected child (up to two children per family), including age, sex, and country of birth. It also includes information regarding the child's formal education, informal learning and parental engagement, formal and informal care arrangements and unmet need for formal care or preschool. Each selected child is represented as one record and the counting unit is 'children'.

Child Care level

Information on the Child care level includes the type(s) of care used by the child(ren), number of days/hours care used and whether care was used 'in the last week' and/or 'in a usual week'. Also included is weekly cost of care after the CCB and/or CCR are deducted, and whether the CCB and/or CCR was claimed for the care. All selected children are represented on this level (a single record will be present for children where 'no care or preschool' was reported) and the counting unit is 'care instances for children'.

The following diagram shows a view of the four levels, as seen in TableBuilder, including the sub–categories under which the individual data items have been grouped. A complete data item list for TableBuilder can be accessed from the Data downloads.

TableBuilder structure, showing the four levels

Multi-response data items

A number of questions included in the survey allow respondents to provide more than one response. The data items resulting from these questions are referred to as 'multi–response data items' and are identified in the CEaCS TableBuilder data item list with <multiple response> appended to the data item name. Note that the sum of individual multi-response categories will be greater than the total population or number of people applicable to the data item as respondents are able to select more than one response.

For example, for the data item 'Parental involvement in informal learning activities with child last week (0-2 years)' shown below, the total applicable population is 936,500 while the sum of responses to individual categories is 3,576,100.

Example of multi-response data item

Special codes

Most data items included in the TableBuilder file include special codes for 'Not applicable', 'Could not be determined', 'Not stated', 'Inadequately described’ and/or 'Other' categories. These are shown in the data item list in the Downloads tab. For continuous items, TableBuilder does not include these codes when calculating sums, medians and means, and ranges. See the example provided under Continuous data items section (below).

The 'Not applicable' category generally represents the number of people who were not asked a particular question or the number of people excluded from the population for a data item when that data was derived (e.g. Year of Arrival in Australia is not applicable for people born in Australia).

The Income Unit level has data items which are specific to mother or father. For most of these data items the 'Not applicable' category represents no mother or father, respectively, in the income unit. However, there are a few mother/father data items where the 'Not applicable' category includes more than no mother or father in the income unit. For example, the 'Not applicable' category for the data item 'Weekly income of mother' refers to 'no source of income for the mother' or 'no mother in the income unit'. Similarly for 'Weekly income of father'. The 'Not applicable' category for the data item 'Weekly income of parent(s)' refers to 'no source of income for the parent(s)'. Note that the Family composition data item can be used to restrict a table to couple families or one parent families.

Continuous data items

The TableBuilder file contains a number of continuous data items which can have a response value at any point along a continuum. All continuous items are available under Summation Options (on the left hand panel in Data View of TableBuilder), where means, medians and ranges can be calculated.

Many continuous data items include special codes for certain responses (e.g. 999 = 'Not applicable'). Such continuous items have a corresponding categorical item that provides the ability to display data for the special code. Any special codes for continuous data items are displayed on the data item list.

When creating ranges in TableBuilder for such continuous items, special codes will automatically be excluded. Therefore the total will show only 'valid responses' rather than all responses (including special codes). Similarly, means and quantiles calculated for continuous items will only include 'valid responses'.

For example:

It can be seen on the data item list that the data item 'Age child first commenced long day care (in months) - continuous' includes the special codes '998. Could not be determined' and '999. Not applicable'. The data item can be selected from the Child level list of items (on the left hand panel in Data View) to create a table showing data for the special codes. The following shows the tabulation of the data item. The continuous values of the data item are contained in the 'A valid response was recorded' row. 'Could not be determined' includes children for which the age they commenced long day care is not known. 'Not applicable' includes children not currently attending long day care. To show the actual continuous values in a table, a range must be created.

Example of continuous item showing special codes

Here is the same table with a range applied to the continuous values (i.e. the 'valid responses') for the data item, available under Summation Options. Note that the numbers of children for the 'Could not be determined' and 'Not applicable' categories no longer contribute to the table.

Example of continuous item with ranges of valid responses only

Some continuous data items are available as categorical data items with values grouped into categories. For example, cost of care is available as ‘Cost of care in a usual week after the Child Care Benefit and Child Care Rebate - continuous’ and ‘Cost of care in a usual week after the Child Care Benefit and Child Care Rebate' with cost categorised into $25 ranges.

Populations

The population relevant to each data item is shown in the data item list and should be considered when extracting and analysing the microdata. The actual population count for each data item is equal to the total cumulative frequency minus the 'Not applicable' category.

Generally, all populations, including very specific populations, can be 'filtered' using other relevant data items. For example, if the population of interest is 'Children aged 4-12 years', any data item with that population (excluding the 'Not applicable' category) can be used as a filter - such as the data item 'Whether child attends school'.

While any applicable data item can be used for this filtering process, the CEaCS TableBuilder also includes some data items that have been specifically derived for this purpose. For example, the population data item 'Children aged 0-2 years' can be used rather than the 'Age of child 0-12 years in single years' data item. The specifically derived population data items are listed in the data item list and are included in the 'Populations' folder on the Child level of the TableBuilder product.

Using TableBuilder

For general information relating to the TableBuilder or instructions on how to use features of the TableBuilder product, please refer to the TableBuilder, User Guide (cat. no. 1406.0.55.005).

Detailed information about the 2017 Childhood Education and Care Survey (CEaCS) can be accessed from the Methodology page of the publication Childhood Education and Care, Australia, June 2017 (cat. no. 4402.0). In particular, the section titled 'Using the Data' on the Explanatory Notes page provides useful information on changes to the survey since the last iteration (in 2014).

More specific information relevant to the 2017 CEaCS TableBuilder, which should enable users to understand and interpret the data, is outlined below. Please read the 'File Structure and Content' section first, for information that will assist in understanding the Using TableBuilder content.

It is recommended that the 'File Structure and Content' and 'Using TableBuilder' sections are read in full prior to using the CEaCS TableBuilder.

Counting units and weights

Weighting is the process of adjusting results from a sample survey to infer results for the total population. To do this, a 'weight' is allocated to each sample unit. The weight is the value that indicates how many population units are represented by the sample unit.

It is critical that the correct weight is selected when specifying tables to ensure that the estimates produced reflect the counting unit of interest. Using the incorrect weight will produce incorrect estimates.

The CEaCS has two weights: one for income units, and one for children. The income unit weights are applied to the Income Unit level and the Income Unit Care level to estimate income units or 'families' and 'care instances for families', respectively. The child weights are applied to the Child level and the Child Care level to estimate 'children,' and 'care instances for children', respectively. The terms 'families', 'care instances for families', 'children' and 'care instances for children' are also referred to as counting units.

The weight can be selected from the Summation Options on the left hand panel in Data View of the TableBuilder. The names of the weights, or counting units, for each level are highlighted below.

Summation Options and weights by level

The default weight in this TableBuilder is the Income Unit level weight, providing estimates for the income unit or 'families'. This default weight will automatically be applied to a table unless an alternative is selected - so care needs to be taken that the correct weight has been selected for the estimates you require.

In general, the Child weight is used if child estimates are required and the Income Unit weight is used if estimates of income units/families are required. Child Care level weights should be used when producing tables with data items from the Child Care level. Income Unit Care level weights should be used when producing tables with data items from the Income Unit Care level. As a general rule of thumb, the weight corresponding to the lowest level data item in a constructed table should be used to ensure the correct weights are applied. For example, if a Child Care level data item is cross-tabulated with a Child level data item, the weight for the Child Care level should be selected.

Using repeating datasets

The Income Unit and Child levels provide 'count' estimates of income units (as a proxy for families) and children, respectively, whereas the Income Unit Care and Child Care levels are repeating datasets. The 'one-to-many' relationships, described in the File Structure section, between the Income Unit level and the Income Unit Care level, and the Child level and the Child Care level, indicate the connection between these levels, i.e. an 'instance of care' is repeated (by type of care) so that multiple records with the same set of data exist for the same family, or child.

For example, a child may have used more than one instance of child care such as (i) a long day care centre, (ii) family day care and (iii) grandparents. Consequently, three records would be present on the Child Care level for this child, representing a repeating dataset, with each record containing information for a common set of data items, e.g. Number of days of care used, Number of hours of care used, cost of the care and so on. Also, the child will have summary records in addition to the individual care type records, described in the following section.

In this example, although the three records all relate to a single child, totals from the Child Care level are a count of child care instances for that child. Similarly, the totals from the Income Unit Care level are a count of summary child care instances for families.

More commonly, CEaCS is used to count the number of children or families who use a particular type (or types) of care, for a particular time period (either in a usual week, or in the last week). The data items that are key to extracting data in this way are specific to each level, as follows:

Child Care level

  • All types of care
  • Flag to indicate whether care used in a usual week
  • Flag to indicate if care used last week

Income Unit Care level

  • Type of care used by the family
  • Flag to indicate if any child in family used care in a usual week
  • Flag to indicate if any child in family used care last week

The following sections detail how to use these items to count care used by 'children' from the Child Care level, and care used by 'families' from the Income Unit Care level, for either 'in a usual week' or 'in the last week'.

Child care level and 'all types of care'

The 'All types of care' index item provides the structure for the Child Care level - i.e. the Child Care level provides a record for each type of care used by each selected child, using the classifications (or categories) provided by this item. 'All types of care' includes separate formal and informal care types as well as summary care type categories (which are sub-totals or totals of the individual type of care categories). Understanding how this data item works is critical as it can result in miscounts if used incorrectly.

Below are the output categories for the 'All types of care' item:

00 No care or preschool
01 Before and/or after school care
02 Long day care centre
03 Family day care
04 Occasional care centre
06 Grandparent
07 Brother/sister
08 Non-resident parent
09 Other relative
10 Other person
21 All care and preschool
22 All formal care
23 All informal care
24 Preschool
25 All care excluding preschool
31 Used formal, used informal, used preschool
32 Used formal, used informal, no preschool
33 Used formal, no informal, used preschool
34 Used formal, no informal, no preschool
35 No formal, used informal, used preschool
36 No formal, used informal, no preschool
37 No formal, no informal, used preschool
41 Used formal care only (disregarding preschool)
42 Used informal care only (disregarding preschool)
43 Used both formal and informal care (disregarding preschool)
52 Family day care and Occasional care
61 Brother/sister and Other relative
62 Brother/sister, non resident parent and other relative
63 Brother/sister, non resident parent, other relative and other person

Categories 00 to 10 and 24 provide counts of individual types of care (01 to 04 are formal care types, and 06 to 10 are informal care types). A child can have a response to one or more of these types of care and therefore these categories can be interpreted as a multi-response item within this data item. Note that individual types of care cannot be summed to provide a total number of children using care, as double counting of children who use more than one type of care will occur. Summary categories must be used to calculate totals (as described below).

Categories 21, 22, 23 and 25 are summary categories and provide totals for formal care, informal care and all care. These summary categories should be used to calculate totals, as they count a child only once across the summarised care types. If you sum formal care types or informal care types, the total will not represent the sum value for each child, but the number of instances of each type of care, resulting in double counting of children. This is particularly important when cross-tabulating 'All types of care' with another variable which may differ between different types of care for the same child (e.g. cost of care or days attended).

For example, consider creating a table cross-tabulating the type of care by cost of care in $25 ranges. If a child attended family day care at a cost of $50 and occasional care at a cost of $25, that child would appear once in the 'All formal care' row with a value of $75. This is the result that will be produced by using the category 21 to get a total of 'All formal care'. If categories 01, 02, 03 and 04 were summed together to create a 'total formal care' category, this child would appear twice in the 'total formal care' row, once with a value of $25 and once at $50, resulting in a double count of that child in the total. They would not appear with their true value of $75 for cost of care.

Categories 31 to 37 and 52, 61, 62 and 63, are additional summary categories that should also be used when calculating totals. For example, to determine how many children attend both some type of formal care (e.g. family day care) and informal care (e.g. grandparent care), but don't attend preschool, use category '32 - Used formal, used informal, no preschool'.This is because if you sum the individual care types (categories 03 and 06) to generate a total, then a child will appear twice in this total, resulting in double counting. Using category number 32 only counts the child once.

Three other summary categories have been provided - categories 41, 42 and 43. These are; '41 - Used formal care only (disregarding preschool)', '42 - Used informal care only (disregarding preschool)' and '43 - Used both formal and informal care (disregarding preschool)'. These differ from 34, 36 and 32, respectively. Category 41 combines 33 and 34 but ignores any preschool cost and hours attended. Similarly, category 42 combines 35 and 36, and category 43 combines 31 and 32. Categories 41, 42 and 43 should be used where preschool attendance is not of importance and is to be removed from the denominator of tables. Note that categories 41 and 42 should not be used in combination with the 'last week' flag items 'Flag to indicate if care used last week' (on Child Care level) or 'Flag to indicate if any child in family used care last week' (on Income Unit Care level). Categories 41 and 42 can be used in combination with the 'usual week' flag items 'Flag to indicate whether care used in a usual week' (on Child Care level) or 'Flag to indicate if any child in family use care in a usual week' (on Income Unit Care level).

Income unit care level and 'type of care used by family'

Similar to 'All types of care' found on the Child Care level, the 'Type of care used by the family' index item provides the structure for the Income Unit Care level - i.e. the Income Unit Care level provides a record for each type of care used by the income unit, or family, using the classifications (or categories) provided by this item. 'Type of care used by the family' provides summary care type categories only, as it combines information for all children aged 0-12 years in the family. It is also complex and can result in miscounts if used incorrectly.

Below are the output categories for the 'Type of care used by the family' item:

00 No care or preschool
21 All care and preschool
22 All formal care
23 All informal care
24 Preschool
25 All care excluding preschool
31 Used formal, used informal, used preschool
32 Used formal, used informal, no preschool
33 Used formal, no informal, used preschool
34 Used formal, no informal, no preschool
35 No formal, used informal, used preschool
36 No formal, used informal, no preschool
37 No formal, no informal, used preschool
41 Used formal care only (disregarding preschool)
42 Used informal care only (disregarding preschool)
43 Used both formal and informal care (disregarding preschool)
52 Family day care and Occasional care
61 Brother/sister and Other relative
62 Brother/sister, non resident parent and other relative
63 Brother/sister, non resident parent, other relative and other person

The categories of 'Type of care used by the family' are the same as the equivalent categories of the 'All types of care' item on the Child Care level except that they represent types of care used by the family, rather than by the child. The descriptions for these categories can be found in the section above for 'All types of care'.

A variety of summary care types has been provided by this item in order to provide a wide range of possible combinations of interest to data users. Note that a family may have records in one or more categories, depending on how many types of care have been used by a child, or children, in the family.

Using flag items

Both the Child Care level and Income Unit Care level require the use of 'flag' items to ensure that estimates are extracted correctly.

The 'All types of care' data item (on the Child Care level) and the 'Type of care used by the family' (on the Income Unit Care level) include responses for child care used both 'in the last week' and 'in a usual week', and many of the items on these levels are specific to one or other of these time periods. Therefore, it is essential to use the 'flag' data items to restrict the population to the time period that you require. For example, to generate frequencies for care used by a child in a usual week, select the data item called 'Flag to indicate whether care used in a usual week' and select the category 'Care used in a usual week' and use this as a filter to restrict the table population.

Note that it is imperative that the 'usual week' or 'last week' care flags are used when any data items from the Child Care level or the Income Unit Care level are used, regardless of whether the care level data items are used alone or with other Income unit or Child level data items. If these flags are not used, the data will be incorrect.

The flags for the Child Care level, and their categories are:

Flag to indicate whether care used in a usual week

  1. Care not used in a usual week
  2. Care used in a usual week

Flag to indicate if care used last week

  1. Care not used last week
  2. Care used last week

The flags for the Income Unit Care level, and their categories are:

Flag to indicate if any child in family use care in a usual week

  1. No children in the family use care in a usual week
  2. At least one child in the family use care in a usual week

Flag to indicate if any child in family used care last week

  1. No children in the family used care last week
  2. At least one child in the family used care last week

Examples: Cross-tabulating data items from different levels

The following examples demonstrate how to apply the information provided in the sections above to cross-tabulate data from different levels on the CEaCS TableBuilder. The four levels are:

  1. Income Unit level
  2. Income Unit Care level
  3. Child level
  4. Child Care level

Example 1: Child level by Child Care level.

When cross-tabulating across levels, in particular with care level items (either from the Child Care level or Income Unit Care level), remember there are several things to consider - what weight to use (i.e. what is your counting unit? Families or children?), what time period do you require (i.e. last week or in a usual week?) and what care types do you require (i.e. individual types of care or summary care items?).

For example, consider you want to extract the number of children, aged 0-5 years, who used formal care in the last week, by type of formal care.
In this example the counting unit is children, the time period is last week and you're interested in the individual types of formal care as well as the total for all types of formal care.

The following steps are taken:

  1. Choose the data item 'Age of child 0-12 in single years' from the Child level
  2. Create a recode item for children aged 0-5 years (see the TableBuilder, User Guide for detail on how to do this).
  3. Select the formal care types you are interested in from the data item 'All types of care' from the Child Care level, including the summary category 'All formal care', which provides a total count.
  4. As a count children is required, and the lowest level item in the table is from the Child Care level, select the 'Care instances for children' as the weight to apply, from Summation Options under Child Care level.
  5. Choose the item 'Flag to indicate if care used last week' from the Child Care level and select the category 'Care used last week' to restrict the population for the table to those children who used care last week. Using the flag item eliminates double-counting of children across the two time periods ('in a usual week' and 'in the last week') and the resulting estimates represent the number of children aged 0-5 years by type of formal care. Note in this example that the flag item has been included in the table as a 'Filter' item (though it may be added as a Wafer, or added directly to the Column or Row).

Note from the tabulation shown below, that the sum of the different types of formal care (Before and after school care, Long day care, Family day care and Occasional care) is greater than the total for All formal care, as a child may have used more than one type of formal care in the last week. This highlights the need to use the summary data items when total counts are required.

Example Table 1: Child level by Child Care Level

Example 2: Income Unit level by Income Unit Care level.

The table below is a count of families with at least one child usually using care, by state/territory.
In this example the counting unit is families, the time period is a usual week, and the types of care required are totals for all formal care, all informal care and preschool.

The steps to create this table were:

  1. From the Income Unit Care level, the summary categories All formal care, All informal care and Preschool have been selected from the 'Type of care used by the family' data item.
  2. This has been cross-tabulated by the data item 'State or territory of usual residence' on the Income Unit level.
  3. The lowest level data item used is from the Income Unit Care level, so the Summation Option 'Care instances for families' is selected to apply the correct weight for this level.
  4. In addition, the flag item category 'At least one child in the family use care in a usual week' (from 'Flag to indicate if any child in family use care in a usual week') has been selected for the time period required. By using the flag items and eliminating any double-counting of families across the two time periods ('in a usual week' and 'in the last week') the estimates represent the number of families by state/territory by type of care.
Example Table 2: Income Unit level by Income Unit Care level

Example 3: Income Unit level by Child level by Child Care level

The table below is a count of children aged 0–8 years who used care in a usual week, by state.
In this example the counting unit is children, the time period is a usual week, and the types of care required include individual care types as well as summary (or total) care types.

The steps to create this table were:

  1. Data items were chosen - 'State or territory of usual residence' from the Income Unit level, the population data item 'Children aged 0–8 years' from the Child level, and multiple categories (for individual care types as well as summary categories) from the 'All type of care' item on the Child Care level.
  2. The Child Care level weight was selected ('Care instances for children' from the Summation Options), because the lowest level data item used is from the Child Care level.
  3. In addition, the flag item category 'Care used in a usual week' (from 'Flag to indicate whether care used in a usual week') has been used to apply the required time period. By using the flag item and eliminating any double-counting of children across the two time periods ('in a usual week' and 'in the last week') the estimates represent the number of children by state/territory by type of care.

Note that, as in Example 1, totals cannot be created by summing individual types of care, but are available in the summary care categories for the data item 'All types of care' (i.e. All care and preschool, All formal care, All informal care and All care excluding preschool).

Example Table 3: Income Unit level by Child level by Child Care level

Example 4: Child level by Income Unit level data using different weights.

There may be instances when it is useful to extract estimates based on the higher level weight in a cross-tabulation. The following example demonstrates how to correctly interpret data output in this way.

Firstly, the table below demonstrates the usual scenario - the data items 'State or territory of usual residence' from the Income Unit level and 'Whether child attends school' from the Child level are cross-tabulated. The Child level weight is used as it is the lowest level in the table. The result is a count of the number of children attending school by state.

Example Table 4: Child level by Income unit level using the Child level weight

When cross-tabulating data items from different levels using the weight from the higher level, things are more complicated and care needs to be taken. Under this scenario, data items at the lower level effectively become multi-response data items at the higher level and, in addition, each category in a data item is tabulated as 'one or more occurrences with the particular characteristic(s)'. It is important to note that the totals in these types of tables indicate the actual estimate of Income Units (i.e. each Income Unit counted only once) while the component cells, which contain the multi-response concept, will be greater than the total.

Using the same table as above, but replacing the Child level weight with the Income Unit level weight, the result is a count of the number of Income Units (i.e. families) with at least one child attending school (see table below). If a family has a child attending school and a child aged less than 4 years this family will be counted twice. Therefore, 'Whether child attends school' is treated as a multi-response data item when the Income Unit weight is used. Note that this is evidenced by the sum of the categories by state being greater than the 'Total' categories.

Example Table 4: Child level by Income unit level using the Income unit level weight

Adjustment of cell values

To minimise the risk of identifying individuals in aggregate statistics, a technique is used to randomly adjust cell values. This technique is called perturbation. Perturbation involves small random adjustment of the statistics and is considered the most satisfactory technique for avoiding the release of identifiable statistics while maximising the range of information that can be released. These adjustments have a negligible impact on the underlying pattern of the statistics. After perturbation, a given published cell value will be consistent across all tables. However, adding up cell values to derive a total will not necessarily give the same result as published totals. The introduction of perturbation in publications ensures that these statistics are consistent with statistics released via services such as TableBuilder. For CEaCS, perturbation was introduced in 2014.

Data item list

A complete list of the data items available for use, including population and classification details, can be found in an Excel spreadsheet in the Data downloads section.

The data item list spreadsheet has five worksheets, with data items grouped by level, as follows: 

  • Contents
  • Income Unit level
  • Income Unit Care level
  • Child level
  • Child Care level

Users intending to purchase the 2017 CEaCS TableBuilder should ensure that the data they require, and the level of detail needed, are available and applicable for the intended use.

Conditions of use

User responsibilities

The Census and Statistics Act 1905 includes a legislative guarantee to respondents that their confidentiality will be protected. This is fundamental to the trust the Australian public has in the ABS, and that trust is in turn fundamental to the excellent quality of ABS information. Without that trust, survey respondents may be less forthcoming or truthful in answering our questionnaires. For more information, see 'Avoiding inadvertent disclosure' and 'Microdata' on our web page How the ABS keeps your information confidential.

The release of microdata must satisfy the ABS legislative obligation to release information in a manner that is not likely to enable the identification of a particular person or organisation. Therefore, in accordance with the Census and Statistics Act, a confidentiality process is applied to the data in TableBuilder to avoid releasing information that may lead to the identification of individuals, families, households, dwellings or businesses.

Prior to being granted access to TableBuilder users must agree to the following ABS Terms & Conditions for Microdata and TableBuilder.

Conditions of sale

All ABS products and services are provided subject to the ABS Conditions of Sale. Any queries relating to these Conditions of Sale should be emailed to intermediary.management@abs.gov.au.

Price

Microdata access is priced according to the ABS Pricing Policy and Commonwealth Cost Recovery Guidelines. For details refer to ABS Pricing Policy on the ABS website. For microdata prices refer to the Microdata prices web page.

Australian universities

The ABS/Universities Australia Agreement provides participating universities with access to a range of ABS products and services. This includes access to microdata. For further information, university clients should refer to the ABS/Universities Australia Agreement web page.

Citations

Information or data from the Australian Bureau of Statistics must be acknowledged responsibly whenever it is used. Citing, or referencing is important for several reasons, including acknowledging that one has used the ideas, words or data of others. Accurately citing sources used also allows others to find and use the original information. For information on how to cite ABS data refer to Help: How to cite ABS Sources.

Further information

The Microdata Entry Page contains links to microdata related information to assist users in understanding and accessing microdata. For further information users should email microdata.access@abs.gov.au or telephone (02) 6252 7714.

Privacy

The ABS Privacy Policy outlines how the ABS handles any personal information that you provide to us.

Data downloads

CEACS 2017 TableBuilder data item list

Previous releases

 TableBuilder data seriesMicrodataDownloadDataLab
Childhood Education and Care, 2014TableBuilder  
Childhood Education and Care, 2011TableBuilder Detailed microdata
Childhood Education and Care, 2008  Detailed microdata
Child Care, 2005  Detailed microdata
Child Care, 2002  Detailed microdata
Child Care, 1999 Basic microdataDetailed microdata
Child Care, 1996 Basic microdata 
Child Care, 1993 Basic microdata 
Child Care Arrangements, 1984 Basic microdata 

Glossary

Show all

Quality declaration

Institutional environment

Relevance

Timeliness

Accuracy

Coherence

Interpretability

Accessibility

Abbreviations

Show all

Previous catalogue number

This release previously used catalogue number 4402.0.55.001.

Back to top of the page