Archive

Archive for the ‘websites’ Category

Data cleansing and ETL with Perl to remove broken links

Doing simple web analytics with an ASP.net DataGrid control over SQL-Server

LLC Catalogue: Video-Reserves.xlsm, Reserve desk, Schedule, using Blackboard Content System WebDAV

For a LLC video schedule, we came up with the following repurposing of existing infrastructure:

  1. MS-Excel: still the “Swiss army knife” of choice for the middle manager. Allows for: semi-automatic creation of reserve date sequences (insert series), given a start and end date; data validation during data entry, and, based on that, sorting and filtering and, based on that, finding.
  2. Blackboard Content management system (WebDAV) to manage reading and writing (editing) permissions.
  3. Staff can use MS-Excel to request videos – preferably at start of term – to be put on reserve within a start and end date, during which they will be periodically shown, by opening the spreadsheet from MS-Excel and filling in the green cells in the first empty row at the bottom.
  4. Lab Staff can use MS-Excel to periodically transfer video reserve requests into video showings.
  5. Lab Assistants can use MS-Excel to daily maintain video reserve desk and video showings.
  6. Students can use a web browser to preview video showing times during the remainder of the term. 
  7. To open the video schedule for read-only, Loyola students and staff can  simply click this link in their browser: https://blackboard.loyola.edu/bbcswebdav/users/trplagwitz/llc-pfiles/video/video-reserves.xslm. Even read-only access includes the capability to search, sort and filter the schedule data, but you cannot save back.
  8. To open the video schedule for editing, LLC and Modern Languages staff  can start MS-Excel, click menu: File / Open, and copy/paste this link:  https://blackboard.loyola.edu/bbcswebdav/users/trplagwitz/llc-pfiles/video/video-reserves.xslm, then click open.
  9. All users will have to authenticate with their institutional account info:

 

 

Blackboard: Content System: Permissions, Roles and Gotchas

  1. The “Course user list“ refers to courses.
  2. The “Organization user list” refers to departmental groups. The subdivision is meaning list for our department.
  3. The “Institution user list” adds the most global group level.
  4. Finally, you can make files available to the “Public”. Note, however, that this seems to effectively bypass the more fine-grained permission checks. E.G. if you give read access to the public, users who open your files will not receive an authentication challenge, so if you try to give some of the users write access to your files, that will not trickle through. Workaround:  Do not use “public”.

LLC Catalogue: This is not Google!

  1. I have been given access to the online catalogue program, learned that VS.net 2008 still supports classic ASP, and managed to make a couple of changes to the catalogue home  and search result and pages which will hopefully make your learning material searches more successful.

A better way to do student homework audio recordings in the Sanako LAB 300, using Blackboard:Assignment

  1. More robust than the more common way using the default network shares of a Sanako Lab 300 – to my knowledge, up to this day Sanako Labs lack any integration with the LMS/VLE regarding the upload of student output – is using the assignment tool of the VLE which provides integration with the Student Information System and an entire infrastructure for assessment purposes (gradebook and beyond).
  2. I know that some teachers use Blackboard email with attachments for assignments, others the blackboard drop-box. Some, including me, use the assignment tool which, since it appears to be far superior to the older tools, this post would like to advertise.  
    1. The assignment tool automatically creates a grade center column. 
    2. You can batch download student file submission (papers or recordings) and blackboard assignment tool puts the assignment name and the username in the file name for easier management,
    3. and you can upload a graded version to return assignments to the student and include comments. 
    4. You can also create comments for the instructors only to view. 
    5. Faculty can also use track changes and insert more fine-grained comments and corrections within MS-Word.
  3. Here are the parts of this series:
    1. How the student reviews a grade Blackboard audio recording assignments: TBA.

Blackboard: Rolling over courses between terms

In your old course, go to CONTROL PANEL > COURSE COPY”.

Choose: “Copy Course Materials into an Existing Course” (assuming your new course shell has been created for you by your IT admin).

Click button:“Browse” and in the opening window, choose your existing current course, by the  term identifier:

Check all items you want to copy. What is safest to avoid errors? Everything, except enrollments?

Click “Submit”/“OK” until done.

The course copy operation will be queued up, and you will be notified when the operation is finished.

Then go to your new course. This operation also copied the content items, including the content management system items.

LLC staff site now features a Wiki

… thanks to Blackboard.