3CSA148_Excel_FinalReview

3CSA148_Excel_FinalReview - Term Definition Primary Key...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Term Definition Primary Key Enter definition here Foreign Key Enter definition here Table Enter definition here Field Enter definition here Record Enter definition here List the Database Objects Enter definition here Referential Integrity Enter definition here Null Enter definition here Comparison Operator Equal = [This first one is completed as an example] Greater Than Greater Than or Equal To Less Than Less Than or Equal to Not Equal To Note: Refer to page EX 141 in your Excel book Note: Refer to the Introduction to Access presentation (available on the Day 28 Daily assignment slide) Enter Summary: Technical vs. Non-Technical by Gender Females Males Semester Non-Tech Tech Semester Non-Tech Tech 2002-03Fa 80% 20% 2002-03Fa 80% 20% 2002-03Sp 80% 20% 2002-03Sp 80% 20% 2003-04Fa 89% 11% 2003-04Fa 91% 9% 2003-04Sp 89% 11% 2003-04Sp 91% 9% 2004-05Fa 90% 10% 2004-05Fa 86% 14% 2004-05Sp 90% 10% 2004-05Sp 86% 14% 2005-06Fa 82% 18% 2005-06Fa 82% 18% 2005-06Sp 82% 18% 2005-06Sp 81% 19% 2006-07Fa 75% 25% 2006-07Fa 77% 23% 2006-07Sp 77% 23% 2006-07Sp 80% 20% Average Amount of Credits Taken Per Semeste Major Semester ECO MIS 2002-03Fa 16.60 16.25 2002-03Sp 17.60 17.25 2003-04Fa 15.33 15.89 2003-04Sp 16.00 16.78 2004-05Fa 15.75 15.58 2004-05Sp 16.63 16.17 2005-06Fa 15.92 15.67 2005-06Sp 16.15 15.47 2006-07Fa 15.73 15.50 2006-07Sp 16.27 16.21 Grand Tota 16.13 15.93 Average GPA By Entry Year EntryYear In-state Outstate 2003 2.143 2.143 2004 2.231 2.293 2005 2.000 2.214 2006 2.143 2.075 2002-03Fa 2003-04Fa 2004-05Fa 2005-06Fa 2006-07Fa 0% 5% 10% 15% 20% 25% 30% Male vs. Female Technical Column D Column H 2002-03Fa 2003-04Sp 2005-06Fa 2006-07Sp 14.00 14.50 15.00 15.50 16.00 16.50 17.00 17.50 18.00 ECO MIS 2003 2004 2005 2006 1.800 1.900 2.000 2.100 2.200 2.300 2.400 Grade Point Averages In and Out of State Column C Column D EntryYear GPA gpa Data 1 2 3 4 Total Total Average - Credits EntryYear Average - in-state or Average - Credits Average - in-state oAverage - Credits Average - in-state or out-sAverage - Credits AverAverAveraAverage - Credits 2003 3.5454545455 3.7142857143 3.6923076923 4 3.79 3.77 2004 3.1666666667 3.4285714286 3.5454545455 3.87 3.55 3.58 Total Result 3.4117647059 3.619047619 3.625 3.94 3.68 3.69 Average - gpa in-state or out-state EntryYear In-state Outstate Total Result 2003 2.1428571429 2.1428571429 2.1428571429 2004 2.2307692308 2.2931034483 2.2816901408 2005 2 2.2142857143 2.169014085 2006 2.1428571429 2.075 2.0925925926 Total Result 2.125 2.1904761905 2.1766917293 EntryYear State Credits FinalG rade gpa in-state or out-state 2003 3 A 4 Outstate 2003 3 B 3 Outstate 2003 3 C 2 Outstate 2003 3 D 1 Outstate 2003 3 F 0 Outstate 2003 4 A 4 Outstate 2003 4 B 3 Outstate 2003 4 D 1 Outstate 2003 5 B 3 Outstate 2003 IL 3 A 4 Outstate 2003 IL 3 B 3 Outstate 2003 IL 3 C 2 Outstate 2003 IL 3 D 1 Outstate 2003 IL 3 F 0 Outstate 2003 IL 4 A 4 Outstate 2003 IL 4 B 3 Outstate 2003 IL 4 C 2 Outstate 2003 IL 4 D 1 Outstate 2003 IL 4 F 0 Outstate 2003 IL 5 A...
View Full Document

Page1 / 13

3CSA148_Excel_FinalReview - Term Definition Primary Key...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online