LibreOffice-Suite-Calc/C2/Basic-Data-Manipulation/Khasi
From Script | Spoken-Tutorial
|
|
---|---|
00:00 | Khublei, Ngi pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka LibreOffice Calc - Basics of Data Manipulation. |
00:07 | Ha kane ka jinghikai , ngin pule shaphang |
00:09 | Ka jingsdang ia ki Formula ba kongsan |
00:12 | Jingpynbeit ryntih katkum ki Columns |
00:15 | Ki bynta ba kongsan halor Ka Filtering Data |
00:17 | Hangne ngi pyndonkam da ka Ubuntu Linux bershon 10.04 kum ka Operating System bad ka Libre Office Suite bershon 3.3.4 |
00:27 | To ngin sdang ia kane ka jinghikai da kaba pule shaphang ki formula ba kham suk kiba pyndonkam ha ka Libre Office Calc |
00:35 | Formula kidei ki equation kiba pyndonkam ia ki number bad variable ban ioh ia ka jingmih. |
00:41 | Ha ka spreadsheet, ki variables kidei ki jaka jong ki cell kiba don ia ki data na ka bynta ban pyndep ia ki jingdonkam ka equation. |
00:47 | Ki arithmetic operators kiba kham donkam bad pyndonkam barabor ki dei ka addition, subtraction , multiplication bad division |
00:56 | To ngin plie ia ka file “Personal-Finance-Tracker.ods” |
01:02 | Ha ka file “Personal-Finance-Tracker.ods”, to ngin peit kumno ban khein lang ia ka dor jong ki jinglut baroh kiba la kdew hapoh jong ka phang (heading), “Cost” |
01:13 | Ngin ai sa kawei ka phang (heading) “SUM TOTAL”, hapoh jong ka “Miscellaneous” |
01:19 | Bad ngin nion ha ka Cell A8 bad ai ia u Serial Number “7” |
01:25 | Mynta, ngin nion ha ka cell “C8” ha kaba ngi kwah ban pyni ia ka dor ki jinglut baroh. |
01:32 | Khnang ban lah ban khein lang ia baroh ki jinglut, ngin type: is equal to SUM bad hapoh jong ki braket ngin kdew shai ia ki column ba naei haduh haei hap khein, kata C3 colon C7 |
01:44 | Mynta nion ia u Enter na ka Keyboard |
01:47 | Phi iohi ba ia baroh ki item hapoh ka “Cost” la dep khein lang |
01:51 | Mynta ngin pule kumno ban shim noh (Subtract) ha Calc |
01:55 | Lada phi kwah ban shim noh ia ka dor jong ka “House Rent” bad “Electricity Bill” bad pyni
ha ka cell ba lah ai kyrteng A9, nyngkong eh , nion ha ka cell A9 |
02:06 | Mynta ha kane ka cell, type is equal to bad hapoh ki braket type ia ki kyrteng ki cell, kata C3 minus C4 |
02:17 | Mynta nion ia u Enter na ka Keyboard |
02:20 | Ngi iohi ba ka dor ha ki ar tylli ki cell lah shah khate bad ka result la pyni ha ka cell A9 |
02:29 | To ngin pynkylla biang (undo) ia kaei kaba ngi la dep leh |
02:32 | Ha kajuh ka rukom, ngi lah ruh ban divide bad multiply ia ki data ha ki cell bapher bapher |
02:37 | Sa kawei pat ka jingtip ba donkam ha ka spreadsheet kadei ban wad ia ka average jong ki nombar. |
02:43 | To ngin peit kumno la leh ia kane. |
02:45 | To ngin ai ia ka phang kum “Average” hapoh jong ka cell “SUM TOTAL” |
02:50 | Hangne, ngi kwah ban pyni ia ka average jong ka total cost. |
02:55 | Te, to ngin nion ha ka cell “C9” |
02:58 | Mynta ngi type: is equal to Average bad Cost hapoh ki braket |
03:04 | Nion ia u Enter na ka Keyboard |
03:07 | Phi iohi ba ka Average jong ka column “Cost”la pyni ha ka cell |
03:11 | To ngin pynkylla biang (undo) ia kaba ngi la dep leh |
03:15 | Ha kajuh ka rukom, phi lah ban wad ia ka average jong ki number ba don ha ka row ba pynkiang |
03:20 | Ngin sa pule kham bun shaphang ki phormula bad operators ha ki kyrdan ba kham shaneng jong kane ka tutorial. |
03:25 | Mynta ngin pule kumno ban pynbeit ia ki data ha ka Calc spreadsheet. |
03:30 | Ka Sorting ka Pynbeit ia ki cell ha ka sheet ha ka rukom ba ngi kwah. |
03:35 | Ha Calc, phi lah ban pynbeit ryntih ia ki data da kaba pyndonkam haduh lai tylli ki rukom kiba la pyntreikam kawei hadien kawei pat. |
03:43 | Ki long kiba iarap shibun haba ngi wad ia kino kino ki item bad ka kham long khlain ka jingtreikam hadien ba phi lah dep ban filter ia ki data |
03:51 | Te shu ong, ngi kwah ban pynbeit ryntih ia ki data hapoh ka heading “Costs” na u barit sha uba heh |
03:57 | Te nyngkong, ngi pynthaba ia ki cell kiba donkam ban pynbeit ryntih da kaba nion ha ka cell “Cost” |
04:03 | Mynta da kaba iai nion ia u mouse na ka liang kadiang, tan ia u sha ka liang ka kolum haduh ba kut jong ka cell kaba ong “2000” |
04:12 | Kane ka jied ia ki kolum kiba ngi kwah ban pynbeit ryntih |
04:15 | Mynta, nion ha ka option Data ha ka menu bar bad nangta sa nion ha Sort |
04:21 | Mynta , jied Current Selection. |
04:24 | Phi iohi ba ka dialog box ka paw ryngkat ki tabs kum “Sort criteria” bad “Options” |
04:31 | Ha ka tab “Sort criteria, jied Cost ha ka bynta “Sort by ” |
04:37 | Khnang ban pynbeit ryntih ia ka “Cost” na ba rit shaba heh, nion ha ka option Ascending kaba mar bud bad ka. |
04:44 | Mynta nion ia u button OK |
04:47 | Phi iohi ba ki kolum la pynbeit ha ka rukom naba rit shaba heh. |
04:51 | Ha kajuh ka rukom, ban pynbeit ryntih na ba heh sha barit, nion ha Descending bad nangta sa nion ia u button OK. |
04:59 | To ngin pynkylla biang (undo ) ia kaei kaba ngi la dep leh |
05:02 | Bun tylli ki kolum lah ban pynbeit ryntih da kaba jied ia ki kolum bad nangta sa pyntreikam ia ka option Sort |
05:09 | Te shu ong , ngi kwah ban pynbet ryntih ia ka Serial Numbers bad kumjuh ia ka Cost |
05:14 | Te, nyngkong jied ia ki kolum kumba la leh hashwa |
05:18 | Mynta, nion ia ka option Data ha ka menu bar bad nangta sa nion Sort |
05:24 | Ha ka dialog box kaba paw, nyngkong eh jied “Cost” ha ka bynta “Sort by” |
05:30 | Nangta sa jied “SN” ha ka bynta “Then by” |
05:35 | Nion ha Descending ha baroh artylli ki option hajan jong ki bad nangta sa nion ha u button OK. |
05:43 | Phi iohi ba ia baroh artylli ki heading la dep pynbeit ha ka rukom naba heh shaba rit |
05:47 | To ngin pynkylla biang(undo) ia kaei kaba ngi la dep leh |
05:49 | Mynta, to ngin pule kumno ban filter ia ki data ha LibreOffice Calc |
05:53 | Ka filter kadei ka list jong ki kyndon ha kaba man ki jingtip kidei ban iahap khnang ban lah ban pyni ia ka. |
06:00 | Khnang ban pyntreikam ia u filter ha ka spreadsheet, ngin nion ha ka cell ba ai kyrteng”Item” |
06:07 | Mynta, nion ha ka option “Data” ha ka menu bar bad nangta sa nion ha “Filter” |
06:12 | Nion ha ka option “Auto Filter” ha ka pop-up menu |
06:16 | Phi iohi ia u dak khnam ba paw ha ki headings |
06:20 | Nion ha u khnam ba shapoh ha ka cell ba la ai kyrteng “item” |
06:24 | Mynta shubuh phi kwah ban pynpaw tang ia ki data ba iadei bad ka “electricity Bill” |
06:29 | Te , nion ha ka opshon “Electricity Bill” |
06:34 | Phi iohi ba tang ki data kiba don jingiadei bad ka “Electricity Bill” la pyni ha ka sheet. |
06:40 | Kiwei kiwei ki opshon lah weng lut. |
06:43 | Khnang ban lah ban peit ia baroh ki data, sa shisien nion ha u khnam ba shapoh ha ka cell ba kyrteng Item bad nangta sa nion ha “All” |
06:52 | Ngi iohi ba mynta ngi la lah ban peit ia baroh ki data kiba ngi la thoh naba sdang. |
06:59 | Shi bynta na ka “AutoFilter”, kidon sa ar tylli ki filter opshon kita kilong “Standard Filter” bad “Advanced Filter” kiba ngin sa pule hadien ha kane kajuh ka bynta. |
07:11 | Bad mynta ngi la poi sha kaba kut jong ka Spoken Tutorial
Halor ka LibreOffice Calc |
07:15 | Ban kyllum lang, ngi lah pule shaphang |
07:18 | Ka jingsdang ia ki formula |
07:21 | Ka jingpynbeit ryntih katkum ki kolum |
07:23 | ki bynta ka kongsan jong ka filtering data |
07:26 | Peit ia ka video ha ka link ba la ai harum. |
07:30 | Kane ka kyllum lang iaka Projek jong ka Spoken Tutorial. |
07:33 | Lada phim don ka bandwidth kaba biang, phi lah ban shu download bad peit ia ka hadien |
07:37 | Ka kynhun jong ka Spoken Tutorial |
07:40 | Ka pynlong ia ki workshop da kaba pyndonkam ia ki spoken tutorial |
07:43 | Ka ai sertiphikate sha kito kiba pass ha ka online test |
07:47 | Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka contact@spoken-tutorial.org |
07:53 | Ka spoken tutorial Projek kadei shibynta jong ka Talk to a Teacher project |
07:58 | Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT,MHRD, Sorkar India |
08:06 | Ia ki jingtip bakham bniah halor kane ka mission lah ban ioh na |
08:08 | spoken hyphen tutorial dot org slash NMEICT hyphen Intro |
08:16 | Ia kane ka tutorial la pynkylla sha ka ktien khasi da I Meboreen Mary Thongni. Khublei shibun ia ka jingiasnohkti lang jong phi. |