MICROSOFT EXCEL

General Features of Spreadsheets

Rows,
Columns, Worksheets, Workbooks, Functions and Formulas, Editing, Formatting,
Screen Layouts.

WORKING WITH EXCEL

Creating a
New Workbook, Opening an Existing Workbook, Entering and Editing Data in
Worksheet (Entering Basic Data, Deleting and Clearing Cell Contents, Entering
Dates, Cutting, Copying and Pasting Data).

FORMATTING CELLS AND WORKSHEETS

Inserting and deleting cells, Merge cells,
Format Cells by using Format Painter, Insert and delete columns
or rows, Insert headers and footers, Rename a worksheet, Add a worksheet to an existing workbook, Change magnification
by using zoom tools.

USING FORMULAS AND FUNCTIONS

Understanding Formulas,
Using Absolute and Mixed Cell References in Formulas, Using Cell Ranges in
Formulas, Summarizing Data Using Functions (SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, (MIN, MAX), Using Conditional Logic Functions (IF, AND, OR), Using
Formulas to Conditionally Summarize Data (SUMIF, COUNTIF), Using Formulas
to Modify Text (LEFT, RIGHT,
MID, TRIM, UPPER, LOWER, CONCATENATE).

CREATING CHARTS

Creating a new Chart,
formatting a Chart with a Quick Style,
formatting a Data Series, modifying a Chart’s Legend, choosing a
different chart type, Switching Between Rows and Columns in Source Data.

MICROSOFT POWERPOINT

INTRODUCTION

PowerPoint Startup
Screen, User Interface Components (Title Bar, Quick
Access Toolbar, Ribbon,
Dialog Box Launcher, Slides Pane, Main Work
Area, Status Bar), Ribbon Tabs.

PRESENTATION BASICS

Creating a Presentation, Saving a Presentation, Closing a Presentation,
Adding New Slides to a Presentation, Selection of Layout, Duplicating
Selected Slides, Rearranging Slides in a Presentation, Deleting
Slides from a Presentation,
Using the Print Preview for Printing Slides, Changing Print Layout.

WORKING WITH TEXT

Using Text
Box to Slides, Changing Font Size & Color, Using Format Painter, Creating
Numbered Lists, Creating Bulleted Lists, Formatting the Text Box (Using Quick
Style, Applying Fill & Border, Applying Texture & Pattern Fill),
Checking Spelling.

ADDING TABLES AND CHARTS IN A PRESENTATION

Inserting a
Table, Inserting Excel Worksheet, Applying Table Styles, Inserting Chart,
Resizing & Moving a Chart.

USING ANIMATION

Applying Transition Effects, Applying Animations, Using
Motion Path Animation, Modifying an Animation’s Start Options and Timing, Setting Up a Slide Show, Using Presenter
View, Creating interactive presentation using Zoom tool.

MICROSOFT ACCESS

Introduction to Microsoft Access 2019

Creating a Database, Saving a Database,
Opening an Existing
Database.

Creating Tables

Creating a Table in Datasheet view, Saving a Table, Creating
a custom Table in Design
View, Adding fields in a table, Data types in Access, Setting Primary Key
field, Creating relationship between two tables.

Creating Forms

Creating a simple Form,
Creating a Form using Form Wizard, Creating a Form using Design View,
Sorting data within a Form, Filtering data within a Form.

Creating Reports

Creating a simple report,
Creating report using
Report Wizard, Creating Reports using Design View.

Creating Queries

Creating a query from a table, Adding
table to a query, Creating
query from multiple tables, Adding criteria to a query.

COMPUTER NETWORKS

BASIC TERMINOLOGIES

Components of a Communication Model

1. Definition
2. Host / Sender
3. Media
4. Message
5. Protocol
6. Destination / Receiver

Computer Networks

1. Basic Definition & Types
2. Geographical Area Wise (Physical)
3. (LAN, MAN, WAN, Internet)

Virtual (Logical)

1. VLANS
2. VPNS

Function / Working

TOPOLOGY

Definition

Types of Topologies

Wired

(BUS, Star, Ring, Hybrid, Mesh)

Wireless

(Wi-Fi, Satellite, Radio Wave)

NETWORKING DAVIES

Node, NIC, Modem, Hub, Switch, Wireless Devices

Access Point, Wireless Modem, Wireless USB Antenna

WAN / Internet Router, Switch

TRANSMISSION MEDIA

Wired media (Guided Media)

Coaxial cable (10 Base2 10 Base 5 10Base T, 100Base X)

BNC Connector

Twisted pair cable

Unshielded twisted- pair

1. Cat 2, Cat 3 (Voice Communication)
2. Cat 4, Cat 5, Cat 6 (Data Transmission)
3. RJ-45 Connector

Shielded twisted- pair

Fiber optic cable

Single Mode

Multi-Mode

Wireless media

Why we use Wireless Media

Technologies

1. Satellite
2. Wi-Fi
3. Bluetooth
4. Microwave
5. Radio Wave

Wireless communication with LANs

1. Introduction
2. Wireless Switches / Hub
3. Wireless NIC

HOW NETWORK TRANSFER DATA (NETWORK MODELS)?

OSI MODEL

1. Application Layer
2. Presentation Layer
3. Session Layer
4. Transport Layer
5. Network Layer
6. Data Link Layer
7. Physical Layer

TCP/IP Model

1. Application Layer
2. Transport Layer
3. Network Layer
4. Physical or Link-Layer

IP ADDRESSES

What is IP address?

Why we use IP Address?

IPV4

Class A, Class B, Class C, Class D, and Class E, IP addresses

Introduction to IPv6

Why IP V6 introduced?

IP V6 address length (i.e. 128 bits)

PROTOCOLS

1. Definition
2. Types
3. Routed protocols

         Definition

Routing Protocols

        Definition

Common Protocols

1. TCP / IIP
2. UDP
3. FTP
4. HTTPs

PRACTICAL PORTION

Installing and Configuring Modem

DSL Configuration

Creating Straight Through cable

Practically demonstrate the connection of computer and hub / switch

Creating Cross Over Cable

Practically demonstrate the connection of two computers without hub / switch

Basic Commands for Troubleshooting

Ping, ipconfig / all, ipconfig / renew, ipconfig / release, trace route,

Packet Tracer (Simulation)

1. Installing network simulator
2. Practically Demonstrate 02-Computers Network
3. Configuring PC’s with IP addresses subnet mask and gateway
4. Create two different topologies of 10-10 computers using Hub
5. Place Switch between hubs to connect both technologies
6. Configuring switches by giving name to switches and management IP addresses
7. Connection PCs to switch and then ping each other` that they are working properly

 Operating Systems

Introduction to Programming