Computer & IT Application - II

Syllabus

P3'': Computer & IT Applications - II

UNIT I

Text Processing Software: Creating and Saving a Document, Previewing and Printing a Document, Editing, Proofreading and Formatting of Documents. Presenting Information in Columns and Tables, using Graphics, Symbols, Diagrams and Charts. Creating and Modifying Table of Contents, Index, Bookmarks, Cross References, Hyperlinks, Foot Notes, End Notes and Bibliography. Crating form Letters, E-Mail Messages and Labels. Collaborating using Tracking of Changes, Adding and Reviewing Comments, Comparing and Merging Documents, Password Protecting of Documents. Creating Documents in Alternate Formats, Mail Merge.

UNIT II

Presentation Software: Creating and Managing Slides and Presentation, Entering and Editing Content on Slides, Presenting Content in Tables, Inserting, Creating and Managing Graphics, Adding Sound and Animation to Slides, Reviewing, Preparing and Delivering Presentation, Customising and Sharing Presentations.

UNIT III

Spreadsheet Software: Creating Workbooks, Working with Data and Tables, Formatting and Changing Workbook Appearance, Managing and Hiding Worksheet Data, Ordering and Summarising Data, Combining Data from Multiple Sources, Creating Charts and Graphs, Protection of Worksheet

Performing Calculations using Formulas and Functions: Analysing Alternate Data Sets, Creating Dynamic Worksheets, Printing WORKSHEETS and Charts. Automating Repetitive Tasks, Performing Business Intelligence Analysis: What-if Analysis, Goal Seek, Data Table, Lookup, Match, Index etc.

UNIT IV

Database: Introduction to Database and Database Management System, Database Models, Type of Databases, Introduction to MS-Access, Creation of Database Tables, Data Types, Basic Query and Report Generation.