Excel

SC_AC19_EOM1-1_ZihuiLi_1.accdb

Home >Information Systems homework help >Excel

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Zihui	Li	{6B472D1E-5A7A-4CF7-A22A-1CF338AD74E8}	{6B472D1E-5A7A-4CF7-A22A-1CF338AD74E8}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

ClubID	ClubName	Address	City	State	PostalCode
C01	Queen City Aquatics	3587 Concord St.	Charlotte	NC	28210
C02	Hillview Swim Group	4372 Hillview St.	Greenville	SC	29601
C03	ATL Aquatics	1440 Junior Ave.	Atlanta	GA	30303
C04	Metro Swim Club	2973 Wright Ave.	Birmingham	AL	35209
C05	Athens Water Athletics	982 West lake Dr.	Athens	GA	30606

MemberID	FirstName	LastName	Street	City	State	PostalCode	ClubID
10003	Joseph	Eckler	29 Prospect Street	Pineville	NC	28134	C01
10005	Barry	Hassler	9 Harrington Avenue	Huntersville	NC	28070	C01
10006	Debbie	Ward	18 Barton Street	Bessemer	AL	35020	C04
10010	Ashish	Mittal	103 Hubbard Way	Fort Mill	SC	29707	C01
10011	Liz	Sorrento	134 Lincoln Road	Gadsden	AL	35901	C04
10015	Michelle	Kim	290 Brook Mill Road	Columbia	SC	29044	C02
10016	Robert	DeCosta	35 Washington Street	Greenville	SC	29601	C02
10017	Paul	Novick	302 Great Road	Atlanta	GA	30301	C03
10020	Carmen	Sanchez	1294 Monument Avenue	Charlotte	NC	28273	C01
10021	Kelly	Smith	7 Lakeview Road	Smyrna	GA	30081	C03
10025	Jessica	Picard	17 Briarwood Lane	Aiken	SC	29801	C02
10026	Sam	Bethel	258 Elm Street	Lexington	SC	29071	C02
10030	John	Ziminsky	1702 Hunter Avenue	Stone Mountain	GA	30083	C03
10031	Olivia	Alexander	29 Newtown Circle	Dunwoody	GA	30350	C03
10035	Tina	Sun	682 Hickory Way	Marietta	GA	30008	C03
10036	Mary	Grant	913 Main Street	Waxhaw	NC	28173	C01
10037	Alan	Fraser	41 Carver Hill Road	Spartanburg	SC	29301	C02
10039	Peter	Grigas	3 Pleasant Street	Greenville	SC	29603	C02
10040	Ronald	Cunningham	52 Putnam Road	Pineville	NC	28134	C01
10042	Kye	Nguyen	456 Harringont Avenue	Charlotte	NC	28277	C01
10043	Barry	Feinberg	73 Endicott Avenue	Waxhaw	NC	28173	C01
10044	Colleen	Murphy	47 Winter Street	Greenville	SC	29604	C02
10046	Marlene	Halpin	75 Elm Boulevard	Marietta	GA	30064	C03
10047	Elijah	Slomich	108 Roosevelt Avenue	Spartanburg	SC	29306	C02
10048	Todd	Wolfe	18 Parker Avenue	Charlotte	NC	28273	C01
10050	Zach	Adgate	92 Apple Blossom Lane	Pineville	NC	28134	C01
10051	Isabella	Cimino	429 South Street	Pineville	NC	28134	C01
10053	Vinnie	Tumbiolo	358 East Street	Atlanta	GA	30301	C03
10054	Jamal	Asmal	9872 Turnpike Road	Charlotte	NC	28277	C01
10055	Juliette	Beaumont	35 Walnut Street	Anderson	SC	29621	C02
10056	Kurt	Eisler	5 Bradford Circle	Charlotte	NC	28277	C01
10057	Charlotte	Eller	52 Bradley St.	Lexington	SC	29071	C02
10058	Pedro	Fuente	9 Mockingbird Lane	Anniston	AL	36201	C04
10059	Maggie	Hadley	6 Rose Court	Mooresville	NC	28115	C01
10060	Mark	Reynolds	11 Pond Lane	Rock Hill	SC	29730	C01
10061	Patricia	Reynose	112 Mainline Street	Birmingham	AL	35022	C04
10065	Shea	McKiernan	780 Flint Street	Matthews	NC	28104	C01
10066	Abigail	Turner	99 Maple Road	Birmingham	AL	35005	C04
10067	George	Krukonis	14 Collins Drive	Dunwoody	GA	30350	C03
10069	Maria	Gonzalez	100 Tower Drive	Charlotte	NC	28277	C01
10070	Joe	Adarski	40 Green Boulevard	Marietta	GA	30060	C03
10072	Ed	Curran	125 Fairview Drive	Anniston	AL	36203	C04
10073	Mary	Curran	25 Fairway Drive	Charlotte	NC	28277	C01
10075	Tom	Larson	70 Crater Lake Street	Bessemer	AL	35022	C04
11012	Julia	Ellison	8730 Swanson Court	Kennesaw	GA	30144	C03
11013	Beckett	Valencia	68 Orange St.	Flowery Branch	GA	30542	C03
11017	Remington	Wilkerson	9169 Ramblewood Dr.	Alabaster	AL	35007	C04
11032	Jax	Levy	33 E. Elmwood Ave.	Pelham	AL	35043	C04
11034	Trevin	Zavala	7176 Atlantic Rd.	Northport	AL	35473	C04
11042	Leah	Stuart	435 Westport Ave.	Roswell	GA	30009	C03

LevelID	Description	RegistrationFee	MonthlyFee	AnnualFee
1	10 and under age group	¤ 165.00	¤ 181.00	¤ 1,991.00
2	11 - 12 age group	¤ 165.00	¤ 193.00	¤ 2,123.00
3	13 - 14 age group	¤ 165.00	¤ 215.00	¤ 2,365.00
4	15 - 16 age group	¤ 165.00	¤ 231.00	¤ 2,541.00
5	Varsity	¤ 165.00	¤ 240.00	¤ 2,640.00
6	Senior	¤ 165.00	¤ 264.00	¤ 2,904.00

SwimmerID	FirstName	LastName	MemberID	LevelID
M10003	Damian	Eckler	10003	6
M10005	Finn	Hassler	10005	1
M10006	Andre	Vilas	10006	3
M10011	Katelynn	Smith	10011	1
M10011-01	Athena	Smith	10011	3
M10015	Francesca	Kim	10015	5
M10016	Andres	DeCosta	10016	6
M10017	Luke	Novick	10017	4
M10020	Mark	Sanchez	10020	3
M10021	Marianne	Rogers	10021	4
M10021-01	Bryson	Rogers	10021	4
M10025	Sydney	Picard	10025	2
M10026	Christine	Bethel	10026	2
M10031	Alex	Alexander	10031	3
M10035	John	Sun	10035	6
M10036	Jayden	Sinson	10036	5
M10036-01	Dean	Grant	10036	4
M10036-02	Edwin	Grant	10036	2
M10037	Lorena	Fraser	10037	4
M10039	Tatum	Grigas	10039	1
M10040	Quiang	Chou	10040	1
M10042	Alberto	Nyguyen	10042	2
M10043	Payton	Feinberg	10043	6
M10044	Alden	Murphy	10044	5
M10046	Aleena	Halpin	10046	5
M10047	Michael	Slomich	10047	1
M10048	Saige	Wofe	10048	1
M10050	Jessica	Adgate	10050	2
M10051	Donovan	Cimino	10051	3
M10053	Bryanna	Tumbiolo	10053	2
M10054	Hazel	Asmal	10054	4
M10055	Logan	Beaumont	10055	5
M10057	Sarah	Eller	10057	5
M10058	Emily	Fuente	10058	6
M10059	Curtis	Hadley	10059	6
M10060	Brennan	Reynolds	10060	1
M10061	Harry	Reynose	10061	2
M10065	Meghan	McKiernan	10065	3
M10067	Rafael	Krukonis	10067	3
M10069	Kei	Gonzalez	10069	4
M10070	Novak	Adarski	10070	5
M10070-01	Stan	Adarski	10070	2
M10070-02	Coby	Adarski	10070	2
M10072	Campbell	Curran	10072	4
M10073	Jean	Curran	10073	5
M10075	Aimee	Larson	10075	1
M11012	Micah	Ellison	11012	1
M11013	Axel	Valencia	11013	2
M11017	Guillermo	Gomez	11017	4
M11032	Xiomaro	Levy	11032	6
M11034	Angelo	Zavala	11034	3
M11042	Josh	Stuart	11042	4
M11042-01	Adam	Stuart	11042	1

StrokeCode	Description

SELECT DISTINCTROW * FROM Members;

SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;