Archive

Archive for the ‘Charts’ Category

Radar Chart visualizing Cost of Living in select US Cities

sperlings-costofliving-us-cities-radar-chart

Source:Sperling’s

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

Line chart of GINI coefficients for select economies since 1980

select-gini-coefficients-excel-chart

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

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

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).

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 Workshop Demand Survey Results

image

7 responded, 1 commented. OP=Oral Proficiency.

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