Week 7

Take home exam

Met Bastiaan Waanders - wiki.




Take home. Make in groups of 1 or 2. Hand in April 1 by uploading on Blackboard (use "Opdrachten inleveren" button). Hand in the following:

  1. Your XQuery file with filename consisting of the two lastnames of your team (like in MarxSherkhonov.xq).
  2. An HTML file with the output of your XQuery. Use the same name, but extension .html
  3. Your HTML file uses an external CSS stylesheet that is called via an absolute URL and that is available on the internet.
  4. Your HTML file should start with the following:

    Exam made by

    Last namecollegekaart nummer
    Last namecollegekaart nummer

Exam questions

  • Download http://data.politicalmashup.nl/collections/members.csv. Extract from it the list of urls to the XML files for these members, and download them all with wget. (Under linux, you can do this with awk and sed).
  • A really bad looking output of the questions is located here. You are supposed to produce the same results, but make them look much nicer.
  • Next to these questions, you should make a new question and program it too. Choose one of the three design patterns: top ten, pie chart or bar chart.
    It is boring for us if you make up a question that another group also uses. So avoid that this happens.
  • A good way to produce your results is to fill in the XQuery skeleton. The HTML was produced by this query. This skeleton is created by Johan van Doornik vandoornik@gmail.com. Mail him if something is wrong.
  • Your results will be used in an article about the Wikipedia coverage of Dutch politicians. Of course such an article cannot just contain text and boring HTML tables. It has to be flashy, funky, good looking, and who knows, maybe even interactive....

    Thus you are supposed to visualize at least two of the queries. Use a pie chart and use a bar chart, or something even more fancy.
    Your XQuery should produce the visualization immediately from the data. Thus not some kind of screenshot made by hand in Excel.
    You can do this for instance using Google charts, but everything is possible.

XQuery solution: