“高等職業(yè)院校單招考試”系列《計算機類職業(yè)技能總復習》緊扣最新單招考試說明,是高等職業(yè)院校單招考試計算機專業(yè)考生的復習用書。本書系統(tǒng)梳理了高等職業(yè)院校單招考試計算機專業(yè)職業(yè)技能所涉及的知識點,涵蓋了“計算機應用基礎”“計算機網(wǎng)絡技術”“程序設計基礎”等專業(yè)核心課程的內容。本書突出了創(chuàng)新性,以考綱透識、導圖透示、考點透學和實戰(zhàn)透練等版塊串聯(lián)知識點,強調全覆蓋、易理解和高仿真,突出技能訓練的有效性和應考的針對性及高效性。
吳竹梅,女,高級講師,自參加工作一直任教計算機專業(yè)課。河北省職業(yè)技術教育研究所編寫的《河北省中等職業(yè)學校對口升學考試——計算機類專業(yè)復習指南》副主編。輔導學生參加2005年、2010年省級計算機技能大賽,均獲得了一等獎。
目錄
第一模塊 計算機基礎知識·····················································1
第一節(jié) 認識計算機·········································································1
第二節(jié) 計算機系統(tǒng)·········································································7
第三節(jié) 微型計算機硬件組成····························································19
第四節(jié) 計算機中信息的表示····························································34
第五節(jié) 計算機安全規(guī)范··································································48
第六節(jié) 計算機發(fā)展新動態(tài)·······························································60
第二模塊 操作系統(tǒng)的使用···················································71
第一節(jié) 操作系統(tǒng)與 Windows 7 概述·················································71
第二節(jié) Windows 7的文件管理·······················································79
第三節(jié) Windows 7的控制面板·······················································88
第一節(jié) 計算機網(wǎng)絡基礎知識····························································95
第三模塊 網(wǎng)絡基礎知識及因特網(wǎng)的應用··································95
第二節(jié) 計算機網(wǎng)絡協(xié)議和體系結構·················································100
第三節(jié) 計算機網(wǎng)絡傳輸介質與網(wǎng)絡設備···········································105
第四節(jié) IP地址與域名··································································112
第五節(jié) 因特網(wǎng)基礎及應用·····························································118
第四模塊 文字處理(Word 2010)基本知識··························125
第一節(jié) Word 2010基本操作························································125
第二節(jié) 格式化文檔·····································································136
第三節(jié) 設置頁面與打印輸出·························································.142
第四節(jié) Word 2010 表格應用·······················································.148
第五節(jié) 圖文混排·······································································.155
第五模塊 電子表格(Excel 2010)基本知識··························162
第一節(jié) Excel 2010 的基本知識····················································.162
第二節(jié) Excel 2010 的基本操作····················································.166
第三節(jié) Excel 2010 公式與函數(shù)····················································.178
第四節(jié) 使用Excel 2010 進行數(shù)據(jù)處理············································188
第五節(jié) Excel 2010 圖表、數(shù)據(jù)透視表與數(shù)據(jù)透視圖的建立··················.194
第六模塊 幻燈片(PowerPoint 2010)基本知識···················200
第一節(jié) PowerPoint 2010 簡介···················································.200
第二節(jié) 演示文稿的基本操作·························································.204
第三節(jié) 演示文稿的效果設置·························································.210
第四節(jié) 演示文稿的放映設置和作品打包···········································.216
第七模塊 Visual Basic 語言程序設計基礎······························221
第一節(jié) Visual Basic 概述···························································.221
第二節(jié) Visual Basic 語言基礎·····················································.227
第三節(jié) Visual Basic 程序結構及基本語句·······································.237
第四節(jié) Visual Basic 設計界面·····················································.248
參考答案··········································································258