Visualization of Municipality’s Budget

Team page for Deploying IT Infrastructure Solutions.

Team Members

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

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

• Daily log:
  • Link to Google Drive
• Final presentation of the project to the clients (10th of April, 2014)
  • Final presentation as prepared by the team
• Final documentation

Results

Personal input

Üllar Seerme

• What I did:
  • Realized the mock-up design from the brainstorming
  • Wrote the documentation

• 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:

• What I learned:

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:

• What i learned:

Pijus Akelis

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

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

Final documentation

Our final documentation can be found from Google Drive. Final Documentation