ADCA (Advanced Diploma in Computer Application)

Computer theory

• Computer introduction
• Electronic machine
• Computer basic structure
• Computer history part 1
• Computer history part 2
• Computer history part 3
• Computer history part 4
• Computer history part 5
• Computer history part 6
• Computer hardware collections
• Computer parts
• Computer types
• Software
• Printers
• Central processing unit (CPU)
• Control unit
• Arithmetic logic unit
• Computer memory
• Random access memory
• Read only memory
• Computer languages
• Computer networks
• Network packets
• Data transmission
• Network topology
• Network components
• Computer network name
• Computer number system

Computer accessories

• Window taskbar
• Window desktop
• Desktop right click
• All about this PC
• Create new folder
• Window paint
• MS paint part 2
• MS paint part 3
• MS paint part 4
• MS paint part 5
• Notepad part 1
• Notepad part 2
• Wordpad part 1
• Wordpad part 2
• MS calculator
• Recycle Bin

MS WORD

• Introduction of MS office
• What is MS word?
• MS word clipboard
• MS word font tool
• MS word paragraph tool
• MS word insert page tool
• MS word table tool
• MS word table design, layout tool
• MS picture tool
• MS picture format tool
• MS word clipart, shapes tool
• MS word hyperlink tool
• MS word header, footer tool
• MS word page number tool
• MS word word art tool
• MS word drop cap tool
• MS word equation tool
• MS word margin tool
• MS word orientation tool
• MS word page size tool
• MS word page column tool
• MS word line number tool
• MS word watermark tool
• MS word background tool
• MS word border tool
• MS word review tool

MS Excel

• Spread sheet & MS Excel introduction
• How to start ms excel
• MS excel environment
• MS excel default settings
• MS excel open, save tools
• Rename delete excel sheet
• All about excel cell
• MS excel clipboard tool
• Excel font tool
• Remove border shading in ms excel
• Vertical alignment tool
• Excel horizontal tool
• MS excel orientation tool
• Wrap text tool
• Merge tool
• Insert delete row tool
• Format width, height tool
• Autofill tool
• Select row, column using single click
• Pound sign error
• Types of cell address
• Arithmetic operators
• Relational operators
• Logical operators
• School template example
• MS excel basic functions
• Convert dataset into table
• MS excel graph chart
• Pivot table, chart
• Number, comma, currency format tool
• Sorting tool in MS excel
• Filter tool
• Financial functions
• Statistics functions
• Round functions
• Date time functions
• String functions
• Searching tools
• Remove duplicate data tools
• Data validation tool
• Consolidate tool
• Goal seek tool
• Show formula tool
• Freeze pane tool
• Save tool with password encryption

MS Power point

• Know about power point
• Start, save power point slides
• Create new slides
• Slide types
• Create duplicate, delete slides
• Use shapes in slides
• Format slides
• Slide show tools
• Custom slide show
• Use illustrations in slide
• Use table in slide
• Header, footer tool in slide
• Video, audio tool in slides
• Use theme tool in slides
• Use animation in slide
• Use custom animation in slides