Skip to main content

An exploratory analysis of missing data from the Royal Bank of Canada (RBC) Learn to Play – Canadian Assessment of Physical Literacy (CAPL) project

Abstract

Background

Physical literacy comprises a range of tests over four domains (Physical Competence, Daily Behaviour, Motivation and Confidence, and Knowledge and Understanding). The patterns of missing data in large field test batteries such as those for physical literacy are largely unknown. Therefore, the aim of this paper was to explore the patterns and possible reasons for missing data in the Royal Bank of Canada Learn to Play–Canadian Assessment of Physical Literacy (RBC Learn to Play–CAPL) project.

Methods

A total of 10,034 Canadian children aged 8 to 12 years participated in the RBC Learn to Play–CAPL project. A 32-variable subset from the larger CAPL dataset was used for these analyses. Several R packages (“Hmisc”, “mice”, “VIM”) were used to generate matrices and plots of missing data, and to perform multiple imputations.

Results

Overall, the proportion of missing data for individual measures and domains ranged from 0.0 to 33.8%, with the average proportion of missing data being 4.0%. The largest proportion of missing data in CAPL was the pedometer step counts, followed by the components of the Physical Competence domain and the Children’s Self-Perception of Adequacy in and Predilection for Physical Activity subscales. When domain scores were regressed on five imputed subsets with the original subset as the reference, there were small and statistically detectable differences in the Daily Behaviour score (β = − 1.6 to − 1.7, p < 0.001). However, for the other domain scores the differences were negligible and statistically undetectable (β = − 0.01 to − 0.06, p > 0.05).

Conclusions

This study has implications for other researchers or educators who are creating or using large field-based assessment measures in the areas of physical literacy, physical activity, or physical fitness, as this study demonstrates where problems in data collection can arise and how missing data can be avoided. When large proportions of missing data are present, imputation techniques, correction factors, or other treatment options may be required.

Background

Physical literacy is defined as the “motivation, confidence, physical competence, knowledge and understanding to value and take responsibility for engagement in physical activities for life” [1]. The Royal Bank of Canada Learn to Play – Canadian Assessment of Physical Literacy (RBC Learn to Play–CAPL) was developed due to the shortage of objective physical literacy data, and aims to provide a reliable, feasible, and valid tool to assess physical literacy in children [2,3,4]. Within the CAPL there are four domains of measures (Physical Competence, Daily Behaviour, Motivation and Confidence, and Knowledge and Understanding), with participants receiving individual domain scores as well as an overall physical literacy score [5].

A Delphi process with international experts was used to develop the CAPL scoring system [6]. An overall physical literacy score was generated from multiple measures within the four domains. The Physical Competence and Daily Behaviour domains are more heavily weighted than the Knowledge and Understanding and Motivation and Confidence domains, due to the ability to objectively measure the former as well as due to some known limitations and biases within some of the protocols in the latter [2, 6]. Furthermore, in this process it was agreed that if a child was missing a single component within a domain or one entire domain, a domain score or overall physical literacy score could still be calculated using an algorithm designed to accommodate missing data and increase participant inclusion [3, 6]. The principle guiding these decisions was inclusivity, in order to ensure that as many children as possible were able to be included. This is important as the CAPL has numerous uses, including providing national surveillance, informing individual programs, providing evidence for resource allocation, and influencing policy decisions [4]. Thus, the inclusion of as many children as possible is extremely important. However, as with all decisions in research, there is the possibility that these decisions will influence the final results, as missing one particular component or domain could influence the results more than a child missing a different component or domain.

The problem of missing data is common to all types of studies, and it is important to understand the reasons why data are missing, to make sure the omission does not bias the results [7]. Missing data can be missing completely at random (i.e., there is no pattern in the missing data), missing at random (i.e., the missing data are significantly associated with the observed variables in the dataset), and missing not at random (i.e., the missing data are associated with the missing data pattern) [8]. As physical literacy is a relatively new area of measurement and CAPL is a new and unique dataset, it is important to understand the patterns and reasons for missing data. Because CAPL is a large test battery that encompasses various different measures, the results may be generalizable to other test batteries with multiple measures.

Thus, the aim of this paper was to explore the patterns and possible reasons for missing data in the RBC Learn to Play–CAPL project.

Methods

Study design and participants

The RBC Learn to Play–CAPL project was a Canada-wide cross-sectional study designed to measure the physical literacy of 8- to 12-year-old children [9]. Data were collected between 2014 and 2017 in 11 Canadian sites (Victoria, British Columbia; Lethbridge, Alberta; Calgary, Alberta; Winnipeg, Manitoba; North Bay, Ontario; Windsor, Ontario; Ottawa, Ontario; Trois-Rivières, Quebec; Antigonish, Nova Scotia; Halifax, Nova Scotia; and Charlottetown, Prince Edward Island). A convenience sampling method was utilized to recruit participants from various settings such as elementary schools, community centres, and after-school programs in order to have children of varying socioeconomic classes and levels of urbanization. A total of 10,034 children were included in the RBC Learn to Play–CAPL project; however, in this paper the number of children included varies by specific analyses due to the missing data.

Written informed consent was provided by parents or legal guardians, and verbal assent was provided by the children. The RBC Learn to Play–CAPL project was approved first by the Children’s Hospital of Eastern Ontario Research Ethics Board (the coordinating centre), and thereafter by each participating site’s institutional Research Ethics Board and participating school boards as required.

CAPL protocol

The participant’s physical literacy was assessed using the published CAPL protocol [3, 6]. The CAPL manual [5], along with associated training materials, is freely available online in both English and French (https://www.capl-ecsfp.ca). Briefly, the CAPL comprises measures of four domains: Physical Competence, Daily Behaviour, Motivation and Confidence, and Knowledge and Understanding. The CAPL provides individual domain scores as well as an overall physical literacy score [3]. The maximum CAPL score is out of 100 points, with Physical Competence, Daily Behaviour, Knowledge and Understanding, and Motivation and Confidence having maximum scores of 32 points, 32 points, 18 points, and 18 points, respectively [3, 6]. A short description of each of the domains is provided below, with more details available from Tremblay et al. [9].

Physical Competence

The Physical Competence domain is comprised of objective measurements of physical fitness, motor performance, and anthropometrics. Physical fitness measures included cardiorespiratory fitness assessed using the Progressive Aerobic Cardiovascular Endurance Run (PACER) [10]; muscular strength measured using handgrip strength [11]; muscular endurance assessed using the abdominal plank test [12]; and flexibility measured using the sit-and-reach test [11]. The Canadian Agility and Movement Skill Assessment (CAMSA) [13] was used to evaluate motor fitness, and the anthropometrics assessed were body mass index (BMI) z-scores [14] and waist circumference [11].

Daily Behaviour

This domain incorporates objective and subjective assessments of physical activity and sedentary behaviour. Pedometers (YamaxDigiWalker SW-200, Yamax Corporation, Tokyo, Japan) were used to measure physical activity for seven consecutive days. Additionally, the children answered questions regarding the number of days they had engaged in at least 60 min of moderate- to vigorous-intensity physical activity (MVPA) in the past 7 days, and their daily screen time habits on weekdays and weekend days [5].

Motivation and Confidence

The Motivation and Confidence domain was evaluated with a questionnaire that included items taken from published instruments in order to assess the participant’s motivation and confidence to be physically active. Each participant’s adequacy in and predilection for physical activity was measured using the Children’s Self-Perception of Adequacy in and Predilection for Physical Activity (CSAPPA) subscales [15]. Additionally, the children answered questions regarding perceived benefits and barriers of physical activity [16] and questions about how their activity levels and skills compared to their peers [3].

Knowledge and Understanding

This domain utilized a questionnaire in order to evaluate the children’s knowledge and understanding of health-related terminology, the utilization of safety equipment in daily life, how to improve motor and fitness skills, and physical activity and sedentary behaviour guideline recommendations [17].

Statistical analysis

A 32-variable subset of the larger CAPL dataset was used for these analyses, which consisted of age, gender, and the CAPL scores (25 components, four domain scores, and the overall physical literacy score) computed from the raw data in the CAPL dataset. The scoring algorithm with the missing protocol allowance had been previously applied to this data (see Additional file 1 for an example of the missing data scoring algorithm). Briefly, the CAPL algorithm for missing data involved the calculation of a re-weighted domain score when one protocol was missing, and/or the calculation of a re-weighted overall physical literacy score when one domain was missing. For example, the Physical Competence domain represented the sum of seven protocol scores (maximum value 160) divided by five (maximum value 32). If the sit-and-reach score (maximum value 8) was missing, the sum of the other six protocols (maximum value 152) was multiplied by 160 and divided by 152 (maximum value of 160). This re-weighed value was then divided by five (maximum value 32) so that it was mathematically comparable to the other Physical Competence scores [5]. Cohen’s d [18] was used to compare the scores in the RBC Learn to Play–CAPL project by the pedometer step counts score (missing vs. not missing).

Several R packages (“Hmisc” [19], “mice” [20], “VIM” [21]) were used for all analyses. “Hmisc” [19] was used to generate matrices and plots of missing data (see Additional file 2), and “VIM” [21] was used to create plots for the frequencies and patterns of missing data (Figs. 1 and 2). The R package “rpart” [22] was used to run a recursive partitioning analysis using age, gender, height, weight, school grade, and site to fit a multivariable model on missing steps data (variable with the greatest missing data). The purpose of this analysis, which was run separately and prior to the multiple imputation analysis, was to determine whether the best predictor(s) of missing steps data was/were suggestive of data missing at random, which is an assumption of multiple imputation by chained equations. The R package “mice” [20] was used to run an exploratory analysis with multiple imputation by chained equations where five imputations were performed with 50 iterations per imputation. Predictive mean matching, proportional odds modelling, and polytomous logistic modelling were used for continuous variables, ordered categorical variables, and unordered categorical variables, respectively. Demographic variables (site, age, and gender) and raw protocol variables (e.g., sit-and-reach maximum value, pedometer steps for each day of the week, pedometer wear time for each day of the week) for each domain were imputed. CAPL scores were then computed from the values in each imputed dataset. These scores were combined with the original 32-variable dataset and identified by a grouping variable for comparison via regression analysis. R 3.4.4 (The R Foundation for Statistical Computing, Vienna, Austria) was used for all analyses.

Results

Table 1 displays the proportion of missing data for the RBC Learn to Play - CAPL dataset. Overall, the proportion of missing data ranged from 0.0 to 33.8%, with the proportion of missing data being 4.0% on average. The largest source of missing data was step counts, at 33.8%. All of the components of the Physical Competence domain, as well as the overall Physical Competence domain score, had proportions of missing data, ranging from 3.6 to 6.4%. Furthermore, the CSAPPA predilection and adequacy subscales, and the overall domain score for Motivation and Confidence, had 4.0% missing data.

Table 1 Proportion of missing scores in the CAPL dataset stratified by domain after the application of CAPL missing data algorithm

Overall, there were 348 unique patterns of missing data within the subset of scores that we examined from the CAPL dataset. Figure 1 displays the frequencies and patterns of missing data for the domain scores and the overall physical literacy score within the RBC Learn to Play–CAPL project. A total of 8998 participants had enough data (i.e., had complete data or enough data to apply the missing data algorithm) to calculate the four domain scores and the overall physical literacy score. The Physical Competence domain had the highest proportion of missing scores (n = 646), with the Motivation and Confidence domain having the second highest proportion of missing domain scores (n = 409).

Fig. 1
figure 1

Frequency of all missing scores by domain and overall physical literacy (histogram on the left) and frequency of missing scores across scores by unique pattern (histogram on the right). Note: Dark grey bars and cells represent missing scores. In the histogram on the right, the numbers from the second row upward represent the number of missing scores per unique pattern. The bottom row (light grey cells across all columns) represents the number of complete scores across all domains and overall physical literacy. pc: Physical Competence score; db: Daily Behaviour score; mc: Motiviation and Confidence score; ku: Knowledge and Understanding score; capl: overall physical literacy score

Figure 2 shows the frequencies and patterns of missing data for the Daily Behaviour domain components. A total of 6502 participants had complete data for all three components (pedometer, self-reported MVPA, and self-reported screen time). The most common pattern for missing data was for children missing step counts (n = 3257), with the next largest patterns for missing data being the children missing all three components for the Daily Behaviour domain (n = 120) or missing the two self-report questions (n = 114). The recursive partitioning analysis (missing step scores ~ age + gender + height + weight + school grade + site) suggested that site was the best predictor of missing data for step counts. Three of the 11 sites included in the RBC Learn to Play–CAPL project were missing step counts for 69.2% of their participants on average. Two four-site groupings had 38.2 and 21.4% of missing step counts for their participants on average, respectively.

Fig. 2
figure 2

Frequency of all missing scores by Daily Behaviour protocol (histogram on the left) and frequency of missing scores across protocols by unique pattern (histogram on the right). Note: Dark grey bars and cells represent missing scores. In the histogram on the right, the numbers from the second row upward represent the number of missing scores per unique pattern. The bottom row (light grey cells across all columns) represents the number of complete scores across all Daily Behaviour protocols. Steps: pedometer score; screen: total screen time score; mvpa: self-reported moderate- to vigorous-intensity physical activity score

Table 2 compares the scores in the project data by those missing versus not missing the pedometer scores (measure with the greatest missing data). Effect sizes for differences for all of the variables were considered negligible to small (range for Cohen’s d: 0.00 to 0.39).

Table 2 Comparison of scores in the RBC Learn to Play–CAPL project by either missing or not missing the pedometer step counts

When the Daily Behaviour score was regressed on a grouping variable (nominal variable from 0 to 5, where 1 to 5 represented the five imputed datasets and zero represented the original dataset, which served as the reference), the scores were 1.6–1.7 units lower on average (p < 0.001) compared to the Daily Behaviour score in the original dataset. When expressed as Cohen’s d coefficients, this represents effect sizes ranging from 0.23 to 0.25. Using the same regression analysis on the other domain scores (Physical Competence, Motivation and Confidence, and Knowledge and Understanding) resulted in very small differences in domain scores between the imputed datasets and the original dataset. There were no statistically significant differences for Physical Competence scores in the imputed datasets (0.04 to 0.06 units lower), Motivation and Confidence scores in the imputed datasets (0.03 units lower), and Knowledge and Understanding scores in the imputed datasets (0.01 units lower).

Discussion

Missing data is a common problem in research, irrespective of study design [7]. The largest proportion of missing data in the RBC Learn to Play–CAPL project was the objectively assessed physical activity (pedometer step counts), distantly followed by the components of the Physical Competence domain and the CSAPPA subscales.

It has been found that compliance for US children wearing pedometers ranges from 46 to 98% [23], which is in line with the results observed in the RBC Learn to Play–CAPL project, where the compliance rate for the pedometers was 66.2%. However, even though our compliance rates are in line with previous research, there is still a large proportion of missing data that needs to be addressed and treated appropriately.

In this exploratory analysis of missing data within the RBC Learn to Play–CAPL project, our recursive partitioning analysis suggests that the largest influence on missing pedometer data was the test site and not demographic characteristics such as age, gender, weight, or height. Thus, it is likely that our missing pedometer data was missing at random, which indicates that the missing data are related to observed variables and not unobserved variables [7]. Therefore, the suggested method to handle the missing data would be multiple imputation [7]. Advantages of multiple imputation include the ability to provide unbiased estimates using only a few imputed datasets, and the capacity to compare the imputed and observed values [24]. However, the end user of the data needs to be considered before a decision on how to handle the missing data is made. If CAPL or other large test batteries with multiple measures are being used for research purposes, it is advised that the data be analyzed to see if similar missing data patterns are observed. If they are, and the data are missing at random, multiple imputation may be necessary. However, large assessment batteries such as CAPL are often used by physical education teachers to inform students and parents on the child’s physical literacy development. Therefore, using techniques such as multiple imputation would not be feasible, as those outside of research would not know or be able to easily apply this technique.

Our exploratory missing data analysis showed that the imputed datasets Daily Behaviour scores were 1.6 to 1.7 units lower on average when compared to the domain score in the original CAPL data frame, which corresponds to a small difference when expressed as a Cohen’s d (0.23–0.25). This is evidence that the existing scoring algorithm is not greatly influenced by the missing scores and therefore, the small difference in scoring seems to be an acceptable trade-off in exchange for a more inclusive assessment battery, with simple missing data procedures. However, in future versions of the CAPL it would be worth considering to not calculate the Daily Behaviour domain score for those missing pedometer step counts, as negligible differences were observed between overall CAPL scores for those with and without the Daily Behaviour domain score (data not shown).

Other sources of missing data within the RBC Learn to Play–CAPL project were the components within the Physical Competence domain and the CSAPPA subscales. The higher degree of missing data within the Physical Competence domain (range from 3.6 to 6.4%) might be due to the perceived difficulty and invasiveness of the tests. This domain encompassed five physical fitness tests (handgrip strength, sit and reach, plank, CAMSA, and PACER), and the degree of missing data increased with the intensity of the tests (e.g., 3.6% for handgrip and 6.4% for the PACER). Furthermore, for the anthropometrics, the proportion of missing data was 6.2% for BMI and 6.4% for waist circumference. However, our exploratory missing data analysis showed that the imputed datasets had Physical Competence scores that differed negligibly on average and were statistically undetectable when compared to the domain score in the original CAPL data frame.

The final large source of missing data in the RBC Learn to Play–CAPL project was the CSAPPA subscales. The amount of missing data for this component (4.0%) could possibly be due to the design of the questionnaire. The CSAPPA subscales are based upon the Harter format [25], where each question is comprised of two matched contrasting statements (e.g., some kids can’t wait to play active games after school BUT other kids would rather do something else after school). The participant is then asked to select which statement fits them best and if it is ‘really true for me’ or ‘sort of true for me’. As this type of question format has been found to be difficult for both children and adults [26, 27], it is possible that the children participating in the RBC Learn to Play–CAPL project did not fully understand how to answer these questions, and therefore skipped them. However, our exploratory missing data analysis showed that the imputed datasets had Motivation and Confidence scores that differed negligibly on average and were statistically undetectable when compared to the domain score in the original CAPL data frame.

Changes have been made to the CAPL testing process that it is hoped will lead to fewer instances of missing data. The CAPL is an extensive battery comprised of 25 components split into four domains. Due to the extensiveness of the CAPL battery, factor analyses were conducted in order to create a shorter and more theoretically aligned version of the CAPL [28]. Using confirmatory factor analysis, Gunnell et al. [28] found that the CAPL could be reduced to 14 components, and this new version was entitled CAPL-2. CAPL-2 consists of the same four domains as CAPL; however, the number of tests in each domain is greatly reduced [29]. For instance, the Physical Competence domain is now comprised only of the PACER, CAMSA, and plank. Even though these three components had a relatively high degree of missing data in CAPL (between 4.2 and 6.4%), it is thought that due to the reduction in tests, it will be less daunting for the children to complete and therefore there will be less missing data. Furthermore, the CSAPPA subscales are still included within the CAPL-2 battery; however, with the fewer number of subscale items (6 in CAPL-2 vs. 17 in CAPL), it is believed that evaluators will have more time to explain to the children how to properly fill in the questions as well as answer any questions the participants may have. Thus, it is hoped that the missing data for this component will be reduced in CAPL-2; future research should explore missing data in CAPL-2. Finally, the pedometer step counts, which were the largest source of missing data in CAPL (at 33.8%), are still included in CAPL-2. As site may be one of the strongest predictors for missing data for the pedometer, we recommend stressing to evaluators the importance of collecting complete data in participants. Another solution is to suspend the missing protocol rule for this domain so that if pedometer step counts are missing, no Daily Behaviour score is calculated. Even though missing data are inevitable, especially with objectively measured physical activity, a level of 34% is much too high.

To the best of our knowledge, this is the only study that has investigated the patterns of missing data in a large test battery for physical literacy consisting of a range of physical activity- and physical fitness-related components. This study has implications for other researchers or educators who are creating or using large field-based assessment measures in the area of physical literacy, physical activity, or physical fitness, as it demonstrates where problems in data collection may arise. Accordingly, measures can be put in place to avoid missing data before data collection begins. Examples of measures that can be put in place to help avoid missing data include: dividing fitness testing into two or more sessions depending on the number of tests; providing children with an alternative time for measuring body composition without their peers around; educating evaluators on the importance of having complete data; and, if utilizing questions that are using the Harter format [25], taking time to carefully explain to the participants how to correctly answer them.

Conclusions

We found that the largest sources of missing data in the RBC Learn to Play–CAPL project were pedometer step counts, followed by the components of the Physical Competence domain, and the CSAPPA subscales. Furthermore, we observed that the scoring algorithm used to calculate CAPL domain scores and the overall physical literacy score were not greatly influenced by the largest source of missing data (pedometer step counts), providing support for the use of the missing data algorithm.

Abbreviations

BMI:

Body mass index

CAMSA:

Canadian Agility and Movement Skill Assessment

CAPL:

Canadian Assessment of Physical Literacy

CSAPPA:

Children’s self-perception of adequacy in and predilection for physical activity

MVPA:

Moderate- to vigorous-intensity physical activity

PACER:

Progressive aerobic cardiovascular endurance run

RBC:

Royal Bank of Canada

References

  1. Tremblay MS, Costas-Bradstreet C, Barnes JD, Bartlett B, Dampier D, Lalonde C, et al. Canada's Physical Literacy Consensus Statement: process and outcome. BMC Public Health. 2018;18(Suppl 2) https://doi.org/10.1186/s12889-018-5903-x.

  2. Longmuir PE. Understanding the physical literacy journey of children: the Canadian assessment of physical literacy. Bull Int Council Sport Sci Phys Educ ICSSPE. 2013;65:1–6.

    Google Scholar 

  3. Longmuir PE, Boyer C, Lloyd M, Yang Y, Boiarskaia E, Zhu W, et al. The Canadian assessment of physical literacy: methods for children in grades 4 to 6 (8 to 12 years). BMC Public Health. 2015;15:767.

    Article  Google Scholar 

  4. Tremblay MS, Lloyd M. Physical literacy measurement - the missing piece. PHE J. 2010;Spring:26–30.

    Google Scholar 

  5. Healthy Active Living and Obesity Research Group. Canadian assessment of physical literacy: manual for test administration. Healthy Active Living and Obesity Research Group. 2013. https://www.capl-ecsfp.ca/capl-manual/. Accessed 26 Apr 2018.

  6. Francis CE, Longmuir PE, Boyer C, Andersen LB, Barnes JD, Boiarskaia E, et al. The Canadian assessment of physical literacy: development of a model of children's capacity for a healthy, active lifestyle through a Delphi process. J Phys Act Health. 2016;13(2):214–22.

    Article  Google Scholar 

  7. Dziura JD, Post LA, Zhao Q, Fu Z, Peduzzi P. Strategies for dealing with missing data in clinical trials: from design to analysis. Yale J Biol Med. 2013;86(3):343–58.

    PubMed  PubMed Central  Google Scholar 

  8. Bannon W Jr. Missing data within a quantitative research study: how to assess it, treat it, and why you should care. J Am Assoc Nurse Pract. 2015;27(4):230–2.

    PubMed  Google Scholar 

  9. Tremblay MS, Longmuir PE, Barnes JD, Belanger K, Andersen KD, Bruner B, et al. Physical literacy levels of Canadian children aged 8–12 years: descriptive and normative results from the RBC Learn to Play-CAPL project. BMC Public Health. 2018;18(Suppl 2) https://doi.org/10.1186/s12889-018-5891-x.

  10. Carrel AL, Bowser J, White D, Moberg DP, Weaver B, Hisgen J, et al. Standardized childhood fitness percentiles derived from school-based testing. J Pediatr. 2012;161(1):120–4.

    Article  Google Scholar 

  11. CSEP. Canadian Society for Exercise Physiology – physical activity training for health. Ottawa, ON: CSEP; 2013.

  12. Boyer C, Tremblay MS, Saunders TJ, McFarlane A, Borghese M, Lloyd M, et al. Feasibility, validity and reliability of the plank isometric hold as a field-based assessment of torso muscular endurance for children 8-12 years of age. Pediatr Exerc Sci. 2013;25(3):407–22.

    Article  Google Scholar 

  13. Longmuir PE, Boyer C, Lloyd M, Borghese MM, Knight E, Saunders TJ, et al. Canadian agility and movement skill assessment (CAMSA): validity, objectivity, and reliability evidence for children 8-12 years of age. J Sport and Health Sci. 2017;6(2):231–40.

    Article  Google Scholar 

  14. World Health Organization. Growth references 5–19 years. World Health Organization. 2007. www.who.int/childgrowth/standards/bmi_for_age/en/. Accessed 26 Apr 2018.

  15. Hay JA. Adequacy in and predilection for physical activity in children. Clin J Sport Med. 1992;2(3):192–201.

    Article  Google Scholar 

  16. Garcia AW, Broda MA, Frenn M, Coviak C, Pender NJ, Ronis DL. Gender and developmental differences in exercise beliefs among youth and prediction of their exercise behavior. J Sch Health. 1995;65(6):213–9.

    Article  CAS  Google Scholar 

  17. Longmuir PE, Woodruff SJ, Boyer C, Lloyd M, Tremblay MS. Physical Literacy Knowledge Questionnaire: feasibility, validity, and reliability for Canadian children aged 8 to 12 years. BMC Public Health. 2018;18(Suppl 2) https://doi.org/10.1186/s12889-018-5890-y.

  18. Cohen J. Statistical power analysis for the behavioral sciences. 2nd ed. New York: Lawrence Erlbaum Associates; 1988.

    Google Scholar 

  19. Harrell FE Jr, With contributions from Dupont C and many others. Hmisc: Harrell Miscellaneous. R package version 3.17–1. CRAN.R-project.org/package=Hmisc. Accessed 26 Apr 2018.

  20. van Buuren S, Groothuis-Oudshoorn K. Mice: multivariate imputation by chained equations in R. J Stat Softw. 2011;45(3):1–67.

    Google Scholar 

  21. Kowarik A, Templ M. Imputation with the R package VIM. J Stat Softw. 2016;74(7):1–16.

    Article  Google Scholar 

  22. Therneau T, Atkinson B, Ripley B. rpart: recursive partitioning and regression trees. R package version 4.1–10. CRAN.R-project.org/package=rpart. Accessed 26 Apr 2018.

  23. Ling J, King KM. Measuring physical activity of elementary school children with unsealed pedometers: compliance, reliability, and reactivity. J Nurs Meas. 2015;23(2):271–86.

    Article  Google Scholar 

  24. Van Buuren S. Flexible imputation of missing data. New York: Chapman & Hall/CRC; 2012.

    Book  Google Scholar 

  25. Harter S. Social support scale for children: manual and questions. University of Denver. 1985 (revised 2012). https://portfolio.du.edu/SusanHarter/page/44343. Accessed 26 Apr 2018.

  26. Eiser J, Eiser R, Havermans T. The measurement of self-esteem: practical and theoretical considerations. Person Individ Diff. 1995;18(3):429–32.

    Article  Google Scholar 

  27. Marsh H, Bar-Eli M, Zach S. Construct validation of Hebrew versions of three physical self-concept measures: an extended multitrait-multimethod analysis. J Sport Exerc Psychol. 2006;28:310–43.

    Article  Google Scholar 

  28. Gunnell KE, Longmuir PE, Barnes JD, Belanger K, Tremblay MS. Refining the Canadian Assessment of Physical Literacy based on theory and factor analyses. BMC Public Health. 2018;18(Suppl 2) https://doi.org/10.1186/s12889-018-5899-2.

  29. Healthy Active Living and Obesity Research Group. Canadian assessment of physical literacy: manual for test administration second edition. Healthy Active Living and Obesity Research Group. 2014. https://www.capl-eclp.ca/capl-manual. Accessed 26 Apr 2018.

Download references

Acknowledgements

The authors would like to acknowledge and thank the principal investigators of all the RBC Learn to Play–CAPL project sites: Kristal D. Anderson, Brenda Bruner, Jennifer L. Copeland, Claude Dugas, Melanie J. Gregg, Nathan Hall, Angela M. Kolen, Kirstin N. Lane, Barbi Law, Patricia E. Longmuir, Dany J. MacDonald, Luc J. Martin, Travis J. Saunders, Dwayne Sheehan, Michelle Stone, François Trudeau, and Sarah J. Woodruff. Without them this research would not have been possible. We would also like to thank Franco Momoli for his advice regarding the analyses as well as for recommending R code.

Funding

This study was funded by the Royal Bank of Canada (RBC), the Public Health Agency of Canada, and Mitacs, and was delivered in partnership with ParticipACTION. Publication charges for this article have been funded by the RBC Learn to Play–CAPL project and the Public Health Agency of Canada, delivered in partnership with ParticipACTION. CDN was supported by a grant from the Henning and Johan Throne-Holst Foundation.

Availability of data and materials

The datasets supporting the conclusions of this article and additional files are available upon reasonable request to Dr. Mark S. Tremblay (mtremblay@cheo.on.ca).

About this supplement

This article has been published as part of BMC Public Health Volume 18 Supplement 2, 2018: Canadian Assessment of Physical Literacy. The full contents of the supplement are available online at https://bmcpublichealth.biomedcentral.com/articles/supplements/volume-18-supplement-2.

Author information

Authors and Affiliations

Authors

Contributions

CDN, JDB, and MST developed the research question. JDB conducted the analysis and CDN wrote the manuscript. All authors were reviewed and revised the manuscript. All authors read and approved the final manuscript.

Corresponding author

Correspondence to Mark S. Tremblay.

Ethics declarations

Ethics approval and consent to participate

Ethics approval for this project was obtained from: Antigonish, NS - St. Francis University Research Ethics Board and the Strait Regional School Board; Calgary, AB - Mount Royal University Human Research Ethics Board; Charlottetown, PEI - University of Prince Edward Island Research Ethics Board and the Prince Edward Island Public Schools Branch Research Ethics Board; Halifax, NS - Dalhousie University Research and Ethics Board, and the Halifax Regional School Board; Lethbridge, AB - University of Lethbridge Human Subject Research Committee; North Bay, ON - Nipissing University Research Ethics Board, Near North District School Board, Nipissing Parry Sound Catholic District School Board, and Conseil Scolaire Catholique Franco-Nord; Ottawa, ON - CHEO Research Ethics Board, University of Ottawa Research Ethics Board, Ottawa-Carleton District School Board, Ottawa Catholic School Board, Conseil des écoles catholiques du Centre-Est, Conseil des écoles publiques de l’Est de l’Ontario, Upper Canada District School Board, Durham District School Board, University of Illinois at Urbana-Champaign; Trois-Rivières, QC - Université du Québec à Trois-Rivières Research Ethics Board; Victoria, BC - Camosun College Research Ethics Board and the Greater Victoria School District; Windsor, ON - University of Windsor Research Ethics Board and the Windsor Essex Catholic District School Board; Winnipeg, MB - The University of Winnipeg University Human Research Ethics Board, River East Transcona School Division, and St. James-Assiniboia School Division. Written informed consent was obtained from parents or legal guardians, and participating children also provided verbal assent.

Consent for publication

Not applicable.

Competing interests

The authors declare that they have no competing interests.

Publisher’s Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Additional files

Additional file 1:

The Canadian Assessment of Physical Literacy (CAPL) comprehensive scoring system and an example of CAPL’s scoring algorithm with the missing protocol allowance. (DOCX 506 kb)

Additional file 2:

Examples of the the plots generated using the “Hmisc” R package for the CAPL dataset. (DOCX 417 kb)

Rights and permissions

Open Access This article is distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution, and reproduction in any medium, provided you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license, and indicate if changes were made. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated.

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Delisle Nyström, C., Barnes, J.D. & Tremblay, M.S. An exploratory analysis of missing data from the Royal Bank of Canada (RBC) Learn to Play – Canadian Assessment of Physical Literacy (CAPL) project. BMC Public Health 18 (Suppl 2), 1046 (2018). https://doi.org/10.1186/s12889-018-5901-z

Download citation

  • Published:

  • DOI: https://doi.org/10.1186/s12889-018-5901-z

Keywords