LibreOffice-Suite-Calc/C2/Formatting-Data/Khasi

From Script | Spoken-Tutorial
Revision as of 16:38, 13 April 2017 by PoojaMoolya (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Time Narration
00:00 Ngi pdiangsngewbha ia phi sha ka Spoken Tutorial halor ka Libre Office Calc- Ban leh ia ki jingpynkylla lane pynpher ia ki data ha calc
00:06 Ha kane ka jinghikai, ngin pule shaphang: * Ban pynpher ia ki bordar, bad ki rong jong ka bynta ba shadien(background)
00:12 Ban pynpher ia ki lain ba bun ba don jingthoh da kaba pyndonkam ia ka Automatic Wrapping
00:18 Ban Pyniasnoh lang ia ki Cell* Ban pynrit ia ki dak ban ngiam ha ka cell
00:22 Hangne ngi pyndonkam da ka Ubuntu Linux bershon 10.04 kum ka operating system bad ka  LibreOffice Suite version 3.3.4.
00:33 Nyngkong eh, to ngin ia pule shaphang kumno ban pynpher ne pynkylla ia ki bordar ha LibreOffice Calc.
00:39 To ngin ia plie ia ka file "personal finance tracker.ods"
00:45 Ban pynpher ne pynkylla ia ki border lah ban leh tang ha kawei ka cell ne bun tylli ki cell
00:50 Kum ka Nuksa- to ngin pynpher ia ki cell kiba don ki mat phang (headings) Serial NumberItemCostSpentReceivedDate and Account.
01:01 To, ngin nion nyngkong eh ha ka cell kaba don ka jingthoh “Serial Number”, ba la pyni dak da u “SN”
01:08 Mynta iai nion na ka liang kadiang jong u mouse bad ring ia u sha ka liang ba don ki mat phang (headings)
01:14 Ynda phi lah dep jied ia baroh kiba don ia ki mat phang sha ka bynta ba phi iohi da pynkiang, klik ha ka icon Borders ha ka Formatting toolbar.
01:23 Ka drop down box ba don bun jait ki border style ka plie
01:28 Jied kawei na ki jait bordar kaba phi kwah da kaba klik ha ka.
01:33 Ngan jied ia ka ba khatduh eh. Ngi iohi ba ki border ki lah pher bad la kylla thik katkum ka style kaba ngi la jied.
01:39 Te mynta ngin “undo” ia ki jingkylla ba ngi la leh
01:45 Ki cell ba ngi la jied ki dang long thaba. Mynta nion ha ka liang kamon jong u mouse ha ka jaka ba thaba jong ki cell bad jied ia bynta FormatCells .
01:54 Mynta nion ha ka bynta ba thoh Borders
01:56 Phin iohi bun ki ba phi lah ban jied na ka bynta ka Line arrangementLineSpacing to contents and Shadow style.
02:05 Kiba la paw ha kawei pa kawei ha kine kidei ki settings ba don lypa jong ka calc.
02:10 Hynrei, ngi lah ban pynkylla ia kine katkum ka jingdonkam jong ngi.
02:14 Hapoh jong ka bynta User-defined, phi lah ban iohi ia ka preview window kaba pyni ia kaba phi la dep jied.
02:22 Ngan jied ia ka bynta balai na kine kaba don hapoh Default bad phi lah ban iohi ba ka jingpynkylla ka paw ha ka preview window.
02:29 Ngan pynkylla ruh ia ki jinglong (Style), Ka pynkiang(Width) bad ki rong(Colors)
02:33 Sa shisien peit ia ki jingpher ha ka preview window.
02:38 Ka bynta ba don Spacing to contents  ka don ia ka Synchronized option ba la dep jied.
02:42 Kane ka mut ba ka juh ka jinglait jaka ka la treikam ha baroh ki margin.
02:47 Phi lah ruh ban uncheck ia ka bad pynkylla ia ki jinglait jaka jong ki margin (spacing) katkum ka jingdonkam.
02:53 Ngan pynkylla ia u margin ba hajrong bad hapoh sha ka jingheh kaba 1.4 pt.
03:00 Ngan ieh ha phi ba phin wad bniah ia kiwei pat ki rukom long“Shadow Styles” dalade.
03:04 Nion ha u OK.
03:06 Kane kan pynwan ia ka jinglong(style) ba phi jied ha ki cell ba la dep jied.
03:11 Hadien ba ngi lah dep pule shaphang kumno ban pynpher ia ki bordar, mynta to ngin pule shaphang kumno ban ai ia ki rong na ka bynta ba shadien (Background colors) ia ki cells.
03:18 Khnang ban ai rong ia ka bynta ba shadien jong ki cell, Ka Calc ka pynioh ia ka rukom ban jied ia kiba ngi khot Background Color, kaba don ha ka Formatting toolbar.
03:27 Te mynta, to ngin peit kumno ngi lah ban leh ia kane.
03:30 Kum ka nuksa, to ngin ia ai rong ia ka bynta ba shadien jong ki cell kiba don ia ki mat phang(headings)
03:36 Nyngkong eh, to ngin klik ha ka cell kaba don ia ka heading “Serial Number”, kaba la pyni dak da u “SN”.
03:44 Mynta, iai nion ia u mouse ha kaliang ka diang bad ring ia u sha ki cell kiba don ia ki mat phang (headings).
03:50 Hadien ba phi la dep jied ia ki cell sha ka pynkiang ba don ia ki heading, klik ha ka Formatting Toolbar bad sa klik ha “Background Color
04:00 Kawei ka menu kan sa plie ha kaba phin lah ban jied ia ki rong kiba phi kwah ban ai sha ka bynta ba shadien(background).
04:08 To ngin klik ha ka rong “Grey”
04:11 Phi lah ban iohi ba ka bynta ba shadien jong ka cell kaba don ki headings ka la kylla sha ka rong grey.
04:17 Ka Calc ka ai ruh ka lad babun rukom ban pynpher ne pynkylla ia ki bun tylli ki lain ba don jingthoh.
04:22 Kaba nyngkong eh ka long da kaba pyndonkam ia ka “Automatic Wrapping”.
04:26 “Automatic Wrapping” ka ai lad ia ki nongpyndonkam ban pynrung bun tylli ki jingthoh (lines of text) ha kawei ka cell
04:33 Te mynta, to ngin peit kumno ngi lah ban leh ia kane.
04:37 Mynta ha ka sheet “personal finance tracker.ods jong ngi, to ngin nion ha ka cell bym don jingthoh eiei.
04:44 Kum ka nuksa- to ngin nion ha ka cell nombar “B12”
04:49 Mynta, ha kane ka cell nion ha ka liang ka mon jong u mouse bad nangta sa nion ha ka bynta “Format Cells”
04:54 Mynta ha ka dialog- box, klik ha ka bynta “Alignment”
04:58 Ha trai jong ka dialog box, klik ha ka bynta“Wrap text automatically”  bad hadien kata sa klik OK .
05:08 Mynta ngin type, “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”.
05:11 Phi iohi ba ki katto katne ki jingthoh ki lah rung lang ha kawei ka cell.
05:19 Te mynta ngin weng noh lane “undo” ia ki jingkylla
05:21 Hadien ba ngi la pule shaphang ka “Automatic Wrapping”, mynta ngin pule shaphang kumno ban pyniasnoh lang ia ki cell ha Calc.
05:29 Ha ka file “personal finance tracker.ods”, lada ngi kwah ban pyniasnoh lang ia ki cell kiba don ia ka Serial Number da ka heading “SN” bad ia ki jingthoh baroh ba don ha ka, te nyngkong klik ha ka data entry “1” hapoh ka heading “SN”
05:46 Mynta , iai nion ia u Shift Key ha ka keyboard bad klik ha ka cell kaba don ka jingthoh “Salary”
05:55 Kane ka pynthaba ne pynshai ia ki ar tylli ki cell kiba ngin pyniasnoh.
05:59 Mynta klik ha ka “Format” kaba don hapoh ka menu bar bad nangta sa klik ha ka bynta “Merge Cells”
06:07 Ha ka sidebar kaba mih, klik ha ka opshon “Merge Cells”
06:12 Ban pyniasnoh lang ia ki jingthoh kiba don ha kine ki ar tylli ki cell ha kawei ka cell, klik ha ka opshon “Yes”kaba paw ha ka dialog box.
06:21 Phi iohi ba ki cell ba la jied ki la iasnoh lang ha kawei bad ki jingthoh ba don ha ki ruh ki la rung ha kajuh ka cell.
06:31 To mynta ngin weng biang ia ki jingpynkylla da kaba klik lang Ctrl + Z.
06:37 Mynta , ngin pule shaphang kumno ban pynrit ia ki jingthoh ba kin rung ha kawei ka cell
06:41 Ia ka font size lah ban pynrit khnang ban lah ban pynrung ia ki dak ha kawei ka cell da kaba suk.
06:49 To ngin pule kumno ban leh ia kane. To ngin type ia kane “This is for the month of January” ha ka cell  B14.
07:00 Phi iohi ba ki jingthoh kim rung lut ha ka cell
07:03 Khnang ban lah ban pynrung lut ia ki jingthoh ha kane ka cell, klik nyngkong eh ha ka cell B14.
07:11 Mynta klik ha ka bynta ba thoh Format ha ka menu bar bad nangta sa klik ha Cells.
07:18 Phi lah ruh ban shu klik ha ka liang ka mon jong u mouse ha kane ka cell bad sa klik Format Cells.
07:24 Phi iohi ba kawei ka dialog box “Format Cells” ka la plie.
07:28 Ha kane ka dialog- box , klik ha ka bynta ba thoh Alignment.
07:31 Ha trai jong kane ka dialog box, klik ha ka check-box “Shrink to fit cell size”  bad nangta sa klik OK .
07:41 Phi iohi ba ki jingthoh baroh ki la rit bad adjust hi da kaba ki pynduna ia ki jingheh khnang ba ki jingthoh ki lah ban rung ha ka cell ba la jied kata B14
07:54 To ngin pynkylla biang “undo” ia ki jingkylla ba ngi lah leh
07:57 Mynta ngi lah poi shaba kut jong ka “Spoken Tutorial” ha ka bynta halor ka LibreOffice Calc”
08:02 Ban pynkyllum lang, ngi la pule shaphang * Ban pynpher ia ki bordar, bad ki rong jong ka bynta ba shadien(background)
08:09 Ban pynpher ia ki lain ba bun ba don jingthoh da kaba pyndonkam ia ka Automatic Wrapping
08:14 Ban Pyniasnoh lang ia ki Cell* Ban pynrit ia ki dak ban ngiam ha ka cell
08:19 KA KAM BALA BYNSHET (COMPREHENSIVE ASSIGNMENT)
08:21 Plie ia ka sheet “spreadsheet practice.ods”.
08:25 Jied lane selek ia ki mat phang baroh (headings).
08:27 Pynkylla ia ka rong jong ka bynta ba shadien (background color) jong ki heading sha ka rong blue.
08:31 Da kaba pyndonkam ia ka “Automatic Wrapping”, type ia kane: “This is a Department Spreadsheet”
08:37 Pynrit ia kine ki jingthoh ba kin lah ban rung lut ha ka cell.
08:40 Peit ia ka video kaba don ha ka link ba la ai harum.
08:43 Kabatai kyllum lang iaka Projek jong ka Spoken Tutorial.
08:46 Lada phim don ka bandwidth kaba biang , phi lah ban shu download bad peit ia ka hadien
08:51 Ka kynhun jong ka Spoken Tutorial: Ka pynlong ia ki workshop da kaba pyndonkam ia ki spoken tutorial
08:56 Ka ai sertiphikate sha kito kiba pass ha ka online test
09:00 Na ka bynta ki jingtip ba kham bniah, sngewbha thoh sha ka contact@spoken-tutorial.org
09:06 Ka spoken Tutorial Projek kadei ka bynta jong ka projek kaba ki khot Talk to a Teacher.
09:11 Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India
09:18 Ia ki jingtip bakham bniah halor kane ka mission lah ban ioh na spoken hyphen tutorial dot org slash NMEICT hyphen Intro
09:29 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