{"id":1312,"date":"2023-07-04T21:24:06","date_gmt":"2023-07-04T19:24:06","guid":{"rendered":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/2023\/07\/04\/aplikace-pc-ve-vyuce-matematiky-a-statistiky\/"},"modified":"2023-07-04T21:24:06","modified_gmt":"2023-07-04T19:24:06","slug":"aplikace-pc-ve-vyuce-matematiky-a-statistiky","status":"publish","type":"post","link":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/2023\/07\/04\/aplikace-pc-ve-vyuce-matematiky-a-statistiky\/","title":{"rendered":"Aplikace PC ve v\u00fduce matematiky a statistiky"},"content":{"rendered":"

Josef Ko\u0161\u0165\u00e1lek<\/em>
V\u0160CHT Praha, \u00dastava ekonomiky a managementu, Praha<\/small><\/p>\n

P\u0159\u00edsp\u011bvek popisuje n\u011bkolik model\u016f vytvo\u0159en\u00fdch v MS Excelu, kter\u00e9 slou\u017e\u00ed pro podporu v\u00fduky st\u0159edo\u0161kolsk\u00e9 matematiky a vysoko\u0161kolsk\u00e9 statistiky. Konkr\u00e9tn\u011b se jedn\u00e1 o model, kam se vlo\u017e\u00ed d\u00e9lky t\u0159\u00ed stran troj\u00faheln\u00edku a v\u00fdstupem jsou v\u00fdpo\u010dty v\u0161ech d\u016fle\u017eit\u00fdch parametr\u016f takov\u00e9ho troj\u00faheln\u00edku: obsah, obvod, \u00fahly, d\u00e9lky v\u00fd\u0161ek a t\u011b\u017enic, velikosti kru\u017enice opsan\u00e9 a vepsan\u00e9. Ale hlavn\u011b je mo\u017en\u00e9 do modelu zadat, kter\u00e9 prvky se maj\u00ed zakreslit a n\u00e1sledn\u011b dojde k jejich grafick\u00e9mu zakreslen\u00ed v troj\u00faheln\u00edku. \u010cl\u00e1nek popisuje principy v\u00fdpo\u010dt\u016f a algoritmy pou\u017eit\u00e9 p\u0159i sestaven\u00ed modelu, pou\u017eit\u00ed modelu jako n\u00e1zorn\u00e9 pom\u016fcky p\u0159i v\u00fduce, ale tak\u00e9 jeho vyu\u017eit\u00ed jako n\u00e1stroje pro snadn\u00e9 generov\u00e1n\u00ed zad\u00e1n\u00ed s v\u00fdsledky, kde je jeho nasazen\u00ed efektivn\u011bj\u0161\u00ed, ne\u017e u programu GeoGebra. D\u00e1le \u010dl\u00e1nek popisuje model vytvo\u0159en\u00fd v MS Excelu, kde vstupem je tabulka hodnot (v\u00fdb\u011brov\u00fd soubor) a hladina v\u00fdznamnosti a v\u00fdstupem jsou v\u00fdsledky r\u016fzn\u00fdch druh\u016f parametrick\u00fdch test\u016f. Op\u011bt je mo\u017en\u00e9 vybrat si druh a modifikaci testu (st\u0159edn\u00ed hodnota, rozptyl, jedno v\u00fdb\u011brov\u00fd, dvou v\u00fdb\u011brov\u00fd, jednostrann\u00fd, oboustrann\u00fd). Automaticky se provede v\u00fdpo\u010det z\u00e1kladn\u00edch statistick\u00fdch charakteristik vlo\u017een\u00fdch hodnot a hlavn\u00edm v\u00fdstupem je hodnota testovac\u00edho krit\u00e9ria a kritick\u00e1 hodnota. Automaticky se nap\u00ed\u0161e v\u00fdsledek testu a hlavn\u011b se cel\u00e1 situace graficky zakresl\u00ed. Pokud je na vstupu zad\u00e1no m\u00e9n\u011b ne\u017e t\u0159icet hodnot, model automaticky identifikuje, \u017ee se jedn\u00e1 o mal\u00fd v\u00fdb\u011br a postupuje cestou v\u00fdpo\u010dt\u016f pro mal\u00e9 v\u00fdb\u011bry. Vyu\u017eit\u00ed p\u0159i v\u00fduce je hlavn\u011b v uk\u00e1zce zm\u011bny v\u00fdstup\u016f v z\u00e1vislosti na zm\u011bn\u011b vstup\u016f v\u010detn\u011b zm\u011bny grafick\u00e9ho v\u00fdstupu. Velk\u00fdm p\u0159\u00ednosem je mo\u017enost snadn\u00e9ho generov\u00e1n\u00ed neomezen\u00e9ho po\u010dtu r\u016fzn\u00fdch zad\u00e1n\u00ed s v\u00fdsledky a to pro pot\u0159eby p\u0159\u00edklad\u016f na procvi\u010den\u00ed i zad\u00e1n\u00ed do test\u016f. Op\u011bt jsou zde dob\u0159e patrn\u00e9 n\u011bkter\u00e9 v\u00fdhody oproti pou\u017eit\u00ed nap\u0159. statistick\u00e9ho SW Gretl. Vedlej\u0161\u00edm produktem obou model\u016f je uk\u00e1zka toho jak\u00fd potenci\u00e1l nab\u00edz\u00ed MS Excel. <\/p>\n","protected":false},"excerpt":{"rendered":"

Josef Ko\u0161\u0165\u00e1lekV\u0160CHT Praha, \u00dastava ekonomiky a managementu, Praha P\u0159\u00edsp\u011bvek popisuje n\u011bkolik model\u016f vytvo\u0159en\u00fdch v MS Excelu, kter\u00e9 slou\u017e\u00ed pro podporu v\u00fduky st\u0159edo\u0161kolsk\u00e9 matematiky a vysoko\u0161kolsk\u00e9 statistiky. Konkr\u00e9tn\u011b se jedn\u00e1 o model, kam se vlo\u017e\u00ed d\u00e9lky t\u0159\u00ed stran troj\u00faheln\u00edku a v\u00fdstupem jsou v\u00fdpo\u010dty v\u0161ech d\u016fle\u017eit\u00fdch parametr\u016f takov\u00e9ho troj\u00faheln\u00edku: obsah, obvod, \u00fahly, d\u00e9lky v\u00fd\u0161ek a t\u011b\u017enic, velikosti … Pokra\u010dovat ve \u010dten\u00ed „Aplikace PC ve v\u00fduce matematiky a statistiky“<\/span><\/a><\/p>\n","protected":false},"author":50,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-1312","post","type-post","status-publish","format-standard","hentry","category-prispevky-ucastniku"],"_links":{"self":[{"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/posts\/1312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/comments?post=1312"}],"version-history":[{"count":0,"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/posts\/1312\/revisions"}],"wp:attachment":[{"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/media?parent=1312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/categories?post=1312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/home.pf.jcu.cz\/~upvm\/2023\/index.php\/wp-json\/wp\/v2\/tags?post=1312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}