computer assignment

NP_AC16_CS1-4a_ShaunLynch_11.accdb

Home >Computer Science homework help >computer assignment

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Shaun	Lynch	{B8B2EA67-D6AC-42ED-941D-E85A26BFD114}	{B8B2EA67-D6AC-42ED-941D-E85A26BFD114}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

CoachID	CoachFirst	CoachLast	BGCExp	CertificationExp	CertificationLevel	LevelID
901021	Josh	Culligan	9/30/20	12/31/19	1	COLL
901263	Richard	Elliot	1/31/19	12/31/20	4	CJR
901366	Pamela	Reynolds	11/30/19	12/31/19	4	BEG3
901486	David	Hamm	1/31/20	12/31/19	4	BEG3
901563	Ashley	Bollinger	5/31/19	12/31/20	2	A1
901574	Matthew	Lambert	1/31/20	12/31/19	2	CSR
901575	Elise	Lew	8/31/20	12/31/20	3	A2
901742	Jim	Gibson	11/30/20	12/31/20	1	BEG2
901748	Andrew	Mendola	9/30/19	12/31/20	3	A3
901880	Anne	Harding	10/31/19	12/31/19	1	CINT

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;