Excel-application-based Basic Statistics course with individualized datasets from the Turkish National Statistics Institute¶

Design · All designs
Evidence · 2 claims (2 for) · 1 study (1 causal), q2 · 0 of 1 report an effect size · 2 claims rest on one study

Description¶

An instructional design in which a whole one-term Basic Statistics course for pre-service science teachers is taught through Excel applications: after the instructor introduces a concept, students examine Excel applications on their own notebooks, then complete application tasks using unique datasets downloaded from the Turkish National Statistics Institute, which they elaborate at home and present to peers. The article states that "the pre-service science teachers in the treatment group were assigned application tasks in which they should find the dataset assigned for them from the website of Turkish National Statistics Institute". Task files and presentations were scored and constituted the course grades.

Design Implications¶

Context¶

Requirements¶

Each student needs a computer with Excel installed and datasets ready for each topic
Unique datasets must be assigned to each student for each application task

Constraints¶

Tasks were initially designed to be 12 times but in practice could only be performed 6 times
The author reports a huge amount of time needed occasionally to solve tiny technical problems, suggesting an assistant technician for each 3-4 students

Target Learners¶

pre-service elementary science teachers

Learning Goals¶

descriptive and inferential statistics concepts and operations

Claims¶

Examples¶

-

Key Sources¶

Serhat Aydın. (2016). Using Excel in Teacher Education for Sustainability. Journal of Teacher Education for Sustainability, 18(2). https://doi.org/10.1515/jtes-2016-0017

Page metadata

Field	Value
`type`	`design`
`id`	`excel-application-statistics-course-element`
`title`	`Excel-application-based Basic Statistics course with individualized datasets from the Turkish National Statistics Institute`
`description`	`An instructional design in which a whole one-term Basic Statistics course for pre-service science teachers is taught through Excel applications: after the instructor introduces a concept, students examine Excel applic...`
`status`	`review`
`generated`	by `process:settle-candidates` on `2026-11-01`
`trust`	unverified — no one has confirmed this page's content
`sources`	1 — `serhat-aydın-2016`

Frontmatter is the page's machine-readable record — see the Schema & Guide.