KöMaL - Középiskolai Matematikai és Fizikai Lapok
 English
Információ
A lap
Pontverseny
Cikkek
Hírek
Fórum

Rendelje meg a KöMaL-t!

VersenyVizsga portál

Kísérletek.hu

Matematika oktatási portál

I. 173. There were 14 questions in a pool, each with a possible answer of ``1'', ``2'' or ``X''. We would like to rank the competitors who played this game. First we assign a certain number to each question: a question is worth m points if there were m people not answering correctly that question. A competitor answering correctly a question gets the number of points of that question. The winner(s) is/are who get(s) the maximal number of points altogether.

Prepare a spreadsheet application to evaluate the pool. Beginning with the first row, each line contains the name of the contestant, then his or her 14 answers in the first 15 columns of the ``Answers'' sheet. There are at most 500 rows. If someone gave no answer to a question, that cell would remain empty. For computations and for the output, you can use the ``Computations'' sheet: cell A1 should contain the maximal number of points achieved, while cell B1 the name(s) of the winner(s).

You should submit the spreadsheet (i173.xls, i173.ods, ...) and a short documentation (i173.txt, i173.pdf, ...) containing a description of your solution, further, the name and version number of your spreadsheet application.

(10 points)

Deadline expired on 15 January 2008.


Google Translation (Sorry, the solution is published in Hungarian only.)

A feladatra sok jó megoldás érkezett. Ezek közül Földes Imre (Szolnok, Verseghy Ferenc Gimn., 11. osztály) munkáját közöljük.

foldes.zip


Statistics on problem I. 173.
10 students sent a solution.
10 points:Földes Imre, Molnár Gábor, Pap 987 Dávid, Szoldatics András.
9 points:Adrián Patrik, Véges Márton.
8 points:1 student.
7 points:1 student.
6 points:1 student.
4 points:1 student.


  • Problems in Information Technology of KöMaL, December 2007

  • Támogatóink:   Ericsson   Google   Cognex   Emberi Erőforrás Támogatáskezelő   Emberi Erőforrások Minisztériuma   Nemzeti Tehetség Program  
    MTA Energiatudományi Kutatóközpont   MTA Wigner Fizikai Kutatóközpont     Nemzeti
Kulturális Alap   ELTE   Morgan Stanley