GRINKLE "ONLY"

access20capstone20grading20rubric.xlsx

Home >Mathematics homework help >GRINKLE "ONLY"

Final Exam - Rubric

Final Exam - Access Capstone
Grading Rubric
Name:		Score:	100
Step	Description	Point Value	Points Earned
1a-1b	Database opened and saved as a00c1College_LastFirst	2
1c	a00c1Transfer workbook imported into a table named Transfer Schools; StudentID set as primary key	5
2a	StudentID field size set to 10	2
2b	StudentID format property has @ symbol removed	2
2c	AdmittingSchool field size set to 75	2
2d	RegistrationFee and TuitionDue fields have 0 decimal places	2
2e	Columns resized so all data is displayed	4
2f	Table sorted on CreditsTransferred field in Ascending order	4
3a-3c	One-to-one relationship created between Transfer Schools and Transfer Students tables; referential integrity enforced	2
4b	Major for Cornelius Kavanaugh set to Elementary Education	1
5a-5b	Transfer Credits query contains FirstName, LastName, Major, Class, and GPA fields from Transfer Students table and the AdmissionDate, TuitionDue, CreditsEarned, and CreditsTransferred fields from the Transfer Schools table	5
5c	Criteria set to 8/1/2015 for AdmissionDate field (144 fields displayed)	2
5d	TuitionDue for Diana Sullivan set to $1500; GPA for Audrey Owen set to 3.51	2
6a-6b	Transfer Credit Calculations query created from Transfer Credits query; has AdmissionDate criteria removed	5
6c	LostCredits field calculates difference between CreditsEarned and CreditsTransferred	2
6d-6e	TuitionPayments field calculates payment for student loans; formatted as Currency	2
6f	DueDate field calculates AdmissionDate plus 30	2
6g	Total row added to query; averages GPA field and sums LostCredits column	2
7a-7c	Transfer Summary query contains AdmittingSchool, StudentID, CreditsEarned, CreditsTransferred, and TuitionDue fields from Transfer Schools table; sorted by AdmittingSchool in Ascending order	5
7d	Query grouped by AdmittingSchool; shows Count of StudentID, Average of CreditsEarned and CreditsTransferred; Sum of TuitionDue	6
7e	CreditsEarned and CreditsTransferred formatted as Standard	2
7f-7g	Captions changed; columns resized in Datasheet view	2
8a	Split Form created from Transfer Schools table; named Transfer Schools Form	5
8b	AdmittingSchool field height reduced	1
8c-8e	Layout removed; fields shrunk; CreditsTransferred field appears to the right of CreditsEarned	4
8f-8g	TuitionDue font size is 18, and font color is Red; StudentID fill color is Yellow	3
9a-9b	Transfer Students Report contains Class, FirstName, LastName, Major, GPA, and LostCredits fields from the Transfer Credit Calculations query	5
10a	Wisp theme applied to this object	2
10b	Report grouped by Class field; sorted by LastName and then FirstName	5
10c	Class font size is 16	1
10d-10e	All values are visible; text boxes resized; report is one page wide	5
10f	PDF file a00c1Transfer_LastFirst created	4
11	Database is compacted, repaired and submitted	2
TOTALS		100	0