EN_ACD_L2_Designing Tables and Charts (1)

Designing Tables and Charts Data & Content Analysis

Quiz Solutions

  • Open-ended Questions: Recognizable by a blank box for responses. Categorical, nominal variables.

  • Closed-ended Questions:

    • Q2, Q11, Q14, Q13, Q15: Dichotomous, categorical, nominal.

    • Q10, Q12: Categorical, ordinal.

    • Q16: Multiple answers, categorical, nominal.

  • Likert Scales: Rating importance of values (numeric, discrete).

Steps in Data Analysis

  1. Check and Prepare Data: Verify accuracy, completeness, and treat missing responses.

  2. Univariate Data Analysis: Describe database, create tables and charts for insights.

  3. Bivariate/Multivariate Analyses: Understand relationships between variables.

  4. Writing the Report: Recommendations shared in the last class.

Analyzing Data on Sphinx Campus

  • Survey Selection: Choose relevant survey and open data module for analysis.

  • Module Analysis Options: Default Dataviv mode for real-time visualization (not used in course).

  • Export Results: Use the "Share" button for easy printing/saving.

  • Creating Analysis for Sub-Samples: Define filters for demographic analysis.

  • Understanding Data Representation: Use charts to visualize distributions.

  • Non-Response Treatment: Manage non-responses for accurate representation.

Presenting Data

  • Categorical and Ordinal Variables: Sort modalities for categorical; maintain order for ordinal.

  • Visualization Best Practices:

    • Pie charts for nominal, bar charts for ordinal.

    • Ensure easy readability in table design.

  • Presentation Rules: Sort tables; prioritize legibility over aesthetics.

Conclusion**: Reporting Results**

  • Charts must have clear titles and commentary explaining results thoroughly.