Home | Courses | AIITA | Advance Certificate in Office Automation

Advance Certificate in Office Automation

By
Font size: Decrease font Enlarge font

Aiita offers many job oriented computer courses.”Advance Certificate in Office Automation” is one of the Aiita approved course.The detailed contents of this course is in the attachment.

COURSE CODE : ACR -01

ELIGIBILITY : 10th

DURATION : 4 Months

SYLLABUS

Fundamental Of Computers

  • Introduction To Computers , Types Of Computer , History Of Computer , Generation Of Computer , PC & Its Components , Disk Defragmentor , Categories Of PC , Evolution Of Micro Processors , Registers Of Micro Processors , Basic Components Of Computer System , Input Output& Storage Units , Software , Types Of Software , Types Of Operating System , Categories Of OS , Example Of Utility Program , Programming Languages , Generations Of Programming Language , Application Software , User &Example Of Application Software , Viruses , Types Of Virus , Virus Detection &Prevention , Communication Process , Communication Protocols , Communication Channel/Media , Modem , Components Of  LAN  , Types Of Internet Connections , Internet& Its Advantages , Internet Services , WWW & Common Technologies of Internet

Dos/Windows XP

 DOS

  • Disk Operating System(Dos) , Introduction , History & Versions Of Dos , Basic–Physical Structure Of Disk, Drive Name , Fat , File &Directory Structure And Naming Rules , Booting Process , Dos , System Files , Dos Commands Internal & External Dir,Md,Cd,Rd,Copy,Del,Ren,Vol,Date,Time,Cls,Path,Type Etc. ,   Chkdsk,Xcopy,Print,Diskcopy,Diskcomp,Doskey,Tree,Move,Label,Append,Format,Sort,Fdisk,Backup,Edit,Move.

Windows XP

  • Introduction To Window XP And Its Features , Hardware Requirements Of Windows , Window Structure,Desktop,Taskbar,Start Menu , Working ,With Recycle Bin –Restoring  A Delete File ,Emptying The Recycle Bin , Managing Files, Folders And Disk Navigating Between Folders ,Manipulating Files And Folders ,Creating New Folder ,Searching Files And Folder My Computer Exploring Hard Disk ,Copying And Moving Files And Folder from One Drive To Another Formatting Floppy Drive ,Windows Accessories-Calculator ,Notepad ,Paint, Wordpad ,Character Map,Paint

Application Package (MS Office)

Office package

  • Word processor Software , Spreadsheet software , Presentation software , Database Management software

MS Word

  • Introduction to Ms Office , Introduction to Ms Word , How to Start , Components of Ms Word , File Menu , Edit Menu , View Menu , Insert Menu , Format Menu , Tools Menu , Table Menu , Window Menu , Help Menu

MS Excel

  • Introduction to MsExcel , Calculations , Formula , Functions , Insert Row/Columns , Create Chart , Format Sheet

Tools Menu

  • Goal Seek , Scenario , Auditing

Data Menu

  • Sort , Filter , Advance Filter , Sub total , Forms , Validations , Table , Consolidate , Pivot table , Window , Help

Ms PowerPoint

  • Introduction , Insert New Slide , Format Slide , Slide Show

MS Access

  • Introduction , Different Between DBMS /RDBMS , Hierarchy , Database File , How to Start work , Create database using wizard , Create blank Database 

Data base object

  • Table , Primary key , Manipulate data , Field properties , Relationships , Forms , Sub forms , Queries , Operators , Calculations , Update Query , Reports , Macro , Import data

Pagemaker

 Adobe Pagemaker

  • Components of Pagemaker , ToolBox , Palettes , Working with text

Constructing a Publication

  • Creating a new Page , Save publication , Preferences  

Edit Text

  • Edit Story , Master Pge , Measurement , Ruler & guideline , Pge numbers

Layout menu

  • Sorting page , Deleting Pge

Text formatting

  • Type Menu , Control Palette , Expert Tracking , Indents And Teb

Element Menu

  • Fill , Fill and Stroke , Create a Frame , Arrange , Wrap textGroup Object , Image Control , Using PhotoShop Effect , Change the Shape Of Polygon/ Rectangle

Utilities Menu 

  • Checking Spelling & Grammer , Change Case , Intex Entry

 

 

 

 

Editor's Desk

How Much Faster Can You Learn?

Say you were to optimize everything you possibly could for a particular learning goal. You used the best time-management system, you picked exactly the right tasks that would drive learning improvement, you applied tremendous motivation and effort. How much faster could you learn something than the status quo would expect? The answer, of course, will be: it depends. But that's rather unsatisfying, if true, because the crucial question is: what does it depend on? Asking how much improvement over the status quo or expected rate of progress is an interesting question in many domains. In some areas, there might be ... Read More

  • Email to a friend Email to a friend
  • Print version Print version

Rate this article

0