MASTERING OFFICE (21CSL381)

MASTERING OFFICE

Course Code 21CSL381 
Teaching Hours/Week (L:T:P: S) 1:0:0:0 
SEE Marks 50
Total Hours of Pedagogy 12T + 12P 
Total Marks 100
Credits 01 
Exam Hours 02

CIE Marks 50

Module-1

MS-Word -Working with Files, Text – Formatting, Moving, copying and pasting text, Styles – Lists – Bulleted and numbered lists, Nested lists, Formatting lists. Table Manipulations. Graphics – Adding clip Art, add an image from a file, editing graphics, Page formatting - Header and footers, page numbers, Protect the Document, Mail Merge, Macros – Creating & Saving web pages, Hyperlinks. Textbook 1: Chapter 2

Module-2

MS-Excel- Modifying a Worksheet – Moving through cells, adding worksheets, rows and columns, Resizing rows and columns, selecting cells, Moving and copying cells, freezing panes - Macros – recording and running. Linking worksheets - Sorting and Filling, Alternating text and numbers with Auto fill, Auto filling functions. Graphics – Adding clip art, add an image from a file, Charts – Using chart Wizard, Copy a chart to Microsoft Word. Textbook 1: Chapter 3

Module-3

MS-Power Point -Create a Presentation from a template- Working with Slides – Insert a new slide, applying a design template, changing slide layouts – Resizing a text box, Text box properties, delete a text box - Video and Audio effects, Color Schemes & Backgrounds Adding clip art, adding an image from a file, Save as a web page. Textbook 1: Chapter 5

Module-4

MS-Access - Using Access database wizard, pages and projects. Creating Tables – Create a Table in design view. Datasheet Records – Adding, Editing, deleting records, Adding and deleting columns Resizing rows and columns, finding data in a table & replacing, Print a datasheet. Queries - MS-Access. Textbook 1: Chapter 4

Module-5

Microsoft Outlook- Introduction, Starting Microsoft Outlook, Outlook Today, Different Views In Outlook, Outlook Data Files Textbook 1: Chapter 7

Weblinks and Video Lectures (e-Resources):

1. https://youtu.be/9VRmgC2GRFE

2. https://youtu.be/rJPWi5x0g3I

3. https://youtu.be/tcj2BhhCMN4

4. https://youtu.be/ubmwp8kbfPc

5. https://youtu.be/i6eNvfQ8fTw

6. http://office.microsoft.com/en-us/training/CR010047968.aspx

7. https://gsuite.google.com/leaming-center

8. http://spoken-tutorial.org

Activity Based Learning (Suggested Activities in Class)/ Practical Based learning

 Real world problem solving using group discussion.

 Real world examples of Windows Framework.