Semester wise Topics for AOC

Semester1

Paper 1: Fundamentals of Computer & Operating system, Peripheral Management

Module 1

Introduction to Computer: Characteristics – Historical evolution –Generation, Basic classification – Data representation (Number system, Base Values) – Different number systems (Decimal, Binary, Octal, and Hexa – decimal) and their mutual conversions – ASCII code – Computer Organization: CPU, ALU, Control unit – Buses – Computer memory – Features of memory devices RAM, Static RAM, Dynamic RAM – ROM (PROM, EPROM, EEPROM) – Secondary storage devices – Floppy, Zip disk, Hard disk, Optical (CD, DVD, Blue Ray), Pen drive – Input/Output devices: Description about standard Input Devices (keyboard & Mouse) – Pointing devices (joystick, touch pad, touch pad, touch screen, track ball, light pen)- Scanner – Character recognition devices (OMR, MICR, OCR, BCR) – Soft copy devices (CRT, LCD) – Hard copy devices – Printers, types of printers (Impact, Non-Impact, Plotters)

Module 2

Network & Communications: – Types of Network – LAN, MAN, WAN – Topologies – Internet – Internet – Internet Services- Programming Logic and Flow Chart: Concept of programming – Algorithmic representation – Flow chart – Basic symbols in flow chart representation –Assembler, Compiler, Interpreter– System software – Application software- Computer languages: Low level, High level – Virus and Antivirus.

Module 3

Operating Systems

MS DOS – Features – Post – Booting and its types – DOS prompt – internal commands – DIR and its switches, cls, date, time, ver, vol, copy con, type, rename/ren, copy, del/erase, wildcard characters, prompt, mkdir/md,  chdir/cd, rmdir/rd, cd.., cd\, path – External commands – label, mem, chkdsk, scandisk, more, xcopy and its switches, attrib and switches, format (on floppy), batch files

Microsoft Windows:- GUI, WIMPs – mouse operations – Windows screen element (desktop, icon, task bar, My computer Recycle bin) – Creating shortcuts and icon management – Set desktop options (screensavers) – Manage multiple windows – Windows Explorer – Creating folders – Copy and Move files and folders – Save in different locations –Search files and folders – Deleting files – Use quick launch – Keyboard commands – Scandisk – Defrayment – Browse the Web – Using Internet and E-mail – Clipboard – Word pad – Paint – Install applications from a CD with an install program – Switch off the computer.

Linux:- History and features of Linux – Introduction to free software foundation (FSF) – Linux v/s DOS, cross comparison using commands – Linux distributions – Red hat, mandrake, Suse, Debain, Slackware, Introduction to Virtual Desktop (KDE) – Set desktop options – Install applications from distribution CD – Using Help functions – Text editing Applications (KEdit) –Save the file to a location on the drive – Desktop working with icons (open a file, directory/folder, application from desktop) – Working with windows (collapse, expand, resize, move, close a window) – Switch between open windows – Managing files (mounting, un mounting) – Using directories/folders – Working with files – File extension – Count total no. of files and sub – directories in a directory – Count files of a particular type – Sort files by name, size, type, date modified – Rename files, directories/ folders – Delete, Restore (files/directories)- Searching of files, directory/folders – Delete, Restore (files/directories) – Searching of files, directory/folders (by content, date, modified, date created, size, windows), View list of recently used files, Compressing files.

Computer Peripheral Management

Monitors, Keyboards, Memories, Hard disks, Floppy disks, Cd-rom drive, Pen drive, Webcam.

Paper 2: Office suite, Office Productivity Tools & Internet Usage

MS Word: Introduction – Basic elements of a Word Window – Working with files creating, opening, saving, working on multiple documents – Working with text: typing and inserting, selecting, deleting, undo, redo, formatting, format painter – formatting paragraph: paragraph: attributes, moving, coping and pasting, clip board, columns Formatting list: bullets and numbering, nested list – Applying style: create. Modify, delete – Spelling and Grammar: autocorrect spelling and grammar checking, synonyms, thesaurus – Tables: Inserting table, drawing table, moving and resizing table, inserting rows and columns – Document merging –Graphics: Adding clip arts adding images from file, editing, drawing auto shapes – Macro: defining, running – Page formatting: margins, size and orientation, header and footer, page number, print preview and printing.

MS Excel: Introduction – Screen elements – Basics terms and definitions – Adding and renaming worksheets – Moving and copying cells – Cell formatting: Number tab, element tab, font tab, border and pattern tab – Date and time- Applying styles – Cell formatting: auto formatting and conditional formatting – Formulas and functions: applying formulas – Linking worksheets, basic functions (SUM, AVERAGE, MIN, MAX, SQRT, TODAY), using function wizards – Sorting and Filtering: basic sorts, complex sort, autofill, filling using functions, goal seeking – Scenarios – Charts: using wizards, working with charts, formatting – Pivot table: creating, lay – outing etc..- Object Linking and Embedding

MS Power Point: Introduction – Features – Hints for successful presentation – Screen layout – Views: normal, slide, outline – Creating a presentation: inserting and new slide, applying templates, changing slide layout, recording and hiding slides – Create a custom slide show – Bulleted list on design templates, number list – Inserting video and audio – Working with colors – Display backgrounds – Drawing graphics: adding clip art, image, auto shapes, word art – Applying slide effects: implementing animations, previewing animations, setting master slides, header and footer, slide numbers, date and time, etc.

MS Access: Definition of RDBMS – normalization Concepts – Creating a blank database – Creating tables: using wizards, and design view- Setting table fields, inserting table elements, setting primary key, adding, deleting records – Setting relationship between tables – Queries: create queries, using wizards and design view – Forms and Reports: create using wizards and design view, adding records, editing forms, reports using wizards and design view, printing reports – Table manipulations with SQL statements (Create, Select, Insert, Update (Alter, Modify) and Delete statements )

OpenOffice.Org

An open source suite of office products sponsored by Sun Microsystems, Open Office.Org is a competitor to Microsoft Office.  It contains products similar to those MS Office.  Students are required to follow similar syllabus for the Open Office.Org applications as mentioned and followed in the respective Microsoft Office Applications.  Open Office.Org products covered are:

Writer: A word processor similar in look and feel to Microsoft Word

Calc: A spreadsheet similar to Microsoft Excel with roughly equivalent range of features

Impress: A presentation program similar to Microsoft Power Point.

Base: A database program similar to Microsoft Access.
Internet Usage

What is Internet, History of the Internet, Advantage and Disadvantage of Internet URL, World Wide Web, Web Page, Electronic Mail – Microsoft Internet Explorer, Netscape Navigator, Attaching Files to Email, Sending Email, Downloading, Uploading, Searching, Computer Virus, Search engines, Social networking sites, Web computing, Browsers, Common web applications, IP address, DNS,Google Calendar, Google Docs.

Paper 3: Communicative English I

Grammar: Noun, Verbs, Adjectives, Pronouns, Adverbs, Clauses – Conjunctions and prepositions, Comparatives and superlatives – using the following: Am, Is, Are, Was, Were, Have, Has, Had, Do, Does, Did, Can, Could, May, Might, Must, Ought, Need, Dare, Used Tense:– Present tense, Present Continuous tense, Present Perfect tense, Present perfect Continuous tense, Past tense, Past Continuous tense, Past Perfect tense, Past Perfect Continuous tense, Future tense, Future Continuous tense, Future Perfect Continuous tense – Active voice and passive voice – Direct and Indirect speech – Sentence formation: Subject and predicate – Classification of sentences: Statement sentence, Imperative sentence, interrogative (question) sentence, Exclamatory sentence, Sentence in simple present tense, Compound sentence, Complex sentences Compound complex sentence

LAB : 1) OS & Office

2) Internet Usage

Semester2

Paper 4:  Business Financial Processing (Accountancy, Manual accountings, Tally Erp9 & Peach Tree)

Basic Accounting, Book keeping, Meaning and Definition of Accounting, Distinction between Accounting and Book Keeping, Types of Accounts, Process of Accounting, Objects of Accounting, Functions of Accounting, Accounting Systems, Debit and Credit rules of Accounts, Cash, Credit and Barter Transactions – Account books, Journal, Steps of Journalizing, Bank transactions – Cash Transactions: Cash payment and Receipt transactions –Cheque Transactions: Cheque payment and Receipt Transactions – Assets: Fixed Asset, Current Asset – Purchase: Cash Purchase, Purchase by cheque and credit purchase – Sales: Cash sales, Sales for cheque and credit sales, Purchase return, Sales return, Capital, Drawings – Accounting Adjustments: Out standings, Prepaid, Depreciation and Bad debt, Compound/Combined journal Entries, Ledger, Trial Balance, Methods for preparation of a trial balance – Final Accounts: Trading Account, Form of a trading Account, Gross profit, Gross loss, Direct Expenses, Indirect expenses, Preparation of a trading account, Profit and loss account, Form of a profit and loss account, Balance sheet, Form of a balance sheet, Current liabilities, Long – term liabilities, Goodwill, Creditors, Debtors, Stock of goods, Difference between profit and loss Account and Balance sheet, Bank Reconciliation, Performa of a Bank reconciliation statement.

Tally: – Introduction, Features, Getting started with tally, company creation ledger creation, multiple ledger creation, Display/Alter multiple groups, Accounting group of ledgers – Inventory Control system: – Stock groups, Display/Alter stock groups,  Unit of measures, Display/Alter unit of measures, stock item, stock category creation, Godown creation – Accounting Vouchers: – voucher date changing, contra voucher, payment voucher, Receipt voucher, journal voucher, sales voucher, purchase voucher –Inventory Vouchers: – Stock journal voucher, physical stock voucher – Features: – Separate Discount column, ‘O’ valued entries in vouchers, Additional cost, use different actual Billed quantity, Debit Note, Credit Note, purchase order, sales order, Batch – wise details, Cost centre creation, Tracking Number, Rejection Notes, memorandum voucher, VAT – Reports: – Day Book, Trial Balance, Trading and profit and loss Account, Balance sheet, Stock summary and Key Board short cuts.

Paper 5: Communicative English II, Administrative Skills&Organisational Behaviour

Reading practice and Dictation (on any specific topic), Vocabulary, Phonetics, Presentation: – Speech, Debate, Group Discussion, Interview Practice, LETTER DRAFTING:-Personal letter, Greeting letter, Invitation letter, Complaints, Job application, Leave letter.

Learning to communicate effectively, managing work and time, preparing communication documents with proper format, language usage, punctuation and reference sources. Understanding proof reading symbols, records management, handling business financial procedures, processing mail, scheduling appointment and receiving visitors, making travel arrangements, planning meetings and conferences, telephone skills and voice recognition. Fostering good human relations in an office and developing attitudes and traits of the successful executive secretary.

Professional Portfolio Development

There will be intensive sessions on creating a positive attitude, on personality development and on interview techniques.

Projects covered in the course of the program will be analyzed and developed to produce a portfolio to be presented to potential clients and employers. Students will prepare a draft CV to include the qualifications gained on this course and submit this to our careers adviser who can provide help the guidance in developing this to a professional standard, ensuring it is suitable for the types of jobs and business you wish to work in. Also will be prepared, the draft answers to standard interviews, enabling one to prepare a “script” in readiness for any interviews, and again submit this to our careers adviser who can see how you are portraying yourself at the interview stage.

ORGANISATIONAL BEHAVIOUR

Organizational Behavior – Meaning – Development of organizational Behavior Personality – Determinants – Structure – Personality and Organization – Personality and Behavior – Attitudes – Nature – Attitudes and Values – Opinions – Prejudice Motivation – Motives – Classification Morale – Indicators – Aspects – Factors Affecting Morale – Improving Morale. Stress Management – Types – Management of stress – Ways to overcome stress. Organizational Culture – Levels – Types of Corporate Culture

LAB : 1) Tally & Peachtree

2) Handling Computer Peripherals like Printer, Scanner,

FAX, Web Cam, CD/DVD writing