PGDCA 102 Office Automation

PGDCA 102 Office Automation – ऑफिस ऑटोमेशन कोर्स पूरा होने के बाद छात्र इन टॉपिक्स में स्ट्रांग हो सकेंगे- यह विषय ऑफिस ऑटोमेशन कार्य की मूल बातें समझने में मदद करता है। छात्र दस्तावेज़ बनाने, स्प्रेडशीट बनाने, छोटे प्रेजेंटेशन बनाने और इंटरनेट से परिचित हो सकेंगे। छात्र डेटाबेस निर्माण और टैली सॉफ्टवेयर में जर्नल, लेजर, लेनदेन के ट्रायल बैलेंस के निर्माण के बारे में जानेंगे।

उपरोक्त विषय में हमने सिलेबस के अनुसार सभी यूनिट को शामिल किया है आप दिए गए लिंक के माध्यम से भी नोट्स तैयार कर सकते है. दुसरे नोट्स के लिए आप हमारे साईट के मैं लिंक computerallnotes.com पर जा सकते है.

PGDCA 102 Office Automation

पीजीडीसीए के ऑफिस ऑटोमेशन कोर्स में निम्न यूनिट और टॉपिक्स होते है-

Unit 1 – Working with MS-Word

Unit 2 – Introduction to MS-Excel

Unit 3 – Advanced Excel

Unit 4 – Working with MS-Power Point

Unit 5 – Working with MS-Access

PGDCA I-Sem Notes in Hindi

Unit 1 – Working with MS-Word

Introduction to word processing’s software and it’s features

Creating new document, Saving documents, Opening and printing documents

Home Tab: Setting fonts, Paragraph settings, various styles (Normal, Nospacing. Headingl, Heading2, Title, Strong), Find & replace, Format painter. Copy paste and paste special

Insert Tab: Pages, Tables, pictures, clipart, shapes, header & footer, word art, equation and symbols

Page Layout Tab: Page setup. page Background. Paragraph (indent and spacing)

Mailing Tab: Create envelops and Labels. Mail merge.

Review Tab: Spelling and grammar check. New comment, Protect document

View Tab: Document views. Zoom. Window (New window. Split. Switch window).

Unit 2 – Introduction to MS-Excel

Introducing Excel, Use of excel sheet.

Creating new sheet, Saving. Opening, and printing workbook.

Home Tab: Font, Alignment. Number, Styles and cells and editing. Conditional Formatting.

Insert Tab: Table, Charts (column chart. Pie chart. Bar chart. Line chart) and Texts (header & footer, word art, signature line).

Page Layout Tab: Page setup options. Scale to it(width, height, scale).

Formulas Tab: Auto sum (sum, average, min, max),logical(IF. and, or, not, true, false), Math & trig(sin.cosine.tangent.ceil.floor, fact,mod.log), watch window.

Data Tab: Get external data from MS Access, Sort and filter options, Data validation, Group and ungroup.

Review Tab: Protects Sheet. Protect workbook. Share work book.

View Tab: Page breaks, Page layout. Freezing panes, Split and hide.

Unit 3 – Advanced Excel

Data analysis

Financial Modeling

Decision Making

Dashboard Reporting

Project Management and its Templates-Gantt Chart Template. Dashboard Template, Status Report Template, Action Plan Template. Estimate Template etc

Budgeting and Forecasting, Inventory Management

advance excel formula- index match, if combined with and/or, offset combined with sum or average, choose, xnpv and xirr. sumif and countif, pmt and ipmt, concatenate, Vlookup, Hlookup etc.

Unit 4 – Working with MS-Power Point

Introducing power point

Use of power point presentation

Creating new slides saving. Opening and printing

Home Tab: New slide, Layout, Reset, Delete. Setting text direction, Align text. Convert to smart art, drawing options

Insert Tab: Table, picture, clipart, photo album, smart art, shapes and chart. movie and sound, hyperlink and action, textbox, word art, object

Design Tab: Page setup options. slide. Orientation, applying various themes, selecting background style and formatting it

Animations Tab: Custom animation for entrance.exit and emphasis, applying slide transition, setting transition speed and sound, animation on rehears timing

Slides how & view Tab: Start slide show options. setup options

View tab: Presentation views.colors andwindow option.

Unit 5 – Working with MS-Access

Front end and backend of application

Introduction to DBMS, Features of DBMS

Creating blank databases, saving accdb format. Defining data types MS-access

Home Tab: Datasheet view, design view, pivot chart view, pivot table view, sort and filter options

Create Tab: Creating tables. Creating reports. Query wizard. External Data Tab: importing data from access and excel sheet, exporting data to excel and MS word

Datasheet Tab: Relationships. Fields and columns options. Data type and formatting options.