{"id":150,"date":"2026-08-06T16:15:53","date_gmt":"2026-08-06T16:15:53","guid":{"rendered":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/?post_type=chapter&#038;p=150"},"modified":"2026-08-12T20:36:21","modified_gmt":"2026-08-12T20:36:21","slug":"process-over-product-approach","status":"publish","type":"chapter","link":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/chapter\/process-over-product-approach\/","title":{"rendered":"Process over Product Approach\u202f"},"content":{"raw":"<div style=\"font-weight: 400\">\r\n\r\nIn higher education, the Process over Product approach is a pedagogical framework that prioritizes and assesses how a student learns, thinks, and develops skills throughout an assignment, rather than focusing solely on the quality of the final submission.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nInstead of grading a student exclusively on a finished 10-page paper, a complex software application, or a final exam, this approach breaks the assignment down into formative milestones. You evaluate the critical thinking, revision, problem-solving, and iterative steps that led to the final outcome.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n<table data-tablestyle=\"MsoNormalTable\" data-tablelook=\"1184\">\r\n<tbody>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nAspect\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nProduct-Focused Approach\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nProcess over Product Approach\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nPrimary Focus\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nThe final deliverable (the \"what\").\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nThe journey, growth, and methodology (the \"how\").\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nAssessment\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nSummative (high-stakes grading at the very end).\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nFormative (low-stakes feedback at multiple checkpoints).\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nError Tolerance\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nMistakes penalize the final grade.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nMistakes are treated as data points for learning and pivot opportunities.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nAI Engagement\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nHigh vulnerability to outsourcing\/ghostwriting.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nInherently resistant to AI shortcuts because the steps must be visible.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n<h2>Implementing Process over Product in Assignments<\/h2>\r\n<\/div>\r\n<div>\r\n\r\nShifting to this model involves scaffolding assignments into sequential, graded steps. Here is how it translates to course design:\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"31\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Scaffolded Milestones: Break a major project into distinct phases. For example, a research assignment is graded across four parts: a topic proposal with research questions, an annotated bibliography, a rough draft with a peer-review reflection, and finally, the polished paper.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"31\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Reflection and Metacognition: Require students to submit a brief reflection log with their work. Ask them: What design choices did you make? Where did you get stuck, and how did you troubleshoot it?<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"31\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Iterative Drafts: Allow students to resubmit work or grade them specifically on how effectively they incorporated feedback from version X to version X+1.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<h2>Why This Matters in Modern Higher Education<\/h2>\r\n<\/div>\r\n<div>\r\n<ol>\r\n \t<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"20\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">De-incentivizes Academic Dishonesty: When the final \"product\" is the only thing that carries grade weight, students face immense pressure to outsource the work (whether to GenAI or a peer). When you grade the unique, messy process of creation, cheating becomes much harder and less appealing.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<div>\r\n<ol>\r\n \t<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"20\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Deepens Skill Acquisition: It teaches students how to learn. By forcing them to document their workflow, troubleshooting strategies, and conceptual pivots, you help them build lifelong metacognitive skills.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<div>\r\n<ol>\r\n \t<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"20\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Reduces High-Stakes Anxiety: Breaking a massive assignment into smaller, manageable chunks lowers student anxiety and reduces procrastination, resulting in higher-quality final work.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<div>\r\n\r\nThe following three Information Systems examples illustrate how to shift focus from final deliverables to student learning journeys. You can easily apply these same scaffolding techniques to the assignments in your own context.\r\n\r\n<\/div>\r\n<div>\r\n<h3>Example 1: Full-Stack Web App Project (4 weeklong)<\/h3>\r\n<\/div>\r\n<div>\r\n\r\nTo see how this works in practice, let\u2019s transform a traditional, high-stakes Information Systems project\u2014like building a full-stack web application with a database backend\u2014into a Process over Product framework.\r\n\r\n<\/div>\r\n<div>\r\n\r\nIn a traditional course, a student might submit the complete code at the end of the semester for 100% of the project grade. In a Process over Product model, we shift the weight to the design, iterative development, and troubleshooting stages.\r\n\r\n<\/div>\r\n<div>\r\n\r\nInstead of one massive deadline, the project is broken down into four distinct milestones. The final working code is only worth a portion of the total grade; the rest is earned by showing how they built it.\r\n\r\n<\/div>\r\n<div>\r\n\r\nMilestone 1: Architectural Design &amp; Schema: Week 1 (15% of project grade).\r\n\r\n<\/div>\r\n<div>\r\n\r\nStudents submit their conceptual blueprint before writing code. This includes a user flow diagram, an Entity-Relationship Diagram (ERD), and a list of AI prompts they used to help brainstorm or refine their database schema.\r\n\r\n<\/div>\r\n<div>\r\n\r\nWhat you are grading: Conceptual understanding, logical data relationships, and intentional planning.\r\n\r\n<\/div>\r\n<div>\r\n\r\nMilestone 2: The Core API &amp; Mock Data: Week 2 (25% of project grade).\r\n\r\n<\/div>\r\n<div>\r\n\r\nStudents build the basic backend routes using mock data. They must submit their code repository along with a short 2-minute screen recording demonstrating that their endpoints work using a tool like Postman.\r\n\r\n<\/div>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nWhat you are grading: Code structure, foundational logic, and early execution.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nMilestone 3: Peer Code Review &amp; Pivot Log: Week 3 (20% of project grade).\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nStudents swap code repositories with a classmate. They must identify two potential bugs or optimizations in their peers\u2019 code. Then, they submit a \"Pivot Log\" detailing the feedback they received and how they plan to alter their own development path to address it.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nWhat you are grading: Critical analysis, collaboration, and the ability to accept and act on technical feedback.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nMilestone 4: Final Integration &amp; Reflection: Week 4 (40% of project grade).\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nStudents deliver the final, connected application. Crucially, the submission must include a Troubleshooting Appendix. They must document at least two major bugs or logic errors they encountered during integration, explaining how they diagnosed the issue and what tools (e.g., console logs, debugger, GenAI) they used to solve it.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nWhat you are grading: Technical completeness, problem-solving methodology, and self-reflection.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<h2>Integrating Gen AI into the Process<\/h2>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nRather than banning AI tools, a process-oriented approach allows you to explicitly incorporate them into the grading rubric as an industry-standard workflow:\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nThe \"AI as a Collaborator\" Rubric: If students use GenAI to generate code snippets, they must include a brief markdown file in their repository showing their prompt history, the initial AI output, and a paragraph explaining the manual modifications or verification steps they had to perform to make that code actually work within their unique system architecture.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nThis ensures students aren't just copy-pasting answers; they are acting as the system architect and code reviewer, which is exactly the skill set they need in a modern, AI-driven tech workforce.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<h3>Example 2: Enterprise Cloud Data Warehouse Optimization (4 weeklong)<\/h3>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nWhen teaching advanced SQL, query optimization, and cloud data warehousing, a traditional \"product\" approach usually grades the final script or whether a query returns the correct result set.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nIn a Process over Product framework, you shift the focus to how the student arrived at that query, how they diagnosed performance bottlenecks, and their architectural decision-making. Since AI can easily generate a standard SELECT statement, grading the analytical and optimization workflow is where the true learning\u2014and assessment\u2014happens.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nHere is how you can restructure assignments for a pure database and cloud data warehousing course.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nThe Scaffolded Assignment: Enterprise Cloud Data Warehouse Optimization\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nInstead of asking students to simply build a warehouse and write queries, this project tasks them with migrating, modeling, and optimizing a messy, un-optimized legacy dataset into a modern cloud data platform (like Snowflake, BigQuery, or AWS Redshift).\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nMilestone 1: Architectural Design &amp; Schema Evolution: Week 1 (20% of grade).\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nStudents analyze a transactional (OLTP) dataset and design a dimensional model (Star or Snowflake schema) optimized for analytical (OLAP) workloads.\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n\r\nThe Process Deliverable: Students submit their Entity-Relationship Diagram (ERD) along with a Design Justification Document. They must explicitly defend why they chose specific columns for Fact vs. Dimension tables and identify potential slowly changing dimensions (SCDs).\r\n\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n\r\nWhat you grade: Data modeling logic and architectural reasoning, not just the DDL scripts.\r\n\r\n<\/div>\r\n<div>\r\n\r\nMilestone 2: ETL Pipeline &amp; Data Quality Assurance: Week 2 (25% of grade).\r\n\r\n<\/div>\r\n<div>\r\n\r\nStudents write the SQL scripts or utilize cloud orchestration tools to extract, transform, and load (ETL) the data into the cloud warehouse.\r\n\r\n<\/div>\r\n<div>\r\n\r\nThe Process Deliverable: Rather than checking if the data is there, students must submit a Data Validation Log. They must write and execute custom SQL unit tests to check for data integrity anomalies (e.g., orphan records, null violations, duplicates) and document how their pipeline handles dirty data.\r\n\r\n<\/div>\r\n<div>\r\n\r\nWhat you grade: Defensive programming habits and data quality engineering methodologies.\r\n\r\n<\/div>\r\n<div>\r\n\r\nMilestone 3: The Query Optimization Log: Week 3 (30% of grade).\r\n\r\n<\/div>\r\n<div>\r\n\r\nGive students a set of complex business questions requiring multi-table joins, subqueries, and window functions. The catch: the initial dataset is large, and a naive query will run slowly or consume excessive cloud compute credits.\r\n\r\n<\/div>\r\n<div>\r\n\r\nThe Process Deliverable: Students submit a Before-and-After Optimization Log for three complex queries. They must include:\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Version 1: Their initial working query.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The Diagnostics: A screenshot\/analysis of the Query Execution Plan (identifying table scans, heavy sorts, or join filters) and performance metrics (execution time, bytes scanned).<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Version 2: The optimized query (e.g., utilizing indexing, partitioning, clustering keys, or CTEs instead of subqueries).<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\">The Justification: An explanation of why the changes reduced the computation cost or execution time.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\nWhat you grade: Ability to read execution plans and apply optimization theory systematically.\r\n\r\n<\/div>\r\n<div>\r\n\r\nMilestone 4: Cloud Cost &amp; Security Governance Reflection: Week 4 (25% of grade).\r\n\r\n<\/div>\r\n<div>\r\n\r\nThe final phase looks at cloud infrastructure administration. Students configure Role-Based Access Control (RBAC) security policies and data masking.\r\n\r\n<\/div>\r\n<div>\r\n\r\nThe Process Deliverable: A short executive presentation or brief explaining their cloud governance strategy. If they used GenAI to help write complex window functions or optimization scripts, they must submit a \"Prompt Audit Trail\" detailing how they validated the AI's logic against their schema constraints.\r\n\r\n<\/div>\r\n<div>\r\n\r\nWhat you grade: Understanding of cloud economics, data security governance, and technical validation.\r\n\r\n<\/div>\r\n<div>\r\n<h2>Quick-Shift Examples for Weekly Lab Assignments<\/h2>\r\n<\/div>\r\n<div>\r\n\r\nIf you want to apply this to smaller, weekly homework assignments rather than a major project, you can make these quick adjustments:\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">The \"Explain Plan\" Quiz: Instead of a quiz asking for the output of a query, provide a complex query and its graphical Execution Plan. Ask students to circle the biggest performance bottleneck (e.g., a full table scan on a million-row table) and write a one-paragraph solution to fix it.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The AI Code Review Lab: Give students a functional but horribly un-optimized SQL query generated by a basic LLM prompt. Task the students with auditing the AI's work, identifying where it failed to utilize best practices (like missing partition filters), and rewriting it for a production environment.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\nThis approach flips the classroom dynamic: the AI becomes the draft-generator, and your students become the highly skilled database engineers who optimize, audit, and govern the infrastructure.\r\n\r\n<\/div>\r\n<div>\r\n\r\nHere is a structured AI Use Log template tailored specifically for database, SQL, and cloud warehousing courses. It balances a quick-glance tabular section for tracking interactions with a narrative text section where students must prove their critical thinking and validation process.\r\n\r\n<\/div>\r\n<div>\r\n\r\nYou can drop this directly into your syllabus, project guidelines, or assignment instructions.\r\n\r\n<\/div>\r\n<div>\r\n<h3>Student Assignment Addendum: GenAI Interaction &amp; Validation Log<\/h3>\r\n<\/div>\r\n<div>\r\n\r\nInstructions: If you utilize Generative AI (such as ChatGPT, Claude, Gemini, or GitHub Copilot) to assist you with data modeling, SQL generation, ETL scripting, or query optimization, you must complete and submit this log alongside your technical files.\r\n\r\n<\/div>\r\n<div>\r\n\r\nThe Golden Rule: The AI is your draft junior analyst; you are the system architect. You are graded on your ability to direct, audit, and modify the AI's output to fit our specific enterprise environment.\r\n\r\n<\/div>\r\n<div>\r\n\r\nSection 1: AI Interaction Ledger (Tabular Format)\r\n\r\n<\/div>\r\n<div>\r\n\r\nLog every major block of code, schema design idea, or optimization strategy you explored with AI.\r\n\r\n<\/div>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n<table data-tablestyle=\"MsoNormalTable\" data-tablelook=\"1184\">\r\n<tbody>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nStep #\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nIntent \/ Technical Goal\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nAI Tool Used\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nPrimary Prompt Used\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nAI Result Evaluation (Success \/ Partial \/ Fail)\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nEx. 1\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nGenerate a Star Schema for an e-commerce database.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nChatGPT-4o\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n\"Convert this OLTP schema [attached] into a Star Schema with 1 fact table and 4 dimension tables.\"\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nPartial. The dimension tables were good, but it missed a key surrogate key for the date dimension.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nEx. 2\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nOptimize a slow JOIN query.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nClaude 3.5 Sonnet\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n\"Why is this query [SQL attached] causing a full table scan on my cloud data warehouse cluster?\"\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nSuccess. It suggested using a cluster key\/partition column on order_date, which resolved the scan.\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nEx. 3\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n. . . .\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n. . . .\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n. . . .\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n. . . .\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nEx. 4\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<tr>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\nEx. 5\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<td data-celllook=\"4369\">\r\n<div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div><\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n<\/div>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n\r\n<span style=\"font-size: 14pt\">Section 2: Technical Validation &amp; Code Audit (Text Format)<\/span>\r\n\r\n<\/div>\r\n<div>\r\n\r\nFor any code or architectural choices generated by the AI that you actually implemented in your project, complete the following three narrative sections.\r\n\r\n<\/div>\r\n<div>\r\n\r\nPart A: The Hallucination &amp; Constraint Check\r\n\r\n<\/div>\r\n<div>\r\n\r\nAI tools lack context regarding your specific cloud database cluster size, partitioning strategy, and security constraints.\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"9\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Identify at least one mistake, inefficient line of code, or missing architectural constraint that the AI initially produced.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"9\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">How did you catch it? (e.g., \"The AI suggested a traditional index, but I am deploying on Snowflake\/BigQuery which uses micro-partitioning instead of traditional indexes.\")<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\nPart B: Code Modifications (The \"Before &amp; After\")\r\n\r\n<\/div>\r\n<div>\r\n\r\nShow how you adapted the AI's generic suggestion into production-grade code that aligns with our course database schema constraints.\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Initial AI-Generated Draft:<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\n-- Paste the unedited SQL snippet or configuration the AI gave you here.\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Iterative AI-Generated Modifications (multiple steps):<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"19\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">-- Paste your iterative prompts and explain exactly what you changed and why it was necessary for your specific database environment, and then the modification SQL snippet the AI gave you here.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"19\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Your Modified Final Production Code:<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\n-- Paste the actual SQL code you deployed in your database here\r\n\r\n<\/div>\r\n<div>\r\n\r\nPart C: Verification &amp; Testing\r\n\r\n<\/div>\r\n<div>\r\n\r\nHow did you prove that your final code was accurate and performing optimally after modifying the AI's work?\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"11\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">State the validation methods you used (e.g., checking record counts against the source data, verifying datatype casting, running an EXPLAIN PLAN or measuring compute credit consumption).<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\nGrading Rubric Snippet: AI Logging (Weight: 15% of Milestone Grade)\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"32\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Exemplary (Full Marks): Log is entirely complete. Student clearly demonstrated critical auditing of AI code, identified syntax\/architectural mismatch errors, adjusted the code successfully for a cloud warehouse environment, and verified the output with metrics (e.g., execution plans, row counts).<\/li>\r\n<\/ul>\r\n<\/div>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"32\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Developing (Partial Marks): Log is filled out, but student blindly accepted AI code without identifying inefficiencies. Code copies generic internet patterns rather than specific course architectural constraints. No clear validation metrics provided.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"32\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Unacceptable (0 Marks): Evident AI code usage throughout the project with no accompanying log, or log contains blank\/vague sections (e.g., writing \"I asked it to help me fix my code\" with no prompt or audit details).<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<h3><span style=\"font-size: 14pt\">Example 3: The Query Performance Trap (One week assignment)<\/span><\/h3>\r\n<\/div>\r\n<div>\r\n\r\nThe Scenario\r\n\r\n<\/div>\r\n<div>\r\n\r\nThe e-commerce database has a sales-transactions table with 12 million rows. The database administrator notices that the following query\u2014designed to calculate total sales per product category for the year 2025\u2014is running painfully slowly, taking over 45 seconds to execute and freeze up application resources.\r\n\r\n<\/div>\r\n<div>\r\n\r\nThe Assignment Task\r\n\r\n<\/div>\r\n<div>\r\n<ol>\r\n \t<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"38\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Analyze the Problem: Identify why the current query forces a full table scan of all 12 million rows instead of utilizing the existing B-Tree index on the order_date column. (Hint: Look closely at the function being applied to the WHERE clause).<\/li>\r\n<\/ol>\r\n<\/div>\r\n<div>\r\n<ol>\r\n \t<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"38\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Rewrite the Query: Write an optimized version of this SQL statement that achieves the exact same result but allows the database engine to utilize the order_date index effectively, dropping the execution time to under 1 second.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<div>\r\n<ol>\r\n \t<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"38\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Document Your Process: If you use GenAI to help you diagnose the performance trap or rewrite the syntax, you must complete the AI Interaction &amp; Verification Mini-Log below and paste it at the top of your .sql submission file.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<div>\r\n\r\nRequired Submission Header: AI Interaction &amp; Verification Mini-Log\r\n\r\n<\/div>\r\n<div>\r\n\r\nGrading Guide for this Question (Total: 10 Points)\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Technical Correctness (7 Points): Did the student successfully rewrite the query to avoid applying a function to the indexed column? (The optimized solution should use a range comparison like WHERE order_date &gt;= '2025-01-01' AND order_date &lt;= '2025-12-31' or database-equivalent date range syntax).<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The Process Mini-Log (3 Points - Binary Check):<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"o\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"2\">Full Credit (3\/3): The log is filled out completely. It clearly shows the student interacted with the tool, verified the outcome, and noted any adjustments made to move from a generic AI draft to their final tested query.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"o\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"2\">No Credit (0\/3): The code submitted is clearly AI-generated (using conventions not taught in class), but the log header is deleted, left blank, or filled out with placeholder fluff (e.g., \"I just asked it to fix the query and it worked\").<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<h3>Example 4: AI Transparency Policy for a writing assignment<\/h3>\r\n<\/div>\r\n<\/div>\r\n<div style=\"font-weight: 400\">\r\n<div>\r\n\r\nGenerative AI Transparency Policy: To encourage responsible innovation, you may utilize Gen AI tools for this assignment without penalty, provided you maintain absolute transparency. If you use AI at any stage, you must append an AI interaction log detailing for each use of AI tools:\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">The name of the AI tool is used.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The exact prompt(s) you submitted.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">The exact output generated by the AI.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\">Your subsequent response or refinement step.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\nGenerative AI Verification Policy: To document your writing, editing, and tool-interaction process, you are required to run your final text through two separate AI verification tools (such as <a href=\"https:\/\/copyleaks.com\/ai-detector\" target=\"_blank\" rel=\"noopener\">Copyleaks<\/a>, <a href=\"https:\/\/gptzero.me\/\" target=\"_blank\" rel=\"noopener\">GPTZero<\/a>, <a href=\"https:\/\/turnitin.app\/\" target=\"_blank\" rel=\"noopener\">Turnitin,<\/a> or <a href=\"https:\/\/www.grammarly.com\/ai-detector\" target=\"_blank\" rel=\"noopener\">Grammarly<\/a>). Your final submission must include a Mandatory Attachment appended to the very end of your memo document containing:\r\n\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"12\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">The complete final analysis report or clear screenshots from both checkers.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"12\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The overall AI probability percentages.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n<ul>\r\n \t<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"12\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Any highlighted text segments from the analysis.<\/li>\r\n<\/ul>\r\n<\/div>\r\n<div>\r\n\r\nHow This is Evaluated: An elevated AI detection score will not automatically result in a point deduction. The instructor will compare the checker\u2019s results directly against your attached AI interaction log. Full compliance with the interaction tracking and the verification report ensures zero point deductions. However, submitting text that returns an AI signature without the required interaction log and verification attachment will result in a score of zero. The final analysis and personal insights must always remain in your own distinct synthesis and reflection.\r\n\r\n<\/div>\r\n<div>\r\n\r\n&nbsp;\r\n\r\n<\/div>\r\n<\/div>","rendered":"<div style=\"font-weight: 400\">\n<p>In higher education, the Process over Product approach is a pedagogical framework that prioritizes and assesses how a student learns, thinks, and develops skills throughout an assignment, rather than focusing solely on the quality of the final submission.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Instead of grading a student exclusively on a finished 10-page paper, a complex software application, or a final exam, this approach breaks the assignment down into formative milestones. You evaluate the critical thinking, revision, problem-solving, and iterative steps that led to the final outcome.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<table data-tablestyle=\"MsoNormalTable\" data-tablelook=\"1184\">\n<tbody>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Aspect<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Product-Focused Approach<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Process over Product Approach<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Primary Focus<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>The final deliverable (the &#8220;what&#8221;).<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>The journey, growth, and methodology (the &#8220;how&#8221;).<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Assessment<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Summative (high-stakes grading at the very end).<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Formative (low-stakes feedback at multiple checkpoints).<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Error Tolerance<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Mistakes penalize the final grade.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Mistakes are treated as data points for learning and pivot opportunities.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>AI Engagement<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>High vulnerability to outsourcing\/ghostwriting.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Inherently resistant to AI shortcuts because the steps must be visible.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<h2>Implementing Process over Product in Assignments<\/h2>\n<\/div>\n<div>\n<p>Shifting to this model involves scaffolding assignments into sequential, graded steps. Here is how it translates to course design:<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"31\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Scaffolded Milestones: Break a major project into distinct phases. For example, a research assignment is graded across four parts: a topic proposal with research questions, an annotated bibliography, a rough draft with a peer-review reflection, and finally, the polished paper.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"31\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Reflection and Metacognition: Require students to submit a brief reflection log with their work. Ask them: What design choices did you make? Where did you get stuck, and how did you troubleshoot it?<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"31\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Iterative Drafts: Allow students to resubmit work or grade them specifically on how effectively they incorporated feedback from version X to version X+1.<\/li>\n<\/ul>\n<\/div>\n<div>\n<h2>Why This Matters in Modern Higher Education<\/h2>\n<\/div>\n<div>\n<ol>\n<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"20\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">De-incentivizes Academic Dishonesty: When the final &#8220;product&#8221; is the only thing that carries grade weight, students face immense pressure to outsource the work (whether to GenAI or a peer). When you grade the unique, messy process of creation, cheating becomes much harder and less appealing.<\/li>\n<\/ol>\n<\/div>\n<div>\n<ol>\n<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"20\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Deepens Skill Acquisition: It teaches students how to learn. By forcing them to document their workflow, troubleshooting strategies, and conceptual pivots, you help them build lifelong metacognitive skills.<\/li>\n<\/ol>\n<\/div>\n<div>\n<ol>\n<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"20\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Reduces High-Stakes Anxiety: Breaking a massive assignment into smaller, manageable chunks lowers student anxiety and reduces procrastination, resulting in higher-quality final work.<\/li>\n<\/ol>\n<\/div>\n<div>\n<p>The following three Information Systems examples illustrate how to shift focus from final deliverables to student learning journeys. You can easily apply these same scaffolding techniques to the assignments in your own context.<\/p>\n<\/div>\n<div>\n<h3>Example 1: Full-Stack Web App Project (4 weeklong)<\/h3>\n<\/div>\n<div>\n<p>To see how this works in practice, let\u2019s transform a traditional, high-stakes Information Systems project\u2014like building a full-stack web application with a database backend\u2014into a Process over Product framework.<\/p>\n<\/div>\n<div>\n<p>In a traditional course, a student might submit the complete code at the end of the semester for 100% of the project grade. In a Process over Product model, we shift the weight to the design, iterative development, and troubleshooting stages.<\/p>\n<\/div>\n<div>\n<p>Instead of one massive deadline, the project is broken down into four distinct milestones. The final working code is only worth a portion of the total grade; the rest is earned by showing how they built it.<\/p>\n<\/div>\n<div>\n<p>Milestone 1: Architectural Design &amp; Schema: Week 1 (15% of project grade).<\/p>\n<\/div>\n<div>\n<p>Students submit their conceptual blueprint before writing code. This includes a user flow diagram, an Entity-Relationship Diagram (ERD), and a list of AI prompts they used to help brainstorm or refine their database schema.<\/p>\n<\/div>\n<div>\n<p>What you are grading: Conceptual understanding, logical data relationships, and intentional planning.<\/p>\n<\/div>\n<div>\n<p>Milestone 2: The Core API &amp; Mock Data: Week 2 (25% of project grade).<\/p>\n<\/div>\n<div>\n<p>Students build the basic backend routes using mock data. They must submit their code repository along with a short 2-minute screen recording demonstrating that their endpoints work using a tool like Postman.<\/p>\n<\/div>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>What you are grading: Code structure, foundational logic, and early execution.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Milestone 3: Peer Code Review &amp; Pivot Log: Week 3 (20% of project grade).<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Students swap code repositories with a classmate. They must identify two potential bugs or optimizations in their peers\u2019 code. Then, they submit a &#8220;Pivot Log&#8221; detailing the feedback they received and how they plan to alter their own development path to address it.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>What you are grading: Critical analysis, collaboration, and the ability to accept and act on technical feedback.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Milestone 4: Final Integration &amp; Reflection: Week 4 (40% of project grade).<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Students deliver the final, connected application. Crucially, the submission must include a Troubleshooting Appendix. They must document at least two major bugs or logic errors they encountered during integration, explaining how they diagnosed the issue and what tools (e.g., console logs, debugger, GenAI) they used to solve it.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>What you are grading: Technical completeness, problem-solving methodology, and self-reflection.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<h2>Integrating Gen AI into the Process<\/h2>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Rather than banning AI tools, a process-oriented approach allows you to explicitly incorporate them into the grading rubric as an industry-standard workflow:<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>The &#8220;AI as a Collaborator&#8221; Rubric: If students use GenAI to generate code snippets, they must include a brief markdown file in their repository showing their prompt history, the initial AI output, and a paragraph explaining the manual modifications or verification steps they had to perform to make that code actually work within their unique system architecture.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>This ensures students aren&#8217;t just copy-pasting answers; they are acting as the system architect and code reviewer, which is exactly the skill set they need in a modern, AI-driven tech workforce.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<h3>Example 2: Enterprise Cloud Data Warehouse Optimization (4 weeklong)<\/h3>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>When teaching advanced SQL, query optimization, and cloud data warehousing, a traditional &#8220;product&#8221; approach usually grades the final script or whether a query returns the correct result set.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>In a Process over Product framework, you shift the focus to how the student arrived at that query, how they diagnosed performance bottlenecks, and their architectural decision-making. Since AI can easily generate a standard SELECT statement, grading the analytical and optimization workflow is where the true learning\u2014and assessment\u2014happens.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Here is how you can restructure assignments for a pure database and cloud data warehousing course.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>The Scaffolded Assignment: Enterprise Cloud Data Warehouse Optimization<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Instead of asking students to simply build a warehouse and write queries, this project tasks them with migrating, modeling, and optimizing a messy, un-optimized legacy dataset into a modern cloud data platform (like Snowflake, BigQuery, or AWS Redshift).<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Milestone 1: Architectural Design &amp; Schema Evolution: Week 1 (20% of grade).<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>Students analyze a transactional (OLTP) dataset and design a dimensional model (Star or Snowflake schema) optimized for analytical (OLAP) workloads.<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<p>The Process Deliverable: Students submit their Entity-Relationship Diagram (ERD) along with a Design Justification Document. They must explicitly defend why they chose specific columns for Fact vs. Dimension tables and identify potential slowly changing dimensions (SCDs).<\/p>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<p>What you grade: Data modeling logic and architectural reasoning, not just the DDL scripts.<\/p>\n<\/div>\n<div>\n<p>Milestone 2: ETL Pipeline &amp; Data Quality Assurance: Week 2 (25% of grade).<\/p>\n<\/div>\n<div>\n<p>Students write the SQL scripts or utilize cloud orchestration tools to extract, transform, and load (ETL) the data into the cloud warehouse.<\/p>\n<\/div>\n<div>\n<p>The Process Deliverable: Rather than checking if the data is there, students must submit a Data Validation Log. They must write and execute custom SQL unit tests to check for data integrity anomalies (e.g., orphan records, null violations, duplicates) and document how their pipeline handles dirty data.<\/p>\n<\/div>\n<div>\n<p>What you grade: Defensive programming habits and data quality engineering methodologies.<\/p>\n<\/div>\n<div>\n<p>Milestone 3: The Query Optimization Log: Week 3 (30% of grade).<\/p>\n<\/div>\n<div>\n<p>Give students a set of complex business questions requiring multi-table joins, subqueries, and window functions. The catch: the initial dataset is large, and a naive query will run slowly or consume excessive cloud compute credits.<\/p>\n<\/div>\n<div>\n<p>The Process Deliverable: Students submit a Before-and-After Optimization Log for three complex queries. They must include:<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Version 1: Their initial working query.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The Diagnostics: A screenshot\/analysis of the Query Execution Plan (identifying table scans, heavy sorts, or join filters) and performance metrics (execution time, bytes scanned).<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Version 2: The optimized query (e.g., utilizing indexing, partitioning, clustering keys, or CTEs instead of subqueries).<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"24\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\">The Justification: An explanation of why the changes reduced the computation cost or execution time.<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>What you grade: Ability to read execution plans and apply optimization theory systematically.<\/p>\n<\/div>\n<div>\n<p>Milestone 4: Cloud Cost &amp; Security Governance Reflection: Week 4 (25% of grade).<\/p>\n<\/div>\n<div>\n<p>The final phase looks at cloud infrastructure administration. Students configure Role-Based Access Control (RBAC) security policies and data masking.<\/p>\n<\/div>\n<div>\n<p>The Process Deliverable: A short executive presentation or brief explaining their cloud governance strategy. If they used GenAI to help write complex window functions or optimization scripts, they must submit a &#8220;Prompt Audit Trail&#8221; detailing how they validated the AI&#8217;s logic against their schema constraints.<\/p>\n<\/div>\n<div>\n<p>What you grade: Understanding of cloud economics, data security governance, and technical validation.<\/p>\n<\/div>\n<div>\n<h2>Quick-Shift Examples for Weekly Lab Assignments<\/h2>\n<\/div>\n<div>\n<p>If you want to apply this to smaller, weekly homework assignments rather than a major project, you can make these quick adjustments:<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">The &#8220;Explain Plan&#8221; Quiz: Instead of a quiz asking for the output of a query, provide a complex query and its graphical Execution Plan. Ask students to circle the biggest performance bottleneck (e.g., a full table scan on a million-row table) and write a one-paragraph solution to fix it.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The AI Code Review Lab: Give students a functional but horribly un-optimized SQL query generated by a basic LLM prompt. Task the students with auditing the AI&#8217;s work, identifying where it failed to utilize best practices (like missing partition filters), and rewriting it for a production environment.<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>This approach flips the classroom dynamic: the AI becomes the draft-generator, and your students become the highly skilled database engineers who optimize, audit, and govern the infrastructure.<\/p>\n<\/div>\n<div>\n<p>Here is a structured AI Use Log template tailored specifically for database, SQL, and cloud warehousing courses. It balances a quick-glance tabular section for tracking interactions with a narrative text section where students must prove their critical thinking and validation process.<\/p>\n<\/div>\n<div>\n<p>You can drop this directly into your syllabus, project guidelines, or assignment instructions.<\/p>\n<\/div>\n<div>\n<h3>Student Assignment Addendum: GenAI Interaction &amp; Validation Log<\/h3>\n<\/div>\n<div>\n<p>Instructions: If you utilize Generative AI (such as ChatGPT, Claude, Gemini, or GitHub Copilot) to assist you with data modeling, SQL generation, ETL scripting, or query optimization, you must complete and submit this log alongside your technical files.<\/p>\n<\/div>\n<div>\n<p>The Golden Rule: The AI is your draft junior analyst; you are the system architect. You are graded on your ability to direct, audit, and modify the AI&#8217;s output to fit our specific enterprise environment.<\/p>\n<\/div>\n<div>\n<p>Section 1: AI Interaction Ledger (Tabular Format)<\/p>\n<\/div>\n<div>\n<p>Log every major block of code, schema design idea, or optimization strategy you explored with AI.<\/p>\n<\/div>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<table data-tablestyle=\"MsoNormalTable\" data-tablelook=\"1184\">\n<tbody>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Step #<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Intent \/ Technical Goal<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>AI Tool Used<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Primary Prompt Used<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>AI Result Evaluation (Success \/ Partial \/ Fail)<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Ex. 1<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Generate a Star Schema for an e-commerce database.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>ChatGPT-4o<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&#8220;Convert this OLTP schema [attached] into a Star Schema with 1 fact table and 4 dimension tables.&#8221;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Partial. The dimension tables were good, but it missed a key surrogate key for the date dimension.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Ex. 2<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Optimize a slow JOIN query.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Claude 3.5 Sonnet<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&#8220;Why is this query [SQL attached] causing a full table scan on my cloud data warehouse cluster?&#8221;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Success. It suggested using a cluster key\/partition column on order_date, which resolved the scan.<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Ex. 3<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>. . . .<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>. . . .<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>. . . .<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>. . . .<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Ex. 4<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<tr>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>Ex. 5<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<td data-celllook=\"4369\">\n<div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<p><span style=\"font-size: 14pt\">Section 2: Technical Validation &amp; Code Audit (Text Format)<\/span><\/p>\n<\/div>\n<div>\n<p>For any code or architectural choices generated by the AI that you actually implemented in your project, complete the following three narrative sections.<\/p>\n<\/div>\n<div>\n<p>Part A: The Hallucination &amp; Constraint Check<\/p>\n<\/div>\n<div>\n<p>AI tools lack context regarding your specific cloud database cluster size, partitioning strategy, and security constraints.<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"9\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Identify at least one mistake, inefficient line of code, or missing architectural constraint that the AI initially produced.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"9\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">How did you catch it? (e.g., &#8220;The AI suggested a traditional index, but I am deploying on Snowflake\/BigQuery which uses micro-partitioning instead of traditional indexes.&#8221;)<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>Part B: Code Modifications (The &#8220;Before &amp; After&#8221;)<\/p>\n<\/div>\n<div>\n<p>Show how you adapted the AI&#8217;s generic suggestion into production-grade code that aligns with our course database schema constraints.<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Initial AI-Generated Draft:<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>&#8212; Paste the unedited SQL snippet or configuration the AI gave you here.<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Iterative AI-Generated Modifications (multiple steps):<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"19\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">&#8212; Paste your iterative prompts and explain exactly what you changed and why it was necessary for your specific database environment, and then the modification SQL snippet the AI gave you here.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"19\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Your Modified Final Production Code:<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>&#8212; Paste the actual SQL code you deployed in your database here<\/p>\n<\/div>\n<div>\n<p>Part C: Verification &amp; Testing<\/p>\n<\/div>\n<div>\n<p>How did you prove that your final code was accurate and performing optimally after modifying the AI&#8217;s work?<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"11\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">State the validation methods you used (e.g., checking record counts against the source data, verifying datatype casting, running an EXPLAIN PLAN or measuring compute credit consumption).<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>Grading Rubric Snippet: AI Logging (Weight: 15% of Milestone Grade)<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"32\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Exemplary (Full Marks): Log is entirely complete. Student clearly demonstrated critical auditing of AI code, identified syntax\/architectural mismatch errors, adjusted the code successfully for a cloud warehouse environment, and verified the output with metrics (e.g., execution plans, row counts).<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"32\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Developing (Partial Marks): Log is filled out, but student blindly accepted AI code without identifying inefficiencies. Code copies generic internet patterns rather than specific course architectural constraints. No clear validation metrics provided.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"32\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Unacceptable (0 Marks): Evident AI code usage throughout the project with no accompanying log, or log contains blank\/vague sections (e.g., writing &#8220;I asked it to help me fix my code&#8221; with no prompt or audit details).<\/li>\n<\/ul>\n<\/div>\n<div>\n<h3><span style=\"font-size: 14pt\">Example 3: The Query Performance Trap (One week assignment)<\/span><\/h3>\n<\/div>\n<div>\n<p>The Scenario<\/p>\n<\/div>\n<div>\n<p>The e-commerce database has a sales-transactions table with 12 million rows. The database administrator notices that the following query\u2014designed to calculate total sales per product category for the year 2025\u2014is running painfully slowly, taking over 45 seconds to execute and freeze up application resources.<\/p>\n<\/div>\n<div>\n<p>The Assignment Task<\/p>\n<\/div>\n<div>\n<ol>\n<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"38\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Analyze the Problem: Identify why the current query forces a full table scan of all 12 million rows instead of utilizing the existing B-Tree index on the order_date column. (Hint: Look closely at the function being applied to the WHERE clause).<\/li>\n<\/ol>\n<\/div>\n<div>\n<ol>\n<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"38\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">Rewrite the Query: Write an optimized version of this SQL statement that achieves the exact same result but allows the database engine to utilize the order_date index effectively, dropping the execution time to under 1 second.<\/li>\n<\/ol>\n<\/div>\n<div>\n<ol>\n<li data-leveltext=\"%1.\" data-font=\"Aptos\" data-listid=\"38\" data-list-defn-props=\"{&quot;335552541&quot;:0,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769242&quot;:[65533,0],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;%1.&quot;,&quot;469777815&quot;:&quot;multilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Document Your Process: If you use GenAI to help you diagnose the performance trap or rewrite the syntax, you must complete the AI Interaction &amp; Verification Mini-Log below and paste it at the top of your .sql submission file.<\/li>\n<\/ol>\n<\/div>\n<div>\n<p>Required Submission Header: AI Interaction &amp; Verification Mini-Log<\/p>\n<\/div>\n<div>\n<p>Grading Guide for this Question (Total: 10 Points)<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">Technical Correctness (7 Points): Did the student successfully rewrite the query to avoid applying a function to the indexed column? (The optimized solution should use a range comparison like WHERE order_date &gt;= &#8216;2025-01-01&#8217; AND order_date &lt;= &#8216;2025-12-31&#8217; or database-equivalent date range syntax).<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The Process Mini-Log (3 Points &#8211; Binary Check):<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"2\">Full Credit (3\/3): The log is filled out completely. It clearly shows the student interacted with the tool, verified the outcome, and noted any adjustments made to move from a generic AI draft to their final tested query.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"o\" data-font=\"Symbol\" data-listid=\"21\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[9675],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;o&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"2\">No Credit (0\/3): The code submitted is clearly AI-generated (using conventions not taught in class), but the log header is deleted, left blank, or filled out with placeholder fluff (e.g., &#8220;I just asked it to fix the query and it worked&#8221;).<\/li>\n<\/ul>\n<\/div>\n<div>\n<h3>Example 4: AI Transparency Policy for a writing assignment<\/h3>\n<\/div>\n<\/div>\n<div style=\"font-weight: 400\">\n<div>\n<p>Generative AI Transparency Policy: To encourage responsible innovation, you may utilize Gen AI tools for this assignment without penalty, provided you maintain absolute transparency. If you use AI at any stage, you must append an AI interaction log detailing for each use of AI tools:<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">The name of the AI tool is used.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The exact prompt(s) you submitted.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">The exact output generated by the AI.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"25\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\">Your subsequent response or refinement step.<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>Generative AI Verification Policy: To document your writing, editing, and tool-interaction process, you are required to run your final text through two separate AI verification tools (such as <a href=\"https:\/\/copyleaks.com\/ai-detector\" target=\"_blank\" rel=\"noopener\">Copyleaks<\/a>, <a href=\"https:\/\/gptzero.me\/\" target=\"_blank\" rel=\"noopener\">GPTZero<\/a>, <a href=\"https:\/\/turnitin.app\/\" target=\"_blank\" rel=\"noopener\">Turnitin,<\/a> or <a href=\"https:\/\/www.grammarly.com\/ai-detector\" target=\"_blank\" rel=\"noopener\">Grammarly<\/a>). Your final submission must include a Mandatory Attachment appended to the very end of your memo document containing:<\/p>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"12\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">The complete final analysis report or clear screenshots from both checkers.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"12\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The overall AI probability percentages.<\/li>\n<\/ul>\n<\/div>\n<div>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"12\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:1440,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">Any highlighted text segments from the analysis.<\/li>\n<\/ul>\n<\/div>\n<div>\n<p>How This is Evaluated: An elevated AI detection score will not automatically result in a point deduction. The instructor will compare the checker\u2019s results directly against your attached AI interaction log. Full compliance with the interaction tracking and the verification report ensures zero point deductions. However, submitting text that returns an AI signature without the required interaction log and verification attachment will result in a score of zero. The final analysis and personal insights must always remain in your own distinct synthesis and reflection.<\/p>\n<\/div>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n","protected":false},"author":24,"menu_order":3,"template":"","meta":{"pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":["hpaul"],"pb_section_license":""},"chapter-type":[],"contributor":[62],"license":[],"class_list":["post-150","chapter","type-chapter","status-publish","hentry","contributor-hpaul"],"part":108,"_links":{"self":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/pressbooks\/v2\/chapters\/150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/wp\/v2\/users\/24"}],"version-history":[{"count":3,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/pressbooks\/v2\/chapters\/150\/revisions"}],"predecessor-version":[{"id":170,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/pressbooks\/v2\/chapters\/150\/revisions\/170"}],"part":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/pressbooks\/v2\/parts\/108"}],"metadata":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/pressbooks\/v2\/chapters\/150\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/wp\/v2\/media?parent=150"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/pressbooks\/v2\/chapter-type?post=150"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/wp\/v2\/contributor?post=150"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/pressbooks.ulib.csuohio.edu\/usingaiinacademics\/wp-json\/wp\/v2\/license?post=150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}