Visualization of Municipality’s Budget

Team page for Deploying IT Infrastructure Solutions.

Members

• Alexandros Kantas, Technological Educational Institute of Crete
• Georgios Alexakis, Technological Educational Institute of Crete
• Pijus Akelis, Vilnius University of Applied Sciences
• Mindaugas Gedaminskas ,Vilnius University of Applied Sciences
• Olga Trikk, The Estonian Information Technology College
• Üllar Seerme, The Estonian Information Technology College

Goal

The goal of the project was to create a prototype tool for the City of Tartu, which enables ordinary citizens to have a visual overview of their municipality's budget. This would also allow for these citizens to manipulate the data to come up with their own ideas for a suitable budget. An example of http://meieraha.eu was given as a possible solution. In terms of usability for the back-end, the administrator or municipality worker should have a simple interface, which allows him or her to easily insert data.

Activity

• Project files:
  • Archived project files
• Daily log:
  • Link to Google Drive
• Final presentation of the project to the clients (10th of April, 2014)
  • Slideshow as prepared by the team
  • Video of presentation, where Alpha Team starts presenting from 49:00
• Final documentation
  • Documentation in .pdf format

Results

Personal input

Üllar Seerme

• What I did:
  • Realized the mock-up design from the brainstorming
  • Wrote the documentation
  • Set up test platform with various software like Apache and MySQL

• What I learned:
  • To use FreeBSD
  • To work with a team
  • To be more confident when doing presentations
  • To communicate more fluently

Olga Trikk

• What I did:
  • Participated in database design
  • Restructurized the budget data we got from the client and imported it to database
  • Contacted with the client about the data structure
  • Implemented saving the budget data from database to .json file and reading data from .json file to jquery

• What I learned:
  • Experience of doing a project in an international team
  • Experience of working on a real project
  • New knowledge about PHP, JavaScript, JSON, jQuery

Georgios Alexakis

• What I did:
  • Design of sliders
  • Design of project
  • Help with final presentation

• What I learned:
  • Ruby on Rails
  • Multicultural teamwork
  • Better communication skills
  • Gained presentation skills

Alexandros Kantas

• What I did:
  • Excel macros for database
  • Database schema
  • JSON files

• What I learned:
  • VBA for Excel
  • PHP and JSON syntax
  • Time management
  • More experience working with a team

Mindaugas Gedaminskas

• What I did:
  • Implementation of sliders
  • Front-end
  • Styling

• What I learned:
  • To work with a team
  • Working in a foreign language
  • Experience in front-end coding
  • To practice good documentation
  • Presentation skills

Pijus Akelis

• What I did:
  • Admin panel
  • General back-end work

• What I learned:
  • Working with a team
  • Stuff about Estonia