Practice Test Geeks(CED) Certified Executive Director Practice Test
← All CED Flashcard Decks

Data Analysis & Reporting Flashcards

7 cards from real CED practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Analysis & Reporting flashcards as text

  1. Which type of data analysis focuses on understanding why a trend or outcome occurred?

    Answer: Diagnostic analysis

    Diagnostic analysis examines root causes to explain why a particular trend or result occurred.

  2. An executive director needs to segment program participants by demographics for a funder report. Which tool is most appropriate for this task?

    Answer: Pivot tables in a spreadsheet application

    Pivot tables allow users to quickly summarize, group, and cross-tabulate large datasets by demographic or other categorical variables.

  3. A report shows that 95% of program participants rated satisfaction as 'high.' Why might an executive director be cautious about this finding?

    Answer: Ceiling effects and social desirability bias may inflate positive ratings

    Near-perfect ratings may reflect ceiling effects or respondents' desire to give socially acceptable answers rather than true perceptions.

  4. Which practice best supports equitable data analysis when evaluating program outcomes across demographic groups?

    Answer: Disaggregate data by race, gender, income, and other relevant dimensions

    Disaggregating data by demographic dimensions reveals disparities that aggregate totals can mask, enabling equity-focused decision-making.

  5. A CED reviews an impact report that confuses correlation with causation. Which statement best illustrates this error?

    Answer: 'Participants who attended more sessions had better outcomes, therefore our sessions cause better outcomes.'

    Concluding causation from a correlation between session attendance and outcomes ignores confounding factors such as participant motivation.

  6. An organization wants to measure social return on investment (SROI). Which component is unique to SROI compared to standard financial ROI?

    Answer: It monetizes social and environmental outcomes alongside financial returns

    SROI assigns monetary value to social and environmental outcomes, providing a broader measure of value than traditional financial ROI.

  7. Which data governance practice is most critical for protecting participant confidentiality in program reports?

    Answer: De-identifying data before sharing and applying role-based access controls

    De-identification and role-based access controls protect personal information while still enabling meaningful program reporting.