Meboreen Mary: Created page with " {|border=1 | '''Time''' | '''Narration''' |- | 00:00 | Ngi pdiangsngewbha ia phi sha ka '''Spoken Tutorial''' halor ka '''Formulas and Functions''' ha ''..."

2017-04-03T10:09:48Z

Created page with " {|border=1 | '''Time''' | '''Narration''' |- | 00:00 | Ngi pdiangsngewbha ia phi sha ka '''Spoken Tutorial''' halor ka '''Formulas and Functions''' ha ''..."

New page

{|border=1
| '''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.

|}

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

Meboreen Mary: Created page with " {|border=1 | '''Time''' | '''Narration''' |- | 00:00 | Ngi pdiangsngewbha ia phi sha ka '''Spoken Tutorial''' halor ka '''Formulas and Functions''' ha ''..."