Home
ELBP User Guide - Moodle PLP @ Bedford College
Contents
1. The period field should referto a column that will contain a valid Period as defined in your plugin s settings e g Last 7 Days Last 28 Days Total etc The value field should referto a column that will contain the numeric value most likely a percentage for this particular user course type period Example Bedford College Electronic Leaming Blue Print Administration User Guide MIS Configuration Moodle Database or MIS Should the plugin use the in built Moodle tables to find the data Or should it directly qu Moodle Database MIS To set up the Attendance plugin with MIS your MIS table view must be in the format of id username course type f rows for each combination of period and type MIS Table View Name If this is specified it will override the table view name defined when you created the MIS cc new_view MIS Post Connection Execute Any SQL commands written here will be executed after a connection is establish commands are valid SQL and remember to include semi colons to seperate them Username Do you want to use the moodle username field or the moodle number field to reference a user in th username e Course Do you want to use the moodle course shortname field or the moodle course number field to referenc shortname EN MIS Field Mapping ID The primary id field of the table view Username The field of the table view that contains the st
2. The Comments plugin is used to allow staff members to write comments about the student These could be positive comments such as praising the student for working hard ornegative commentsto do with behaviour attendance quality of work etc To install this plugin choose Core Plugins from the drop down menu then choose Comments from the next drop down then click Install Once it has installed click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font colours to be used in each plugin header bar If forsome reason your browser doesnot support the HTML color input type and the colourscript included doesn t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhex code We can also choose whether ornot the number of comments the student has should be shown when they look at the ELBP block Finally we can set how many of the most recent comments should be shown in the summary of the plugin By default this will be 5 The Settings tab allowsusto define what data will be stored against each comment by setting up Attributes Attributes are done in the same way acrossany plugin which usesthem they are pieces of information you want to be stored against a given record a comment in this case Our defaul
3. bcgt Then next to the install button where it displays the path to the file it is attempting to install from click on that and it should become a text box Change bcgt class php to elbp_ prior leaming classphp and then click Install Then click on Settings and we will setup the Prior Lea ming plugin The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If forsome reason your browser doesnot support the HTML color input type and the colour script included doesn t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhex code There is no other setup required forthis plugin as it is just displaying data from the bcgt block All setup for that isdone through the bcgt block itself Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure itis enabled Then if you view a student s ELBP you should see the PriorLeaming plugin isnow available Prior Quals 5 i Avg GCSE Score 46 00 y GCSE Religious Information Iw BT GCSE English A GCSE Maths B GCSE Science C GCSE Business Studies D a Bedford College Electronic Leaming Blue Print Administration User Guide 59 2 2 4 3 Aspirational Grades The Aspirational Grades plugin isan extemal plugin
4. Day Number field should referto a column containing the number of the day that particular record is for e g where Monday 1 to Sunday 7 or Sunday 0 to Saturday 6 This isso we can orderit by day The Day Name field should referto a column containing the name of the day that particular record is for The Usema me field should referto a column containing data that will match the user s Moodle usemame or Moodle idnumber depending on which you chose in that setting previously The Lesson Name field should referto a column containing the title of the lesson to be displayed The Teaching Staff field should referto a column containing a string of allthe teachers that are relevant for this particular lesson The Course field should referto a column containing data that will match the course s Moodle shortname or Moodle idnumber if you chose to try and link to Moodle courses by one of these fields The Room field should refer to a column containing the name of the room this lesson will be taking place in The Start Time field should referto a column containing the time that this lesson starts This must be in the format 00 00 e g 12 30 The End Time field should referto a column containing the time that this lesson ends This must be in the format 00 00 e g 17 00 The Start Date field should referto a column containing the date that this lesson se
5. Trackchangesevery 7 days Tracking period 60 days Start date 21 09 2014 That would mean that starting on 21 09 2014 every 7 daysit would store ina tracking table what the student s current Attendance data is Then on the ELBP we would be able to look back overthe previous 60 days and see what the Attendance wasat every 7 day interval NOTE The tracking table in the database gets VERY large Example Aj EEE 25 12 2013 83 98 92 100 100 en 200 01 01 2014 0 83 96 2 92 o 0 100 100 o 100 0 08 01 2014 100 100 96 0 92 o 100 100 100 o 100 0 15 01 2014 85 15 88 8 92 0 100 0 100 o 100 0 22 01 2014 100 15 87 1 91 F 100 0 100 o 100 0 Bedford College Electronic Leaming Blue Print Administration User Guide 24 Lastly we have the Profile Summary section If you have the Student Profile plugin installed and enabled this will allow us to display a summary of the Attendance data in the Student Profile To do so simply choose which period you would like to be displayed foreach Type We generally recommend having a Total or Overall period forjust such an occasion The MIS tab letsusconnectto an extemal data source to bring in the Attendance data ratherthan using the Moodle database to store it If you don t want to use an MISconnection you can skip thisbit To setup the plugin to use an MIS connection firstly you will need to go back to the main Configuration page and create an MISconnection
6. t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhex code The Settings tab lets us define what possible Challenges the students can choose from by giving them a name and an icon By default these challenges will be Alcohol Substance Abuse Child Adult Care Communication Skills Computer Skills Cultural Issues Disability English Skills Exam Anxiety Family Life Finances Grief Loss Health Housing Shelter Legal Issues Motivation Relationship Problems Stress Time Management Transportation Unclear Goals Career Choices You can assign icons to them by supplying an image URL as well Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure itis enabled Then if you view a student s ELBP you should see the Challenges plugin isnow available Bedford College Electronic Leaming Blue Print Administration User Guide 41 TEST STUDENT Student Details 88888888 Full Name Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88888888 localhost Icl Attendance 92 Punctuality 93 Q Your Challenges Full Alcohol Substance Abuse Tue 25th Mar 2014 Name Exam Anxiety Tue 25th Mar 2014 Daffy Finances Tue 25th Mar 2014 Duck I Reaister Ria 2 1 11 Leaming Styles The Lea ming Styles plugin allows the student to take a short questionnaire which will then calc
7. The Register plugin is used to display a student s register information so that both the student and staff can see which lessons the student was present absent etc for To install this plugin choose Core Plugins from the drop down menu then choose Register from the next drop down then click Install Once it has installed click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If for some reason your browser does not support the HIML color input type and the colour script included doesn t work for your browser you Bedford College Electronic Leaming Blue Print Administration User Guide 33 will see just a blank input box forthese colouroptions in which case you will need to entera colourhexcode The Settings tab allowsusto define the start and end ofouracademic year so that we can displa y the weeks correctly Forexample your academic year might start on 01 09 2014 which you would want to be displayed as Week 1 So for Start Date Week you would set the date to 01 09 2014 and the week numberto 1 And do the same forthe end of the academic year Next we have the Value Settings section where we can define codesand what they mean on the register For exa mple your institution might use the fol
8. cshort Course IDNumber cidnum SELECT id username firstname lastname email institution FROM user WHERE id uid Row Type Will the query return a single row or multiple rows to loop through Single Row Multiple Rows Add Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the quer username User Name Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the quer firstname Firstname Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the quer lastname Surname Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the quer email Email Address Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the quer institution Student or Staff Becomes Bedford College Electronic Leaming Blue Print Administration User Guide 48 Your Things User Name 88888888 Firstname Test Surname Student Email Address 88888888 localhost Icl Student or Staff Student 2 1 12 5 Extemal DB Report To use an Extemal DB report first you will need to go back to the MIS tab of the main configuration and create a new MISconnection unless you already have one you want to use and assign it to the Custom Plugin Now the Settings tab of the Extemal DB Report will allow you to setu
9. unless you have already created one you wish to use then assign it to the Attendance amp Punctuality plugin Now retum to the MIStab on the Attendance amp Punctuality setthgsand change the tick box from Moodle Database to MIS and save the change Then you should see various extra settings for the MIS connection In orderto use the MIS option instead of the Moodle database your table view that we will be querying must be in the format of id usemame course type period value though the column namescan be different if you want that is what they must contain So there must be a new row foreach combination of Type and Period fora student Example LORIS faon ER 19 0 10 SELECT FROM test new_view order by pcode Filter AY Fie 8 Autosize D pcode course type period value p 271040 LETEST Punctuality Total 3 271040 LETEST Punctuality Last 28 Days 2 271040 LETEST Punctuality Last 7 Das 1 271040 LETEST Attendance Total 44 271040 LETEST Attendance Last 28 Days 55 271040 LETEST Attendance Last7Days 66 271040 as Punctuality Total 12 271040 A Punctuality Last 28 Days 11 271040 as Punctuality Last 7 Days 10 2710490 MM Attendance Total 90 271040 UM Attendance Last 28 Days 80 271040 UM Attendance Last 7 Days 70 Where the course is NULL denotes the overall data forthat student not specific to an individual course Bedford College Electronic Leaming Blue Print Administration User Guide 25 In
10. a test MIS query at the bottom of the page to see if it is retuming the data you think it should be The Data tab allows usto import Registerdata directly into our Moodle database using a CSV spreadsheet You can download an example csv and a template csv to fill out with data to be imported You can also choose what to do should the import script come across any users or courses that don t actually exist in Moodle Bedford College Electronic Leaming Blue Print Administration User Guide 35 You could use thisto manually import Registerdata every day week etc but if possible the best thing to do if you want to use the Moodle database would be to setup a cron using the Crons tab To setup a cron first choose to enable it Then choose when you want the cron to run You can choose eithera specific time orto run Every Forexample if you choose Timing Specific Time Hour 05 Minute 30 Then the cron will run at 05 30 every day If you choose Timing Every Hour 01 Minute 15 Then the cron will run every 1 hourand 15 minutes Lastly all you have to do isspecify where on yourserverthe CSV file will be located to processand import The cron will use the exact same script to import the data asisrun when you run the import manually from the Data tab So the best thing to do isto test it first using the Data tab to ensure that your CSV is in the correct format and working and t
11. any student s ELBP by pressing Ctrl Shift You can then type help fora list of available commands 4 4 Clearthe Popup Window You can clearthe popup window and transparent overlay on any student s ELBP by pressing Ctrl Shift Enter 5 Data Import Specifications Some plugins allow you to import data with CSV files and setup cronsto automatically import the data Fields must be enclosed in double quotes and separated with commas If you are creating the CSV in Microsoft Excel ora similar program this will almost certainly be done automatically however if you are using a script to generate the CSV file manually you will need to ensure that this is done E g col1 col2 col3 etc If a field is Optional the column must still exist in the CSV it just means it doesn t need to have any data in it Note Data Import is notthe same as an MIS connection 5 1 Atiendance Required Optional Ecample Notes Alphanumeric Required 123456 This must matc h eithera usemame or idnumber of a user depending on Bedford College Electronic Leaming Blue Print Administration User Guide 64 choose in yourdata settings type Alphanumeric Required Attendance Thismust match one of the Types as defined in your Attendance settings period Alphanumenc Required Last 7 Days Thismust match one of the Periods as defined in your Attendance settings courseshortname Alp
12. can and cannot see that field For more information on Confidentiality levels hover over the little help icon Here you can also choose whetherornotthe profile can be edited as you may just wantto use it to display data ratherthan have itchanged by anyone The MIS tab allows usto choose whether or not this plugin uses the Moodle database orif it drawsdata out of an extemal database most probably your MIS SIS system If you want to use the Moodle database you do not have to do anything on this tab you Can ignore it If you do want to draw data out of another system the first thing you will need to do isto go back to the ELBP Configuration page go to the MIStab and create a new MIS connection unless you have already created one you want to use and assign it to the StudentProfile plugin Once you have assigned a valid MISconnection to the StudentProfile plugin come backto the MIS settings and changed Moodle Database to MIS and save the settings this will then load up additional MISsettingsso that we can map our Plugin to the MISdata We should now see the next setting is MIS Table View Name here we need to define the name of the table or view we are going to be querying Next we can define any SQLwe want to be executed after connecting for example setting a particular charset if you need to This is optional Next we need to choose how we are going to be looking up data when we load up a student s ELB
13. custom attribute field dob DATE_FORMAT dob d m Y nicedob Bedford College Electronic Leaming Blue Print Administration User Guide 18 Now let s save those settingsand run our MIStest again and see what results we get Anon Object Full Name gt Daffy Duck Address gt 789 Some Road Some Place Some County ABI 2CD Date of Birth gt 13 01 1926 So youcan see now we have the Date of Birth in a different format So if I now went to the ELBP of a user with the usema me of dduck this is the data it would retrieve from the MIS system Also on this page we have an MIS Contact section If we are allowing students to edit their profiles but we are also using an MISconnection we do not reallywant them to be able to directly UPDATE the MIS database asthis ma y cause problems So instead what we can do is specify a userto be emailed with the details whenever a student updatestheir profile information so they can then amend the MIS database Once you have finished setting up the Student Profile and made sure it isenabled you should be able to see it has appeared on the ELBP when you view a student Home gt elLP Test Student 88888888 Switch User TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88888888 localhost icl Bedford College Electronic Leaming Blue Print Administration
14. in each plugin header bar If for some reason your browser doesnot support the HIML Bedford College Electronic Leaming Blue Print Administration User Guide 30 color input type and the colour script included doesn t work for your browser you will see just a blank input box forthese colouroptions in which case you will need to entera colourhex code Next in the Attachments Configuration section we can choose what document typeswe want to allow to be uploaded By default none of these will be selected so you will need to choose some You can also specify others if the type you are looking for isn t listed anywhere but it must be a valid MIME type The Max File Size setting cannot be edited it just uses the web server s setting Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the Attachments plugin is now available TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88888838 localhost icl SUMMARY Attendance 92 Punctuality 93 eILP A Your File Attachments e ae G Y Punctuality 93 Last Five Attachments COURSE A P mM Test File No attendance punctuality records found Bedford College Electronic Leaming Blue Print Administration User Guide 31 2 1 6 Comments
15. ones such ascoursepicker and userpicker If yourtype requires options e g a select menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any Next we can edit the Review Questions and their possible values These area series of options the staff member will be able to fill out when creating the report to summarise how the student is doing in those various areas Next we can put in some instructions for staff to see when creating a new Course Report And finally we can hook data into ourcourse reports from other plugins if it is supported The supported hooks for Course Reports are currently Attendance This will bring through the student s Attendance data for that course Grade Tracker If you have the Bedford College Gradetracker block installed you can bring through Unit information Target Gradesand Final Gradesinto the Course Report The Periodical tab allows usto setup Periodical Reports We can enable disable it and also choose which data to hook into the Periodical Reports Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure itisenabled Then if you view a student s ELBP you should see the Course Reports plugin is now available Bedford College Electronic Leaming Blue Print Administration User Guide 38 Po a SN A Ger Your Course Reports
16. specified it will override the table view name defined when you created the MIS connection an people MIS Post Connection Execute Any SQL commands written here will be executed after a connection is established This may commands are valid SQL and remember to include semi colons to seperate them E Date Format The format that any date fields will be in Examples 19 12 1987 d m Y 12 19 1987 m d Y 19 DEC 1987 d M Username Do you want to use the moodle username field or the moodle idnumber field to reference a user in the external d MIS Field Mapping ID The primary id field of the table view lid Field Function Alias Username The field of the table view that contains the student username idnumber username Field Function Alias Full Name The field of the table view that refers to this custom attribute field name Field Function gt as Address The field of the table view that refers to this custom attribute field addr Field Function gt las Date of Birth The field ofthe table view that refers to this custom attribute field dob Field Function Alias Bedford College Electronic Leaming Blue Print Administration User Guide 17 Then I would save these settingsand run an MIStest atthe bottom ofthe page If I were to then enter dduck as my usema me in the MIStes
17. student set how confident they are at achieving the targets set forthem as well asthe score maximum by default this is 1 5 Then various other Bedford College Electronic Leaming Blue Print Administration User Guide 39 settings such as should the Targets lock for editing after the deadline has passed Should the Targets be deleted if the session isdeleted And do you wanta boxto be able to email the session details to other interested parties such asthe students Personal Tutor Teaching Staff etc The Settings tab allows usto define form fields so store whatever data we want against the Session by creating Attributes Attributes are done in the same way across any plugin which uses them they are pieces of information you want to be stored against a given record a Support Session in thiscase You can select the type of attribute which accepts most common HTML fom elements as well asa few custom onessuch ascoursepicker and userpicker If yourtype requires options e g a select menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any We can also hook data into our Support Sessions from other plugins if it issupported such asAttendance data Targets etc If you want the Support Session to be able to have Targets created forit and assigned to it you will need to hook in Targets Once you have finished s
18. the bcgt block All setup for that isdone through the bcgt block itself Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure itis enabled Then if you view a student s ELBP you should see the Assessment Calendar plugin is now available Assessment Calendar x O J My Assessment Calendar Active Assessments Assessment Due Date No results found Bedford College Electronic Leaming Blue Print Administration User Guide 61 3 Known Issues Due to the complexity of the system especially in connecting to various different database engines there are some issues which we are aware of which you may or may not come across 3 1 Querying SQL Server MIS connection from a Linux server If your Moodle server is running on Linux and you are connecting an MIS database which is running on SQL Server you may find issues with some queries not working possibly giving you fatal errors For example if you use the BKSB or BKSB Live plugins which have SQL Server queries built into them This will most likely be due to how your Linux server is trying to connect to the Windows server We recommend using the php_odbc driver with the Free IDS library as this configuration hashad the least amount of problemsin ourtesting though it isby no means brilliant and if you find a better solution by all means let us know If you have created a custom Extemal DB plugin you may also find that test q
19. which comeswith the Bedford College Grade Tracker block It can be used to assign Target Aspirational grades to student s qualifications and courses through the ELBP To install this plugin select Extemal Plugin from the drop down menu then block then bcgt Then next to the install button where it displays the path to the file it is attempting to install from click on that and it should become a text box Change bcat class php to elbp_target grades class php and then click Install Then click on Settings and we will setup the Prior Lea ming plugin The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin headerbar If forsome reason your browser doesnot support the HTML color input type and the colour script included doesn t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhexcode There is no other setup required forthis plugin as it is just displaying data from the bcgt block All setup for that is done through the bcgt block itself Once you have finished setting up your Plugin you will need to add itto a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the Aspirational Grades plugin is now available Aspirational Grades m My Aspirat
20. Bedford College Electronic Leaming Blue Print Administration User Guide DFO XAO 3 aw y OLLES Electronic Leaming Blue Print Administration User Guide Conn Warwicker cwarwicke edford ac uk moodlesupportabedford ac uk Bedford College Electronic Leaming Blue Print Administration User Guide 1 Contents LL Installati n GU AAPP o 3 TL un e ENEE E LA es Bereet E 1 3 Installing the Block S EE 5 li Silla 6 TAL MAN Configura ON eessen ege Eege EE Eeer 7 1 4 2 Eine 8 1 4 3 Settings CONTO UN ssp e 8 144 Mee e ion ni e N E A 10 14 5 A roo EEE E EP AA a naaa iean 11 L46 Alea 11 Semesteren A A 12 2 Instaling Managing WEE Un GE 14 2 ee Un EE 14 2 1 1 e Ee ee EE 14 ee en Ke O E L E 19 2 13 TO A pei 21 2 1 4 ARSNdANES soia le loin a 22 215 Acea 29 21 0 COMME ti A ER AE a AEE REE Aa 31 KAN e GE lait 32 2 1 8 Course Te E 36 2 1 9 Additional SUP PO Esc ae 38 2110 e le 40 SE lesione 41 2 1 12 Custom PUIG UNS O PPP Po PO nannan annn nennen 43 2425 A e o o A 50 Za BB iaa 50 222 BKSB Live lla 51 224 WN econo 51 224 Grade Wa E 57 3 KNOWN lees 61 Bedford College Electronic Leaming Blue Print Administration User Guide 2 3 1 Querying SQLServer MIS connection from a LINUX eener 61 3 2 Moodle Text Editors AttribUtes iii 61 CC Ee e tele EE 62 4 Ipsand Meks ar rele lai 62 Dee et EE 62 4 Z Centre the E EE 62 4 3 Command Dn 63 4 4 Ale arthe Popup le Leet 63 5 Data I
21. E Most Recent Periodical Course Reports Name Date No results found Most Recent Course Reports Course Last Course Report No reports found a 2 1 9 Additional Support The Additional Support plugin is similarto the Tutorials plugin and allows sta ff members assigned to a student as Additional Support Tutors to record support sessions they have with the student in the same way the Personal Tutor records Tutorial sessions To install this plugin choose Core Plugins from the drop down menu then choose Additional Support from the next drop down then click Install Once it has installed click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If forsome reason your browser doesnot support the HTML color input type and the colourscript included doesn t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhex code Next we have the Additional Support Configuration section where we can set any instructionswe want to be displayed to the staff memberwhen creating a new support session Then we can set the numberof most recent sessions to be displayed in the summary box by default this is 5 Then we can enable disable Confidence levels which lets the
22. MPOR Led ER de EE 63 5g Attendalite m iatale ee 63 e REGIS EE 64 53a O IG erence A lh eet ete deal n 65 e UCERO A a a a n a a a a a a 66 Bedford College Electronic Leaming Blue Print Administration User Guide 3 1 Installation Guide The following instructions are aimed at the Moodle administrators who will be installing the ELBP block and the other blocks that come packaged with it Dashboard BKSB and Timetable LL System Requirements Moodle Version sid Version 2 4 2 5 2 6 2 7 Moodle Database MySQL SQL Server PostgreSQL PHP Version 5 3 2 PHP Extensions fileinfo Settings Modules mod_rewrite enabled php short tags enabled jQuery Version 1 9 1 jQuery Ul Version 1 10 3 In addition to these requirements if you wish to make connections to extemal databases MIS connections you will need to ensure your server hasthe required extensions to do so Once you have installed the block you will see a list on the MIS settings page of the extensions you will need for various different database connections If you are using Moodle 2 4 please refer to this Forum Topic 1 2 The Blocks There are 4 blocks which come with the ELBP system though you do not have to use all of them if you don t wish to but some of them do rely on the code base of others to function ELBP This is the core ELBP block which holds all the functionality to use the ELBP Bedford College Electronic Leaming Blue Print Administrati
23. Moodle database to store your Timetable information you can skip the MIS tab and move onto the Data tab If you do want to use an extemal database you can skip the Data and Crons tabsand go to the MIS tab The MIS tab lets you setup the Timetable to draw in data from an extemal database To do this the first thing you will need to do is retum to the MIS tab of the main configuration and create a new MISconnection unless you already have done so and link it up to the Timetable plugin Now if you retum to the MIS tab in the Timetable settings and change the tickbox from Moodle Database to MIS and save the change now we should see some extra MIS settings So to setup the MIS connection first we need to enter the name of the table or view what we will be querying Then optionally any SQL you need to be executed afterthe connection isestablished Next we need to choose which day numbering system our extemal database is using 0 6 Sun Sat or 1 7 Mon Fri Next we need to choose how we are going to find a user in the table view will it be by their Moodle usemame or their Moodle idnumber field Bedford College Electronic Leaming Blue Print Administration User Guide 53 Then we move onto the MIS Field Mappings where we define what columnsin the extemal database we need to retum The ID field should referto a unique id column this is optional but helpful The
24. P Are we going to be looking for their usemame or their idnumber Next we have the MIS Field Mapping section where we can map ourfields to those fields columns in our extemal data source Firstly we have ID this should contain a unique ID field in the defined table view I a Then we have Usemame this should contain either the student s usemame or idnumber asdefined in previous setting Then we have a mapping foreach of the Profile Fields we set up For this example have used the Profile Fields Full Name Address and Date of Birth Bedford College Electronic Leaming Blue Print Administration User Guide 16 So forthe sake of example let us assume am connecting to another MySQL database that stores our MIS information And the table want to query is this name email usemame dob country addr id p 6 Conn Warwicker cwarwicker bedford ac uk cwarwicker 1987 12 19 GB 123 Some Road Some Place Some County AB1 2CD ri Mark Chaney mchaney bedford ac uk mchaney 1986 07 26 GB 456 Some Road Some Place Some County AB1 2CD 8 Daffy Duck dduck looney net dduck 1926 01 13 US 789 Some Road Some Place Some County AB1 2CD The settings would put into thispage would be MIS Configuration Moodle Database or MIS Should the plugin use the in built Moodle tables to find the data Or should it directly query your MIS Moodle Database MIS MIS Table View Name If this is
25. Tutorial related requirements which will count towardsthe students overall progress Then click on Settings and we will setup the Grade Tracker plugin The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If for some reason your browser doesnot support the HTML color input type and the colourscript included doesn t work for your browser you will see just a blank input box forthese colour options in which case you will need to entera colour hex code There is no other setup required forthis plugin asit is just displaying data from the bcgt block All setup for that is done through the bcgt block itself Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the Grade Tracker plugin is now available om i My Tracking Sheets we BTEC Level 3 Certificate Art and Design Interactive Media mm lore TUE 09 00 Bedford College Electronic Leaming Blue Print Administration User Guide 58 2 2 4 2 Prior Leaming The Prior Leaming plugin isan extemal plugin which comes with the Bedford College Grade Tracker block It can be used to display a student s qualifications on entry To install this plugin select Extemal Plugin from the drop down menu then block then
26. User Guide 19 2 1 2 Targets The Targets plugin is used so that students can have individual targets set forthem to achieve To install this plugin choose Core Plugins from the drop down menu then choose Targets from the next drop down then click Install Once it has installed click Settings forthe Targets plugin and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font colours to be used in each plugin header bar If forsome reason your browser doesnot support the HTML color input type and the colourscript included doesn t work for your browser you will see just a blank input box forthese colour options in which case you will need to entera colourhex code Next we also have the Student Progress configuration if you have enabled the Student Progress Bar in the main ELBP configuration This lets you define any Target related requirements which will count towards the students overall progress Next we can choose whether or not to display a progressbarof Targets for the student when they look at the block to see how many targets they have achieved Next we have the settings Progress Achieved Automation and Achieved Progress Automation Basically this means that if a target is set to 100 progress do you want it to automatically be set to achieved And visa versa And lastl
27. _rewrite on your server asthe block makes use of fancy uns e 9 blocks bc_dashboard report 1 view Bedford College Electronic Leaming Blue Print Administration User Guide 6 1 4 Setup The first thing you will want to do once the block is installed isto create some new system roles We will need 2 new roles one for Personal Tutors and one for Additional Support Tutors The Personal Tutors role will be used to assign sta ff members to individual students in a mentor mentee relationship The Additional Support Tutor role will be used forthe same reason but to assign students who need additional support If your institution does not require either of these you can skip this part To create the new rolesgo to your Moodle Administration Settings block gt Site Administration gt Users gt Permissions gt Define Roles SETTINGS gt My profile settings v Site administration e Notifications Registration Advanced features v Users Accounts Y Permissions User policies Site administrators Define roles Duplicate the editingteacher role twice and we will use those as our Personal Tutor and Additional Support Tutor roles Set the context types where this role may be assigned to User Role archetype ARCHETYPE Teacher editing EN Context types where this System role may be assigned lv User Category Course Activity module Block Bedford College Electronic Leaming Blue Print Administration Us
28. also allows you to create your own custom reports bringing in pretty much any data from the ELBP and its various plugins This block isnot required but it isrecommended fora better ELBP experience This block does not require the ELBP block in order to function however without it there will be very little itcan do Bedford College Electronic Leaming Blue Print Administration User Guide 1 3 Installing the Block s Once you have ensured that your server meets the system requirements outlined above unzip the zip file and upload these the folders you wish to use to your blocky directory For the sake of this explanation we will assume you are using all 4 blocks supplied with the ELBP Once the folders have been uploaded go to your Administration Settings block on your Moodle site and click on Notifications in orderto run the install of the blocks If you experience any problems installing the blocks please contact moodlesupport bedford ac uk and we will try our best to assist you Once the blocks have successfully installed tum editing on and add the ELBP block to the course Generally we recommend having one instance of the block on the front page but if you preferto have the block on individual courses that is fine Asa site administrator you should have a Configuration link on the block s menu which we will use shortly to setup the ELBP If you install the bc_dashboard block you will need to enable mod
29. at will match the users Moodle usema me or Moodle idnumber depending on which you chose in that setting previously The Day Name field should referto a column containing the name of the day that particular record is for The Day Number field should referto a column containing the number of the day that particular record is for e g where Monday 1 to Sunday 7 orMonday 0 to Sunday 6 This isso we can orderit by day The Course field should referto a column containing data that will match the course s Moodle shortname or Moodle idnumber depending on which you chose in that setting previously The Description field should refer to a column containing a description of the event lesson etc This will probably be the title of the course whereasthe course field isa code The Start Time field should referto a column containing the start time of that particular event This should be in the format 00 00 e g 12 30 The End Time field should referto a column containing the end time of that particular event This should be in the format 00 00 e g 13 30 The Week field should referto a column containing the week number of that particular record The Value field should refer to a column containing the value the student has for that particular record This should match one of the Values you previously set such as A ap etc Once you have saved these changes we can run
30. ate of Birth 16 09 1990 88888888 localhost ici eILP O Your Personal Targets gt One to One Tutorials d Most Recent Tutorials 0 0 0 0 No tutorials found 2 1 4 Attendance The Attendance plugin is used to display the students Attendance Punctuality etc so that they and any of their tutorscan see it To install this plugin choose Core Plugins from the drop down menu then choose Attendance from the next drop down then click Install Once it has installed click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If for some reason your browser doesnot support the HTML color input type and the colour script included doesn t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhex code Next we also have the Student Progress configuration if you have enabled the Student Progress Bar in the main ELBP configuration This lets you define any Attendance related requirements which will count towards the students overall progress Bedford College Electronic Leaming Blue Print Administration User Guide 23 The Settings tab allows usto customise how our Attendance plugin will work what types of data it will store e g Attendance Punct
31. d on theirown blocks so that they can be installed into your ELBP system 2 2 1 BKSB The BKSB plugin isan extemal plugin that comesin itsown elbp_bksb block which allows staff and students to view BKSB results through Moodle also allows students to complete BKSB a ssessments embedded within Moodle without having to login to the extemal BKSB portal This plugin is written by Bedford College and isnot endorsed or supported by BKSB themselves To install this plugin choose Extemal Plugin from the drop down menu then select Block and then elbp_bksb and click Install The first thing we need to do now is setup the MISconnection to our BKSB server As farasl know BKSB only supports being run on Microsoft SQL Server so the BKSB plugin ishard coded to use an SQL Server database To setup the MISconnection go to the MIS tab of the main configuration and follow the instructions then link the MISconnection to the BKSB plugin at the bottom of that page Once you have setup and linked your MISconnection click on Settings and we will setup the BKSB plugin The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If for some reason your browser does not support the HTML color input type and the colourscript included doesn t work for your browser you will see just a blan
32. ecified it will override the table view name defined when you created the MIS connection and use this instead tt MIS Post Connection Execute Any SQL commands written here will be executed after a connection is established This maybe something like setting the default character set Please ensure the co remember to include semi colons to seperate them Day Number Format The format in which the day numbers will be in 1 Monday 7 Sunday w Username Do you want to use the moodle username field or the moodle number field to reference a user in the external database username e MIS Field Mapping ID The primary id field of the table view id Field Function Alas Day Number The field of the table view that contains the number value of the day e g 1 Monday 2 Tuesday etc dsynum Field Function Alas Day Name The field of the table view that contains the string value of the day e g Monday Tuesday etc dayname Field Function Alias Username The field of the table view that contains the student username idnumber poode Field Function Allas Lesson Name The field of the table view that contains the name or description of the lesson lesson Field Function Alias Teaching Staff The field of the table view that contains the name or names of teaching staff on this lesson staff Field Function Alias Course The field of the table view that contains the course code that is reflected in the moodle course eit
33. ecturers if you are using either or both don t need to be added to their roles the role just needs to be created so that we have a specific role to attach students to them with Now if you browse your list of students we highly recommend using the Bedford College Dashboard block to integrate with the ELBP in this case you can view the ELBP of a student which should look something like this once you have some plugins installed r E PA too Lyra Delecque l ira Ee K eg sio inown as Lyra Stvertongoe is the heroine of Philp Pubert His Dark Materiais triogy Lyra e a t o Bedford College Electronic Leaming Blue Print Administration User Guide 13 There are various other settings and configuration options you can play with such as hooking data from one plugin into another e g hooking Targets into Tutorials so that you can assign targetsto tutorials hooking attendance data into Tutorials or Course Reports etc If you have any further questions on setup oruse orthe ELBP or any problems please contact either moodlesupport bedford ac ukorcwarwicker bedford ac uk Bedford College Electronic Leaming Blue Print Administration User Guide 14 2 Installing Managing Plugins This section will go into more detail regarding each individual plugin and how to set it up Most of them should be very similarand easy to do 2 1 Core Plugins 2 1 1 Student Profile The Student Profile plugin sits at the top of the ELBP and displays inf
34. elect menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any Forexample here you may want to add another attribute to store any Student comments so they can record what they think about the target So you would add a new Attribute of type Textbox and call it Student Comments In the Targets plugin we also have the Target Hover setting which lets us define which of our attributes is our main target content so that we can display it in tooltips from other plugins By default this will be the Target attribute And finally we have Target Instructions which is displayed at the top of the New Target form as instructions for creating a new Target Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the Targets plugin is now available TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88883888 localhost Icl eILP Your Personal Targets 0 e 8 Bedford College Electronic Leaming Blue Print Administration User Guide 21 2 1 3 Tutorials The Tutorials plugin is used so that Personal Tutors can set Tutorial records fora student recording what was discussed any targe
35. ensure that the Query and jQuery UI in yourtheme matchesthe required versions otherwise you may find that certain aspects of the system do not work asexpected Next is the alerts configuration This allows us to enable or disable email alerts within the ELBP system If they are enabled staff will be able to set up customised alerts which they want to receive forexample they may want an alert when Student X misses a target deadline or when any student on Course Y hastheir attendance drop below 90 Lastly we have the Student Progress Bar configuration where you can enable disable the Student Progress Bar which isa progress bar atthe top of each student s ELBP which displays their overall progress based on what requirements you have defined these are defined in the plugins themselves These requirements can be set in the Main tab of any Plugins which support it Each requirement also lets you set an importance score so that you can set different requirements to be worth more in the percentage calculation than others Bedford College Electronic Leaming Blue Print Administration User Guide 1 4 2 Environment The Environment page will show you some details about your Moodle server and your installation of the ELBP block The first section PHP Extensions will list any additional PHP extensions which are required by any of the plugins you have installed and whether or not you have them installed on your server Main Environ
36. er Guide 7 Give them their new na mes and adjust any pemissions that you would like adjusted Now we are ready to move onto the actual ELBP setup If you go to your ELBP block you should see a Configuration link at the bottom if you are a ste admin Click that and it will take you through to the Configuration settings Here you should see there are 5 tabs along the top Main Environment Settings MIS and Plugins 1 4 1 Main Configuration These settings allow you to customise the main settings of the block such as its display name as some institutions may have been using blocks previously called Personal Leaming Plan or Individual Leaming Plan etc so they may wish to rename this block to avoid confusion amongst their staff and students The next setting allows you to tum gradients on or off this is just a minor styling choice on the ELBP Without gradients will just use solid colours Next we have jQuery configuration The ELBP system requires jQuery and jQuery UI to function as mentioned in system requirements By default the required versions come with the ELBP blockand will be loaded up whenever they are required however it is possible that you may be using a theme which includes its own jQuery in which case this could lead to conflictsand cause it not to work So if yourtheme does include jQuery you can tick this setting so that the ELBP doesnot load up its own jQuery files You will however need to
37. etting up your Plugin you will need to add it to a Plugin Group and ensure it isenabled The student will have to have at least 1 staff member assigned to them via the Additional Support Tutor otherwise it will simply say that they are not assigned for Additional Support Thiscan be done through the dashboard by following the My Students link on the ELBP block TEST STUDENT Student Details 88888888 Full Name Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88888888 localhost cl Attendance 92 Punctuality 93 Additional Support n One to One Support Most Recent Additional Support Sessions No results found Name No res Bedford College Electronic Leaming Blue Print Administration User Guide 40 2 1 10 Challenges The Challenges plugin allows the student to highlight areas that they feel may impact upon theiracademic success such as Home Life Finances Health etc To install this plugin choose Core Plugins from the drop down menu then choose Challenges from the next drop down then click Install Once it has installed click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to Change its display title and to change itsbackground and font coloursto be used in each plugin header bar If forsome reason your browser doesnot support the HTML color input type and the colour script included doesn
38. g differences 2 2 3 Timetable The Timetable plugin isan extemal plugin that comesin itsown elbp_timetable block which allows staff and studentsto the student s timetable in daily weekly monthly and yearly views Bedford College Electronic Leaming Blue Print Administration User Guide 52 To install this plugin choose Extemal Plugin from the drop down menu then select Block and then elbp_timetable and click Install Then click Settings and we will setup the Timetable plugin The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If forsome reason your browser doesnot support the HTML color input type and the colourscript included doesn t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhex code The next setting allows usto set whether or not we want courses brought back by the Timetable to try and link to Moodle courses and if so by which field Next we have the Time Settings section where we can define what hourthe Timetable should start and end and how many minutes should it be broken down by Next we have the Colour Settings where we can choose the default colours for each day on the Timetable users can change these individually as well If you want to use the
39. hanumeric Optional X101_14 If set this must match either the shortname or idnumber of a course depending on which field you choose in yourdata settings If blank the record will assume thisisan Overall record value Integer This isthe value you are setting Field Required Optional Example Notes usemame Required 123456 This must match eithera usemame or idnumber ofa user depending on which field you choose in yourdata settings courseshoriname Alphanumeric Optional X101_14 If set this must match either the shortname or idnumber of a course depending on which field you choose in yourdata settings If left blank the Register record will not be linked to a Moodle Course eventc ode Alphanumenc Required ABC 123 This is a unique code for this register event this lesson on this day at this time Bedford College Electronic Leaming Blue Print Administration User Guide 65 Thiswill probably come from your extemal Timetabling stem of the event of the da daynumber Integer 1 Required 3 This is the number of the day E g where Monday 1 Tuesday 2 etc This is used for ordering the Register events startime hhmm Integer 4 Required 0900 This is the 24 hour sta rts endtime hhmm Integer 4 Required 1230 This is the 24 hour ends 13 weeknumber Integer 1 2 Required This is the week number asdefined in your Register settings
40. he Data tab allows you to import Timetable data manually into your database using a CSV spreadsheet example and template available on this page You can also choose what the script should do if it comesacross any users or courses that do not exist in your Moodle system Whilst you can just use this to manually import data asand when you need to the best thing to do would be to setup a Cron to run automatically to import the data To setup a cron first choose to enable it Then choose when you want the cron to run Youcan choose eithera specific time orto run Every Forexample if you choose Timing Specific Time Hour 05 Minute 30 Then the cron will run at 05 30 every day If you choose Timing Every Hour 01 Minute 15 Then the cron will run every 1 hourand 15 minutes Lastly all you have to do isspecify where on yourserverthe CSV file will be located to processand import The cron will use the exact same script to import the data asisrun when you run the import manually from the Data tab So the best thing to do isto test it first using the Data tab to ensure that your CSV is in the correct format and working and then set it up asa cron Bedford College Electronic Leaming Blue Print Administration User Guide 56 If the cron attemptsto run but cannot find the file specified it will fail Best practice would be to have the CSV automatically generated and placed in that locati
41. hen set it up asa cron If the cron attempts to run but cannot find the file specified it will fail Best practice would be to have the CSV automatically generated and placed in that location every night or every whatever period you want it to run Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure itisenabled Then if you view a student s ELBP you should see the Register plugin is now available Bedford College Electronic Leaming Blue Print Administration User Guide 36 TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88888888 localhost ici SUMMARY Attendance 92 Punctuality 93 eILP ese BA K Your Registers CR Comments a i Monday Most Recent Comments Unit 14 Fitness Training Tue 25th Mar 2014 Academic Performance Tuesday English Functional Skills Attendance 92 Pimofisalh 02 6 Your Personal Targets s N 2 1 8 Course Reports The Course Reports plugin allowsteaching staff to create reportsasan overview of how the student is performing on their course They can also create periodical reports e g termly and combine individual reports into one large report To install this plugin choose Core Plugins from the drop down menu then choose CourseReports from the next drop down then click Install Once
42. her Personal Tutor Additional Support Lecturerand ELBP Admin If you followed the instructions up to this point you will already know about the Personal Tutor and Additional Support roles so if you want to use them you can enter in their shortna mes here There are also 2 more roles which we didn t mention before asdepending on how you setup and use your Moodle site they may not be relevant to you but theirdescriptions are below The Front Page Teacher role is used so that staff memberscan be assigned that role on the front page course so thatthe ELBP system can correctly work out permissions if you place the block on the front page If you place the block on individual courses instea d this role probably won t be necessary Users should be assigned this role on the front page course The Personal Tutor role is what will be used when staff members assign individual students to themselvesas Mentees Users should be assigned this role on the front page course The Additional Support Lecturer role isidenticalto the Personal Tutor role except it is used to assign studentsas Additional Support Mentees or whatever you wish to call them Users should be assigned this role on the front page course The ELBP Admin role isused foranyone who wantsto have system wide permissions to view edit any student s ELBP without having to be their course teacheror personal tutor e g Course Area Managers Anyone with this role will also be able t
43. her by shortname idnumber or fullname this setting can be changed in the main settings code Field Function Allas Room The field of the table view that contains the room the lesson takes place in room Field Function Allas Start Time The field of the table view that contains a string time value of the start time of the lesson This MUST be in the format 00 00 e g 12 30 starttime Field Function Allas End Time The field of the table view that contains a string time value of the end time of the lesson This MUST be in the format 00 00 e g 13 30 endtime Field Function Alas Start Date The field of the table view that contains a string date value of the start date of the lesson series This MUST be in the format dd mm yyyy e g 21 09 2014 startdste DATE_FORMAT startdate d m Y sandie End Date The field of the table view that contains a string date value of the end date of the lesson series This MUST be in the format dd mm yyyy e g 31 07 2015 enddate DATE_FORMAT enddate d m Y enoa Bedford College Electronic Leaming Blue Print Administration User Guide 55 Now if we run a test MIS query we can see that the correct data isbeing retumed ID 1 UsenD 3 User Full Name Test Student Course C001 14 Description Testing Stuff Start Date 01 03 2014 End Date 01 03 2015 Sta rt Time 09 00 End Time 11 00 Day Number 2 Staff Conn Mark Nadine Room A16 etc If you prefer to use the Moodle database t
44. in which usesthem they are pieces of information you want to be stored against a given record a target in this case You can select the type of attribute which accepts most common HIML form elements aswell asa few custom ones such ascoursepicker and userpicker If your type requires options e g a select menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any Next we have the Tutorial Hooks section which allows usto hook in data from other plugins Supported hooks for Tutorials Targets Attendance Avg Total For example if we have no hooks when we set up a Tutorial it will just be a box for the date a boxfor Tutor Comments and a box for Student comments But if we enable the Hook to the Targets plugin then we can add Targets specifically to that Tutorial they will also appearin the Targets plugin box Bedford College Electronic Leaming Blue Print Administration User Guide 22 Finally we have the Tutorial Instructions for when people are setting up new Tutorials Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure itisenabled Then if you view a student s ELBP you should see the Tutorials plugin is now available TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address 8 Test Road Test Town TE12ST D
45. ional Grades Qualification Course Aspirational Target G BTEC Level 3 Certificate Art and Design D D G Interactive Media e n Bedford College Electronic Leaming Blue Print Administration User Guide 60 2 2 4 4 Assessment Calendar The Assessment Calendar plugin isan extemal plugin which comes with the Bedford College Grade Tracker block Itcan be used to view a calendar of assignments quizzes etc which a particular student course or qualification has attached to them To install this plugin select Extemal Plugin from the drop down menu then block then bcgt Then next to the install button where it displays the path to the file it is attempting to install from click on that and it should become a text box Change bcgt class php to elbp_assessment calendar class php and then click Install Then click on Settings and we will setup the Assessment Calendar plugin The Main tab of the plugin settings allows you to enable disable the plugin to Change its display title and to change itsbackground and font colours to be used in each plugin header bar If forsome reason your browser doesnot support the HTML color input type and the colour script included doesn t work for your browser you will see just a blank input box for these colour options in which case you will need to entera colourhex code There is no other setup required for this plugin as it is just displaying data from
46. is isthe same asthe Intemal DB Report except that instead of running it against your Moodle database you setup an MIS connection and run it against an extemal database Next we have the Summary Configuration section where we can set a summary r title this is what appears in the summary box e g Your Targets Your Tutorials Bedford College Electronic Leaming Blue Print Administration User Guide 44 etc and youcan upload anicon to appearin the box should be 64x64 pixe Is like the othericons Once you have chosen what plugin structure to use we can edit the settings of the Custom Plugin 2 1 12 1 Single Report The Settings tab of the Single Report allows usto define a set of Attributes to appear in the plugin which can be filled out by the student Attributes are done in the same way across any plugin which uses them they are pieces of information you want to be stored against a given record You can select the type of attribute which accepts most common HIML fom elements aswellasa few custom onessuch ascoursepickerand userpicker If yourtype requires options e g a select menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any Example Attributes These are the fields of information you wish to have displayed on the plugin section Add New Attribute Name Type Option
47. it hasinstalled click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If for some reason your browser does not support the HTML Bedford College Electronic Leaming Blue Print Administration User Guide 37 color input type and the colourscript included doesn t work for your browser you will see just a blank input box forthese colour options in which case you will need to entera colourhex code Next we also have the Student Progress configuration if you have enabled the Student Progress Bar in the main ELBP configuration This lets you define any Course Reports related requirements which will count towardsthe students overall progress The Settings tab allows us to firstly choose what type of courses we want to be able to store Course Reports against If you do not use Meta Child courses orare unsure just tick Both Then choose which field should be used to display the name of the course Next in the Course Reports Attributes section we can create attributes Attributes are done in the same way across any plugin which uses them they are pieces of information you want to be stored against a given record a Course Report in thiscase You can select the type of attribute which accepts most common HTML fom elements aswell asa few custom
48. k input box forthese colour options in which case you will need to entera colourhexcode Then in the Web Links section we can paste in the links to the BKSB Portal and BKSB Reporting sites on ournetwork remember to include the trailing slash Then in the Assessment IDs section we can specify which assessment type should link to which assessment id in the BKSB database If you leave this blank it will attempt to work it out based on name Most of the time that should work but sometimes if you have had lots of BKSB upgrades and have various different versions Bedford College Electronic Leaming Blue Print Administration User Guide 51 of assessments it might pick the wrong one so you would need to find out itsid from the BKSB database and assign it here Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the BKSB plugin is now available e k Assessment Summary Most Recent Initial Assessments ASSESSMENT RESULT DATE English English Pre entry Oct 2 2013 3 05PM Mathematics Entry Oct 12 2011 2 11 06AM Oct 15 2012 ICT ICT Entry 3 10 06AM a 2 2 2 Live The BKSB Live plugin is very similarto the BKSB plugin however it has slightly different functionality due to the BKSB Databridge client database not storing allthe same information asthe old system did However your users shouldn t really notice any bi
49. lowing codeson your registers Present L Late A Absent E Excused Etc So here iswhere you would setup the codes and their titles The MIS tab allows usto setup the plugin to dra w in data from an extemal data source ratherthan using the Moodle database If you want to use the Moodle database instead you can skip this bit To set up the Register plugin to use an MIS connection you must first go back to the main Configuration page and create an MIS connection unless you have already done so and link it up to the Register plugin Then come backto the MIS tab in the Register settings and change Moodle Database to MIS and save the change then you should see some extra MIS settings So to setup the MIS connection first we need to enterthe name of the table or view what we will be querying Then optionally any SQL you need to be executed afterthe connection isestablished Next we need to choose how we are going to find a userin the table view will it be by their Moodle usemame ortheir Moodle idnumber field Next we have the MIS Field Mapping section where we define what the column na mesare in ourtable view so that we can SELECTthe correct data Bedford College Electronic Leaming Blue Print Administration User Guide 34 The ID field should referto a unique id column this is optional but helpful The usemame field should referto a column containing data th
50. lst any pluginsthat ma y come with extemal blocks e g the BKSB block orthe Timeta ble blockthat are provided by Bedford College along with this ELBP block can be found by navigating the blocks in the drop down menu The plugin should install very quickly and will populate its settings with default values which you can change if you wish Once the plugin is installed it willappearin the Manage Plugins section below though it willbe disabled forthe time being until you are happy that you want people to be able to start using it To manage the settings of a plugin click the Settings link next to it and to uninstall a plugin click the red cross in the uninstall column See section 2 fordetailson each individual plugin Once you have installed and configured all the plugins you want you will need to create a plugin Group It s up to you how you want to do this you may want all pluginsto be displayed on the same page in which case you could just create one group called ELBP orwhatever you like and add all plugins to that Oryou may want to separate the plugins out into different categories Either way create your group and add whatever plugins you want to it Lastly you will need to enable all the plugins that you want to use by clicking the little eye icon in Manage Plugins 1 4 6 Actions The Actionstab allows you to run ELBP related actionsagainst users Firstly you can reset changes to plugin box colou
51. mat and working and then set it up asa cron If the cron attempts to run but cannot find the file specified it will fail Best practice would be to have the CSV automatically generated and placed in that location every night or every whatever period you want it to run Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure it isenabled Bedford College Electronic Leaming Blue Print Administration User Guide 29 Then if you view a student s ELBP you should see the Attendance plugin isnow available TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 888888838 localhost Icl SUMMARY Attendance 92 Punctuality 93 eILP I Attendance 92 Punctuality 93 O Your Personal Targets 0 gem ua e a O 0 0 0 ef N No attendance punctuality records found 2 1 5 Attachments The Attachments plugin is used to allow staff membersto upload documents specifically forthat student To install this plugin choose Core Plugins from the drop down menu then choose Attachments from the next drop down then click Install Once it has installed click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font colours to be used
52. ment Settings MIS Plugins PHP Extensions Extension Plugins Status Attachments Required fileinfo Attendance amp Punctuality Optional OK The second section lists all the database tablesin the ELBP the number of recordsin them and the size so that you can keep an eye on them to see if they are getting too large at any point If a table is highlighted red there isa problem with it which you should be able to view by hovering overthe red icon to the right This will probably just be something like the table doesn t have any indexes mdl_lbp_import_mapping_users 30953 1 52 MB wy mdl_Ibp_learning_styles This table has not been indexed This could potentially make it quite slow to query if there mdi_Ibp_learning_style_answe re a lot of records mdi_lbp_learning_style_answer_pt 52 48 KB mdl_lbp_learning_style_questions 15 32 KB mdi_lbp_logs 3 80 KB mdl_lbp_log_attributes 5027 720 KB 1 4 3 Settings Configuration These general settings allow you to define system settings forthe ELBP Firstly you have the Academic Year setting Rather than archive off old data at the end of each year you can simply set the start date of the current academic year and then all data where possible before that date is hidden Thiscan be over written by individual plugins in their own Settings Bedford College Electronic Leaming Blue Print Administration User Guide 9 You should next see four roles for you to fill out Front Page Teac
53. n Add New Attribute Name Type Options Display Validation Name Text H Main Element None E z Text only Numbers only 7 Date Datepicker w Main Element y None Not empty E Text only Numbers only 7 Student Comments Textbox Y Main Element None z Text only Numbers only Tutor Comments Textbox H Main Element ls None piy Text only Numbers only gt Save Title Attribute Which attribute do you want to be displayed as the title for each item This should be something short like a title or a category or a date etc Name Your Things Most Recent Instance 2 Tue 25th Mar 2014 Admin User Instance 1 Tue 25th Mar 2014 Admin User Bedford College Electronic Leaming Blue Print Administration User Guide 46 2 1 12 3 Incremental Report The Settings tab of the Incremental Report allows us to define a set of Attributes to appear in the plugin which can be filled out by the student Attributes are done in the same way acrossany plugin which uses them they are pieces of information you want to be stored against a given You can select the type of attribute which accepts most common HIML fom elements aswell asa few custom onessuch as coursepickerand userpicker If yourtype requires options e g a select menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any Example Attributes These are the fields of info
54. nctuality period gt Last 28 Days value gt 11 27 Bedford College Electronic Leaming Blue Print Administration User Guide 28 So we can see that it is SELEC Ting the corect data The Data tab allows usto import Attendance data directly into our Moodle database using a CSV spreadsheet You can download an example csv and a template csv to fill out with data to be imported You can also choose whatto do should the import script come acrossany users or courses that don t actually exist in Moodle You could use thisto manually import Attendance data every day week etc but if possible the best thing to do if you want to use the Moodle database would be to setup a cron using the Crons tab To setup a cron first choose to enable it Then choose when you want the cron to run You can choose eithera specific time orto run Every Forexample if you choose Timing Specific Time Hour 05 Minute 30 Then the cron will run at 05 30 every day If you choose Timing Every Hour 01 Minute 15 Then the cron will run every 1 hourand 15 minutes Lastly all you have to do isspecify where on yourserverthe CSV file will be located to processand import The cron will use the exact same script to import the data asisrun when you run the import manually from the Data tab So the best thing to do isto test it first using the Data tab to ensure that your CSV is in the correct for
55. o see more reports Users should be assigned this role on the front page course Next we have the exclude courses setting If you have any coursesthat you do not want to show up in things like course reports course attendance etc that students may be on e g you may have an All Students course orany numberof other generic courses then you can exclude them by course ID here Finally we have the Logo setting A lot of the ELBP pluginscan be printed off and you may want to have your institution s logo at the top of the print outs so you can upload that here If there isa red waming that sa ys your directory is not writable that meansthat your webserver does not have the permissions to write filesto that directory so it won t be able to upload anything unless you change the permissions on that directory Bedford College Electronic Leaming Blue Print Administration User Guide 10 1 4 4 MIS Settings Various ELBP plugins allow you to connect to an extemal data source to bring in data rather than using the Moodle database On thispage you can setup connections to those data sourcesand assign them to any installed plugins The ELBP curently supports connecting to the following databases MySQL SQL Server Oracle Microsoft Access PostgreSQL Firebird SQLite The top section of this page shows you which PHP Extensions are required to connect to various different databases and which ones you have installed If you wish to connec
56. of the lesson Field Required Optional Example Notes Alphanumeric 123456 na na This must match eithera usemame or idnumber ofa user depending on which field you choose in yourdata settings This must match the Field Name of one of the Profile Fields you define in our Student Profile Bedford College Electronic Leaming Blue Print Administration User Guide 67 o configuration Do DUT S in le Y ug
57. on User Guide 4 ELBP_BKSB The elbp_bksb block isa plugin of the ELBP block Within the ELBP it will show students BKSB results however you can also add the block itself to a page to allow for more functionality such as the ability for students to take assessments through Moodle for teachersto be able to view all the BKSB results of their students etc This block itself is not required if you do not want to use it This block requires the ELBP block in order to function ELBP_BKSBLIVE The elbp_bksblive blockisa plugin very similarto the elbp_bksb block howeverthis hasbeen developed to work with BKSB s new BKSB Live hosted system ELBP_TIMETABLE The elbp_timetable block isa plugin of the ELBP block Within the ELBP it will show a student s timetable in a grid format with optionsto look at a Daily view Weekly view Monthly view orYea ny view The block itself can also be added to a page which will show the student s lessons that day as well asa link to view their full timetable This block itself is not required if you do not want to use it This block requires the ELBP block in orderto function BC_DASHBOARD The bc_dashboard block isa separate block which is bundled with the ELBP If it is installed some of the ELBP functionality will be overwritten to use the dashboard instead For instance it will override the My Students list and use a nicer looking one in the Dashboard with more functionality This block
58. on every night or every whatever period you want it to run Once you have finished setting up your Plugin you will need to add itto a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the Timetable plugin isnow available DI Kl E Si Y This Weeks Timetable sbks MON No records found ASSES TUE Englist 09 00 11 00 Testing Stuff Room A16 AA Maths WED No records found THU No records found FRI No records found Bedford College Electronic Leaming Blue Print Administration User Guide 57 2 2 4 Grade Tracker If you are using the Bedford College Grade Trackerblock see http moodlegrades bedford ac uk there are an additional 4 plugins you can install onto your ELBP system 2 2 4 1 Grade Tracker The Grade Tracker plugin isan extemal plugin which comes with the Bedford College Grade Trackerblock It can be used to display tracking gridson a student s ELBP To install this plugin select Extemal Plugin from the drop down menu then block then bcgt Then next to the install button where it displays the path to the file it is attempting to install from click on that and it should become a text box Change bcat class php to elbp_bcgt class php and then click Install Next we also have the Student Progress configuration if you have enabled the Student Progress Barin the main ELBP configuration This lets you define any
59. ormation about the student as well asa Student Information area which the students can fill out like a kind of mini profile Unlike all other plugins it doesnot appearasa box and cannot be added to a plugin group To install this plugin choose Core Plugins from the drop down menu on the Plugins tab of the Configuration page then choose StudentProfile and then Click Install Once it has been installed click Settings and we will set it up In the Main tab we can enable disable the plugin thiscan also be done with the eye icon on the previous page Next we can change the display name of the plugin if we want it to appearassomething else Next we also have the Student Progress configuration if you have enabled the Student Progress Bar in the main ELBP configuration This lets you define any Student Profile related requirements which will count towards the students overall progress And then we have the Extras Configuration where you can enable ordisable any extrason the Student Profile such as Badges The Profile Fields tab allows you to add new fields that you want to be displayed on the students profiles Forexample Fullname Address Contact Number Emergency Contact Emergency Contact Number Date of Birth Etc Bedford College Electronic Leaming Blue Print Administration User Guide 15 Each field can have a different Confidentiality level to define who
60. p the SQL query and field mappings Example MIS Configuration SQL Query This is the SQL query which will be run on your Moodle database to gather the data for the repo User ID uid Username uname User IDNumber idnum Course ID cid Course Shortname cshort Course IDNumber cidnum SELECT FROM people WHERE username uname OR name Daffy Duck Row Type Will the query return a single row or multiple rows to loop through D Single Row Multiple Rows MIS Field Mapping Add Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the query name Full Name Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the query dob Date of Birth Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the query addr Address Field To reference a field returned in the SQL query it must be mapped to a meaningful name E g the query country Country of Origin Bedford College Electronic Leaming Blue Print Administration User Guide 49 Becomes Your Things Date a Address prod Birth of Origin 789 Some Road Some Daffy 1926 Duck 04 43 Place Some County ABI US 2CD Test 1990 8 Test Road Test Town Student 09 16 TE12ST The Permissions tab forthe Custom Plugin will allow you to define what userscan and cannot do with the plugin based on their
61. ries starts This must be in the format dd mm yyyy e g 21 09 2014 The End Date field should refer to a column containing the date that this lesson series ends This mustbe in the format dd mm yyyy e g 31 06 2015 Once we have saved these settings we can run a test MIS query at the bottom of the page by supplying a usemame to be queried against so that we can see what data isbeing retumed Example Given the following extemal database table view Bedford College Electronic Leaming Blue Print Administration User Guide 54 DIS fao ooa I E 10 SELECT FROM test tt where pcode 28888888 Fiter 4 Eat PA Eb Eb Fe 8 f Autosize FA o id pcode ccode lesson daum dayname room st startime endime startdate enddate p 1 88888888 C001 14 Testing Stuff 2 Tuesday A16 Conn Mark Nadine 09 00 11 00 20140301 2015 03401 2 88888888 D12314 Fake Stuf 5 Frtag A16 Cupboard Conn 12 00 12 30 2014 03 28 2014 03 28 We can see what columns we need to link up to which field mappings However the start and end datesare in the wrong format so to get them into the dd mm yyyy format we will need to apply a function and aliasto that field So our MISsettings would be MIS Configuration Moodle Database or MIS Should the plugin use the in built Moodie tables to find the data Or should it directly query your MIS each time Moodle Database 9 mis MIS Table View Name f this is sp
62. rmation you wish to have displayed on the plugin section 4 Add New Attribute Name Type Options Display Validation Subject Text Main Element None Text only Numbers only huu Grade Text e Main Element None Text only Numbers only mix Date Datepicker Main Element None Not empty Text only Numbers only 4 ill gt Becomes Your Things Subject Grade Date English A 11 03 2014 Maths B 11 03 2014 Psychology D 13 02 2014 Bedford College Electronic Leaming Blue Print Administration User Guide 47 2 1 12 4 Intemal DB Report The Settings tab of the Intemal DB Report structure allows you to input an SQL query to be run forthe student You can use various placeholders to insert things like the student s id usema me etc You can then choose whetherthe query is going to retum 1 row or multiple rows which should be looped through Finally you can then create the field mappingsforthe fieldsthat you want to be displayed on the ELBP You can also run a test query to make sure it is retuming the data you expect but for testing purposes you will need to replace any placeholders with actual values Example Settings Here you can define the query and the field mappings for your report SQL Query This is the SQL query which will be run on your Moodle database to gather the data for the rep User ID uid Username uname User IDNumber idnum Course ID cid Course Shortname
63. role What permissions a re shown dependson the Structure of the plugin as some Structures allow for more things to be done with them than others The permissions check on the student s ELBP will go through System roles Course roles User rolesand Front Page rolesto see ifthe userhasa given permission Forexample say we were looking at the ELBP of student ID 123 on course ID 4 Also say that you are the Personal Tutor of that student and finally say the permissions were set so that only Teacherscan print the plugin off and only Personal Tutors and Studentscan edit the plugin When checking if the logged in user can print it will say Inthe System context are we a teacher No Are wea teacheron Course ID 4 No Are we assigned to UserID 123 asa Teacher No Are wea teacheron Course ID 1 Front page No When checking if the logged in user can edit it will sa y Inthe System context are we a Personal Tutorora Student No Are we assigned to Course ID 4asa Personal Tutor No Are wea student on Course ID 4 No Are we assigned to UserID 123 asa Personal Tutor Yes So the permission is granted Bedford College Electronic Leaming Blue Print Administration User Guide 50 2 2 Extemal Plugins There are a couple of other plugins offered with the ELBP system which are in their own separate blocks so that they can be displayed on theirown on Moodle courses Thisalso letsanyone create an ELBP Plugin base
64. rs either of all users ora specific user Next you can set individual capabilities to overide a user srole capabilities For example one particular student ma y be abusing the ability to add comments to Targets and ratherthan create a new role to PREVENTthat capability and add him to that role you can just go to Actions and set his capability to PREVENT Bedford College Electronic Leaming Blue Print Administration User Guide 12 1 5 Pemissions Capabilities Finally you will need to set up what user roles have what pemissions If you are going to have your ELBP block on the front page you will need to use the elbp_frontpageteacher role orif you already have a role to define staff on the front page then use that in the ELBP settings You will need to adjustthe permissions forthis role so that everything under ELBP Block isset to ALLOW except the following which should be set to PREVENT elbp admin PREVENT If you are using the Bedford College BKSB block as well front page teachers should have the bksb_student permission set to PREVENTand everything else ALLOW If you are adding the ELBP block to individualcourse pages then the permissions should be okay asthey are but it s probably best to double check the student and teacher roles just to make sure When a teacherseesthe block they should see My Students then a student sees it they should see My ELBP Personal Tutors and Additional Support L
65. s Display Validation Date Datepicker v Main Element None Not empty Text only Numbers only mi Personal Statement Textbox X Main Element None a Numbers only Tutor Comments Textbox M Main Element Le None Numbers only Becomes Your Things Date 08 03 2014 Personal Statement This is my personal statement Tutor Comments Well done Bedford College Electronic Leaming Blue Print Administration User Guide 45 2 1 12 2 Multi Report The Settings tab of the Multi Report allows usto define a set of Attributesto appear in the plugin which can be filled out by the student Attributes are done in the same way across any plugin which uses them they are pieces of information you want to be stored against a given record You can select the type of attribute which accepts most common HIML fom elements aswell asa few custom onessuch as coursepickerand userpicker If yourtype requires options e g a select menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any It also allows you to choose which of the attributes should be used asa title foreach instance created Attributes These are the fields of information you wish to have displayed on the plugin sectio
66. simple textbox 3 3 Moodle 2 8 There are a few known issues with Moodle 2 8 and above again related to the Moodle Text Editors such asthem having a very small default height and duplicating themselves when you load something up from the Dock We would recommend using the simple Text Box instead forthe time being 4 Tips and Tricks 4 1 The Dock At the bottom of a student s ELBP you will see there isa blue bar This isthe Dock Whenever you close an expanded popup view the current state will be saved into the dock Opening up from the Dock will open this last saved state whereas opening from the nomal plugin box will always reset this state and open the plugin up fresh Forexample let s say you were typing outa Target but then realised you need to check their Attendance If you close the Target popup then check their attendance then open up the Target popup in the nomal way you will have lost everything you typed However if you close the Target popup check their Attendance then open it up from the Dockat the bottom of the page it will still have everything you typed 4 2 Cente the HBP If you drag and drop an expanded popup off the screen so that the dragable handle is no longer visible and it gets stuck there you can centre it by pressing Bedford College Electronic Leaming Blue Print Administration User Guide 63 Ctrl Shift Pipe character 4 3 Command Line You can bring up the ELBP command line on
67. t it will run a query based on all the settings we have input to try and find all the information about a user with the usema me dduck which for me would retum Anon Object Full Name gt Daffy Duck Address gt 789 Some Road Some Place Some County ABI 2CD Date of Birth gt 1926 01 13 However the Date of Birth isnot in a particular nice format so let schange that This iswhere itbecomesa little more complex and we have to start using the Field Functions and Aliases You also have to know some SQL How this would work differs greatly depending on the type of database we are connecting to however for this example we are using MySQL So basically what we want to do isratherthan just retum the value in the dob field we want to run it through a function first instead In MySQL to convert a date into a different format we would use the DATE FORMATI function For example if we do this in our MySQL database we can see how we can change the format CIR GA 3118 19 1 2 Le SELECT dob DATE_FORMAT dob d m Y as nicedob FROM people Filter Fie 8 Autosize D dob nicedob p 1987 12 19 19 12 1987 1986 07 26 26 07 1986 1926 01 13 13 01 1926 So what we will do here isforthe Date of Birth field we will add that function call into the Field Function box and then add an aliasso we get both the original and the new versions Date of Birth The field of the table view that refers to this
68. t to a database but do not have any of the required extensions installed you will need to install them before you can connect MSSQL pdo_sqlsrv OK pdo_odbc OK MySQL pdo_mysgql OK Oracle pdo_oci OK The next section lists any MISconnections you have created The next section allows you to create a new MISconnection Firstly give ita unique name Then select what database type you are connecting to Then fill out the connection details host usemame password database name The host field will different depending on the type of database connection If you are unsure what to put here click on the little help icon next to Create New MIS Connection forsome examples Once you have filled out the connection details you can Test the connection to see if it works If it does you can then save it Once you have saved it the next section allows usto assign MISconnections to ELBP plugins to be used but you won t have any plugins installed yet so thiscan be done later Bedford College Electronic Leaming Blue Print Administration User Guide 11 1 4 5 Plugins This is where we install and manage all the ELBP plugins By default none of them are installed when the block is installed as different institutions ma y want to use different plugins so it s totally up to you which ones you want to install To install a new plugin select it from the drop down menu All core ELBP plugins are listed underthe Core option whi
69. t values here should be Category Description and Action Taken You can select the type of attribute which accepts most common HTML form elements as well asa few custom onessuch ascoursepickerand userpicker If your type requires options e g a select menu ora checkbox then you will have some additional inputs where you can choose what options it should have then you can choose what validation it should have if any To remove an existing Attribute simply leave its name blank and when you save them it willbe removed Lastly here we have the Title Attribute setting which just lets uschoose which of the Attributes we will use asa kind of title foreach comment s summary Once you have finished setting up your Plugin you will need to add it to a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the Comments plugin is now available Bedford College Electronic Leaming Blue Print Administration User Guide 32 TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address y 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88888888 localhost icl SUMMARY Attendance 92 Punctuality 93 eILP Ff fix Gs Comments Your File Attachments y Most Recent Comments Last Five Attachments coul Tue 25th Mar 2014 Academic Performance Test File No at e Your Personal Targets db One to One Tutoria 2 1 7 Register
70. the future we will attempt to broaden the requirements of this plugin so that if your Attendance data isin a very different format it will still work without having to create a view to format it like this So to setup the MIS connection first we need to enter the name of the table or view what we will be querying Then optionally any SQL you need to be executed after the connection is established Next we need to choose how we are going to find a user in the table view will it be by their Moodle usemame ortheir Moodle idnumber field Then similarly for the courses how are we going to find a course in the table view Will it be by the Moodle shortname or Moodle idnumber field Next we have the MIS Field Mapping section where we define what the column na mesare in ourtable view so that we can SELECTthe correct data The ID field should referto a unique id column thisis optional but helpful The usemame field should referto a column containing data that will match the user s Moodle usema me or Moodle idnumber depending on which you chose in that setting previously The course field should referto a column containing data that will match the course s Moodle shortna me or Moodle idnumber depending on which you chose in that setting previously The type field should referto a column that will contain a valid Type as defined in your plugin s settings e g Attendance Punctuality etc
71. ts that were set etc To install this plugin choose Core Plugins from the drop down menu then choose Tutorials from the next drop down then click Install Once it hasinstalled click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If for some reason your browser doesnot support the HTML color input type and the colour script included doesn t work for your browser you will see just a blank input box forthese colour options in which case you will need to entera colourhex code Next we can choose whether or not to display a progress bar of Tutorials forthe student when they look at the block to see how many targets they have achieved Next we also have the Student Progress configuration if you have enabled the Student Progress Bar in the main ELBP configuration This lets you define any Tutonal related requirements which will count towards the students overall progress Finally we can set how many of the most recent tutorials we want to display in the summary list by default this is 5 The Settings tab allows usto define attributes to be included in Tutorials so we can record whatever data we want By default these will be set to Tutor Comments and Student Comments Attributes are done in the same way acrossany plug
72. uality Lateness Whatever etc what penodsof time to store it against e g Term 1 Term 2 Last 7 Days Last 28 Days etc The first Settings section lets us choose what courses we want to display Attendance information for If you do not use Meta Child courses then just tick Both for this And also choose which name you want to be displayed forthe course Next we have the Record Types section where we can define the record types we want to record By default this will be Attendance and Punctuality but you can change them to whatever you want e g Absent Late Present Lizard etc They should also have a 1 or 2 character short code which should be unique e g if you have Attendance and Absent they should not both have the short code A Next we have the Record Periods section where we can choose what periods of time we are storing the data against By default this will be Last 7 Days Last 28 Days and Total but again you can change them to whatever you want Next we have the Tracking section which lets us setup Attendance tracking This is only available when using the Moodle database not when using an MIS connection If you enable this you can choose the date to start tracking what period of time it should show tracking for and what period of time it should be before it writes changes to the database For example if set
73. udent username idnumber pcode Course The field of the table view that contains the course code that is reflected in the moodle course either by s course Type The field of the table view that contains a string to define what type of record this is e g Attendance Punt Punctuality plugin type Period The field of the table view that contains a string to define what period of time this record covers e g Term Attendance amp Punctuality plugin period Value The field of the table view that contains the numeric percentage value value 26 Now after we have saved these changes we can run a test MIS query to make sure it is retuming the correct data For example using the MISdatabase view showed you earlier can run a test query looking for any data related to the user with the usemame 271040 and get the following output Array 0 gt Anon Object username gt 271040 course gt Bedford College Electronic Leaming Blue Print Administration User Guide type gt Attendance period gt Last 28 Days value gt 80 1 gt Anon Object username gt 271040 course gt type gt Attendance period gt Last 7 Days value gt 70 2 gt Anon Object username gt 271040 course gt type gt Attendance period gt Total value gt 90 3 gt Anon Object username gt 271040 course gt type gt Pu
74. ueries work but once you add vanablesinto the queries they do not retum any data If that isthe case try changing any operators to LIKE e g SELECT FROM myTable WHERE username LIKE uname instead of SELECT FROM myTable WHERE username Suname If you require help getting this setup contact moodlesupport bedford ac uk and we can provide you with support or if you prefer just some documentation on the processes to follow 3 2 Moodle Text Editors Athibutes In some version of Intemet Explorer if you use a Moodle Text Editor the rich text editor asone of your plugin attributes it can cause problems such as being unable to load up the plugin from the dock orforexample being unable to re load the tutorial form orthe additional support fom after having clicked to add a target This is due to a core bug in jquery in the way Intemet Explorer handles retrieving the data from iframes and isnot something we can easily fix Bedford College Electronic Leaming Blue Print Administration User Guide 62 We believe it works in IE 10 and above but in lower versions you may run into this problem in which case it would be best to change the attribute to use a simple textbox instead lthasalso been reported that in other browsers the Text Editors do not load properly though so farwe are unable to get to the bottom of what is causing this If it occurs foryou we would again recommend changing to a
75. ulate their Lea ming Style This isbased on a custom questionnaire developed forthe ELBP which in future versions you will be able to customise To install this plugin choose Core Plugins from the drop down menu then choose Leaming Styles from the next drop down then click Install Once it hasinstalled click Settings and we will set it up The Main tab of the plugin settings allows you to enable disable the plugin to change its display title and to change itsbackground and font coloursto be used in each plugin header bar If for some reason your browser does not support the HTML color input type and the colour script included doesn t work for your browser you will see just a blank input box forthese colour options in which case you will need to entera colourhex code Bedford College Electronic Leaming Blue Print Administration User Guide 42 The Settings tab allows usto see the default questions and answers which are used to calculate the user s Lea ming Style This Lea ming Style plugin uses the VAK Visual Linguistic Spatial Auditory Kinesthetic Lea ming Styles paradigm so each answer gives pointsto a certain style which are then averaged outatthe end Atthe moment you cannot change these without changing things directly in the database but in future versions you will be able to edit add delete questions answersand possibly styles Once you have finished setting up your Plugin
76. usual settings where you can change the plugin s display name and colours Now onto the Plugin Structure section This is where we decide what type of plugin we are creating You have 5 optionsto choose from Single Report Thisisa single set of form fields which the usercan fill out They can update their responses whenever they like but there is only one instance of them Think of it like the Student Profile That might have fields like Date of Birth Address etc You only fill them out once although you can change them later on Multi Report Thisisa set of form fields which can be filled out numerous times creating new instances Think of it like a Tutorial You have boxes to fill out like Description Comments by Tutor Comments by Student etc but then a few weeks later you want to fill out another new tutorial using the same boxes Incremental Report Thisisa set of form fields which can be used to append data to a report Think of it like a table with each new instance being a row you are adding to the table Intemal DB Report This lets you define an SQL query to run on your Moodle database and field mappings so that you can display the information For example you could set it up to run a query to display all the students courses they are enrolled on orall the assignments they have submitted on their courses etc Itisup to you what you want the query to do Extemal DB Report Th
77. value Alphanumeric Required A This isthe value you are setting forthis record 5 3 Timetable Field Data Type Required Optional Example Notes usemame Alphanumeric Required 123456 Thismust match eithera usemame or idnumber of a user depending on which field you choose in your data settings courseshortname Alphanumeric Optional X101_14 If set this must match either the shortname or idnumber of a course depending on which field you choose in your data settings If left blank the Timetable record will not be linked to a Moodle Bedford College Electronic Leaming Blue Print Administration User Guide 66 PO description Alphanumeric Optional startdate yyyymmdd Integer 8 Required enddate yyyymmdd Integer 8 Required starttime hhmm Required endtime hhmm Required daynumber Integer 1 Required staff Alphanumeric Optional room Alphanumeric Optional 5 4 StudentProfile 20140627 20150301 title ofthe event Thisisthe start date of the lesson in the format YYYYMMDD This is the end date of the lesson in the format YYYYMMDD This is the 24 hour time that the lesson starts This is the 24 hour time that the lesson ends This is the number of the day E g where Monday 1 Tuesday 2 etc This is used for ordering the Timetable events This is the sta ff who teach this lesson in whatever format ou want This is the room name code
78. y we have the Integrate with Calendar setting If this is ticked then any new targets added for students will be added into their Moodle calendar The Settings tab allows usto customise our Target Statuses Attributes and Instructions On installation of the plugin it should have created some default values for you which you may wish to keep or you may wish to change The Target statuses allow you to define the status of each target by default these options are To Be Achieved Partially Achieved Achieved and Withdrawn There are some check boxes next to each status as well which allow you to define which of these statuses should be considered Achieved Complete Met which of these statuses should be ignored and won t be checked for its deadline nor will it be included in progress reports And List in Summary means that the last 5 targets of this status will be listed on the student s Target summary on the ELBP Bedford College Electronic Leaming Blue Print Administration User Guide 20 Attributes are done in the same way across any plugin which uses them they are pieces of information you want to be stored against a given record a target in this case Ourdefault values here should be Target Type and Target You can select the type of attribute which accepts most common HIML fom elements aswell asa few custom onessuch as coursepickerand userpicker If yourtype requires options e g a s
79. you will need to add it to a Plugin Group and ensure it isenabled Then if you view a student s ELBP you should see the Lea ming Styles plugin is now available TEST STUDENT Student Details Student Info 88888888 Full Name Please fill me in Test Student Address 8 Test Road Test Town TE12ST Date of Birth 16 09 1990 88888888 localhost icl SUMMARY Attendance 92 Punctuality 93 eILP i O Your Learning Styles K Your Registers Monday ai o E Unit 14 Fitness Training Tuesday Auditory Visual Kinesthetic 13 3 66 7 20 English Functional Skills snc Poy I N aste Attendance 92 Bedford College Electronic Leaming Blue Print Administration User Guide 43 2 1 12 Custom Plugins As well asall the plugins supplied with the ELBP you can create yourown customised ones if there is something else you would like on the students ELBPs which isn t covered by any of our plugins To create a Custom Plugin go to the Plugins tab of the main Configuration To create a new one from scratch give ita title and click Create Or if someone has exported a Custom Plugin for you to import you can choose the XML file to import it from instead We will be creating a new one from scratch forthis example Once you have created the plugin it should appear in the Manage Plugins list highlighted yellow Click on Settings and we will set it up The Block Configuration section has the
Download Pdf Manuals
Related Search
Related Contents
株式会社LーXーL FSM-300 or FSM-320 Fast Steering Mirror & FSM User`s Manual - Data Loggers 工業用端子台 Samsung Galaxy Alpha Lietotāja rokasgrāmata MagicLift™ Hydraulic Service Jack Operating Instructions & Parts Copyright © All rights reserved.
Failed to retrieve file