📜 ⬆️ ⬇️

All-Russian Olympiad in Applied Informatics

This article will be interesting to those who are not averse to spending a little time to read the story of one victory, who is interested in how such events take place in our country and, in my opinion, is indispensable for those who want to take part.

image
The event is organized by MESI and is held every spring in April-May.
The Olympiad is held in three rounds: city, regional, all-Russian.
Participation in it can take students 3-5 courses of universities, specializing in applied computer science in various fields. The team consists of 3 students. It is fair to note that the majority of students study in the field of applied informatics in economics, where I also study. The essence of the Olympiad is to create a project to automate some business process of a particular organization.

My acquaintance with this Olympiad began in the fall of 2007, we prepared for a long time and we were sent to Ufa in April 2008, where we took second place. The first three teams were supposed to go on an all-Russian tour. But then he did not take place. Having decided that the Olympiad will not be held, we began to improve in other areas of IT.

But in April 2009, our manager said: "Team, in a couple of weeks we are going to Moscow for a regional round of the Olympiad." We haven’t opened anything for a year and almost fought over the books that each of us will read.
')
The Olympiad itself consists of three parts:
  1. Tests. They have questions on information security, on design, on information management, on databases. This is an independent work.
  2. The main task, it takes 4 hours. After that, you hand over your completed project, you can no longer change it. Then a break, after which, within 1.5 hours, preparation of the presentation.
  3. The last part, performance and presentation of the project in the form of Power Point slides, strain and read how to properly present information using slides.

This tour ended tragically for us. We were awarded the best project, and we had to share the 3rd place with one team, it was visible in the table, which was displayed on the big screen. But for some reason it happened that when we talked in the finals about the distribution of seats, they just took us and forgot, they just forgot. And our victory in the nomination for the best project sounded like a consolation prize. Our leader at this crucial moment somewhere dumped. We approached the organizers with a request to explain to us what happened after all. Nobody listened to us, they just didn’t listen and everything, damn it, we were just sent and closed a sign. In principle, this meant that we were not going to any national tour, and we didn’t even want to go after that. I think it is clear that we were experiencing at that moment. After, in Moscow, it was already impossible to find out, do not ask why.

Then we quarreled not only with our leader, but also among themselves. Our manager wrote to Moscow, they apologized to him. After a couple of weeks of quarrels, common sense won out after all, and we decided to go. We had a month to prepare.

I went in and said that I Want First Place ! And no drooling and grimacing about the fact that there will be Moscow, Novosibirsk, and God knows who else! We go for the first place.
The important thing is not to win but to take part. These are the words of those who have too much free time! I feel sorry for killing one month of my life in order to simply live a week and walk around Moscow. And in general, how much can you already participate in this Olympiad! We must already win!

And preparation began.

Preparation begins with the fact that it is necessary to correct what has turned out badly before. Our project was recognized by the jury as the best that remains (?) - performance and tests.
At this time, the tests decided to take out in the individual competition, which means everyone is sitting and reading what he wants in his spare time from the team training.
Speech With the performance, we messed up, messed up on a grand scale. Up to the point that I started to turn blue, turn green and so on.

How is this fixed?
We decided that we would conduct a pair of computer security, since our supervisor taught this subject to our stream. The topic we got is “Encryption Algorithms” (DES, AES, RSA, etc.). The bottom line should be that everyone in the audience understands how it is encrypted and decrypted.

We are done with flaws.
But it is impossible to show in the project what we showed then, we need a serious upgrade.

Now it's time to tell in detail about what should be presented in the main task and in general what it is.
You are given a description of the organization, its documentation and a description of its business processes in IDEF0 notation, 20-30 minutes after the start (or maybe right away) they distribute 1C forms used in this organization.
At the end you must provide an automation project. You can automate HR, CRM, or warehouse operations, depending on what task you’ve got, but these are the three main objects that you need to imagine.

The automation project includes:
  1. The “Task Statement” or “Technical Assignment” document, or rather this and that (we wrote only the problem statement). Documents should be based on guests, if you want to take you at all seriously. Be careful with the choice of GOST, which will prepare. Some are no longer valid, and on most Internet resources you will not be told that this series is no longer valid. And someone on the jury will know this, and believe me, do not miss the chance to tell everyone!
  2. Gantt chart. This can be done in the MS Project office application, in which enough books have been published and written in many accessible languages ​​on the Internet. I approached its development very carefully. It represented the life cycle of the software release process, based on the MSF model, it outlined what each stage consists of, provided documents that should be at each stage, and much more that only allows this scheduler to be used.
  3. The database schema in Erwin (of course, you can draw it in Access and even in Paint). The database is developed at the logical and physical levels. It's probably silly to say that you should just understand perfectly what a normalized database is and know how to set the keys correctly. Examine this product and all the nuances will be cut down mercilessly. On the databases, the jury always has a lot of questions.

The system architecture should also be presented.
This is a required part.

You are not tired yet?

Let's move on to upgrade our project. Listening to competitors in the regional tour, I wrote down original ideas and wrote down the word OLAP, to my great shame I did not know what it was then.
Your project must contain a scientific novelty. We have this become Data minig , the existence of which we learned, of course, in the month of our training. An intuit course was taught, all algorithms were learned and written out, and applications were found in all branches of life. Read more, broaden your horizons. Read as much as you can , even diagonally.
And, of course, we decided to pervert over the network architecture. Read about NAS and SAN .
A nice addition will be a prototype of interfaces (of course, with working buttons) and a feasibility study.

We also clearly described how much time we needed and divided the tasks. Who and what will perform, in what order. If you decide to create a team, you need to come up not only from the side of someone who knows well, but also that you know how to listen to each other. We have three girls in our team, and it is often difficult for us to agree with each other, despite the fact that we are friends from the first year. What you will not do for the purpose!
An organized and solid team is the key to success.

A little advice, everyone should know not only their part of the practical task, but also understand everything in order to check it with a fresh look.

So III Tour.

I'll tell you a little about the organization of the event itself.
As mentioned above, it is organized by the Moscow State University of Economics, Statistics and Informatics. Students are accommodated in the hostel, which is located on the campus. The cost of living is 500 rubles. per day, this is the standard throughout Russia. Rooms for three and two people, with TV, kettle. Every day there are free and good meals, it is considered good form in the conduct of the Olympics.

Your team will be given 2 computers, they will be installed:
AllFusion
Design IDEF 3.5
MS Office 2007 full package
MS SQLServer 2008
Delphi7
Visual studio
You can also ask for additional software, by discussing it with the administrators in advance by mail. In real time, they could not organize access to 1C from the computer classroom.
The second time, worse living conditions were waiting for us, and in general a lot of trouble happened along the way.
We arrived at the hostel, there was no hot water anywhere and even a basin, the water was boiled in a 1L kettle. Rising in the evening on day 1 on the elevator, I was anticipating how comfortable it would be with this kettle: “In general, for complete happiness, it is necessary that there is no light either.” And what do you think? We turn on the light in our room, but it is not! And the neighbors have! And sockets work for us, but there is no top light! My friends looked at me maliciously: “People like you used to be burned at the stake!” They love me)))

I'll tell you a little about our performance and the jury.
The jury includes all team leaders plus independent experts who have every right to ask any questions. You have a whole evening before the performance to remember what you were doing, to understand the lyatas and come up with an original answer. Prepare a list of possible questions and answers in advance.
An example from our presentation:
We said casual about data mining, highlighting its advantages. As expected, the jury was followed by many questions to which we were ready.
There was a bloop about whom we did not even suspect. The automation project was supposed to cost the customer 750 thousand rubles. (that we do not read), they learned only in the evening from the head. We have a feasibility study, everything is counted there! We met, we are great.
The jury looks at our network architecture, where we used SAN (wrote about it above). In general, we initially planned to use NAS, I looked at its cost, SAN is steeper, well, we assign him 10 points in the feasibility study ... well, no, 15 thousand rubles ... The jury asks the question: "Do you remember that the project should cost 750 thousand?" (many have not read it before, read the manual from and to ) We open our feasibility study with serious people. And then the jury member just starts laughing. “And where did you buy a SAN at that price?” It's not even just a boo! This is from the hands of the fourths! ”And so that you don’t have to smile sweetly and invent on the move that you have your people everywhere and great discounts, well, customs can also give you the confiscated goods - think over everything to the smallest detail , from the cost of the Win version Server, which you will need, to arrows on the database schema.

Everybody liked our performance very much.
Personally, I really liked the GUU team, they performed very well, but, unfortunately, the jury did not rate them.

There were 13 or 15 teams from all over Russia.

We took first place! YES! YES! YES! I told you!

  1. Saratov State University
  2. Magnitogorsk State University
  3. the place was divided by the universities of Novosibirsk
    • Novosibirsk State University of Economics and Management
    • Novosibirsk State Technical University
  4. State University of Management
  5. Tver branch of MESI
  6. MESI

I do not remember further.

My friend took first place in the individual competition!

Official site where you can find information about events held at MESI.

Ps. I can not write. The site is not very convenient directions to the University. It will be more convenient for you to get to the metro station Slavyansky Boulevard, then go to Kutuzovsky Prospekt via the crossing near the metro station and get off at the bus stop. On the windshield you need will be written MESI. Go 5-10 minutes. For comparison, from art. Metro University about an hour.

Source: https://habr.com/ru/post/82921/


All Articles