本书是《大学计算机基础》的配套实验教材,主要内容包括:Windows 10 操作系统、文字处理软件、电子表格处理软件、演示文稿制作软件、算法与程序设计、计算机网络与 Internet 等。 本书结合大学计算机基础课程的基本教学要求,参考了全国计算机等级考试二级 MS Office 考试大纲要求,是为提高读者的实际操作应用能力而编写的实验教材。实验内容在主教材的基础上做了进一步扩展,实验步骤详细,读者可自行上机操作。
徐群叁,现任鲁东大学信息与电气工程学院讲师。长期从事计算机教育、计算机应用等领域的研究工作。先后在《计算机工程》、《计算机工程与应用》等杂志及各类国际学术会议上发表论文10余篇。近年来主要参与《计算机系统组装与维护》、《计算机文化基础》、《PhotoShop》、《Dreamweaver》等课程的课程建设等工作。
第 1 章 Windows 操作系统············································································1
1.1 实验 1—Windows 桌面操作 ·····························································1
1.2 实验 2—Windows 窗口操作和设置 ·················································.12
1.3 实验 3—Windows 文件操作 ··························································.20
1.4 实验 4—Windows 设置 ································································.28
习题 ·································································································.35
第 2 章 文字处理软件 ···············································································.38
2.1 实验 1—文档编辑 ······································································.38
2.2 实验 2—文档排版 ······································································.46
2.3 实验 3—表格制作 ······································································.54
2.4 实验 4—图文混排 ······································································.58
2.5 实验 5—邮件合并 ······································································.64
2.6 实验 6—引用 ············································································.72
2.7 实验 7—页面布局 ······································································.76
习题 ·································································································.81
第 3 章 电子表格处理软件 ·········································································.85
3.1 实验 1—Excel 基本操作·······························································.85
3.2 实验 2—公式和函数的使用 ··························································.94
3.3 实验 3—工作表格式化设置 ··························································101
3.4 实验 4—Excel 的图表操作····························································108
3.5 实验 5—Excel 的数据管理操作······················································115
习题 ·································································································121
第 4 章 演示文稿制作软件 ·········································································128
4.1 实验 1—演示文稿的创建与幻灯片管理 ···········································128
4.2 实验 2—幻灯片的编辑与修饰 ·······················································135
4.3 实验 3—幻灯片动画设计与幻灯片切换 ···········································142
4.4 实验 4—演示文稿的放映与输出 ····················································149
习题 ·································································································153
第 5 章 算法与程序设计 ············································································155
5.1 实验 1—配置 Python 开发环境 ······················································155
5.2 实验 2—Python 程序简单应用·······················································160
5.3 实验 3—Python 程序综合应用·······················································163
习题 ·································································································167
第 6 章 计算机网络与 Internet ····································································171
6.1 实验 1—组建局域网和接入 Internet ················································171
6.2 实验 2—发送和接收邮件 ·····························································179
6.3 实验 3—Internet 信息检索 ····························································184
习题 ·································································································191
参考文献··································································································195