Differences

This shows you the differences between two versions of the page.

--- cs200_a3 [2023.09.29 10:14] – Steve Isenberg
+++ cs200_a3 [2024.02.15 05:20] (current) – removed Steve Isenberg
@@ Line 1: / Line 1: @@
-~~NOCACHE~~ <fs x-small>This page last changed ~~LASTMOD~~ and viewed {{counter|today| time| times}} today, {{counter|yesterday| time| times}} yesterday, and {{counter|total| time| total times}} since it was created.</fs>
-=====Things to discuss about assignment 3=====
-====Scoring for Fall 2023====
-  - Is the score out of 100 or 102? <fc #ff0000>yes should be out of 100</fc>\\ //Chris graded out of 102 because I make a grade box for all of my assignments - I had a facil do that early on when I was in the program and I loved that level of feedback directly on the assignment//
-    - //yes should be out of 100; if a problem Cindy will handle. -Cindy//
-  - How to handle/grade if students who use the wrong size for their VARCHAR? <fc #ff0000>Don't take off points.</fc>\\ //Chris took 2 points off, once per assignment//
-  - How to handle/grade if a student uses AUTO_INCREMENT in the courses_taught table?\\ <fc #ff0000>Tell them not to use AutoIncrement as doesn't work in other DBMS.</fc>//Chris noted it, but did not take off points//
-  - <del>How to handle/grade using AUTO_INCREMENT:</del>
-    -  <del>Student uses AUTO_INCREMEMENT but manually assigns correct values in table</del>
-    -  <del>Student uses AUTO_INCREMEMENT and lets system define values in table</del>
-  - How to handle/grade: Inserting data that doesn't match the sample data //(Chris took 2 points off once)//
-  - How to handle using PRIMARY KEY instead of using CONSTRAINT\\ <fc #ff0000>Take off 2 points, tell them correct way.</fc>\\ //Kim and Steve both suggested 2 points, once per assignment; this should be explicitly stated in the grading guide for clarity//
-====Changes to Assignment 3 for future class running====
-  - <fc #ff0000>YES</fc> Should re re-score the assignment so it totals 100?\\ <fc #ff0000>Yes. Change #13 to be 9 points.</fc>
-  - <fc #ff0000>YES</fc> Should we take off 1 point for not using right size of varchar?\\ <fc #ff0000>Yes. Need a size, and should be correct. -1 for whole paper.</fc>
-  - <fc #ff0000>YES</fc> Change A3 so it does NOT say that ID is an automatically generated number, as we specify its value?
-  - Should we do anything with INT vs INT(11)?  //(Chris didn't -- it doesn't impact storage allocation at all, and is purely a display thing unlike VARCHAR)//
-    - Should we replace the ''INT(11)'' in the page 1 diagram and use <fc #ff0000>''INTEGER''</fc> or ''INT'' (no 11) instead? <fc #ff0000>Yes.</fc>
-  - Change A3, Instructions, Step 1, should we state that ''the quote characters typed in your document must be the simple quotes ' and ” and not the fancy ones''?
-    - Or should we have them submit a 2nd file with just the SQL?
-  - Should we tell students (a) not to use AUTO_INCREMENT or (b) that it's OK to use AUTO_INCREMENT or ( c) say nothing, or (d) penalize them for it\\ Warn students NOT TO USE Auto Increment; works in MySQL but not in other DBMS.
-  - <del>How to handle/grade using AUTO_INCREMENT:</del>
-    -  <del>Student uses AUTO_INCREMEMENT but manually assigns correct values in table</del>
-    -  <del>Student uses AUTO_INCREMEMENT and lets system define values in table</del>
-  - <fc #ff0000>NO</fc> Should we suggest in the assignment that students use Notepad(Windows) or TextEdit(MacOS) to write their statements then copy-paste into their document, thus avoiding curvy quotes, so both they and we can use the statements directly?
-  - <fc #ff0000>YES</fc> Change A3, page 1, Change RoomCode to varchar(6) and in the data change some room codes in the data to have A or B suffix?\\ <fc #ff0000>YES take all data types out AND add suffix.</fc>
-  - <fc #ff0000>YES</fc> Change A3, page 4, change the first paragraph to point to https://apachefriends.org/download for getting XAMPP
-  - <fc #ff0000>NO.</fc> Change A3, page 4, for the steps once you've downloaded XAMPP, step 3 should be rewritten ''Start the SQL web interface by typing ”localhost:8080/phpmyadmin” (Mac) :80 (Windows) as the URL in your browser.''\\ Remove step 4 and renumber step 5 accordingly
-  - Change A3, page 4, under Now you can answer..., first paragraph, change to read ''...you should not only include the SQL command in text exactly as you typed it into SQL, but also...''
-  - Change A3, add wording to say that ''your facilitator may be duplicating your work using the commands in your text''?