krebsiTi cxrilebi da diagramebi

        Tema 6

618 

  gakveTili 18   monacemebis analizi: krebsiTi cxrili da   diagramebi      ‹‹         

? 

1 

kiTxvebi da testebi

√

2

pasuxebi testebze damatebiTi literatura

 

pedagogis konsultacia

                       

5

?  savarjiSoebi

3

√

4

pasuxebi savarjiSoebze

monacemebis analizi. krebsiTi cxrilebi da diagramebi krebsiTi cxrilebi da diagramebi gamoiyeneba sxvadasxva sirTulis da moculobis monacemebis interaqtiuli analizisTvis. aseT cxrilebSi monacemebi dajgufebulia da dajamebuli mravali niSan-TvisebiT. maTSi SesaZlebelia ara marto dajameba, aramed saSualo ariTmetikulis, minimaluri, maqsimaluri da sxva mniSvnelobebis gamoTvla. aseTi cxrilebis wyaroT SeiZleba gamoyenebul iqnes cxrili, moTxovna, forma. ganvixiloT dinamiuri cxrilis analizis magaliTi. amisaTvis gamoviyenoT cxrili tblStudentebis_sia monacemTa bazidan Magistratura(0203weli12kursi1semestri).mdb. cxrilSi davTvaloT studentebis raodenoba fakultetebze, specialobebze, maT Soris fasianebis da sabiujeto pirvel da meore kursis WrilSi. gaxseniT monacemTa baza da gaxseniT cxrili tblStudentebis_sia, gamoiZaxeT brZaneba Home/Views/View/PivotTable. cxrilis gaxsnis Semdeg fanjris muSa nawili carielia:

cxrilis maketis SeqmnisTvis muSa magidaze unda ganvalagoT velebi. velebis sia SegiZliaT gamoitanoT ekranze instrumentuli panelidan Pivot Table Tools/Design RilakiT Field List. gadavitanoT velebi siidan Semdegi TanmimdevrobiT: jer SevqmnaT filtris velebi, Semdeg striqonebis velebi da bolos svetebis velebi. velebi SegiZliaT gadaaTrioT da CasvaT im adgilze, sadac maketis Tanaxmad unda moxvdnen. SegiZliaT isargebloT RilakiT Add da airCioT gverdze ganlagebuli Rilakis siidan mniSvneloba, romelic miuTiTebs adgils, sad Seitaneba veli: striqonSi (Row Area), svetebSi (Colunn Area), filtrebSi (Filter on), monacemebSi (Data Area), detalebSi (Detail Data). striqonebis adgilze SevitanoT veli: fakulteti, specialoba, kursi; svetebis adgilze SevitanoT veli: fasiani; filtris adgilze: gvari, saxeli, mamis_saxeli, saswavlo_weli; monacemebis velSi: CaTvlis wignakis nomeri. velebis gadatana SegiZliaT “gadaTreviT” an isargebleT velebis siis paneliT da moniSnoT veli, qvemoT CamoSaleT samkuTxa isris qveS moTavsebuli areebi da airCieT is are, romelSic unda moaTavsoT veli, daaWireT mausiT Rilaks Add. velebis gadatanis Semdeg cxrili ase unda gamoiyurebodes:

 

nebismier velze marjvena Rilakis dawkapunebiT gamoiZaxeba konteqsturi meniu:

vinaidan studentebis raodenobas CaTvlis wignakis nomriT viTvliT, davaWiroT marjvena RilakiT velis dasaxelebas da konteqsturi meniudan avarCioT brZaneba AutoCalc. CamoSaleT brZanebis bolos arsebuli samkuTxedi da gamoCndeba is funqciebi, romlis gamoyeneba SegiZliaT cxrilSi. airCieT Count, raTa daiTvaloT studentebze Canawerebis raodenoba. velis waSla yovelTvis SegiZliaT brZanebiT Remove. brZanebiT Hide Details, Collapse SegiZliaT gamoitanoT marto Sedegebi, brZanebebiT Show Details da Expend gamogaqvT Semadgeneli striqonebi (svetebi). am funqcias emsaxurebian velis bolos moTavsebuli mimatebis da gamoklebis niSnebic:

am cxrilis mixedviT fakultetze kodiT “17” _ 139 studenti swavlobs da maT Soris 13 fasian seqtorze. Tu romelime konkretuli specialobis studentebis raodenoba gnebavT gamoitanoT, CamoSaleT samkuTxedi velis dasaxelebis marjvniv da

mouSaleT yvela danarCens Tolia. aseve SegiZliaT gamoitanoT marto pirveli kursis studentebis raodenoba, Tu gamorTavT velis siidan meore kurss. isargeblebT elementis konteqsturi meniudan brZanebiT Properties (Tvisebebi). igive dasaxelebis fanjaraSi SeZlebT SeucvaloT am elements formati, saxeli; SeurCioT Srifti, saSedego velebis ricxviTi mniSvnelobebis tipi:

daformatebuli cxrili saSedego monacemebiT:

Tu cxrilSi vels TagviT svetidan striqonSi gadaitanT, Sesabamisad Seicvleba monacemebis ganlageba da jamebi. veli fasiani gadatanilia striqonSi, amiT jamebis Sinaarsi saTanadod Seicvala: pirvel striqonSi miviReT fasiani studentebis raodenoba pirvel, meore da orive kursze; meore striqonSi ki – igive WrilSi sabiujeto studentebis raodenoba. SegiZliaT SecvaloT adgilebi svetSi moTavsebuli velebis: fasiani da kursi. Tu gadatanamde jamebi miiReboda gare velis _ fasiani da Siga velis kursi mixedviT, maTi adgilebis gacvlis Semdeg gare velad xdeba kursi da Siga velad fasiani. pirvel SemTxvevaSi daiTvleba fasian seqtorze arsebuli studentebis raodenoba I da II kursze detalurad; meore SemTxvevaSi _ piriqiT, daiTvleba studentebis raodenoba I da II kursze danawevrebiT fasian da sabiujeto seqtorebze. Tu krebsiTi cxrili Seqmnili gaqvT, misi diagramiT warmodgena moiTxovs Tqvengan marto saTanado reJimis arCevas. krebsiTi cxrilis tblStudentebis_sia diagramis reJimi rom miviRoT, instrumentul panele imoqmedeT Rilakebze: PivotTable View/Design/View/PivotCart View an isargrbleT programis fanjris qvemoTa kuTxeSi, marjvniv moTavsebul xedvis reJimebis RilakebiT. iseve, rogorc cxrilebSi, aqac SegiZliaT cvaloT Tvisebebis adgili diagramis RerZebs Soris, raTa miiRoT sxvadasxva suraTi cxrilis monacemebis jgufebis warmodgenis da analizisTvis:

warmodgenil diagramaSi vertikalur RerZze ganlagebulia studentebis raodenoba, horizontalurze ki _ fakulteti da specialobebi. studentebis raodenoba specialobaze aRniSnulia svetiT. vinaidan dajgufeba specialobebis garda kidev kursiT da swavlis seqtoriT (fasiani, sabiujeto) sruldeba, amitom gamoyenebulia sxvadasxva ferebi: I kursis sabiujeto studentebis svetia lurji da fasianisa _ yavisferi, II kursis sabiujeto studentebis yviTli da fasianisa _ salaTisferi. SevucvaloT RerZebs dasaxelebebi. amisaTvis davawkapunoT arsebulze da konteqstur meniudan gamoviZaxoT brZaneba Properties. igive dasaxelebis dialogur fanjaraSi gadavideT CanarTSi Format da SevitanoT monacemebi ise, rogorc naCvenebia qvemoT:

 

horizontalur RerZs daarqviT „specialobebi“, vertikalurs ki „studentebis raodenoba“. aseve daaformateT danarCeni elementebi diagramaze. gamoitaneT legenda, raTa gaarCioT ferebis daniSnuleba. amisaTvis isargebleT instrumentul panelze Pivot Table xatuliT . am diagramis warmodgena SegiZliaT sxva saxiTac, magaliTad, gistogramiT. diagramebis tipebi farTod aris warmodgenili, Tqven SegiZliaT nebismieri maTgani airCioT. amisaTvis instrumentul panelze Pivot Chart gaaaqtiureT xatula Chart Type an daawkapuneT diagramis cariel nawilSi, gamoiZaxeT konteqsturi meniu da airCieT brZaneba Chart Type. fanjaraSi Chart Type aarCieT diagramis tipi:

iseve, rogorc krebsiT cxrilSi, diagramebSic iolad SeiZleba cvaloT velebi RerZebs Soris, gadaitanoT vertikaluri RerZidan horizontalurze da piriqiT. diagramis maketi iolad gaiwyoba interaqtiul reJimSi. diagrama da krebsiTi cxrili sinqronulad icvleba: nebismieri cvlileba diagramis maketSi iwvevs cvlilebas cxrilSi. SeitaneT cvlileba diagramaze: gadaaTrieT legendidan veli fasiani, diagrama axla ase unda gamoiyurebodes:

axla diagramaze gamotanilia pirvel da meore kursis fasiani studentebi specialobebis WrilSi. cxrilis, moTxovnis da formis analizis Sedegi warmoadgens igive sawyis cxrils. rodesac xuravT krebsiT cxrils, programa gekiTxebaT, gnebavT Tu ara SeinaxoT cxrili misi analizis maketiT an/da diagramiT. Tanxmobis SemTxvevaSi cxrili inaxeba PivotTable formatSi. uaryofis SemTxvevaSi Tqven kargavT Tqvens mier Sesrulebul samuSaos da Semdeg jerze mogixdebaT axlidan krebsiTi cxrilis Camoyalibeba. etyoba gamosavali SeiZleba moiZebnos cxrilis safuZvelze formis SeqmniT. airCieT cxrili da gamoiZaxeT brZaneba: Create/Forms/MoreForms/PivotTable. kranze krebsiTi cxrilis Seqmnis konstruqtoris fanjara gamoCndeba. SeqmeniT fomra krebsiTi cxrilis konstruqtoriT ise, rogorc cxriliT sargeblobis SemTxvevaSi. formis daxurvis dros kiTxvaze, Seinaxos Tu ara programam forma, mieciT Tanxmoba da Senaxvis fanjaraSi miuToiTeT formis iseTi dasaxeleba, romelic iolad migaxvedrebT, rom es forma krebsiT cxrils warmoadgens. aseTi formebi erTi cxrilis safuZvelze SegiZliaT mravali SeqmnaT.

­   sakontrolo kiTxvebi da testebi 1. 2.

ra daniSnuleba aqvs krebsiT cxrils? CamoTvaleT krebsiTi cxrilis maketis areebi, sadac unda ganlagdnen obieqtis velebi.

3.

SeiZleba Tu ara SevcvaloT krebsiT cxrilSi misi wyaros monacemebi? 1. ara 2. ki romeli obieqtebi ar SeiZleba warmodgenil iqnes krebsiTi cxrilisa da diagramis reJimSi? 1. cxrilebi 2. moTxovnebi 3. formebi 4. angariSebi

4.

5.

romeli brZanebiT viwyebT krebsiTi cxrilis Seqmnas? 1. 2.

6.

Home/Views/View/PivotTable Pivot Table Tools/Design

romeli brZanebiT viZaxebT obieqtis velebis sias? 1.Field List 2.Property Sheet

7.

8.

9.

romeli brZanebiT vrTavT krebsiT cxrilSi saSedego striqonebs detalebis velisTvis? 1. 2. 3. SeiZleba

Autocalc Totals

orive brZanebiT pasuxebis siidan Tu ara CavsvaT krebsiTi cxrilis maketis erT areSi ramdenime veli?

1. ara 2. ki SeiZleba Tu ara gamoTvliTi velebis ganlageba maketis detalebis areSi (Detail Data)? 1. ara 2. ki

10. moaxdens Tu cvlilebebi, 1. 2.

ara gavlenas krebsiTi cxrilis gaxsnisas wyaroSi monacemebis Tu krebsiTi cxrili cvlilebamde aris Seqmnili? ara ki

­  pasuxebi testebze 3.1; 4. 4; 5. 1; 6. 1; 7. 3; 8. 2; 9.2; 10. 2.

­  savarjiSoebi 1. 2.

SeqmeniT krebsiTi cxrili da misi diagrama cxrilisTvis tblSemestrisSedegebisUwyisi bazidan Magistratura(0203weli12kursi1semestri).mdb SeqmeniT krebsiTi cxrili da misi diagrama cxrilisTvis Sedegi bazidan Testireba.mdb

­ 

pasuxebi savarjiSoebze 1. krebsiTi cxrili rom SeqmnaT, gaxseniT baza Magistratura(0203weli12kursi1semestri).mdb, moniSneT cxrili „tblSemestrisSedegebisUwyisi“, romlis analizs atarebT da daaWireT Rilaks Open. gaxsnili cxrilis fanjaraSi Home/Views/View gamoiZaxeT brZaneba PivotTable View. velebis siidan gadaitaneT velebi filtrSi _ Specialoba_dasaxeleba; striqonebSi _ fakulteti, disciplina_ dasaxeleba, kursi; svetebSi _ CaTvlis_wignakis_nomeri da detalur monacemebis nawilSi _ Sefaseba_saboloo. Sedegi aseTi unda miiRoT:

igive cxrilis diagrama rom miiRoT, gamoiZaxeT brZaneba Home/Views/View /PivotChart View. miRebuli diagrama daaformateT: SeucvaleT Srifti, daarqviT saxelebi vertikalur da horizontalur RerZebs, gamoiZaxeT legenda. Sedegi aseTi unda miiRoT:

2.

gaxseniT monacemTa baza „testireba“. gaxseniT cxrili Sedegi. gamoiZaxeT brZaneba Home/Views/View/PivotTable View. gadaitaneT velebi ise, rogorc naCvenebia qvemoT suraTze. daaWireT vels jamuri bali da Sefaseba marjvena RilakiT da konteqsturi meniudan miuTiTeT AutoCalc/Average _ saSualo ariTmetikulis daTvla. Sedegi aseTi unda iyos:

   igive cxrilis

diagrama

rom

miiRoT,

gamoiZaxeT

brZaneba

View/Design/View/

PivotCart. miRebuli diagrama daaformateT: SeucvaleT Srifti, daarqviT saxelebi vertikalur miiRoT:

da

horizontalur

RerZebs,

gamoiZaxeT

legenda.

Sedegi

aseTi

unda

­  damatebiTi literatura 1. 2. 3. 4. 5. 6. 7. 8. 9.

c. jafiaSvili. monacemTa bazebis daproeqteba da marTva. _ Tbilisi; Tbilisis saxelmwifo universitetis gamomcemloba, 2008. gv. 291-298.  MakDonal,d M& Access 2007&Nedosta.]ee rukowodstwo& Per& s angl& ! M&% Izdatel,stwo& “Russkaq Redakciq“ + SPb&% $BHW_Peterburg$, 2007. str& 296_313& Гончаров А. Ю. Access 2007. Самоучитель с примерами. Москва, «КУДИЦ-ПРЕСС», 2007, .гл. 4. http://office.microsoft.com/ru-ru/training/CR101582831049.aspx (аудио курсы) John Viescas , Jeff Conrad. Microsoft® Office Access 2007 Inside Out. Intermediate, Advanced. US,ISBN 13 : 9780735623255, 2007. Curtis D. Frye . Microsoft® Office Access 2007 Plain & Simple. Beginner.ISBN 13 : 9780735622920, 2007. Steve Lambert, M. Dow Lambert III, Joan Preppernau. Microsoft® Office Access 2007. Step by Step. Beginner, Intermediate. ISBN 13 : 9780735623033, 2007.

Michael R. Groh, Joseph C. Stockman, Gavin Powell, and Cary N. Prague. "Access 2007 Bible"ISBN‐13: 978‐ 0‐470‐04673‐9ббWiley Publishing, Inc., Indianapolis, pg.123‐203.  http://office.microsoft.com/en-us/training/CR101582831.aspx (Audio kurses)  

­  konsultaciisTvis isargebleT misamarTiT: 1. [email protected] 2. Tsu, ekonomikisa da biznesis fakulteti, oTaxi 612, tel. 303710

      ­