Course Practice Activities
For each module (7 total) in the course, students will be given the opportunity to complete a relevant course practice activity covering material from that particular module. These activities are ungraded, do not require a submission, and a solution will be provided so students can check their work. The purpose of the activities are to provide further learning before completing the scored assignments.
Course Activities
For each module (7 total) in the course, students will be asked to complete a relevant course activity covering material from that particular module. These activities will be submitted via Canvas as with the individual assignments, though these activities are designed to be shorter and address a particular task of the module. (For example, developing a piece of SQL using a specific function.)
Individual Homework Assignments
Students will be assigned individual homework assignments or analyses throughout the course. These assignments will include tasks designed to introduce and expand knowledge of data management and organizations. While it is acceptable to discuss aspects of the homework and solution strategy with others, students' submissions should represent their own work. For instance, it would be acceptable to ask for help if you keep getting an error message in SQL, but it would be unacceptable to take someone else’s SQL script, run it, and report the results. When in doubt, consult the professor. Assignments should be submitted online by the due date and time, a 20% reduction in points will be given for late work. No late work will be accepted after a solution is posted. Students will be allowed to make multiple attempts on assignments.
Quizzes
Each module will have an accompanying quiz to test student knowledge of the material (7 total quizzes across the course). Quizzes and tests are open note, open book, and even open Google. However, students may not work with others on these quizzes, either students registered for the class or others outside the class. Copying and pasting questions into AI tools and submitting the generated responses is prohibited. Quizzes and tests will have a time limit and will be taken with only 1 attempt.
Mid-Term and Final
During Module 4 a course Mid-term will be submitted. The midterm will be a paper describing how the techniques and skills gained in this and the prerequisite course will be applied to build their final project. The final will have a combination of multiple-choice, fill-in-the blank, matching, essay questions, and SQL coding questions. The final will cover all topics of the course. Both the mid-term. and final are open note, open book, and even open Google. However, students may not work with others on these quizzes. Copying and pasting questions into AI tools and submitting the generated responses is prohibited. The final will have a time limit of 90 minutes.
Course Project
Students will form teams or work individually to architect, develop, and deploy a small data warehouse using the discussed methodology and techniques in this and the pre-requisite course. This project will be developed throughout the course, with a final presentation on why and how the final semantic layer was built. While emphasis will be placed on technical skills during development of the project, particular emphasis will be placed on coherent and accurate explanation of the project in the form of a presentation to presented to a non-technical audience (like a C-suite or board of directors).
Use of AI Tools:
Responsible use of AI for learning and ideation will be permitted and encouraged in specific assignments where noted by the instructor. Unless explicitly allowed in the instructions, students may not use generative AI tools (e.g., ChatGPT, Bard, Copilot) to complete homework, quizzes, or tests. Copying and pasting questions into AI tools and submitting the generated responses is prohibited. These models may produce incorrect or misleading answers when lacking full course context, and such use undermines the learning process.