“高等職業(yè)院校單招考試”系列《計算機類職業(yè)技能總復(fù)習(xí)》緊扣最新單招考試說明,是高等職業(yè)院校單招考試計算機專業(yè)考生的復(fù)習(xí)用書。本書系統(tǒng)梳理了高等職業(yè)院校單招考試計算機專業(yè)職業(yè)技能所涉及的知識點,涵蓋了“計算機應(yīng)用基礎(chǔ)”“計算機網(wǎng)絡(luò)技術(shù)”“程序設(shè)計基礎(chǔ)”等專業(yè)核心課程的內(nèi)容。本書突出了創(chuàng)新性,以考綱透識、導(dǎo)圖透示、考點透學(xué)和實戰(zhàn)透練等版塊串聯(lián)知識點,強調(diào)全覆蓋、易理解和高仿真,突出技能訓(xùn)練的有效性和應(yīng)考的針對性及高效性。
吳竹梅,女,高級講師,自參加工作一直任教計算機專業(yè)課。河北省職業(yè)技術(shù)教育研究所編寫的《河北省中等職業(yè)學(xué)校對口升學(xué)考試——計算機類專業(yè)復(fù)習(xí)指南》副主編。輔導(dǎo)學(xué)生參加2005年、2010年省級計算機技能大賽,均獲得了一等獎。
目錄
第一模塊 計算機基礎(chǔ)知識·····················································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)絡(luò)基礎(chǔ)知識····························································95
第三模塊 網(wǎng)絡(luò)基礎(chǔ)知識及因特網(wǎng)的應(yīng)用··································95
第二節(jié) 計算機網(wǎng)絡(luò)協(xié)議和體系結(jié)構(gòu)·················································100
第三節(jié) 計算機網(wǎng)絡(luò)傳輸介質(zhì)與網(wǎng)絡(luò)設(shè)備···········································105
第四節(jié) IP地址與域名··································································112
第五節(jié) 因特網(wǎng)基礎(chǔ)及應(yīng)用·····························································118
第四模塊 文字處理(Word 2010)基本知識··························125
第一節(jié) Word 2010基本操作························································125
第二節(jié) 格式化文檔·····································································136
第三節(jié) 設(shè)置頁面與打印輸出·························································.142
第四節(jié) Word 2010 表格應(yīng)用·······················································.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é) 演示文稿的效果設(shè)置·························································.210
第四節(jié) 演示文稿的放映設(shè)置和作品打包···········································.216
第七模塊 Visual Basic 語言程序設(shè)計基礎(chǔ)······························221
第一節(jié) Visual Basic 概述···························································.221
第二節(jié) Visual Basic 語言基礎(chǔ)·····················································.227
第三節(jié) Visual Basic 程序結(jié)構(gòu)及基本語句·······································.237
第四節(jié) Visual Basic 設(shè)計界面·····················································.248
參考答案··········································································258