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







