Introduction
"ComputerApplicationFundamentals"isanintroductorycomputercourse.Qualitycourses.
Thebooksatisfiestheteachingtenetofordinarycollegesanduniversitiestotrain"appliedtalents".Itisrichincontent,keepspacewiththetimes,andhasstrongpracticability.
Thisbookcanbeusedasatextbookforcolleges,vocationalandtechnicalcolleges,andasatrainingtextbookforshort-termcomputerofficetrainingclassesorasatutorialbook.
BookCatalog
Chapter1ComputerBasicKnowledge
1.1ComputerDevelopmentandApplication
1.1.1ComputerDevelopment
1.1.2Computerapplication
1.2Computerhardwareintroduction
1.2.1Mainframe,centralprocessingunitandmotherboard
1.2.2Memory,Inputandoutputequipment
1.2.3Otherexternalequipment
1.2.4Computermainperformanceindicators
1.3Computerandcoding
1.3.1NumberSystem
1.3.2Coding
1.4ComputerSoftwareSystem
1.4.1SystemSoftware
1.4.2ApplicationSoftware
Practicequestions
Chapter2WindowsOperatingSystem
2.1Windowsstartupandexitandinterfacecomposition
2.1.1WindowsstartupAndexit
2.1.2Windowsinterfacecomposition
2.2Windowsbasicoperation
2.2.1mouseandkeyboard
2.2.2"Start"menu
2.2.3window
2.2.4menu
2.2.5dialogbox
2.3Windowsfilemanagement
2.3.1Fileconcept
2.3.2Folderandfilelocation
2.3.3"MyComputer"
2.3.4FileandFolderManagement
2.3.5FileandFolderProperties
2.3.6DiskManagement
2.4SystemSettings
2.4.1TaskbarandStartMenu
2.4.2DesktopSettings
2.4.3ControlPanel
2.5CommonlyusedprogramsthatcomewithWindows
2.5.1Calculator
2.5.2Notepad
2.5.3WordPad
2.5.4Drawing
2.6Windowsnetworkusage
2.6.1NetworkNeighborhood
2.6.2ResourceSharing
Practices
Chapter3WordApplication
3.1WordIntroduction
3.1.1Word2003startupandshutdown
3.1.2Word2003workinginterface
3.1.3ViewWorddocuments
3.2Wordbasicoperations
3.2.1documentcreation
3.2.2documentinput
3.2.3Savingandopeningofdocuments
3.2.4Texteditingoperations
3.3Wordtypesettingtechnology
3.3.1Settingcharacterformat
3.3.2Paragraphformatting
3.3.3Settingtabstops
3.3.4Bulletsandnumbering
3.3.5Theuseofformatbrush
3.3.6Borderandshading
3.3.7Columns
3.3.8Insertpagenumberandsetseparator
3.3.9Setheaderandfooter
3.4Wordadvancedtypesettingoperations
3.4.1Useofstyles
3.4.2Longdocumentproduction
3.4.3Speciallayout
3.4.4Documentpagesettings
3.5Formproduction
3.5.1Createform
p>3.5.2Formediting
3.5.3Formmodification
3.6Dataprocessingintheform
3.6.1Sortingoftheform
p>3.6.2Numericalcalculationoftables
3.6.3Interchangeoftablesandtext
3.7Graphicfunction
3.7.1InserttextBox
3.7.2InsertClipArt
3.7.3InsertPictureFile
3.7.4InsertWordArt
3.7.5InsertAutograph
3.7.6InsertIcon
3.8MailMerge
3.8.1UseMailMergeRelatedConceptsandSteps
3.8.2Createaformletter
3.8.3Makeanemailenvelopeandlabel
Practicequestions
Chapter4ExcelApplication
4.1IntroductiontoExcel
4.1.1Excelinterfacecomposition
4.1.2Fileoperations
4.2Excelbasicoperations
4.2.1Basiccelloperations
4.2.2Areaselection
4.2.3Worksheetoperations
4.3Formulasandfunctions
4.3.1Entertheformula
4.3.2Automaticsummation
4.3.3Function
4.3.4Addressreference
4.4WorksheetFormat
4.4.1Cellformatting
4.4.2Rowheightandcolumnwidth
4.4.3Patternandcolor
4.4.4Gridlinesandborders
4.5DataManagement
4.5.1Createdatalist
4.5.2DataValidity
4.5.3Sortingofdata
4.6Chartproduction
4.6.1Createchart
4.6.2Editchart
Practicequestions
Chapter5PowerPointApplication
5.1IntroductiontoPowerPoint
5.1.1FeaturesofPowerPoint
5.1.2PowerPointworkinterface
5.1.3Creatingapresentation
5.2BasicoperationsofPowerPoint
5.2.1Makingslides
5.2.2Makingpresentations
5.2.3Editingpresentations
5.2.4Savingpresentations
5.3Editingandbeautifyingpresentations
5.3.1Pageformatconversion
5.3.2Edittextandparagraphs
5.3.3Changepageappearance
5.3.4Insertotherobjects
5.4Maketheslidesmove
5.4.1Switchingofslides
5.4.2Animationscheme
5.4.3SinceDefineanimation
5.4.4Addmusicorsound
5.4.5Automaticplaybackofslideshow
Practicequestions
Chapter6Internetapplication
6.1Internetaccess
6.1.1AccesstotheInternetthroughLAN
6.1.2AccesstotheInternetthroughdial-up
6.2UseIEtobrowsetheweb
6.2.1UseofIE
6.2.2IEsettings
6.3UseOutlooktoreceiveandsendemail
6.3.1Outlookinterface
6.3.2Accountsettings
6.3.3Emailwritingandsending
6.3.4Emailreceivingandreading
Practicequestions
Chapter7CourseTraining
7.1UseWordtomakea"jobapplicationresume"asshowninFigure7-1.
7.2UseExceltocreatethe"employeeregistrationform"showninFigure7-14
7.3Makeaphotoalbum
7.3.1CreatetheopeningslideshowasshowninFigure7-29
7.3.2Makeaslideshowof"cuttingpictureswithself-selectedgraphics"
7.3.3Makeaslideshowwithmultipleobjectsevenlydistributed
7.3.4Drawaslideshowwiththeeffectsof"puzzle"and"filmfilm"
7.3.5continuetoinsertotherslides
7.3.6Settheanimationeffect
7.3.7Settheswitchingmethodoftheslideshow
7.3.8Letthebeautifulsongsrunthrough
7.4UseExcelMakingasingle-choiceelectronictestpaper
Chapter8:Respondingtoproblemsthatmaybeencounteredinjobinterviewsinthiscourse
Referenceanswerstopracticequestions