LibreOffice-Suite-Calc/C2/Working-with-data/Khasi

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.

Contributors and Content Editors

Meboreen Mary