Visualization of Municipality’s Budget: Difference between revisions

From ICO wiki
Jump to navigationJump to search
Line 25: Line 25:
====Üllar Seerme====
====Üllar Seerme====
* '''What I did:'''
* '''What I did:'''
** Created the inital sketch based on brainstorming
** Realized the mock-up design from the brainstorming
** Wrote the documentation
** Wrote the documentation
**  
**  
Line 37: Line 37:
====Olga Trikk====
====Olga Trikk====
* '''What I did:'''
* '''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:'''
* ''' 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====
====Georgios Alexakis====

Revision as of 10:42, 11 April 2014

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

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