Hello all,
This link contains the Recording Session from December 8th, 2016:
https://us.bbcollab.com/recording/65D7EE6A8940BA933DF2F743570D3EF9
We talked about the following topics:
- Designing SQL Query for ASR and generate a report for Most Active Courses per User: Bill Vilberg
- Presenting a Grade Center Report to show Attempts and Scores for all students in a course: Isaiah Andrea
Query:
SELECT U.USER_ID, GM.TITLE, A.SCORE,GM.POSSIBLE, A.ATTEMPT_DATE FROM ATTEMPT A
INNER JOIN GRADEBOOK_GRADE GG ON A.GRADEBOOK_GRADE_PK1 = GG.PK1
INNER JOIN GRADEBOOK_MAIN GM ON GG.GRADEBOOK_MAIN_PK1 = GM.PK1
INNER JOIN COURSE_USERS CU ON GG.COURSE_USERS_PK1 = CU.PK1
INNER JOIN COURSE_MAIN CM ON GM.CRSMAIN_PK1 = CM.PK1
INNER JOIN USERS U ON CU.USERS_PK1 = U.PK1
WHERE CU.ROLE = 'S'
AND CU.CRSMAIN_PK1 = (SELECT PK1 FROM COURSE_MAIN WHERE COURSE_ID = 'Enter Course ID Here')
ORDER BY U.USER_ID;
- Q&A Session: ALL
Due to the Holidays season, the next month's (January) session has been canceled. Our next meeting/presentation will on Thursday February 09, 2017. Please save the date and continue to ask questions and share your thoughts with us by posting in the Community Site: https://community.blackboard.com/groups/asradmins
Thank you,
Isaiah Andrea