Deploying IT Infrastructure Solutions
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.
Assignments
Coprporate 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.
Skilles 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:
- Question’s CRUD
- Test CRUD (schedule, time limits)
- Question choice engine (difficulty levels, topics etc)
- Grades and reports
- Manage users/attendees
Test interface:
- Authentication/authorization
- Start test
- End test
- 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
Robotic competitions organization software system
Description
The software system provides everything from participant registration to the live competition carry out by the referees. It contains web based interfaces and real-time applications such as score and time overlay on video broadcast. Different competition (tournament) formats are needed. As much as possible smart solutions and freely available components shall be used in order to keep the development time short.
Expected outcome
System design description including component, database and sequence diagrams. Suggestion on database, programming language and reusable components is expected. Creating a project time plan with at least two scenarios (full scope, minimum scope) is secondary objective. Prototype solution covering some part of the system would be a bonus task.
Expectations from students
Knowledge of database- and web programming. Understanding of software architectures such as MV is appreciated.
E-teacher
In the course of studying Database Fundamentals the students, as independent coursework, must draw ERD- schemes. Although there is no use of drawing the diagrams if the lector doesn’t give feedback on the success or failure of said work. The whole process of drawing ERD-diagrams looks like any other teaching process- The teacher prepares the task, the student draws the ERD-diagram and hands it to the teacher, The teacher then looks it over and corrects/improves/comments it then returning it to the student. The specificity in here being that the solutions of the tasks are graphic and no task has one concrete solution – every student solution is different. This makes every revision unique- the teacher must understand the undergrads intention, check its compliance whit the task set and then if needed make changes in the model without changing its nature.
For now it has always been done on paper – Undergrad draws a ERD case system model, prints it and hands it to the lecturer; the lecturer, if needed, corrects it with a pen , writes their comments and the non-grading evaluation and returns it to the undergrad. The lector marks the results of the test in their ÕIS table.
This process doesn’t exist electronically because during the semester there are many undergrads (ca 140-150) and there are no comfortable ways to grade them QUICKLY electronically. Herewith, when the lector gets the work printed on paper he is capable of correcting them with haste. Hence it raises two main problems that need solving. The Schemes sent on paper must be replaced by electronically forwardable materials and a way to revise/correct electronically presented ERD quick must be created.
Past couple of years have brought with them the development of portable computer user interface – There are touch screens and electronic pens, with which one can draw on a computer screen. From there springs the thought, of making an application for correction of such works, where the lector writes the corrections/notes/comments directly on the work presented by the undergrad. Using an electronic pen.
The process itself should look like this:
- The undergrad creates an ERD‐diagram and presents it in some from, that is editable by the pen (Would be best if the format permitted layers, for both the teacher and the student, so if needed the teachers additions could be „turned off
- The undergrad logs into the portal where their tests are to be presented and uploads their work. (the status becomes „presented“)
- The lector makes the corrections and adds the grade (the status of the work becomes „graded“; the evaluation can either be „accepted“, „needs personal discussion “ or „Must be reapplied“)
- The undergrad finds out their grade. If needed presents the work again.
Notes:
- The form of the presentation and the correction must be chosen
- The environment should allow the setting of the time for the discussion and medium if the lector wished for it (Time and place of direct contact; Skype etc.)
- The lector must be able to note the appointment
- The system must send an email to the lector if there is a wish for discussion
A Professional too valuable to lose
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 Februrary 2012 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.
Teams and their assignments
Example Team
Assignment: A Professional too valuable to lose
Documentation: Sailing pirates
Members
- Student 1, The Estonian Information Technology College
- Student 2, Technological Educational Institute of Crete
- Student 3, Vilnius University of Applied Sciences
- Student 4, Vaasa University of Applied Sciences
- Student 5, Fachhochschule Kiel
