Meboreen Mary: Created page with "{|border=1 | '''Time''' | '''Narration''' |- | 00:00 | Ngi pdiang sngewbha ia phi sha ka Spoken Tutorial halor ka Libre Office Calc- Working with data |- | 00:06 | Ha kane k..."

2017-04-03T06:56:55Z

Created page with "{|border=1 | '''Time''' | '''Narration''' |- | 00:00 | Ngi pdiang sngewbha ia phi sha ka Spoken Tutorial halor ka Libre Office Calc- Working with data |- | 00:06 | Ha kane k..."

New page

{|border=1
| '''Time'''
| '''Narration'''

|-
| 00:00
| Ngi pdiang sngewbha ia phi sha ka Spoken Tutorial halor ka Libre Office Calc- Working with data

|-
| 00:06
| Ha kane ka jinghikai , ngin pule shaphang

|-
| 00:09
| Ka jingstet da kaba pyndonkam da ki Fill tools bad Selection lists

|-
| 00:13
| Ban sam lang iaki jingthoh hapdeng ki sheet

|-
| 00:16
| Ban weng iaki data, ban bujli iaki data bad pynkylla iaki katto katne ki bynta jong ka data.

|-
| 00:23
| Hangne ngi pyndonkam da ka'''Ubuntu Linux''' version '''10.04''' bad '''LibreOffice Suite''' version '''3.3.4'''.

|-
| 00:32
| Ban pynrung iaki data ha kas preadsheet kalah ban long kaba eh bad bunkam tangba ka Calc ka ai ia shibun kitiar pyndonkam kiba pynsuk shibun.

|-
| 00:42
| Kawei na ki kam kaba lah ban leh ka long ban '''drag bad drop''' iaki jingthoh jong kawei ka cell sha kawei pat ka cell da kaba pyndonkam ia u mouse.

|-
| 00:49
| Tangba kaCalc ka kynthup ruh ia shibun kiwei pat ki tools ban pynrung ha ka rukom automatic ia ki jingthoh, khamtam ia kiba ju pyndonkam man kapor

|-
| 00:57
| Kine ki tools ki long- '''Fill tool, Selection lists'''.

|-
| 01:01
| Kine kilah ban pynrung iaki jingtip ha ki bun tylli ki sheet jong kajuh ka dokumen

|-
| 01:06
| Ngin pule shaphang jongki kawei hadien kawei pat.

|-
| 01:09
| To ngin plie iaka file “Personal-Finance-Tracker.ods”

|-
| 01:14
| U Fill tool u long uba iarap shibun na ka bynta ban duplicate ia ki jingthoh ha ka sheet

|-
| 01:19
| Ha ka file “Personal-Finance-Tracker.ods”, to shu ong- ngikwah ban copy iaka data hapoh ka heading Cost shaki cell ba mar khap.

|-
| 01:30
| Te, nyngkong eh jied ia baroh ki data kiba donkam ban copy da kaba nion ha ka '''cell '''kaba don ia jingthoh “6000”

|-
| 01:38
| Mynta da kaba iai nion ia u mouse na kaliang ka diang bad tan lane drag ia u haduh bakut jongka cell kaba don iaka jingthoh “2000” hapoh ka Cost

|-
| 01:46
| Kumjuh ruh jied iaki cell ha kaba phi mut ban copy ia ka data.

|-
| 01:51
| Mynta , pyllait noh ia u mouse button ba sha kadiang

|-
| 01:53
| Nion ha u opshon Edit ha u menu bar bad nangta sa nion ia u opshon Fill

|-
| 01:59
| Ha ka pop-up menu, nion ha ka opshon Right

|-
| 02:03
| Phi iohi baka data hapoh ka heading “Cost” lah copy sha ki cell ba markhap

|-
| 02:09
| To ngin phai biang lane undo iaki jingpynkylla.

|-
| 02:12
| Kiwei kiwei ki jingpyndonkam kiba kham eh jong ka Fill tool ka long da kabapyndonkam ia u ban pyndap iaki series kum ki data ha ki sheets.

|-
| 02:20
| Ka Calc kaai iaka default lists naka bynta ki sngi ba pura bad ba lyngkot jong kataiew bad bnai jong u snem.

|-
| 02:27
| Ka ai lad ruh ia u nong pyndonkam ban shna la kajong ka lis.

|-
| 02:34
| Mynta, to ngin thep iaka heading kaba thymmai kaba kyrteng “Days” hapoh ka sheet jong ngi.

|-
| 02:38
| Hapoh kane, ngin leh ba kan pyni hi iaki 7 tylli ki sngi jong ka taiew

|-
| 02:43
| Jied ia 7 tylli ki cell kiba nyngkong kiba don hapoh ka heading “Days”.

|-
| 02:48
| Mynta, nion iaka Edit opshon ha ka menu bar bad leit shaka Fill opshon.

|-
| 02:53
| Nion ha ka opshon Series ha ka menu.

|-
| 02:57
| Phi iohi baka dialog- box ka paw ryngkat bad ka heading “Fill Series”

|-
| 03:02
| Mynta, hapoh ka heading- “Series type”, nion ha ka opshon “AutoFill”

|-
| 03:07
| Ha ka “Start value” field, ngi type iaka sngi ba nyngkong jong ka taiew , kata “Sunday”

|-
| 03:13
| Ka jingpynkiew la buh lypa “1”. Mynta, nion ha ka OK button

|-
| 03:18
| Phi iohi ba iaki sngi la dep pynrung ha ki cell

|-
| 03:23
| Phi lah ban pyndap tang iaki sngi jong ka taiew, u bnai lane snem da kajuh ka rukom kumba lah batai lypa ka Calc.

|-
| 03:32
| Kawei pat ka rukom na ka bynta ba kan pyndap hi iaki data balong mar bud kilong kumne harum.

|-
| 03:37
| Type “Sunday” ha ka cell bad sa nion Enter. Kane kan phai iaka jingmut jong ka sha ka cell kaba bud ha ka column.

|-
| 03:46
| Phai biang sha ka cell ha kaba ka “Sunday” la type. Phin sa iohi ba i box baiong barit ha trai kamon jong ka cell.

|-
| 03:55
| Nion ha kane ka box da u mouse

|-
| 03:57
| Tan ia u shapoh haduh ba phin da iohi Saturday ba ka paw hapoh ka synduk sha kaliang kamon.

|-
| 04:04
| Pyllait noh ia u mouse button

|-
| 04:06
| Ki cell la pyndap hi ia ki sngi jong ka taiew.

|-
| 04:10
| Kane ka buit ka treikam ha baroh ki data kiba mar bud. To ngin phai biang lane undo ia baroh ki jingpynkylla bangi la leh

|-
| 04:17
| Phi lah ruh ban shna iaki series tang shisien naka bynta ki number da kaba pyndap ia u numbar ba sdang, bakut bad uba kiew.

|-
| 04:24
| Ban batai ia kane, ngin pyndam shwa ia ki numbar ba la pyndap lypa ha ki cell “A1” haduh “A7”

|-
| 04:33
| Hadien ba lah pyndam ia ki numbar, jied biang ia ki cell kiba kdew kum “A2” haduh “A7”

|-
| 04:40
| Mynta, nion ia u '''Edit''' ha u menu bar bad nangta ha u '''Fill''' bad '''Series '''opshon.

|-
| 04:46
| Ka dialog-box kamih hakhmat jongngi. Mynta, nion ha u '''Linear '''opshon, hapoh jong u heading '''“Series type”''', lada ka khlem jied hi da lade.

|-
| 04:57
| Ha ka jaka'''“Start value”, '''ngin type ia u numbar basdang- kata “1”.

|-
| 05:03
| Ha ka jaka'''“End value”''', ngin type ia u numbar ba khatduh ba ngin pyndap kum “6”.

|-
| 05:08
| Mynta, ngin buh ia u “Increment” value kum “1” bad haba kut ngin nion ha u OK button.

|-
| 05:14
| Ngi iohi ba ki cell dalade hi kilah pyndap ia ki numbar ba marbud hadien jong u.

|-
| 05:21
| Ha baroh kine ki jait. U '''Fill''' tool u shna iaka jing iadei jongki cell ka ba neh shipor hapdeng jong ki. Shisien baka lah dep, kineki cell kim don shuh ha jing iadei hapdeng iwei bad iwei pat.

|-
| 05:32
| Shi bynta na ka Fill tool, kadon sa kawei ka tool kaba lah ban pynstet kata “Selection lists” kaba long tang bad ka text.

|-
| 05:40
| Ngin sa iakren ia kane ha ki jinghikai kiba shadien jong kane ka series.

|-
| 05:45
| Hadien ba ngi lah dep pule shaphang ka'''“Fill tools”''' bad '''“Selection lists”''', mynta ngin pule kumno ban sam ia ki jingthoh hapdeng ki sheet.

|-
| 05:52
| Ka Calc ka ai lad ia u nong pyndonkam ban pyndap ia kijuh ki jingtip ha kajuh ka cell ha bun tylli ki sheet.

|-
| 05:58
| Kane kamut, ha ka jaka ban pyndap ia kajuh kalis ha man kawei pa kawei ka sheet, phi lah ban shu pyndap ia ki shisien pyndap ha kajuh kapor.

|-
| 06:07
| Ha ka “Personal-Finance-Tracker.ods” file jong ngi, baroh ki data kidon ha ka'''Sheet 1'''.

|-
| 06:14
| Mynta, ngi kwah ka “Sheet 2” bad kumjuh ruh ka “Sheet 3” kin pyni kajuh ka data kumba don ha “Sheet 1”

|-
| 06:21
| Te , ngin nion ha ka opshon Edit ha ka menu bar bad nangta nion ha ka Opshon Sheet

|-
| 06:27
| Mynta, nion ha Select

|-
| 06:30
| Mynta, ha ka dialog box kaba paw, da kaba pyndonkam ia u Shift Key ngi jied ki opshon '''Sheet 1, “Sheet 2”''' and '''Sheet 3'''.

|-
| 06:40
| Bad nangta sa nion ha u OK button.

|-
| 06:42
| Kane ka ialam biang ia ngi sha '''Sheet 1'''

|-
| 06:45
| Mynta , to ngin pynrung khyndiat ki data ha “Sheet 1”

|-
| 06:49
| Kum ka nuska- ha ka '''cell''' kaba paw kum '''“F12”''' ngin type '''“This will be displayed on multiple sheets”'''

|-
| 06:57
| Mynta, nion ha ka “Sheet 2” bad “Sheet 3” tab uwei hadien uwei.

|-
| 07:02
| Ngi iohi ba ha man kine ki sheet, ki cell kiba paw kum '''“F12”''' kidon ia kijuh ki data.

|-
| 07:09
| To ngin phai biang lane undo ia baroh ki jingpynkylla ba ngi la leh

|-
| 07:12
| Ha kaba bud, to ngin pule shaphang kiwei ki lad ba ngin pyndam bad pynbeit ia ki data ha ki cell.

|-
| 07:18
| Ban pyndam ia ki data khlem da weng ia ki formatting jong ka cell, ngin shu jied beit ia ka cell.

|-
| 07:25
| Phi iohi ba ka data jong ka cell ka paw ha ka jaka jong ka '''“Input line”.'''

|-
| 07:30
| Mynta,nion ia u '''Backspace '''button ha ka keyboard.

|-
| 07:35
| Phi iohi ba ki data ki lah shah pyndam.

|-
| 07:37
| To ngin phai biang ia baroh ki jingpynkylla.

|-
| 07:39
| Ban kylliang ia ka data ha ka cell, shu jied ia ka cell bad type halor jong ka data kaba rim.

|-
| 07:46
| Ka data kaba thymmai kan sah ryngkat bad ka formatting jong ka. To ngin phai biang ia ki jingpyn kylla.

|-
| 07:52
| Khnang ban pynkylla ia ka bynta jong ka data ha ka cell, khlem da weng ia ki contents, shu nion arsien ha kata ka cell.

|-
| 08:01
| Mynta, da kaba kdew da u cursor, phi lah ban edit ia ka cell katkum ka jingdonkam.

|-
| 08:07
| To ngin pynphai biang ia ki jingpyn kylla.

|-
| 08:09
| Bad da kane ngi la poi sha bakut jong ka Spoken Tutorial halor ka LibreOffice Calc:

|-
| 08:15
| Ban batai kyllum; ngi la pule shaphang

|-
| 08:17
| Ban pynstet da kaba pyndonkam da u '''Fill''' tools bad '''Selection lists.'''

|-
| 08:20
| Ban iasam ia ki contents hapdeng ki sheets.

|-
| 08:23
| Ban weng ia ki data, kylliang, bad pyn kylla ia ka bynta jong ka data.

|-
| 08:29
| Peit ia ka video ha ka link ba la ai harum

|-
| 08:32
| Ka kyllum lang iaka Spoken Tutorial projek

|-
| 08:35
| Lada phim don ka jingstet ha ka bandwidth jong phi, phi lah ban shu download bad peit iaka hadien

|-
| 08:40
| Ka kynhun jong ka Spoken Tutorial

|-
| 08:43
| Ka pynlong ia ki workshop da kaba pyndonkam da ki spoken tutorials

|-
| 08:46
| Ka ai sertiphikate sha kito kiba pass ha ka online test

|-
| 08:49
| Na ka bynta ki jingtip ba bniah, thoh sha '''contact at spoken hyphen tutorial dot org'''.

|-
| 08:55
| Ka Spoken Tutorial Projek kadei ka bynta jong ka Talk To a Teacher projek

|-
| 09:00
| Ia kane la kyrshan da ka National Mission On Education lyngba ka ICT, MHRD, Sorkar India

|-
| 09:07
| Shibun ki jingtip halor kane ka mission ki don ha

|-
| 09:11
| '''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.

|-
| 09:18
| Ia kane ka jinghikai la pynkylla sha ka ktien Khasi da i Meboreen. Khublei shibun ia ka jingia snohkti lang jong phi.

|}

LibreOffice-Suite-Calc/C2/Working-with-data/Khasi - Revision history

Meboreen Mary: Created page with "{|border=1 | '''Time''' | '''Narration''' |- | 00:00 | Ngi pdiang sngewbha ia phi sha ka Spoken Tutorial halor ka Libre Office Calc- Working with data |- | 00:06 | Ha kane k..."