Computer Aided Personal Productivity Tools Lab Syllabus MBA Pune university for Academic year 2013-14

Subject Name: Computer Aided Personal Productivity Tools Lab

Subject Type: Generic- Elective ( Internal Subject for Sem II)

Subject Code: 213

Marks: 50

Distribution of Marks: 50 (Internal Marks by College)

Unit 1 MS WORD + 1

1.1 Collaboration – Protect your document with passwords, permission, and other restrictions, Save a document to SharePoint from Office 2010, The purpose of IRM and its limitations, Mail Merge (1)

1.2 Tracking changes and comments – Turn track changes on or off, Review tracked changes and comments (1)

1.3 Formatting – Add, change, or delete WordArt, Add or remove text effects, Adjust the spaces between letters, lines or paragraphs, Set the default font, Language, Apply, customize, and save a document theme in Word (1)

1.4 Tables of contents and other references – Create a table of contents, Edit a citation placeholder, Create a bibliography, Foot note & End Note, Captions & Index (1)

1.5 Checking Spelling, grammar, and thesaurus 1.6 Managing Headers, footers, and page numbers, Links (1)

1.7 Inserting Page breaks and section breaks, Applying Multiple headers, page layouts 1.8 Tables Tools, Illustrations, Equations, Symbols (1)


2.1 Working with text & SmartArt graphics – Add alternative text to a shape, picture, chart, table, SmartArt graphic, or other object, Wrap text around an object in PowerPoint 2010, Adjust the indent in a bulleted or numbered list on the ruler, Change the look, position, or function of bulleted or numbered lists in your presentation (1)

2.2 Organizing and formatting slides, Using masters – Understanding a slide master, Create or customize a slide master, Apply one or more slide masters to a presentation (1)

2.3 Working with animation, sounds & Movies – Turn your presentation into a video, Embed or link to a video from your presentation, Set the ‘Play’ options fora video in your presentation, Trim a video, Compress your media files, Tips for improving audio and video playback and compatibility (1)

2.4 Working with hyperlinks and action buttons (1)

2.5 Reviewing and adding comments – Show markup and add Comments 2.6 Creating support materials – Notes and Notes Master, Printing Notes (1)

2.7 Delivering your presentation – Using Presenter’s Mode, Optimising Handouts 2.8 Embedding Presentation – Multiple presentations & Slides and files on the slide (1)


3.1 Excel Basics Review – Using Keyboard, Importing and Exporting Data (Access, SPSS) (1)

3.2 Excel For Marketing & Statistics – Creating Business Solutions (1) 3.3 Excel & HRIS – Database Creation, Analysis & reporting (1)

3.4 Excel for Finance – Analysing Financial Statements e.g. Balance sheet, Ratio Analysis, Using Applications e.g. PROWESS, Ace Equity, Creating Excel Dashboard (3)

Unit 4 MS Outlook

4.1 MS Outlook -Start using the Outlook Social Connector, Stay up-to-date in the People Pane, Assign a colour category to an e-mail message, Customize the appearance of task lists, Turn the Reading Pane on or off, Introduction to Conversations, Create and add a message signature, Manage messages by using rules, Automate common or repetitive tasks (2)

Unit 5 Media for Social Connectivity

5.1 Using Google + & Google Docs ( 2 )

5.2 Using Twitter for networking and Business (1)

5.3 Creating Blogs, Using LinkedIn, and other academics and Business websites. Networking, Surveys, Discussions, Business Information (2)


Emphasis should be on hands on experience.

All sessions should be conducted in the IT laboratory.

Text Books

• Excel 2010 Bible [With CDROM] by John Walkenbach John Wiley & Sons

• Word 2010 Bible by Herb TysonJohn Wiley & Sons

• MOS 2010 Study Guide for Microsoft Word, Excel, PowerPoint, and Outlookby Joan Lambert III and Joyce Cox(Apr 8, 2011)

• Microsoft Word 2010 Step by Stepby Joyce Cox and Joan Lambert III

• PowerPoint 2010 Bible [Paperback] by Faithe Wempen

Reference Books

• Microsoft Word 2010 in Depth by Faithe Wempen

• Microsoft Word 2010 Plain & Simple by Katherine Murray

• Beyond Bullet Points: Using Microsoft PowerPoint to Create Presentations That Inform, Motivate, and Inspire [Paperback] BPG

• Microsoft PowerPoint 2010 Plain & Simple by Nancy Muir

• Office 2010 Bible by John Walkenbach, Herb Tyson, Michael R. Groh, Faithe Wempen, Lisa A. Bucki

• Business Analysis with MS Excel by Conard Carlberg, Pearson Education

Supplementary Reading material





• _tools