Deploying IT Infrastructure Solutions: Difference between revisions

From ICO wiki
Jump to navigationJump to search
Irokk (talk | contribs)
Martina (talk | contribs)
 
(28 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Category: Õppetöö]]
[[File:EU_flag_LLP_EN_01.jpg‎‎|320px|right|text-top]]
[[File:EU_flag_LLP_EN_01.jpg‎‎|320px|right|text-top]]
<br style="clear: both" />
<br style="clear: both" />
Line 12: Line 11:
Results wiki page for the 2013 IP program [[Deploying IT Infrastructure Solutions 2013]].
Results wiki page for the 2013 IP program [[Deploying IT Infrastructure Solutions 2013]].


Video recordings of the lectures' are [https://echo360.e-ope.ee/ess/portal/section/f3965e33-979e-46d3-9b6c-e5df6f6ce4f7 here]
Video recordings of the lectures' and public presentation are [https://echo360.e-ope.ee/ess/portal/section/f3965e33-979e-46d3-9b6c-e5df6f6ce4f7 here]
 
 


=Assignments=
=Assignments=


==Corporate ISP Network Designing and Implementation==
==Corporate ISP Network Designing and Implementation==
Line 46: Line 49:
Greenpower network will work as intended and the solution is documented.
Greenpower network will work as intended and the solution is documented.


===Skilles needed===
===Skills needed===
Basic understanding of IP address, dynamic routing protocols, IPSec VPNS, Firewalls, IDS, wireless devices,  configuring routers and switches.
Basic understanding of IP address, dynamic routing protocols, IPSec VPNS, Firewalls, IDS, wireless devices,  configuring routers and switches.




Lecturer: Truls T. Ringkjob and Indrek Rokk (Estonian IT College)
Lecturer: Truls T. Ringkjob and Indrek Rokk (Estonian IT College)


==Entry Test Web Application==
==Entry Test Web Application==
Line 88: Line 92:
Support for several authentication methods such as password/username and Estonian ID Card ( More info and help from Margus Ernits).
Support for several authentication methods such as password/username and Estonian ID Card ( More info and help from Margus Ernits).
All attempts must be logged.
All attempts must be logged.


==Visualization of Municipality’s Budget==
==Visualization of Municipality’s Budget==
Line 94: Line 99:
Technical solution which enables local governments to visualize their budget (it´s composition etc) on their official webpage. Could be something similar to http://meieraha.eu/ which is for state budget.
Technical solution which enables local governments to visualize their budget (it´s composition etc) on their official webpage. Could be something similar to http://meieraha.eu/ which is for state budget.
The goal of this tool should be to simplify for users of city website (citizens) the complicated data of budget.
The goal of this tool should be to simplify for users of city website (citizens) the complicated data of budget.


===Problem and expected outcome===
===Problem and expected outcome===
Line 101: Line 105:
The created tool (solution) should offer also the possibility to „play“ with different components of budget to get better ideas of the choices and alternatives of local municipality.
The created tool (solution) should offer also the possibility to „play“ with different components of budget to get better ideas of the choices and alternatives of local municipality.
Te expected outcome should be a prototype for Tartu city what is test municipality. The tool should be easily used by all local governments who want to use that. It means that every municipality should be capable of inserting their data and see respective visualization of their data.
Te expected outcome should be a prototype for Tartu city what is test municipality. The tool should be easily used by all local governments who want to use that. It means that every municipality should be capable of inserting their data and see respective visualization of their data.


===Expectations from students===
===Expectations from students===
Line 126: Line 129:
• MySQL (version 5.6) and supported databases
• MySQL (version 5.6) and supported databases
• Drupal prefered (prefered version 8)usable with several slides. They use Drupal, multisite solution
• Drupal prefered (prefered version 8)usable with several slides. They use Drupal, multisite solution


===Support===
===Support===
Lilian Lukka, Head of Information Service, City of Tartu
Lilian Lukka, Head of Information Service, City of Tartu


==Bang&Olufsen Mobile Remote Control App==
==Bang&Olufsen Mobile Remote Control App==
Line 169: Line 172:
Knowledge of database- and web programming. Understanding of software architectures such as MV is
Knowledge of database- and web programming. Understanding of software architectures such as MV is
appreciated.
appreciated.


==A Professional too valuable to lose==
==A Professional too valuable to lose==
Line 202: Line 206:


Note: There is a dual-boot PC with a small set of assistive devices located in the students' work room (407).
Note: There is a dual-boot PC with a small set of assistive devices located in the students' work room (407).


=Teams and their assignments=  
=Teams and their assignments=  




Line 210: Line 217:
Assignment: [[#Corporate ISP Network Designing and Implementation|Corporate ISP Network Designing and Implementation]]
Assignment: [[#Corporate ISP Network Designing and Implementation|Corporate ISP Network Designing and Implementation]]


Documentation: [https://drive.google.com/folderview?id=0B0l-8m_Chg59OEw2R1JTc2V6X2s&usp=sharing&invite=CKPxxIIG Google Directory for documentation]
Documentation: [https://drive.google.com/folderview?id=0B0l-8m_Chg59OEw2R1JTc2V6X2s&usp=sharing Google directory for documentation]


====Members====
====Members====
Line 217: Line 224:
* Ari Vastamäki, Vaasa University of Applied Sciences
* Ari Vastamäki, Vaasa University of Applied Sciences


====Personal Input====
* '''Teemu Mahlamäki'''
** What I did:
*** During the project I was responsible for server configurations and Linux services
** What I learned:
*** I learned a lot about networking between the ISP and things about several protocols like BGP and EIGRP.
*** I also gained some experience on working in multicultural teams.
*** One of the new things that I encountered during project was a purely Linux based active directory solution.
*** I also gained a lot of insight on encryption methods and the philosophical approach on system and software development.


==Crash test team==
* '''Ari Vastamäki'''
** What I did:
*** My role in the team was to configure Cisco routers with Ankit Charolia. I also made the presentations and documentation about network structure and Cisco configurations.
** Things that I learned:
*** HRSP VLAN, VPN, DHCP, MPLS configurations
*** basic configuring
*** physical connections and network designing
*** presentation skills from daily feedbacks
*** Theory about MPLS protocols
**What I learned from lectures:
*** Basics of Ruby on Rails
*** Scrum Project management
*** Why we should document
*** Theory about visualization of data
*** Basics of Data Mining
*** How to give presentations in English
 
 
 
==Crashtest team==


Assignment: [[#Entry Test Web Application | Entry Test Web Application]]
Assignment: [[#Entry Test Web Application | Entry Test Web Application]]
Line 239: Line 274:
Assignment: [[#Visualization of Municipality’s Budget|Visualization of Municipality’s Budget]]
Assignment: [[#Visualization of Municipality’s Budget|Visualization of Municipality’s Budget]]


Documentation: [https://docs.google.com/document/d/1ZhxmEWWedMWB2sOszT33AHFGIldcjid0P6kAPcON07U/edit?pli=1 Daily log]
Documentation: [https://wiki.itcollege.ee/index.php/Visualization_of_Municipality’s_Budget Link to Wiki page]


====Members====
====Members====
Line 248: Line 283:
* Olga Trikk, The Estonian Information Technology College
* Olga Trikk, The Estonian Information Technology College
* Üllar Seerme, The Estonian Information Technology College
* Üllar Seerme, The Estonian Information Technology College
====Personal Input====
[https://wiki.itcollege.ee/index.php/Visualization_of_Municipality%E2%80%99s_Budget#Personal_input Available on the team's Wiki page]




Line 255: Line 293:


Documentation:
Documentation:
[https://drive.google.com/folderview?id=0B3FyuCnUBakxNk5ZYm5xTTZLUEk&usp=sharing Google directroy for documnetation]
Daily reports:
[https://docs.google.com/document/d/1tiYt7qAlM_t2c2-Xozeqb-v8_JYuwrI79jbUioahN-8/edit?pli=1 Day 1],
[https://docs.google.com/document/d/1tiYt7qAlM_t2c2-Xozeqb-v8_JYuwrI79jbUioahN-8/edit?pli=1 Day 1],
[https://docs.google.com/document/d/1bd_LQHVPpiKPQRjMaMHiw4ulr9xU66_dpBqS3ldxV50/edit?pli=1 day 2],
[https://docs.google.com/document/d/1bd_LQHVPpiKPQRjMaMHiw4ulr9xU66_dpBqS3ldxV50/edit?pli=1 day 2],
Line 260: Line 300:
[https://docs.google.com/presentation/d/12O1hzbywXZLM6e2vi2gsTUtqTV0hKgi869bkrbBXjME/edit?pli=1#slide=id.p day 4],
[https://docs.google.com/presentation/d/12O1hzbywXZLM6e2vi2gsTUtqTV0hKgi869bkrbBXjME/edit?pli=1#slide=id.p day 4],
[https://docs.google.com/presentation/d/1sTmJjv2UHixhXBFht34Tbgdm6nOw_woa6pOzxcbFknQ/edit?pli=1#slide=id.p day 5]
[https://docs.google.com/presentation/d/1sTmJjv2UHixhXBFht34Tbgdm6nOw_woa6pOzxcbFknQ/edit?pli=1#slide=id.p day 5]


====Members====
====Members====
Line 269: Line 308:
* Matti Rita-Kasari, Vaasa University of Applied Sciences
* Matti Rita-Kasari, Vaasa University of Applied Sciences


===Personal Input===


==Team 5==
[https://wiki.itcollege.ee/index.php/Unitive_developers_personal_input Avaiable here]
 
==Nemo Team==


Assignment: [[#A Professional too valuable to lose|A Professional too valuable to lose]]
Assignment: [[#A Professional too valuable to lose|A Professional too valuable to lose]]


Documentation: [https://docs.google.com/document/d/1FNATHQZj-ytPudRRIZSzB1Ga_fKJhkvYD1JCBRLyddk/edit?pli=1 Final Log]
Documentation: [[Media:2014_DITS_Nemo_team_Final_Log.pdf‎|Daily log]], [[Media:2014_DITS_Nemo_team_FinalPresentation.pdf‎|Final Presentation]], [[Media:2014_DITS_Nemo_team_FullDescriptionofSolutions.pdf‎|Full Description of Solutions]], [[Media:2014_DITS_Nemo_team_costs.pdf‎|Cost proposal for client]]


====Members====
====Members====
Line 281: Line 323:
* Kalliopi-Nefeli Goumenaki, Technological Educational Institute of Crete  
* Kalliopi-Nefeli Goumenaki, Technological Educational Institute of Crete  
* Daniel Cuervo, Fachhochschule Kiel
* Daniel Cuervo, Fachhochschule Kiel
====Personal Input====
[https://wiki.itcollege.ee/index.php/Nemo_Team_Personal_Input Available here]

Latest revision as of 11:06, 22 April 2014




This is the student results wiki page for the IP program "Deploying IT Infrastructure Solutions" taking place from 30th of March until 12th of April 2014.

All the information regarding program will be presented in the program web page.

Results wiki page for the 2013 IP program Deploying IT Infrastructure Solutions 2013.

Video recordings of the lectures' and public presentation are here


Assignments

Corporate ISP Network Designing and Implementation

Description

GreenPower is a new company with two offices. HQ in Tallinn and branch office in Amsterdam. They have about 300 employees. 275 in the Tallinn office and 25 in the Amsterdam office.

Many of GreenPowers employees work remotely and so there needs to be a secure VPN solution for the remote users to access the corporate network

You need to design and implement the whole corporate network of GreenPower.

Requirements

The network must work with both IPv4 and IPv6.

Both wired and wireless networks at both sites. The corporate wireless network must use 802.1x with a RADIUS or TACACS server.

The two sites must have a secure tunnel between them and dynamic routing must be established between these two sites.

VoIP must be working between the two sites. Yes you can use the Asterisks solution for this.

Corporate webserver with proof of concept webpage, DNS, Domain name, DHCP, HSRP, best practices of securing a network must be deployed as well.

Remote workers need a secure way to access the corporate network as well as be able to surf the net in confidence. In confidence means that the local ISP the remote users uses to access the corporate network will not be able to see what the remote users is doing.

Quality of Service must be enabled to ensure that VOIP traffic get priority.

ISP requirements Students must set up and MPLS cloud to simulate the ISP network.

Expected outcome

Greenpower network will work as intended and the solution is documented.

Skills needed

Basic understanding of IP address, dynamic routing protocols, IPSec VPNS, Firewalls, IDS, wireless devices, configuring routers and switches.


Lecturer: Truls T. Ringkjob and Indrek Rokk (Estonian IT College)


Entry Test Web Application

Description

The goal is to develop an Entry Test web application for Estonian IT College. The task starts with requirement collection and analysis (2 days), followed by choosing technical solutions such as web application framework, programming language and database system. The next steps are to design the database and to prototype the web based user interface.

Expected outcome

  • Analysis of requirements, functionalities.
  • Database design
  • Prototype of web application

Expectations from students

Previous programming experience with PHP or Ruby or Python

Lectures support

Ruby and Ruby on Rails crash course - Tiia Tänav Web based UI design - Tiia Tänav

Functionality

Admin interface:

  1. Question’s CRUD
  2. Test CRUD (schedule, time limits)
  3. Question choice engine (difficulty levels, topics etc)
  4. Grades and reports
  5. Manage users/attendees

Test interface:

  1. Authentication/authorization
  2. Start test
  3. End test
  4. Do test

Support for several authentication methods such as password/username and Estonian ID Card ( More info and help from Margus Ernits). All attempts must be logged.


Visualization of Municipality’s Budget

Description

Technical solution which enables local governments to visualize their budget (it´s composition etc) on their official webpage. Could be something similar to http://meieraha.eu/ which is for state budget. The goal of this tool should be to simplify for users of city website (citizens) the complicated data of budget.

Problem and expected outcome

The problem is that average citizen is mostly not capable of „reading“ and understanding the data about costs and incomes his/her municipality or the distributions of them between different areas local municipality is responsible for. This leads to sometimes unjustified critics towards the choices local government does and also to low interest and motivation to say their say in decicion process.

The created tool (solution) should offer also the possibility to „play“ with different components of budget to get better ideas of the choices and alternatives of local municipality. Te expected outcome should be a prototype for Tartu city what is test municipality. The tool should be easily used by all local governments who want to use that. It means that every municipality should be capable of inserting their data and see respective visualization of their data.

Expectations from students

The tool should be easily usable by boths sides – municipalities inserting data and citizens (even with only basic skills) using the data. Also the visual attraction is important! Technical specfications (written by IT Department of Tartu City)

In terms of webusability the tool should work with • Firefox (version5) • Chrome (version18) • Internet Explorer (version 10) • Safari (version4) • Android (version 4) • Opera (version12) HTML5 standard

Load enduarance : 3000 pages per/hour

Requirements for platform: • Operation System FreeBSD (version 10) • Webserver Apache (version 2.4) • PHP (version 5.5). PHP-s status deprecated should be avoided). • MySQL (version 5.6) and supported databases • Drupal prefered (prefered version 8)usable with several slides. They use Drupal, multisite solution

Support

Lilian Lukka, Head of Information Service, City of Tartu


Bang&Olufsen Mobile Remote Control App

Description

Provide a software solution that enables a user to control a B&O TV via an app. The app should get info from the TV to tailor the user experience according to TV setup. The design of the app must be in line with the B&O traditions.

Problem

Main effort of the task is to implementing the two‐way protocol to communicate to the TV. Secondly the design needs to be minimalistic and offering magical user experience. Everything should “just work” without much configuration by user, “predicting” what user would like to do, etc.

Recommended technologies

Android or iOS. It does not need be used on actual phone, emulator on a PC is just fine. Two‐way protocol over Ethernet (lan/wlan) provided by B&O.

Outcome

You should be able to demonstrate app that can find B&O TV from a network, connect two‐way to it and some user interface elements that show the magical user experience.

Software requirements & limitations

Any open source software may be used or adapted. Android or iOS development environment.

Skills needed

Knowledge of either Android or iOS development. Some experience of UI design in apps. Suggested would be to:

  1. Adherence to a coding standard;
  2. Code documentation used (Doxygen, Javadoc etc.);

Support

  1. Support with B&O two‐way protocol understanding;
  2. Introduction to the domain;
  3. Progress follow‐up sessions;
  4. E‐mail;

Expectations from students

Knowledge of database- and web programming. Understanding of software architectures such as MV is appreciated.


A Professional too valuable to lose

Description

Andrew Bessett (45) is an experienced systems administrator with nearly 20 years of experience in both Microsoft and Unix-like systems. His successful career as a leading sysadmin of Shelley's, a high-profile London insurance company, got a serious setback in February 2013 when the British Airways flight 6201 from Dubai to London with 146 passengers onboard crashed in the Austrian Alps due to bad weather and control system malfunction. Andrew, returning from his winter vacation, was one of the 12 survivors. However, he suffered serious injuries. His two upper vertebrae were smashed on impact, his hands suffered third-degree burns and had to be amputated - right at the shoulder, left at the elbow.

After spending a year in a rehabilitation programme at the Royal National Orthopaedic Hospital in Stanmore, London, he has decided to return to his work. His condition has stabilized but has left him practically paralyzed from neck down - he can move his head and (with very limited power and range) his remaining part of the left hand. He had to use respirator after the accident, but has recovered enough to breathe freely. His speech, hearing, vision and mental aptitude have survived fully intact and he has retained most of his professional skills (interrupted only by the year in therapy). He uses a joystick-controlled powered wheelchair as a means of transportation.

The company has decided to re-hire Andrew if he can prove his ability to handle most of his earlier duties. You are his technical advisory team and have to draft a suitable workstation and necessary software, plus all the necessary amendments in the company infrastructure (premises, workspace, hardware, networking, typical configuration of servers and workstations, intranet, mobile communication, website etc) to allow him return to work. Note: The IT infrastructure at Shelley's makes extensive use of both Microsoft Windows and Debian GNU/Linux platforms.

Things to do

  1. Study assistive technology (solutions that allow people with different disabilities to use computers).
  2. Map technologies that can be considered for the case (NB! The whole field is heavily individualized - most of the more complex solutions have to be tailor-made).
  3. As dedicated assistive solutions are often expensive, study also possibilities of using regular computing hardware (both in standard and non-standard roles - this is a good place for MacGyver types).
  4. Study both hardware, software and their combinations (as a rule, the simpler the hardware, the more needs to be done in software)
  5. As Andrew's company uses both Windows and Linux, study both and when possible, give preference to multiplatform/platform-independent

solutions.

  1. Also consider the work environment (doors, elevators, desk, chair, shelves etc) and possible assistive devices needed here (e.g. the powered wheelchair is quite large and heavy).

Expected outcome

A project of Andrew's future workplace - location, furniture, lighting, computer hardware and software, possible adjustments to work regimen etc. Specific models and brands of products can be proposed, but preferrably suggesting several alternatives. The project should be polished enough to be presented to the upper management of a large company.

Expectation from students

The team should get at least somewhat familiar with assistive IT solutions. Team members can choose their roles, e.g. someone on hardware, someone on environment, software etc.

Lecturer: Kaido Kikkas (Estonian IT College)

Note: There is a dual-boot PC with a small set of assistive devices located in the students' work room (407).


Teams and their assignments

Team Virtual

Assignment: Corporate ISP Network Designing and Implementation

Documentation: Google directory for documentation

Members

  • Teemu Mahlamäki, Vaasa University of Applied Sciences
  • Ankit Charolia, Fachhochschule Kiel
  • Ari Vastamäki, Vaasa University of Applied Sciences

Personal Input

  • Teemu Mahlamäki
    • What I did:
      • During the project I was responsible for server configurations and Linux services
    • What I learned:
      • I learned a lot about networking between the ISP and things about several protocols like BGP and EIGRP.
      • I also gained some experience on working in multicultural teams.
      • One of the new things that I encountered during project was a purely Linux based active directory solution.
      • I also gained a lot of insight on encryption methods and the philosophical approach on system and software development.
  • Ari Vastamäki
    • What I did:
      • My role in the team was to configure Cisco routers with Ankit Charolia. I also made the presentations and documentation about network structure and Cisco configurations.
    • Things that I learned:
      • HRSP VLAN, VPN, DHCP, MPLS configurations
      • basic configuring
      • physical connections and network designing
      • presentation skills from daily feedbacks
      • Theory about MPLS protocols
    • What I learned from lectures:
      • Basics of Ruby on Rails
      • Scrum Project management
      • Why we should document
      • Theory about visualization of data
      • Basics of Data Mining
      • How to give presentations in English


Crashtest team

Assignment: Entry Test Web Application

Documentation: task presentation github GIT repo

Members

  • Arsenios Matsanto, Technological Educational Institute of Crete
  • Lelet Hollo, The Estonian Information Technology College
  • Zumradkhon Kamolova, Fachhochschule Kiel
  • Jeremias Soini, Vaasa University of Applied Sciences
  • Edvard Šavareiko, Vilnius University of Applied Sciences
  • Anastasios Kalaentzis, Technological Educational Institute of Crete


Alpha Team

Assignment: Visualization of Municipality’s Budget

Documentation: Link to Wiki page

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

Personal Input

Available on the team's Wiki page


Unitive developers

Assignment: Bang&Olufsen Mobile Remote Control App

Documentation: Google directroy for documnetation Daily reports: Day 1, day 2, day 3, day 4, day 5

Members

  • Alexandros Apollon Rodopoulos, Technological Educational Institute of Cret
  • Harsh Jaikrushna Soni, Fachhochschule Kiel
  • Mantas Navickis, Vilnius University of Applied Sciences
  • Vilppu Vuorinen, Vaasa University of Applied Sciences
  • Matti Rita-Kasari, Vaasa University of Applied Sciences

Personal Input

Avaiable here

Nemo Team

Assignment: A Professional too valuable to lose

Documentation: Daily log, Final Presentation, Full Description of Solutions, Cost proposal for client

Members

  • Martynas Jaras, Vilnius University of Applied Sciences
  • Grigorios Maragkakis, Technological Educational Institute of Crete
  • Kalliopi-Nefeli Goumenaki, Technological Educational Institute of Crete
  • Daniel Cuervo, Fachhochschule Kiel

Personal Input

Available here