Difference between revisions of "LibreOffice-Suite-Calc/C3/Advanced-Formatting-and-Protection/Khasi"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
|||
| Line 151: | Line 151: | ||
|- | |- | ||
| 03:07 | | 03:07 | ||
| − | | Nion OK. | + | | Nion OK. Mynta, to ngin pyrshang ban jied bad pynkylla ia ki data ha ka cell. |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| Line 195: | Line 191: | ||
|- | |- | ||
| 03:43 | | 03:43 | ||
| − | | Na ka Menu Bar, nion ha '''“Tools” > “Protect Document”''' bad '''“Sheet”'''. | + | | Na ka Menu Bar, nion ha '''“Tools” > “Protect Document”''' bad '''“Sheet”'''. |
|- | |- | ||
Revision as of 12:39, 18 April 2017
| |
|
|---|---|
| 00:00 | Ngi pdiang sngewbha ia phi sha ka Spoken Tutorial halor ka Advanced Formatting and Protection in LibreOffice Calc. |
| 00:07 | Ha kane ka jinghikai , ngin pule shaphang kumno ban
Password protect ia ka spreadsheet Ban iada da kaba buh password ia kawei ka sheet lane ka tab ha ka spreadsheet Ban shna ia ki ranges na ka bynta ka database Ban pyndonkam ia ka opshon Subtotal bad Ban validate ia ki cell |
| 00:25 | Hangne ngi pyndonkam da ka
Ubuntu Linux version 10.04 bad LibreOffice Suite version 3.3.4. |
| 00:35 | To ngin plié ia ka “Personal-Finance-Tracker.ods”. |
| 00:40 | Nyngkong eh ngin pule kumno ban password protect ia kane ka file. |
| 00:44 | Kane ka opshon ka pynthikna ba tang ki briew kiba tip ia ka password kin lah ban plié ia kane ka file. |
| 00:51 | Na ka Main menu, nion File bad Save As |
| 00:55 | Ka Save dialog-box ka paw |
| 00:58 | Nangta, buh dak ha ka 'Save with password' box |
| 01:03 | Nangata sa nion Save. |
| 01:06 | Namar ba ngi pyndonkam da ka opshon Save As , ngi lah ban save ia ka kum kawei pat ka file lane shu bujli ia kajuh ka file |
| 01:15 | Hangne, to ngin bujli ia ka file |
| 01:18 | Nion Yes. |
| 01:20 | Nangta , sa pyndap ka password |
| 01:23 | Bad sa pyndap biang ia ka password ha ka Confirm box bad sa nion OK. |
| 01:30 | Nangta , khang noh ia ka "Personal-Finance-Tracker.ods". |
| 01:36 | Mynta, to ngin plié biang ia ka file bad peit kaei kaba jia |
| 01:41 | Ka Enter Password dialog-box ka paw.! |
| 01:45 | To ngin pyndap ia ka password ba bakla hangne. |
| 01:48 | Nion OK |
| 01:50 | Ngi ioh kawei ka khubor kaba ong ba ka password ka bakla. |
| 01:56 | Mynta, type ia ka password kaba dei. |
| 01:59 | Ka file ka plie |
| 02:01 | Kumno ngi weng iaka password opshon? Ka long kaba suk bha |
| 02:07 | Ngi shu weng ia u dak ba la ai ha ka opshon Save with password |
| 02:10 | Sa shisien, namar ba ngi pyndonkam da ka opshon Save , ngi lah ban save ia ka kum kawei pat ka file lane shu bujli ia kajuh ka file |
| 02:18 | Hangne, to ngin bujli ia ka file. |
| 02:21 | Nion Yes |
| 02:23 | To ngin close bad openia kane file |
| 02:27 | Phim donkam ia ka password ban plié ia ka file. |
| 02:31 | To ngin pule kumno ban password protect ia kawei kawei ka sheet na kane ka file. |
| 02:37 | Na ka menu bar, nion ha Tools > Protect Document bad Sheet. |
| 02:44 | Ka “Protect Sheet” dialog-box ka paw. |
| 02:47 | Ban iada ia ka sheet, nyngkong eh weng lane uncheck ia ki opshon “Select Locked cells” bad “Select Unlocked cells”. |
| 02:56 | Mynta ha ka bynta “Password” to ngin pyndap “abc”, ha ki dak rit bad ngin pyndap biang ia ka password ha ka jaka “Confirm”. |
| 03:07 | Nion OK. Mynta, to ngin pyrshang ban jied bad pynkylla ia ki data ha ka cell. |
| 03:15 | Ngim lah ban jied ia kano kano ka cell |
| 03:18 | Ia ka sheet ym lah ban pynkylla. |
| 03:22 | Ka long kumno pat bad kiwei kiwei ki sheet? |
| 03:24 | To ngin nion ha Sheet2. |
| 03:27 | To ngin jied ia ka cell bad pyrshang ban edit ia ka |
| 03:30 | Ka Calc ka ailad ban edit lane pynkylla ia ki cell ha kiwei pat ki sheet. |
| 03:35 | To ngin phai biang sha ka sheet ba nyngkong. |
| 03:38 | Mynta to ngin un-protect noh ia ka sheet |
| 03:41 | Kane ka suk bha. |
| 03:43 | Na ka Menu Bar, nion ha “Tools” > “Protect Document” bad “Sheet”. |
| 03:49 | Ka dialog box kaba pan iaka password ka paw |
| 03:53 | Pyndap “abc” ha ki dak rit ha ka bad sa nion OK. |
| 03:59 | Ngi la lah ban jied biang ia ki cells |
| 04:03 | To ngin pule shaphang ki Ranges. |
| 04:06 | Phi lah ban batai ia ki range jong ki cell ha ka spreadsheet bad pyndonkam ia ka ha ka database. |
| 04:12 | Each row in this database range corresponds to a database record and
Man kawei pa kawei ka row ha kane ka database range ka iadei bad ka database record bad |
| 04:17 | Man kawei pa kawei ka cell ha ka row ka iadei bad ka database field |
| 04:22 | Phi lah ban pynbeit ryntih, ban kyllum lang, ban wad bad leh ia ki jingkhein jingkdiah ha ka range kumba phi kwah ha kano kano ka database. |
| 04:30 | To ngin shna ia ka database ha ka “Personal-Finance-Tracker.ods” bad pynbeit ryntih ia ka data. |
| 04:38 | Nyngkong eh, jied ia ki item kiba ngi donkam ha ka database. |
| 04:43 | To ngin jied ryngkat ia baroh ki data hapoh ka heading “SN” haduh "Account". Ngi la dep pule lypa kumno ban jied ia ki data. |
| 04:53 | Mynta , to ngin ai kyrteng ia ka database jong ngi. |
| 04:56 | Na ka Menu bar, nion Data bad nangta sa nion ha Define Range. |
| 05:02 | Ha ka “Name” field, type “dtbs” kaba dei ka kyrteng lyngkot jong ka database. |
| 05:08 | Nion Ok |
| 05:10 | Sa shisien, na ka Menu bar, nion Data bad Select Range. |
| 05:15 | Peit bha ba ha ka “Select Database Range” dialog-box kaba paw, ka kyrteng “dtbs” la pyni kum ka database |
| 05:24 | Nion ha u OK button |
| 05:27 | Mynta to ngin pynbeit ryntih ia ka data ha kane ka database. |
| 05:31 | Na ka Menu Bar, nion Data bad Sort. |
| 05:35 | Ha ka Sort dialog-box kaba paw, nion ha “Sort by” field badjied “SN”. |
| 05:42 | Nangta, na ka liang kamon, jied “Descending”. |
| 05:47 | Hapoh ka “Then by” field kaba nyngkong, nion ha u drop down bad jied “Cost”. |
| 05:54 | Sa shisien, naka liang ka mon, jied “Descending”. |
| 05:58 | Ha ka “Then by” field kaba ar, nion ha ka drop-down, jied “Spent” bad nangta sa jied biang “Descending”. |
| 06:07 | Nion Ok. |
| 06:09 | Ka data hapoh ka heading “SN” la pynbeit ryntih na ba heh sha ba rit |
| 06:15 | Ha kajuh ka rukom, ngi lah ban leh ia kiwei kiwei ki operation ha ka database ruh. |
| 06:21 | To ngin nion CTRL+Z keys ban weng ia baroh ki jingpynkylla ba la leh ban pynbeit ryntih bad ioh biang ia ka data barim |
| 06:28 | Mynta , to ngin pule kumno ban pyndonkam ia ka opshon “Subtotal” hapoh Calc |
| 06:34 | Ka opshon “Subtotal”, ka khein lang lane calculate ia ka grand total jong ki data hapoh ki heading bapher bapher, da kaba pyndonkam ia ki mathematical function kiba ngi kwah. |
| 06:43 | To ngin jied ia ka subtotal jong ki data hapoh ka heading “Cost”. |
| 06:49 | Nyngkong , to ngin pyndam ia ka entry ha ka row number 8. |
| 06:53 | Jied lut ryngkat ia baroh ki data hapoh SN haduh ACCOUNT. |
| 06:59 | Nangta, na ka Menu Bar, nion Data bad Subtotals. |
| 07:04 | Ha ka Subtotals dialog-box kaba paw, na ka “Group by” field, to ngin jied “SN”. |
| 07:11 | Kane ka kyllum lang ia ki data da ka Serial Number. |
| 07:15 | Nangta, ha ka “Calculate subtotals for” field, nion ha ka “Cost” option. |
| 07:21 | Kane kan sa khein lang ia ka total jong baroh ki entry kiba don hapoh jong ka, |
| 07:26 | Hapoh jong ka “Use function” field , jied “Sum” bad nion OK |
| 07:33 | Peit bha ba ka “Grand total” jong baroh ki entry, hapoh ka heading “Costs” la pyni ha ka spreadsheet. |
| 07:41 | Ha ka liang kadiang jong ka Sheet. Don lai tylli ki tab ba thymmai, “1”, ”2”bad “3”. |
| 07:47 | Kine ki tab ki ai ia 3 tylli ki view kiba pher jong ka data. |
| 07:52 | To ngin nion ha tab 1. |
| 07:54 | Peit bha ba tang ka grand total jong ka data hapoh “Costs” la pyni |
| 08:00 | Nion ha tab “2” |
| 08:02 | Ka data hapoh “Costs” bad kumjuh ka grand total la pyni. |
| 08:08 | Mynta , nion ha tab “3” |
| 08:11 | Ngi ioh iaka detailed view jong ka sheet ryngkat bad ka grand total jong ka data hapoh “Costs”. |
| 08:18 | To ngin khang noh ia kane ka file. |
| 08:21 | Ka dialogue box ryngkat ka message Save or Discard changes ka paw. |
| 08:26 | Nion Discard. |
| 08:28 | Mynta, to ngin plié biang ia ka file. |
| 08:31 | Mynta , to ngin pule shaphang ka opshon “Validity” ha LibreOffice Calc. |
| 08:37 | Ka “Validity” opshon ka pynshisha ia ka data ha ka spreadsheet. |
| 08:41 | Ia kane la leh da kaba pynthikna ia ki “Validation rules” naka bynta ki cell ba la dep jied ha ka spreadsheet. |
| 08:49 | Kum ka nuksa, ha ka “Personal-Finance-Tracker.ods”, ngi lah ban pynthikna iaka rukom siew na ka bynta ki item ba la dep thied da ka pyndonkam ka Validation. |
| 08:59 | Mynta, to ngin pyndam lane delete ia ka heading “Date” bad baroh kiba don hapoh jong ka |
| 09:04 | To ngin ai da kawei ka heading na ka bynta “Mode of Payment” kum “M-O-P”, mar bud jong ka heading “Received”. |
| 09:12 | Hapoh jong ka heading “M-O-P”, ia ki cell lah ban pyndonkam ban pyni ia ka rukom siew naka bynta ki data entry kiba hap hapoh ka heading “Items” |
| 09:21 | Kita ki long ”Salary”, ”Electricity Bills” bad kiwei kiwei pat. |
| 09:27 | Mynta, to ngin nion ha ka cell bathylli kaba don hapoh jong ka heading ”M-O-P”. |
| 09:33 | Kane kan don ia ka rukom siew na ka bynta ka “Salary” |
| 09:38 | Mynta, na ka Menu Bar, nion “Data” bad “Validity”. |
| 09:43 | Ka Validity dialog box ka paw |
| 09:47 | To ngin nion ha ka “Criteria” tab |
| 09:50 | Na ka “Allow” field drop-down, nion “List” |
| 09:55 | Ka “Entries” box ka mih . |
| 09:58 | To ngin pyndap ia ki opshon kiban sa paw haba pynshisha ia ka cell ba la dep jied |
| 10:05 | To ngin type ia ka rukom siew kaba nynkong kum “In Cash” bad nangta sa nion ia u Enter key na ka keyboard, |
| 10:13 | Mynta to ngin type ia ka rukom siew kaba ar kum “Demand Draft”. |
| 10:19 | Nion Ok. |
| 10:21 | Ki cell ba la dep jied la pynshisha. |
| 10:25 | Mynta , nion ia u down-arrow uba paw hajan. |
| 10:30 | Hato phi iohi ia ki opshon kiba ngi la dep pyndap kum Mode of Payments ha ka Entries box? |
| 10:36 | Ban pynshisha ia ki cell ba hapoh, nyngkong eh nion ha ka Format Paintbrush opshon ha ka toolbar |
| 10:43 | Nangta, jied ia ki cell ba hapoh jong ka cell ba la dep pynshisha da kaba nion ia u mouse button na ka liang kadiang bad nangta sa drag sha ki cell |
| 10:53 | Mynta, pyllait noh ia u mouse button. |
| 10:57 | Baroh ki cell ba la dep jied la pynshisha ha ka juh ka rukom. |
| 11:09 | Mynta, nion ha ka cell kaba hapoh jong ka heading “M-O-P” bad nangta sa nion ha u down-arrow. |
| 11:17 | Baroh artylli ki opshon naka bynta ka rukom siew la pyni. |
| 11:21 | To ngin jied ia ka In Cash opshon |
| 11:25 | Ha kajuh ka rukom, phi lah ban jied “Cash” lane “Demand Draft” ha kawei pa kawei ka cell ba la dep pynshisha katkum ka rukom siew ba la buh |
| 11:36 | Bad da kane, ngi la poi shaba kut jong ka Spoken Tutorial halor ka LibreOffice Calc. |
| 11:42 | Ban batai kyllum, ngi la dep pule shaphang kumno ban
Password protect ia ka spreadsheet Ban iada da kaba buh password ia kawei ka sheet lane ka tab ha ka spreadsheet Kumno Ban shna ia ki ranges na ka bynta ka database Kumno Ban pyndonkam ia ka opshon Subtotal bad Kumno Ban validate ia ki cell |
| 12:01 | Peit ia ka video ba la ai ha ka link ba don harum |
| 12:04 | Ka kyllum lang ia Ka Spoken Tutorial project. |
| 12:07 | Lada phim don iaka bandwidth kaba biang phi lah ban shu download bad peit ia ka |
| 12:11 | Ka Kynhun jong ka Spoken Tutorial Project |
| 12:13 | *Ka pynlong ia ki workshop da kaba pyndonkam da ki spoken tutorials. |
| 12:17 | *Ka ai sertiphikate sha kito kiba pass ha ka online test. |
| 12:20 | Na ka bynta ki jingtip ba kham bniah sngewbha thoh sha contact at spoken hyphen tutorial dot org. |
| 12:27 | Ka Spoken Tutorial projek kadei shi bynta jong ka Talk to a Teacher project. |
| 12:31 | Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India. |
| 12:39 | Shibun ki jingtip halor kane ka mission ki don ha |
| 12:42 | spoken hyphen tutorial dot org slash NMEICT hyphen Intro. |
| 12:50 | Ia kane ka jinghikai la pynkylla sha ka ktien Khasi da I Meboreen Mary. Khublei shibun iaka jingiasnohkti lang jong phi. |
