{"id":31,"date":"2023-06-28T05:58:51","date_gmt":"2023-06-28T05:58:51","guid":{"rendered":"http:\/\/dars-ishlanma.uz\/?p=31"},"modified":"2024-06-25T09:23:08","modified_gmt":"2024-06-25T04:23:08","slug":"malumotlarni-tartiblash-va-saralash-mavzusini-takrorlash","status":"publish","type":"post","link":"https:\/\/dars-ishlanma.uz\/ru\/malumotlarni-tartiblash-va-saralash-mavzusini-takrorlash\/","title":{"rendered":"\u041e\u0411\u0417\u041e\u0420 \u0422\u0415\u041c\u042b \u041e\u0420\u0413\u0410\u041d\u0418\u0417\u0410\u0426\u0418\u042f \u0418 \u041a\u0410\u0422\u0415\u0413\u041e\u0420\u0418\u0417\u0410\u0426\u0418\u042f \u0418\u041d\u0424\u041e\u0420\u041c\u0410\u0426\u0418\u0418"},"content":{"rendered":"<p><strong>Dars maqsadi:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:lower-alpha\">\n<li>Ta\u2019limiy: O\u2019quvchilarga electron jadvalda hujjatlarni tartiblash va saralashni o\u2019rgatish;<\/li>\n\n\n\n<li>Tarbiyaviy: O\u2019quvchilarni vatanga sodiq va fidoiy qilib tarbiyalash, milliy va umummadaniy qadriyatlarimiz asosida tarbiyalash;<\/li>\n\n\n\n<li>Rivojlantiruvchi: O\u2019quvchilarda electron jadvalda ma\u2019lumotlarni tartiblash va saralash bo\u2019yicah bilim, ko\u2019nikma, malakasini rivojlantirish.<\/li>\n<\/ol>\n\n\n\n<p>Darsning borishi:<\/p>\n\n\n\n<p>Tashkiliy qism:<\/p>\n\n\n\n<p>Salomlashish:<\/p>\n\n\n\n<p>Davomatni aniqlash:<\/p>\n\n\n\n<p>Siyosiy daqiqa (Bugungi kun axborot va texnologiya yangiliklari)<\/p>\n\n\n\n<p><strong>Yangi mavzu bayoni: O\u2019quvchilar kompyuterda o\u2019tiradi va berilgan vazifalarni bajaradi.<\/strong><\/p>\n\n\n\n<p><strong>1-mashq.<\/strong><\/p>\n\n\n\n<p>7 ta sinfdoshingizning ismi va familiyasi yozilgan jadvaldan avval \u201cA\u201d harfidan boshlanadigan familiyalarni, so\u2019ngra ismi \u201ca\u201d harfi bilan tugaydiganlarini saralang.<\/p>\n\n\n\n<p><strong>Mashqni bajarish tartibi:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>Dastlab MS Excell dasturini ishga tushiramiz;<\/li>\n\n\n\n<li>Dasturning jadval maydonida berilgan mashq shartidan kelib chiqib kerakli jadvalni hosil qilamiz;<\/li>\n\n\n\n<li>Tasmasimon menyular satrida \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limiga o\u2019tamiz;<\/li>\n\n\n\n<li>\u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limining \u201cTartiblash va saralash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u0438 \u0444\u0438\u043b\u0442\u0440) bandidan \u0424\u0438\u043b\u0442\u0440 tugmasini bosamiz, natijada ustunlar boshida maxsus tugmachalar paydo bo\u2019ladi;<\/li>\n\n\n\n<li>Tugmachalardan foydalanib kerakli shartlar asosida ma\u2019lumotlarni saralash mumkin;<\/li>\n\n\n\n<li>Buning uchun tugmacha bosiladi va \u201cMatnlar uchun saralash\u201d (\u0422\u0435\u043a\u0441\u0442\u043e\u0432\u044b\u0435 \u0444\u0438\u043b\u044c\u0442\u0440\u044b) buyrug\u2019idan foydalaniladi.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"740\" height=\"621\" src=\"http:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/filtr.png\" alt=\"\" class=\"wp-image-32\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/filtr.png 740w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/filtr-300x252.png 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"408\" src=\"http:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/filtr2-1.png\" alt=\"\" class=\"wp-image-34\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/filtr2-1.png 473w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/filtr2-1-300x259.png 300w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><\/figure>\n<\/div>\n\n\n<p><strong>2-mashq.<\/strong><\/p>\n\n\n\n<p>Sinfdoshlaringizdan beshtasining familiyasi, ismi, tug\u2019ilgan yili, joriy yil, yoshi qatnashgan \u201cSinfdosh\u201d nomli jadval tuzing va formatlang. Shu jadvalni quyidagi xususiyatlardan birortasi orqali tartiblang:<\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:lower-alpha\">\n<li>familiyalarni o\u2019sish yoki kamayish yo\u2019nalishida;<\/li>\n\n\n\n<li>tug\u2019ilgan yillarni o\u2019sish yoki kamayish yo\u2018nalishida.<\/li>\n<\/ol>\n\n\n\n<p><strong>Mashqni bajarish tartibi:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>Dastlab MS Excell dasturini ishga tushiramiz;<\/li>\n\n\n\n<li>Dasturning jadval maydonida berilgan mashq shartidan kelib chiqib, kerakli jadvalni hosil qilamiz;<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"468\" src=\"http:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/1-mashq.png\" alt=\"\" class=\"wp-image-35\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/1-mashq.png 936w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/1-mashq-300x150.png 300w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/1-mashq-768x384.png 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<p>3. Tasmasimon menyular satrida \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limiga o\u2019tamiz;<\/p>\n\n\n\n<p>4. \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limining \u201cTartiblash va saralash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u0438 \u0444\u0438\u043b\u0442\u0440) bandidan \u201cTartiblash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430) tugmasini bosamiz, natijada muloqot oynasi ochiladi. Undan kerakli ustun va kerakli yo\u2019nalishni tanlaymiz;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"275\" src=\"http:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash.png\" alt=\"\" class=\"wp-image-36\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash.png 786w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash-300x105.png 300w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash-768x269.png 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><\/figure>\n<\/div>\n\n\n<p><strong>3-mashq.<\/strong><\/p>\n\n\n\n<p>O\u2019tgan chorakda barcha fanlardan o\u2019zlashtirishingizni aks ettiruvchi jadval tuzing. Jadvaldagi ma\u2019lumotlarni: fanlar nomini o\u2019sish yo\u2019nalishida, baholarni esa kamayish yo\u2019nalishida tartiblang. Olingan natijalarga asosan qaysi fandan ijobiy natijaga erishganingizni ifodalovchi jadvalni filtrlash amali yordamida ajratib saqlang.<\/p>\n\n\n\n<p><strong>Mashqni bajarish tartibi:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>Dastlab MS Excell dasturini ishga tushiramiz;<\/li>\n\n\n\n<li>Dasturning jadval maydonida berilgan mashq shartidan kelib chiqib, kerakli jadvalni hosil qilamiz;<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"673\" height=\"428\" src=\"http:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash2.png\" alt=\"\" class=\"wp-image-37\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash2.png 673w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash2-300x191.png 300w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><\/figure>\n<\/div>\n\n\n<p>3. Tasmasimon menyular satrida \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limiga o\u2019tamiz;<\/p>\n\n\n\n<p>4. \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limining \u201cTartiblash va saralash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u0438 \u0444\u0438\u043b\u0442\u0440) bandidan \u201cTartiblash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430) tugmasini bosamiz, natijada muloqot oynasi ochiladi. Undan kerakli ustun va kerakli yo\u2019nalishni tanlaymiz;<\/p>\n\n\n\n<p><strong>4-masq.<\/strong><\/p>\n\n\n\n<p>Oilangiz har bir a\u2019zosining 10 kunlik suv sarfini va umumiy sarflangan suv hajmini aks ettiruvchi jadval tuzing. Jadvaldagi ma\u2019lumotlarni avval qarindoshlik darajasini ko\u2019rsatuvchi xususiyat (ota, ona, aka, uka, opa, singil va boshqalar), keyin suv sarfi bo\u2018yicha tartiblang. Suv sarfiga chegara oling va shu shart bo\u2019yicha filtrlab alohida saqlang.<\/p>\n\n\n\n<p><strong>Mashqni bajarish tartibi:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>Dastlab MS Excell dasturini ishga tushiramiz;<\/li>\n\n\n\n<li>Dasturning jadval maydonida berilgan mashq shartidan kelib chiqib, kerakli jadvalni hosil qilamiz;\\<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"498\" src=\"http:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash3.png\" alt=\"\" class=\"wp-image-38\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash3.png 773w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash3-300x193.png 300w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/tartiblash3-768x495.png 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/figure>\n<\/div>\n\n\n<p>3. Tasmasimon menyular satrida \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limiga o\u2019tamiz;<\/p>\n\n\n\n<p>4. \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limining \u201cTartiblash va saralash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u0438 \u0444\u0438\u043b\u0442\u0440) bandidan \u201cTartiblash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430) tugmasini bosamiz, natijada muloqot oynasi ochiladi. Undan kerakli ustun va kerakli yo\u2019nalishni tanlaymiz;<\/p>\n\n\n\n<p><strong>5-masq.<\/strong><\/p>\n\n\n\n<p>Berilgan a, b, d qiymatlarga mos A, B, D kvadratlarning yuzini hisoblash jadvalini tuzing. Natijaviy qiymatlarni o\u2018sish yo\u2018nalishida saralang.<\/p>\n\n\n\n<p><strong>Mashqni bajarish tartibi:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>Dastlab MS Excell dasturini ishga tushiramiz;<\/li>\n\n\n\n<li>Dasturning jadval maydonida berilgan mashq shartidan kelib chiqib, kerakli jadvalni hosil qilamiz;<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"732\" height=\"491\" src=\"http:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/amaliy.png\" alt=\"\" class=\"wp-image-39\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/amaliy.png 732w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/06\/amaliy-300x201.png 300w\" sizes=\"auto, (max-width: 732px) 100vw, 732px\" \/><\/figure>\n<\/div>\n\n\n<p>3. Tasmasimon menyular satrida \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limiga o\u2019tamiz;<\/p>\n\n\n\n<p>4. \u201cMa\u2019lumotlar\u201d (\u0414\u0430\u043d\u043d\u044b\u0435) bo\u2019limining \u201cTartiblash va saralash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u0438 \u0444\u0438\u043b\u0442\u0440) bandidan \u201cTartiblash\u201d (\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430) tugmasini bosamiz, natijada muloqot oynasi ochiladi. Undan kerakli ustun va kerakli yo\u2019nalishni tanlaymiz;<\/p>\n\n\n\n<p><strong>Yangi mavzuni mustahkamlash:<\/strong> O\u2019quvchilar baholarni kundaliklariga qo\u2019yish<\/p>\n\n\n\n<p><strong>Uyga vazifa:<\/strong> Yangi mavzuga tayyorgarlik ko\u2019rish va 6-7- mashqlarni mustaql bajarish.<\/p>\n\n\n\n<!-- Yandex.RTB R-A-2562262-5 -->\n<div id=\"yandex_rtb_R-A-2562262-5\"><\/div>\n<script>window.yaContextCb.push(()=>{\n\tYa.Context.AdvManager.render({\n\t\t\"blockId\": \"R-A-2562262-5\",\n\t\t\"renderTo\": \"yandex_rtb_R-A-2562262-5\"\n\t})\n})\n<\/script>","protected":false},"excerpt":{"rendered":"<p>Dars maqsadi: Darsning borishi: Tashkiliy qism: Salomlashish: Davomatni aniqlash: Siyosiy daqiqa (Bugungi kun axborot va texnologiya yangiliklari) Yangi mavzu bayoni: O\u2019quvchilar kompyuterda o\u2019tiradi va berilgan vazifalarni bajaradi. 1-mashq. 7 ta sinfdoshingizning ismi va familiyasi yozilgan jadvaldan avval \u201cA\u201d harfidan boshlanadigan familiyalarni, so\u2019ngra ismi \u201ca\u201d harfi bilan tugaydiganlarini saralang. Mashqni bajarish tartibi: 2-mashq. Sinfdoshlaringizdan beshtasining familiyasi, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":41,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4,5,6],"class_list":["post-31","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dars-ishlanma","tag-filtrlash","tag-saralash","tag-trtiblash"],"_links":{"self":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":4,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":1245,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/31\/revisions\/1245"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/media\/41"}],"wp:attachment":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/tags?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}