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

From Script | Spoken-Tutorial
Revision as of 18:31, 7 June 2017 by Kishorjitn (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
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) ꯇꯧꯕꯤꯕꯅꯤ ꯫ ꯁꯔꯨꯛ ꯌꯥꯕꯤꯕꯒꯤ ꯊꯥꯒꯠꯆꯔꯤ ꯫

Contributors and Content Editors

Kishorjitn, Oken-khwai