Coordinator Activity Indicator
Contents |
About
Develop an indicator about the activities of a course coordinator. For example,
- Have they logged in?
- Is there a course coordinator allocated?
- Are they a new coordinator to Blackboard or CQU?
- What level of activity are they doing with the site each week?
- How many times have the posted to the discussion forum in the last 2 weeks
- How many announcements have the posted in the last 2 weeks
- Percentage of messages within a discussion forum that has been read by the coordinator
What are the indicators?
List here what indicators we're going to include
Relevant database information
Bb Course user information
Database
- COURSE_USERS and USERS contain information about the users and who is allocated to which course
Code
- webfuse::lib::Blackboard::CourseUsers.pm gets information about users for a course
- webfuse::lib::Blackboard::Users.pm gets information about a user
ASA user information
Database
- DATA::PEOPLE information about users
- DATA::COURSE_MEMBERS who's teaching what
Code
- webfuse::lib::DATA::People.pm information about the users
- webfuse::lib::CourseUsers.pm who's teaching what
Activity
Database
- bb_bb60::ACTIVITY_ACCUMULATOR details about what is going on
Code
- Information about what a particular user has done in a recent time frame
TABLE => "bb_bb60.ACTIVITY_ACCUMULATOR",
CONDITIONS => "timestamp>{timestamp} and USER_PK1 in ( {PK1} )",
FIELDS => "USER_PK1,COURSE_PK1,count(INTERNAL_HANDLE)",
GROUP => "group by USER_PK1,COURSE_PK1",
Discussion forum
Database
- CONFERENCE_MAIN - Each course has a conference - i.e. the discussion board
- Actually can have many - e.g. ACCT19064 - one conference for different groups
- Fields = GROUPS_SOS_ID_PK2 DTCREATED PK1 ICON SOS_ID_PK2 DTMODIFIED BREAK_IND NAME CRSMAIN_SOS_ID_PK2 ORDER_NUM HTML_IND AVAILABLE_IND DESCRIPTION GROUPS_PK1 ROW_STATUS CRSMAIN_PK1 AREA_ID
- FORUM_MAIN - each conference contains many forums,
- PK1 from CONFERENCE_MAIN gets what we want
- Interesting fields MESSAGE_TRACK_HITS ORDER_NUM DESCRIPTION DTCREATED PK1 CONFMAIN_PK1 NAME DTMODIFIED ROW_STATUS
- Fields = COLOR_LISTING_OLD_MESSAGE COLOR_LISTING_NEW_MESSAGE MESSAGE_TRACK_HITS COLOR_MSG_BODY_BACKGROUND MESSAGE_STATUS_SHOWN ALLOW_ANNON_IND LISTING_FONT_SIZE MESSAGE_SHOW_HITS_TO_ALL MESSAGE_DATE_SHOW_SECONDARY PREFORMAT_IND MESSAGE_DATE_UPDATE_IS_PRIMARY ALLOW_MAILTO_IN_ARCHIVES ALLOW_ADMIN_ATTACH_ALWAYS MESSAGE_NEW_INCLUDES_CURRENT ALLOW_AUTHOR_EDIT_IND ALLOW_SORT_REVERSE ALLOW_ADMIN_EDIT_ALL_MESSAGES ORDER_NUM ALLOW_CUSTOM_SETTINGS MAX_ATTACH_LIMIT_KILOBYTES COLOR_LAST_VIEWED_BACKGROUND MESSAGE_WITH_THREADVIEWER ALLOW_ADMIN_VIEW_ANONYMOUS DESCRIPTION COLOR_MSG_HEADER_BACKGROUND ALLOW_PUBLISH_WITHOUT_PREVIEW DTCREATED PK1 CONFMAIN_PK1 HIDE_ARCHIVED_MESSAGES COLOR_MSG_HEADER_FOREGROUND ADMIN_EQUIVALENT_G ALLOW_ADMIN_REMOVE_MESSAGE ALLOW_LOCKS_IN_ARCHIVES COLOR_MSG_MAILTO_FOREGROUND COLOR_MSG_SORTBODY_BACKGROUND SOS_ID_PK2 ALLOW_BLOCKING_USERS NAME COLOR_LAST_VIEWED_FOREGROUND ALLOW_AUTHOR_REMOVE_IND BREAK_IND CONFMAIN_SOS_ID_PK2 DTMODIFIED LISTING_INCLUDES_HITS TRACKING_WHEN_COLLECTING LISTING_INCLUDES_EMAIL_ANCHOR MESSAGE_WITH_THREADWALKER ALLOW_ADMIN_THREAD_LOCK ADMIN_EQUIVALENT_T SHOW_ADVANCED_CONFIG MAX_ATTACH_COUNT HIDE_FROM_ACCESSLIST_Z_AND_P MAX_ATTACH_AT_ONE_TIME ALLOW_FILE_ATTACHMENT_IND ALLOW_ADMIN_RESPOND_ALWAYS COLOR_MSG_BODY_FOREGROUND ALLOW_NEW_THREADS_IND FORUM_DEFAULTS_FOR_NEW_MSGS ROW_STATUS ANONYMOUS_NAME LISTING_SUBJECT_TRUNC_ADJUST ALLOW_SORT_AND_OR_DISTINCTION
- MSG_MAIN all messages in forum
- Threads calculated based on use of MSGMAIN_PK1 being a pointer to the parent that a message is a reply to and if there are multiples, them being listed in date order
- Fields = DTCREATED SUBJECT POSTED_EMAIL PK1 USERS_SOS_ID_PK2 THREAD_LOCKED MSGMAIN_SOS_ID_PK2 FORUMMAIN_SOS_ID_PK2 PREFORMAT_IND SOS_ID_PK2 ARCHMAIN_PK1 DTMODIFIED BREAK_IND MSGMAIN_PK1 CARTRG_FLAG HIT_COUNT ARCHMAIN_SOS_ID_PK2 FORUMMAIN_PK1 MSG_TEXT POST_AS_ANNON_IND USERS_PK1 ROW_STATUS POSTED_NAME
