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.

License

eFaculty Fellowship for Dual Enrollment – Montgomery College Copyright © by Shinta Hernandez and Akima Rogers. All Rights Reserved.