Posts Tagged ‘charting’

Radar Chart visualizing Cost of Living in select US Cities



Categories: Charts, e-commerce, Media Tags: ,

Line chart of GINI coefficients for select economies since 1980


Based on this Dataset from the World Bank, a bit more recent than the Wikipedia Chart currently.

Categories: Charts Tags: , ,

LRC classroom usage 2013/4


Bugs in MS-Calendaranalytics?

  1. Is there an Off-by-1 bug in MS-Calendaranalytics pivot chart?
    1. I am hovering (as an example) over the first name in the upper list which displays the right name as tooltip, the first name in the second listimage
    2. I guess I could learn DAX to fix this one myself, but what I have found myself doing is copy/paste the legend control from underneath, which does not exhibit this apparent bug, as a screenshot over the wrong legend (Seems strangely inadequate!).
  2. Cannot run visual basic macro because of a syntax errorimageVersion 1 on Excel 2010 (64-bit) on Windows 7 (64-bit). Restarting (Excel/Windows) made this go away.
  3. This stopped working on load from one day to the next, without the file getting saved and updated in between: System.Runtime.InteropServices.COMException (0x80070490): Element not found. (Exception from HRESULT: 0x80070490)
    at Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IHostItemProvider.GetHostExtender(String extenderType, String extenderCookie, IntPtr& extenderObject)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.Office.Tools.IHostItemProvider.GetHostExtender(Type primaryType, String primaryCookie)
    at Microsoft.Office.Tools.Excel.ControlSiteImpl..ctor(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, UInt32 officeVersion, Control control, _OLEObject extenderControl, Boolean isDynamic)
    at Microsoft.Office.Tools.Excel.FactoryImpl.Microsoft.Office.Tools.Excel.Factory.CreateControlSite(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, Control control)
    at Microsoft.Office.Tools.Excel.Controls.Button..ctor(Factory factory, IHostItemProvider hostItemProvider, IServiceProvider serviceProvider, String cookie, String extenderCookie, Object container, String identifier)
    at ExchangeAnalytics.Sheet4.InitializeControls() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 169
    at ExchangeAnalytics.Sheet4.Initialize() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 55
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.ExecutePhase(ExecutionPhases executionPhases)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IExecuteCustomization2.LoadEntryPoints(IntPtr serviceProvider)

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

Collaborative timeline activity for face-to-face classes on history

  1. An easily produced and repeated classroom activity, originally developed for listening comprehension and speaking practice in  language classes, based on filling out collaboratively a timeline spreadsheet in the digital audio lab:
    1. Listen and process/write:
      1. Advanced German class listens to segments of an authentic German cultural history documentary from the authentic German TV series “100 deutsche Jahre” (which follows a single topic throughout 20th century German history).
      2. And each student enters notable summaries of events with their time of occurrence into a spreadsheet
      3. that the teacher
      4. has at beginning of activity distributed to each individual student using the digital audio labs file management features
      5. and after listening collects from students, merges, either with student author data or an anonymous student identifier (for corrections), into an excel timeline spreadsheet
      6. and visualizes the collaborative outcome as an easily collated timeline on the projector to the entire class.
    2. Speaking: Discuss!
      1. Identify what are the gravity points for the comprehension of the video by the class: Why are these events deemed important?
      2. What are the outliers? Criticism? Justification?
      3. Also correct language errors in the  student output.
    3. nexus_timeline_excel_100_deutsche_jahre
      1. In early 2006, there was no Excel web app – collaboration likely has become simpler now
        1. launch link to publically editable spreadsheet to class
        2. visualize using excel web app charts