SPLIT UP

TRADE: COPA (PRACTICAL) Nov 2024

TRADE INSTRUCTOR:
MAA BHAVANI PRIVATE I.T.I BHADRAVATI
Mont Week Peri Name of Topic Planning Completion Reason Sign Remark
h od Date Date For Late of
No G.I
Format
documents .Insert
text and paragraphs
• Find and replace
text
• Insert symbols
and special
characters.
Format text and
paragraphs.
• Apply text effects
• Apply formatting
by using Format
Painter
• Set line and
paragraph spacing
and indentation
• Apply built-in
styles to text
• Clear formatting
Create and
configure
document sections
• Format text in
multiple columns
• Insert page,
section, and column
breaks
• Change page
setup options for a
section
Create tables.
• Convert text to
tables.
• Convert tables to
text.
• Create tables by
specifying rows
and columns.
Modify tables .
• Sort table data •
Configure cell
margins and
spacing
• Merge and split
cells
• Resize tables,
rows, and columns
• Split tables
• Configure a
repeating row
header.
Mont Week Peri Name of Topic Planning Completion Reason Sign Remark
h od Date Date For Late of
No G.I
Create and modify
lists
• Format
paragraphs as
numbered and
bulleted lists
• Change bullet
characters and
number formats •
Define custom
bullet characters
and number
formats
• Increase and
decrease list levels
• Restart and
continue list
numbering
• Set starting
number values
Create and manage
references .
Create and
manage reference
elements
• Insert footnotes a
n d endnotes
• Modify footnote
and endnote
properties
• Create and
modify
bibliography
citation sources •
Insert citations f o r
bibliographies
Create and
manage reference
tables • Insert
tables of contents
• Customize tables
of contents
• Insert
bibliographies
Manage graphic
elements
Insert
illustrations and
text boxes
• Insert shapes
• Insert pictures •
Insert 3D models
• Insert Smart Art
graphics
• Insert screenshots
and screen
clippings • Insert
text boxes
Mont Week Peri Name of Topic Planning Completion Reason Sign Remark
h od Date Date For Late of
No G.I
Format
illustrations and
text boxes.
• Apply artistic
effects • Apply
picture effects a n d
picture styles
• Remove picture
backgrounds
• Format graphic
elements
• Format SmartArt
graphics
• Format 3D models
Add text to graphic
elements
• Add and modify
text in text boxes
• Add and modify
text in shapes
" Add and modify
SmartArt graphic
content
Modify graphic
elements
• Position objects
• Wrap text around
objects
• Add alternative
text to objects for
accessibility
Manage document
collaboration Add
and manage
comments
• Add comments
• Review and reply
to comments
• Resolve
comments
• Delete comments
Manage change
tracking • Track
changes • Review
tracked changes •
Accept and reject
tracked changes
• Lockand unlock
change tracking
Manage Mailings
Perform mail
merge
• Create envelopes
• Create labels
• Create a new
mailing list
• Perform mail
merge using an
existing list
Mont Week Peri Name of Topic Planning Completion Reason Sign Remark
h od Date Date For Late of
No G.I
Open files in MS
Excel
• Open MS Excel •
Create a new Excel
file
• Create a new
Excel file from a
template
• Open an existing
Excel file.
Import data
• Import data from
txt files
• Import data from
csv files
Navigate within
workbooks
• Search data
• Navigate to
named cells, ranges
or workbook
elements
• Insert and remove
hyperlinks
Format
worksheets a n d
workbooks
• Modify page
setup
• Adjust row height
and column width
• Customize
headers and footers.
.Customize
options and
views .
• Display and
modify content in
different views
• Freeze rows and
columns
• Change window
views
• Modify basic
workbook
properties
• Display formulas
Configure
contentf o r
collaboration
• Set a print area
• Save workbooks
in alternative file
formats
• Configure print
settings Manage
data cells and
ranges
Mont Week Peri Name of Topic Planning Completion Reason Sign Remark
h od Date Date For Late of
No G.I
.Manipulate data
• Paste data by
using special paste
options
• Fill cells by using
Auto Fill
• Insert and delete
multiple columns
or rows • Insert and
delete cells
Format cells and
ranges
• Merge and
Unmerge cells
• Modify cell
alignment,
orientation and
indentation
• Format cells using
Format Painter
• Wrap text within
cells
• Apply number
formats
• Apply cell
formats from the
Format cells dialog
box
• Apply cell styles •
Clear cell
formatting
Define and
reference named
ranges.
• Define a named
range
• Name a table
• Summarize data
visually Insert
spark lines
• Apply built in
conditional
formatting
• Remove
conditional
formatting

Manage tables
and table data
Create and format
tables
• Create excel
tables from cell
ranges
• Apply table styles
• Convert tables to
cell ranges
Mont Week Peri Name of Topic Planning Completion Reason Sign Remark
h od Date Date For Late of
No G.I
.Manage tables
and table data
• Add or remove
table rows and
columns
• Configure table
style options
• Insert and
configure total
rows
Filter and sort
table data
• Filter records
• Sort data by
multiple columns
Perform operations
using formulas and
functions
Insert references.
• Insert relative,
absolute and mixed
references
• Reference named
ranges and named
tables in formulas.
.Calculate and
transform data
• Perform
calculations using
AVERAGE(),
MIN(), MAX() and
SUM()
• Count cells by
using COUNT(),
COUNTIF() and
COUNTBLANK() •
Perform conditional
operations by using
the IF()
Function
Format and
modify text
• Format text using
RIGHT(),LEFT()
and MID() functions
• Format text using
UPPER(),
LOWER() and
LEN() functions •
Format text using
CONCAT() and
TEXTJOIN()
functions
Manage Charts
Create Charts
• Create charts
• Create chart
sheets
Mont Week Peri Name of Topic Planning Completion Reason Sign Remark
h od Date Date For Late of
No G.I
Modify charts.
• Add data series to
charts • Switch
between rows and
columns in source
data
• Add and modify
chart elements
• Add trend lines to
chart
Format charts.
• Apply chart
layouts
• Apply chart styles
• Add alternative
text to charts for
accessibility
Manage Pivot
Tables
Create Pivot
Tables
• Create Pivot
tables from cell
ranges
• Manipulate fields
(columns) to get
desired analysis
• Use Filters for
pivot tables
• Represent data as
Count, Sum,
Average & % of
row / column
• Group data in
Columns & rows
for aggregate
reports