LibreOffice-Suite-Calc/C3/Formulas-and-Functions/Khasi

Time	Narration
00:00	Ngi pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka Formulas and Functions ha LibreOffice Calc.
00:07	Ha kane ka jinghikai, ngin pule shaphang Conditional Operator If..Or statement Basic statistic functions Rounding off numbers.
00:19	Hangne ngi pyndonkam da ka Ubuntu Linux version 10.04 kum ka  operating system bad ka LibreOffice Suite version 3.3.4.
00:30	Ngi la dep pule shakhmat kumno ban pyndonkam bad pyntreikam ia ki arithmetic operators ba kongsan kum addition, subtraction bad average ha ka data.
00:39	Mynta, to ngin pule shaphang khyndiat khynsoit ki operators ba donkam.
00:43	Uwei na ki operator ba ju pyndonkam barabor udei u Conditional Operator.
00:51	Ki Conditional Operators ki peit bniah ia ki kyndon ba la pyntreikam da u user ha ka data
00:56	Bad ki ai ia ka result ha Boolean – kata TRUE lane FALSE.
01:01	To ngin plié ia ka “Personal-Finance-Tracker.ods”.
01:05	Hangne, hapoh ka heading “Cost” ngi la dep list ia ka dor jong ki item ba bun
01:11	To ngin pyntreikam ia ki conditional operator ha kine bad peit ia ki result.
01:17	To ngin nion ha ka cell ba kyrteng “B10” bad type “Condition Result” hapoh jong ka.
01:24	Mynta , nion ha ka cell ba kyrteng “C10”
01:28	Ka result jong ka kyndon kan sa treikam bad sa paw ha kane ka cell.
01:33	Kynmaw ba ka dor jong ka “House Rent” kadei rupees 6,000.
01:38	Ka dor jong ka “Electricity Bill” kadei rupees 800.
01:43	Ka dor jong ka “House Rent” ka kham bun ban ia ka “Electricity Bill”.
01:48	Ngi lah ban pyntreikam shibun ki kyndon ha kine bad peit ia ki result.
01:54	Nion ha ka cell ba kyrteng kum “C10”.
01:57	Ha kane ka cell, type ia ka condition ba nyngkong kum is equal to C3 greater than C4 bad sa nion ia u Enter key
02:09	Namar ba ka dor ha ka cell C3 ka kham heh ban ia ka dor ha ka cell C4, ka result kaba ngi ioh kadei “TRUE”.
02:18	Mynta, to ngin pynkylla ia ka conditional statement sha: is equal to C3 less than C4.
02:26	Nion Enter
02:28	Ka result kaba ngi ioh kadei FALSE.
02:32	Ha kajuh ka rukom, ngi lah ban pyntreikam ia kiwei pat ki conditional statement bad peit bniah ia ki result.
02:38	Kine ki statement ki long kiba donkam shibun haba pyniadei bad ki data kiba heh baheh.
02:44	Phi lah ruh ban pyndonkam ia ka If lane Or condition ha ka data
02:49	Ban print ia ki result katkum ki kyndon kiba ong TRUE
02:55	To ngin nion ha ka cell ba kyrteng kum “C10”bad type:
02:59	is equal to IF bad hapoh ki braces, C3 greater than C4 comma, hapoh ki double quotes “Positive” comma bad sa shisien hapoh ki double quotes “Negative”.
03:16	Kane ka mut, ba lada u value ha cell C3 u kham heh ban ia u value ha C4, “Positive” kan sa mih.
03:25	Lym kumta, kan sa paw “Negative”.
03:28	Mynta , nion enter
03:31	Phin iohi ba ka result kadei “Positive” namar rupees 6000 ka heh ban ia rupees 800.
03:39	Mynta ha ka conditional statement, to ngin pynkylla “greater than” sha “less than” bad nion  Enter key.
03:47	Phi shem ba ka result mynta kadei “Negative”, namar ba u value ha cell C3 u heh ban ia u value ha cell C4.
03:57	Phi iohi ruh ia ka jingkylla ha ka result , lada ngi pynkylla ia ka data ha ki cell C3 bad C4.
04:04	Ka result kaba mih mynta kadei Negative.
04:09	Mynta , to ngin pynkiew ia u value ha ka cell C4 sha “7000” bad nion Enter key
04:17	Ka result ka la kylla hi sha “Positive”.
04:22	Sa shisien, to ngin pynrit ia u value ha cell C4 sha “800”
04:26	Bad nion ia u enter Key
04:29	Ka result kan sa kylla hi sha “Negative”.
04:34	Mynta to ngin pyndam noh ia ki jingpynkylla ba ngi la leh
04:38	Nangta, to ngin pule shaphang khyndiat khynsoit ki arithmetic bad statistic functions.
04:43	Ki arithmetic function ba kongsan ki kynthup ia SUM na bynta ka addition, PRODUCT na bynta multiplication,QUOTIENT na bynta division bad shibun kiwei kiwei kiba ngi la dep pule lypa ha ki jinghikai ba la dep
04:57	Mynta , to ngin leh katto katne ki operation ban peit kumno ka Sum, Product bad ka Quotient functions ka treikam
05:05	Nyngkong eh, to ngin jied “Sheet 3”.
05:08	Pyndap ia ki number “50”, ”100” bad ”150” hapoh ki cell ba kyrteng “B1”, “B2” bad “B3” kawei hadien kawei
05:19	Nion ha ka cell A4 bad type SUM
05:23	Nion ha ka cell B4.
05:26	Ngin khein ia ka result ha kane ka cell.
05:30	Type : : is equal to “SUM”  bad hapoh braces B1 comma B2 comma B3.
05:37	Nion enter
05:39	Phin iohi ba ka result ka pyni “300”.
05:43	Phi lah ruh ban pyndap ia ka range jong ki cell kumne
05:47	Nion ha B4 sa shisien
05:49	Mynta, hapoh ki braces, ha ka jaka jong B1 comma B2 comma B3, type B1 colon B3
05:58	Nion enter
06:00	Sa shisien , ka result ka pyni “300”.
06:03	Mynta, to ngin nion ha ka cell “A5” bad type: “PRODUCT”.
06:08	Nion ha ka cell “B5”.
06:10	Hangne, type is equal to “PRODUCT” bad hapoh ki braces, B1 colon B3.
06:18	Nion Enter
06:20	Phin iohi ba ka result ka pyni “7,50,000”.
06:26	Mynta to ngin peit kumno ka Quotient ka treikam
06:29	Nion ha ka cell ba kyrteng “A6” bad type: “QUOTIENT”.
06:34	Mynta nion ha ka cell “B6”.
06:37	Ngin pyndonkam ia kane ka cell ban khein ia ka result.
06:40	Bad type: is equal to QUOTIENT bad hapoh ki braces, B2 comma B1
06:47	Nion Enter
06:49	Phin ioh ia ka result kum “2”. Kata kadei namar “100” divide da u “50” ka mih 2.
06:59	Kumjuh ruh, ngi lah ban leh shibun ki arithmetic operations ha Calc.
07:05	Mynta, to ngin pule kumno ban pyndonkam ia ki Functions.
07:09	Ki Statistical functions ki long kiba iarap shibun ban khmih bha ia ki data ha ki spreadsheet. Kum ka nuksa ki function kum COUNT, MIN, MAX, MEDIAN, MODE  bad kiwei kiwei ki dei kiba long statistical
07:27	Nyngkong eh, nion ha sheet 1.
07:30	To ngin peit kumno ban wad ia ka the minimum,ka maximum bad ka median costs, da kaba pyndonkam da ki statistical functions.
07:37	To ngin nion ha ka cell ba kyrteng “C10” ha kaba ngin sa pyni ia ka result.
07:44	Hapoh ka heading “Cost” ngi don tang khyndiat ki entry
07:48	Ka minimum cost kadei rupees 300.
07:51	Ka maximum cost kadei rupees 6000.
07:55	Kine ki long ki result kiba dei ban paw haba ngi pyndonkam ia ki function jong ki
08:00	Ha ka cell “C10”, to ngin type: is equal to MAX bad hapoh braces C3 colon C7.
08:10	Mynta, nion ia u Enter Key.
08:13	Phin iohi ba ka result kadei “6000” kaba long ka value baheh tam ha ka kolum
08:20	Mynta, to ngin bujli ia ka jingthoh “MAX” ha ka statement da “MIN”
08:25	Bad nion ia U Enter Key
08:28	Phin iohi ba ka result kadei “300” kaba long ka value barit tam ha ka Cost kolum
08:34	Ban wad ia ka median value, bujli ia ka jingthoh “MIN” da “MEDIAN”
08:40	Bad nion ia U Enter Key
08:43	Ka result ka pyni “800” kaba long ka median cost ha ka kolum
08:50	Kumjuh ruh, phi lah ban pyndonkam da kiwei ki statistical functions halor ki data bad ban peit bniah ia ki kawei pa kawei.
08:58	To ngin pyndam ia ki jingpynkylla ha ka cell
09:02	Mynta, to ngin pule kumno ban round off  ia ki number
09:05	To ngin leh khyndiat ki jingpynkylla hapoh ka heading- “Cost”.
09:09	Ngin pynkylla :“6000” sha “6000.34”“600” sha “600.4”, ”300”sha “300.3”.
09:23	Mynta , nion ha ka cell ba kyrteng “B11” bad type ia ka heading “ROUNDING OFF”.
09:31	Nion ha ka cell ba kyrteng “C11” ha kaba ngin wad ia ka total jong ki items hapoh ka heading “Cost”.
09:39	Ha ka cell C11, to ngin type : is equal to SUM bad hapoh braces C3 colon C7.
09:49	Mynta, nion ia u Enter key.
09:53	Phin iohi ba ka total kadei “9701.04”.
09:59	Mynta shubuh ngim kwah ban buh decimal ha ka result jong ngi
10:04	Ka lad ba biang eh ka dei ban round off ia ka result sha u whole number ba jan tam.
10:09	To ngin nion ha ka cell kaba don ka total “9701.04”.
10:15	Type: is equal to ROUND, open brace SUM bad sa shisien hapoh braces C3 colon C7.
10:25	Khang noh ia u brace. Nion ia u Enter key.
10:29	Phi iohi ba ka result mynta kadei “9701” kaba long “9701.04”, ba la round off sha u whole number ba jan tam.
10:44	Ka rounding off lah ruh ban leh sha u whole number uba rit lane uba heh.
10:52	To ngin nion ha ka cell kaba don ka result bad edit ia ka jingthoh “ROUND”sha “ROUNDUP”.
10:59	Mynta, nion ia u Enter key.
11:02	Ka result mynta kadei “9702” uba dei u whole number uba heh
11:10	Khnang ban round off sha u whole number barit, pynkylla ia ka jingthoh “ROUNDUP” sha “ROUNDDOWN”
11:17	Bad nion ia u Enter key.
11:19	Ka result mynta kadei “9701” uba dei u whole number uba rit
11:28	To ngin weng noh lane undo ia ki jingpynkylla ban ioh ia ka “Personal-Finance-Tracker.ods” kumba ka long naba sdang.
11:37	Bad da kane ngi la poi shaba kut jong ka Spoken Tutorial halor ka LibreOffice Calc.
11:43	Ban batai lyngkot, ngi la dep pule shaphang: Conditional Operator If..Or statement Basic statistic functions Rounding off numbers.
11:55	Peit ia ka video ba la ai ha ha ka link harum
11:58	Ka kyllum lang ia ka Spoken Tutorial project.
12:01	Lada phim don ia ka bandwidth kaba biang phi lah ban shu download bad peit ia ka.
12:06	Ka kynhun jong ka Spoken Tutorial projek
12:08	Ka pynlong ia ki workshop da kaba pyndonkam ia ki spoken tutorials.
12:11	Ka ai sertiphikate sha klto kiba pass ha ka online test
12:15	Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha contact at spoken hyphen tutorial dot org.
12:21	Ka Spoken Tutorial projek kadei shibynta jong ka Talk to a Teacher projek.
12:26	Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT, MHRD, sorkar India.
12:34	Shibun ki jingtip halor kane ka mission kidon ha
12:37	spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
12:45	Ia kane ka tutorial la pynkylla sha ka Ktien Khasi da I Meboreen Mary. Khublei shibun ia ka jingiasnoh kti lang jong phi.

Contributors and Content Editors

Meboreen Mary