Diploma in Information Technologies

Duration: 12 Months

MS-Excel

• Introduction to Excel
• Basic Calculations
• Basic Functions
• Text Functions
• Date and Time Functions
• IF Condition
• Lookup Functions
• Mathematical Functions
• PMT Functions
• Conditional Formatting
• Cell & Table Formats
• Insertion and Deletion
• Sorting and Filtering
• Pivot Table and Pivot Chart
• Slicer & Timeline
• Cell Name Management
• Formula Auditing
• Calculations
• Import & Export Data
• Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate
• What If Analysis - Scenario Manager, Goal Seek & Data Table
• Group, Ungroup & Subtotal
• Sheet & File Protection
• Freeze Panes
• Macros

Excel VBA

• Basics of Excel VBA
• Macro Recordings and Check Codes
• Basic Syntax and Variables
• If Condition
• Loops
• Procedures & Functions
• Introduction to Excel Objects
• Manipulate Cells & Ranges
• Working with Worksheets and Workbooks
• User Forms & Controls
• Event Handling
• Importing & Exporting Data
• Create Dashboards with VBA
• Working with Pivot Tables and Charts
• Custom Classes & Objects
• Array Handling

HTML 5

• Introduction to HTML
• Document Structure
• Meta Tags
• Lists in HTML
• Images in HTML
• Hyperlinks
• Tables
• Forms in HTML
• IFrame in HTML
• Basic SVG
• Audio & Video Tags
• Entities

CSS 3

• Where and Why we use CSS
• Selectors of CSS
• Colors in CSS
• Backgrounds in CSS
• Borders in CSS
• Width and Height in CSS
• Margins & Paddings
• Fonts & Text Styling
• Box Model
• Display Property
• Flexbox
• Floating
• Navbar Project
• Card Projects
• Banner Projects
• Advance CSS Selectors
• Transformations
• Transition Animation
• Advance Animation
• Display Grid
• Media Query

JavaScript

• JavaScript Introduction
• Outputs in JS
• Variables & Constants
• Operators
• Functions in JS
• Arrays in JS
• Loops
• Array Functions
• Objects
• String Functions
• Math Functions
• Date and Time in JS
• For In & For Of Loops
• New Loop Functions in JS
• DOM Introduction
• DOM Forms
• DOM CSS & Classes
• DOM Event Listener
• DOM Animation
• BOM Introduction
• Form API
• History API
• Fetch API
• Storage API

C Programming

• Introduction To C Programming
• Comments & Output in C
• Variables & Data Types
• Constants
• Operators
• IF Condition
• Switch Condition
• Loops - While, For and Do...While
• Arrays in C
• String in C
• Pointers
• Functions in C
• File System in C
• Structures and Enums

C++

• Introduction to C++
• Variables, Inputs and Outputs
• Operators
• Strings in C++
• Math Functions in C++
• IF & Switch Conditions
• Loops
• Array & Structures
• Pointers
• Functions
• OOPs Introduction
• Constructors & Access Specifiers
• Encapsulation
• Inheritance
• Polymorphism
• Filesystem in C++
• Exceptions

Python

• Introduction to Python
• Variables & Comments
• Strings in Python
• Python Operators
• Lists in Python
• Tuples in Python
• Sets in Python
• Dictionary in Python
• IF Condition
• While Loop
• For Loop
• Functions in Python
• Lambda
• Python Classes and Objects
• Inheritance
• Iterators
• Polymorphism
• Modules in Python
• Dates in Python
• Built-in Math Functions
• Regular Expression
• Try...Except
• Filesystem in Python
• MySQL in Python
• Python and Mongo DB

Java