MS-EXCEL
| Topic |
Code |
| Excel Intro | E1 |
| Clipboard | E2 |
| font | E3 |
| alignment | E4 |
| number | E5 |
| styles | E6 |
| cells | E7 |
| editing | E8 |
| tables | E9 |
| Illustrations | E10 |
| charts | E11 |
| Links | E12 |
| text | E13 |
| themes | E14 |
| page setup | E15 |
| scale to fit | E16 |
| sheet options | E17 |
| arrange | E18 |
| Sub Assessment : EXC1 |
| formulas | E19 |
| names | E20 |
| auditing | E21 |
| calculation | E22 |
| external data | E23 |
| connections | E24 |
| sort,filter | E25 |
| data tools | E26 |
| outline | E27 |
| proofing | E28 |
| comments | E29 |
| changes | E30 |
| views | E31 |
| show/hide | E32 |
| zoom | E33 |
| window | E34 |
| macros | E35 |
| others | E36 |
| Sub Assessment : EXC2 |
| Main Assessment |
My-SQL
| Topic |
Code |
| intro |
M01 |
| create |
M02 |
| insert |
M03 |
| update |
M04 |
| delete |
M05 |
| truncate |
M06 |
| select |
M07 |
| alter |
M08 |
| aggregate fn |
M09 |
| group by |
M10 |
| string fn |
M11 |
| numeric fn |
M12 |
| date fn |
M13 |
| constraint |
M14 |
| sub query |
M15 |
| joins |
M16 |
| procedures |
M17 |
| triggers |
M18 |
| extra |
M19 |
| Main Assessment : |
Mongo DB
| Topic |
Code |
| intro |
MD01 |
| basics |
MD02 |
| insert |
MD03 |
| find |
MD04 |
| update |
MD05 |
| remove |
MD06 |
| projection |
MD07 |
| indexing |
MD08 |
| aggregation |
MD09 |
| validation |
MD10 |
| others |
MD11 |
| Main Assessment : |
Python
| Topic |
Code |
| INTRO |
P1 |
| DATATYPES |
P2 |
| CONVERSIONS |
P3 |
| PRINT FUNCTION |
P4 |
| OPERATORS |
P5 |
| CONDITIONAL STATEMENT |
P6 |
| LOOPING STATEMENT |
P7 |
| BREAK, CONTINUE, PASS |
P8 |
| FUNCTIONS |
P9 |
| DEFAULT ARGUMENTS |
P10 |
| KEYWORD ARGUMENT |
P11 |
| ARBITARY ARGUMENT |
P12 |
| RECURSION |
P13 |
| Sub Assessment : PYT1 |
| MODULES |
P14 |
| PACKAGE |
P15 |
| DECIMAL FUNCTION |
P16 |
| MATH, RANDOM |
P17 |
| LIST |
P18 |
| TUPLE |
P19 |
| ARRAY |
P20 |
| SORTING ALGORITHM |
P21 |
| SEARCH |
P22 |
| STRING |
P23 |
| SET |
P24 |
| DICTIONARY |
P25 |
| FILES |
P26 |
| BINARY FILES |
P27 |
| DIR & FILE MANAGEMENT |
P28 |
| EXCEPTION HANDLING |
P29 |
| NAMESPACE ESCAPE |
P30 |
| Sub Assessment : PYT2 |
| CLASS & OBJECT |
P31 |
| CONSTRUCTOR |
P32 |
| DESTRUCTION |
P33 |
| DATA ATTRIBUTES |
P34 |
| CLASS ATTRIBUTES |
P35 |
| PRIVATE |
P36 |
| INHERITANCE |
P37 |
| OVERRIDING |
P38 |
| OPERATOR OVERLOADING |
P39 |
| Sub Assessment : PYT3 |
| MULTITHREAD |
P40 |
| DATABASE ACCESS |
P41 |
| Sub Assessment : PYT4 |
| TKINTER |
P42 |
| LABEL,LABELFRAME |
P43 |
| ENTRY BUTTON |
P44 |
| CHECKBUTTON,RADIOBUTTON |
P45 |
| SPINBOX, LISTBOX |
P46 |
| MENU, MESSAGE |
P47 |
| OPTION MENU |
P48 |
| SCALE |
P49 |
| TK MESSAGEBOX |
P50 |
| SCROLL BAR |
P51 |
| IMAGE PROCRESSING |
P52 |
| Sub Assessment : PYT5 |
| Main Assessment |
MatplotLib
Power BI
NumPy
Pandas
Git
| Topic |
Code |
| introduction |
GT01 |
| setup commands |
GT02 |
| git bash commands |
GT03 |
| init, clone |
GT04 |
| staging, commit |
GT05 |
| git stash |
GT06 |
| git ignore |
GT07 |
| git branches |
GT08 |
| git merge |
GT09 |
| inspect commands |
GT10 |
| git compare |
GT11 |
| git remote |
GT12 |
| git push |
GT13 |
| git fetch, pull |
GT14 |
| tracking path changes |
GT15 |
| git rebase |
GT16 |
| misc |
GT17 |
| Sub Assessment : |
