PoojaMoolya at 11:10, 13 April 2017

2017-04-13T11:10:53Z

Meboreen Mary at 06:00, 25 January 2017

2017-01-25T06:00:05Z

Meboreen Mary: Created page with " {| Border = 1 ! Time ! Narration |- |00:00 |Khublei, Ngi pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka '''LibreOffice Calc - Basics..."

2017-01-25T05:59:30Z

Created page with " {| Border = 1 ! <center>Time</center> ! <center>Narration</center> |- |00:00 |Khublei, Ngi pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka '''LibreOffice Calc - Basics..."

New page

{| Border = 1
! <center>Time</center>
! <center>Narration</center>
|-
|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
|'''<nowiki>* </nowiki>'''Ka jingsdang ia ki Formula ba kongsan

|-
|00:12
|<nowiki>* Jingpynbeit ryntih katkum ki Columns</nowiki>

|-
|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 '''cel'''l

|-
|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
|<nowiki>*ki bynta ka kongsan jong ka filtering data</nowiki>

|-
|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 [mailto:contact@spoken-tutorial.org 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.

|}

@@ Line 13: / Line 13: @@
 |-
 |00:09
-|'''<nowiki>* </nowiki>'''Ka jingsdang ia ki Formula ba kongsan
+|'''Ka jingsdang ia ki Formula ba kongsan
 |-
 |00:12
-|<nowiki>* Jingpynbeit ryntih katkum ki Columns</nowiki>
+| Jingpynbeit ryntih katkum ki Columns
 |-
@@ Line 329: / Line 329: @@
 |-
 |07:23
-|<nowiki>*ki bynta ka kongsan jong ka filtering data</nowiki>
+|ki bynta ka kongsan jong ka filtering data
 |-
@@ Line 377: / Line 377: @@
 |-
 |08:16
-|Ia kane ka tutorial la pynkylla sha ka ktien khasi da I Meboreen Mary Thongni.
+|Ia kane ka tutorial la pynkylla sha ka ktien khasi da I Meboreen Mary Thongni. Khublei shibun ia ka jingiasnohkti lang jong phi.
 Khublei shibun ia ka jingiasnohkti lang jong phi.
 |}

@@ Line 252: / Line 252: @@
 |05:47
 |To ngin pynkylla biang(undo) ia kaei kaba ngi la dep leh
 |-
@@ Line 382: / Line 379: @@
 |Ia kane ka tutorial la pynkylla sha ka ktien khasi da I Meboreen Mary Thongni.
 Khublei shibun ia ka jingiasnohkti lang jong phi.
 |}

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

PoojaMoolya at 11:10, 13 April 2017

Meboreen Mary at 06:00, 25 January 2017

Meboreen Mary: Created page with " {| Border = 1 ! Time ! Narration |- |00:00 |Khublei, Ngi pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka '''LibreOffice Calc - Basics..."