Spreadsheet tools are widely accessible to and commonly used by K-12 students and teachers. While spreadsheets are not ideal for many types of statistical analysis, they have an important role in data collection and organization. From a pedagogical standpoint, spreadsheets make data visible and easy to interact with, facilitating student engagement in data exploration, analysis, and computation. Though not suitable for all tasks, spreadsheets can facilitate learning and practicing data and computing skills for K-12 students. This paper 1) demonstrates the potential utility of spreadsheets in K-12; 2) reviews prior frameworks and standards that are relevant for K-12 data tools; and 3) proposes data-driven data skills to help develop data acumen and computational fluency. We provide some example activities, identify challenges and barriers to adoption, suggest pedagogical approaches to ease the learning curve for instructors and students, and discuss the need for professional development to facilitate deeper use of spreadsheets for data science and STEM disciplines.
翻译:电子表格工具在K-12学生和教师中广泛可用且普遍使用。虽然电子表格并不适合许多类型的统计分析,但它们在数据收集和组织中发挥着重要作用。从教学角度来看,电子表格能使数据可视化且易于交互,从而促进学生参与数据探索、分析和计算。尽管电子表格并非适用于所有任务,但它能促进K-12学生学习和实践数据与计算技能。本文:1)展示电子表格在K-12中的潜在实用性;2)回顾与K-12数据工具相关的既有框架和标准;3)提出数据驱动的数据技能,以帮助培养数据敏锐度和计算流畅度。我们提供了一些示例活动,指出采用过程中的挑战与障碍,建议采用教学方法以降低师生学习曲线的难度,并讨论通过专业发展促进电子表格在数据科学及STEM学科中更深层次应用的需求。