Archive

Archive for the ‘Visualizations’ Category

LRC classroom usage 2013/4

excel-powerpivot-visualization-chart-calendaranalytics-teacher-classroom-use

Mapping of Language Student Locations using PowerView

  1. What do our language students call home? Based on a pivot-table that counts zip codes, let PowerView tell you, which is can now distributed as a free add-in for Excel 2013 Prof, but you need to enable it (under File / Options / Add-Ins).
  2. image
  3. Comes with a nifty zoom: image
  4. image
  5. Click, then Hover a data bubble for more info; image
  6. Like with Bing Maps Visualization, the weighting is surprising: image

Mapping of Language Student Locations using Bing Maps

  1. What do our language students call home? Based on a pivot-table that counts zip codes, let Bing Maps tell you, a default add-in easily accessible in the insert section of the ribbon:
  2. image
  3. Note a Limitation: Bing Maps max 100 data points. image
  4. So we limited to zip codes with at least 15 students (which returns just below 100 zip codes).
  5. Also note, the Bing maps app cannot be increased beyond a certain size (below is the maximum).image
  6. Finally, note  that the visualization does have a weight indicator, but it seems imperfect:
  7. image
  8. clip_image001
  9. Here is how data (type) input errors get handled (duplicates override the original):
  10. image
  11. Fix your data, the reload from the upper right unfoldable menu: imageimage
  12. Voilà: image

Summary of the LRC main classroom use in year 2012/3

image

(Tentative while experimenting with Calendaranalytics).

Summary of my work calendar in year 2012/13

calendaranalytics-lrc-director

(Tentative while experimenting with Calendaranalytics).

First results with MS-Calendar Analytics for learning center management

  1. You can use the controls on the right to drill into the detail by selecting one or more
    1. Aliases,
    2. Attendees,
    3. Time periods
    4. Status.
  2. The graphs on the left and in the center will automatically reflect your selection on the right.
  3. These results lead to more questions. E.g. why is this tripod so popular?
  4. calendaranalytics
  5. Lesson learnt: Now it comes back to haunt us that we block broken or MIA equipment from users attempting to book it by making it look “busy” with an 24/7 “Appointment“. However, It should however be possible to filter out such appointments, versus “meeting requests”.
  6. calendaranalytics0

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

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