Wanted to update the way that we do the midterm for MIS 400. We are going to talk about ideas for how to do this during the strategy meeting on 1/4/2011.
The changes will be based on Dr. Luce's MIS 220 hands on midterm and final from last quarter.
-Glenn
Ideas from the strategy meeting:
ReplyDeleteThe midterm will ask the students to create new products and insert them into a database.
1. Allow the students to look at their old code (implicitly)
2. TAs will grade based off of functionality, not the code itself. There will be a rubric.
3. We will provide the students with the GUI for the midterm - it will be up to them to provide the code.
4. In class, we will create a products view GRV during week three. This will be how we ensure that the product was actually inserted (grab all products with status of "new")
TO DO:
1. Create an in class assignment for the Products GRV
2. Create an exam
a. Template
b. Make a question Statement
c. Create a Rubric
3. Dyan will perform run through on the Test
4. Carter will test for weaknesses
RISK ASSESSMENT:
1. Code is being shared electronically by students
2. Time may be an issue - Test takes too long to complete.
3. Must avoid ambiguity in the charge.
4. Avoid large point deductions for single pieces of functionality
5. Point Deduction Ideas
a. Need to address grading on a case by case basis?
b. If page does not work, 30 - 40% is taken right off the top + plus other errors.
In Progress work is hosted locally on my machine... ASPPub-2.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteI have gone through most of the midterm and these are my thoughts on some of the vulnerabilities:
ReplyDelete1. We will need to go through the first few steps for the class (the unzipping, and adding the pages into the asppub). There are always students who have problems doing it or cannot remember. This should eliminate at least some risk of unneeded risk.
2. What if someone's original CustomerRegistrationExecuteNonQuery does not work in some way (does not load, does not insert into database, or even the student has not created the page)? It will not work in the final. As long as we (the TAs) make sure everyone has a working page, it should hopefully be fine.
3. When adding the downloaded pages to the SBGfolder, the student HAS to select 'All Files' in the dropdown list. Otherwise he/she will only add the HTML file and not the CS.
4. What happens if they cannot insert anything? Errors will be different for everyone. How many points will a person who misspelled something compare to someone who left something critical out?
I keep getting the following error message when I try to insert something: Cannot insert explicit value for identity column in table 'PRODUCT' when IDENTITY_INSERT is set to OFF
I'm taking a break and coming back to this later...let my mind rest.
inserting data into the database:
ReplyDeleteWarn the students that they should not be able to insert into the database.
*****Possible: make a new database that we can put into the zip file?
Possible: make product ID autonumbered.
Decided that we no longer will bring registration info over from other page
Use westgustgroceries database as the database for the midterm
- need to add new products table to this database
- Still using code.
Page Load event - add a hint that this is not where students want to type
Students will need to select "all files" when adding the .aspx and .cs files to their solution explorer
No longer need status of new?
- We will just pull in all products onto the view products page
Plan is to use the southbreezegroceries database.
need to confirm that product ID is unique
-Instructions need to say "do not include product ID.
-CONFIRMED: ProductID is autonumbered, so students will not
Move to a "create your own page" type of exam.
- give students instructions on what needs to be included in order to successfully complete the assignments.
Vic will post rubric
-Glenn
TO DO:
ReplyDeletePost a new set of instructions for the midterm, send to Carter and Dyan. Will have this done by EOD.
Guidelines to send:
-Students create a page (GUI) on their own following directions given to them
- 4 fields user can put info into
- Validators
- Must do insert into code
- Students will check their work on the "check new products page" that we provide them with or that they build. Look into this.
-Glenn
Hi Everyone!
ReplyDeleteI went through the latest and greatest version of the midterm and it is MUCH, MUCH better.
The assignment did not take me too long to complete and if they have been paying attention to the code thus far it should not take them too long either. I am going to say that it probably took me about an hour or so...?
Here are some things that still must be addressed in the directions:
1. Do you want the students to use a validation summary or are you not picky about this. The reason I ask this is because if they are granted a large amount of points on having the page load and look great (however not inserting anything) then the page should have good graphical designs. One thing we should decide is if two students have code that crashes but both have all validators and such. If one student has a nice looking webpage, but the other has a poorly designed one that also does not work, will that have an impact on the grading?
2. Another issue that might be addressed is just the order of the steps in the direction. I know that the instructions say to read the whole paper for beginning, but would it be possible to state earlier on that the product id does not need to be entered in the database due to auto numbering?
I really see no huge issue on this version of the test, but I still have the few main concerns that I did before. I still do not like that the students must use their homework ASPPub to do this assignment. What if their page is not running for some reason due to an issue in a prior assignment? Is there a way to make the same database and have them just make a separate folder that they can put this in and just post for the day?
Well just a few thoughts, I know we will have more to discuss tomorrow! See you all bright and early.
Dyan brings up two good points.
ReplyDelete1. Since we emphasize user interface design, we should credit that. This means we will need tangible ways of measuring good/bad design. Ideas?
2. Yes, we should make it clear that Product ID does not need to be imported.
3. Again, I agree execution the midterm should not be dependent on a an other page running. However, the ability to grade it will depend on having SbS 3.2(?) completed so the product insert can be verified.
MIS400 – Code Based Midterm.
ReplyDeleteRead through this entire page before beginning your midterm!
For your midterm you will be required to code a single webpage on your own. The purpose of this page is to insert – through code – a product into the database. You will use the South Breeze Groceries database to perform the insert. Be sure to use code-behind so that there is an associated .cs file. If you choose to perform the insert through the GUI or if your page does not load , we will not grade your submission.
On your AddAProduct.aspx page, you will need to have the following:
3 textboxes
1 checkbox
Validators for the textboxes
A submit button
The btnSubmit_Click event will be where you perform the insert (aka you should put your code here!)
Make sure that you identify what information the user should input into each textbox and checkbox.
Other things that you should know:
You should use the South Breeze Groceries database and connection string.
ProductID will not need to be one of the textboxes because this is an auto-generated field in the database.
This means that if you try to insert a new product into the PRODUCTS table, it will automatically assign a Product ID to the new product.
Once you are finished with your page, you can check that your insert was successful by checking out the gridview on the MidtermProductsPage.aspx. This page can be downloaded from the following location: INSERT LINK TO THE PAGE HERE.
This page will need to be added to the solution explorer underneath the South Breeze Groceries folder.
In order to navigate to MidtermProductsPage.aspx, add a button to your AddAProduct.aspx page and have it redirect there. If you do not include this button we will not be able to see if the insert was successful, and as a result you will only receive half
You now have everything you need to complete your midterm! Good luck, and don’t forget to submit the link to the ISMS forum after you copy everything over to the ASP.Net drive. Happy Coding!
https://www.msu.edu/~glazered/tc801/graphic.html
ReplyDeleteThis comment has been removed by the author.
ReplyDelete1. No validation summary, but people will need to put in validation
ReplyDelete2. Grades will be contingent on how the page looks (201 Principles)
- https://www.msu.edu/~glazered/tc801/graphic.html will be given to the students for design principles
- 25% for page loading
- 50% for page loading and looking nice
- 60% for Insert crashing and yellow screen
- 80% for Insert Crashing and Try-Catch
- 90% for insert Successful
- 100% for Insert successful and reviewed
3. Use the old connection string and the database for ASPPub?
- will need to supply a zip file for students to download if we don't do this.
- DECIDED: Use existing ASPPub and connection strings. Just add a page.
- ACTION: Will need to tell students that their pages will need to work before midterm
- They can go to help sessions for help.
- In future quarters, we may ask students to create a new connection string to a new database all on their own
-
4. Go through directions for Midterm and change things to be more orderly. Change the Language.
It's a wrap!
ReplyDeleteAt this point in my writing career, I simply want to get more visibility for your writing and I will write for free as long as you are okay with me adding a small author bio section next to each blog post about myself.Putlocker
ReplyDelete