Archive

Archive for the ‘Metrics’ Category

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

2013/01/24 Leave a comment

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

Categories: Analytics, audience-is-administration, Charts, Institution-is-University-of-North-Carolina-Charlotte, Metrics, reports, Spreadsheets, Visualizations Tags: , , , ,

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.

 

Categories: audience-is-language-learning-center-temp-staff, audience-is-students, audience-is-teachers, English, erepository, Farsi, French, German, Italian, Japanese, learning-materials, Mandarin, Metrics, Portuguese, Russian, Spreadsheets, Yoruba Tags: , , ,

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 the password below.

Categories: audience-is-administration, audience-is-teachers, digital-audio-lab, e-languages, Institution-is-University-of-North-Carolina-Charlotte, learning-usage-samples, marketing, Metrics, recording-software, reports, Screencasts, service-is-assessing, Speaking, Spreadsheets, Writing Tags: ,

Getting answers for the LRC management from Report Express

2012/08/30 Leave a comment
    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
Categories: audience-is-language-learning-center-manager, e-infrastructure, Institution-is-University-of-North-Carolina-Charlotte, Metrics, service-is-project-managing Tags: , , , , ,

LRC Workshop Demand Survey Results

2012/04/24 Leave a comment

image

7 responded, 1 commented. OP=Oral Proficiency.

Categories: audience-is-teachers, Charts, e-infrastructure, e-languages, e-learning, Media, Polls, Visualizations, workshops Tags: , , , ,

Protected: Timesheets Pivot Table

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

This content is password-protected. To view it, please enter the password below.

Categories: Analytics, Metrics, service-is-hr-managing, Spreadsheets Tags:

Protected: How to track staff and loan equipment times using the LRC checkinout.xlsm

2012/02/23 Enter your password to view comments.

This content is password-protected. To view it, please enter the password below.

Categories: Metrics, service-is-hr-managing, service-is-library, Spreadsheets Tags: , ,

How to make a tally on student staff performance

2012/01/30 Leave a comment
  1. We have a “Do’s and Don’ts” checklist for student workersas a Word web app
    1. easy to view/print for student staff,
    2. easy to update/print (and stash the work places with) for permanent staff – where each item has their point value.
  2. We have a tally of points earned (sorry, permanent staff only)  by temp staff member with date+time and explanation in Excel Web app which can be easily updated with observations by permanent staff when walking the LRC floor
Categories: audience-is-language-learning-center-staff, audience-is-language-learning-center-temp-staff, Metrics, service-is-hr-managing, Spreadsheets Tags: ,