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

From Script | Spoken-Tutorial
Jump to: navigation, search
Time
Narration
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 Ka jingsdang ia ki Formula ba kongsan
00:12 Jingpynbeit ryntih katkum ki Columns
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 cell
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 ki bynta ka kongsan jong ka filtering data
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 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.

Contributors and Content Editors

Meboreen Mary, PoojaMoolya