“高等职业院校单招考试”系列《计算机类职业技能总复习》紧扣最新单招考试说明,是高等职业院校单招考试计算机专业考生的复习用书。本书系统梳理了高等职业院校单招考试计算机专业职业技能所涉及的知识点,涵盖了“计算机应用基础”“计算机网络技术”“程序设计基础”等专业核心课程的内容。本书突出了创新性,以考纲透识、导图透示、考点透学和实战透练等版块串联知识点,强调全覆盖、易理解和高仿真,突出技能训练的有效性和应考的针对性及高效性。
吴竹梅,女,高级讲师,自参加工作一直任教计算机专业课。河北省职业技术教育研究所编写的《河北省中等职业学校对口升学考试——计算机类专业复习指南》副主编。辅导学生参加2005年、2010年省级计算机技能大赛,均获得了一等奖。
目录
第一模块 计算机基础知识·····················································1
第一节 认识计算机·········································································1
第二节 计算机系统·········································································7
第三节 微型计算机硬件组成····························································19
第四节 计算机中信息的表示····························································34
第五节 计算机安全规范··································································48
第六节 计算机发展新动态·······························································60
第二模块 操作系统的使用···················································71
第一节 操作系统与 Windows 7 概述·················································71
第二节 Windows 7的文件管理·······················································79
第三节 Windows 7的控制面板·······················································88
第一节 计算机网络基础知识····························································95
第三模块 网络基础知识及因特网的应用··································95
第二节 计算机网络协议和体系结构·················································100
第三节 计算机网络传输介质与网络设备···········································105
第四节 IP地址与域名··································································112
第五节 因特网基础及应用·····························································118
第四模块 文字处理(Word 2010)基本知识··························125
第一节 Word 2010基本操作························································125
第二节 格式化文档·····································································136
第三节 设置页面与打印输出·························································.142
第四节 Word 2010 表格应用·······················································.148
第五节 图文混排·······································································.155
第五模块 电子表格(Excel 2010)基本知识··························162
第一节 Excel 2010 的基本知识····················································.162
第二节 Excel 2010 的基本操作····················································.166
第三节 Excel 2010 公式与函数····················································.178
第四节 使用Excel 2010 进行数据处理············································188
第五节 Excel 2010 图表、数据透视表与数据透视图的建立··················.194
第六模块 幻灯片(PowerPoint 2010)基本知识···················200
第一节 PowerPoint 2010 简介···················································.200
第二节 演示文稿的基本操作·························································.204
第三节 演示文稿的效果设置·························································.210
第四节 演示文稿的放映设置和作品打包···········································.216
第七模块 Visual Basic 语言程序设计基础······························221
第一节 Visual Basic 概述···························································.221
第二节 Visual Basic 语言基础·····················································.227
第三节 Visual Basic 程序结构及基本语句·······································.237
第四节 Visual Basic 设计界面·····················································.248
参考答案··········································································258