gatb - software corrección

7
Parte 1 Parte 2 Q R.C. Rpta Ptje N R.C. Rpta Ptje 1 53 1 0 1 34 4 0 1 2 55 2 0 2 36 2 0 2 3 56 2 0 3 38 3 0 3 4 57 1 0 4 40 1 0 4 5 58 1 0 5 42 1 0 5 6 59 1 0 6 44 2 0 6 7 60 2 0 7 46 4 0 7 8 62 1 0 8 48 4 0 8 9 63 1 0 9 50 4 0 9 10 65 2 0 10 52 3 0 10 11 66 2 0 11 54 1 0 11 12 67 2 0 12 56 4 0 12 13 68 1 0 13 58 5 0 13 14 69 1 0 14 60 1 0 14 15 70 2 0 15 62 1 0 15 16 71 1 0 16 64 3 0 16 17 72 1 0 17 66 4 0 17 18 74 1 0 18 68 4 0 18 19 76 1 0 19 70 2 0 19 20 77 1 0 20 74 2 0 20 21 78 2 0 21 76 5 0 21 22 79 1 0 22 78 2 0 22 23 80 2 0 23 80 4 0 23 24 81 2 0 24 82 4 0 24 25 82 1 0 25 84 2 0 25 26 84 1 0 26 86 1 0 26 27 85 2 0 27 88 2 0 27 28 86 2 0 28 90 3 0 28 29 87 2 0 29 92 2 0 29 30 89 2 0 30 94 1 0 30 31 90 1 0 31 96 4 0 31 32 91 1 0 32 98 1 0 32 33 93 1 0 33 100 4 0 33 34 94 2 0 34 102 4 0 34 35 95 2 0 35 104 4 0 35 36 96 1 0 36 106 5 0 36 37 97 1 0 37 108 1 0 37 38 98 1 0 38 110 1 0 38 39 99 2 0 39 112 2 0 39 40 100 1 0 40 114 5 0 40 41 103 2 0 41 116 1 0 42 104 2 0 42 118 1 0 43 105 2 0 43 120 5 0 44 106 1 0 44 122 3 0

Upload: josemanrique123

Post on 17-Sep-2015

211 views

Category:

Documents


31 download

DESCRIPTION

Archivo excel formulario para corregir la prueba psicotecnica GATB

TRANSCRIPT

Hoja1GATBGATBParte 1Parte 2Parte 3Parte 4Parte 5CUADRO CALIFICACINnQR.C.RptaPtjenNR.C.RptaPtjenGSR.C.RptaPtjenGVR.C.RptaPtjenGNR.C.RptaPtje1531013440125120144633012250FactoresGVNSQ2552023620235510245653025430Puntajes Obtenidos0000035620338303458103466620375500457104401044613044668404107300055810542105565405477050512910Desviacin Estndar66689659106442066684064872206141120Puntaje TOTAL00000760207464077711074874207171210CALIFICACIN862108484088743084976308191430Inferior00000963109504099782095078109221640Normal - Inferior00000106520105230101081101051803010241820Normal00000116620115410111184401151822011261910Normal - Superior00000126720125640121288201252822012292130Superior00000136810135850131391301353864013312340Muy Superior000001469101460101414943014548840143425201570201562101515974015549060153627201671101664301616101401655921016382840177210176640171710410175694501741303018741018684018171071018579650184332101976101970201918110101957983019463410207710207420201911430205810040204835302178202176502120117302159102502150374022791022782022211202022601045022533920238020238040232212440236010650235541302481202482402423127402461108102457433025821025842025241301025621091025604430268410268610262513320266311130TOTAL0278520278820272613740276311360Puntaje G0288620289030282714030286411540Puntaje N029872029922029281431029651172030892030941030291472030651195031901031964031301501031661214032911032981032311534032671233033931033100403331158103368125603494203410240343216020346812750359520351044035331632035691296036961036106503634166203670131203797103710810373516920377113320389810381101038361734038711354039992039112203937176103972137204010010401145040381792040731395041103204111610TOTAL041741414042104204211810Puntaje G042741434043105204312050Puntaje S0437514550441061044122304476147104510710451242045771492046108204612620467715120471092047128204778152204811010481305048791536049112104913230497915660501132050132305080158205111420TOTAL05181160205211520Puntaje N0528216250531171053821646054118105483166305511820558416820561202056851706057122205785172405812310588617410591241059871761060125206088178106112620TOTAL06212710Puntaje G06312810Puntaje V0641292065132206613320671341068135206913610701371071138207213920731412074142107514310761451077146107814720791482080150208115120821521083153108415420851552086156108715810881601089161109016210911631092164209316510941661095167109616810971702098172109917320100174101011751010217620103178101041791010518010106181201071821010818310109185201101862011118820112189101131901011419120115192201161932011719410118195201191972012019910121200201222011012320220124203101252042012620520127207201282082012920920130210101312122013221310133214201342161013521620136216101372161013821610139216101402161014121610142216201432162014421620145216201462161014721610148216101492162015021620TOTAL0Puntaje Q0

A=1B=2C=3D=4E=5I=1D=2A=1B=2C=3D=4a-b=1a-c=2a-d=3b-c=4b-d=5c-d=6A=1B=2C=3D=4Respuesta CorrectaRespuesta CorrectaRespuesta CorrectaRespuesta CorrectaRespuesta CorrectaCapacidad Mental GeneralAptitud VerbalAptitud NumricaAptitud EspacialPercepcin de Formas

Hoja2

Hoja3