Recording from December 8th, 2016 Session

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