Course

MODULE 1

Introduction to Computer

MS-Office 

Introduction to Computers

Windows

MS-Word

Internet

Power Point

Outlook Express

MS-Excel

MS-Access 

 

Advanced Excel with Power BI 

Introduction to Advanced Excel

Entering data and calculation

Working with Rows and Columns,

Cell References

Filling Series / Custom List

Conditional Formatting

Maths and Trigonometry Function

Statistical Function / Date & Time Function

Logical Function / IF Function

Data Validation Function

V/H Lookup Function / Text Function / Index & Match

Function with Condition, Sumifs, Countifs, Averageifs

Financial Function

Scenario, Goal Seek & Solver

Database Function -D Get

Sorting, Sub Totaling, Auditing, Macro & Consolidate

Filtering of Data / Pivot Table and Chart

Split / Hyperlink to Database Freeze

Tracking Workbook Charge

Protecting / Page Setup / MIS Report

Power BI

Data Ingestion (Connecting to Excel/Sql),

Transformation Using Power Query,

Data Modeling (Relationships, Star Schema),

DAX Calculations (Measures/Columns),

And Visualization (Charts, Dashboards, Reports)

Hands on Project Work

 

Advanced Account Tally 

Company Information

Creation - Stock with

Opening Balance

Stock information - Manufacturing Date

Batch No. Expiry Date

Accounting Voucher Entry

Purchase / Purchase Order Entry

Sales / Sales Order Entry

Discount- Cash Discount & Trade Discount

Bill Wise Details for Customer / Supplier

Voucher Class / Voucher Entry Type

Manufacturing Account

Accounting / Non-Accounting Voucher

Price Level Pos invoice

Price List Discount Scheme

Back and Restore

Budget Creation

Billing Term with Purchase / Sales Entry

Activate Interest Calculation

Enable Cheque Printing

Allow Multi Currency

Service Tax

Input Credit adjustment

Payroll - A

Payroll - B

Excise Duty

TDS Entry

TCS Entry

GST Entry

 

DTP (GRAPHIC DESIGNING)

Windows

Corel Draw

Photoshop

In Design

Adobe Illustrator

 

Front End Web Develop.

DOM & BOM Concepts

GSAP Animations

Scroll Trigger Effects

Portfolio & Real Projects

Deployment & Hosting

TOOLS COVERED

VS Code • React DevTools • GSAP • GitHub • Netlify • Chrome DevTools and many more

A - WEB DESIGNING

Fundamentals of Computers

Fundamentals of Internet & E-Commerce

Windows

HTML

DHTML

HTML5 / CSS3 / jQuery

Flash

JavaScript / Dream Weaver

Photoshop

PHP / Bootstrap

B - REACT.JS

React Introduction & Setup

JSX Syntax & Components

Functional Components

Props & State Management

useState Hook

Conditional Rendering

Lists & Keys

Event Handling

Forms & Validation

React Router Basics

Context API

Multi-Page Applications 

Hands on project

 

Programming Front End / Back End

C, C++ or VB or C# (Front-End Optional)

My SQL or SQL Server 2008 (Back-End Optional)

 

Linux Operating System

Understanding LAN

Understanding Internet & E-Commerce

Multimedia -Audio & Video Recording / Editing / Mixing

Utilities like PC Tools, Virus & Anti-virus

 

MODULE 2 & 3 (Hardware & Networking)

A – Desktop Hardware

Digital Electronics

Binary Numbers

Fundamental of Computer

Power Supply (SMPS)

Motherboard / Chipset

Processor (CPU)

Memory

BIOS

Hard Disk

Optical Peripherals

Other Peripherals

B – Operating System Administration

Deployment of Windows Client OS / Server OS / Linux OS

Repairing Windows Operating System

OS Hardening & OS Error Troubleshooting

Reinstallation of Operating System

User / Group Management

Installation of Applications

Hardware Management

Uninstallation of Applications

Drivers Deployment and identification

C- Management

User / Group Management

Peripheral's Drivers, Applications Installations

Hardware Management

User Data Management (Permissions and Logins)

Drivers Deployment and Identification

Hardware, OS, Application Troubleshooting

D- Fundamental Networking

Basics of Networking, Networking components, Types of Networks

Networking Hardware (Crimping, Croaning, Switching, Dressing)

Logical Networking (IP Addressing, Routing, Packet Transmission)

Networking Traffic Flow & Troubleshooting

 

MODULE 4- PYTHON OR .NET OR CORE JAVA                                          

Python

HTML & CSS Fundamentals

JavaScript & DOM Concepts

Bootstrap Framework

Responsive Website Design

Environment Setup

Basic Syntax

Reg Expressions

Variable Types

CGl Programming

Basic Operators

Database Access

Decision Making

Loops / Numbers / Strings

Multithreading  

XML Processing

Lists  / Tuples / Dictionary

GUI Programming

Date & Time Functions

Further Extensions

Modules Files I/C

Python Useful Resources

Exceptions

Classes/Objects

React.js Frontend Development

Components, Hooks & Routing

Python Programming Basics

Django Backend Development

Models, Views & Templates

MySQL Database Integration

Authentication & Authorization

CRUD Functionality

API & Frontend Integration

Deployment & Hosting

Final Full-Stack Project

TOOLS COVERED

React • Django • MySQL • GitHub • VS Code • Chrome DevTools

 

OR

 

.NET

MOD 1

HTML

CSS3

JAVASCRIPT

MODULE 2

Overview of the Microsoft .NET Platform

Introduction to the .NET Platform

Overview of the NET Framework

Overview of C#

Using Value-Type Variables

Statements and Exceptions

Methods and Parameters

Arrays / Essentials of Object-Oriented Programming

Using Reference-Type Variables

Creating and Destroying Obiects

Inheritance in C#

Aggregation, Namespaces and Advanced Scope

Operators and Events

MOD 3 – MVC

Create HTML Controls in MVC

Model, View, & Controller

MODULE 4 -.NET CORE

ASP.NET Core Middleware

.NET Advanced Topics

MOD 5- FRAMEWORK

DATABASE -SQL SERVER

 

OR

 

CORE JAVA

MOD 1

HTML  

CSS3

JAVASCRIPT

MOD 2

An Overview of java

Data Types, Variables and Array Mod. 3: Operators

Introducing Classes

Introducing Method and Classes

Inheritance

Packages and Interface

Exception Handling

Multithreaded Programming

Enumeration, Autoboxing and Annotation Mod.

11:1/O Applets, and other Topics Mod. 12: Generic

String Handling

Input/Output

Event Handling

MOD 3

DATABASE – ORACLE

 

Now onwards you are a Computer Engineer !

You can become All-rounder in IT-Field

 

BCA / MCA Students can opt for this course.

 This course will assist the students in their practicals and upgrade their skills.

ALSO JOIN

*KLiC ADVANCED EXCEL

*KLiC TALLY PRIME WITH GST

*KLiC ADVANCED TALLY PRO

*KLiC DTP (CORAL DRAW)

*KLiC DTP (ADOBE)

*KLiC PHOTOSHOP

*KLiC GRAPHIC DESIGNING

*KLiC CONTENT ILLUSTRATOR

*KLiC VIDEO EDITING

*KLiC WEB DESIGNING

*KLiC C PROGRAMMING

*KLiC C++ PROGRAMMING

*KLiC HARDWARE SUPPORT

*KLiC NETWORK SUPPORT

*KLiC SECURITY SUPPORT

*KLiC DESKTOP SUPPORT

AND GET YCMOU UNIVERSITY MARKSHEET & MKCL CERTIFICATE & DIPLOMA.