Post on 13-Feb-2016
description
Distribuţia notelor
Notă Examen Nota Număr note Distribuţia grafică a notelor
554 8.25 1 52 llllllllllllllllllllllllllllllllllllllllllllllllllll299 8.75 2 122 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll331 8.25 3 175 lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll190 10.00 4 234 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll531 9.00 5 304 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll271 10.00 6 352 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll549 7.25 7 412 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll715 2.50 8 462 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll104 6.50 9 518 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll589 8.25 10 626 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll300 1.00708 1.2556 6.50
208 3.0072 2.75
631 5.00137 8.25302 6.25312 6.50632 6.75723 1.50648 8.50415 9.75304 2.25638 3.25659 2.75392 9.00339 10.00402 1.00623 3.00254 9.50305 1.75108 4.50604 3.50718 9.00370 1.25354 5.25
6 6.25
Să se reprezinte grafic (histogramă orizontală) distribuţia notelor utilizând o funcţie de tip text, si nu un obiect grafic
Cod student
506 6.0064 7.0029 1.75
313 2.75184 4.00477 4.00292 2.0059 2.5089 9.50
434 3.75183 9.50645 1.25282 6.5071 4.50
100 1.00315 3.50725 9.00101 6.25451 9.25612 4.50316 2.50317 8.50274 9.75667 6.50617 5.25127 7.5079 3.7577 1.00
156 4.00704 6.50529 3.75296 3.25172 7.0081 5.0057 10.00
457 10.00432 2.00586 3.25541 8.75225 3.25330 9.7544 3.25
144 10.00220 7.25216 9.50324 1.50
135 1.00328 9.50308 8.2542 6.50
644 3.50200 6.50699 3.00129 10.00171 5.25329 2.00173 9.00320 5.50335 9.50192 7.00260 1.00336 4.50379 9.00637 4.50206 9.00341 10.00248 2.75344 8.50345 2.75112 7.50310 1.00367 8.25346 8.75277 1.00152 2.0023 10.00
716 4.75291 2.50411 4.50276 5.75185 7.50608 3.75105 1.25564 5.25236 6.75349 1.00222 2.50186 7.00251 10.00443 2.7598 10.00
500 2.25
334 9.7566 8.50
355 1.00474 7.50360 3.00102 8.25375 2.75568 3.75599 2.00239 6.50470 1.25681 6.25537 1.00668 5.75364 9.00366 4.75662 5.00224 8.0012 5.2524 10.00
559 3.507 3.50
653 10.00624 9.50373 2.50403 7.50376 2.25441 5.25350 2.00593 4.75298 8.00325 10.00720 3.50510 3.00661 3.25143 3.25404 5.00426 10.0046 9.00
378 3.25268 9.0062 1.75
123 9.75672 6.50134 5.50597 9.50
579 8.50497 5.75168 4.50365 3.25383 7.25552 9.00169 4.00620 5.50619 6.7541 1.00
126 10.00710 5.00634 6.00337 9.50229 4.75387 1.00284 6.75111 6.0026 6.25
393 10.00486 6.50242 8.00188 1.00479 2.0054 10.00
395 9.75340 1.25397 1.00165 3.50307 5.00361 5.25400 1.25139 2.00674 2.20633 8.00513 7.50401 8.75406 3.25489 1.0065 10.0049 3.5018 9.50
570 4.5028 1.00
713 1.00678 5.25
87 7.00407 2.75418 6.50269 5.00574 8.00234 7.25490 5.75468 7.75396 10.00408 9.50414 9.50542 4.50430 4.50712 9.0053 4.50
613 4.50622 4.75655 5.0092 4.50
606 9.75603 9.5047 9.50
228 1.25124 9.00416 5.50677 7.50294 4.50118 6.2538 4.50
215 7.75417 1.25419 9.75435 3.00682 4.50688 8.5093 1.00
436 3.0017 9.00
388 6.25180 1.50132 6.00684 1.50238 10.00125 6.50621 6.50626 6.50
213 8.7531 7.5084 9.5094 4.25
343 5.50458 5.25481 4.50642 8.50438 3.25199 10.0070 1.00
485 10.00647 2.00666 2.50550 9.50295 3.50
3 9.75657 3.2515 8.00
210 9.00439 5.50702 3.00459 5.00381 1.00442 7.75694 1.00273 8.00372 10.00445 4.50447 3.7511 7.00
582 8.25422 6.50448 5.00116 2.00
8 10.00692 5.25449 4.50227 5.50707 9.75722 3.75327 9.50687 2.00138 7.50
9 1.00321 1.50
352 7.25197 4.75640 7.5067 9.25
293 3.00359 7.75473 3.50467 7.75553 8.75652 1.00
1 8.50548 3.00174 2.25455 8.00598 6.2551 10.00
460 6.50164 3.25669 2.75141 8.00257 1.50629 1.25602 1.00462 5.75584 4.50463 3.75658 6.00446 4.50303 10.00625 5.75195 3.50456 7.50261 1.00382 3.50600 9.50230 1.00285 10.0061 1.00
571 9.75410 6.50475 5.2580 6.25
121 1.00209 9.25556 1.00157 6.00
680 9.75241 7.50146 9.00133 2.0035 3.00
120 2.75226 3.25207 1.00280 5.75193 2.00265 2.50394 1.0091 9.5030 6.2539 5.25
476 3.75480 4.50181 8.50487 5.00488 10.0045 2.00
427 1.50163 1.50483 1.75235 8.75543 1.25358 1.00109 3.25136 5.00491 6.50544 9.50714 3.00278 4.50279 4.5027 1.00
219 5.7514 9.75
160 6.25494 2.2578 2.00
142 4.75700 10.0013 4.75
698 2.00338 4.50217 6.25
161 6.75253 8.50178 2.00501 5.5052 10.0043 10.00
502 1.50696 3.50503 4.75107 1.00425 8.00362 7.25113 5.75140 5.25386 10.00117 10.00693 1.25115 8.00
5 2.25119 4.7588 1.00
151 1.50203 6.50505 9.50575 7.00665 3.25453 6.00333 1.00641 2.10478 8.0048 1.00
508 1.50509 4.50162 7.25514 7.75266 6.50214 10.00420 9.75515 7.75
2 9.50516 2.00159 3.50187 4.00114 4.75697 8.00519 9.75
518 1.00149 6.50240 9.50288 4.7540 10.00
452 8.25605 5.00521 2.25301 10.00179 10.00577 4.50522 9.0074 1.0068 3.75
353 6.75444 4.50437 4.75484 6.25573 8.75523 7.25525 1.00332 9.50347 9.25469 2.00572 9.75595 5.50205 2.50628 1.25247 10.00391 3.7585 9.00
528 1.25148 2.25431 8.5096 2.00
245 2.50399 2.00706 5.0033 10.00
182 10.00592 8.75685 2.75246 8.50511 9.00651 5.50679 5.00
536 4.50189 6.50368 3.75167 7.50202 3.75464 10.00533 7.75504 9.75262 10.00627 6.5097 10.0032 2.00
654 10.0099 10.00
147 3.50534 9.75539 1.75232 10.00374 10.0036 2.00
703 2.75342 2.50611 7.00286 3.50660 6.00389 5.00709 6.25646 1.00671 2.25689 9.5055 10.00
532 8.25557 6.50673 6.50433 1.00656 1.00170 3.00610 5.00221 4.5083 10.0050 10.00
587 8.50675 5.7563 8.2521 7.75
558 1.00
482 8.00596 3.75721 5.75106 8.00218 6.75103 9.00424 4.5073 2.00
560 1.50428 9.50695 5.25676 4.50283 3.75686 4.50601 1.00717 9.75263 8.50517 9.75423 1.75270 4.50259 7.50561 2.00377 1.50256 10.00461 1.00562 9.75563 7.75130 1.00131 2.00289 1.00607 6.75255 10.00630 5.25243 3.50565 9.50639 4.50690 6.0022 6.00
204 1.7590 1.00
450 7.00212 6.25390 2.00493 8.00614 1.25466 9.00
385 10.00545 3.25567 5.7534 10.00
724 2.00198 3.50128 3.50237 8.75576 3.75535 2.00244 8.75580 7.50566 7.75551 9.00663 1.00581 10.00615 3.0086 9.00
701 1.50583 2.00223 10.00318 1.25585 3.75357 7.00588 9.50495 4.5069 1.50
636 1.75590 3.50398 3.00471 8.00249 2.75591 1.00275 2.75578 4.50158 2.50649 5.50314 8.25413 4.50440 6.25306 1.25290 4.75110 3.00356 8.50122 9.50
Distribuţia grafică a notelor
lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
utilizând o funcţie de tip text, si nu un obiect grafic
lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
Nume Prenume Sucursala Departament
ALBITER Oana Plevnei Creditare
ALBU Constanta Doctor Felix Creditare
BLAGA Mădălina Plevnei Corporaţii
CHIRU Bogdan Plevnei Oficiul juridic
COMAN Aura Ştefan cel Mare Asigurari
CONSTANTIN Ana Doctor Felix Corporaţii
DEDU Natalia Ştefan cel Mare Corporaţii
GANEA Pavel Ştefan cel Mare Creditare
MANESCU Andreea Ştefan cel Mare Oficiul juridic
MIHAI Carmen Ştefan cel Mare Creditare
MIHAI Dinu Doctor Felix Oficiul juridic
MONDREA Laura Ştefan cel Mare Creditare
NEDELCU Mihai Ştefan cel Mare Oficiul juridic
PANAIT Cornel Ştefan cel Mare Asigurari
PETRE Cristina Doctor Felix Relaţii clienţi
POPA Florin Ştefan cel Mare Corporaţii
POPESCU Viorel Dan Doctor Felix Creditare
SAVU Cătălin Ştefan cel Mare Asigurari
SORESCU Liana Plevnei Creditare
VISAN Alexandra Plevnei Corporatii
VLAD Petru Ştefan cel Mare Relaţii clienţi
Data naşterii (ll/zz/aa)
11/07/49 F Oct-1983 Nov-194909/04/77 F Feb-1970 Sep-197711/23/61 F Aug-1981 Nov-196108/17/56 M Dec-1979 Aug-195603/04/80 F Dec-2006 ###12/07/50 F May-2004 Dec-195007/22/61 F Feb-2006 Jul-196111/01/70 M Nov-2002 Oct-197010/10/81 F Apr-2006 Oct-198102/27/60 F Sep-1980 Feb-196006/02/55 M Jul-1979 Jun-195506/15/60 F Apr-2006 Jun-196001/30/81 M Jun-1985 Jan-198105/01/59 M Oct-1984 Apr-195908/09/66 F Apr-1980 Aug-196610/01/50 M Jun-1999 Sep-195012/12/62 M Apr-2006 Dec-196204/04/70 M Mar-1978 Apr-197003/12/68 F Apr-2006 ###12/25/72 F Nov-1975 Dec-197202/05/60 M Aug-2001 Feb-1960
Genul (M=masculin F=feminin)
Data angajării
Vechimea (ani)
Cod numeric personal
2,900 lei 2.49.11.07.345633
2,900 lei 2.77.09.04.444890
2,800 lei 2.61.11.23.546967
3,200 lei 1.56.08.17.341871
1,000 lei 2.80.03.04.227773
1,050 lei 2.50.12.07.472590
1,050 lei 2.61.07.22.114674
1,200 lei 1.70.11.01.555889
1,050 lei 2.81.10.10.510053
2,900 lei 2.60.02.27.503812
3,200 lei 1.55.06.02.422877
1,000 lei 2.60.06.15.100121
2,790 lei 1.81.01.30.333655
2,500 lei 1.59.05.01.673895
3,350 lei 2.66.08.09.310349
1,180 lei 1.50.10.01.701902
1,000 lei 1.62.12.12.345345
2,900 lei 1.70.04.04.222888
1,000 lei 2.68.03.12.508405
3,200 lei 2.72.12.25.557812
1,180 lei 1.60.02.05.667445
Salariu încadrare
Cod Produs pret
1231234 312
1233212 332
2345657 456
3578903 789
2134123 341
4568950 689
48.1666666666667 #DIV/0!
Să se calculeze preţul mediu, presupunând că acesta este editat începând de la valoarea poziţională 3 până la 5 în codul compozit din câmpul A3:A8.
, presupunând că acesta este editat începând de la valoarea poziţională 3 până la 5 în codul compozit din câmpul A3:A8.
5 9 12 0001 AAA
3 5 10 01 A
4 7 9 001 AA
Cod compozit in patru trepte variabile
Identificarea valorii
pozitionale aferente primului SPATIU
Identificarea valorii
pozitionale aferente celui de-al doilea
SPATIU
Identificarea valorii
pozitionale aferente celui de-al treilea
SPATIU
Extragerea primului grup de
caractere
Extragerea celui de-al
doilea grup de caractere
0001 AAA ZZ 999999
01 A ZZZZ 99
001 AA Z 9999
Observaţie: Alegerea succesiunii de afişare a grupurilor de caractere din codul compozit recompus rămâne la latitudinea studentului.
ZZ 9 0001 AAA ZZ 9
ZZZZ 99 01 ZZZZ 99
Z 9999 001 AA 9999
Extragerea celui de-al
treilea grup de
caractere
Extragerea ultimului grup de
caractere
Cod recompus in alta ordine (prin concatenare)
: Alegerea succesiunii de afişare a grupurilor de caractere din codul compozit recompus rămâne la latitudinea studentului.
Nume Prenume Sucursala Departament Codul salariatului
ALBITER Oana Plevnei Creditare Cred-Nov49 F
ALBU Constanta Doctor Felix Creditare Cred-Sep77 F
BLAGA Mădălina Plevnei Corporaţii Corp-Nov61 F
CHIRU Bogdan Plevnei Oficiul juridic Ofic-Aug56 M
COMAN Aura Ştefan cel Mare Asigurari Asig-Mar80 F
CONSTANTIN Ana Doctor Felix Corporaţii Corp-Dec50 F
DEDU Natalia Ştefan cel Mare Corporaţii Corp-Jul61 F
GANEA Pavel Ştefan cel Mare Creditare Cred-Nov70 M
MANESCU Andreea Ştefan cel Mare Oficiul juridic Ofic-Oct81 F
MIHAI Carmen Ştefan cel Mare Creditare Cred-Feb60 F
MIHAI Dinu Doctor Felix Oficiul juridic Ofic-Jun55 M
MONDREA Laura Ştefan cel Mare Creditare Cred-Jun60 F
NEDELCU Mihai Ştefan cel Mare Oficiul juridic Ofic-Jan81 M
PANAIT Cornel Ştefan cel Mare Asigurari Asig-May59 M
PETRE Cristina Doctor Felix Relaţii clienţi Rela-Aug66 F
POPA Florin Ştefan cel Mare Corporaţii Corp-Oct50 M
POPESCU Viorel Dan Doctor Felix Creditare Cred-Dec62 M
SAVU Cătălin Ştefan cel Mare Asigurari Asig-Apr70 M
SORESCU Liana Plevnei Creditare Cred-Mar68 F
VISAN Alexandra Plevnei Corporatii Corp-Dec72 F
VLAD Petru Ştefan cel Mare Relaţii clienţi Rela-Feb60 M
Genul (M=masculin F=feminin)
Codul angajatului reprezintă un cod compozit care conţine: primele 4 litere din departament, luna şi anul naşterii .
Exemplu: salariatul Visan Alexandra are codul Corp-12-72
Cod numeric personal
59 ani Oct-1983 25 ani 2,900 lei 2.49.11.07.345633 ALBITER 2.49.11.07.345633
31 ani Feb-1970 39 ani 2,900 lei 2.77.09.04.444890 ALBU Cons2.77.09.04.444890
47 ani Aug-1981 27 ani 2,800 lei 2.61.11.23.546967 BLAGA Mă2.61.11.23.546967
52 ani Dec-1979 29 ani 3,200 lei 1.56.08.17.341871 CHIRU Bo1.56.08.17.341871
29 ani Dec-2006 2 ani 1,000 lei 2.80.03.04.227773 COMAN A2.80.03.04.227773
58 ani May-2004 4 ani 1,050 lei 2.50.12.07.472590 CONSTAN2.50.12.07.472590
47 ani Feb-2006 3 ani 1,050 lei 2.61.07.22.114674 DEDU Nata2.61.07.22.114674
38 ani Nov-2002 6 ani 1,200 lei 1.70.11.01.555889 GANEA Pa1.70.11.01.555889
27 ani Apr-2006 2 ani 1,050 lei 2.81.10.10.510053 MANESCU 2.81.10.10.510053
49 ani Sep-1980 28 ani 2,900 lei 2.60.02.27.503812 MIHAI Ca 2.60.02.27.503812
53 ani Jul-1979 29 ani 3,200 lei 1.55.06.02.422877 MIHAI Di 1.55.06.02.422877
48 ani Apr-2006 2 ani 1,000 lei 2.60.06.15.100121 MONDREA 2.60.06.15.100121
28 ani Jun-1985 23 ani 2,790 lei 1.81.01.30.333655 NEDELCU 1.81.01.30.333655
49 ani Oct-1984 24 ani 2,500 lei 1.59.05.01.673895 PANAIT Co1.59.05.01.673895
42 ani Apr-1980 28 ani 3,350 lei 2.66.08.09.310349 PETRE Cri2.66.08.09.310349
58 ani Jun-1999 9 ani 1,180 lei 1.50.10.01.701902 POPA Flor 1.50.10.01.701902
46 ani Apr-2006 2 ani 1,000 lei 1.62.12.12.345345 POPESCU V1.62.12.12.345345
38 ani Mar-1978 31 ani 2,900 lei 1.70.04.04.222888 SAVU Cătă1.70.04.04.222888
41 ani Apr-2006 2 ani 1,000 lei 2.68.03.12.508405 SORESCU 2.68.03.12.508405
36 ani Nov-1975 33 ani 3,200 lei 2.72.12.25.557812 VISAN Ale2.72.12.25.557812
49 ani Aug-2001 7 ani 1,180 lei 1.60.02.05.667445 VLAD Petr1.60.02.05.667445
Vârsta (ani)
Data angajării
Vechimea (ani)
Salariu încadrare
Nume Prenume
Cod numeric personal
reprezintă un cod compozit care conţine: primele 4 litere din departament, luna şi anul naşterii .
Adresa e-mail
Pana Adrian
Ionescu Bogdan
Ionescu Iuliana
Oancea Mirela
Gheorghe Mirela
Mares Valerica
Mihai Florin
Stanciu Andrei
Gavrila Alexandru
Nume Prenume
pana@ase.roionescu@ase.roionescu@ase.rooancea@ase.rogheorghe@ase.romares@ase.romihai@ase.rostanciua@ase.rogavrila@ase.ro
Adresa e-mail va fi compusă din numele cadrului didactic + caracterul "@" şi domeniul "ase.ro".Exemplu: pana@ase.ro
va fi compusă din numele cadrului didactic + caracterul "@" şi domeniul "ase.ro".
Denumire disciplinamicrosoft Excel 2007birotică profeSIOnalăsisteme informatice de GesTiuNebazele tehnologiei informaţieimaTEmatici aplicate in ECOnomieDoctrine Contemporane
Text în care primul caracter este majusculă, eliminindu-se spatiile nesemnificativemicrosoftExcel2007biroticăprofeSIOnalăsistemeinformaticedeGesTiuNebazeletehnologieiinformaţieimaTEmaticiaplicateinECOnomieDoctrineContemporane
Extragerea anului Extragerea lunii Extragerea zilei
Precizarea zilei din saptaminaPrecizarea numarului saptaminii
7111
Format personalizat :dddd dd mmmm yyyy è
Formulă ce returnează numărul trimestrului
8/29/20152015
829
Data calendaristica
Monday 09 November 2015Monday 18 May 2015
Monday 10 August 2015Sunday 08 March 2015
Formulă ce returnează numărul semestrului
Data lansării unei comenzi de fabricaţie a unui vapor es Fri 13 March 2015Numărul de zile necesar fabricaţiei 45
Fri 20 March 2015Fri 20 March 2015
Diferenţa:
Data livrării (fără weekend-uri şi s.l.)Data livrării (cu weekend-uri şi s.l.)
zile
Suma depusă într-un depozit la termen:Rata dobânzii (anuale):Perioada constituirii depozitului (cu capitalizare)
Nr. luni Friday 22 May 20156 luni Tuesday 22 November 2016
12 luni Sunday 22 May 201618 luni Tuesday 22 November 201624 luni Monday 22 May 2017
obs: Sa se formateze conditional luna si anul unei scadente care coincid cu luna curenta a anului curent
Câmp numit "Data_depozit"
50,000 lei 12%
6 luni
obs: Sa se formateze conditional luna si anul unei scadente care coincid cu luna curenta a anului curent
ç Data constituirii depozituluiç Data primei scadenţe (după 6 luni)ç Data celei de a 2-a scadenţe (după 12 luni)ç Data celei de a 3-a scadenţe (după 18 luni)ç Data celei de a 4-a scadenţe (după 24 luni)
Câmp numit "Data_depozit"
Wednesday 15/04/2015Thursday 14/05/2015
Data plecarii în concediuData revenirii din concediu
Număr de zile (lucrătoare) de concediu (fără weekend-uri) èNumăr de zile concediu (fără weekend-uri şi sărbători legale) è
Thursday 01/01/2015Friday 02/01/2015
22 Saturday 24/01/201521 Sunday 12/04/2015
Monday 13/04/2015Friday 01/05/2015
Sunday 31/05/2015Monday 01/06/2015
Saturday 15/08/2015Monday 30/11/2015Tuesday 01/12/2015
Friday 25/12/2015Saturday 26/12/2015
Câmp intitulat "Sarbatori"