LibreOffice-Suite-Calc/C3/Using-Charts-and-Graphs/Khasi

Time	Narration
00:00	Khublei, ngi pdiangsngewbha ia phi sha ka Spoken tutorial halor ka LibreOffice Calc-Inserting Charts in spreadsheets.
00:07	Ha kane ka jinghikai, ngin pule shaphang
00:11	Bad shna, ban pynkylla bad ban format ia ki charts
00:14	Ban pynrit pynheh bad ban pynkynriah ia ki charts.
00:18	Hangne ngi pyndonkam da ka Ubuntu Linux version 10.04 bad LibreOffice Suite version 3.3.4.
00:27	To ngin sdang pule shaphang ia bun tylli ki opshon ban view lane peit ha LibreOffice Calc.
00:32	Ki charts ki lah ban long ki ba kham donbor ban ai jingtip ia u ne ka nongpule.
00:37	LibreOffice Calc  ka ai shibun ki chart formats na ka bynta ka data jong ngi.
00:43	Da kaba pyndonkam ia ka Calc, phi lah ban pynpher ia ki charts ha kiba bun rukom.
00:48	To ngin plie ia ka sheet jong ngi ka "personal finance tracker.ods"
00:53	Bad to ngin pyndap ia ka dor ki jinglut baroh jong ki item kiba la kdew ha ka sheet.
00:59	Ngin nion ha ka cell ba kdew kum “E3” bad ngin type ia ka dor kum “6500”.
01:06	Mynta da kaba hiar shapoh ka kolum, ngin type ia ki dor kum “1000”, ”625”, ”310” bad “2700” ha ka  cell ba kyrteng kum “E4”, ”E5”, ”E6” and “E7” kawei hadien kawei.
01:26	Nangta, ngin sa pyndap ia ki dor ba la ioh pdiang na man kawei pa kawei ka item ba la kdew ha ka sheet.
01:31	Te, nion ha ka cell ba kyrteng “F3” bad type ia ka dork um “500”.
01:37	Mynta da kaba hiar shapoh jong kane ka kolum, ngin type ia ki dor kum “200”, “75”, ”10” bad “700” ha ki cell ba la ai kyrteng “F4”, ”F5”, ”F6” bad “F7” kawei hadien kawei.
01:54	Mynta to ngin pule kumno ban shna ia ka chart na ka bynta kane ka table.
01:58	Ban lah ban shna ia ka chart, nyngkong eh ngi donkam ban jied ia ka data kaba dei ban kynthup ha ka chart.
02:04	Te, nion ha ka cell “SN” bad khlem da pyllait ia u mouse button, drag ia u cursor shaduh ka cell ba khatduh kaba don ia ka jingthoh “700” ha ka.
02:14	Mynta , nion ha ka opshon Insert ha ka menu bar bad nangta sa nion ha ka opshon Chart.
02:21	Phi iohi ba ka default chart ryngkat bad ka data la pynrung ha ka worksheet.
02:27	Ha kajuh ka por, ka "Chart Wizard" dialog-box ka plie.
02:32	Ka "Chart Wizard" ka pyni ba la dep jied ia ka default chart
02:36	Kane ka default chart ka pyni ia ki jingpynkylla ba phi leh ha ka Chart Wizard.
02:42	Ka "Chart Wizard" dialog-box Ka don lai tylli ki bynta ba kongsan,- ki rukom ban leh ban set up ia ka chart, ki jingkwah jong ki chart types bad ki opshon na ka bynta kawei pa awei ka chart type.
02:55	Da kaba buh dak ha ka opshon “3D Look”, lah ruh ban pynpaw ia ka chart ha ka rukom three dimensions.
03:03	To ngin pyrshang ia kine ki opshon
03:05	Ngin nion ha ka “Bar” opshon hapoh ka jaka “Choose a chart type”
03:11	Peit ba ka sample chart ka pyni ia ka jingwandur jong ki data ha ka table, ha ka “Bar” format.
03:19	Kumjuh, phi lah ban nion ha kiwei ki opshon kum “Pie” <pause> “Area”, <pause> “Bubble” <pause>
03:28	Bad bun kiwei ki opshon hapoh ka jaka “Choose a chart type” bad ioh ia ki jaid chart kaba ngi kwah.
03:35	Hapoh ka Steps opshon, ngi don ia kawei pat ka opshon kaba kyrteng Data Range.
03:40	Da kaba pyndonkam ia kane ka opshon, phi lah ban edit dalade ia ki range jong ki data kiba phi kwah ban pynwandur ha ka chart.
03:48	Ka default opshon ban plot ia ki data kadei “Data series in columns”.
03:54	Hynrei ngi lah ban pynkylla ia kane ka rukom katba ngi kwah ban plot ia ki data da kaba pyndonkam “Data series in rows”
04:02	Kane ka iarap lada phi pyndonkam da ka style jong ki chart kum “Column” ban pyni ia ka data jong phi.
04:10	Khatduh phi lah ban jied lada phi pyndonkam da ka “First row as label”
04:24	lane “First column as label”,
04:28	Lane baroh kum ki label ha ki lain jong ka chart.
04:34	Nangta nion biang ha Data series in column.
04:38	Mynta, ha ka sample chart, lada ngi kwah ban weng ia ki data hapoh ka heading “Received”, ngi lah ban leh ia kane da kaba nion nyngkong hapoh ka jaka “Data range”.
04:49	Nangta edit ia kine ki range “$A$1 is to $F$7” sha “$A$1 is to $D$7”.
05:03	Peit ba ka data kaba don hapoh ka heading “Received”, kam don shuh ha ka chart.
05:11	Nangta, to ngin peit kaei kaba ka “Data Series” ka leh.
05:15	Peit, don 5 tylli ki rows hangne- kiba thew ia ka total ki rows jong ka data ha ka spreadsheet jong ngi.
05:21	Ki Add bad Remove button kin ailad ia ngi ban pyndap bad weng ia ki row jong ki data na ki chart.
05:29	Ngi lah ruh ban pynieng ia ki data da kaba pyndonkam da ki Up bad Down button.
05:34	Te, hadien ba ngi lah dep jied kaei bad kumno ban kdew ia ki data ha ka chart, nion ha u Finish button ha ka dialog-box.
05:43	Phi iohi ba ka chart ka lah rung hapoh ka spreadsheet.
05:47	Hadien ba ngi lah dep pule kumno ban pynrung ia ki chart ha ka spreadsheet.
05:51	Mynta ngin pule kumno ban format ia ki chart ha ka LibreOffice Calc.
05:56	Ka Format menu kadon shibun ki opshon na ka bynta ban format
06:00	Bad pynbit pynbiang ia ka dur bad rukom long jong ki chart.
06:04	To ngin format ia ka chart kaba ngi pynrung hapoh ka spreadsheet.
06:08	Te, nion arsien ha ka chart khnang ba kan don hapoh jong u border ba bthuh
06:13	Ban pynithuh ba ka don hapoh ka Eidt mode.
06:18	Mynta, nion ha ka Format opshon ha ka main menu.
06:22	Phi iohi ba ka dop-down menu kadon ia bun ki format opshon kum “Format Selection”, “Position and Size”, “Arrangement”, “Chart Wall”, “Chart Area” bad shibun kiwei pat.
06:37	Ia kine ngi pyndonkam na ka bynta ban buh bha ia ka chart, pynbeit ryntih bad format ia ka background bad kyrteng ia ka chart.
06:44	Ngin pule shaphang ki opshon kiba ngi shait pyndonkam bha barabor ha kaban format kawei hadien kawei.
06:49	Ka “Format Selection” opshon ka plie ia ka dialog-box ryngkat ka heading “Chart Area”.
06:56	Peit ba don 3 tylli ki tab hangne- “Borders, “Area” bad “Transparency”.
07:03	Ha ka rukom ba ju long, “Border” tab lah jied lypa.
07:07	To ngin pynkylla ia ka style bad color jong ka chart border.
07:11	Ban leh ia kane, nion ha ka jaka “Style” bad jied “Continuous”.
07:16	Nangta, ha kajuh ka rukom ha ha jaka “Color”, nion ha “Green”.
07:21	Mynta, nion ha u Ok button
07:26	Peit ba ka style bad ka color jong ka chart border ka kylla lang.
07:31	Ki Title opshon ki format ia ka title jong ka chart bad ia u axes jong ka.
07:36	Ka Axis opshon ka format ia ki lain kaba pynmih ia ka chart
07:41	Bad ruh ia ka font jong ka text kaba mih ha baroh ar ki X bad Y axes.
07:46	Wad bniah ia baroh kine ki opshon dalade, hadien, khnang ba phin tip kaei kaba ki leh.
07:53	Ka Calc ka ai ruh ia ka opshon ban pynkylla ia ka background jong ka chart area.
07:58	Ka chart area kadei ka area kaba ker ia ki chart graphic, kynthup ia ka title kaba kongsan bad key.
08:05	Ban format ia ka chart area, nion ha ka Format opshon bad jied ia ka Chart Wall.
08:12	Phi iohi ba ka dialog-box kapaw ryngkat lang bad ka heading “Chart-Wall”.
08:17	Ka jaka “Style” ka pyni ia ka “Continuous”, kumba kane kadei ka lad ba khatduh ia ngi.
08:22	Ha ka jaka “Color”, to ngin nion ha “Red”.
08:26	Ngi pynkylla ruh ia ka size sha “0.20”cm.
08:31	Mynta nion ha u Ok button
08:35	Phi iohi ba ka style bad ka color jong ka chart area ka la kylla.
08:41	Nangnta ngin pule shaphang kumno ban resize bad pynkynriah ia ki element ha ka chart.
08:46	Na ka bynta ban resize ia ka chart, nion ha ka sample chart.
08:51	Phi iohi ia ki handles ba jyrngam ba mih sawdong ka chart.
08:54	Ban pynheh bad pynrit ia ka size jong ka chart, nion bad tan uwei na ki marker ha uwei na ki 4 ki tduh jong ka chart.
09:03	Ban pynkynriah ia ka chart, nyngkong eh nion ha ka chart.
09:07	Mynta , pyniaid ia u cursor ha kano kano ka jaka ha ka chart
09:11	U cursor u kylla sha i dak kti
09:14	Nion bad rah ia ka chart sha ka jaka ba phi kwah. Mynta , pyllait noh ia u mouse button
09:20	Phi lah dep pynkynriah ia ka chart!
09:24	Mynta ngin pule kumno ban resize ia ki chart da kaba pyndonkam ia “Position and size” dialog-box.
09:30	Sa shisien, nion ha ka chart.
09:33	Mynta, right-click ha ka chart bad jied “Position and Size” na ka context menu.
09:40	Ka “Position and Size” dialog-box ka paw.
09:44	Kadon bun ki jaka ha kaba lah ban buh ia ki jaka jong u ‘X’ bad ‘Y’ ha ka chart bad ruh ia ka pynkiang bad pynieng jong ka chart.
09:52	To ngin buh ia u ‘X’ coordinate sha u “1.00” bad ‘Y’ coordinate sha u “0.83” na ka bynta ka chart jong ngi.
10:02	Nion ha u OK button
10:04	Ngi iohi ba ka chart dalade hi ka lah don ha ka jaka katkum ki values ba lah buh hapoh ha chart area.
10:12	Bad da kane , ngi la poi shaba kut jong kane ka Spoken Tutorial.
10:16	Ban kyllum lang, ngi la pule shaphang kumno : Ban shna charts, ban pynkylla bad ban pynpher ia ki.
10:21	Ngi la pule ruh kumno ban pynrit pynheh bad ban pynkynriah ia ki charts hapoh jong ka spreadsheet.
10:27	Comprehensive Assignment-
10:29	Plie ia ka spreadsheet “practice.ods”.
10:34	Pynrung ia ka pie chart na ka bynta ka data.
10:37	Pynrit bad pynkynriah ia ka chart shapoh sha kaliang ka mon jong ka sheet.
10:42	Peit ia ka video kaba don ha ka link ba la ai harum
10:46	Ka kyllum lang ia ka Spoken Tutorial project.
10:50	Lada phim don ia ka bandwidth kaba biang, phi lah ban shu download bad peit ia ka.
10:54	Ka kynhun jong ka Spoken Tutorial
10:56	Ka pynlong ia ki workshop da kaba pyndonkam ia ki Spoken Tutorials
11:00	Ka ai sertiphikate sha kito kiba pass ha ka online test.
11:04	Na ka bynta ki jingtip ba kham bniah , sngewbha thoh sha: contact at spoken hyphen tutorial dot org.
11:11	Spoken Tutorial projek kadei ka bynta jong ka Talk to a Teacher Projek.
11:15	Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
11:23	Shibun ki jingtip halor kane ka mission ki don ha
11:26	spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
11:34	Ia kane ka jinghikai la pynkylla sha ka ktien Khasi da I Meboreen Mary Thongni na Shillong. Khublei Shibun ia ka jingiasnohkti lang jong phi.

Contributors and Content Editors

Meboreen Mary, PoojaMoolya