書單推薦 新書推薦 |
WPS辦公應(yīng)用(中級)(第2版) 讀者對象:應(yīng)用型本科院校、高等職業(yè)院校、中等職業(yè)院校計算機相關(guān)專業(yè)學(xué)生和老師。 ![]()
本書是《WPS 辦公應(yīng)用職業(yè)技能等級標(biāo)準(zhǔn)》(中級)與全國計算機等級考試(二級)的配套教材,包括長文檔管理、演示文稿制作和表格數(shù)據(jù)運算3大模塊9個項目,深入淺出地介紹了長文檔編輯、排版美化、演示文稿編輯、演示文稿合成、動畫制作、數(shù)據(jù)管理、公式函數(shù)、排序、篩選、分類匯總、合并、透視表等知識點與技能點,同時每個模塊均介紹了WPS AI的相關(guān)功能,跟蹤人工智能大模型技術(shù)的應(yīng)用發(fā)展趨勢,使學(xué)生掌握如何應(yīng)用AI輔助辦公、提高效率。 本書適用應(yīng)用型本科院校、高等職業(yè)院校計算機相關(guān)專業(yè)學(xué)生和老師。
田啟明,溫州職業(yè)技術(shù)學(xué)院人工智能學(xué)院院長,黨總支副書記,二級教授,入選教育部新時代職業(yè)學(xué)校名師培養(yǎng)對象、浙江省"萬人計劃”教學(xué)名師,主持建設(shè)國家雙高專業(yè)群核心專業(yè)、國家骨干專業(yè)、國家教師教學(xué)創(chuàng)新團隊、國家精品課程;主持建設(shè)浙江省第二批雙高專業(yè)群、浙江省優(yōu)勢專業(yè)、浙江省示范實訓(xùn)基地、浙江省精品課程1門;主編11種教材(含國家級規(guī)劃教材2種、工信部規(guī)劃教材1種、省重點教材3種),副主編8種教材;公開發(fā)表論文二十多篇,主持或參與國家、省、市級課題近五十項。曾獲1項國家教學(xué)成果一等獎、3項省教學(xué)成果一等獎、浙江省高校教師教學(xué)軟件評比一等獎、浙江省高?蒲谐晒泉,曾被評為浙江省專業(yè)帶頭人、浙江省首屆教壇新秀、溫州市"師德楷!。
第一篇 長文檔管理
項目 1 公司招聘啟事文檔的制作 ·························································.002 學(xué)習(xí)目標(biāo) ····················································································.002 項目效果 ····················································································.002 知識技能 ····················································································.003 1.1 視圖的應(yīng)用 ··········································································.003 1.3 圖形的繪制 ··········································································.011 1.4 表格樣式的設(shè)置 ····································································.015 1.5 表格工具的應(yīng)用 ····································································.016 主要步驟 ····················································································.017 項目拓展 ····················································································.020 項目小結(jié) ····················································································.021 綜合練習(xí) ····················································································.021 項目 2 網(wǎng)店策劃論文的排版 ·······························································.024 學(xué)習(xí)目標(biāo) ·····················································································.24 項目效果 ·····················································································.24 知識技能 ·····················································································.25 2.1 項目符號和編號的設(shè)置 ····························································.25 2.2 多級編號的應(yīng)用 ·····································································.27 2.3 分隔符的設(shè)置 ········································································.30 2.4 章節(jié)工具的應(yīng)用 ·····································································.31 2.5 多頁表格的設(shè)置 ·····································································.34 2.6 導(dǎo)航窗格的應(yīng)用 ·····································································.35 主要步驟 ·····················································································.36 項目拓展 ·····················································································.38 項目小結(jié) ·····················································································.40 綜合練習(xí) ·····················································································.40 項目 3 網(wǎng)店策劃論文的美化 ·······························································.043 學(xué)習(xí)目標(biāo) ····················································································.043 項目效果 ····················································································.043 知識技能 ····················································································.044 3.1 修改與新建樣式 ····································································.044 3.2 頁眉、頁腳的美化 ·································································.046 3.3 圖表編號和目錄的設(shè)置 ···························································.048 3.4 腳注和尾注的美化 ·································································.049 3.5 超鏈接與交叉引用的使用 ························································.050 3.6 參考文獻與書簽的設(shè)置 ···························································.052 3.7 AI 文檔排版 ·········································································.054 主要步驟 ····················································································.055 項目拓展 ····················································································.057 項目小結(jié) ····················································································.058 綜合練習(xí) ····················································································.059 第二篇 演示文稿制作 項目 4 公司簡介演示文稿的制作 ·························································.064 學(xué)習(xí)目標(biāo) ····················································································.064 項目效果 ····················································································.064 知識技能 ····················································································.065 4.1 圖片的處理 ··········································································.065 4.2 智能圖形的應(yīng)用 ····································································.069 4.3 表格的編輯 ··········································································.070 4.4 公式的編輯 ··········································································.072 4.5 幻燈片對齊工具 ····································································.073 4.6 版式與母版的設(shè)置 ·································································.074 主要步驟 ····················································································.076 項目拓展 ····················································································.083 項目小結(jié) ····················································································.085 綜合練習(xí) ····················································································.086 項目 5 旅游景點演示文稿的制作 ·························································.088 學(xué)習(xí)目標(biāo) ····················································································.088 項目效果 ····················································································.088 知識技能 ····················································································.090 5.1 音頻和視頻的插入 ·································································.090 5.2 音頻和視頻的編輯 ·································································.094 5.3 音頻超鏈接和視頻超鏈接的設(shè)置 ···············································.095 5.4 動作鏈接的設(shè)置 ····································································.099 5.5 演示文稿的合并 ····································································.101 5.6 AI 生成演示文稿 ···································································.102 主要步驟 ····················································································.105 項目拓展 ····················································································.111 項目小結(jié) ····················································································.112 綜合練習(xí) ····················································································.112 項目 6 畢業(yè)紀(jì)念冊演示文稿制作 ·························································.115 學(xué)習(xí)目標(biāo) ····················································································.115 項目效果 ····················································································.115 知識技能 ····················································································.116 6.1 路徑動畫的設(shè)置與應(yīng)用 ···························································.116 6.2 文本動畫的設(shè)置與應(yīng)用 ···························································.118 6.3 “動畫窗格”的應(yīng)用 ······························································.119 6.4 復(fù)雜動畫的制作 ····································································.121 6.5 交互式動畫的制作 ·································································.122 主要步驟 ····················································································.125 項目拓展 ····················································································.130 項目小結(jié) ····················································································.131 綜合練習(xí) ····················································································.132 第三篇 表格數(shù)據(jù)運算 項目 7 學(xué)業(yè)成績統(tǒng)計 ········································································.136 學(xué)習(xí)目標(biāo) ····················································································.136 項目效果 ····················································································.136 知識技能 ····················································································.138 7.1 單元格引用 ··········································································.138 7.2 公式 ···················································································.138 7.3 常用函數(shù) ·············································································.139 7.4 公式套用 ·············································································.141 主要步驟 ····················································································.141 項目拓展 ····················································································.143 項目小結(jié) ····················································································.144 綜合練習(xí) ····················································································.144 項目 8 星級寢室評比 ········································································.146 學(xué)習(xí)目標(biāo) ····················································································.146 項目效果 ····················································································.146 知識技能 ····················································································.146 8.1 數(shù)據(jù)類型 ·············································································.146 8.2 數(shù)據(jù)轉(zhuǎn)換 ·············································································.147 8.3 填充 ···················································································.149 8.4 條件格式 ·············································································.150 8.5 數(shù)據(jù)有效性 ··········································································.151 8.6 下拉列表 ·············································································.152 主要步驟 ····················································································.152 項目拓展 ····················································································.155 項目小結(jié) ····················································································.156 綜合練習(xí) ····················································································.157 項目 9 公益捐贈物品統(tǒng)計 ··································································.159 學(xué)習(xí)目標(biāo) ····················································································.159 項目效果 ····················································································.159 知識技能 ····················································································.161 9.1 排序 ···················································································.161 9.2 篩選 ···················································································.162 9.3 分類匯總 ·············································································.163 9.4 數(shù)據(jù)透視表 ··········································································.164 9.5 圖表 ···················································································.165 9.6 數(shù)據(jù)合并 ·············································································.167 9.7 AI 表格················································································.169 主要步驟 ····················································································.170 項目拓展 ····················································································.173 項目小結(jié) ····················································································.174 綜合練習(xí) ····················································································.174
你還可能感興趣
我要評論
|







