LibreOffice-Suite-Calc/C2/Basic-Data-Manipulation/Khasi

Time	Narration
00:00	Khublei, Ngi pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka LibreOffice Calc - Basics of Data Manipulation.
00:07	Ha kane ka jinghikai , ngin pule shaphang
00:09	* Ka jingsdang ia ki Formula ba kongsan
00:12	* Jingpynbeit ryntih katkum ki Columns
00:15	Ki bynta ba kongsan halor Ka Filtering Data
00:17	Hangne ngi pyndonkam da ka Ubuntu Linux bershon 10.04 kum ka Operating System bad ka Libre Office Suite bershon 3.3.4
00:27	To ngin sdang ia kane ka jinghikai da kaba pule shaphang ki formula ba kham suk kiba pyndonkam ha ka Libre Office Calc
00:35	Formula kidei ki equation kiba pyndonkam ia ki number bad variable ban ioh ia ka jingmih.
00:41	Ha ka spreadsheet, ki variables kidei ki jaka jong ki cell kiba don ia ki data na ka bynta ban pyndep ia ki jingdonkam ka equation.
00:47	Ki arithmetic operators kiba kham donkam bad pyndonkam barabor ki dei ka addition, subtraction , multiplication bad division
00:56	To ngin plie ia ka file “Personal-Finance-Tracker.ods”
01:02	Ha ka file “Personal-Finance-Tracker.ods”, to ngin peit kumno ban khein lang ia ka dor jong ki jinglut baroh kiba la kdew hapoh jong ka phang (heading), “Cost”
01:13	Ngin ai sa kawei ka phang (heading) “SUM TOTAL”, hapoh jong ka “Miscellaneous”
01:19	Bad ngin nion ha ka Cell A8 bad ai ia u Serial Number “7”
01:25	Mynta, ngin nion ha ka cell “C8” ha kaba ngi kwah ban pyni ia ka dor ki jinglut baroh.
01:32	Khnang ban lah ban khein lang ia baroh ki jinglut, ngin type: is equal to SUM bad hapoh jong ki braket ngin kdew shai ia ki column ba naei haduh haei hap khein, kata C3 colon C7
01:44	Mynta nion ia u Enter na ka Keyboard
01:47	Phi iohi ba ia baroh ki item hapoh ka “Cost” la dep khein lang
01:51	Mynta ngin pule kumno ban shim noh (Subtract) ha Calc
01:55	Lada phi kwah ban shim noh ia ka dor jong ka “House Rent” bad “Electricity Bill” bad pyni ha ka cell ba lah ai kyrteng A9, nyngkong eh , nion ha ka cell A9
02:06	Mynta ha kane ka cell, type is equal to  bad hapoh ki braket type ia ki kyrteng ki cell, kata C3 minus C4
02:17	Mynta nion ia u Enter na ka Keyboard
02:20	Ngi iohi ba ka dor ha ki ar tylli ki cell lah shah khate bad ka result la pyni ha ka cell A9
02:29	To ngin pynkylla biang (undo) ia kaei kaba ngi la dep leh
02:32	Ha kajuh ka rukom, ngi lah ruh ban divide bad multiply ia ki data ha ki cell bapher bapher
02:37	Sa kawei pat ka jingtip ba donkam ha ka spreadsheet kadei ban wad ia ka average jong ki nombar.
02:43	To ngin peit kumno la leh ia kane.
02:45	To ngin ai ia ka phang kum “Average” hapoh jong ka cell “SUM TOTAL”
02:50	Hangne, ngi kwah ban pyni ia ka average jong ka total cost.
02:55	Te, to ngin nion ha ka cell “C9”
02:58	Mynta ngi type: is equal to Average bad Cost hapoh ki braket
03:04	Nion ia u Enter na ka Keyboard
03:07	Phi iohi ba ka Average jong ka column “Cost”la pyni ha ka cell
03:11	To ngin pynkylla biang (undo) ia kaba ngi la dep leh
03:15	Ha kajuh ka rukom, phi lah ban wad ia ka average jong ki number ba don ha ka row ba pynkiang
03:20	Ngin sa pule kham bun shaphang ki phormula bad operators ha ki kyrdan ba kham shaneng jong kane ka tutorial.
03:25	Mynta ngin pule kumno ban pynbeit ia ki data ha ka Calc spreadsheet.
03:30	Ka Sorting ka Pynbeit ia ki cell ha ka sheet ha ka rukom ba ngi kwah.
03:35	Ha Calc, phi lah ban pynbeit ryntih ia ki data da kaba pyndonkam haduh lai tylli ki rukom kiba la pyntreikam kawei hadien kawei pat.
03:43	Ki long kiba iarap shibun haba ngi wad ia kino kino ki item bad ka kham long khlain ka jingtreikam hadien ba phi lah dep ban filter ia ki data
03:51	Te shu ong, ngi kwah ban pynbeit ryntih ia ki data hapoh ka heading “Costs” na u barit sha uba heh
03:57	Te nyngkong, ngi pynthaba ia ki cell kiba donkam ban pynbeit ryntih da kaba nion ha ka cell “Cost”
04:03	Mynta da kaba iai nion ia u mouse na ka liang kadiang, tan ia u sha ka liang ka kolum haduh ba kut jong ka cell kaba ong “2000”
04:12	Kane ka jied ia ki kolum kiba ngi kwah ban pynbeit ryntih
04:15	Mynta, nion ha ka option Data ha ka menu bar bad nangta sa nion ha Sort
04:21	Mynta , jied Current Selection.
04:24	Phi iohi ba ka dialog box ka paw ryngkat ki tabs kum “Sort criteria” bad “Options”
04:31	Ha ka tab “Sort criteria, jied Cost ha ka bynta “Sort by ”
04:37	Khnang ban pynbeit ryntih ia ka “Cost” na ba rit shaba heh, nion ha ka option Ascending kaba mar bud bad ka.
04:44	Mynta nion ia u button OK
04:47	Phi iohi ba ki kolum la pynbeit ha ka rukom naba rit shaba heh.
04:51	Ha kajuh ka rukom, ban pynbeit ryntih na ba heh sha barit, nion ha Descending bad nangta sa nion ia u button OK.
04:59	To ngin pynkylla biang (undo ) ia kaei kaba ngi la dep leh
05:02	Bun tylli ki kolum lah ban pynbeit ryntih da kaba jied ia ki kolum bad nangta sa pyntreikam ia ka option Sort
05:09	Te shu ong , ngi kwah ban pynbet ryntih ia ka Serial Numbers bad kumjuh ia ka Cost
05:14	Te, nyngkong jied ia ki kolum kumba la leh hashwa
05:18	Mynta, nion ia ka option Data ha ka menu bar bad nangta sa nion Sort
05:24	Ha ka dialog box kaba paw, nyngkong eh jied “Cost” ha ka bynta “Sort by”
05:30	Nangta sa jied “SN” ha ka bynta “Then by”
05:35	Nion ha Descending ha baroh artylli ki option hajan jong ki bad nangta sa nion ha u button OK.
05:43	Phi iohi ba ia baroh artylli ki heading la dep pynbeit ha ka rukom naba heh shaba rit
05:47	To ngin pynkylla biang(undo) ia kaei kaba ngi la dep leh
05:49	Mynta, to ngin pule kumno ban filter ia ki data ha LibreOffice Calc
05:53	Ka filter kadei ka list jong ki kyndon ha kaba man ki jingtip kidei ban iahap khnang ban lah ban pyni ia ka.
06:00	Khnang ban pyntreikam ia u filter ha ka spreadsheet, ngin nion ha ka cell ba ai kyrteng”Item”
06:07	Mynta, nion ha ka option “Data” ha ka menu bar bad nangta sa nion ha “Filter”
06:12	Nion ha ka option “Auto Filter” ha ka pop-up menu
06:16	Phi iohi ia u dak khnam ba paw ha ki headings
06:20	Nion ha u khnam ba shapoh ha ka cell ba la ai kyrteng “item”
06:24	Mynta shubuh phi kwah ban pynpaw tang ia ki data ba iadei bad ka “electricity Bill”
06:29	Te , nion ha ka opshon “Electricity Bill”
06:34	Phi iohi ba tang ki data kiba don jingiadei bad ka “Electricity Bill” la pyni ha ka sheet.
06:40	Kiwei kiwei ki opshon lah weng lut.
06:43	Khnang ban lah ban peit ia baroh ki data, sa shisien nion ha u khnam ba shapoh ha ka cell ba kyrteng Item bad nangta sa nion ha “All”
06:52	Ngi iohi ba mynta ngi la lah ban peit ia baroh ki data kiba ngi la thoh naba sdang.
06:59	Shi bynta na ka “AutoFilter”, kidon sa ar tylli ki filter opshon kita kilong “Standard Filter” bad “Advanced Filter” kiba ngin sa pule hadien ha kane kajuh ka bynta.
07:11	Bad mynta ngi la poi sha kaba kut jong ka Spoken Tutorial Halor ka LibreOffice Calc
07:15	Ban kyllum lang, ngi lah pule shaphang
07:18	Ka jingsdang ia ki formula
07:21	Ka jingpynbeit ryntih katkum ki kolum
07:23	*ki bynta ka kongsan jong ka filtering data
07:26	Peit ia ka video ha ka link ba la ai harum.
07:30	Kane ka kyllum lang iaka Projek jong ka Spoken Tutorial.
07:33	Lada phim don ka bandwidth kaba biang, phi lah ban shu download bad peit ia ka hadien
07:37	Ka kynhun jong ka Spoken Tutorial
07:40	Ka pynlong ia ki workshop da kaba pyndonkam ia ki spoken tutorial
07:43	Ka ai sertiphikate sha kito kiba pass ha ka online test
07:47	Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka contact@spoken-tutorial.org
07:53	Ka spoken tutorial Projek kadei shibynta jong ka Talk to a Teacher project
07:58	Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT,MHRD, Sorkar India
08:06	Ia ki jingtip bakham bniah halor kane ka mission lah ban ioh na
08:08	spoken hyphen tutorial dot org slash NMEICT hyphen Intro
08:16	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