Archive

Posts Tagged ‘report-express’

Working around problems getting ELTI course worksheet out of Report Express

2013/11/20 2 comments

Problem: I used to, but cannot anymore get the course worksheet for ELTI out of Report Express. My choices:

image

Result set is empty:

image

Course enrollment does not work either:

image

 

image

I am still in a position to get the full class list out of the system, but that is not what I need, and is not the course worksheet sheet just a calculation based on the

image

image

Solution: Use “international programs” as the “department”.

image

It seems “department”and “subject” drop downs synchronize only with the selection of “college”, but selection of “department” can be in conflict with selection of “subject” (Is this a good GUI?).

It also seems that this affects only  the “course worksheet", but not the “class list”(Huh?)

Another example: I seem to be able to get to the  Film studies course list only if I leave all other drop down to “all”..

image

Categories: e-infrastructure, Glitches&Errors, Institution-is-University-of-North-Carolina-Charlotte, Learning-logs, websites 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: , , , , ,

Protected: How to get an email and username list of your class out of Report Express

2012/08/24 Enter your password to view comments.

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

Categories: audience-is-teachers, digital-audio-lab, e-infrastructure, Institution-is-University-of-North-Carolina-Charlotte, LRCRoomCoed434 Tags: , ,