Module 3 - Revision history

Todd: /* Grading */

2026-01-10T16:57:58Z

Grading

Todd: /* AI Tool Integration: Upvote Feature */

2026-01-10T13:23:28Z

AI Tool Integration: Upvote Feature

Todd: /* AI Tool Integration: Upvote Feature */

2026-01-10T13:17:47Z

AI Tool Integration: Upvote Feature

Todd: /* AI Tool Integration: Upvote Feature */

2026-01-10T13:11:46Z

AI Tool Integration: Upvote Feature

Todd: /* AI Tool Integration: Upvote Feature */

2026-01-10T13:07:18Z

AI Tool Integration: Upvote Feature

Todd: /* AI Tool Integration: Upvote Feature */

2026-01-10T13:06:51Z

AI Tool Integration: Upvote Feature

Todd: /* AI Tool Integration: Upvote Feature */

2026-01-10T13:04:01Z

AI Tool Integration: Upvote Feature

Todd: /* Grading */

2026-01-10T13:02:13Z

Grading

Todd: /* Grading */

2026-01-10T12:59:01Z

Grading

Todd at 16:27, 9 January 2026

2026-01-09T16:27:23Z

@@ Line 270: / Line 270: @@
 #* The output of each of the five queries is correct. (3 points each)
 #*: ''Note: To demonstrate the output of your queries, text files containing the 'entire' result (including the query and number of records found) of running each query should committed to Github. The file for query 1 should be named <code>query1.txt</code>, the file for query 2 should be named <code>query2.txt</code>, and so on.''
-#* A description of your AI usage in the AI Reflections portion of the README.md (5 points).
+#* Completion of the AI Reflections for the individual portion of the assignment following the [[AI Best Practices]] (5 points)
 # '''News Site (60 Points):'''
 #* '''''User Management (20 Points):'''''
@@ Line 300: / Line 300: @@
 #* '''''AI Tool Implementation (10 Points):'''''
 #** Upvote/downvote system is fully functional (5 points)
-#** A description of your AI usage in the AI Reflections portion of the README.md (5 points)
+#** Completion of the AI Reflections for the group portion of the assignment following the [[AI Best Practices]] (5 points)
 #*** Discuss any security or quality fixes you needed to make
 #** We recommend you to use "Edit" Mode of Copilot to implement this feature

@@ Line 219: / Line 219: @@
 '''AI Tool Usage Process:'''
+# '''Prompt Engineering''': Write clear, specific prompts asking the AI to generate PHP/MySQL code for the voting feature
-. '''Prompt Engineering''': Write clear, specific prompts asking the AI to generate PHP/MySQL code for the voting feature
+# '''Code Review''': Carefully review all AI-generated code for:
+#* Security vulnerabilities (SQL injection, XSS, etc.)
-. '''Code Review''': Carefully review all AI-generated code for:
+#* Code quality and readability
-* Security vulnerabilities (SQL injection, XSS, etc.)
+#* Compatibility with your existing codebase
-* Code quality and readability
+# '''Integration''': Modify and adapt the AI-generated code to work with your existing authentication system and database schema
-* Compatibility with your existing codebase
+# '''Testing''': Thoroughly test the feature to ensure it works correctly and securely
 '''Documentation Requirements:'''

@@ Line 208: / Line 208: @@
 '''Requirements''':
-- Implement an **upvote/downvote system** for stories and/or comments
+* Implement an **upvote/downvote system** for stories and/or comments
-- Use an AI coding assistant to help generate the initial code for this feature
+* Use an AI coding assistant to help generate the initial code for this feature
-- The voting system should:
+* The voting system should:
-  - Allow registered users to vote on stories and/or comments
+** Allow registered users to vote on stories and/or comments
-  - Prevent users from voting multiple times on the same item
+** Prevent users from voting multiple times on the same item
-  - Display vote counts prominently
+** Display vote counts prominently
-  - Sort stories by vote count (hot/trending)
+** Sort stories by vote count (hot/trending)
 '''AI Tool Usage Process:'''
@@ Line 223: / Line 223: @@
 . '''Code Review''': Carefully review all AI-generated code for:
-   - Security vulnerabilities (SQL injection, XSS, etc.)
+* Security vulnerabilities (SQL injection, XSS, etc.)
-   - Code quality and readability
+* Code quality and readability
-   - Compatibility with your existing codebase
+* Compatibility with your existing codebase
 . '''Integration''': Modify and adapt the AI-generated code to work with your existing authentication system and database schema

@@ Line 233: / Line 233: @@
 '''Documentation Requirements:'''
-In your AI Reflections portion of the README.md, include:
+In the '''AI Reflections''' section of your README.md, include the following:
-- Which AI tool you used
+* The '''AI tool(s)''' you used
-- Examples of prompts you used to generate the voting feature code
+In addition, submit a '''separate file in your GitHub repository''' containing the '''chat logs''' of your interactions with the AI tool(s).
 === Web Security and Validation ===

@@ Line 243: / Line 243: @@
 - Any security considerations you addressed in the AI-generated code
-- Chat logs of the prompts use with the AI tools (submitted in a separate file on GitHub)
+- Chat logs of your prompts with the AI tools (submitted in a separate file on GitHub)
 === Web Security and Validation ===

← Older revision		Revision as of 13:06, 10 January 2026
Line 242:		Line 242:

	- Any security considerations you addressed in the AI-generated code		- Any security considerations you addressed in the AI-generated code
		+
		+	- Chat logs of the prompts use with the AI tools (submitted in a separate file on GitHub)

	=== Web Security and Validation ===		=== Web Security and Validation ===

@@ Line 261: / Line 261: @@
 == Grading ==
-We will be grading the following aspects of your work.  There are 100 points total.
+We will be grading the following aspects of your work.  There are 105 points total.
 '''Assignments (including code) must be committed to Github by the end of class on the due date (commit early and often). Failing to commit by the end of class on the due date will result in a 0. '''
@@ Line 276: / Line 276: @@
 #*: ''Note: To demonstrate the output of your queries, text files containing the 'entire' result (including the query and number of records found) of running each query should committed to Github. The file for query 1 should be named <code>query1.txt</code>, the file for query 2 should be named <code>query2.txt</code>, and so on.''
 #* A description of your AI usage in the AI Reflections portion of the README.md (5 points).
 # '''News Site (60 Points):'''
 #* '''''User Management (20 Points):'''''
@@ Line 305: / Line 304: @@
 # '''Creative Portion & AI Integration (15 Points)'''
 #* '''''AI Tool Implementation (10 Points):'''''
-#** Upvote/downvote system is fully functional (4 points)
+#** Upvote/downvote system is fully functional (5 points)
 #** A description of your AI usage in the AI Reflections portion of the README.md (5 points)
 #*** Discuss any security or quality fixes you needed to make
 #** We recommend you to use "Edit" Mode of Copilot to implement this feature
 #** Be sure to create a new branch before implement this in case any of your original code being changed
-#* '''''Additional Creative Features (5 Points):'''''
+#* '''''Additional Creative Feature (5 Points):'''''
-#** Implementation of additional creative features beyond basic requirements
+#** Implementation of additional creative feature beyond basic requirements
 #** Feature enhances user experience and site functionality
 #* '''''Make sure you have a README.md file in your group repo with the following:'''''

@@ Line 269: / Line 269: @@
 ________
-# '''MySQL Queries (25 Points):'''
+# '''MySQL Queries (30 Points):'''
 #* A MySQL server is running on your instance. Put a screenshot in your repository of your terminal connected to your MySQL server. (2 points)
 #* Tables' fields, including data types and foreign keys, are correct (8 points)
@@ Line 275: / Line 275: @@
 #* The output of each of the five queries is correct. (3 points each)
 #*: ''Note: To demonstrate the output of your queries, text files containing the 'entire' result (including the query and number of records found) of running each query should committed to Github. The file for query 1 should be named <code>query1.txt</code>, the file for query 2 should be named <code>query2.txt</code>, and so on.''
 # '''News Site (60 Points):'''
 #* '''''User Management (20 Points):'''''
@@ Line 304: / Line 306: @@
 #* '''''AI Tool Implementation (10 Points):'''''
 #** Upvote/downvote system is fully functional (4 points)
-#** AI tool usage is properly documented in README.md (3 points)
+#** A description of your AI usage in the AI Reflections portion of the README.md (5 points)
-#** Code review process for AI-generated code is evident(security and quality fixes) (3 points)
+#*** Discuss any security or quality fixes you needed to make
 #** We recommend you to use "Edit" Mode of Copilot to implement this feature
-#** Be sure to create a new branch before implement this in case any of your original code being changed.
+#** Be sure to create a new branch before implement this in case any of your original code being changed
 #* '''''Additional Creative Features (5 Points):'''''
 #** Implementation of additional creative features beyond basic requirements
@@ Line 315: / Line 317: @@
 #** A link to your homepage of the site
 #** A brief description of what you did for your creative portion
-#** Documentation of AI tool usage (tool used, prompts, code review process)
+#** Documentation of AI tool usage (tool used, prompts, code review process) in the AI Reflections
 #** Any additional login details needed for the TA
 [[Category:Module 3]]
 [[Category:Modules]]

@@ Line 3: / Line 3: @@
 This article contains your assignments for Module 3.
 == Using the Wiki ==
@@ Line 18: / Line 19: @@
 </source>
 }}
@@ Line 192: / Line 201: @@
 * All data must be kept in a MySQL database (user information, stories, comments, and links).
 * Creative Portion.
 === Web Security and Validation ===
@@ Line 212: / Line 262: @@
 We will be grading the following aspects of your work.  There are 100 points total.
 '''Assignments (including code) must be committed to Github by the end of class on the due date (commit early and often). Failing to commit by the end of class on the due date will result in a 0. '''
 ________
 # '''MySQL Queries (25 Points):'''
-#* A MySQL server is running on your instance. Put a screenshot in your repository of your terminal connected to your MySQL server. ( (2 points)
+#* A MySQL server is running on your instance. Put a screenshot in your repository of your terminal connected to your MySQL server. (2 points)
 #* Tables' fields, including data types and foreign keys, are correct (8 points)
 #*: ''Note: To demonstrate the structure of your tables, you should commit a text file containing the output of the <code>SHOW CREATE TABLE</code> command '''for each table.''' Each table's file should have a name of the form <code>tablename.sql</code> (e.g. <code>students.sql</code>).''
@@ Line 252: / Line 301: @@
 #** Site is intuitive to use and navigate (4 points)
 #** Site is visually appealing (1 point)
-# '''Creative Portion (15 Points)''' (see below)
+# '''Creative Portion & AI Integration (15 Points)'''
 #* '''''Make sure you have a README.md file in your group repo with the following:'''''
 #** Names and Student IDs of all the group members
 #** A link to your homepage of the site
 #** A brief description of what you did for your creative portion
 #** Any additional login details needed for the TA
 [[Category:Module 3]]
 [[Category:Modules]]