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. |
