LibreOffice-Suite-Calc/C2/Working-with-data/Khasi
From Script | Spoken-Tutorial
| Time | Narration |
| 00:00 | Ngi pdiang sngewbha ia phi sha ka Spoken Tutorial halor ka Libre Office Calc- Working with data |
| 00:06 | Ha kane ka jinghikai , ngin pule shaphang |
| 00:09 | Ka jingstet da kaba pyndonkam da ki Fill tools bad Selection lists |
| 00:13 | Ban sam lang iaki jingthoh hapdeng ki sheet |
| 00:16 | Ban weng iaki data, ban bujli iaki data bad pynkylla iaki katto katne ki bynta jong ka data. |
| 00:23 | Hangne ngi pyndonkam da kaUbuntu Linux version 10.04 bad LibreOffice Suite version 3.3.4. |
| 00:32 | Ban pynrung iaki data ha kas preadsheet kalah ban long kaba eh bad bunkam tangba ka Calc ka ai ia shibun kitiar pyndonkam kiba pynsuk shibun. |
| 00:42 | Kawei na ki kam kaba lah ban leh ka long ban drag bad drop iaki jingthoh jong kawei ka cell sha kawei pat ka cell da kaba pyndonkam ia u mouse. |
| 00:49 | Tangba kaCalc ka kynthup ruh ia shibun kiwei pat ki tools ban pynrung ha ka rukom automatic ia ki jingthoh, khamtam ia kiba ju pyndonkam man kapor |
| 00:57 | Kine ki tools ki long- Fill tool, Selection lists. |
| 01:01 | Kine kilah ban pynrung iaki jingtip ha ki bun tylli ki sheet jong kajuh ka dokumen |
| 01:06 | Ngin pule shaphang jongki kawei hadien kawei pat. |
| 01:09 | To ngin plie iaka file “Personal-Finance-Tracker.ods” |
| 01:14 | U Fill tool u long uba iarap shibun na ka bynta ban duplicate ia ki jingthoh ha ka sheet |
| 01:19 | Ha ka file “Personal-Finance-Tracker.ods”, to shu ong- ngikwah ban copy iaka data hapoh ka heading Cost shaki cell ba mar khap. |
| 01:30 | Te, nyngkong eh jied ia baroh ki data kiba donkam ban copy da kaba nion ha ka cell kaba don ia jingthoh “6000” |
| 01:38 | Mynta da kaba iai nion ia u mouse na kaliang ka diang bad tan lane drag ia u haduh bakut jongka cell kaba don iaka jingthoh “2000” hapoh ka Cost |
| 01:46 | Kumjuh ruh jied iaki cell ha kaba phi mut ban copy ia ka data. |
| 01:51 | Mynta , pyllait noh ia u mouse button ba sha kadiang |
| 01:53 | Nion ha u opshon Edit ha u menu bar bad nangta sa nion ia u opshon Fill |
| 01:59 | Ha ka pop-up menu, nion ha ka opshon Right |
| 02:03 | Phi iohi baka data hapoh ka heading “Cost” lah copy sha ki cell ba markhap |
| 02:09 | To ngin phai biang lane undo iaki jingpynkylla. |
| 02:12 | Kiwei kiwei ki jingpyndonkam kiba kham eh jong ka Fill tool ka long da kabapyndonkam ia u ban pyndap iaki series kum ki data ha ki sheets. |
| 02:20 | Ka Calc kaai iaka default lists naka bynta ki sngi ba pura bad ba lyngkot jong kataiew bad bnai jong u snem. |
| 02:27 | Ka ai lad ruh ia u nong pyndonkam ban shna la kajong ka lis. |
| 02:34 | Mynta, to ngin thep iaka heading kaba thymmai kaba kyrteng “Days” hapoh ka sheet jong ngi. |
| 02:38 | Hapoh kane, ngin leh ba kan pyni hi iaki 7 tylli ki sngi jong ka taiew |
| 02:43 | Jied ia 7 tylli ki cell kiba nyngkong kiba don hapoh ka heading “Days”. |
| 02:48 | Mynta, nion iaka Edit opshon ha ka menu bar bad leit shaka Fill opshon. |
| 02:53 | Nion ha ka opshon Series ha ka menu. |
| 02:57 | Phi iohi baka dialog- box ka paw ryngkat bad ka heading “Fill Series” |
| 03:02 | Mynta, hapoh ka heading- “Series type”, nion ha ka opshon “AutoFill” |
| 03:07 | Ha ka “Start value” field, ngi type iaka sngi ba nyngkong jong ka taiew , kata “Sunday” |
| 03:13 | Ka jingpynkiew la buh lypa “1”. Mynta, nion ha ka OK button |
| 03:18 | Phi iohi ba iaki sngi la dep pynrung ha ki cell |
| 03:23 | Phi lah ban pyndap tang iaki sngi jong ka taiew, u bnai lane snem da kajuh ka rukom kumba lah batai lypa ka Calc. |
| 03:32 | Kawei pat ka rukom na ka bynta ba kan pyndap hi iaki data balong mar bud kilong kumne harum. |
| 03:37 | Type “Sunday” ha ka cell bad sa nion Enter. Kane kan phai iaka jingmut jong ka sha ka cell kaba bud ha ka column. |
| 03:46 | Phai biang sha ka cell ha kaba ka “Sunday” la type. Phin sa iohi ba i box baiong barit ha trai kamon jong ka cell. |
| 03:55 | Nion ha kane ka box da u mouse |
| 03:57 | Tan ia u shapoh haduh ba phin da iohi Saturday ba ka paw hapoh ka synduk sha kaliang kamon. |
| 04:04 | Pyllait noh ia u mouse button |
| 04:06 | Ki cell la pyndap hi ia ki sngi jong ka taiew. |
| 04:10 | Kane ka buit ka treikam ha baroh ki data kiba mar bud. To ngin phai biang lane undo ia baroh ki jingpynkylla bangi la leh |
| 04:17 | Phi lah ruh ban shna iaki series tang shisien naka bynta ki number da kaba pyndap ia u numbar ba sdang, bakut bad uba kiew. |
| 04:24 | Ban batai ia kane, ngin pyndam shwa ia ki numbar ba la pyndap lypa ha ki cell “A1” haduh “A7” |
| 04:33 | Hadien ba lah pyndam ia ki numbar, jied biang ia ki cell kiba kdew kum “A2” haduh “A7” |
| 04:40 | Mynta, nion ia u Edit ha u menu bar bad nangta ha u Fill bad Series opshon. |
| 04:46 | Ka dialog-box kamih hakhmat jongngi. Mynta, nion ha u Linear opshon, hapoh jong u heading “Series type”, lada ka khlem jied hi da lade. |
| 04:57 | Ha ka jaka“Start value”, ngin type ia u numbar basdang- kata “1”. |
| 05:03 | Ha ka jaka“End value”, ngin type ia u numbar ba khatduh ba ngin pyndap kum “6”. |
| 05:08 | Mynta, ngin buh ia u “Increment” value kum “1” bad haba kut ngin nion ha u OK button. |
| 05:14 | Ngi iohi ba ki cell dalade hi kilah pyndap ia ki numbar ba marbud hadien jong u. |
| 05:21 | Ha baroh kine ki jait. U Fill tool u shna iaka jing iadei jongki cell ka ba neh shipor hapdeng jong ki. Shisien baka lah dep, kineki cell kim don shuh ha jing iadei hapdeng iwei bad iwei pat. |
| 05:32 | Shi bynta na ka Fill tool, kadon sa kawei ka tool kaba lah ban pynstet kata “Selection lists” kaba long tang bad ka text. |
| 05:40 | Ngin sa iakren ia kane ha ki jinghikai kiba shadien jong kane ka series. |
| 05:45 | Hadien ba ngi lah dep pule shaphang ka“Fill tools” bad “Selection lists”, mynta ngin pule kumno ban sam ia ki jingthoh hapdeng ki sheet. |
| 05:52 | Ka Calc ka ai lad ia u nong pyndonkam ban pyndap ia kijuh ki jingtip ha kajuh ka cell ha bun tylli ki sheet. |
| 05:58 | Kane kamut, ha ka jaka ban pyndap ia kajuh kalis ha man kawei pa kawei ka sheet, phi lah ban shu pyndap ia ki shisien pyndap ha kajuh kapor. |
| 06:07 | Ha ka “Personal-Finance-Tracker.ods” file jong ngi, baroh ki data kidon ha kaSheet 1. |
| 06:14 | Mynta, ngi kwah ka “Sheet 2” bad kumjuh ruh ka “Sheet 3” kin pyni kajuh ka data kumba don ha “Sheet 1” |
| 06:21 | Te , ngin nion ha ka opshon Edit ha ka menu bar bad nangta nion ha ka Opshon Sheet |
| 06:27 | Mynta, nion ha Select |
| 06:30 | Mynta, ha ka dialog box kaba paw, da kaba pyndonkam ia u Shift Key ngi jied ki opshon Sheet 1, “Sheet 2” and Sheet 3. |
| 06:40 | Bad nangta sa nion ha u OK button. |
| 06:42 | Kane ka ialam biang ia ngi sha Sheet 1 |
| 06:45 | Mynta , to ngin pynrung khyndiat ki data ha “Sheet 1” |
| 06:49 | Kum ka nuska- ha ka cell kaba paw kum “F12” ngin type “This will be displayed on multiple sheets” |
| 06:57 | Mynta, nion ha ka “Sheet 2” bad “Sheet 3” tab uwei hadien uwei. |
| 07:02 | Ngi iohi ba ha man kine ki sheet, ki cell kiba paw kum “F12” kidon ia kijuh ki data. |
| 07:09 | To ngin phai biang lane undo ia baroh ki jingpynkylla ba ngi la leh |
| 07:12 | Ha kaba bud, to ngin pule shaphang kiwei ki lad ba ngin pyndam bad pynbeit ia ki data ha ki cell. |
| 07:18 | Ban pyndam ia ki data khlem da weng ia ki formatting jong ka cell, ngin shu jied beit ia ka cell. |
| 07:25 | Phi iohi ba ka data jong ka cell ka paw ha ka jaka jong ka “Input line”. |
| 07:30 | Mynta,nion ia u Backspace button ha ka keyboard. |
| 07:35 | Phi iohi ba ki data ki lah shah pyndam. |
| 07:37 | To ngin phai biang ia baroh ki jingpynkylla. |
| 07:39 | Ban kylliang ia ka data ha ka cell, shu jied ia ka cell bad type halor jong ka data kaba rim. |
| 07:46 | Ka data kaba thymmai kan sah ryngkat bad ka formatting jong ka. To ngin phai biang ia ki jingpyn kylla. |
| 07:52 | Khnang ban pynkylla ia ka bynta jong ka data ha ka cell, khlem da weng ia ki contents, shu nion arsien ha kata ka cell. |
| 08:01 | Mynta, da kaba kdew da u cursor, phi lah ban edit ia ka cell katkum ka jingdonkam. |
| 08:07 | To ngin pynphai biang ia ki jingpyn kylla. |
| 08:09 | Bad da kane ngi la poi sha bakut jong ka Spoken Tutorial halor ka LibreOffice Calc: |
| 08:15 | Ban batai kyllum; ngi la pule shaphang |
| 08:17 | Ban pynstet da kaba pyndonkam da u Fill tools bad Selection lists. |
| 08:20 | Ban iasam ia ki contents hapdeng ki sheets. |
| 08:23 | Ban weng ia ki data, kylliang, bad pyn kylla ia ka bynta jong ka data. |
| 08:29 | Peit ia ka video ha ka link ba la ai harum |
| 08:32 | Ka kyllum lang iaka Spoken Tutorial projek |
| 08:35 | Lada phim don ka jingstet ha ka bandwidth jong phi, phi lah ban shu download bad peit iaka hadien |
| 08:40 | Ka kynhun jong ka Spoken Tutorial |
| 08:43 | Ka pynlong ia ki workshop da kaba pyndonkam da ki spoken tutorials |
| 08:46 | Ka ai sertiphikate sha kito kiba pass ha ka online test |
| 08:49 | Na ka bynta ki jingtip ba bniah, thoh sha contact at spoken hyphen tutorial dot org. |
| 08:55 | Ka Spoken Tutorial Projek kadei ka bynta jong ka Talk To a Teacher projek |
| 09:00 | Ia kane la kyrshan da ka National Mission On Education lyngba ka ICT, MHRD, Sorkar India |
| 09:07 | Shibun ki jingtip halor kane ka mission ki don ha |
| 09:11 | spoken hyphen tutorial dot org slash NMEICT hyphen Intro. |
| 09:18 | Ia kane ka jinghikai la pynkylla sha ka ktien Khasi da i Meboreen. Khublei shibun ia ka jingia snohkti lang jong phi. |
