Lesson 4 Final Project: SQL & Logic | Data Analysis Like an AI System (Capstone Task)

Culminating Performance Task for Lesson 4 of the AI Programming & Logic Unit

This Lesson 4 SQL & Logic Final Project serves as the capstone assessment for the unit, asking students to analyze data and apply logical conditions the way AI systems and developers do. Students create a small dataset, write SQL‑style queries, and use logical operators (AND / OR) to make decisions from data—simulating how AI processes information.

This project emphasizes conceptual understanding, reasoning, and explanation, not advanced syntax, making it accessible for beginners while still academically rigorous.

No prep required

Beginner‑friendly data analysis task

Designed to wrap up the unit’s learning progression

Project Overview: In this final project, students:

• Create a simple dataset (5–10 rows)
• Write 3–5 SQL‑style queries to retrieve information
• Apply logical operators (AND / OR) to filter data
• Explain how their queries work in plain language
• Reflect on how data and logic simulate AI decision‑making

The focus is on thinking like an AI system, not memorizing code.

Skills Assessed- Students demonstrate:

• Data organization and creation
• SQL querying concepts
• Logical reasoning with AND / OR
• Computational thinking
• Clear explanation and reflection
• AI literacy and data‑driven decision‑making

What’s Included (Component‑Level)

• Performance‑based final project prompt
• Clear student directions
• AI‑connected task framing
• Scoring rubric (20 points total)
• Alignment with Lesson 4 instruction and prior lessons
  (Instructional slides, worksheets, labs, and quizzes are included elsewhere in the unit bundle.)

Rubric Overview - The rubric assesses:

• Data creation quality
• Accuracy of SQL‑style queries
• Appropriate use of logical operators
• Clarity of explanation
• Overall effort and completeness

This allows for consistent grading while still encouraging student creativity and reasoning.

This final project is designed to be used:

• After students complete Lesson 4 instruction and practice
• As the formal summative assessment for the unit
• As a bridge between using AI tools and understanding how AI systems work

It reinforces the unit’s capstone idea:
AI systems work because of data and logic—and now students work with data and logic too.

Grade Levels

• Middle School (Grades 6–8)
• High School (Grades 9–12)
• Intro College / CTE

This final project is included as part of a larger AI Programming & Logic unit bundle and is intended for classroom use only. Redistribution is not permitted.

Keywords

SQL final project data analysis project AI and data lesson computer science capstone project logic and SQL project AI literacy assessment data driven decision making intro to SQL for students