Video tutorials are a popular medium for informal and formal learning. However, when learners attempt to view and follow along with these tutorials, they encounter what we call gaps, that is, issues that can prevent learning. We examine the gaps encountered by users of video tutorials for feature-rich software, such as spreadsheets. We develop a theory and taxonomy of such gaps, identifying how they act as barriers to learning, by collecting and analyzing 360 viewer comments from 90 Microsoft Excel video tutorials published by 43 creators across YouTube, TikTok, and Instagram. We conducted contextual interviews with 8 highly influential tutorial creators to investigate the gaps their viewers experience and how they address them. Further, we obtain insights into their creative process and frustrations when creating video tutorials. Finally, we present creators with two designs that aim to address gaps identified in the comment analysis for feedback and alternative design ideas.

中文翻译：

---

“我的有毒特质是认为我会记住这一点”：功能丰富的软件视频教程的学习者体验中的差距

视频教程是非正式和正式学习的流行媒介。然而，当学习者尝试查看并遵循这些教程时，他们会遇到我们所说的差距，即可能妨碍学习的问题。我们研究了电子表格等功能丰富的软件视频教程用户遇到的差距。通过收集和分析 43 位创作者在 YouTube、TikTok 和 Instagram 上发布的 90 个 Microsoft Excel 视频教程中的 360 条观众评论，我们开发了此类差距的理论和分类法，确定了它们如何成为学习障碍。我们对 8 位极具影响力的教程创作者进行了情境访谈，以调查他们的观众体验到的差距以及他们如何解决这些差距。此外，我们还深入了解了他们在创建视频教程时的创作过程和挫折。最后，我们向创作者展示了两种设计，旨在解决反馈和替代设计理念的评论分析中发现的差距。