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

Time	Narration
00:00	Ngi pdiangsngewbha ia phi sha ka Spoken tutorial halor ka “ LibreOffice Calc “ - kaba iadei bad ki jingpyndonkam ia ki cell bad ki sheet.
00:07	Ha kane ka jinghikai ngin pule shaphang
00:09	* Kumno ban pynrung bad pyndam ne weng ia ki row bad ki kolum
00:13	* Ban pynrung bad pyndam ne weng ia ki sheet bad ruh ban jer kyrteng ia ki sheet.
00:17	Hangne ngi pyndonkam da ka Ubuntu Linux bershon 10.04 kum ka operating system bad ka LibreOffice Suite bershon 3.3.4.
00:29	To ngin sdang ia kane ka jinghikai da kaba pule shaphang kumno ban pynrung ia ki row bad kolum ha ka spreadsheet.
00:35	To ngin ia plie ia ka file "personal finance tracker.ods"
00:42	Ki kolum bad ki row lah ban pynrung kawei kawei ne kum ka kynhun.
00:47	Khnang ban lah ban pynrung kawei ka row ne kawei ka kolum ha ka spreadsheet- nyngkong eh jied lane pruid dak ia ka “cell”, ka kolum ne ka row ha kaba phi kwah ban pynrung ia ka kolum ne ka row kaba thymmai.
01:00	Kum ka nuksa ha ka file"personal finance tracker.ods", to ngin nion nyngkong ha ka row banyngkong.
01:09	Ngan nion ha ka “cell” kaba don ia ka jingthoh “Cost” ha ka.
01:13	Mynta nion ha ka opshon “Insert” ha ka menu bar bad nangta sa klik ha ka bynta ba thoh “Rows”
01:19	Ngi iohi ba kawei ka row kaba thymmai ka la rung hajrong jong ka row kaba ngi lah jied ne pruid dak.
01:25	Ha kajuh ka rukom ban pynrung ia ka kolum kaba thymmai, nion ia u “Insert” ha ka menu bar bad nangta sa nion “Columns”
01:34	Phin iohi ba kawei ka kolum bathymmai ka lah rung ha shwa ka “Cell” kolum kaba lah dep jied
01:40	Te mynta ngin weng noh lane “undo” ia ki jingkylla ba ngi lah leh
01:44	Lada phi lah jied ne selek ia ka kolum da kaba klik ha u dak alphabet uba pynithuh ia ka lane ia ka row da u nombar uba pynithuh ia ka row, te shu nion na ka mon ne jied ia ka opshon “Insert Columns” lane “Insert Rows” ha ka menu ba mih, khnang ba phin lah ban pynrung ia ka “row” lane ka “kolum”ba thymmai.
02:04	Ha kawei pat ka rukom, phi lah ban jied ia ka “cell” da kaba shu klik ha ka cell da u kursor. Nangta sa klik ha ka liang ka mon bad jied ia ka opshon “Insert”. Phin iohi ia kawei ka dialog box kumne.
02:18	Ban pynrung ia ka row ne kolum bathymmai jied “Entire Row” lane “Entire Column”
02:25	Ban pynrung bun tylli ki kolum lane ki row ha kajuh ka por, nyngkong eh ngi dei ban jied da kaba pyni dak ia ki kolum ne ki row katkum ka jingkwah jong ngi da kaba ngi bat sah ia naphang ka diang jong u “mouse”ha ka cell ba sdang bad drag ia u “mouse” sha ka liang sha ki number ba donkam jong ki identifier
02:43	Hangne ngi lah jied ban pyni dak 4 tylli ki cell.
02:47	Bud ia ki jingbatai ba lah ai, ban pynrung ki row lane ki kolum ba thymmai. Nga kwah ban pynrung ki row thymmai. Te kumta nga right-klik ha ka bynta ba lah dep selek ne jied bad nga nion ia u opshon”Insert”
03:00	Hadien kane ,nga jied ka option “Entire Row”.Nion ha u “OK”button. Phin iohi ba 4tylli ki row ba thymmai lah dep pynrung hajrong kito kiba lah dep jied ne selek.
03:14	Mynta ngin pule shaphang kumno ban pyndam lane weng “Column”’kawei kawei lane kum ka kynhun.
03:20	Ban pyndam ne weng ia kawei ka kolum lane ka row, nyngkong eh jied ne selek ia ka row ne kolum kaba phi kwah ban weng.
03:28	Kum ka nuksa, - lada phi kwah ban weng ia ka kolum kaba don ka jingthoh “Laundry” ha ka, nyngkong eh jied ne selek ia ka cell ha kata ka kolum da kaba nion ha ka.
03:37	Mynta nion ha ka liang ka mon ha ka “Cell”, bad sa klik ia u opshon “Delete”
03:43	Ka dialog box kan sa paw bad ka jingthoh “Delete Cells”.
03:47	Mynta , nion ha u opshon “Shift cells up” bad sa nion ha u “OK” button.
03:53	Phi iohi ba ka cell ka lah jah ne lah weng bad ki cell ba shapoh lah rah shajrong. To ngin phai biang na ba sdang lane “undo”
04:01	Mynta, to ngin pule kumno ban weng ne pyndam bun tylli ki kolum lane row ha kajuh ka por.
04:08	Kum ka nuksa, - lada ngi kwah ban pyndam ne weng ia ka row ba don ka jingthoh “Miscellaneous ” ha ka, nyngkong eh jied ia ka cell kaba don ia u serial nombar jong ka, uba dei 6.
04:18	Mynta bat sah ia u “mouse” ha kane ka “cell” bad drag lane tan sha baroh kawei ka row. Ha kawei ka pat ka rukom, nion ha u row nombar uba phi mut ban weng. Baroh kawei ka row kan sa thaba .
04:33	Nion ha ka liang ka mon ha ka cell bad nangta sa klik ha u opshon “Delete”
04:38	Ka dialog box kan sa paw bad ka jingthoh “Delete Cells”.
04:43	Mynta , nion ha u opshon “Shift cells up” bad sa klik ha u “OK” button.
04:48	Phi iohi ba ka row baroh kawei ka lah jah ne lah weng bad ka row ba shapoh la rah shajrong.
04:55	Ha kajuh ka rukom, phi lah ban weng lane pyndam ia ki kolum da kaba jied ia ki kolum ha jaka ki row. To ngin phai biang naba sdang lane “undo” ia baroh ki jingpynkylla kiba ngi la leh.
05:04	Hadien ba ngi lah dep pule shaphang kumno ban pynrung bad weng ia bun tylli ki row bad ki kolum ha ka “sheet”, mynta pat ngin pule shaphang kumno ban pynrung lane weng ia ki sheet ha “Calc”
05:14	Don bun tylli ki rukom halor kumno ban pynrung ia ka sheet ba thymmai ha Calc. Ngin pule shaphang kawei pa kawei ka rukom kawei hadien kawei pat.
05:23	U mawjam banyngkong eh na ka bynta baroh ki rukom kadei ban jied lane selek ka “Sheet” kaba hadien jong ka ia ka sheet bathymmai yn sa pynrung.
05:30	Mynta nion ha u opshon”Insert” ha ka menu bar bad sa klik ha”Sheet”
05:36	Ka dialog box kan sa paw ryngkat bad ka jingthoh “Insert Sheet”
05:41	Mynta ngin jied ia ka bynta “After current sheet” ban pynrung ka sheet bathymmai hadien jong kane ka sheet.
05:49	Ha ka bynta ba thoh “Name”, ka kyrteng jong ka sheet bathymmai ka paw kum “Sheet 4”. Kato kadei ka kyrteng ba lah ai da ka system. Phi lah ban pynkylla ia ka lada phi kwah.
06:01	Mynta nion ha u “OK” button. Ngi iohi ba ka sheet ba thymmai ka lah rung hadien kane ka sheet ba ngi don.
06:09	Kawei pat ka rukom ban pynrung ia ka sheet bathymmai ka lomg da kaba right-klik ha ka sheet tab ba lah ha trai jong ka “Calc window” bad nangta sa nion ha u opshon “Insert Sheet”
06:19	Phi lah ban jied ka jaka, ki nombar jong ki sheet bad ka kyrteng bad sa nion ha u “OK”button. Kane kan sa pynrung ia ka sheet kumba mgi kwah.
06:31	Kawei pat ka rukom ba kham suk ban pynrung ia ka sheet hadien ka sheet ba lah jied ka long da kaba nion ha u button “Add Sheet” ba lah pyni dak da u dak + hadien jong u “sheet tab”
06:43	Da kaba nion ha u, kawei ka sheet ba thymmai yn shem ba ka lah rung hadien ka sheet ba khatduh eh ha ka bynta .
06:51	Ka rukom ba khatduh ban pynrung ia ka sheet bathymmai ka long da kaba nion ha ka jaka ba thylli ne suda hadien jong ka “Add Sheet”ba pyni da u dak +, ha ka sheet tab ha trai duh.
07:06	Da kaba nion ha ka jaka ba suda, ngi iohi ba ka “Insert Sheet” dialog –box ka paw.
07:13	Phi lah ban pynrung ia ki jingtip shaphang ki sheet ha ka dialog box bad nangta sa nion ha u “OK” button.
07:20	Hadien ba lah dep pule shaphang kumno ban pynrung ia ki sheet, mynta ngin pule halor kumno ban weng ne pyndam ia ki sheet ha “calc”
07:27	Ia ki sheet lah ban weng kawei kawei ne bun tylli
07:31	Ban weng ne pyndam kawei kawei ka sheet nion ha ka liang kamon ha u sheet tab jong ka sheet kaba phi kwah ban weng bad nangta sa nion ha ka opshon“Delete sheet” ha ka pop- up menu bad sa nion ha opshon “Yes”.
07:45	Phin iohi ba ka sheet kam don shuh.
07:48	Kawei pat ka rukom ban weng ia kawei ka sheet ka long da kaba pyndonkam ia u option “edit” ha ka menu bar.
07:55	Kum ka nuksa-lada phi kwah ban weng ia ka “Sheet 3” na ka list, nion ha ka opshon “Edit” ha ka menu bar bad sa nion ha ka opshon “Sheet.”
08:05	Mynta nion ha u opshon “Delete” ha ka pop-up menu bad sa nion ha u opshon “Yes”
08:12	Phi iohi ba ka sheet kam don shuh. Mynta ngin phai biang naba sdang. Lane ngin “undo” ia ki jingpynkylla
08:19	Ban lah ban weng bun tylli ki sheet , kum ka nuksa- lada phi kwah ban weng “Sheet 2” bad “Sheet 3”, te nyngkong nion ha ka tab “Sheet2” bad da kaba iai nion ia u “Shift” button ha ka keyboard, nion ha ka tab”Sheet 3”
08:36	Mynta nion ha ka liang kamon ha kawei na kine ki tab bad klik ha ka opshon “Delete Sheet” na ka pop-up menu bad nangta sa nion ha u opshon “Yes”
08:47	Phi iohi ba baroh artylli ki sheet ki jah noh. Ban pule kham bniah, to ngin phai biang naba sdang da kaba “undo”ia ki jingpynkylla baroh.
08:56	Sa kawei pat ka rukom ban weng ia ka kawei ka sheet ka long da kaba pyndonkam ia u opshon “Edit” ha ka menu bar.
09:03	Kum ka nuksa, - lada phi kwah ban weng ia ka “Sheet 6” bad “Sheet 7” na ka list, nion ha ka “edit opshon” ha ka menu bar bad nangta sa nion ha ka opshon “Sheet”
09:14	Mynta nion ha ka opshon “Select”ha ka pop-up menu
09:19	Ha ka dialog box kaba paw, nion ha ka opshon “Sheet 6” bad da kaba iai nion ia u “Shift” button ha ka keyboard, nion ha ka opshon “Sheet 7”
09:30	Nion ha u “OK”button. Kane kan selek ia ka sheet kaba phi kwah ban weng.
09:37	Mynta nion biang ha ka opshon “Edit ”ha ka menu bar bad sa nion ia ka opshon “Sheet”
09:45	Mynta nion ha u opshon “Delete” ha ka pop-up menu bad sa nion ha u opshon “Yes.”
09:51	Phi iohi ba ka sheet kam don shuh.
09:56	Hadien ba lah dep pule kumno ban weng ia ki sheets na Calc, mynta ngin pule shaphang kumno ban ai kyrteng “rename” ia ki sheet ha ka spreadsheet.
10:03	Lada phi iohi ha ka spreadsheet, ki sheet ba pher bapher lah ai kyrteng lypa kum "Sheet 1”, “Sheet 2", “Sheet 3" bad kumta ter ter.
10:13	Kane kan treikam bad long ha ka spreadsheet kaba rit kaba don tang khyndiat tylli ki sheet tangba kan long kaba kham jynjar lada don bun tylli ki sheet.
10:21	“Calc” ka ai ka lad ha kaba ngi lah ban ai kyrteng ia ki sheet kat kum ka jingkwah jong ngi.
10:27	Kum ka nuksa, lada ngi kwah ban ai kyrteng ia ka “Sheet 4 ”kum “ Dump”, da kaba suk ngi lah ban leh kumta da kaba klik arsien ha u tab “Sheet 4” harum.
10:37	Phi iohi ba ka mih kawei ka dialog box ryngkat bad ka jingthoh “Renaming Sheet” ka don ka jingthoh “Sheet 4 ” ha ka, ba lah don lypa.
10:47	Mynta, weng noh ne pyndam ia kane ka kyrteng ba lah don lypa bad thoh ia ka kyrteng thymmai”Dump”
10:52	Klik ha u “OK” button bad phi iohi ba ka “Sheet 4” ka la kylla sha ka kyrteng “Dump”. Mynta ngin weng noh ia ka “Sheet 5” bad “Dump”.
11:02	Mynta ngi lah poi shaba kut jong ka “Spoken Tutorial” ha ka bynta jong ka “LibreOffice Calc”
11:08	Ban kyllum lang, ngi lah pule shaphang: * Ban pynrung ban weng ia ki row bad ki kolum.
11:14	*Pynrung bad weng ia ki sheet bad ai kyrteng ia ki.
11:19	COMPREHENSIVE ASSIGNMENT- plie ia ka file "Spreadsheet Practice.ods"
11:25	Jied bad weng ia ka row kaba don ia ka jingthoh “Serial Number”. Ai kyrteng ia ka sheet “Department Sheet”
11:32	Peit ia ka video kaba don ha ka link ba lah ai harum.
11:36	Kane ka kyllum lang iaka Projek jong ka Spoken Tutorial. Lada phim don ia ka bandwidth kaba biang phi lah ban shu download bad peit ia ka hadien.
11:44	Ka kynhun jong ka Spoken Tutorial: Ka pynlong ia ki workshop da kaba pyndonkam ia ki spoken tutorial
11:50	Ka ai sertiphikate sha kito kiba pass ha ka online test. Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka contact@spoken-tutorial.org
11:59	Ka spoken tutorial Projek kadei ka bynta jong ka projek kaba ki khot Talk to a Teacher. Ia kane lah kyrshan da ka National Mission on Education lyngba ka ICT,Sorkar India
12:12	Ia ki jingtip bakham bniah halor ka mission lah ban ioh na spoken hyphen tutorial dot org slash NMEICT hyphen Intro
12:22	Ia kane ka tutorial la pynkylla sha ka ktien Khasi da I Meboreen Mary Thongni. Khublei shibun ia ka jingiasnohkti lang jong phi.

Contributors and Content Editors

Meboreen Mary, PoojaMoolya