{"id":223,"date":"2023-07-05T12:59:27","date_gmt":"2023-07-05T12:59:27","guid":{"rendered":"https:\/\/dars-ishlanma.uz\/?p=223"},"modified":"2024-06-25T08:49:24","modified_gmt":"2024-06-25T03:49:24","slug":"ms-acces-2010-da-matematik-amallarni-bajarish","status":"publish","type":"post","link":"https:\/\/dars-ishlanma.uz\/ru\/ms-acces-2010-da-matematik-amallarni-bajarish\/","title":{"rendered":"\u0412\u042b\u041f\u041e\u041b\u041d\u0415\u041d\u0418\u0415 \u041c\u0410\u0422\u0415\u041c\u0410\u0422\u0418\u0427\u0415\u0421\u041a\u0418\u0425 \u0414\u0415\u0419\u0421\u0422\u0412\u0418\u0419 \u0412 MS ACCESS 2010"},"content":{"rendered":"\n<p><strong>Dars maqsadi:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u201cMS Acces da matematik amallar bajarish\u201d mavzusi nazariyasini o\u2019rganish<\/li>\n\n\n\n<li>O\u2019quvchilarda AS Acces da matematik amallardan foydalanish qobiliyatini rivojlantirish, olgan bilimlarni amalda qo\u2019llash ko\u2019nikmasini o\u2019stirish.<\/li>\n<\/ul>\n\n\n\n<p><strong>Dars turi: Kombinatsiyalashtirilgan dars.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ko\u2019rgazmali qurollar va tarqatmali vositalar:<\/li>\n\n\n\n<li>Kompyuter;<\/li>\n\n\n\n<li>Video proyektor;<\/li>\n\n\n\n<li>Mavzusida mos tayyorlangan test savollari;<\/li>\n\n\n\n<li>O\u2019tilgan mavzuni mustahkamlash uchun tarqatmalar;<\/li>\n\n\n\n<li>Uy vazifasi uchun tarqatmali vositalar.<\/li>\n<\/ul>\n\n\n\n<p><strong>Dars rejasi:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>Tashkiliy qism (1 min.)<\/li>\n\n\n\n<li>O\u2019tgan mavzuni (mustahkamlash) tekshirish&nbsp; (10 min.)<\/li>\n\n\n\n<li>Yangi mavzuni o\u2019rganish (20 min.)<\/li>\n\n\n\n<li>O\u2019tilgan mavzuni mustahkamlash ( 5 min.)<\/li>\n\n\n\n<li>Dars yuzasidan xulosa (2 min.)<\/li>\n\n\n\n<li>Uyga vazifa berish (2 min.)<\/li>\n<\/ol>\n\n\n\n<p><strong>Darsning borishi<\/strong><\/p>\n\n\n\n<p><strong>1. Tashkiliy qism.<\/strong><\/p>\n\n\n\n<p><strong>Maqsad:<\/strong> o\u2019quvchilarni darsga tayyorlash.<\/p>\n\n\n\n<p>Dars mavzusi e\u2019lon qilinadi. O\u2019quvchilar oldiga vazifa qo\u2019yiladi: ma\u2019lumotlar ombori va ularni tashkil etish haqida gapirib berish.<\/p>\n\n\n\n<p><strong>2. O\u2019tgan mavzuni mustahkamlash.<\/strong><\/p>\n\n\n\n<p>\u201cTa\u2019limiy Test\u201d dasturi yordamida avval otilgan mavzularga oid test sinovi o\u2019tkazish<\/p>\n\n\n\n<p><strong>3. Yangi mavzuni o\u2019rganish.<\/strong><\/p>\n\n\n\n<p>O\u2019rganish uchun savollar:<\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>MS Acces 210 dasturini ishga tushirish va yangi ma\u2019lumotlar omborini taskil etish.<\/li>\n\n\n\n<li>MS Acces 210 dasturida matematik amallardan foydalanish.<\/li>\n<\/ol>\n\n\n\n<p>MS Access 2010 da ma\u2019lumotlar omborini hosil qilib, ular ustida ba\u2019zi \u2013 bir matematik hisob \u2013 kitob ishlarini amalga oshirishimizga to\u2018g\u2018ri keladi. Ushbu&nbsp; ishlarni&nbsp; amalga&nbsp; oshirish&nbsp; matematik&nbsp; va&nbsp; statistik&nbsp; funksiyalar yordamida&nbsp; amalga&nbsp; oshiriladi.&nbsp; Matematik&nbsp; hisob&nbsp; ishlarini&nbsp; <strong>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435<\/strong> menyusining&nbsp; <strong>\u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440&nbsp; \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432<\/strong>&nbsp; bo\u2018limi&nbsp; orqali&nbsp; amalga&nbsp; oshirishimiz mumkin.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"118\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/konstruktor-1.png\" alt=\"\" class=\"wp-image-226\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/konstruktor-1.png 607w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/konstruktor-1-300x58.png 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/figure>\n<\/div>\n\n\n<p>MS Acces 2010 da ham MS Excel 2010&nbsp; kabi matematik va munosabat amallari,&nbsp; matematik&nbsp; va&nbsp; statistik&nbsp; funksiyalardan,&nbsp; mantiqiy&nbsp; amallardan foydalanish imkoniyatlari mavjud.<\/p>\n\n\n\n<p><strong>MS Access 2010 dasturida matematik amallar<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u2116<\/strong><\/td><td><strong>Belgi<\/strong><\/td><td><strong>Vazifasi<\/strong><\/td><\/tr><tr><td><strong>1<\/strong><\/td><td><strong>+<\/strong><\/td><td>Qo\u2019shish<\/td><\/tr><tr><td><strong>2<\/strong><\/td><td><strong>&#8211;<\/strong><\/td><td>Ayrish<\/td><\/tr><tr><td><strong>3<\/strong><\/td><td><strong>*<\/strong><\/td><td>Ko\u2019paytirish<\/td><\/tr><tr><td><strong>4<\/strong><\/td><td><strong>\/<\/strong><\/td><td>Bo\u2019lish<\/td><\/tr><tr><td><strong>5<\/strong><\/td><td><strong>^<\/strong><\/td><td>Darajaga oshirish<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>MS Access 2010 da matematik munosabat amallari<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u2116<\/strong><\/td><td><strong>Belgi<\/strong><\/td><td><strong>Vazifasi<\/strong><\/td><\/tr><tr><td><strong>1<\/strong><\/td><td><strong>&gt;&nbsp;<\/strong><\/td><td>Katta<\/td><\/tr><tr><td><strong>2<\/strong><\/td><td><strong>&lt;&nbsp;<\/strong><\/td><td>Kichik<\/td><\/tr><tr><td><strong>3<\/strong><\/td><td><strong>=<\/strong><\/td><td>Teng<\/td><\/tr><tr><td><strong>4<\/strong><\/td><td><strong>&gt;=<\/strong><\/td><td>Katta yoki teng<\/td><\/tr><tr><td><strong>5<\/strong><\/td><td><strong>&lt;=<\/strong><\/td><td>Kichik yoki teng<\/td><\/tr><tr><td><strong>6<\/strong><\/td><td><strong>&lt;<\/strong><strong> <\/strong><strong>&gt;<\/strong><\/td><td>Teng emas<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>MS Access 2010 da matematik funksiyalar<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u2116<\/strong><\/td><td><strong>Funksiya<\/strong><\/td><td><strong>Vazifasi<\/strong><\/td><\/tr><tr><td><strong>1<\/strong><\/td><td><strong>ABS<\/strong><\/td><td>Sonning modulini hisoblaydi<\/td><\/tr><tr><td><strong>2<\/strong><\/td><td><strong>SQR<\/strong><\/td><td>Sonni kvadrat ildizini hisoblaydi<\/td><\/tr><tr><td><strong>3<\/strong><\/td><td><strong>COS<\/strong><\/td><td>Sonni cosinusini hisoblaydi<\/td><\/tr><tr><td><strong>4<\/strong><\/td><td><strong>SIN<\/strong><\/td><td>Sonni sinusinusini hisoblaydi<\/td><\/tr><tr><td><strong>5<\/strong><\/td><td><strong>TAN<\/strong><\/td><td>Sonni tangnsini hisoblaydi<\/td><\/tr><tr><td><strong>6<\/strong><\/td><td><strong>ATN<\/strong><\/td><td>Sonni arktangnsini hisoblaydi<\/td><\/tr><tr><td><strong>7<\/strong><\/td><td><strong>LOG<\/strong><\/td><td>Sonni logarifmini hisoblaydi<\/td><\/tr><tr><td><strong>8<\/strong><\/td><td><strong>RND<\/strong><\/td><td>0 va 1 oraliqdagi istalgan sonni tanlab olish<\/td><\/tr><tr><td><strong>9<\/strong><\/td><td><strong>INT<\/strong><\/td><td>Haqiqiy sonni butun qismini olish<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>MS Access 2010 da statistik funksiyalar<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>\u2116<\/strong><\/td><td><strong>Funksiya<\/strong><\/td><td><strong>Vazifasi<\/strong><\/td><\/tr><tr><td><strong>1<\/strong><\/td><td><strong>NOT<\/strong><\/td><td>Inkor<\/td><\/tr><tr><td><strong>2<\/strong><\/td><td><strong>AND<\/strong><\/td><td>Va<\/td><\/tr><tr><td><strong>3<\/strong><\/td><td><strong>OR<\/strong><\/td><td>Yoki<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>1-mashq.<\/strong>&nbsp; Uchta&nbsp; ustunda&nbsp; berilgan&nbsp; sonlarning&nbsp; yig\u2018indisini&nbsp; to\u2018rtinchi ustunga hosil qiling.<\/p>\n\n\n\n<p><strong>Bajarish:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>jadval quyidagicha hosil qilinadi:<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"361\" height=\"125\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/jadval.png\" alt=\"\" class=\"wp-image-227\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/jadval.png 361w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/jadval-300x104.png 300w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>hosil qilingan jadvalni <strong>\u201cQo\u2018shish\u201d<\/strong> nomi bilan saqlaymiz;<\/li>\n\n\n\n<li>saqlangan jadvalni yuklanadi va quyidagi tartibda to\u2018ldiriladi:<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"190\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/qoshish.png\" alt=\"\" class=\"wp-image-228\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/qoshish.png 495w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/qoshish-300x115.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>to\u2018ldirilgan&nbsp; jadvalni&nbsp; yopib,&nbsp; menyular&nbsp; satridan&nbsp; <strong>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u044f-\u041a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u043e\u0440 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432<\/strong> ketma-ketligi tanlanadi;<\/li>\n\n\n\n<li>\u201cQo\u2018shish\u201d nomli jadval belgilanadi va \u0414\u043e\u0431\u0430\u0432\u0438\u0442\u044c tugmasi bosiladi.<\/li>\n\n\n\n<li>ishchi oynani quyidagicha to\u2018ldiramiz:<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"98\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/zapros.png\" alt=\"\" class=\"wp-image-229\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/zapros.png 680w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/zapros-300x43.png 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>jadvalning&nbsp; navbatdagi&nbsp; ustunga&nbsp; sichqonchaning&nbsp; o\u2018ng&nbsp; tugmasini&nbsp; bosib kontekst menyudan <strong>\u043f\u043e\u0441\u0442\u0440\u043e\u0438\u0442\u044c<\/strong> bandi tanlanadi:<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"158\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/postroit.png\" alt=\"\" class=\"wp-image-230\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/postroit.png 744w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/postroit-300x64.png 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>hosil&nbsp; bo\u2018lgan&nbsp; oyna&nbsp; ikki&nbsp; qismdan&nbsp; iborat&nbsp; bo\u2018lib,&nbsp; birinchi&nbsp; oynada matematik&nbsp;&nbsp;&nbsp; hisob&nbsp; ishlarining&nbsp; formulalari&nbsp; kiritiladi.&nbsp; Ikkinchi&nbsp; oynada matematik,&nbsp; statistik&nbsp; funksiyalar&nbsp; va&nbsp;&nbsp;&nbsp; mantiqiy&nbsp; amallarni&nbsp; qo\u2018llash&nbsp; usullari beriladi.&nbsp; Berilgan&nbsp; uchta&nbsp; ustundagi&nbsp; sonlarning&nbsp; yig\u2018indisi&nbsp; uchunchi&nbsp; ustunda hosil&nbsp; qilish&nbsp; uchun&nbsp; birinchi&nbsp; oynaga&nbsp; quyidagi&nbsp; kodni&nbsp; kiritamiz:&nbsp;&nbsp;&nbsp; A+B+C: [A]+[B]+[C]<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"492\" height=\"413\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/virajeniya.png\" alt=\"\" class=\"wp-image-231\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/virajeniya.png 492w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/virajeniya-300x252.png 300w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>bajarilgan amallarni \u201cSonlarni qo\u2018shish\u201d nomi bilan saqlab, jadvalni yuklasak, quyidagi ko\u2018rinish hosil bo\u2018ladi:<\/li>\n\n\n\n<li>&nbsp;<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"706\" height=\"191\" src=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/sonlarni-qoshish.png\" alt=\"\" class=\"wp-image-232\" srcset=\"https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/sonlarni-qoshish.png 706w, https:\/\/dars-ishlanma.uz\/wp-content\/uploads\/2023\/07\/sonlarni-qoshish-300x81.png 300w\" sizes=\"auto, (max-width: 706px) 100vw, 706px\" \/><\/figure>\n<\/div>\n\n\n<p>Ushbu jadvalning uchta ustunidagi sonlarning yig\u2018indisi to\u2018rtinchi ustunda aks etgan.<\/p>\n\n\n\n<p><strong>4. O\u2019tilgan mavzuni mustahkamlash<\/strong><\/p>\n\n\n\n<p>Mavzuni mustahkamlash uchun o\u2019quvchilarga darslikdagi mavzuga oid savollardan iborat tarqatma tarqatiladi.&nbsp; &nbsp;<\/p>\n\n\n\n<p><strong>5. Dars yuzasidan xulosa<\/strong><\/p>\n\n\n\n<p>Aytigchi, bugungi dars sizlarga tushunarli bo\u2019ldimi?<\/p>\n\n\n\n<p>Darsda ko\u2019proq nima esingizda qoldi?<\/p>\n\n\n\n<p><strong>6. Uyga vaziva berish<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\" style=\"list-style-type:1\">\n<li>Darslikda berilgan mavzuga oid 1,2 \u2013 mashqlarni bajarish<\/li>\n\n\n\n<li>Quyidagi savollar javobini o\u2019rganish:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>MS Access 2010 da qanday matematik amallari mavjud?<\/li>\n\n\n\n<li>MS Access 2010 da qanday munosabat amallari mavjud?<\/li>\n\n\n\n<li>MS Access 2010 da matematik funksiyalarni yozing.<\/li>\n\n\n\n<li>MS Access 2010 da statistik funksiyalarni yozing.<\/li>\n\n\n\n<li>MS Access 2010 da mantiqiy amallarni yozing.<\/li>\n\n\n\n<li>Berilgan&nbsp; to\u2018rtta&nbsp; sonning&nbsp; ko\u2018paytmasini&nbsp; hisoblovchi&nbsp; jadval&nbsp; hosil<\/li>\n\n\n\n<li>qiling.<\/li>\n\n\n\n<li>Ustundagi sonlarning ildizini hisoblovchi jadval hosil qiling.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-white-color has-vivid-green-cyan-background-color has-text-color has-background wp-element-button\">Fayl sifatida yuklab olish<\/a><\/div>\n<\/div>\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>\n","protected":false},"excerpt":{"rendered":"<p>\u0412\u042b\u041f\u041e\u041b\u041d\u0415\u041d\u0418\u0415 \u041c\u0410\u0422\u0415\u041c\u0410\u0422\u0418\u0427\u0415\u0421\u041a\u0418\u0425 \u0414\u0415\u0419\u0421\u0422\u0412\u0418\u0419 \u0412 MS ACCESS 2010<\/p>","protected":false},"author":1,"featured_media":238,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-223","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dars-ishlanma"],"_links":{"self":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/223","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=223"}],"version-history":[{"count":5,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"predecessor-version":[{"id":1234,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/posts\/223\/revisions\/1234"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/media\/238"}],"wp:attachment":[{"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dars-ishlanma.uz\/ru\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}