{"id":1323804,"date":"2020-12-14T02:16:47","date_gmt":"2020-12-14T07:16:47","guid":{"rendered":"https:\/\/gijn.org\/?p=1323804"},"modified":"2024-02-11T02:18:00","modified_gmt":"2024-02-11T07:18:00","slug":"veri-analizi-elektronik-tablolar","status":"publish","type":"post","link":"https:\/\/gijn.org\/tr\/kaynak\/veri-analizi-elektronik-tablolar\/","title":{"rendered":"Veri Analizi- Elektronik Tablolar"},"content":{"rendered":"<p><a href=\"https:\/\/gijn.org\/analyzing-data-spreadsheets\/\" target=\"_blank\" rel=\"noopener\"><strong>Gijn<\/strong><\/a><\/p>\n<p>Elektronik tablolar genellikle gazetecilerin kullanmay\u0131 \u00f6\u011frendi\u011fi ilk veri arac\u0131d\u0131r. Csv dosyalar\u0131 gibi yap\u0131land\u0131r\u0131lm\u0131\u015f verileri temizlemek ve analiz etmek i\u00e7in kullan\u0131\u015fl\u0131 bir ara\u00e7t\u0131r. Microsoft Excel ve Google E-Tablolar en yayg\u0131n kullan\u0131lan elektronik tablolar. A\u015fa\u011f\u0131da, Excel&#8217;de gezinmenize ve elektronik tablo becerilerinizi geli\u015ftirmenize yard\u0131mc\u0131 olacak baz\u0131 kaynaklar bulunmakta.<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"http:\/\/mjwebster.github.io\/DataJ\/BeginnerExcel.html\"><strong>Veri Gazetecili\u011fi E\u011fitimi: Temel Excel<\/strong><\/a>\u00a0 gazeteci\u00a0 MaryJo Webster taraf\u0131ndan haz\u0131rlanan e\u011fitim animasyon ekran g\u00f6r\u00fcnt\u00fcler ile temel excel fonksiyonlar\u0131n\u0131 nas\u0131l kullanabilece\u011finizi \u00f6rneklerle i\u015fliyor.\u00a0 PC kullan\u0131c\u0131lar\u0131 hedef kitle olsa da MC kullan\u0131c\u0131lar\u0131 da rahatl\u0131kla yararlanabilir.<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/www.coursera.org\/\"><strong>Coursera<\/strong><\/a><strong>\u00a0<\/strong>ve\u00a0<strong><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/www.edx.org\/\">edX<\/a><\/strong>\u00a0 veri analizi i\u00e7in Excel kullan\u0131m\u0131n\u0131 \u00fccretsiz sunan olduk\u00e7a pratik e\u011fitimler sa\u011fl\u0131yor.\u00a0 Hedef kitle sadece gazetecileri kapsamasa da olduk\u00e7a faydal\u0131 e\u011fitimleri kaps\u0131yor.<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/leanpub.com\/spreadsheetstories\/\"><strong>E-tablolarda haber bulma<\/strong><\/a><strong>k<\/strong> gazeteci\u00a0 Paul Bradshaw\u00a0 veri gazetecili\u011fine yeni ba\u015flayanlar i\u00e7in \u00f6nemli bir e\u011fitim sunuyor. E-tablolarla \u00e7al\u0131\u015f\u0131rken haber de\u011feri ta\u015f\u0131yan veri setlerini se\u00e7menin y\u00f6ntemlerini anlat\u0131yor.<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/edu.gcfglobal.org\/en\/excel2016\/\"><strong>GFCGlobal<\/strong><\/a><strong>\u00a0<\/strong>\u00a0Excel&#8217;de \u00f6zet tablolar, grafikler, filtreleme, s\u0131ralama ve daha pek \u00e7ok \u00f6zelli\u011fi \u00f6\u011frenebilirsiniz. E\u011fitimlerin sonunda testler de yer al\u0131yor.<\/p>\n<p><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/www.mrexcel.com\/\"><strong>Mr Excel<\/strong>\u00a0<\/a>\u00a0 Bill Jelen taraf\u0131ndan 1998 tarihinden beridir\u00a0 tavsiyeler ve ipu\u00e7lar\u0131n yer ald\u0131\u011f\u0131 \u00f6nemli bir Excel soru bankas\u0131 sitesi.<\/p>\n<p><strong><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/www.ewa.org\/reporter-guide\/reporters-guide-excel\">Haberciler \u0130\u00e7in Excel Rehberi<\/a>\u00a0<\/strong> \u00a0gazetecilerin Excel&#8217;de etkin \u015fekilde \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayan kapsay\u0131c\u0131 bir rehber kaynak.\u00a0 \u00d6zet tablolar, veri temizleme y\u00f6ntemleri ad\u0131m ad\u0131m anlat\u0131l\u0131yor.<\/p>\n<p><strong><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/datajournalism.com\/read\/longreads\/spreadsheets-for-journalism\">Gazeteciler i\u00e7in e-tablolar<\/a>\u00a0<\/strong>gazetecilik profes\u00f6r\u00fc Brant Houston taraf\u0131ndan\u00a0 haz\u0131rlanan\u00a0 e\u011fitim veri analizine h\u0131zl\u0131 \u015fekilde giri\u015f yapmay\u0131 sa\u011fl\u0131yor.<\/p>\n<p>VOYD&#8217;un <strong><a rel=\"noopener\" target=\"_blank\" href=\"https:\/\/veribulteni.voyd.org.tr\/4-1-google-e-tablo-ile-veri-analizi\/\">temel veri e\u011fitiminden <\/a><\/strong>de yararlanmak m\u00fcmk\u00fcn.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gijn Elektronik tablolar genellikle gazetecilerin kullanmay\u0131 \u00f6\u011frendi\u011fi ilk veri arac\u0131d\u0131r. Csv dosyalar\u0131 gibi yap\u0131land\u0131r\u0131lm\u0131\u015f verileri temizlemek ve analiz etmek i\u00e7in kullan\u0131\u015fl\u0131 bir ara\u00e7t\u0131r. Microsoft Excel ve Google E-Tablolar en yayg\u0131n kullan\u0131lan elektronik tablolar. A\u015fa\u011f\u0131da, Excel&#8217;de gezinmenize ve elektronik tablo becerilerinizi geli\u015ftirmenize yard\u0131mc\u0131 olacak baz\u0131 kaynaklar bulunmakta. Veri Gazetecili\u011fi E\u011fitimi: Temel Excel\u00a0 gazeteci\u00a0 MaryJo Webster taraf\u0131ndan [&hellip;]<\/p>\n","protected":false},"author":3031180,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_price":"","_stock":"","_tribe_ticket_header":"","_tribe_default_ticket_provider":"","_tribe_ticket_capacity":"0","_ticket_start_date":"","_ticket_end_date":"","_tribe_ticket_show_description":"","_tribe_ticket_show_not_going":false,"_tribe_ticket_use_global_stock":"","_tribe_ticket_global_stock_level":"","_global_stock_mode":"","_global_stock_cap":"","_tribe_rsvp_for_event":"","_tribe_ticket_going_count":"","_tribe_ticket_not_going_count":"","_tribe_tickets_list":"[]","_tribe_ticket_has_attendee_info_fields":false,"republication-tracker-tool-hide-widget":false,"footnotes":"","_tec_slr_enabled":"","_tec_slr_layout":""},"categories":[23204,23200],"tags":[],"gijn_topic":[18925],"series":[],"gijn_language":[],"gijn_region":[],"class_list":["post-1323804","post","type-post","status-publish","format-standard","hentry","category-ipucu-sayfasi","category-kaynak","gijn_topic-veri-gazeteciligi"],"acf":[],"ticketed":false,"_links":{"self":[{"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/posts\/1323804","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/users\/3031180"}],"replies":[{"embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/comments?post=1323804"}],"version-history":[{"count":1,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/posts\/1323804\/revisions"}],"predecessor-version":[{"id":1323805,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/posts\/1323804\/revisions\/1323805"}],"wp:attachment":[{"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/media?parent=1323804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/categories?post=1323804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/tags?post=1323804"},{"taxonomy":"gijn_topic","embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/gijn_topic?post=1323804"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/series?post=1323804"},{"taxonomy":"gijn_language","embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/gijn_language?post=1323804"},{"taxonomy":"gijn_region","embeddable":true,"href":"https:\/\/gijn.org\/tr\/wp-json\/wp\/v2\/gijn_region?post=1323804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}