Differences

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

--- cs200_a3 [2023.09.29 09:42] – 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//
-  - How to handle/grade using AUTO_INCREMENT:
-    -  Student uses AUTO_INCREMEMENT but manually assigns correct values in table
-    -  Student uses AUTO_INCREMEMENT and lets system define values in table
-  - 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\\ //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====
-  - Should re re-score the assignment so it totals 100?
-  - Should we take off 1 point for not using right size of varchar?
-  - 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
-  - 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 ''INTEGER'' or ''INT'' (no 11) instead?
-  - 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?
-  - 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?
-  - Change A3 so it does NOT say that ID is an automatically generated number, as we specify its value?
-  - 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''?
-  - Change A3, page 4, change the first paragraph to point to https://apachefriends.org/download for getting XAMPP
-  - 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” 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''?