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

VISUAL CUE	NARRATION
00:00	Khublei ngi pdiang sngewbha iaphi sha ka Spoken tutorial LibreOffice Calc ha kaba iadei bad ka rukom pyndonkam iaki cells.
00:06	Ha kane ka tutorial ngin pule shaphang:
00:08	Kumno ban thep iaki nombar, ki jingthoh, ki nombar kum ka jingthoh, ka tarik bad kapor ha ka spreadsheet.
00:16	Kumno ban pyndonkam iaka Format cells dialog box
00:19	Kumno ban kdew ban phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
00:23	Kumno ban jied iaki item ha ki rows, columns bad sheets.
00:29	Hangne ngin pyndonkam da ka Ubuntu 10.04 Operating system bad LibreOffice Suite version 3.3.4.
00:39	Te to mynta ngin sdang ban pule kumno ban thep iaki data ha ki cells.
00:43	Ngin plié iaka Personal finance tracker.ods
00:49	Phi lah ban type kino kino ki jingthoh ha kawei kawei ka cell da kaba click ha kato ka cell nangta sa type da kaba pyndonkam ka keyboard jong phi.
00:59	Ha kaba nyngkong ki jingthoh kiba phi type kin phai ha kaliang kadiang. Phi lah ban pynkylla iaka jaka jong ka da kaba click ha uno uno u Alignment tabs ha u Formatting Bar.
01:08	To ngin phaidien biang kumba kalong nyngkong.
01:11	Mynta click ha u cell uba pyni A1 ha ka spreadsheet.
01:15	Phi iohi hangne ba ka cell ba phi kdew kalah thaba.
01:20	Hangne ngi lah dep type lypa iaka heading jong ka column.
01:24	Hapoh ha heading, “Items” ngin type kato katne kiwei pat ki items hapoh jong ka kum “Salary”, “House rent”, “Electricity bill”, “Phone bill”, “Laundry” and “Miscellaneous”.
01:38	Ban ioh ban pynrung iaki nombar ha ka cell, klik ha ka cell bad type iaki nombar
01:43	Ban pynrung ia u negatib nombar, phi lah ban buh da u dak minos hashwa jong u ne phi lah ban buh ia u hapdeng ki braket.
01:53	Kum ka rukom, ki nombar lah pynryntih sha kamon, ban ki negatib nombar ki bud hadien u dak minos.
02:01	To ngin phaidien biang ia baroh ki jingpynkylla.
02:04	Mynta hapoh u heading Serial Number, ba la thoh “SN” ha ka spreadsheet “personal finance tracker.ods”, ngi kwah ba u serial nombar jong uwei pa uwei u item ban un long hapoh jong uwei pat.
02:17	Te klik ha ka cell ba iahap bad “A2” bad pynrung iaki nombar kum 1, 2,3 uwei hapoh jong uwei pat.
02:27	Ban ioh ban pyndap iaki serial nombar ha ka rukom automatic, klik ha ka cell ”A4”. Kawei ka box barit balong rong iong ha kaliang kamon sha ka bynta ba shapoh. Drag iaka cell haduh “A7” bad sa pyllait noh ia u buton jong u mouse.
02:42	Phin sa iohi ba ki cell “A5” haduh”A7” kin sa dap da ki serial nombar.
02:51	Hadien ba phi lah dep pynrung iaki serial nombar jongki item, mynta ngin pynrung ia kador lane “cost” jong kawei pa kawei ka item hapoh ka heading” cost”
02:59	Te ngi klik ha ka cell ba la ai kyrteng “C3” bad type ia ka dor jinglut na ka bynta “ House rent ” kum “Rupees 6000”
03:07	Mynta kan jia aiu lada ngi kwah ban thoh ha shwa jong u nombar da u dak na bynta pisa.
03:11	Shubuh, ngi kwah ban pynrung ”Rupees 800” na ka bynta “Electricity bill”. Te, klik ha kaliang kamon jong u mouse bad nangta klik ha u opshon ”Format Cells”
03:23	Kane kan sa plie iaka “Format Cells” dialog box.
03:27	U tab ba nyngkong u dei “Numbers”. Te klik hangta lada ym pat dep select iaka.
03:32	Shibun kiwei pat ki bynta phi iohi hapoh “Category” kum Number, Percent, Currency, Date, Time bad sa kiwei pat.
03:41	To ngin jied Currency.
03:44	Mynta hapoh jong u Format opshon, klik ha u khnam ba shapoh. Kane kan sa plie ia shibun ki dak symbol jongki currency kylleng ka pyrthei.
03:53	To ngin scroll ne kiew shajrong bad jied INR Rupees English India. Ka Rupee 1,234 ba lah dep jied lypa kan sa paw ha ka drop down ba shapoh.
04:04	Phi lah ban iohi ia ka rukom long jong ka ha ka bynta ba sha kaliang kamon.
04:10	Hapoh Options, ngi don ia u opshon ban pynrung ia u nombar jongki Desimal bad ki nombar jongki zero ki ban bud hadien jong u katkum ka jingkwah jong ngi.
04:20	Ngin khmih mynta katba ngi nang pynbun iaki zero, ka bynta hapoh ka Format kan kylla sha Rupees 1,234 desimal zero zero kaba pyni ba don artylli ki jaka decimal.
04:35	Phin shem iaki jingpynkylla ha ka jaka ba khot preview area.
04:40	Klik ha Thousands Separator ban ioh ban pynsnoh da u ”comma” ha man ka thousand. Sa shisien phin shem ia ki jingkylla ha ka jaka ba lah pyni.
04:50	Lah ruh ban pynkylla iaki font style da kaba klik ha u Font tab. U don shibun ki opshon na bynta Font, Typeface bad ka Size.
05:00	Peit bad khmih ia Ki Font Effects bad kiwei pat ki tab ban tip bha shaphang jongki.
05:05	Ngin sa pule shaphang ki opshon ha Alignment tab ha kawei pat ka tutorial.
05:11	To ngin iaklik ha OK.
05:15	To ngin type 800 bad pres Enter. Phin sa iohi ba u nombar 800 un sa paw kum Rupees 800 bad 2 tylli ki decimal.
05:26	Mynta to ngin jied iaki cell C5 haduh C7. Nion ia u CTRL key bad sa jied iaka cell G2 ruh. Phin sa iohi ba baroh ki cell ki lah thaba.
05:39	Klik u mouse kamon ha kano kano ka cell ba thaba bad jied Format Cells.
05:46	Jied iaki juh ki opshon kumba ha shwa. Klik ha OK.
05:51	Mynta ngi thoh iaki jinglut jong kiwei pat ki items kawei hapoh jong kawei pat kum “Rupees 600” na bynta ka “Phone bill”, ”Rupees 300” na bynta ki jinglut ha “Laundry” bad “Rupees 2000”kum kita kiwei pat ki jinglut ne “Miscellaneous”
06:06	Hapoh ka heading “Accounts” ngi type iaka salary na ka bynta kato ka bnai kum “Rupees 30000”
06:13	Ban pynrung iaka tarik ha Calc, jied iaka cell bad type iaka tarik.
06:18	Phi lah ruh ban phiah iaki bynta jongki tarik da kaba thoh ia u forward slash ne u hyphen ne phi lah ban thoh kum 10 October 2011.
06:27	Ka Calc kalah ban ithuh ia shibun tylli ki rukom thoh tarik.
06:32	Ha kawei pat ka rukom, klik u mouse kamon ha ka cell bad jied ia u opshon “Format Cells”
06:38	Hapoh kato ka bynta jied “Date” bad ka format ba phi kwah hapoh “Format”. Ngin jied 12,31,1999. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.
06:51	Ka Format code ka paw hapoh kum MM, DD bad YYYY. Lah ban jied iaka Format code katkum ka jingkwah jong phi.
07:02	Ngan type DD,MM bad YYYY. Phi lah ban iohi iaki jingpynkylla ha ka jaka preview. Klik OK.
07:12	Ban pynrung iaka por ha Calc, Jied iaka cell bad type iaka por.
07:18	Phi lah ban phiah iaki bynta jong kapor da kaba buh iaki colon kum 10 colon 43 colon 20.
07:24	Ha kawei pat ka rukom, klik u mouse kamon ha ka cell bad jied ia u opshon “Format Cells”
07:31	Hapoh kato ka bynta jied “Time” bad ka format ba phi kwah hapoh “Format”. Ngin jied 13,37,46. Phin iohi ba la pynpaw ha ka jaka pynpaw ne ka preview area.
07:43	Ka Format code ka paw hapoh kum HH:MM: SS. Lah ban jied iaka Format code katkum ka jingkwah jong phi. Ngan type HH:MM
07:57	Phi lah ban iohi iaki jingpynkylla ha ka jaka preview. Klik OK.
08:03	To ngin phaidien biang ia baroh ki jingpynkylla.
08:06	Hadien ba ngi lah dep pule kumno ban thoh ia ki jingthoh, nombar bad tarik ha ka Calc, mynta ngin pule kumno ban kdew bad ban phai ha kajuh ka spreadsheet na kawei ka cell sha kawei bad na kawei ka sheet sha kawei pat.
08:17	Te ngin ia peit shwa mynta kumno ban kdew bad phai na kawei ka cell sha kawei pat ha ka spreadsheet.
08:23	Phi lah ban treikam hapoh jong uno uno u cell da kaba shu click ha uto u cell da u cursor.
08:29	Phin iohi ba kato kawei ka cell kan sa thaba.
08:32	Kawei pat ka rukom ban pyndonkam ia u cell ngi pyndonkam da ka cell kaba don ka jingiadei ne jingiasnoh bad kata cell kaba ngi pyndonkam lane Cell Reference.
08:38	Click ha u khnam barit bad ba iong sha kamon jong ka “Name Box”
08:43	Mynta type ka cell Reference jong ka cell sha kaba phi kwah ban phai bad sa press “Enter”
08:49	Phi lah ruh ban click ha ka name box, pyndam noh ia ka Cell Reference ba lah don lypa bad sa type ia ka Cell reference ba phi kwah bad sa press enter
08:58	Mynta pat ngin pule kumno ban kdew bad phai na kawei cell sha kawei ha ka spreadsheet.
09:03	Ka rukom kaba nyngkong ban kdew bad phai na uwei u cell sha uwei ngi pyndonkam da u cursor.
09:09	Ban buhdak da kaba pyndonkam da u cursor, ngi lah da kaba suk ban leh ia kane da kaba shu pyniaid ia u cursor sha ki cell kiba phi kwah ban duh dak bad sa click hangta da u button ba sha ka diang jong u mouse jong phi.
09:18	Kane ka pynkylla ia ka rukom buhdak jong phi sha u cell uba thymmai.
09:22	Kane ka rukom ngi shait kham pyndonkam haba ki cells kiba ngi pyndonkam ki ia jngai uwei na uwei pat.
09:28	Sa kawei pat ka rukom ban phai na uwei u cell sha uwei ngi pyndonkam da u “Tab” key, ban iaid na uwei u cell sha uwei ha ka rukom pynkiang ne row.
09:35	“Shift + Tab” ban phaidien sha u cell uba don hashwa ha ka row kaba hakmat.
09:39	“Enter” ban iaid biang sha khmat jong uwei pat u cell ha kawei pat ka column.
09:42	“Shift + Enter” ban phaidien sha u cell uba don hashwa ha ka column.
09:46	Mynta pat ngin pule kumno ban phai na kawei ka spreadsheets sha kawei ha ka Calc da kaba pyndonkam da ka keyboard.
09:53	Ban ioh rung pyndonkam ha kawei pat ka sheet sha kamon jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Down” key ha kajuh kapor.
10:00	Ban ioh rung pyndonkam ha kawei pat ka sheet sha kadiang jong ka sheet kaba phi treikam mynta, nion “Control” bad “Page Up” key ha kajuh kapor.
10:08	Phi lah ruh ban phai na kawei ka sheet sha kawei pat da kaba pyndonkam da u cursor.
10:13	Ka jingbatai ka kham bniah kadon ha ka tutorial kaba iadei bad ka “Working with Sheets”.
10:19	Lada phi don bun ki sheets palat ia ka lai tylli, kiwei kin nym lah ban paw hynrei kidon bad rieh hapoh u scrool bar ba thiah hapoh jong ka screen.
10:28	Lada kane ka long kumta, te ki 4tylli ki buton hapoh bad sha kadiang jong ka sheet tab lah ban pyndonkam ban peit ia ki sheet kiba rieh.
10:36	To mynta ngin phai dien ia kaei kaba ngi lah dep pynkylla.
10:39	Ban jied ia ki cell ha ka rukom kaba bteng pynieng bad pynkiang, ngin click shwa nyngkong ha uwei u cell.
10:45	Nangta press bad tan sharum ia u button kadiang jong u mouse.
10:48	Pyniaid ia u cursor ha ka screen bad ynda phi lah ioh katkum ka jingkwah jong phi, pyllait noh ia u button kadiang jong u mouse. Mynta phin iohi ba kito ki cells ba phi jied ki lah thaba.
11:00	Mynta kumno ban jied ki columns bad ki rows ha kajuh ka bynta bad ialong kawei, ngi click ha ka column lane row kaba nyngkong ha ka group.
11:09	Nangta nion ia u “Shift” key.
11:12	klik ia ka column ne row kaba khatduh ha ka group.
11:15	Ban jied ia ki columns bad ki rows kiba iaphiah, click ha ka column lane row kaba nyngkong ha ka group.
11:23	Nion bad wat pyllait ia u “Control” Key bad sa click ha baroh ki column ki row ba iaphiah.
11:31	Ban jied ia ar ne palat ia ar tylli ki sheets ban ialong kawei, click ha u sheet tab uba nyngkong uba kham donkam napdeng jong ki.
11:39	Nangta iaid shadien duh jong u sheet tab uba phi pyndonkam.
11:43	Nion ia u “Shift” key bad sa click ha u sheet tab.
11:48	Baroh ki tab kiba hap hapdeng jong kito ki sheet tab kiba phi click ki kylla lieh bad thaba kaba mut ba kito baroh ki sheets ngi lah jied kyllum lang kawei.
11:56	Mynta kiei kiei baroh ba phi treikam ha kawei ka sheets ka lah trei lang ruh ha baroh kiwei pat.
12:01	Ban jied ia ki sheets kiba ia phiah, click ha u sheet tab uba nyngkong.
12:08	Nangta pyniaid ia u cursor ha u sheet tab uba lai.
12:12	Nion ia u “Control” key bad sa click.
12:16	Mynta ki sheets kiba phi lah jied ki lah kylla lieh bad kiei kiei baroh ba phi treikam ne leh kan ktah lang ia baroh kiwei pat ki sheets kiba thaba.
12:24	Mynta ngi lah poi sha kaba kut ha kane ka Spoken Tutorial on LibreOffice Calc.
12:30	Kum ban shu pynkynmaw iaphi, ngi la dep pule shaphang :
12:33	Kumno ban thep iaki nombar, ki jingthoh, ki nombar kumka jingthoh, ka tarik bad kapor ha ka calc.
12:40	Kumno ban pyndonkam iaka Format cells dialog box
12:43	Kumno ban kdew bad phai na uwei u cell sha uwei bad na kawei ka sheet sha kawei pat.
12:47	Kumno ban jied iaki item ha ki rows, columns bad sheets.
12:52	COMPREHENSIVE ASSIGNMENT
12:55	Plie ia ka “Spreadsheet Practice.ods”
12:58	Hapoh jong “Serial Numbers” type ki nombar naduh 1 haduh 5 uwei hapoh jong uwei pat.
13:04	Kumno ban phai na uwei u cell sha uwei da kaba pyndonkam ia ki keys.
13:09	Jied ia baroh ki items hapoh jong serial number.
13:13	Pyndap sa kawei ka column na ka bynta ka Date and Time.
13:16	Pyndap katto katne ki nombar da kaba pyndonkam da ka Format Cells dialog box opshon.
13:21	* Peit iaka video kaba don ha ka link ba lah ai harum
13:24	* Kane ka kyllum lang iaka Projek jongka Spoken Tutorial
13:27	*Lada phim don ka jingstet jongka rukom phah bad iohpdiang iaki webpage lyngba ka internet kaba biang jong phi, phi dang iai lah hi ban download bad ban peit iaka.
13:32	Ka kynhun jongka Spoken Tutorial
13:35	*Ka pyniaid iaki workshop da kaba pyndonkam iaki spoken tutorial
13:38	*Ka ai sertiphikate sha kito kiba pass ha ka online test
13:41	*Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka kontak ha ka spoken hiphen tutorial dor org
13:48	*Spoken Tutorial kadei ka bynta jongka project Talk To A Teacher.
13:52	*Ia kane la kyrshan da ka National Mission on Education lyngba ICT, MHRD, Sorkar India.
14:00	*Ki jingtip ba kham bniah ha kane ka Mission ki don ha
14:03	*spoken hyphen tutorial dot org slash NMEICT hyphen Intro
14:11	* Ia kane ka turorial la pynkylla sha ka ktien Khasi da I Meboreen Mary Thongni. Bad nga dei I Pdiangburom Nongrum.
14:16	*Khublei Shibun iaka jing ia snohkti jong phi.

Contributors and Content Editors

Devraj, Meboreen Mary, PoojaMoolya