信息技術與計算機應用基礎

項目1 信息技術基礎 ··························································································.1
1.1 認識信息技術 ·····················································································.2
1.1.1 信息技術的概念 ··········································································.2
1.1.2 人類社會發展進程中的信息技術 ·····················································.2
1.1.3 信息技術的意義 ··········································································.3
1.2 計算機的發展 ·····················································································.3
1.2.1 計算機的概念 ·············································································.3
1.2.2 計算機的發展歷程 ·······································································.4
1.2.3 計算機的發展趨勢 ·······································································.6
1.3 計算機的分類、特點與應用領域 ·····························································.9
1.3.1 計算機的分類 ·············································································.9
1.3.2 計算機的特點 ············································································.11
1.3.3 計算機的應用領域 ······································································.11
1.4 計算機系統 ·······················································································.12
1.4.1 計算機硬件系統 ·········································································.13
1.4.2 計算機軟件系統 ·········································································.17
1.4.3 計算機的主要性能指標 ································································.18
1.5 計算機的數據轉換 ··············································································.19
1.5.1 數據的存儲單位 ·········································································.20
1.5.2 計算機的計數制 ·········································································.20
1.5.3 進制數間的相互轉換 ···································································.22
1.6 計算機內部的信息表示與輸入 ·······························································.25
1.6.1 計算機內部信息編碼 ···································································.25
1.6.2 鍵盤 ························································································.27
1.6.3 漢字輸入 ··················································································.29
項目2 Windows 10 操作系統 ············································································.33
2.1 操作系統概述 ····················································································.34
2.1.1 操作系統的功能 ·········································································.34
2.1.2 操作系統的主要特征 ···································································.34
2.1.3 操作系統的分類 ·········································································.35
2.1.4 常用操作系統 ············································································.36
2.2 Windows 10 基礎 ················································································.37
2.2.1 Windows 10 的啟動和關閉 ····························································.37
2.2.2 Windows 10 桌面 ········································································.38
2.2.3 “開始”菜單 ·············································································.41
2.2.4 任務欄 ·····················································································.42
2.2.5 窗口 ························································································.43
2.3 文件及文件夾 ····················································································.45
2.3.1 文件及文件夾的概念 ···································································.46
2.3.2 文件及文件夾的管理 ···································································.46
2.4 Windows 10 控制面板 ··········································································.49
2.4.1 鼠標設置 ··················································································.50
2.4.2 鍵盤設置 ··················································································.51
2.4.3 區域設置 ··················································································.51
2.4.4 程序的安裝和卸載 ······································································.52
2.4.5 用戶賬戶 ··················································································.53
2.5 操作系統的個性化設置 ········································································.54
2.5.1 背景設置 ··················································································.55
2.5.2 顏色設置 ··················································································.55
2.5.3 鎖屏界面設置 ············································································.56
2.5.4 主題設置 ··················································································.58
2.5.5 “開始”菜單設置 ·······································································.58
2.5.6 任務欄設置 ···············································································.60
項目3 文檔處理 ······························································································.62
3.1 文檔的基本操作 ·················································································.63
3.1.1 WPS 2019 的啟動和退出 ······························································.63
3.1.2 WPS 2019 的文檔操作界面 ···························································.63
3.1.3 文檔的基本操作 ·········································································.65
3.1.4 文本的輸入與編輯 ······································································.68
3.1.5 字符格式化 ···············································································.73
3.1.6 段落格式化 ···············································································.75
3.1.7 項目符號與編號 ·········································································.77
3.1.8 分欄及首字下沈 ·········································································.79
3.1.9 頁面設置 ··················································································.79
3.1.10 打印預覽及打印 ·······································································.82
3.2 應用形狀、圖片 ·················································································.89
3.2.1 形狀的插入、編輯和修飾 ·····························································.89
3.2.2 圖片的插入和編輯 ······································································.94
3.2.3 文本框的插入和編輯 ···································································.96
3.2.4 藝術字的創建和編輯 ···································································.97
3.2.5 智能圖形的插入和編輯 ································································.99
3.3 表格的操作和應用 ············································································.104
3.3.1 創建表格 ················································································.104
3.3.2 編輯表格 ················································································.105
3.3.3 設置表格的邊框和底紋 ······························································.107
3.3.4 表格的自動套用格式 ·································································.108
3.3.5 表格的計算與排序功能 ······························································.109
3.4 長文檔排版 ·····················································································.113
3.4.1 頁眉、頁腳的設置 ····································································.113
3.4.2 分頁與分節 ·············································································.117
3.4.3 樣式 ······················································································.118
3.4.4 編制目錄和索引 ·······································································.119
3.4.5 文檔的修訂與批註 ····································································.120
項目4 電子表格處理 ·······················································································.124
4.1 工作簿和工作表的基本操作 ································································.125
4.1.1 表格的功能和工作界面 ······························································.125
4.1.2 管理工作簿 ·············································································.126
4.1.3 管理工作表 ·············································································.126
4.1.4 行和列的基本操作 ····································································.129
4.1.5 數據輸入 ················································································.132
4.1.6 格式化工作表 ··········································································.134
4.2 公式和函數的使用 ············································································.141
4.2.1 單元格引用 ·············································································.141
4.2.2 輸入與編輯公式 ·······································································.142
4.2.3 使用函數 ················································································.142
4.3 數據處理 ························································································.148
4.3.1 數據排序 ················································································.148
4.3.2 數據篩選 ················································································.150
4.3.3 分類匯總 ················································································.152
4.3.4 有效性數據設置 ·······································································.153
4.3.5 條件格式設置 ··········································································.156
4.4 圖表分析數據 ··················································································.161
4.4.1 使用圖表分析數據 ····································································.161
4.4.2 使用數據透視表分析數據 ···························································.165
4.4.3 使用數據透視圖分析數據 ···························································.170
項目5 演示文稿制作 ·······················································································.177
5.1 制作演示文稿 ··················································································.178
5.1.1 演示文稿的基本操作 ·································································.178
5.1.2 幻燈片的基本操作 ····································································.180
5.1.3 插入圖片 ················································································.182
5.1.4 插入藝術字 ·············································································.182
5.1.5 插入形狀和文本框 ····································································.183
5.1.6 插入表格 ················································································.183
5.1.7 插入多媒體 ·············································································.184
5.2 模板及母版的使用 ············································································.193
5.2.1 應用模板制作演示文稿 ······························································.193
5.2.2 制作母版 ················································································.197
5.2.3 使用母版 ················································································.199
5.3 幻燈片動畫設計 ···············································································.207
5.3.1 設置幻燈片的切換動畫 ······························································.207
5.3.2 設置幻燈片的動畫效果 ······························································.209
5.3.3 插入超鏈接 ·············································································.213
5.3.4 添加交互動作 ··········································································.215
5.4 演示文稿放映和導出 ·········································································.219
5.4.1 放映前的準備 ··········································································.219
5.4.2 控制放映流程 ··········································································.222
5.4.3 導出演示文稿 ··········································································.225
項目6 信息檢索 ·····························································································.231
6.1 信息檢索基礎 ··················································································.231
6.1.1 信息檢索的概念 ·······································································.231
6.1.2 信息檢索的要素 ·······································································.232
6.1.3 信息檢索的基本流程 ·································································.233
6.1.4 信息檢索的方法 ·······································································.234
6.2 使用信息檢索 ··················································································.235
6.2.1 搜索引擎的使用 ·······································································.235
6.2.2 期刊數據庫檢索 ·······································································.239
項目7 信息素養與社會責任 ··············································································.242
7.1 信息素養 ························································································.242
7.1.1 信息素養的概念 ·······································································.242
7.1.2 信息素養的主要要素 ·································································.243
7.1.3 提高信息素養的途徑 ·································································.245
7.2 信息技術的發展 ···············································································.245
7.2.1 信息技術的發展史 ····································································.245
7.2.2 樹立正確的職業理念 ·································································.246
7.3 信息倫理與職業行為自律 ···································································.247
7.3.1 信息倫理概述 ··········································································.247
7.3.2 與信息倫理相關的法律法規 ························································.248
7.3.3 職業行為自律 ··········································································.248
項目8 新一代信息技術概述 ··············································································.250
8.1 5G 與物聯網 ····················································································.250
8.1.1 5G 概述 ·················································································.251
8.1.2 5G 網絡與物聯網的融合發展 ······················································.251
8.2 雲計算、大數據與人工智能 ································································.252
8.2.1 雲計算概述 ····8.2.2 大數據概述 ·············································································.254
8.2.3 雲計算、大數據與人工智能的融合發展 ·········································.255
8.3 VR/AR/MR 技術 ···············································································.256
8.3.1 VR 概述 ·················································································.256
8.3.2 AR 概述 ·················································································.257
8.3.3 MR 概述 ················································································.257
8.3.4 VR/AR/MR 技術的應用 ·····························································.258
項目9 信息安全 ·····························································································.261
9.1 信息安全意識 ··················································································.261
9.1.1 建立信息安全意識 ····································································.262
9.1.2 常見的網絡欺詐行為 ·································································.262
9.2 信息安全概述 ··················································································.264
9.2.1 信息安全概念 ··········································································.264
9.2.2 信息安全基本要素 ····································································.265
9.2.3 網絡安全等級保護 ····································································.265
9.3 信息安全常見威脅及防禦 ···································································.266
9.3.1 計算機病毒與防治 ····································································.266
9.3.2 分布式拒絕服務攻擊及防禦 ························································.267
9.3.3 木馬的攻擊與防治 ····································································.268
9.4 信息安全應用 ··················································································.270
9.4.1 使用殺毒軟件查殺計算機病毒 ·····················································.270
9.4.2 防火墻管理 ·············································································.271
項目10 程序設計基礎 ·····················································································.273
10.1 程序設計基礎知識 ···········································································.273
10.1.1 程序設計概述 ········································································.274
10.1.2 程序設計語言 ········································································.274
10.1.3 程序設計過程 ········································································.275
10.2 Python 程序設計 ·············································································.276
10.2.1 Python 語言簡介 ·····································································.276
10.2.2 Python 開發環境配置 ·······························································.277
10.2.3 Python 程序運行方式 ·······························································.281
10.2.4 數據類型 ··············································································.283
10.2.5 常量和變量 ···········································································.285
10.2.6 運算符 ·················································································.288
10.2.7 函數 ····················································································.290
10.2.8 程序結構 ··············································································.295
10.2.9 程序的流程控制 ·····································································.300
10.2.10 錯誤和異常處理 ····································································.301
項目11 人工智能 ···························································································.307
11.1 人工智能基礎知識 ···········································································.307
11.1.1 人工智能的定義 ·····································································.307
11.1.2 人工智能的發展 ·····································································.308
11.2 人工智能核心技術 ···········································································.308
11.2.1 計算機視覺 ···········································································.308
11.2.2 機器學習 ··············································································.309
11.2.3 深度學習 ··············································································.309
11.2.4 自然語言處理 ········································································.309
11.2.5 知識圖譜 ··············································································.310
11.2.6 人機交互 ··············································································.310
11.2.7 自主無人系統技術 ··································································.310
11.3 人工智能技術應用 ···········································································.310