Recording from December 8th, 2016 Session

Version 1

    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