Archive
Archive for the ‘websites’ Category
Data cleansing and ETL with Perl to remove broken links
2010/04/01
Leave a comment
Categories: e-infrastructure, Screencasts, service-is-programming, websites
data-cleansing, ETL, LRC-website, Perl
Doing simple web analytics with an ASP.net DataGrid control over SQL-Server
2010/04/01
Leave a comment
Categories: e-infrastructure, service-is-programming, websites
asp.net, c#, DataGrid, ibuyspy, IIS, LRC-website, MS-SQL-server, web-analytics
LLC Catalogue: Video-Reserves.xlsm, Reserve desk, Schedule, using Blackboard Content System WebDAV
2010/03/24
Leave a comment
For a LLC video schedule, we came up with the following repurposing of existing infrastructure:
- 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.
- Blackboard Content management system (WebDAV) to manage reading and writing (editing) permissions.

- 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.

- Lab Staff can use MS-Excel to periodically transfer video reserve requests into video showings.
- Lab Assistants can use MS-Excel to daily maintain video reserve desk and video showings.
- Students can use a web browser to preview video showing times during the remainder of the term.

- 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.
- 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.
- All users will have to authenticate with their institutional account info:

A better way to do student homework audio recordings in the Sanako LAB 300, using Blackboard:Assignment
2010/03/08
Leave a comment
-
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).
-
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.
-
The assignment tool automatically creates a grade center column.
-
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,
-
and you can upload a graded version to return assignments to the student and include comments.
-
You can also create comments for the instructors only to view.
-
Faculty can also use track changes and insert more fine-grained comments and corrections within MS-Word.
-
-
Here are the parts of this series:
-
How the student reviews a grade Blackboard audio recording assignments: TBA.
Categories: assignments, digital-audio-lab, e-learning, lms, multimedia-recording
blackboard, gradebook, sanako-lab-300
Blackboard: Rolling over courses between terms
2010/01/19
Leave a comment
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.







