117 Statistical Analysis for Faculty-Mentored Independent Student Research – Scaffolded Assignment #2
Nichole Gibbs Thomas
Cohort 2025
Learning Objectives
Students will learn to compute descriptive statistics (count, mean, range) using Google Sheets.
Purpose/Rationale
Students deepen their understanding of quantitative analysis by applying Excel functions to their personally generated data, reinforcing the connection between theory and empirical evidence.
Instructions
- Access the shared Google Sheets document.
- Use Excel functions to compute: count, mean, and range.
- Complete calculations for each elicited emotion variable.
- Optional: Visit the Digital Learning Center to create AI‑generated images illustrating the data‑analysis phase.
Format Requirements
Completed in Google Sheets
Rubric/Criteria
Evaluated using a rubric. Assignment counts for 1% of the final grade.