The following are in reverse chronological order.
Final Exam (scores will be multiplied by two before adding to total points)
wrong type for a field like text instead of number -1
missing one-to-many relationship -3
major show-stopping problem with query, form, or report -5
missing query, form, or report -7
==============================================================================
0124 63 number in stock should not be text, where query shows all stores, no value query, no stats query, no onhand query, stocked form shows just one food item per store, value report does not sum inventory at each store,
03033 69 number in stock should not be text, value report does not total inventory in each store, moderate query should be >= 1 AND <= 5 not Or, foodzip query needs all 3 tables, where query needs all 3 tables, value query does not calculate value and does not sum, onhand query does not sum,
037005 94 number in stock should not be text, stats query does not show correct results,
072186 31 inventory table not correct, no relationships, foodzip query shows 90 rows when run, where query shows 90 rows when run, no value query, no stats query, no onhand query, no stocked form, no value report, no where report,
1488 69 number in stock should not be text, not enough inventory records leading to some food item not in any store, foodzip query shows all foods, where query shows all stores, value query does not sum inventory value at each store, onhand query does not sum, value report does not sum,
14Life 84 number in stock should not be text, value query not correct sums, onhand query not one row and not sum, value report based on bad field name,
2267 0
229 20 food and stores tables look good,
845785 99 number in stock should not be text,
986 65 inventory table has no quantity on hand field, foodzip query has a bad field name, where query has a bad field name, stats query is not one row sum/min/max/avg over all stores, onhand query does not sum, stocked form does not work, where report does not work,
Duffman014 54 food---inventory table relationship is not one-to-many, moderate query should be >= 1 AND <= 5 not Or, foodzip query does not run, where query shows all stores, value query does not run, no stats query, no onhand query, show food names in subform for stocked form, show store names in where report, no value report,
Monte 97 number in stock should not be text, tomatoes at Shop Rite twice in inventory table, some numbers not formatted for currency,
Sand 75 where query shows all stores, value query does not sum inventory for each store, stats query gives error message when run, onhand query does not work, value report does not work,
Sebastion 72 quantity on shelves should not be text, foodzip query shows all foods, where query shows all stores, value query does not sum inventory for each store, no onhand query, value report does not sum inventory at each store,
Steinbrennr 94 number in stock should not be text, onhand query does not sum all stores,
Weaver 40 number in stock should not be text, no table relationships, foodzip query gives 900 rows when run, where query gives 90 rows when run, no value query, no stats query, no onhand query, no stocked form, no where report, no value report,
babyboy5 58 whole bread is put at ShopRite twice in inventory table, foodzip query shows all stores, no moderate query, no stats query, no onhand query, where query shows all stores, value query does not calculate and sum inventory values at each store, value report does not sum inventory at each store,
matrix 78 food item unit cost should not be text, number in stock should not be text, moderate query shows all food items, value query does not sum inventory value at each store, onhand query does not sum, value report does not sum inventory at each store,
sandnsnow 80 foodzip query should be any store not particular store, value query does not sum, onhand query not all stores and not sum, value report does not sum,
snowball 98 number in stock should not be text, some numbers not formatted for currency,
umbrella 95 query onhand gives total inventory of all stores not the particular food,
wil2887 100
xx2xxxxxxxx 0
0124 90 junction table empty, only one report which is empty
03033 100
037005 100
072186 90 tables are good questions but queries, forms, and reports are better
1488 90 tables are good questions but queries, forms, and reports are better
14Life 100
2267 0
229 90 answers were provided in written form not as files on USB drive
845785 100
986 95 reports are read by humans and should show names not just primary keys from tables
Duffman014 100
Monte 100
Sand 40 only one exam question, no exam questions answers
Sebastion 100
Steinbrennr 100
Weaver 90 tables are good questions but queries, forms, and reports are better
babyboy5 70 tables are good questions but queries, forms, and reports are better; no exam question answers
matrix 100
sandnsnow 100
snowball 90 tables are good questions but queries, forms, and reports are better
umbrella 100
wil2887 100
xx2xxxxxxxx 0
0124 100
03033 100
037005 100
072186 84 no Tracking Forms; not all Fort Fun Forms
1488 94 not all Fort Fun Forms
14Life 94 not all Fort Fun Queries
2267 0
229 76 no Fort Fun Queries; no Fort Fun Forms; no Fort Fun Reports
845785 100
986 100
Duffman014 60 no IT Queries; no Fort Fun Queries; no Tracking Forms; no Fort Fun Forms; no Tracking Reports
Monte 20 no Word files; not all IT Queries; not all0 Fort Fun Queries; not all Tracking Forms; no Fort Fun Forms; no Tracking Reports; no Fort Fun Reports
Sand 55 some Word files missing; no Fort Fun Queries; no Fort Fun Forms; no Fort Fun Reports
Sebastion 76 no IT Queries; no Tracking Forms; no Fort Fun Forms
Steinbrennr 92 no Fort Fun Forms
Weaver 94 one Word files missing
babyboy5 92 not all Fort Fun Queries; not all Tracking Reports
matrix 52 no Word files; no Fort Fun Reports
sandnsnow 100
snowball 100
umbrella 100
wil2887 80 no Fort Fun Forms; not all Tracking Reports; no Fort Fun Reports
xx2xxxxxxxx 0
I am trying to do the last project and I can not find the clip art that it wants us to use. Can you please tell me how to proceed? I am talking about Page 228.Answer.
Don't panic, just use any academic-looking clip art.
10 songs: key, title, performer, CD title, date, category
15 students: key, fname, lname, major, ZIP, credits
30 row junction: key, student key, song key
students 1-many junction, songs 1-many junction
referential integrity
3 queries
3 forms, 2 are form with subform
3 reports
songs.html linked into your index.htm
0124 85 no forms with subforms; index.htm is your song list,i.e., you did not put a link in your index.htm TO your song list
03033 100
037005 100
072186 100
1488 95 no 1->many relationships with referential integerity
14Life 100
2267 60 textbook files got lost
229 40 no song database
845785 100
986 100
Duffman014 40 only part 1
Monte 100
Sand 20 did only Projects 2, 3, 4; no song database
Sebastion 95 no 1->many relationships with referential integerity
Steinbrennr 100
Weaver 100
babyboy5 100
matrix 100
sandnsnow 100
snowball 100
umbrella 100
wil2887 100
xx2xxxxxxxx 0
Teaching means making me learn. The job of a college professor is to make me learn.
Teaching does not mean making a student learn. The job of a professor is to provide for students the opportunity and environment to learn, to show them what they need to learn, and to assess student learning in order to assign a grade. It is the responsibility of the student to learn.
A student comes to class to turn in a project on his/her USB drive. The student finds to his/her great dismay that the files are missing on the USB drive and requests an extension to recreate the files. I ask about the backup USB drive. The student responds sheepishly that the files were not backed up onto the backup USB.Result.
The student must take a zero on the assignment and use his/her 100 "slack" "personal leave" points. The student protests that that is not how he/she wants to use those points.Response.
I don't know where your files might have ended up or how they might have disappeared, but I do know that you had no copies on your backup USB. I try to emphasize creating backup copies of files and even include those exact instructions on exams. If you don't do backups, then you suffer the consequences if something goes wrong. The consequences are painful and frustrating, as you are experiencing. I'm willing to bet that from now on you will be more conscientious making backups. This lesson is invaluable.
I don't like to hear "Well, I don't want to use my 100 points for that." because this kind of situation is exactly what the 100 points are for.
After trying many different schemes for late assignments and makeup exams, I have decided to incorporate 100 "slack" points into the grading scheme and accept no late assignments and give no makeup exams regardless of the reason. Why? It is very time consuming to decide what reasons are good and what are not. Obviously, you think your reason is good. I have decided not to characterize reasons as good or bad because it takes up too much time and energy to decide exactly where to draw the line between acceptable and not acceptable reasons.
Why are the exams in class and not take home?Answer.
The projects are designed to give students the knowledge and practice for the exams. The latter are used to assess the student learning that occurred (or not) during the projects. The exam length and time allowed are designed to make sure that floundering around with the questions, trying to figure out the material on the fly at exam time instead of thorough preparation before the exam, results in a low grade, as it should.
The projects are take home with some in-class time allocated so that students can take as much time as needed to learn the material. The exams are not for learning but for assessment and are therefore not take home.
In my judgement, five out-of-class projects and three in-class exams and a final are a good balance.
Since I did terrible on my first project and exam but better on my second project, is it still possible for me to pass with at least a C?Answer.
Here is a way to figure out the answer using Excel. Build an Excel spreadsheet and fill in your grades so far. Then put in hypothetical grades for everything else. Look at the syllabus, find the grading scheme, and put a formula into your spreadsheet that calculates your average. Play around with the hypothetical grades to see what the possibilities are.
To answer your question, that is exactly what I would do. Since Excel is part of this course, it is perfect for you to do it instead!
Web page items total 100 points
===============================
index.htm
embedded picture, -10 if missing or not working
link to resume.doc, -10 if missing or not working
link to coverletter.doc, -10 if missing or not working
link to video, -20 if missing or not working, -15 if < 60 seconds, -10 if < 120 secs, -5 if < 180 secs
link to the Rowan department Web page of your major, -10 if missing or not working
link(s) to club, hobby, and/or sport websites you've participated in, -10 if nothing at all in this category
link(s) to High Schools and other Colleges you have attended, -10 if nothing at all in this category
link(s) to sample work, -10 if nothing at all in this category
link(s) to Web pages of previous work positions, -10 if nothing at all in this category
0124 85 video falls into sample work category
03033 100
037005 100
072186 100
1488 85 video < 3 minutes -5, no club/hobby/sports -10
14Life 100
2267 90 no club/hobby/sports -10
229 60 no video -20, high school link invalid -10, work experience link invalid -10
845785 100
986 100
Duffman014 90 coverletter wrong format -5, video < 3 minutes -5
Monte 90 short corrupted video (choppy) -10
Sand 70 no video -20, hobby link invalid -10
Sebastion 100
Steinbrennr 100
Weaver 90 video < 3 minutes -10
babyboy5 100
matrix 70 file:// link to video -20, no work experience link -10
sandnsnow 100
snowball 95 video < 3 minutes -5
umbrella 95 video < 3 minutes -5
wil2887 0 no web page
xx2xxxxxxxx 0 no web page
xxx3xxxxxxx 0 no web page
almodo42
aydink85
bodine90
bompad79
bookma40
brewer03
catanz15
daya79
esserc80
evanst33
hannad27
henrym10
holmst28
mannin37
martin2p
miller4c
pantal17
perezi87
picone17
redesm70
reidj20
riosl31
schure94
yangj95
Using the following symbols
almodo42
aydink85
bodine90
bompad79
bookma40
brewer03
catanz15
daya79
esserc80
evanst33
hannad27
henrym10
holmst28
mannin37
martin2p
miller4c
pantal17
perezi87
picone17
redesm70
reidj20
riosl31
schure94
yangj95
home page:
http://elvis.rowan.edu/~hartley/index.html
e-mail:
hartley@elvis.rowan.edu