大学计算机基础（第2版） 高等院校计算机类专业"互联网+"创新规划教材 卓海旋 陈凌杰 主编
￥38.20
| 运费： | ¥ 3.00-18.00 |
商品详情
书名：大学计算机基础（第2版）
定价：49.0
ISBN：9787301375327
作者：孙琦 主编
版次：2
出版时间：2026-06
内容提要：
作者简介：
孙琦，副教授，辽宁传媒学院，数字媒体系系主任，多年来一直在高校从事一线教学和管理工作，主持或参与科研课题十余项。发表论文20余篇，主参编教材5部。
目录：
第 1 章 人工智能和计算机基础知识 ··········································································· 1
1.1 人工智能 ········································································································· 2
1.1.1 人工智能概述 ·························································································· 3
1.1.2 国内外人工智能技术发展现状 ····································································· 6
1.1.3 人工智能的发展前景 ················································································· 7
1.2 计算机概论 ······································································································ 9
1.2.1 计算机的发展简史 ·················································································· 10
1.2.2 计算机的特点 ························································································ 13
1.2.3 计算机的应用 ························································································ 13
1.2.4 计算机中的数据表示与编码 ······································································ 15
1.2.5 进位计数制 ··························································································· 16
1.2.6 进制转换 ······························································································ 17
1.2.7 字符编码 ······························································································ 18
1.2.8 案例应用——ASCII 的应用 ······································································· 19
1.3 计算机系统构成 ······························································································ 20
1.3.1 微型计算机系统 ····················································································· 21
1.3.2 案例应用——计算机的选购 ······································································ 23
知识拓展 ·············································································································· 23
本章小结 ·············································································································· 24
关键词 ················································································································· 24
本章习题 ·············································································································· 24
推荐阅读 ·············································································································· 26
第 2 章 Windows 操作系统 ······················································································· 27
2.1 操作系统概述 ································································································· 28
2.1.1 操作系统的概念 ····················································································· 30
2.1.2 操作系统的功能 ····················································································· 30
2.1.3 操作系统的分类 ····················································································· 31
2.1.4 操作系统的安装 ····················································································· 33
2.1.5 认识 Windows 10 操作系统 ······································································· 34
2.2 Windows 10 文件及文件夹的管理 ········································································ 36
2.2.1 键盘的基本操作 ····················································································· 37
2.2.2 认识 Windows 文件 ················································································· 40
2.2.3 浏览计算机中的资源 ··············································································· 41
2.2.4 执行应用程序 ························································································ 41
2.2.5 文件和文件夹的操作 ··············································································· 42
2.2.6 库 ······································································································· 44
2.2.7 案例应用——计算机的文件管理 ································································ 45
2.3 Windows 10 个性化环境设置 ·············································································· 45
2.3.1 个性化的桌面和主题 ··············································································· 47
2.3.2 时间和语言设置 ····················································································· 53
2.3.3 卸载程序 ······························································································ 53
2.3.4 鼠标和键盘设置 ····················································································· 54
2.3.5 用户账户 ······························································································ 56
2.3.6 轻松使用设置 ························································································ 57
2.3.7 文件资源管理器选项设置 ········································································· 58
2.3.8 案例应用——计算机中应用程序的卸载 ······················································· 58
知识拓展 ·············································································································· 59
本章小结 ·············································································································· 59
关键词 ················································································································· 59
本章习题 ·············································································································· 59
推荐阅读 ·············································································································· 61
第 3 章 Word 2016 文字处理软件 ············································································· 62
3.1 Word 简介 ····································································································· 63
3.1.1 Word 的用途 ························································································· 64
3.1.2 Word 的启动与退出 ················································································ 64
3.1.3 Word 的界面布局 ··················································································· 65
3.1.4 案例应用——定制个性化的选项卡 ····························································· 68
3.2 文档的基本操作和文本编辑 ··············································································· 70
3.2.1 文件的基本操作 ····················································································· 71
3.2.2 文档的编辑 ··························································································· 74
3.2.3 布局设置 ······························································································ 82
3.2.4 案例应用——制作一则通知 ······································································ 85
3.3 表格操作 ······································································································· 87
3.3.1 表格的建立与基础操作 ············································································ 88
3.3.2 表格的编辑与格式设置 ············································································ 89
3.3.3 设置表格样式美化表格 ············································································ 91
3.3.4 案例应用——制作一份精美的个人简历 ······················································· 93
3.4 图文混排 ······································································································· 95
3.4.1 绘制与编辑形状 ····················································································· 95
3.4.2 插入和编辑其他对象 ··············································································· 96
3.4.3 图文的排列方式 ····················································································· 98
3.4.4 案例应用——设计一个具有美感的文档版式 ················································ 100
3.5 长文档的编辑与管理 ······················································································· 102
3.5.1 插入题注、脚注和尾注 ··········································································· 103
3.5.2 创建索引与目录 ···················································································· 104
3.5.3 文档的修订与批注 ················································································· 106
3.5.4 打印预览与打印 ···················································································· 107
3.5.5 案例应用——宣传手册的排版设计 ···························································· 109
知识拓展 ············································································································· 111
本章小结 ············································································································· 111
关键词 ················································································································ 111
本章习题 ············································································································· 112
推荐阅读 ············································································································· 113
第 4 章 Excel 2016 电子表格处理软件 ··································································· 114
4.1 工作簿和工作表的基本操作 ·············································································· 115
4.1.1 创建和打开工作簿 ················································································· 116
4.1.2 保存和关闭工作簿 ················································································· 116
4.1.3 保护工作簿 ·························································································· 118
4.1.4 选择工作表 ·························································································· 119
4.1.5 插入与删除工作表 ················································································· 119
4.1.6 移动与复制工作表 ················································································· 120
4.1.7 隐藏与显示工作表 ················································································· 121
4.1.8 冻结工作表窗格 ···················································································· 122
4.2 编辑工作表 ··································································································· 122
4.2.1 数据的输入 ·························································································· 123
4.2.2 数据的填充 ·························································································· 124
4.2.3 单元格的编辑 ······················································································· 126
4.2.4 设置数据条件格式 ················································································· 129
4.2.5 案例应用——编制学生成绩表 ·································································· 130
4.3 公式及函数的应用 ·························································································· 132
4.3.1 输入公式 ····························································································· 133
4.3.2 公式中的运算符 ···················································································· 134
4.3.3 单元格相对地址引用 ·············································································· 135
4.3.4 单元格绝对地址引用 ·············································································· 135
4.3.5 常用函数 ····························································································· 136
4.3.6 案例应用——学生成绩统计分析 ······························································· 137
4.4 数据管理与分析 ····························································································· 139
4.4.1 图表的制作 ·························································································· 140
4.4.2 数据排序 ····························································································· 141
4.4.3 数据筛选 ····························································································· 143
4.4.4 案例应用——快递费用评估 ····································································· 146
知识拓展 ············································································································· 148
本章小结 ············································································································· 149
关键词 ················································································································ 149
本章习题 ············································································································· 149
推荐阅读 ············································································································· 151
第 5 章 PowerPoint 2016 演示文稿软件 ································································· 152
5.1 演示文稿的基本操作 ······················································································· 153
5.1.1 创建和保存演示文稿 ·············································································· 153
5.1.2 打开和关闭演示文稿 ·············································································· 155
5.1.3 保护演示文稿 ······················································································· 155
5.1.4 插入与删除幻灯片 ················································································· 156
5.1.5 移动与复制幻灯片 ················································································· 157
5.1.6 隐藏与显示幻灯片 ················································································· 158
5.2 幻灯片的编辑 ································································································ 158
5.2.1 幻灯片的版式 ······················································································· 159
5.2.2 文本的输入和编辑 ················································································· 160
5.2.3 插入图片和文本框 ················································································· 161
5.2.4 插入艺术字 ·························································································· 162
5.2.5 插入 SmartArt 图形 ················································································ 163
5.2.6 插入表格 ····························································································· 164
5.2.7 插入图表 ····························································································· 165
5.2.8 插入音频文件 ······················································································· 165
5.2.9 插入视频文件 ······················································································· 166
5.2.10 案例应用——公司的宣传文稿 ································································· 167
5.3 幻灯片的特效设计 ·························································································· 169
5.3.1 设置幻灯片背景 ···················································································· 170
5.3.2 使用幻灯片母版 ···················································································· 171
5.3.3 制作动画 ····························································································· 171
5.3.4 案例应用——小学语文教学课件 ······························································· 174
5.4 幻灯片的放映 ································································································ 175
5.4.1 设置放映方式 ······················································································· 176
5.4.2 控制放映过程 ······················································································· 177
5.4.3 设置放映时间 ······················································································· 177
5.4.4 自定义幻灯片放映 ················································································· 178
知识拓展 ············································································································· 179
本章小结 ············································································································· 180
关键词 ················································································································ 180
本章习题 ············································································································· 180
推荐阅读 ············································································································· 181
第 6 章 计算机网络与应用 ······················································································ 182
6.1 计算机网络概述 ····························································································· 183
6.1.1 计算机网络的概念 ················································································· 183
6.1.2 计算机网络的主要功能 ··········································································· 184
6.1.3 计算机网络的分类 ················································································· 184
6.1.4 案例应用——共享打印机 ········································································ 187
6.2 Internet 应用 ·································································································· 188
6.2.1 Internet 接入技术 ··················································································· 189
6.2.2 IP 地址、域名和 URL ············································································· 193
6.2.3 WWW 服务 ·························································································· 195
6.2.4 Internet 信息的查找 ················································································ 196
6.2.5 移动互联网 ·························································································· 199
6.2.6 案例应用——无线网络连接 ····································································· 202
6.3 Web 技术 ······································································································ 204
6.3.1 Web 的特点 ·························································································· 204
6.3.2 Web 前端开发技术 ················································································· 205
6.3.3 案例应用——制作网站主页 ····································································· 208
知识拓展 ············································································································· 209
本章小结 ············································································································· 209
关键词 ················································································································ 210
本章习题 ············································································································· 210
推荐阅读 ············································································································· 211
第 7 章 IT 新技术 ··································································································· 212
7.1 人工智能 ······································································································ 213
7.1.1 人工智能研究的基本内容 ········································································ 214
7.1.2 人工智能的应用 ···················································································· 216
7.1.3 案例应用——AI 助力 PPT 制作 ································································· 217
7.1.4 案例应用——AI 助力 Excel 数据处理 ························································· 218
7.2 物联网 ········································································································· 219
7.2.1 物联网概述 ·························································································· 220
7.2.2 物联网的关键技术 ················································································· 221
7.2.3 物联网的应用 ······················································································· 223
7.2.4 案例应用——无锡车路云一体化 ······························································· 224
7.3 虚拟现实技术 ································································································ 225
7.3.1 虚拟现实技术概述 ················································································· 226
7.3.2 虚拟现实技术的发展历史 ········································································ 229
7.3.3 虚拟现实技术的应用 ·············································································· 230
7.3.4 案例应用——TwinSite 推出交互式 VR 培训 ················································· 231
知识拓展 ············································································································· 232
本章小结 ············································································································· 232
关键词 ················································································································ 232
本章习题 ············································································································· 232
推荐阅读 ············································································································· 233
参考文献 ·················································································································· 234
定价：49.0
ISBN：9787301375327
作者：孙琦 主编
版次：2
出版时间：2026-06
内容提要：
本书立足人工智能赋能教育变革，以通俗易懂的语言、翔实生动的案例，全面介绍了大学计算机基础的相关理论知识与实际应用。全书共分 7 章，内容包括人工智能和计算机基础知识、Windows 操作系统、Word 2016 文字处理软件、Excel 2016 电子表格处理软件、PowerPoint 2016 演示文稿软件、计算机网络与应用，以及 IT 新技术。 本书具有很强的实用性和可操作性，可作为高等院校计算机基础课程的教材，也可供计算机爱好者自学使用。
作者简介：
孙琦，副教授，辽宁传媒学院，数字媒体系系主任，多年来一直在高校从事一线教学和管理工作，主持或参与科研课题十余项。发表论文20余篇，主参编教材5部。
目录：
第 1 章 人工智能和计算机基础知识 ··········································································· 1
1.1 人工智能 ········································································································· 2
1.1.1 人工智能概述 ·························································································· 3
1.1.2 国内外人工智能技术发展现状 ····································································· 6
1.1.3 人工智能的发展前景 ················································································· 7
1.2 计算机概论 ······································································································ 9
1.2.1 计算机的发展简史 ·················································································· 10
1.2.2 计算机的特点 ························································································ 13
1.2.3 计算机的应用 ························································································ 13
1.2.4 计算机中的数据表示与编码 ······································································ 15
1.2.5 进位计数制 ··························································································· 16
1.2.6 进制转换 ······························································································ 17
1.2.7 字符编码 ······························································································ 18
1.2.8 案例应用——ASCII 的应用 ······································································· 19
1.3 计算机系统构成 ······························································································ 20
1.3.1 微型计算机系统 ····················································································· 21
1.3.2 案例应用——计算机的选购 ······································································ 23
知识拓展 ·············································································································· 23
本章小结 ·············································································································· 24
关键词 ················································································································· 24
本章习题 ·············································································································· 24
推荐阅读 ·············································································································· 26
第 2 章 Windows 操作系统 ······················································································· 27
2.1 操作系统概述 ································································································· 28
2.1.1 操作系统的概念 ····················································································· 30
2.1.2 操作系统的功能 ····················································································· 30
2.1.3 操作系统的分类 ····················································································· 31
2.1.4 操作系统的安装 ····················································································· 33
2.1.5 认识 Windows 10 操作系统 ······································································· 34
2.2 Windows 10 文件及文件夹的管理 ········································································ 36
2.2.1 键盘的基本操作 ····················································································· 37
2.2.2 认识 Windows 文件 ················································································· 40
2.2.3 浏览计算机中的资源 ··············································································· 41
2.2.4 执行应用程序 ························································································ 41
2.2.5 文件和文件夹的操作 ··············································································· 42
2.2.6 库 ······································································································· 44
2.2.7 案例应用——计算机的文件管理 ································································ 45
2.3 Windows 10 个性化环境设置 ·············································································· 45
2.3.1 个性化的桌面和主题 ··············································································· 47
2.3.2 时间和语言设置 ····················································································· 53
2.3.3 卸载程序 ······························································································ 53
2.3.4 鼠标和键盘设置 ····················································································· 54
2.3.5 用户账户 ······························································································ 56
2.3.6 轻松使用设置 ························································································ 57
2.3.7 文件资源管理器选项设置 ········································································· 58
2.3.8 案例应用——计算机中应用程序的卸载 ······················································· 58
知识拓展 ·············································································································· 59
本章小结 ·············································································································· 59
关键词 ················································································································· 59
本章习题 ·············································································································· 59
推荐阅读 ·············································································································· 61
第 3 章 Word 2016 文字处理软件 ············································································· 62
3.1 Word 简介 ····································································································· 63
3.1.1 Word 的用途 ························································································· 64
3.1.2 Word 的启动与退出 ················································································ 64
3.1.3 Word 的界面布局 ··················································································· 65
3.1.4 案例应用——定制个性化的选项卡 ····························································· 68
3.2 文档的基本操作和文本编辑 ··············································································· 70
3.2.1 文件的基本操作 ····················································································· 71
3.2.2 文档的编辑 ··························································································· 74
3.2.3 布局设置 ······························································································ 82
3.2.4 案例应用——制作一则通知 ······································································ 85
3.3 表格操作 ······································································································· 87
3.3.1 表格的建立与基础操作 ············································································ 88
3.3.2 表格的编辑与格式设置 ············································································ 89
3.3.3 设置表格样式美化表格 ············································································ 91
3.3.4 案例应用——制作一份精美的个人简历 ······················································· 93
3.4 图文混排 ······································································································· 95
3.4.1 绘制与编辑形状 ····················································································· 95
3.4.2 插入和编辑其他对象 ··············································································· 96
3.4.3 图文的排列方式 ····················································································· 98
3.4.4 案例应用——设计一个具有美感的文档版式 ················································ 100
3.5 长文档的编辑与管理 ······················································································· 102
3.5.1 插入题注、脚注和尾注 ··········································································· 103
3.5.2 创建索引与目录 ···················································································· 104
3.5.3 文档的修订与批注 ················································································· 106
3.5.4 打印预览与打印 ···················································································· 107
3.5.5 案例应用——宣传手册的排版设计 ···························································· 109
知识拓展 ············································································································· 111
本章小结 ············································································································· 111
关键词 ················································································································ 111
本章习题 ············································································································· 112
推荐阅读 ············································································································· 113
第 4 章 Excel 2016 电子表格处理软件 ··································································· 114
4.1 工作簿和工作表的基本操作 ·············································································· 115
4.1.1 创建和打开工作簿 ················································································· 116
4.1.2 保存和关闭工作簿 ················································································· 116
4.1.3 保护工作簿 ·························································································· 118
4.1.4 选择工作表 ·························································································· 119
4.1.5 插入与删除工作表 ················································································· 119
4.1.6 移动与复制工作表 ················································································· 120
4.1.7 隐藏与显示工作表 ················································································· 121
4.1.8 冻结工作表窗格 ···················································································· 122
4.2 编辑工作表 ··································································································· 122
4.2.1 数据的输入 ·························································································· 123
4.2.2 数据的填充 ·························································································· 124
4.2.3 单元格的编辑 ······················································································· 126
4.2.4 设置数据条件格式 ················································································· 129
4.2.5 案例应用——编制学生成绩表 ·································································· 130
4.3 公式及函数的应用 ·························································································· 132
4.3.1 输入公式 ····························································································· 133
4.3.2 公式中的运算符 ···················································································· 134
4.3.3 单元格相对地址引用 ·············································································· 135
4.3.4 单元格绝对地址引用 ·············································································· 135
4.3.5 常用函数 ····························································································· 136
4.3.6 案例应用——学生成绩统计分析 ······························································· 137
4.4 数据管理与分析 ····························································································· 139
4.4.1 图表的制作 ·························································································· 140
4.4.2 数据排序 ····························································································· 141
4.4.3 数据筛选 ····························································································· 143
4.4.4 案例应用——快递费用评估 ····································································· 146
知识拓展 ············································································································· 148
本章小结 ············································································································· 149
关键词 ················································································································ 149
本章习题 ············································································································· 149
推荐阅读 ············································································································· 151
第 5 章 PowerPoint 2016 演示文稿软件 ································································· 152
5.1 演示文稿的基本操作 ······················································································· 153
5.1.1 创建和保存演示文稿 ·············································································· 153
5.1.2 打开和关闭演示文稿 ·············································································· 155
5.1.3 保护演示文稿 ······················································································· 155
5.1.4 插入与删除幻灯片 ················································································· 156
5.1.5 移动与复制幻灯片 ················································································· 157
5.1.6 隐藏与显示幻灯片 ················································································· 158
5.2 幻灯片的编辑 ································································································ 158
5.2.1 幻灯片的版式 ······················································································· 159
5.2.2 文本的输入和编辑 ················································································· 160
5.2.3 插入图片和文本框 ················································································· 161
5.2.4 插入艺术字 ·························································································· 162
5.2.5 插入 SmartArt 图形 ················································································ 163
5.2.6 插入表格 ····························································································· 164
5.2.7 插入图表 ····························································································· 165
5.2.8 插入音频文件 ······················································································· 165
5.2.9 插入视频文件 ······················································································· 166
5.2.10 案例应用——公司的宣传文稿 ································································· 167
5.3 幻灯片的特效设计 ·························································································· 169
5.3.1 设置幻灯片背景 ···················································································· 170
5.3.2 使用幻灯片母版 ···················································································· 171
5.3.3 制作动画 ····························································································· 171
5.3.4 案例应用——小学语文教学课件 ······························································· 174
5.4 幻灯片的放映 ································································································ 175
5.4.1 设置放映方式 ······················································································· 176
5.4.2 控制放映过程 ······················································································· 177
5.4.3 设置放映时间 ······················································································· 177
5.4.4 自定义幻灯片放映 ················································································· 178
知识拓展 ············································································································· 179
本章小结 ············································································································· 180
关键词 ················································································································ 180
本章习题 ············································································································· 180
推荐阅读 ············································································································· 181
第 6 章 计算机网络与应用 ······················································································ 182
6.1 计算机网络概述 ····························································································· 183
6.1.1 计算机网络的概念 ················································································· 183
6.1.2 计算机网络的主要功能 ··········································································· 184
6.1.3 计算机网络的分类 ················································································· 184
6.1.4 案例应用——共享打印机 ········································································ 187
6.2 Internet 应用 ·································································································· 188
6.2.1 Internet 接入技术 ··················································································· 189
6.2.2 IP 地址、域名和 URL ············································································· 193
6.2.3 WWW 服务 ·························································································· 195
6.2.4 Internet 信息的查找 ················································································ 196
6.2.5 移动互联网 ·························································································· 199
6.2.6 案例应用——无线网络连接 ····································································· 202
6.3 Web 技术 ······································································································ 204
6.3.1 Web 的特点 ·························································································· 204
6.3.2 Web 前端开发技术 ················································································· 205
6.3.3 案例应用——制作网站主页 ····································································· 208
知识拓展 ············································································································· 209
本章小结 ············································································································· 209
关键词 ················································································································ 210
本章习题 ············································································································· 210
推荐阅读 ············································································································· 211
第 7 章 IT 新技术 ··································································································· 212
7.1 人工智能 ······································································································ 213
7.1.1 人工智能研究的基本内容 ········································································ 214
7.1.2 人工智能的应用 ···················································································· 216
7.1.3 案例应用——AI 助力 PPT 制作 ································································· 217
7.1.4 案例应用——AI 助力 Excel 数据处理 ························································· 218
7.2 物联网 ········································································································· 219
7.2.1 物联网概述 ·························································································· 220
7.2.2 物联网的关键技术 ················································································· 221
7.2.3 物联网的应用 ······················································································· 223
7.2.4 案例应用——无锡车路云一体化 ······························································· 224
7.3 虚拟现实技术 ································································································ 225
7.3.1 虚拟现实技术概述 ················································································· 226
7.3.2 虚拟现实技术的发展历史 ········································································ 229
7.3.3 虚拟现实技术的应用 ·············································································· 230
7.3.4 案例应用——TwinSite 推出交互式 VR 培训 ················································· 231
知识拓展 ············································································································· 232
本章小结 ············································································································· 232
关键词 ················································································································ 232
本章习题 ············································································································· 232
推荐阅读 ············································································································· 233
参考文献 ·················································································································· 234
- 北京大学出版社旗舰店 （微信公众号认证）
- 【发票】在订单留言电子邮箱、发票抬头、税号、（统一开电子发票，缺一项都不能开票，自行下载打印）
- 扫描二维码，访问我们的微信店铺
- 随时随地的购物、客服咨询、查询订单和物流...
