Setting Up Flexible Snapshot Processes Based in Rolebased Access Control Cathy Colless & Anthony Leonard
Snapshot Consulting Engagement (first attempt) § System installation 2005 § Standard engagement questions § Consultant asked us to identify an institutional data source for: – Users – Courses – Enrolments § Replied People. DB, SITS
Engagement Outcomes § All three snapshots running § Course ID format: 2004 -T 2 -2020001 -A § Course categories and user institutional roles § 5000 course sites with automated enrolments created and ready for use
Implementation approach. . pilot project bids § 5000 course sites created. Ready to roll ! § Resisted the temptation to walk around campus tossing course sites at passer-bys § Small scale pilot implementation approach (bids) § No enrolment constraints mentioned, approach may have encouraged constraint free proposals § Expected manual sites to be small minority
Diabetes Care Combined modules for diploma and degree level students § Diabetes Care module taught as a combined group of both diploma and degree students § Two separate SITS module codes/credits § Two BB course sites created and built to avoid manually managing enrolments for large cohorts of students § Announcements, discussion boards, blogs all common to the entire group § Less than ideal situation having two sites
Robotic Telescope Any student taking an Astrophysics programme § Control the robotic telescope § Share digital images § All Astrophysics student at all levels use the telescope § Unable automate enrolments
Health Economics PG Dip Café Barista All students in certificate & diploma programmes § Fully distance education § Café site in addition to individual module sites § Tutors not enrolled in Café site § Could not provide automated enrolments based on a programme affiliation
Chemistry college based small group tutorials all undergraduate chemistry students § All undergraduate chemistry students divided into groups based on residential college § All undergraduate chemistry students in one site § Could not provided automatic enrolments for the site § Started using CSV files generated with SQL
Politics – Graduate Submission all postgraduate students in Politics § Politics site managed by Post Graduate Programme Administrator for plagiarism detection purposes only § Individual modules leaders did not use the site § One site used for submission of all Politics post graduate students § Revert to csv files again
Some other general issues § SITS codes and terms change regularly due to scheduling and assessment changes § Example: 2004 -T 2 -2020001 -A changed to 2004 -T 2 -2020001 -B § Mid term changes cause a major crisis § Course is disabled and disappears if a SITS code changes § Cannot “restore” to an existing course
Reality – End of Pilot Status § Thousands of manual & “CSV file” enrolments § Technology/systems driving practice § 40% of Pilot module sites had complex requirements for enrolment criteria § Other 60% represented the less innovative/creative of the bids § Trying to sell what we had in stock instead of what staff actually wanted
Back to the Drawing Board § First attempt relied on intuition § More systematic/evidence based approach for second attempt § Look at solutions from other system addressing similar requirements
Windows Active Directory
Digital Repository - Group Based Access Model
Community System Portal User Institutional Role Module or Tab
Role Based Access Control User List Group Role Permission Privilege Resource
Undocking SITS Module Groups from Course Sites SITS Module 11 BB Course Site SITS Module 2 2 BB Course Site SITS Module 3 3 BB Course Site SITS Module 4 4 BB Course Site SITS Module 5 5 BB Course Site SITS Module 5 T 2
The Separation Process – Implementation Options § Considered a separate database table § Wanted to use BB without customisation § Decided to create special “group users” § This would allow us to use the enrolment tools to manage the association between course and a group user § No need to write a building block or stand alone web application to manage flexible enrolments
Original snapshot process People DB users Blackboard users user snapshot SITS modules (MAV) extra courses course snapshot SITS Admin !! enrollments (SMO) enrollment snapshot VLE Admin extra user enrollments Students Lecturer
New snapshot process People DB Blackboard users user snapshot group users SITS enrollments (SMO) Blackboard group user enrollments a e us modules (MAV) SITS Admin n rs ot h ps } courses enrollment snapshot VLE Admin Students group user enrollments Lecturer
A simple one-to-one case example § Example SITS Module 0280111 -T 1 § What happens: – a module site Y 2007 -000123 is created – a “group user” group. sits. module. 0280111 -t 1 – enrolment of the group user onto the module site Y 2007 -000123 – enrolment of “real” users based on SITS module group user § The initial result of this is the same as hard coding the link between the module site and the SITS module
Example Data Scheme BB Course ID Group Usernames Old 2006 -T 1 -0110178 -A - 2006 -T 2 -0110178 -A 2006 -T 1 -0110103 -A New Y 2007 -0123 Y 2007 -0312 Y 2008 -0123 group. sits. module_0110178 -t 1 -a group. sits. module_0110178 -t 2 -a group. sits. module_0110103 -t 1 -a
Retrieving group user enrolments from the DB Database Tables Select um. user_id, cm. course_id Course_users from Course_main course_users cu, course_main cm, Users um where cu. crsmain_pk 1 = cm. pk 1 and cu. users_pk 1 = um. pk 1 and cu. role = ‘U'
The next step…. Groups based on user attributes § User attributes in People Database § Departmental Association § Level Classification Attribute – First Year – Second Year… – Academic Staff – Support Staff § Potential for other systems in the future
People Group User examples § group. people. dept_0011. atree_01 § All staff in the Biology Department § group. people. dept_0011. atree_09 § All first years in the Biology Department § group. people. dept_0014. atree_01 § All staff in the Chemistry Department § group. thingspeoplelike. food_fishandchips § All people who like fish & chips
Rolling out the new snapshots 07/08 year § Every project from the pilot phase successfully changed to snapshot based enrolments ! § New round of project § Even higher level of proposals with non-traditional enrolment criteria
In Practice – Biology Welcome § All new Biology students § Induction, catch-up and welcome content § Blog § group. people. dept_00 nn. atree_nn
In Practice - Plagiarism Awareness § Pan University course § Small changes to contextualised content by each department § Enrolments important to gradebook § Different enrolments for departments
Sociology PG & Staff Seminar Series § Termly programme of seminars § Enrolment of academic and research staff and PG students
Some conclusions § An inflexible snapshot model stifles creative and innovative use of Blackboard § The system will drive the practice if the system is not flexible § When news spreads that snapshot can provide automated enrolment to meet complex criteria demand for this will quickly grow. § Flexible model avoids the need for two parallel systems
“Don't decide how big to build the bridge by counting the number of people swimming across the big river” Keith Moala - Tonga
Your questions please.
Enrolment Snapshot Script to extract list of Group User enrolments in the BB enrolment table from the Bb database BB Course Group User Enrolment Y 2007 -0001 group. sits. module_0110101 -t 1 -a Y 2007 -0001 group. sits. module_0110103 -t 1 -a Y 2007 -0002 group. sits. module_0120401 -t 2 -a
Creating the Enrolment Snapshot BB Course Group User Y 2007 -0001 group. sits. module_0110101 t 1 -a Y 2007 -0001 group. sits. module_0110103 t 1 -a Y 2007 -0002 group. sits. module_0120401 t 2 -a Script works through the list of group enrolments, looking up the student enrolments from SITS for each module building up a Snapshot file. external_course_key|external_person_key|role Y 2007 -0001|1055|student Y 2007 -0001|1138|student Y 2007 -0002|1139|student
Original snapshot process People. DB SITS Module (MAVS) User Snapshot Course Snapshot Blackboard User Blackboard Course 1. Create course site & 2. SITS Enrolments Blackboard Link BB site to a SITS Course module Enrolment Snapshot Enrolment
Changes to snapshot processes Blackboard User Snapshot People. DB Nothing needed to change SITS Module (MAVS) Course Snapshot Blackboard Course 1. Create course site & 2. Link BB site to a SITS module SITS Enrolments Enrolment Snapshot May need changing later but put aside for now Blackboard Course Enrolment
Decoupling the courses snapshots Users Group oad Blackboard User L SITS Module (MAVS) Blackboard Course Snapshot E r Changencourse ID ol G 1. Create course site to meaninglessroup U identifier unique ser & s (1 instead of SITS module code Blackboard 1) 2. Link BB site to a SITS module Course Enrolment
And finally back to enrolling “real” users Users Group oad Blackboard User L SITS Module (MAVS) Blackboard Course Snapshot Enr ol G rou p. U SITS Enrolments ser Enrol “R s (1 eal” Use list of group user enrolments -1) rs Blackboard Course Enrolment
Snapshots before & after summary User Snapshot People. DB Users roup Blackboard User G Load SITS Module (MAVS) Course Snapshot Enr ol G SITS Enrolments rou p. U ser s Enrolment Snapshot Blackboard Course Enrolment
Скачать презентацию Setting Up Flexible Snapshot Processes Based in Rolebased
3a2edbd3a71e169bde239d288600bafd.ppt