Department of Commerce
Course File
MS OFFICE FOR COMMERCE
Academic Year: 2023-24
Name of
MS OFFICE FOR COMMERCE Type SEC
Course
Course Code YET TO UPDATE Credits 2
Instructional
Programme Commerce 2
Hrs/week
Class I BCOM A No of Sessions 30
Semester I
PROGRAMME OUTCOMES & PROGRAMME SPECIFIC OUTCOMES
Programme Outcomes:
PO PO1: Disciplinary knowledge: Capable of demonstrating comprehensive knowledge and
understanding of one or more disciplines that form a part of an undergraduate Programme of
study
PO2: Communication Skills: Ability to express thoughts and ideas effectively in writing and
orally; Communicate with others using appropriate media; confidently share one’s views and
express herself/himself; demonstrate the ability to listen carefully, read and write analytically,
and present complex information in a clear and concise manner to different groups.
PO3: Critical thinking: Capability to apply analytic thought to a body of knowledge; analyse and
evaluate evidence, arguments, claims, beliefs on the basis of empirical evidence; identify
relevant assumptions or implications; formulate coherent arguments; critically evaluate
practices, policies and theories by following scientific approach to knowledge development.
PO4: Problem solving: Capacity to extrapolate from what one has learned and apply their
competencies to solve different kinds of nonfamiliar problems, rather than replicate curriculum
content knowledge; and apply one’s learning to real life situations.
PO5: Analytical reasoning: Ability to evaluate the reliability and relevance of evidence; identify
logical flaws and holes in the arguments of others; analyze and synthesize data from a variety
of sources; draw valid conclusions and support them with evidence and examples, and
addressing opposing viewpoints.
PO6: Research-related skills: A sense of inquiry and capability for asking relevant/appropriate
questions, problem arising, synthesising and articulating; Ability to recognise cause-and-effect
relationships, define problems, formulate hypotheses, test hypotheses, analyse, interpret and
draw conclusions from data, establish hypotheses, predict cause-and-effect relationships;
ability to plan, execute and report the results of an experiment or investigation
PO7: Cooperation/Team work: Ability to work effectively and respectfully with diverse teams;
facilitate cooperative or coordinated effort on the part of a group, and act together as a group
or a team in the interests of a common cause and work efficiently as a member of a team
PO8: Scientific reasoning: Ability to analyse, interpret and draw conclusions from
quantitative/qualitative data; and critically evaluate ideas, evidence and experiences from an
open-minded and reasoned perspective.
PO9: Reflective thinking: Critical sensibility to lived experiences, with self awareness and
reflexivity of both self and society.
PO10 Information/digital literacy: Capability to use ICT in a variety of learning situations,
demonstrate ability to access, evaluate, and use a variety of relevant information sources; and
use appropriate software for analysis of data.
PO11 Self-directed learning: Ability to work independently, identify appropriate resources
required for a project, and manage a project through to completion.
PO 12 Multicultural competence: Possess knowledge of the values and beliefs of multiple
cultures and a global perspective; and capability to effectively engage in a multicultural society
and interact respectfully with diverse groups.
PO 13: Moral and ethical awareness/reasoning: Ability toembrace moral/ethical values in
conducting one’s life, formulate a position/argument about an ethical issue from multiple
perspectives, and use ethical practices in all work. Capable of demonstratingthe ability to
identify ethical issues related to one‟s work, avoid unethical behaviour such as fabrication,
falsification or misrepresentation of data or committing plagiarism, not adhering to intellectual
property rights; appreciating environmental and sustainability issues; and adopting objective,
unbiased and truthful actions in all aspects of work.
PO 14: Leadership readiness/qualities: Capability for mapping out the tasks of a team or an
organization, and setting direction, formulating an inspiring vision, building a team who can
help achieve the vision, motivating and inspiring team members to engage with that vision, and
using management skills to guide people to the right destination, in a smooth and efficient way.
PO 15: Lifelong learning: Ability to acquire knowledge and skills, including „learning how to
learn‟, that are necessary for participating in learning activities throughout life, through self-
paced and self-directed learning aimed at personal development, meeting economic, social and
cultural objectives, and adapting to changing trades and demands of work place through
knowledge/skill development/reskilling.
Programme Specific Outcomes:
PSO1 – Placement: To prepare the students who will demonstrate respectful engagement
with others’ ideas, behaviors, beliefs and apply diverse frames of reference to decisions and
actions.
PSO 2 - Entrepreneur: To create effective entrepreneurs by enhancing their critical thinking,
problem solving, decision making and leadership skill that will facilitate startups and high
potential organizations
PSO PSO3 – Research and Development: Design and implement HR systems and practices
grounded in research that comply with employment laws, leading the organization towards
growth and development.
PSO4 – Contribution to Business World: To produce employable, ethical and innovative
professionals to sustain in the dynamic business world.
PSO 5 – Contribution to the Society: To contribute to the development of the society by
collaborating with stakeholders for mutual benefi
SYLLABUS
Unit 1 : Introduction to MS Word & Commonly used features
Introduction to Word processing -Word processor / Editor - File Extension - DOCx, DOTx
- Application / Document area Title Bar, Menu Bar, Ribbon, Icons, Status Bar, Scroll Bar -
Page Layout - Page Size ( Letter / A4 ) - Orientation ( Landscape / Portrait ) - Margin
( Top, Left, Bottom, Right ) -Navigation(Arrow keys, Ctrl + Arrow keys, Home, End, Page
UP/ Page Down ) - Selection - Using Shift + Navigation Fonts / Superscript / Subscript -
Show / Hide - Displays non printing characters ( Space / TAB / Enter ) - Change Case -
Bullets / Numbering - Format Painter – Clipboard - Find / Replace Screen shot - Prnt
SCR / Alt + PrntScr – Indent - Line and Para spacing - Tab Stop - Text to Table - Table to
Text
Unit 2 : Insert Tab & Mail Merge
Insert Tab - Picture ( Styles, Border, Effects, Warp Text, Align, Rotate, Flip, Crop ) -
Water Mark - Shapes ( Group, Ungroup, Bring to Front, Send to Back, Format shape ) –
Hyperlink – Bookmark - Text Box - Word Art Tables - Rows , Columns, Cell - Merge Cell
- Split Cell TOC - Update entire - Header / Footer - Cover Page - Break - Section Break -
Spell Check - ABC / F7 - Word Count Working with Mail Merge
Unit 3 : Introduction to MS Powerpoint
Creating Presentation - File Extension - PPTx, PPSx - Slides and Layouts, Apply Background -
Title Bar, Menu Bar, Ribbon, Icons, Status Bar, Scroll Bar - View - Slide Master Insert Logo - to
display in all slides - Change Text color - to maintain consistency in all slides Slideshow - F5 /
Shift F5 New Slide - Ctrl + M Animation Effects - Apply in objects within the Slide Transition
Effect - Apply between slides Rehearse Timing - Set timing to each slide Loop until ESC - After
reaching LAST slide, display again from 1st slide. SaveAs - PPSx - PowerPoint Show SlideShow
- Use Pen / Highlighter Paste the Chart from Excel - Data linked to Excel source Insert Chart
within PowerPoint - Data linked internally
Unit 4 : Introduction to MS Excel &Using Formulas
Working with Excel Opening a Workbook - Understanding the Display Screen Working
with the Ribbon - Exploring the File Tab - Working with the Quick Access Toolbar -
Working with the Status Bar- Switching Between Opened Workbooks Entering Data -
Moving the Cell Pointer - Selecting a Range of Cells - Creating a New Workbook -
Inserting, Renaming, and Deleting Worksheets - Entering Constant Values - Using Auto
Fill to Enter Data - Saving a Workbook - Editing Cell Contents Clearing Cell Contents -
Insert / Edit Comments - Working with Undo and Redo - Closing a Workbook Using
Formulas Entering Formulas with Addressing Methods ( Relative / Mixed / Absolute ) -
Using Auto Fill with Formulas - Using the Sum, Average, Max, Min, Count Functions -
Using IF and NestedIf Function - Using Text Functions ( Len, Trim, Left, Right, Mid,
Find, Replace, Upper, Lower, Proper ) - Using Date Functions ( Today, Now, Day, Month,
Year ) - Using Lookup Functions ( Vlookup, Hlookup ) - Using Formula Error Checking -
Cutting / Copying and Pasting Constant Values and Formulas - Copy / Pasting using
Transpose option - Using Format Painter
Unit 5 : Working on multiple Worksheets & Working with huge Datasets
Formatting Worksheets - Formatting Numbers - Changing the Font Format - Aligning Cell
Contents - Merging Cells Adding Borders - Applying Cell Styles - Modifying Columns and
Rows - Changing Column Width - Changing Row Height Inserting and Deleting Columns or
Rows - Hiding Columns or Rows - Editing Workbooks - Working with AutoCorrect Checking
Spelling - Using Find and Replace - Using Hyperlinks ( Internal / External ) Working with huge
Dataset Using multilevel Sort - Using Filters - Fetching Unique Records Finding Duplicates -
Applying Conditional Formatting Rules Applying Freeze Panes - Using Pivot Table ( Layout &
Format ) Working with Charts Pie / Bar / Column / Line Charts - Titles / Legends / Data labels
Copy / Pasting in Word / PowerPoint Printing Worksheets Using Print Preview - Working with
Print Settings - Using Page Setup Tools - Working in Page Layout View - Creating a Header and
Footer - Using Page Break Preview - Printing a Worksheet Exiting Excel
TEXT BOOK & REFERENCE BOOKS:
1 Hart-Davis, G., Kettell, J. A., Simmons, C. (2003). Microsoft Office 2003: The
Complete Reference. United Kingdom: McGraw-Hill/Osborne.
2 Lambert, J., Frye, C. (2018). Microsoft Office 2019 Step by Step. United States: Pearson
Education.
3 Lambert, J., Cox, J. (2007). Microsoft Office Word 2007 Step by Step. United States:
Microsoft Press. 4 Richardson, T., Held, B., Moriarty, B. (2019). Microsoft Excel
Functions and Formulas with Excel 2019/Office 365. United States: Mercury Learning and
Information
5 Lalwani, L. (2019). Excel 2019 All-in-One: Master the New Features of Excel 2019 /
Office 365. India: BPB Publications.
6 Weverka, P. (2010). PowerPoint 2010 All-in-One For Dummies. Germany: Wiley.
WEB REFERENCE:
1. Ms Word tutorial: [Link]
2. Ms PowerPoint: [Link]
3. Mail Merge material: [Link]
for-bulk-email-letters-labelsand-envelopes-f488ed5b-b849-4c11-9cff-
932c49474705
4. Ms Excel functions: [Link]
5. Materials : [Link]
COURSE PLAN
Content No of Listening / reading Activity
Unit
Sessions materials
Introduction to Word [Link] Create an invitation in MS word
I processing -Word nHYzK-BVg for a college day programme.
processor / Editor - File
Extension - DOCx, DOTx 6
- Application / Document
area Title Bar, Menu Bar,
Ribbon, Icons, Status Bar,
Scroll Bar - Page Layout -
Page Size ( Letter / A4 ) -
Orientation ( Landscape /
Portrait ) - Margin ( Top,
Left, Bottom, Right ) -
Navigation(Arrow keys,
Ctrl + Arrow keys, Home,
End, Page UP/ Page Down
) - Selection - Using Shift
+ Navigation Fonts /
Superscript / Subscript -
Show / Hide - Displays
non printing characters
( Space / TAB / Enter ) -
Change Case - Bullets /
Numbering - Format
Painter – Clipboard -
Find / Replace Screen shot
- Prnt SCR / Alt + PrntScr
– Indent - Line and Para
spacing - Tab Stop - Text
to Table - Table to Text
Insert Tab - Picture [Link] Create a document to using
II ( Styles, Border, Effects, 6 [Link]/salem/referen clip arts, Tables, Bullets &
Warp Text, Align, Rotate, ce/wp-content/uplo numbering and headers
Flip, Crop ) - Water Mark ads/20 and footers.
- Shapes ( Group, 17/01/[Link]
Ungroup, Bring to Front,
Send to Back, Format
shape ) – Hyperlink –
Bookmark - Text Box -
Word Art Tables - Rows ,
Columns, Cell - Merge
Cell - Split Cell TOC -
Update entire - Header /
Footer - Cover Page -
Break - Section Break -
Spell Check - ABC / F7 -
Word Count Working
with Mail Merge
Creating Presentation - 6 [Link] Create a poster using MS
File Extension - PPTx, WJe_oYa3itE Powerpoint to celebrate
III PPSx - Slides and women’s day.
Layouts, Apply
Background - Title Bar,
Menu Bar, Ribbon, Icons,
Status Bar, Scroll Bar -
View - Slide Master
Insert Logo - to display in
all slides - Change Text
color - to maintain
consistency in all slides
Slideshow - F5 / Shift F5
New Slide - Ctrl + M
Animation Effects -
Apply in objects within
the Slide Transition
Effect - Apply between
slides Rehearse Timing -
Set timing to each slide
Loop until ESC - After
reaching LAST slide,
display again from 1st
slide. SaveAs - PPSx -
PowerPoint Show
SlideShow - Use Pen /
Highlighter Paste the
Chart from Excel - Data
linked to Excel source
Insert Chart within
PowerPoint - Data linked
internally
IV Working with Excel [Link] Create a table for the monthly
Opening a Workbook - .com/excel-basics/ income and expenditure incurred
Understanding the 6 in your startup company and
Display Screen Working generate a chart for the same.
with the Ribbon -
Exploring the File Tab -
Working with the Quick
Access Toolbar -
Working with the Status
Bar- Switching Between
Opened Workbooks
Entering Data - Moving
the Cell Pointer -
Selecting a Range of
Cells - Creating a New
Workbook - Inserting,
Renaming, and Deleting
Worksheets - Entering
Constant Values - Using
Auto Fill to Enter Data -
Saving a Workbook -
Editing Cell Contents
Clearing Cell Contents -
Insert / Edit Comments -
Working with Undo and
Redo - Closing a
Workbook Using
Formulas Entering
Formulas with
Addressing Methods
( Relative / Mixed /
Absolute ) - Using Auto
Fill with Formulas -
Using the Sum, Average,
Max, Min, Count
Functions - Using IF and
NestedIf Function -
Using Text Functions
( Len, Trim, Left, Right,
Mid, Find, Replace,
Upper, Lower, Proper ) -
Using Date Functions
( Today, Now, Day,
Month, Year ) - Using
Lookup Functions
( Vlookup, Hlookup ) -
Using Formula Error
Checking - Cutting /
Copying and Pasting
Constant Values and
Formulas - Copy /
Pasting using Transpose
option - Using Format
Painter
V Formatting Worksheets - [Link] Create a table for the monthly
Formatting Numbers - [Link]/data- income and expenditure incurred
Changing the Font 6 analysis/[Link] in your startup company and
Format - Aligning Cell generate a chart for the same.
Contents - Merging Cells
Adding Borders -
Applying Cell Styles -
Modifying Columns and
Rows - Changing
Column Width -
Changing Row Height
Inserting and Deleting
Columns or Rows -
Hiding Columns or Rows
- Editing Workbooks -
Working with
AutoCorrect Checking
Spelling - Using Find and
Replace - Using
Hyperlinks ( Internal /
External ) Working with
huge Dataset Using
multilevel Sort - Using
Filters - Fetching Unique
Records Finding
Duplicates - Applying
Conditional Formatting
Rules Applying Freeze
Panes - Using Pivot
Table ( Layout &
Format ) Working with
Charts Pie / Bar / Column
/ Line Charts - Titles /
Legends / Data labels
Copy / Pasting in Word /
PowerPoint Printing
Worksheets Using Print
Preview - Working with
Print Settings - Using
Page Setup Tools -
Working in Page Layout
View - Creating a Header
and Footer - Using Page
Break Preview - Printing
a Worksheet Exiting
Excel
ASSIGNMENT
Learning
Date of
[Link] Topics Materials to be
Submission
referred
Create a College Application
Form for using MS Word.
1 ------
Create a worksheet using MS
2 Excel to calculate the sales bill ------
of a Departmental store.
Create a presentation using MS
3 Powerpoint to celebrate ------
women’s day.
