李云平版 計算機專業(yè)英語——學習情景1：辦公自動化VIP

計算機專業(yè)英語 主講教師 2 能力提高篇 3 能力提高篇 LearningScenarios1OfficeAutomation Words ExpressionsTextA OfficeSoftwareTextB OfficeHardwarePracticeReadingMaterial 5 Words Expressions 6 Words Expressions 7 Words Expressions 8 Words Expressions 9 TextA OfficeSoftware OfficeAutomationistheapplicationofcomputerandcommunicationtechnologytoimprovetheproductivityofclericalandmanagerialofficeworkers Today sorganizationshaveavarietyofofficeautomationhardwareandsoftwarecomponents Officesoftwarecanbeusedtodowordprocessingandsimpledatabaseprocessing maketheformandslideshow etc OfficesoftwareincludesMicrosoftOffice KingsoftWPS YOZOsoftOffice RedOffice etc Theapplicationrangeofofficesoftwareisverywide frommeetingrecordtosocialinvestigation anddigitalofficeisinseparablefromthehelpofit Withthedevelopmentofscienceandtechnology theoperationofofficesoftwarehasbeenbecomingmoreandmoresimple butthefunctionhasbeenbecomingmoreandmoredetailed MicrosoftOffice2010isanewgenerationofofficesoftware whichhassixversions TheyareOfficePrimary OfficeHomeandStudent OfficeHomeandBusiness OfficeStandard OfficeProfessionalandOfficeProfessionalPlus ThestandardeditionofMicrosoftOffice2010includesalotofcomponentswhichareMicrosoftWord2010 MicrosoftExcel2010 MicrosoftOutlook2010withBusinessContactManager MicrosoftPowerPoint2010 MicrosoftOneNote2010 MicrosoftPublisher2010andMicrosoftOfficeWebApps 10 TextA OfficeSoftware MicrosoftWord Asshowninfigure1 1below MicrosoftWordisanapplicationofwordprocessor Wordcanbeusedtoeditthetext graphics image soundandanimation andinserttheinformationofothersoftware Wordcanbeusedtomakethegraphicsbydrawingtoolsandeditartwordsandmathematicalformulas whichcansatisfytherequirementsofusersaboutthedocumentprocessing Wordprovidesapowerfultabulationfunctionforusers whichcanbeusedtotabulatenotonlyautomatically butalsomanually Word2010alsoincreasesmanynewfunctions suchasonlinereal timecollaborationandversionrecovery MicrosoftExcel MicrosoftExcelisusedtocreatetable calculateandanalyzedata Exceliswidelyusedinmanagement statisticseconomics financeandmanyotherfields Asshowninfigure1 2below Excel2010addssomenewfeatures suchasSparklines Accordingtothedatathatisselectedbytheuser Excel2010willdirectlydrawthelinechart barchartandsooninthecellandequiptheuserwithSparklinesdesignpaneltochooseacustomstyle 11 TextA OfficeSoftware Figure1 1Word2010 Figure1 2Excel2010 12 TextA OfficeSoftware MicrosoftOutlook MicrosoftOutlookcanbeusedtosendandreceivee mails managecontactinformation keepdiaries arrangeschedulesandassigntasks Asshowninfigure1 3below Outlook2010increasessomenewfunctions Forexample theuserscanmanagemultipleemailaccountsinoneplace keepincontactwithsocialandbusinessnetworkandreceivevoicemessagesandfaxesintheinbox MicrosoftPowerPoint MicrosoftPowerPointisasoftwarewhichisusedtomakeandshowslides PowerPointcanbeusedtoproducethepresentationthatcontainsthetext graphics image sound videoclipandothermultimediaelements Theusercanorganizetheinformationintoagroupofillustratedpicture PowerPointisusedtointroducethecompany sproductsanddemonstratetheuser sacademicachievements Asshowninfigure1 4below PowerPoint2010addsnotonlymorespecialeffectsofslidetransitionandimageprocessing butalsomorevideofeatures 13 TextA OfficeSoftware Figure1 3Outlook2010 Figure1 4PowerPoint2010 14 TextA OfficeSoftware MicrosoftOneNote MicrosoftOneNote2010isanoteprogram whichisusedtosearch organize findandsharetheuser snotesandinformation MicrosoftPublisher MicrosoftPublisher2010istheprocessofpublicationproduction whichisusedtoproducepressreleases brochuresandotherprofessionalpublicationsandmarketingmaterials MicrosoftOfficeWebApps MicrosoftOfficeWebAppsprovidesanewstyleofdocumentstoragefortheuser whowilleasyviewandeditthedocumentinthebrowser ByusingOfficeWebApps websitecouldbecomeanewstoragedeviceofofficedocument whichwillmakethedocumenteasiertoaccessandshare 15 TextA OfficeSoftware Notes 1 Theapplicationrangeofofficesoftwareisverywide frommeetingrecordtosocialinvestigation anddigitalofficeisinseparablefromthehelpofit 譯文 辦公軟件的應用范圍很廣 大到社會調查 小到會議記錄 數(shù)字化的辦公都離不開辦公軟件的鼎立協(xié)助 from to 意為 從 到 例如 fromwintertosummer 意為 自冬至夏 beinseparablefrom 意為 離不開 thehelpof 意為 幫助 這些都是慣用短語 2 Wordcanbeusedtomakethegraphicsbydrawingtoolsandeditartwordsandmathematicalformulas whichcansatisfytherequirementsofusersaboutthedocumentprocessing 譯文 Word軟件可以利用繪圖工具進行圖形制作 編輯藝術字 數(shù)學公式 能夠滿足用戶的各種文檔處理要求 beusedtodo 意為 被用于做某事 usedtodo 意為 過去常常做某事 beusedtodoing 意為 習慣于做某事 這里的 to 是介詞 英文中 Word軟件被用于制作圖表 編輯藝術字和數(shù)學公式 翻譯成中文時 可以變成主動語態(tài) 即 Word軟件可以利用繪圖工具進行圖形制作 編輯藝術字和數(shù)學公式 這樣翻譯比較符合我們的習慣 satisfytherequirementsofusers 意為 滿足用戶的需求 這是比較常用的英語短語 16 TextA OfficeSoftware Notes 3 Accordingtothedatathatisselectedbytheuser Excel2010willdirectlydrawthelinechart barchartandsooninthecellandequiptheuserwithSparklinesdesignpaneltochooseacustomstyle 譯文 Excel2010可根據(jù)用戶選擇的數(shù)據(jù) 直接在單元格內畫出折線圖 柱狀圖等 并配有Sparklines設計面板供自定義樣式的選擇 accordingto 意為 根據(jù) to 是介詞 后面加名詞或動名詞 equipsbwithsth 意為 為sb提供或配備sth 與 providesbwithsth 的含義相似 都是為某人提供某物 4 Asshowninfigure1 4below PowerPoint2010addsnotonlymorespecialeffectsofslidetransitionandimageprocessing butalsomorevideofeatures 譯文 PowerPoint2010除了新增更多幻燈片切換特效 圖片處理特效之外 還增加了更多視頻功能 如圖1 4所示 asshowninfigure1 4below 意為 如下圖1 4所示 slidetransition 意為 幻燈片切換 imageprocessing 意為 圖片處理 notonly butalso 意為 不僅 而且 兩個省略號所表示的內容的形式應該是一致的 表示一種遞進關系 17 TextA OfficeSoftware Exercises 1 Translatethefollowingphrases 1 dowordprocessing 2 anewgenerationofofficesoftware 3 manynewfunctions 4 makethedocumenteasiertoaccessandshare 5 keepincontactwith2 Fillintheblankswithappropriatewordsorphrases A simpleB MicrosoftPowerPointC officeautomationD thedevelopmentofE analyzedataF detailed 1 Today sorganizationshaveavarietyofhardwareandsoftwarecomponentsattheirdisposal 2 Withscienceandtechnology theoperationofofficesoftwarehasbeenbecomingmoreandmore butthefunctionhasbeenbecomingmoreandmore 3 MicrosoftExcelisusedtocreatetable calculateand 4 isasoftwarewhichisusedtomakeandshowslides 18 TextA OfficeSoftware Exercises 3 TranslatethefollowingsentencestoEnglish 1 MicrosoftOffice2010是微軟推出的新一代辦公軟件 共有6個版本 2 Outlook軟件可以用來收發(fā)電子郵件 管理聯(lián)系人信息 記日記 安排日程 分配任務 3 PowerPoint可以用于介紹公司的產(chǎn)品 展示自己的學術成果 4 MicrosoftOneNote2010是一種筆記程序 用來搜索 組織 查找和共享用戶的筆記和信息 5 MicrosoftPublisher2010是出版物制作程序 用來制作新聞稿和小冊子等專業(yè)出版物及營銷素材 19 TextB OfficeHardware Witharapidincreaseintheamountofofficeoperations officeautomationhasbecomeanintegratedtechnology Officeautomationhardwaredevicesincludecomputers printers copiers scanners faxmachines recorders routers etc Thecomputerisformedbythemainframeboxandperipheralequipments ThemainframeboxincludesCPU memory mainboard powersupply opticaldriver Peripheralequipmentsincludetheexternalmemory inputandoutputdevices CPU Acentralprocessingunitisthecorepartofanycomputersystem whichismadeupofarithmeticunitandcontrollerunit Asshowninfigure1 5below IntelandAMDaretwomajorcompaniestomanufacturetheCPU 20 TextB OfficeHardware Memory Thememorythatisusedtostoredataandprogramisthestoragecomponentonthemotherboard Asshowninfigure1 6below thememoryisanonlytemporarystoragearea Whentheprocessingiscompleted thememoryiscleared Mainboard Asshowninfigure1 7below themainboardisinstalledinthechassis whichisoneofthemostimportantpartsofthecomputer Themainboardisgenerallyrectangularboard Therearethemaincircuitsystemsofcomputers BIOSchips I Ocontrolchips keyboardandpanelcontrolswitchinterfaces indicatorplugs andothercomponentsonthemainboard Figure1 7Mainboard Figure1 6Memory 21 TextB OfficeHardware Powersupply Asshowninfigure1 8below acomputerpowersupplyisaclosedindependentcomponentwhichisinstalledinthemainframebox Throughaswitchingpowertransformer itconvertsalternatingcurrenttodirectcurrentthatcanbeusedbyavarietyofsystemcomponentswithinthemainframebox Opticaldriver Aopticaldriverisoneofthemostcommonaccessoriesinacomputer asshowninfigure1 9below ItcanbedividedintoCD ROM DVD ROM COMBO ROM CD ROMisreadonlymemory whichisdevelopedbytheCD DAformat DVD ROMisanopticaldriverwhichcanreadDVDdiscs anditiscompatiblewithDVDandCDformats COMBO ROMisamultifunctionalopticalstorageproductwhichisacollectionofCD ROMandDVD ROM Figure1 9OpticalDriver Figure1 8PowerSupply 22 TextB OfficeHardware Externalmemory ExternalmemoryisanimportantmemoryinadditiontoamemoryandCPUcache Thismemorycansavedataevenafterpowerfailure Commonexternalmemoriesareharddisks floppydisks opticaldisks USBdisks asshowninFigure1 10 etc Keyboard Asshowninfigure1 11below thekeyboardisformedbyagroupofswitchmatrixwhichcontainsnumberkeys letterkeys symbolkeys functionkeys controlkeysandsoon Figure1 11Keyboard Figure1 8CommonExternalMemory USBDisk 23 TextB OfficeHardware Mouse Asshowninfigure1 12below themouseisasortofhandheldscreencoordinatepointingdevice Therearetwocommonlyusedtypesofmouse Oneisthemechanicaltype theotheristheopticaltype Scanner Asshowninfigure1 13below scannerisacomputerperipheralequipmentandadigitalinputdevice Thescannercancaptureanimageandconvertitintoasignalwhichacomputercandisplay edit storeandoutput Scannershavemanydifferenttypes suchasdrumscanner flatscanner penscanner filmscannerandsoon Severalimportanttechnicalindicatorsofscannersareresolution grayscale colornumber scanspeedandscanformat Figure1 13Scanner Figure1 12Mouse 24 TextB OfficeHardware Monitor Asshowninfigure1 14below themonitorisanecessarycomputeroutputdevice Twoimportantelementsofthemonitoraresizeandclarity Thesizeisindicatedbythediagonallengthofitsviewingarea Commonsizesare15 17 19and21inches Theclarityisindicatedbyitsresolution whichismeasuredbypixels Thegreatertheresolutionis thebettertheclarityoftheimageis Printer Aprintershowninfigure1 15isoneofcomputeroutputdevices whichisusedtoprinttheresultsofcomputerprocessingonpaper Therearethreeindicatorstomeasuretheperformanceofprinter Theyareprintresolution printspeedandnoise Theprinterhasmanydifferenttypes Accordingtotheprinciple itcanbedividedintothesub hittingstyleandthenon impactstyle Accordingtotheapplication itcanbedividedintodotmatrixprinter colorinkjetprinterandlaserprinter Figure1 15Printer Figure1 14Monitor 25 TextB OfficeHardware Copier Asshowninfigure1 16below acopierisusedtocopythemanuscriptinothertimes zoominorout Itcanbeconnectedtoacomputerthroughtheinterface anditbecomesanimportantpartofofficehardware Theimportantdirectionsofitsdevelopmentaretorealizethemultifunction colorization small scaleandhigh speed Fax Asshowninfigure1 17below afaxisthecommunicationequipment whichconvertsdocuments charts photographsandotherstillimagesintoelectricalsignalswiththescanandopticalconversiontechnologyandtransmitsthesignalstothereceiverinordertocopyintheformofrecord Accordingtotheapplication faxescanbedividedintophotofax paperfax weatherfaxandfilefax Figure1 17Fax Figure1 16Copier 26 TextB OfficeHardware Recorder Asshowninfigure1 18below arecorderuseslaserbeamtoreadthematerial Theuserscanmakeuseoftherecordertorecordcompactdisksinordertoconvenientstorageofdata RecorderscanbedividedintoCDrecordersandDVDrecorders ThecapacityofDVDrecorderismuchlargerthanCDrecorder Router ArouterisanequipmentwhichconnectslocalareanetworkwithwideareanetworkintheInternet asshowninfigure1 19below Itwillautomaticallyselectandsetuparouteaccordingtothecaseofchannel andsendthesignalinthebestpath TherouteristhehuboftheInternet whichhasbeenwidelyappliedtoallfieldsofwork Figure1 19Router Figure1 18Recorder 27 TextB OfficeHardware Notes 1 Acentralprocessingunitisthecorepartofanycomputersystem whichismadeupofarithmeticunitandcontrollerunit 譯文 中央處理器由運算器和控制器組成 是任何計算機系統(tǒng)中必備的核心部件 thecorepartof 意為 核心部件 computersystem 意為 計算機系統(tǒng) bemadeupof 意為 由 組成 是被動語態(tài) 例如 PlatoconjecturedeachoftheseelementstobemadeupofacertainPlatonicsolid theelementofearthwouldbeacube ofairanoctahedron ofwateranicosahedron andoffireatetrahedron 意為 柏拉圖推測每一種元素都是由某些理想立方體組成 地元素是由立方體組成 風元素是一個八面體 水元素是二十面體 火元素是四面體 此例中 bemadeupof 被多次使用 使用時省略了 bemadeup 2 Thememorythatisusedtostoredataandprogramisthestoragecomponentonthemotherboard Whentheprocessingiscomplete thememoryiscleared 譯文 內存是指主板上的存儲部件 用來存放當前正在執(zhí)行的數(shù)據(jù)和程序 程序處理完成后 內存就被清空了 第一句話是由 that 引導的定語從句 修飾前面的先行詞 memory 說明內存是用來存放數(shù)據(jù)和程序的 關系代詞 that 引導的定語從句可以修飾代表人或物地先行詞 但不能用于引導非限定性定語從句 that 可以充當主語 賓語 表語 本句中 that 就是充當主語 本句在翻譯時多補充了修飾語 當前正在執(zhí)行的 主要是為了中文連貫才補充的 也是與第二句話形成了一個呼應 thememoryiscleared 是被動語態(tài) 翻譯時請注意 28 TextB OfficeHardware Notes 3 Asshowninfigure1 7below themainboardisinstalledinthechassis whichisoneofthemostimportantpartsofthecomputer 譯文 如圖1 7所示 主板安裝在機箱內 是微機最重要的部件之一 本句中 which 引導了非限定性定語從句 修飾先行詞 mainboard 作主語 which 引導的定語從句 修飾代表物的先行詞 在從句中可以作主語 賓語 在限定性定語從句中 多數(shù)情況下 which 可以與 that 互換 在非限定性定語從句中 which 引導的句子可以單獨翻譯成一句話 oneofthemostimportantpartsof 意為 最重要的部件之一 是常用的短語 4 Theclarityisindicatedbyitsresolution whichismeasuredbypixels Thegreatertheresolutionis thebettertheclarityoftheimageis 譯文 清晰度由像素來衡量的分辨率表示 分辨率越大圖像越清晰 indicate measure 兩個含義相近的動詞都使用被動語態(tài) 表示 表明 指示 衡量 的意思 which 引導了一個非限定性定語從句 修飾先行詞 resolution 作主語 Thegreater thebetter 意為 越 越 也是常用的句型 例如 Experimentalresultsshowthatthegreaterthetask to machineratiois thebettertheperformanceofQUICKFITisthanMULTIFITandBoundFit andthemakespanofQUICKFITistheleastamongthoseofLPT MULTIFITandBoundFitinmostofcases andQUICKFITissuitableforthelargescaleidenticalscheduling 意為 實驗結果表明 絕大多數(shù)情況下 任務機器比越大 QUICKFIT算法的性能就越優(yōu)于MULTIFIT和BoundFit 總完成時間等于MULTIFIT和BoundFit中的最小者 29 TextB OfficeHardware Exercises 1 Translatethefollowingphrases 1 thecorepartofanycomputersystem 2 themaininputdevice 3 sizeandclarity 4 asshowninfigure1 10 5 inorderto2 Fillintheblankswithappropriatewordsorphrases A numberB memoryC whichD withinE convertsF ThroughG switchmatrixH formed 1 Thecomputerisbythemainframeboxandperipheralequipments 2 aswitchingpowertransformer italternatingcurrenttodirectcurrentthatcanbeusedbyavarietyofsystemcomponentsthemainframebox 3 CD ROMisreadonly isdevelopedbytheCD DAformat 4 Thekeyboardisformedbyagroupofwhichcontainskeys letterkeys symbolkeys functionkeys controlkeysandsoon 30 TextB OfficeHardware Exercises 3 TranslatethefollowingsentencestoEnglish 1 辦公自動化是在辦公業(yè)務量急劇增長的情況下發(fā)展起來的一門綜合性技術 2 辦公自動化的硬件設備主要包括計算機 打印機 復印機 掃描儀 傳真機 刻錄機 路由器等 3 主機箱主要包括CPU 內存 主板 電源 光驅 4 如圖1 5所示 中央處理器主要由Intel和AMD兩大公司生產(chǎn) 5 常見的外儲存器有硬盤 軟盤 光盤 U盤等 31 Practice Part RoleplayConversation1RoseandMikearegoingtoschooltogether Rose Goodmorning Mike Mike Goodmorning Rose Whatobligatorycoursesdoyoutakethisterm Rose TherearecollegeEnglish AdvancedMathematics Physics PE ManagementandAccounting Whataboutyou Mike IhavetotakeAdvancedMathematics CLanguage MicrocomputerInterfaceTechnique ComputerNetworkandDatabaseTechnique Rose Wow youmustgetonwellincomputer CanyouexplainOfficeSoftwaretome Ihavealwaysbeenprettyunclearonthisissue Mike Ofcourse Officesoftwarecanbeusedtodowordprocessingandsimpledatabaseprocessing maketheformandslideshow etc OfficesoftwareincludesMicrosoftOffice KingsoftWPS YOZOsoftOffice RedOffice etc Theapplicationrangeofofficesoftwareisverywide frommeetingrecordtosocialinvestigation Rose Oh Isee Thanksalot 32 Practice Conversation1Rose和Mike正在去上學的路上 Rose 早上好 Mike Mike 早上好 Rose 你這學期的必修課有哪些 Rose 我必須上大學英語 高等數(shù)學 大學物理 體育 管理學 會計學 你呢 Mike 我需要上高等數(shù)學 C語言 單片機接口課程 計算機網(wǎng)絡 數(shù)據(jù)庫 Rose 喔 你計算機一定學得很好 你能給我解釋一下辦公軟件是什么嗎 我一直沒有弄清楚這個問題 Mike 當然可以 辦公軟件是指可以進行文字處理 簡單數(shù)據(jù)庫的處理 表格制作 幻燈片制作等方面工作的軟件 包括微軟Office 金山WPS 永中Office 紅旗Office等 辦公軟件的應用范圍很廣 大到社會調查 小到會議記錄 Rose 哦 我明白了 謝謝 33 Practice Conversation2KateandTomaretalkingabouttheCPUintheclassroom Kate Tom couldyoudomeafavor Tom Sure Kate MissLihastaughtusacentralprocessingunitisthecorepartofacomputersystem ButIstillcan tunderstandthedefinitionoftheCPU Tom ThebrainofacomputeristheCPU Itcontrolsinformation tellsotherpartswhattodoandperformsallthecomputer scalculations Kate Oh thatishowitis Kate和Tom在教室里討論CPU Kate Tom 你能幫我一個忙嗎 Tom 當然可以 Kate 李老師講課時說 CPU是計算機的核心部件 但是我還是不太明白CPU的含義 Tom CPU是計算機的大腦 它控制著信息 告訴其他部件做什么并且執(zhí)行計算機所有的運算 Kate 哦 原來是這樣啊 34 Practice Part writing通過Internet查找資料 借助如 金山詞霸 等電子詞典和輔助翻譯軟件 完成以下技術報告 通過E mail發(fā)送給老師 并附上你收集資料的網(wǎng)址 1 簡述MicrosoftOffice最新版本包含的組件有哪些 請附圖片及簡要描述2 簡述最新的CPU的性能及價格 請附圖片及簡要描述3 簡述最新的打印機的性能及價格 請附圖片及簡要描述 35 ReadingMaterial OfficeAutomation OfficeAutomation OA isanewworkstyle whichcombinesthemodernofficewiththecomputernetwork Officeautomationisanewtechnologyapplicationinthecurrenttechnologicalrevolution whichistheproductoftheinformationsociety Theordinaryroutineofofficeworkismainlyforlargefileprocessing suchasdraftingavarietyoftexts filingdocumentsfromothersareas copyingandprintingfiles etc Therefore theuseofcomputerwordprocessingtechnologytoproduceandstoreallkindsofdocuments theuseofotheradvancedequipmentsuchascopiers faxmachinestocopyandtransferdocuments theuseofcomputernetworktechnologytotransferdocumentsarethebasicfeaturesofofficeautomation Withthedevelopmentof3Gmobilenetwork officeautomationhasenteredthemobileage Mobileofficeautomationsystemisanintegrationof3GMobileTechnology IntelligentMobileTerminal VirtualPrivateNetwork VPN IdentityAuthentication GeographicInformationSystems GIS WebServiceandCommercialIntelligenceTechnology Itcanmigratetheoriginaldocument addressbook schedule filemanagement noticeandotherfunctionsfromOAsystemtomobilephone andthestaffcanconductbusinessanytimeandanywhere 36 ReadingMaterial OfficeAutomation Thesoulofofficeautomationissoftware asshowninfigure1 22 thehardwarecanachievetheenvironmentalguaranteeofofficeautomation Officeautomationischaracterizedbyauthorityandopen Authoritycanensurethesafetyandthelayeroftheinformation whichisthepremiseoftheofficeautomationsystemtostart Openmakestheinformationsharingareality Officeautomationsystemhassixfunctions WordProcessingreferstoinputting editing modifying merging generating storing copyingandprintingthefiles Generallyspeaking wordprocessors intelligentprintersandotherequipmentscancompletethesetasks FileManagementcontainstheregistration filing classification retrievalandsecurityofdocuments whichcanbeachieve