LibreOffice-Suite-Calc/C2/Basic-Data-Manipulation/Manipuri
From Script | Spoken-Tutorial
Revision as of 18:31, 7 June 2017 by Kishorjitn (Talk | contribs)
Time | Narration’ |
00:00 | ’’’ꯂꯤꯕꯔꯑꯣꯐꯤꯁ ꯀꯦꯜꯁꯤ - ꯕꯦꯁꯤꯛꯁ ꯑꯣꯐ ꯗꯥꯇꯥ ꯃꯦꯅꯤꯄꯨꯂꯦꯁꯟ’’’ (LibreOffice Calc – Basics of Data Manipulation) ꯒꯤ ’’’ꯁ꯭ꯄꯣꯀꯟ ꯇꯨꯇꯣꯔꯤꯌꯦꯜ’’’ (Spoken tutorial) ꯗꯥ ꯇꯥꯔꯥꯝꯅꯥ ꯑꯣꯛꯆꯔꯤ ꯫ |
00:07 | ꯃꯁꯤꯒꯤ ꯇꯨꯇꯣꯔꯤꯌꯦꯜ (tutorial) ꯑꯁꯤꯗꯥ ꯑꯩꯈꯣꯢꯅꯥ ꯇꯝꯒꯗꯧꯔꯤꯕꯥ ꯑꯗꯨꯗꯤ : |
00:09 | ꯕꯦꯁꯤꯛ (basic) ꯁꯤꯡꯒꯤ ’’’ꯐꯣꯔꯃꯨꯂꯥ ’’’ (Formula) ꯒꯤꯋꯥꯍꯧꯗꯣꯛ꯫ |
00:12 | ꯀꯂꯝ (’’’column’’’) ꯁꯤꯡꯅꯥ ꯁꯣꯔꯇꯤꯡ (sorting) ꯇꯧꯕ꯫ |
00:15 | ’’’ꯐꯤꯜꯇꯔꯤꯡ ꯗꯇ’’’ (’’’filtering data’’’) ꯒꯤ ꯕꯦꯁꯤꯛꯁꯤꯡ꯫ |
00:17 | ꯃꯁꯤꯗ ꯑꯩꯈꯣꯢꯅ ’’’ꯎꯕꯨꯟꯇꯨ ꯂꯤꯅꯛꯁ’’’ (’’’Ubuntu Linux’’’) ꯒꯤ ꯚꯔꯖꯟ (version) ’’’꯱꯰꯬꯰꯴’’’ ꯕꯨ ꯑꯣ ꯄꯔꯦꯇꯤꯡ ꯁꯤꯁꯇꯦꯝ (operating system) ꯑꯣꯢꯅ ꯑꯃꯗꯤ ’’’ꯂꯤꯕꯔꯑꯣꯐꯤꯁ ꯁꯌꯨꯠ’’’ (’’’LibreOffice Suite’’’) ꯚꯔꯖꯟ (version) ’’’꯳꯬꯳꯬꯴’’’ ꯁꯤꯖꯤꯟꯅꯒꯅꯤ ꯫ |
00:27 | ꯑꯩꯈꯣꯢ ꯇꯨꯇꯣꯔꯤꯌꯦꯜ (tutorial) ꯑꯁꯤ ’’’ꯂꯤꯕꯔꯑꯣꯐꯤꯁ ꯀꯦꯜꯁꯤ ’’’ (’’’LibreOffice Calc’’’) ꯗꯥ ꯁꯤꯖꯤ ꯟꯅꯔꯤꯕ
ꯕꯦꯁꯤꯛ ꯐꯣꯔꯃꯨꯂꯥꯁꯤꯡ (basic formulas) ꯒꯤ ꯃꯇꯥꯡꯗꯒꯤ ꯍꯥꯟꯅ ꯇꯝꯕ ꯍꯧꯔꯁꯤ ꯫ |
00:35 | ꯐꯣꯔꯃꯨꯂꯥ (formula) ꯁꯤꯡ ꯍꯥꯢꯕ ꯑꯁꯤ ꯃꯁꯤꯡ ꯑꯃꯗꯤ ’’’ꯚꯦꯔꯤꯌꯦꯕꯜ’’’ (’’’variable’’’) ꯃꯌꯥꯝꯕꯨ ꯁꯤꯖꯤ ꯟꯅꯕ ꯏꯀ꯭ꯋꯦꯁꯟ (equation) ꯁꯤꯡ ꯑꯗꯨꯕꯨꯅꯤ ꯫ |
00:41 | ’’’ꯏꯁꯄ꯭ꯔꯦꯗꯁꯤꯠ’’’ (’’’spreadsheet’’’) ꯑꯃꯗ ꯚꯦꯔꯤꯌꯦꯕꯜ (variable) ꯁꯤꯡ ꯑꯁꯤ ꯏꯀ꯭ꯋꯦꯁꯟ (equation) ꯑꯗꯨꯕꯨ ꯃꯄꯨꯡ ꯐꯥꯍꯟꯕꯗ ꯃꯊꯧ ꯇꯥꯔꯤꯕ ꯗꯇ (data) ꯗꯨꯕꯨ ꯌꯥꯎꯔꯤꯕ ’’’ꯁꯦꯜ’’’ (’’’cell’’’) ꯒꯤ ꯃꯐꯝꯁꯤꯡ ꯑꯗꯨꯅꯤ ꯫ |
00:47 | ꯈ꯭ꯌꯥꯢꯗꯒꯤ ꯍꯦꯟꯅ ꯁꯤꯖꯤꯟꯅꯕ ꯕꯦꯁꯤꯛ (basic) ꯑꯦꯔꯤꯠꯃꯦꯇꯤꯛ (arithmetic) ꯑꯣꯄꯔꯦꯁꯟ (operation) ꯁꯤꯡꯗꯤ ꯇꯤꯟꯁꯤꯟꯕ, ꯈꯥꯢꯗꯣꯛꯄ, ꯄꯨꯔꯤꯕ ꯑꯃꯗꯤ ꯌꯦꯟꯅꯕꯅꯤ ꯫ |
00:56 | ꯍꯧꯖꯤꯛ ꯑꯩꯈꯣꯢ ꯑꯧꯈꯣꯢꯒꯤ “ꯄꯔꯁꯅꯦꯜ-ꯐꯥꯢꯅꯥꯟꯁ-ꯇ꯭ꯔꯦꯀꯔ.ꯑꯣꯗꯤꯑꯦꯁ” (“Personal-Finance-Tracker.ods”) ꯐꯥꯢꯜ (file) ꯑꯁꯤ ꯍꯥꯟꯅ ꯍꯥꯡꯗꯣꯛꯂꯁꯤ ꯫ |
01:02 | ꯑꯩꯈꯣꯢꯒꯤ “ꯄꯔꯁꯅꯦꯜ-ꯐꯥꯢꯅꯥꯟꯁ-ꯇ꯭ꯔꯦꯀꯔ.ꯑꯣꯗꯤꯑꯦꯁ” (“Personal-Finance-Tracker.ods”) ꯐꯥꯢꯜ (file) ꯑꯁꯤꯗ, ꯍꯦꯗꯤꯡ (heading), “ꯀꯣꯁ꯭ꯠ (cost) ꯒꯤ ꯃꯈꯥꯗ ꯄꯜꯂꯤꯕ ꯑꯦꯛꯁꯄꯦꯟꯁ (expense) ꯁꯤ ꯡꯒꯤ ꯀꯣꯁ꯭ꯠ (cost) ꯄꯨ ꯃꯇꯧ ꯀꯔꯝꯅ ꯇꯤꯟꯁꯤꯟꯒꯅꯤ ꯍꯥꯢꯕꯗꯨ ꯌꯦꯡꯜꯁꯤ ꯫ |
01:13 | ꯑꯩꯈꯣꯢꯅ “ꯃꯤꯁꯦꯂꯦꯅꯤꯌꯁ” (“Miscellaneous”) ꯒꯤ ꯃꯈꯥꯗ “ꯁꯝ ꯇꯣꯇꯦꯜ” ꯀꯧꯕ ꯍꯦꯗꯤꯡ (heading) ꯑꯃꯥ ꯑꯃꯨꯛ ꯄꯤꯔꯁꯤ ꯫ |
01:19 | ꯑꯗꯨꯒ ꯑꯧꯈꯣꯢꯅ ’’’ꯁꯦꯜ ꯑꯦ ꯸’’’ ꯗ ꯅꯝꯂꯅꯤ ꯑꯃꯗꯤ ꯁꯤꯔꯤꯌꯦꯜ ꯅꯝꯕꯔ ꯑꯗꯨ “꯷” ꯊꯝꯒꯅꯤ ꯫ |
01:25 | ꯑꯗꯨꯒ ꯑꯧꯈꯣꯢꯅ ꯑꯄꯨꯟꯕ ꯀꯣꯁ꯭ꯠ (cost) ꯁꯤꯡꯕꯨ ꯎꯍꯟꯕ ꯄꯥꯝꯂꯤꯕ ꯁꯦꯜ (cell) ꯅꯝꯕꯔ (number) “ꯁꯤ ꯸” (“C8”) ꯇꯥ ꯅꯝꯒꯅꯤ ꯫ |
01:32 | ꯀꯣ ꯁ꯭ꯠ (cost) ꯁꯤꯡ ꯑꯗꯨꯕꯨꯂꯣ ꯢꯅ ꯇꯤꯟꯁꯤꯟꯅꯕ, ꯑꯩꯈꯣꯢꯅ ꯅꯝꯒꯅꯤ : ’’’ꯏꯁꯏꯀ꯭ꯌꯦꯜꯇꯨ ꯁꯝ’’’ (’’’is equal to SUM’’’) ꯑꯃꯗꯤ ꯕ꯭ꯔꯦꯁꯦꯁ (Braces) ꯃꯅꯨꯡꯗ ꯇꯤꯟꯁꯤꯟꯒꯗꯧꯔꯤꯕ ꯀꯂꯝ (column) ꯁꯤꯡꯒꯤ ꯔꯦ ꯟꯖ (range), ꯍꯥꯢꯕꯗꯤ , ’’’ꯁꯤ ꯳ ꯀꯣꯂꯣꯟ ꯁꯤ ꯷’’’꯫ |
01:44 | ꯍꯧꯖꯤꯛꯀꯤ ꯕꯣꯔ꯭ꯗ (keyboard) ꯇꯥ ’’’ ꯏ ꯟꯇꯔ’’’ (’’’Enter ’’’) ꯅꯝꯂꯣ ꯫ |
01:47 | ’’’ꯀꯣꯁꯠ꯭’’’ (’’’Cost’’’) ꯃꯅꯨꯡꯗ ꯂꯩꯕ ꯑꯥꯢꯇꯦꯝ (item) ꯁꯤꯡ ꯂꯣꯢꯅ ꯇꯤꯟꯁꯤꯟꯕ ꯎꯕꯤꯒꯅꯤ ꯫ |
01:51 | ꯍꯧꯖꯤꯛ ’’’ꯀꯦꯜꯁꯤ ’’’ (’’’Calc’’’) ꯗꯥ ꯃꯇꯧ ꯀꯔꯝꯅ ꯈꯥꯢꯗꯣꯛꯅꯒꯅꯤ ꯍꯥꯢꯕꯗꯨ ꯇꯝꯂꯁꯤ ꯫ |
01:55 | ꯑꯩꯈꯣꯢꯅ ꯀꯔꯤꯒꯨꯝꯕ ’’’ꯌꯨꯝꯒꯤ ꯚꯔꯥ ’’’ ꯑꯃꯗꯤ ’’’ꯃꯩꯒꯤ ꯈꯖꯅ’’’ ꯒꯤ ꯃꯃꯜ ꯑꯗꯨ ꯈꯥꯢꯗꯣꯛꯅꯤꯡꯂꯕ ꯑꯃꯗꯤ
’’’ꯁꯦꯜ’’’ (’’’cell’’’) ꯔꯤꯐꯔꯦꯟꯁ꯭ꯗ (referenced) ꯕꯨ ’’’ꯑꯦ ꯹’’’ (’’’A9’’’) ꯑꯣꯢꯅ ꯎꯍꯟꯅꯤꯡꯂꯕꯗꯤ , ꯆꯝꯅ ’’’’ꯑꯦ꯹’ ꯁꯦꯜ’’’ (’’’’A9’ cell’’’) ꯗ ꯍꯥꯟꯅ ꯅꯝꯕꯤꯌꯨ꯫ |
02:06 | ꯍꯧꯖꯤꯛ ꯃꯁꯤꯒꯤ ꯁꯦꯜ (cell) ꯑꯁꯤꯗ ’’’ꯏꯁꯏꯀ꯭ꯋꯦꯜꯇꯨ’’’ (’’’is equal to’’’) ꯑꯃꯗꯤ ꯕꯔꯦꯁꯦꯁ (braces) ꯃꯅꯨꯡꯗ ꯃꯁꯥ ꯃꯁꯥꯒꯤ ’’’ꯁꯦꯜ ꯔꯤꯐꯔꯦꯟꯁ’’’ (’’’cell reference’’’) ꯁꯤꯡ ꯍꯥꯢꯕꯗꯤ , ’’’ꯁꯤ꯳ꯃꯥꯢꯅꯁ ꯁꯤ ꯴’’’ (’’’C3 minus C4’’’) ꯅꯝꯕꯤꯔꯣ ꯫ |
02:17 | ꯀꯤꯕꯣꯔ꯭ꯗ (keyboard) ꯇ ’’’ ꯢ ꯟꯇꯔ’’’ (’’’enter’’’) ꯀꯤ (key) ꯅꯝꯂꯣ ꯫ |
02:20 | ꯑꯩ ꯈꯣꯢꯅ ꯎꯔꯦ ꯃꯗꯨꯗꯤ ꯁꯦꯜ ꯔꯤꯐꯔꯦꯟꯁ (cell reference) ꯑꯅꯤ ꯗꯨꯗ ꯌꯥ ꯎꯕ ꯃꯃꯜ ꯑꯗꯨ ꯈꯥ ꯢꯗꯣꯛꯅꯔꯦ ꯑꯃꯗꯤ
ꯐꯣꯜ ꯑꯗꯨ ꯁꯦꯜ (cell ) ꯅꯝꯕꯔ (number) ’ꯑꯦ ꯹’ (’A9’) ꯗ ꯎꯠꯂꯦ ꯫ |
02:29 | ꯑꯩꯈꯣꯢꯅ ꯇꯧ ꯈꯤꯕꯁꯤꯡ ꯑꯗꯨ ’’’ꯑꯟꯗꯨ’’’ (’’’undo’’’) ꯇꯧꯔꯁꯤ ꯫ |
02:32 | ꯃꯁꯤꯒ ꯃꯥꯟꯅꯅꯥ ꯁꯦꯜ (cell) ꯃꯈꯜ ꯁꯤꯡꯗ ꯂꯩ ꯕ ꯗꯇ ꯕꯨ ꯌꯦꯟꯅꯕ ꯑꯃꯗꯤ ꯄꯨꯔꯤꯕ ꯌꯥꯒꯅꯤ ꯫ |
02:37 | ꯑꯇꯣꯞꯄ ꯏꯁꯄ꯭ꯔꯦꯗꯁꯤꯠ (spreadsheet) ꯒꯤ ꯑꯆꯝꯕ ꯑꯣ ꯄꯔꯦꯁ ꯟ (operation) ꯑꯃꯗꯤ ꯃꯁꯤꯡꯁꯤꯡꯒꯤ
ꯑꯦꯚꯔꯦꯖ (average) ꯄꯨꯊꯣꯛꯄꯅꯤ ꯫ |
02:43 | ꯃꯁꯤ ꯀꯃꯥꯢꯅ ꯇꯧꯕꯒꯦ ꯌꯦꯡꯂꯁꯤ ꯫ |
02:45 | ꯑꯩꯈꯣꯢꯅ “ꯁꯝ ꯇꯣꯇꯦꯜ” (“SUM TOTAL”) ꯁꯦꯜ (cell) ꯒꯤ ꯍꯦꯛ ꯃꯈꯥꯗ ꯍꯦꯗꯤꯡ (heading) ꯑꯗꯨ ꯑꯦꯚꯔꯦ ꯖ (average) ꯍꯥꯢꯅ ꯄꯔꯁꯤ ꯫ |
02:50 | ꯃꯁꯤꯗ ꯑꯩꯈꯣꯢꯅ ꯑꯄꯨꯟꯕ ꯃꯃꯜꯗꯨꯒꯤ ꯑꯦꯚꯔꯦꯖ (average) ꯎꯠꯄ ꯄꯥꯝꯂꯤ ꯫ |
02:55 | ꯑꯗꯨꯅ ꯑꯩꯈꯣꯢ “ꯁꯤ ꯹” (“C9”) ꯁꯦꯜ (cell) ꯗ ꯅꯝꯂꯁꯤ ꯫ |
02:58 | ꯍꯧꯖꯤꯛ ꯕ꯭ꯔꯦꯁꯦꯁ (braces) ꯃꯅꯨꯡꯗ ꯅꯝꯒꯅꯤ : ’’’ꯏꯁꯏꯛꯋꯦꯜꯇꯨ ꯑꯦꯚꯔꯦꯖ’’’ ꯑꯃꯗꯤ ’’’ꯀꯣꯁꯠ꯭’’’꯫ |
03:04 | ꯀꯤꯕꯣꯔ꯭ꯗ (keyboard) ꯇꯥ ’’’ ꯏ ꯟꯇꯔ’’’ (’’’Enter’’’) ꯀꯤ ꯅꯝꯂꯣ ꯫ |
03:07 | ꯅꯍꯥꯛꯅ ꯁꯦꯜ (cell) ꯗꯨꯗ ’’’ꯀꯣꯁ꯭ꯠ꯭’’’ (’’’Cost’’’) ꯀꯂꯝ ꯒꯤ ꯑꯦꯚꯔꯦꯖ (average) ꯎꯠꯄ ꯎꯒꯅꯤ ꯫ |
03:11 | ꯑꯩꯈꯣꯢꯅ ꯇꯧꯈꯤꯕꯁꯤꯡ ꯑꯗꯨ ’’’ꯑꯟꯗꯨ’’’ (’’’undo’’’) ꯇꯧꯔꯁꯤ ꯫ |
03:15 | ꯃꯁꯤꯒ ꯃꯥꯟꯅꯅꯥ ꯅꯍꯥꯛꯅ ꯍꯣꯔꯥꯢꯖꯣꯟꯇꯦꯜ (horizontal) ꯔꯣ (row) ꯗ ꯂꯩꯕ ꯏꯂꯤꯃꯦꯟꯠ (element) ꯁꯤ ꯡꯒꯤ ꯑꯦꯚꯔꯦꯖ (average) ꯄꯨꯊꯣꯛꯄ ꯌꯥꯢ꯫ |
03:20 | ꯑꯩꯈꯣꯢꯅ ꯐꯣꯔꯃꯨꯂꯤ (formulae) ꯑꯃꯗꯤ ꯑꯣꯄꯔꯦꯇꯔ (operator) ꯁꯤꯡꯒꯤ ꯃꯔꯝꯗ ꯑꯍꯦꯟꯕꯁꯤꯡ ꯑꯦꯗꯚꯥ ꯟꯁ (advanced) ꯂꯦꯚꯦꯜ (level) ꯇꯨꯇꯣꯔꯤꯢꯜ (tutorial) ꯁꯤꯡꯗ ꯇꯝꯒꯅꯤ ꯫ |
03:25 | ꯍꯧꯖꯤꯛ ’’’ꯀꯦꯜꯁꯤ ꯏꯁꯄ꯭ꯔꯦꯗꯁꯤꯠ’’’ (’’’Calc spreadsheet’’’) ꯇ ꯗꯇ (data) ꯀꯔꯝꯅ ꯁꯣꯔꯠ꯭ (sort)
ꯇꯧꯒꯅꯤ ꯇꯝꯂꯁꯤ ꯫ |
03:30 | ꯁꯣꯔꯇꯤꯡ (Sorting) ꯅ ꯁꯤꯠ (sheet) ꯑꯗꯨꯗ ꯂꯩꯕ ꯚꯤꯁꯤꯕꯜ (visible) ꯁꯦꯜ (cell) ꯁꯤꯡꯕꯨ ꯑꯄꯥꯝꯕ ꯃꯑꯣ ꯡꯗ ꯁꯤꯟꯗꯣꯛꯏ꯫ |
03:35 | ꯀꯣꯜꯁꯤ (Calc) ꯗ ꯅꯍꯥꯛꯅ ꯗꯇ (data) ꯁꯤꯡꯕꯨ ꯀ꯭ꯔꯥꯢꯇꯔꯤꯌꯥ (criteria) ꯃꯈꯜ ꯑꯍꯨꯝ ꯐꯥꯎꯕ ꯃꯊꯪ ꯃꯊꯪ
ꯄꯥꯟꯗꯨꯅ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯧꯕ ꯌꯥꯢ꯫ |
03:43 | ꯃꯈꯣꯢꯁꯤꯅ ꯀꯔꯤꯒꯨꯝꯕ ꯅꯍꯥꯛꯅ ꯑꯈꯟꯅꯕ ꯑꯥꯢꯇꯦꯝ (item) ꯑꯃꯕꯨ ꯊꯤꯕꯗ ꯈꯨꯗꯣꯡ ꯆꯥꯍꯜꯂꯤ ꯑꯃꯗꯤ ꯀꯔꯤ ꯒꯨꯕ ꯅꯍꯥꯛꯅ ꯗꯇ (data) ꯑꯗꯨꯕꯨ ꯆꯤꯊꯣꯛꯂꯕ ꯑꯣ ꯢꯔꯕꯗꯤ ꯑꯃꯨꯛꯀ ꯍꯦꯟꯅ ꯃꯄꯥꯡꯒꯜ ꯀꯜꯍꯜꯂꯤ ꯫ |
03:51 | ꯀꯔꯤꯒꯨꯝꯕ ꯑꯩꯈꯣꯢꯅ ꯗꯇ (data) ꯁꯤꯡꯕꯨ ꯍꯦꯗꯤꯡ (heading) “ꯀꯣꯁꯠ꯭” (“Cost”) ꯁꯤꯡꯒꯤ ꯃꯈꯥꯗ
ꯑꯄꯤꯛꯄꯗꯒꯤ ꯑꯆꯧꯕꯗꯥ ꯁꯣꯔꯠ꯭ (sort) ꯇꯧꯒꯦ ꯄꯥꯝꯃꯦ ꯍꯥꯢꯅ ꯍꯥꯢꯔꯁꯤ ꯫ |
03:57 | ꯑꯗꯨ ꯑꯣꯢꯔꯗꯤ , ꯑꯍꯥꯟꯕꯗ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯧꯒꯗꯧꯔꯤꯕ ꯁꯦꯜ (cell) ꯁꯤꯡ ꯑꯗꯨꯕꯨ ꯑꯩꯈꯣꯢꯅ “ꯀꯣꯁ꯭ꯠ” (“Cost”) ꯁꯦꯜ (cell) ꯗ ꯅꯝꯗꯨꯅ ꯍꯥꯢꯂꯥꯢꯠ (highlight) ꯇꯧꯒꯅꯤ ꯫ |
04:03 | ꯍꯧꯖꯤꯛ ’’’ꯃꯥꯎꯁ’’’ (’’’mouse ’’’) ꯒꯤ ꯑꯣꯢꯊꯪꯕ ꯕꯇꯟ (button) ꯅꯝꯗꯨꯅ, ꯀꯂꯝ (column) ꯔꯣꯝꯗ ’’’꯲꯰꯰꯰’’’ (’’’2000 ’’’) ꯍꯥꯢꯔꯤꯕ ꯑꯔꯣꯢꯕ ꯁꯦꯜ (cell) ꯌꯧꯕ ꯐꯥꯎꯕ ꯆꯤꯡꯂꯣ ꯫ |
04:12 | ꯃꯁꯤ ꯅꯑꯩꯈꯣꯢꯅ ꯁꯣ ꯔꯠ꯭ (sort) ꯇꯧꯕ ꯄꯥꯝꯂꯤꯕ ꯀꯂꯝ (column) ꯗꯨꯕꯨ ꯈꯟꯒꯅꯤ ꯫ |
04:15 | ꯍꯧꯖꯤꯛ, ꯃꯦꯅꯨ (menu) ꯕꯥꯔ (bar) ꯗ ꯂꯩꯔꯤꯕ ’’’ꯗꯇ’’’ (’’’Data’’’) ꯑꯣꯞꯁꯟ (option) ꯗ ꯅꯝꯂꯣ ꯑꯗꯨꯒ
’’’ꯁꯣꯔ꯭ꯠ’’’ (’’’Sort’’’) ꯇ ꯅꯝꯂꯣ ꯫ |
04:21 | ꯃꯊꯪꯗ, ’’’ꯀꯔꯦꯟꯇ ꯁꯦꯂꯦꯛꯁꯟ’’’ (’’’Current Selection’’’)ꯕꯨ ꯈꯂꯣ ꯫ |
04:24 | ꯅꯍꯥꯛꯅ ’’’“ꯁꯣꯔ꯭ꯠ ꯀ꯭ꯔꯥꯢꯇꯦꯔꯤ ꯌꯥ ”’’’ (’’’“Sort criteria”’’’) ꯑꯃꯁꯨꯡ ’’’“ꯑꯣꯞꯁꯟꯁ”’’’ (’’’“Options”’’’) ꯇꯦꯕꯁꯤꯡ ꯌꯥꯎꯕ ꯗꯥꯢꯂꯣꯒ-ꯕꯣꯛꯁ (dialogue-box) ꯑꯃꯥ ꯊꯣꯛꯄ ꯎꯔꯦ ꯫ |
04:31 | “ꯁꯣꯔ꯭ꯠ ꯀ꯭ꯔꯥꯢꯇꯦꯔꯤꯌꯥ ” (“Sort criteria”) ꯇꯧꯕꯗ, ’’’“ꯁꯣꯔ꯭ꯠ ꯕꯥꯢ”’’’ (’’’“Sort by”’’’) ꯐꯤꯜꯗꯗ
’’’ꯀꯣꯁ꯭ꯠ’’’ (’’’Cost’’’) ꯑꯗꯨ ꯈꯜꯂꯣ ꯫ |
04:37 | “ꯀꯣꯁ꯭ꯠ” (“Cost”) ꯑꯗꯨ ꯑꯄꯤꯛꯄꯗꯒꯤ ꯑꯆꯧꯕꯗ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯧꯅꯕ, ꯍꯦ ꯛ ꯃꯊꯪꯗ ꯂꯩꯔꯤꯕ
’’’ꯑꯦꯁꯦꯟꯗꯤꯡ’’’ (’’’Ascending’’’) ꯑꯣꯞꯁꯟ (option) ꯑꯗꯨꯗ ꯅꯝꯂꯣ ꯫ |
04:44 | ꯍꯧꯖꯤꯛ ’’’ꯑꯣꯀꯦ ’’’ (’’’OK’’’) ꯕꯇꯟ (button) ꯗ ꯅꯝꯂꯣ ꯫ |
04:47 | ꯍꯧꯖꯤꯛ ꯅꯍꯥꯛꯅ ꯀꯂꯝ (column) ꯑꯗꯨ ꯑꯄꯤꯛꯄꯗꯒꯤ ꯑꯆꯧꯕꯗ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯧꯕ ꯎꯔꯦ ꯫ |
04:51 | ꯆꯞ ꯃꯥꯟꯅꯅꯥ ꯑꯆꯧꯕꯗꯒꯤ ꯑꯄꯤꯛꯄꯗ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯧꯅꯕꯒꯤ ꯗꯃꯛ, ’’’ꯗꯤꯁꯦꯟꯗꯤꯡ’’’ (’’’Descending’’’) ꯕꯇꯟ (button) ꯗ ꯅꯝꯂꯣ ꯑꯗꯨꯒꯥ ’’’ꯑꯣꯀꯦ ’’’ (’’’OK ’’’) ꯕꯇꯟ (button) ꯗ ꯑꯃꯨꯛ ꯅꯝꯂꯣ ꯫ |
04:59 | ꯑꯩꯈꯣꯢꯅ ꯇꯧꯈ꯭ꯔꯤꯕꯁꯤꯡ ꯑꯗꯨ ’’’ꯑꯟꯗꯨ’’’ (’’’Undo’’’) ꯇꯧꯔꯁꯤ ꯫ |
05:02 | ꯑꯍꯥꯟꯕꯗ ꯀꯂꯝ (column) ꯁꯤꯡ ꯑꯗꯨ ꯈꯜꯂꯒ ꯑꯃꯗꯤ ’’’ꯁꯣꯔ꯭ꯠ’’’ (’’’sort’’’) ꯑꯣꯞꯁꯟ (option) ꯁꯤꯡ ꯑꯃꯨꯛ ꯈꯜꯂꯒꯥ ꯑꯃꯗꯒꯤ ꯍꯦ ꯟꯕ ꯀꯂꯝ (column) ꯁꯤꯡꯕꯨ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯧꯕ ꯌꯥꯢ꯫ |
05:09 | ꯑꯩꯈꯣꯢꯅ ’’’ꯁꯤꯔꯌꯦꯜ ꯅꯝꯕꯔ’’’ (’’’serial number’’’) ꯁꯤꯡ ꯑꯃꯗꯤ ’’’ꯀꯣꯁ꯭ꯠ’’’ (’’’cost’’’) ꯕꯨ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯧꯕ ꯄꯥꯝꯂꯦ ꯈꯜꯂꯁꯤ ꯫ |
05:14 | ꯑꯗꯨꯅ, ꯑꯍꯥꯟꯕꯗ ꯍꯥꯟꯅꯅꯥ ꯇꯧꯈꯤꯕꯒꯨꯝꯅ ꯀꯂꯝ (column) ꯁꯤꯡ ꯑꯁꯤ ꯈꯜꯂꯣ ꯫ |
05:18 | ꯍꯧꯖꯤꯛ, ꯃꯦꯅꯨ (menu) ꯕꯥꯔ (bar) ꯗ ꯂꯩꯕ ’’’ꯗꯇ’’’ (’’’Data’’’) ꯑꯣꯞꯁꯟ (option) ꯗ ꯅꯝꯂꯣ ꯑꯗꯨꯒꯥ
’’’ꯁꯣꯔ꯭ꯠ’’’ (’’’Sort’’’) ꯇ ꯅꯝꯂꯣ ꯫ |
05:24 | ꯊꯣꯛꯂꯤꯕ ꯗꯥꯢꯂꯣꯒ-ꯕꯣꯛꯁ (dialog-box) ꯑꯗꯨꯗ, ꯑꯍꯥꯟꯕꯗ ’’’ꯁꯣꯔ꯭ꯠ ꯕꯥꯢ’’’ (’’’Sort by’’’) ꯐꯤꯜꯗ (field) ꯗ ꯂꯩꯕ ’’’ꯀꯣꯁ꯭ꯠ’’’ (’’’Cost’’’) ꯑꯗꯨ ꯈꯜꯂꯣ ꯫ |
05:30 | ꯑꯗꯨꯒꯥ ’’’“ꯗꯦꯟꯕꯥꯢ”’’’ (’’’“Then by”’’’) ꯐꯤꯜꯗ (field) ꯗ ꯂꯩꯕ ’’’“ꯑꯦꯁꯑꯦꯟ”’’’ (’’’“SN”’’’) ꯑꯗꯨ ꯈꯜꯂꯣ ꯫ |
05:35 | ꯃꯅꯥꯛꯇ ꯂꯩꯔꯤꯕ ꯑꯣꯞꯁꯟ (option) ꯑꯅꯤꯗꯨꯗ ꯂꯩꯕ ’’’ꯗꯤꯁꯦꯟꯗꯤꯡ’’’ (’’’Descending’’’) ꯑꯗꯨꯗꯥ ꯅꯝꯂꯣ ꯑꯃꯗꯤ ’’’ꯑꯣꯀꯦ ’’’ (’’’OK’’’) ꯕꯇꯟ (button) ꯗ ꯅꯝꯂꯣ ꯫ |
05:43 | ꯅꯍꯥꯛꯅ ꯎꯔꯦ ꯃꯗꯨꯗꯤ ꯍꯦꯗꯤꯡ (heading) ꯁꯤꯡ ꯑꯗꯨ ꯑꯆꯧꯕꯗꯒꯤ ꯑꯄꯤꯛꯄꯗ ꯁꯣꯔ꯭ꯠ (sort) ꯇꯩꯔꯦ ꯫ |
05:47 | ꯑꯩꯈꯣꯢꯅ ꯇꯧꯈꯤꯕꯁꯤꯡ ꯑꯗꯨ ’’’ꯑꯟꯗꯨ’’’ (’’’undo’’’) ꯇꯧꯔꯁꯤ ꯫ |
05:49 | ꯍꯧꯖꯤꯛ ’’’ꯂꯤꯕꯔꯑꯣꯐꯤꯁ ꯀꯦꯜꯁꯤ ’’’ (’’’LibreOffice Calc’’’) ꯗꯥ ꯃꯇꯧ ꯀꯔꯝꯅꯥ ꯗꯇ (data) ꯕꯨ ’’’ꯐꯤ ꯜꯇꯔ’’’ (’’’filter’’’) ꯇꯧꯒꯅꯤ ꯍꯥꯢꯕꯗꯨ ꯇꯝꯂꯁꯤ ꯫ |
05:53 | ’’’ꯐꯤꯜꯇꯔ’’’ (’’’filter’’’) ꯑꯁꯤ ꯢꯟꯇꯔꯤ (entry) ꯑꯃꯃꯝꯕꯨ ꯎꯊꯣꯛꯄꯗ ꯆꯪꯕ ꯀꯟꯗꯤꯁꯟ (condition) ꯁꯤꯡ ꯑꯗꯨꯒꯤ ꯂꯤꯁ꯭ꯠ (list) ꯑꯃꯅꯤ ꯫ |
06:00 | ꯐꯤꯜꯇꯔ (filter) ꯑꯃꯕꯨ ꯏꯁꯄ꯭ꯔꯦꯗꯁꯤꯠ (spreadsheet) ꯇ ꯍꯥꯞꯅꯕꯒꯤꯗꯃꯛ, ꯑꯩꯈꯣꯢꯅꯥ ’’’ꯑꯥꯢꯇꯦꯝ’’’ (’’’Item’’’) ꯀꯧꯕ ’’’ꯁꯦꯜ’’’ (’’’cell’’’) ꯑꯗꯨꯗ ꯅꯝꯂꯁꯤ ꯫ |
06:07 | ꯍꯧꯖꯤꯛ, ꯃꯦꯅꯨ (menu) ꯕꯥꯔ (bar) ꯗ ꯂꯩꯕ ’’’ꯗꯇ’’’ (’’’Data’’’) ꯑꯣꯞꯁꯟ (option) ꯗ ꯅꯝꯂꯣ ꯑꯗꯨꯒꯥ
’’’ꯐꯤꯜꯇꯔ’’’ (’’’filter’’’) ꯗ ꯅꯝꯂꯣ ꯫ |
06:12 | ꯄꯣꯞ-ꯑꯞ (pop-up) ꯃꯦꯅꯨ (menu) ꯗ ꯂꯩꯕ ’’’ꯑꯣꯇꯣꯐꯤꯜꯇꯔ’’’ (’’’AutoFilter’’’) ꯗ ꯅꯝꯂꯣ ꯫ |
06:16 | ꯅꯍꯥꯛꯅ ꯍꯦꯗꯤꯡ (heading) ꯁꯤꯡꯒꯤ ꯃꯊꯛꯇ ꯑꯦꯔꯣ (arrow) ꯃꯥꯔ꯭ꯛ (mark) ꯊꯣꯛꯄꯗꯨ ꯎꯔꯦ ꯫ |
06:20 | ’’’“ꯑꯥꯢꯇꯦꯝ”’’’ (’’’“Item”’’’) ꯀꯧꯕ ꯁꯦꯜ (cell) ꯑꯗꯨꯗ ꯂꯩꯕ ꯃꯈꯥꯊꯪꯕ-ꯑꯦꯔꯣꯗ ꯅꯝꯂꯣ ꯫ |
06:24 | ꯍꯧꯖꯤꯛ, ꯅꯍꯥꯛꯅ “ꯏꯂꯦꯛꯇ꯭ꯔꯤꯁꯤꯇꯤ ꯕꯤꯜ” (“Electricity Bill”) ꯒ ꯃꯔꯤ ꯂꯩꯅꯕ ꯗꯇ (data) ꯈꯛꯇꯃꯛ
ꯊꯣꯛꯍꯟꯅꯤꯡꯂꯕꯗꯤ ꯫ |
06:29 | ꯑꯗꯨꯅ ’’’ꯏꯂꯦꯛꯇ꯭ꯔꯤꯛꯁꯤꯇꯤ ꯕꯤꯜ’’’ (’’’Electricity Bill’’’) ꯑꯣ ꯞꯁꯟꯗ (option) ꯗ ꯅꯝꯂꯣ ꯫ |
06:34 | ꯅꯍꯥꯛꯅ ꯎꯔꯦ ꯃꯗꯨꯗꯤ ’’’ꯏꯂꯦꯛꯇ꯭ꯔꯤꯛꯁꯤꯇꯤ ꯕꯤꯜ’’’ (’’’Electricity Bill’’’) ꯒ ꯃꯔꯤ ꯂꯩꯅꯕ ꯗꯇ ꯈꯛꯇꯃꯛ ꯁꯤꯠ (sheet) ꯇ ꯊꯣꯛꯂꯦ ꯫ |
06:40 | ꯂꯦꯝꯍꯧꯔꯤꯕ ꯑꯣꯞꯁꯟ (option) ꯁꯤꯡ ꯑꯗꯨ ꯂꯧꯊꯣꯛꯈ꯭ꯔꯦ ꯫ |
06:43 | ꯗꯇ (data) ꯁꯤꯡ ꯑꯗꯨ ꯂꯣꯢꯅ ꯌꯦꯡꯕ ꯐꯪꯅꯕ, ꯑꯃꯨꯛꯀꯁꯨ ’’’ꯑꯥꯢꯇꯦꯝ’’’ (’’’Item’’’) ꯀꯧꯕ ꯁꯦꯜ (cell) ꯒꯤ ꯃꯈꯥ ꯊꯪꯕ ꯑꯦꯔꯣ (arrow) ꯗ ꯅꯝꯂꯣ ꯑꯃꯗꯤ ’’’ꯑꯣꯜ’’’ (’’’All’’’) ꯗ ꯅꯝꯂꯣ ꯫ |
06:52 | ꯑꯩꯈꯣ ꯢꯅ ꯌꯥꯔꯦ ꯃꯗꯨꯗꯤ ꯍꯥꯟꯅ ꯏꯈꯤꯕ ꯑꯁꯦꯡꯕ ꯗꯇ (data) ꯁꯤꯡ ꯑꯗ ꯨ ꯌꯦꯡꯕ ꯐꯪꯂꯦ ꯫ |
06:59 | ’’’“ꯑꯇꯣꯐꯤꯜꯇꯔ”’’’ (’’’“AutoFilter”’’’) ꯒꯤ ꯃꯊꯛꯇ ꯐꯤꯜꯇꯔ (filter) ꯑꯣꯞꯁꯟ ꯃꯈꯜ ꯑꯅꯤ ꯍꯥꯢꯕꯗꯤ ’’’ꯁ꯭ꯇꯦꯟꯗꯔ꯭ꯗ ꯐꯤꯜꯇꯔ’’’ (’’’Standard Filter’’’) ꯑꯃꯗꯤ ’’’ꯑꯦꯗꯚꯥꯟꯁ ꯐꯤꯜꯇꯔ’’’ (’’’Advanced filter’’’) ꯂꯩꯔꯤ ꯑꯃꯗꯤ ꯃꯁꯤꯕꯨ ꯃꯇꯨꯡ ꯇꯥꯔꯛꯄꯗ ꯑꯣꯢꯅ ꯇꯝꯒꯅꯤ ꯫ |
07:11 | ꯃꯁꯤꯅꯥ ’’’ꯂꯤꯕꯔꯑꯣꯐꯤꯁꯀꯦꯜꯁꯤ ’’’ (’’’LibreOffice Calc’’’) ꯒꯤ ’’’ꯁ꯭ꯄꯣꯀꯟ ꯇꯨꯇꯣ ꯔꯤꯌꯦꯜ’’’ (’’’Spoken Tutorial’’’) ꯑꯁꯤꯒꯤ ꯑꯔꯣꯢꯕꯥ ꯁꯔꯨꯛ ꯑꯗꯨ ꯄꯨꯔꯛꯂꯦ ꯫ |
07:15 | ꯁꯝꯖꯜꯂꯕꯗꯥ ,ꯑꯩꯈꯣꯢꯅꯥ ꯇꯝꯈ꯭ꯔꯦ : |
07:18 | ꯕꯦꯁꯤꯛ (basic) ꯁꯤꯡꯒꯤ ’’’ꯐꯔꯃꯨꯂꯥ ’’’ (Formula) ꯒꯤ ꯋꯥꯍꯧꯗꯣꯛ꯫ |
07:21 | ꯀꯂꯝ (column) ꯁꯤꯡꯅꯥ ꯁꯣꯔꯇꯤꯡ (sorting) ꯇꯧꯕ꯫ |
07:23 | ꯐꯤꯜꯇꯔꯤꯡ (filtering) ꯗꯇ (data) ꯒꯤ ꯕꯦꯁꯤꯛꯁ (basics)꯫ |
07:26 | ꯃꯈꯥꯗꯥ ꯄꯤꯔꯤꯕꯥꯂꯤꯡꯀ (link) ꯑꯁꯤꯗꯥ ꯚꯤꯗ꯭ꯌꯣ (video) ꯌꯦꯡꯉꯣ ꯫ |
07:30 | ꯃꯁꯤꯅꯥ ꯁ꯭ꯄꯣꯀꯟ (spoken) ꯇꯨꯇꯣꯔꯤꯌꯦꯜ (tutorial) ꯄ꯭ꯔꯣꯖꯦꯛꯇ (project) ꯁꯝꯂꯞꯅꯥ ꯄꯜꯂꯦ ꯫ |
07:33 | ꯑꯗꯣꯝꯒꯤ ꯑꯐꯕꯥ ꯕꯦꯟꯋꯤꯗ (bandwidth) ꯂꯩꯇ꯭ꯔꯗꯤ ,ꯗꯥꯎꯟꯂꯣꯗ (download) ꯇꯧꯔꯒꯥ ꯌꯦꯡꯕꯤꯌꯨ꯫ |
07:37 | ꯁ꯭ꯄꯣꯀꯟ (spoken) ꯇꯨꯇꯣꯔꯤꯌꯦꯜ (tutorial) ꯄ꯭ꯔꯣꯖꯦꯛ (project) ꯇꯤꯝ (team) ꯅꯥ: |
07:40 | ꯁ꯭ꯄꯣꯀꯟ ꯇꯨꯇꯣꯔꯤꯌꯦꯜ (spoken tutorial) ꯁꯤꯡ ꯁꯤꯖꯤꯟꯅꯗꯨꯅꯥ ꯋꯥꯔ꯭ꯀꯁꯣꯞ (workshop) ꯀꯌꯥ ꯄꯥꯡꯊꯣꯛꯏ꯫ |
07:43 | ꯑꯣꯟꯂꯥꯏꯟ (online) ꯇꯦꯁ꯭ꯠ (test) ꯇꯥ ꯃꯥꯢꯄꯥꯛꯂꯕꯁꯤꯡꯗ ꯁꯔꯇꯤꯐꯤꯀꯦꯠ (certificate) ꯁꯤꯡ ꯄꯤ ꯫ |
07:47 | ꯑꯀꯨꯞꯄ ꯃꯔꯣꯜꯒꯤꯗꯃꯛ, ꯃꯁꯤꯗꯥ ꯏꯕꯤꯔꯛꯎ: ’’’ꯀꯟꯇꯦꯛꯑꯦꯠꯁ꯭ꯄꯣꯀꯟ ꯍꯥꯏꯐꯦꯟꯇꯨꯇꯣꯔꯤꯌꯦꯜ ꯗꯣꯠ
ꯑꯣꯑꯥꯔꯖꯤ ’’’ (’’’contact@spoken-tutorial.org’’’)꯫ |
07:53 | ’’’ꯏꯁ꯭ꯄꯣꯀꯟ ꯇꯨꯇꯣꯔꯤꯌꯦꯜ’’’ ꯄ꯭ꯔꯣꯖꯦꯛ ꯑꯁꯤ ’’’ꯇꯣꯛ ꯇꯨ ꯑꯦ ꯇꯤꯆꯔ’’’ ꯄ꯭ꯔꯣꯖꯦꯛꯒꯤ ꯁꯔꯨꯛ ꯑꯃꯅꯤ ꯫
|
07:58 | ꯃꯁꯤ ꯅꯦꯁꯅꯦꯜ (National) ꯃꯤꯁꯟ (Mission) ꯑꯣꯟ (on) ꯑꯦꯗꯨꯀꯦꯁꯟ (Education) ꯊꯔꯨ (through) ꯑꯥꯢ ꯁꯤ ꯇꯤ (ICT), ꯑꯦꯝ ꯍꯩꯁ ꯑꯥꯔ ꯗꯤ (MHRD), ꯚꯥꯔꯠ ꯁꯔꯀꯥꯔꯅꯥ ꯁꯞꯄꯣꯔꯗ ꯁꯍꯖꯣꯛ ꯄꯤꯕꯤꯕꯅꯤ ꯫ |
08:06 | ꯃꯤꯁꯟ (mission) ꯑꯁꯤꯒꯤ ꯑꯀꯨꯞꯄꯥ ꯃꯔꯣꯜ ꯑꯁꯤꯗꯥ ꯐꯪꯕꯤꯒꯅꯤ : |
08:08 | '’’’ꯁ꯭ꯄꯣꯀꯟ ꯍꯥꯏꯐꯦꯟ ꯇꯨꯇꯣꯔꯤꯌꯦꯜ ꯗꯣꯠ ꯑꯣ ꯑꯥꯔ ꯖꯤ ꯁ꯭ꯂꯥꯁ ꯑꯦꯟ ꯑꯦꯝ ꯏ ꯑꯥꯢ ꯁꯤ ꯇꯤ ꯍꯥꯏꯐꯦꯟ
ꯏꯟꯇ꯭ꯔꯣ ’’’ (’’’spoken hyphen tutorial dot org slash NMEICT hyphen Intro’’’)꯫ |
08:16 | ꯃꯁꯤꯒꯤ ꯇꯨꯇꯣꯔꯤꯌꯦꯜ (tutorial) ꯑꯁꯤ ꯗꯦꯁꯤ ꯀ꯭ꯔꯦꯎ ꯁꯣꯂꯨꯁꯟꯁ ꯄꯤꯚ꯭ꯤ ꯇꯤ. ꯂꯤꯃꯤꯇꯦꯗ (DesiCrew Solutions Pvt. Ltd.) ꯅꯥ ꯀꯟꯇ꯭ꯔꯤꯕ꯭ꯌꯨꯠ (contribute) ꯇꯧꯕꯤꯕꯅꯤ ꯫ ꯁꯔꯨꯛ ꯌꯥꯕꯤꯕꯒꯤ ꯊꯥꯒꯠꯆꯔꯤ ꯫ |