Sql Course Development Via Scaffolding, Social Constructivism, & Fantasy Football

Abstract

Applying scaffolding and social constructivist concepts in online learning environments requires consideration of multimedia design and the impact it has on learning achievement. Online learning is transforming students’ experiences from “learning from technology” to “learning with technology”. Social constructivism –theoretical model in which learners make meaning from experience – and scaffold –theoretical guidelines for learning through incremental assistance – approaches aid instructors in providing effective and responsible learning environments though balancing student support and engaging challenges to help students understand that, ultimately, they learn from and teach each other. This project seeks to execute scaffolding and social constructivist techniques in a prototype online undergraduate level course on Structured Query Language, a programming language, for computer science and related field students. The prototype focuses on utilizing datasets from professional football players and utilizing Gamification aspects to create a pseudo fantasy football league. Students manage their fantasy teams and compete via increasing difficult SQL statements.