模塊 1 信息技術概述························································································.1
知識目標 ···································································································.1
能力目標 ···································································································.1
素質(zhì)目標 ···································································································.1
1.1 認識信息技術 ······················································································.1
1.1.1 信息技術的概念··········································································.1
1.1.2 信息技術的發(fā)展歷程····································································.1
1.1.3 信息技術的意義··········································································.2
1.2 計算機的基礎知識 ················································································.3
1.2.1 計算機的定義·············································································.3
1.2.2 計算機的發(fā)展·············································································.3
1.2.3 計算機的特點·············································································.6
1.2.4 計算機的應用領域·······································································.6
1.2.5 計算機的發(fā)展趨勢·······································································.8
1.2.6 計算機的類型·············································································.8
1.3 計算機系統(tǒng)的組成 ··············································································.10
1.3.1 計算機硬件系統(tǒng)········································································.11
1.3.2 計算機軟件系統(tǒng)········································································.14
1.4 計算機的信息存儲和計數(shù)制 ··································································.15
1.4.1 數(shù)據(jù)的存儲單位········································································.15
1.4.2 計算機的計數(shù)制········································································.16
1.4.3 進位計數(shù)制之間的相互轉(zhuǎn)換·························································.18
1.5 計算機的內(nèi)部信息編碼 ········································································.21
課后練習 ·································································································.22
模塊 2 Windows 10 操作系統(tǒng) ···········································································.24
知識目標 ·································································································.24
能力目標 ·································································································.24
素質(zhì)目標 ·································································································.24
2.1 操作系統(tǒng)概述 ····················································································.24
2.1.1 操作系統(tǒng)的概念········································································.24
2.1.2 操作系統(tǒng)的功能········································································.25
2.1.3 操作系統(tǒng)的分類········································································.25
2.1.4 PC 常用的操作系統(tǒng) ···································································.27
2.2 Windows 10 操作系統(tǒng)中的基本操作 ························································.27
2.2.1 啟動和退出··············································································.27
2.2.2 桌面·······················································································.28
2.2.3 “開始”菜單···········································································.31
2.2.4 任務欄····················································································.32
2.2.5 窗口及對話框···········································································.33
2.3 資源管理器 ·······················································································.35
2.3.1 資源管理器的使用·····································································.35
2.3.2 文件及文件夾的管理··································································.37
2.3.3 磁盤管理·················································································.39
2.4 操作系統(tǒng)的個性化設置 ········································································.41
2.4.1 背景設置·················································································.42
2.4.2 顏色設置·················································································.42
2.4.3 鎖屏界面設置···········································································.42
2.4.4 主題設置·················································································.43
2.4.5 開始設置·················································································.44
2.4.6 任務欄設置··············································································.45
2.5 附件工具的使用 ·················································································.46
2.5.1 記事本····················································································.47
2.5.2 畫圖·······················································································.47
2.5.3 截圖工具·················································································.48
課后練習 ·································································································.48
模塊 3 WPS 文字···························································································.50
知識目標 ·································································································.50
能力目標 ·································································································.50
素質(zhì)目標 ·································································································.50
3.1 制作大美洛陽簡介 ··············································································.50
3.1.1 WPS 2022 的啟動和退出·····························································.51
3.1.2 WPS 2022 文檔操作頁面·····························································.52
3.1.3 新建、保存和打開文檔·······························································.54
3.1.4 文本的錄入與編輯·····································································.56
3.1.5 字符格式化··············································································.61
3.1.6 段落格式化··············································································.63
3.2 制作大美洛陽宣傳冊 ···········································································.69
3.2.1 繪制圖形·················································································.70
3.2.2 插入圖片·················································································.74
3.2.3 插入藝術字··············································································.76
3.2.4 插入文本框··············································································.77
3.3 制作龍門石窟宣傳頁 ···········································································.84
3.3.1 邊框和底紋的設置·····································································.85
3.3.2 項目符號和編號········································································.86
3.3.3 分欄及首字下沉········································································.90
3.3.4 主題、背景和水印·····································································.91
3.3.5 頁面設置·················································································.93
3.3.6 打印預覽及打印········································································.95
3.4 制作個人簡歷 ···················································································.100
3.4.1 插入表格················································································.101
3.4.2 編輯表格················································································.103
3.4.3 設置表格的邊框和底紋·······························································105
3.4.4 表格的自動套用格式··································································106
3.5 畢業(yè)論文排版 ···················································································.111
3.5.1 頁眉、頁腳和頁碼的設置···························································.112
3.5.2 分頁與分節(jié)的設置····································································.115
3.5.3 設置大綱級別··········································································.117
3.5.4 編制目錄和索引·······································································.118
3.5.5 文檔的修訂與批注·····································································120
課后練習 ································································································.123
實訓練習 ································································································.124
模塊 4 WPS 表格··························································································.126
知識目標 ································································································.126
能力目標 ································································································.126
素質(zhì)目標 ································································································.126
4.1 制作學生信息表 ················································································.126
4.1.1 表格的功能和工作界面·······························································127
4.1.2 管理工作簿和工作表··································································128
4.1.3 行和列的基本操作·····································································132
4.1.4 數(shù)據(jù)填充················································································.135
4.2 修飾學生信息表 ················································································.139
4.2.1 格式化工作表··········································································.140
4.2.2 設置有效性數(shù)據(jù)·······································································.144
4.2.3 設置條件格式··········································································.147
4.3 統(tǒng)計學生成績表 ················································································.153
4.3.1 引用單元格·············································································.154
4.3.2 在公式中使用函數(shù)·····································································156
4.4 分析商品銷售表 ················································································.166
4.4.1 數(shù)據(jù)排序················································································.167
4.4.2 數(shù)據(jù)篩選················································································.169
4.4.3 分類匯總················································································.171
4.4.4 數(shù)據(jù)透視表·············································································.172
4.5 制作商品銷售圖表 ·············································································.181
4.5.1 創(chuàng)建圖表················································································.182
4.5.2 修改圖表················································································.184
4.6 打印商品銷售表 ················································································.190
4.6.1 頁面設置················································································.190
4.6.2 工作表的打印··········································································.194
課后練習 ································································································.199
實訓練習 ································································································.200
模塊 5 WPS 演示文稿····················································································.203
知識目標 ································································································.203
能力目標 ································································································.203
素質(zhì)目標 ································································································.203
5.1 制作公司簡介演示文稿 ·······································································.203
5.1.1 演示文稿的基本操作··································································204
5.1.2 幻燈片的基本操作·····································································205
5.1.3 編輯幻燈片·············································································.207
5.1.4 套用模板制作幻燈片··································································208
5.1.5 設置幻燈片母版·······································································.212
5.2 制作洛陽牡丹演示文稿 ·······································································.218
5.2.1 插入圖片················································································.219
5.2.2 插入藝術字·············································································.220
5.2.3 插入形狀和文本框·····································································220
5.2.4 插入表格················································································.220
5.2.5 插入智能圖形··········································································.221
5.2.6 添加音頻················································································.222
5.2.7 插入超鏈接·············································································.224
5.3 豐富洛陽牡丹演示文稿效果 ··································································235
5.3.1 設置幻燈片切換效果··································································235
5.3.2 設置幻燈片中頁面元素的動畫效果 ···············································237
5.3.3 幻燈片的放映設置·····································································238
5.3.4 輸出演示文稿··········································································.239
課后練習 ································································································.246
實訓練習 ································································································.247
模塊 6 網(wǎng)絡與信息安全··················································································.249
知識目標 ································································································.249
能力目標 ································································································.249
素質(zhì)目標 ································································································.249
6.1 認識計算機網(wǎng)絡 ················································································.249
6.1.1 計算機網(wǎng)絡的概念·····································································249
6.1.2 計算機網(wǎng)絡的功能·····································································250
6.1.3 計算機網(wǎng)絡的分類·····································································250
6.2 Internet 相關知識 ···············································································.251
6.2.1 Internet 的相關概念····································································251
6.2.2 TCP/IP···················································································.252
6.2.3 IP 地址和域名 ·········································································.254
6.3 網(wǎng)上沖浪 ·························································································.255
6.3.1 瀏覽器的使用··········································································.255
6.3.2 信息檢索················································································.259
6.3.3 搜索引擎的使用·······································································.260
6.3.4 電子郵箱的注冊及使用·······························································260
6.4 網(wǎng)絡安全基礎 ···················································································.265
6.4.1 計算機病毒與防范·····································································265
6.4.2 防火墻···················································································.266
課后練習 ································································································.268
模塊 7 IT 新技術 ··························································································.269
知識目標 ································································································.269
能力目標 ································································································.269
素質(zhì)目標 ································································································.269
7.1 人工智能 ·························································································.269
7.1.1 人工智能的定義·······································································.269
7.1.2 人工智能的發(fā)展歷程··································································270
7.1.3 人工智能的應用·······································································.270
7.2 物聯(lián)網(wǎng)·····························································································.272
7.2.1 物聯(lián)網(wǎng)的定義··········································································.272
7.2.2 物聯(lián)網(wǎng)的關鍵技術·····································································272
7.2.3 物聯(lián)網(wǎng)的應用··········································································.273
7.3 大數(shù)據(jù)·····························································································.274
7.3.1 大數(shù)據(jù)的定義··········································································.275
7.3.2 大數(shù)據(jù)的發(fā)展歷程·····································································275
7.3.3 大數(shù)據(jù)的意義··········································································.275
7.4 云計算·····························································································.276
7.4.1 云計算的定義··········································································.276
7.4.2 云計算的發(fā)展歷程·····································································277
7.4.3 云計算的特點··········································································.277
7.4.4 云計算的應用··········································································.278
7.5 區(qū)塊鏈·····························································································.279
7.5.1 區(qū)塊鏈概述·············································································.279
7.5.2 區(qū)塊鏈的分類及特點··································································280
7.5.3 區(qū)塊鏈的核心技術·····································································281
7.5.4 區(qū)塊鏈的應用··········································································.282
7.6 虛擬現(xiàn)實 ·························································································.283
7.6.1 虛擬現(xiàn)實技術··········································································.283
7.6.2 虛擬現(xiàn)實技術的應用··································································284
7.7 信創(chuàng)································································································.285
7.7.1 信創(chuàng)概述················································································.285
7.7.2 信創(chuàng)的發(fā)展歷程·······································································.286
課后練習 ································································································.287