Archive

Archive for the ‘Metrics’ Category

How my documentation blog is developing

2012/3 enrolment per language in the main LRC constituent departments (LCS and ELTI)

excel-pivot-visualization-databars-conditional-formatting-report-express-student-enrollment

LRC online language learning materials: the list

2013/01/17 2 comments

Below you can find a scrollable and searchable list of LRC learning materials in Moodle metacourses  (of which you can find a standalone list here).

You can filter this LRC Excel Web App using the column header dropdowns. You can click on the language in the leftmost column to go to your language’s metacourses and in its folders easily locate the resources in the right columns.

Languages that do not have their dedicated metacourse are LCTL/independent study and can be found in the LRC metacourse.

Note that the material you are looking for are not necessarily in this list, as there are other containers for language learning materials used on campus, including individual Moodle courses, textbook publisher applications, often based on Quia, like for Hybrid 1st-year Spanish, and the library ereserves.

Larger view here. UNCC-LRC Editors click here.

 

Protected: Our assessment results after 1.5 years with Sanako Study 1200

2012/11/09 Enter your password to view comments.

This content is password protected. To view it please enter your password below:

Getting answers for the LRC management from Report Express

    1. Report Express is a powerful tool to get current enrolment data which seems vital for running the LRC, but which I have not been able to get my hands on before easily (SCT-Banner limits access too much).
    2. Excel download format – which I recommend : cleaner (fewer graphics) and more information – DOES work, but for Excel 2010, I have to rename the download file extension from XLS to HTML (which the download is) and “open with”  –> Excel.
    3. I have not been successful merging these output files per language on the command line into one large HTML file and cleaning up the <html><body> framework – so I have to open each one, merge by copy/paste the contents of the result worksheet into a new worksheet and clean up the data in there by converting into an Excel Table and sorting by a suitable table column, e.g. ID, which puts all actual enrolment data sequentially, and separates all (redundant anyways) header and footer information.
    4. I finally added table columns with array formulas to calculate the enrolment aggregates,
      1. per this section (to answer questions like: will this class fit into the language resource center?),
      2. this course # (to answer questions like: where can we have maximum impact on improving learning with technology with creating the minimum of new learning/assessment materials. Assessment is standardized per course #.)
      3. and per language-level.
    5. Finally,  vlookup-columns allow me to link the instructor of record and other missing class information (room, building, time) to the student enrolment rows. This allows me to filter, sort and search the enrolment sheet with real-life questions, like
      1. can we support this size class/course/level and language in the LRC
      2. is it practical to relocate this course for part/a whole class meeting to the LRC
      3. which students need be given access permissions to the SANAKO
      4. etc.
    6. Sample filter of the aggregate sheet: enrolment-with-vlookup

LRC Workshop Demand Survey Results

image

7 responded, 1 commented. OP=Oral Proficiency.

Protected: Timesheets Pivot Table

2012/03/13 Enter your password to view comments.

This content is password protected. To view it please enter your password below: