關(guān)于我們
書單推薦
新書推薦
|
大學(xué)計算機基礎(chǔ) 讀者對象:本書可作為各高校各專業(yè)“大學(xué)計算機”課程的教材,也可作為計算機應(yīng)用技術(shù)的培訓(xùn)教程和計算機愛好者的參考用書。
本書是根據(jù)教育部高等學(xué)校大學(xué)計算機課程教學(xué)指導(dǎo)委員會關(guān)于高校計算機基礎(chǔ)教學(xué)的有關(guān)精神,同時根據(jù)以應(yīng)用型人才為目標(biāo)的培養(yǎng)方案編寫的。全書共分 8 章,主要內(nèi)容包括:計算機概論、計算思維、 Windows 操作系統(tǒng)、文字處理軟件、電子表格處理軟件、演示文稿制作軟件、算法與程序設(shè)計、計算機網(wǎng)絡(luò)與 Internet 等。 本書結(jié)合大學(xué)計算機基礎(chǔ)課程的基本教學(xué)要求,參考了全國計算機等級考試二級 MS Office 考試大綱要求,兼顧計算機技術(shù)的最新發(fā)展,結(jié)構(gòu)嚴(yán)謹(jǐn),層次清晰,內(nèi)容豐富。為提高讀者的實際操作應(yīng)用能力,本書也有配套的實驗教程。 本書可作為各高校各專業(yè)“大學(xué)計算機”課程的教材,也可作為計算機應(yīng)用技術(shù)的培訓(xùn)教程和計算機愛好者的參考用書。
徐效美,女,現(xiàn)任魯東大學(xué)副教授,長期從事計算機教育、計算機應(yīng)用等領(lǐng)域的研究工作。先后在《計算機應(yīng)用與軟件》、《微計算機應(yīng)用》等期刊及各類學(xué)術(shù)會議上發(fā)表論文多篇,她從事計算機教學(xué)工作10余年,先后講授過《計算機文化基礎(chǔ)》、《數(shù)據(jù)庫應(yīng)用技術(shù)》、《程序設(shè)計基礎(chǔ)C語言》、《程序設(shè)計基礎(chǔ)VB》等課程。
第 1 章 計算機概論 ·····················································································1
1.1 信息與信息系統(tǒng)···············································································1 1.1.1 信息與信息技術(shù) ·····································································1 1.1.2 系統(tǒng)與信息系統(tǒng) ·····································································4 1.1.3 信息經(jīng)濟與信息社會 ······························································.5 1.2 計算機與計算機系統(tǒng)·········································································6 1.2.1 計算機概述 ···········································································6 1.2.2 計算機中的數(shù)制與編碼 ·························································.13 1.2.3 計算機系統(tǒng)的組成 ·······························································.27 1.2.4 微型計算機系統(tǒng) ··································································.32 1.3 計算機信息安全············································································.40 1.3.1 計算機安全概述 ··································································.40 1.3.2 計算機病毒及防治 ·······························································.41 1.3.3 信息安全技術(shù) ·····································································.44 思考題 ······························································································.49 第 2 章 計算思維 ·····················································································.50 2.1 計算思維概論···············································································.50 2.1.1 計算思維的定義 ··································································.50 2.1.2 計算思維的基本內(nèi)容 ····························································.51 2.2 計算思維之抽象············································································.52 2.3 計算思維之自動化·········································································.52 2.4 計算思維的應(yīng)用············································································.53 2.4.1 物聯(lián)網(wǎng) ··············································································.53 2.4.2 云計算 ··············································································.55 2.4.3 大數(shù)據(jù)與數(shù)據(jù)挖掘 ·······························································.57 2.4.4 區(qū)塊鏈 ··············································································.59 2.4.5 人工智能 ···········································································.61 2.4.6 博弈論 ··············································································.65 思考題 ······························································································.68 第 3 章 Windows 操作系統(tǒng)·········································································.69 3.1 操作系統(tǒng)分類···············································································.69 3.1.1 操作系統(tǒng)的類型 ··································································.69 3.1.2 常用操作系統(tǒng)介紹 ·······························································.71 3.2 Windows 10 操作系統(tǒng)入門·······························································.72 3.2.1 Windows 10 的啟動與退出 ·····················································.72 3.2.2 Windows 10 桌面··································································.73 3.2.3 Windows 10 窗口與對話框 ·····················································.79 3.3 Windows 10 文件資源管理器····························································.84 3.3.1 文件資源管理器的打開 ·························································.85 3.3.2 文件和文件夾 ·····································································.85 3.4 Windows 10 設(shè)置···········································································.93 3.4.1 Windows“設(shè)置”窗口的打開···················································.93 3.4.2 設(shè)置外觀和主題 ··································································.94 3.4.3 設(shè)置輸入法 ········································································.97 3.4.4 卸載或更改程序 ··································································.98 3.5 Windows 10 磁盤管理和常用附件······················································.98 3.5.1 Windows 10 磁盤管理 ···························································.98 3.5.2 Windows 10 常用附件 ···························································101 思考題 ······························································································104 第 4 章 文字處理軟件 ···············································································105 4.1 Word 2016 基礎(chǔ) ············································································105 4.1.1 Word 的啟動 ·······································································105 4.1.2 窗口組成 ···········································································106 4.1.3 文檔的基本操作 ··································································108 4.2 文檔的編輯··················································································111 4.2.1 輸入文本 ···········································································111 4.2.2 選定文本 ···········································································113 4.2.3 刪除、復(fù)制和移動文本 ·························································114 4.2.4 插入文件 ···········································································115 4.2.5 查找與替換 ········································································116 4.2.6 撤銷、恢復(fù)和重復(fù) ······························································.119 4.3 文檔的排版··················································································119 4.3.1 字符格式 ···········································································119 4.3.2 段落格式 ···········································································120 4.3.3 樣式 ·················································································121 4.3.4 設(shè)置邊框和底紋 ··································································123 4.3.5 設(shè)置項目符號和編號 ····························································125 4.3.6 常用的特殊格式 ··································································126 4.3.7 復(fù)制格式和清除格式 ····························································127 4.4 表格制作·····················································································127 4.4.1 創(chuàng)建表格 ···········································································127 4.4.2 編輯表格 ···········································································129 4.4.3 格式化表格 ········································································131 4.5 圖文混排·····················································································133 4.5.1 圖片 ·················································································134 4.5.2 形狀 ·················································································138 4.5.3 SmartArt 圖形 ·····································································141 4.5.4 文本框 ··············································································143 4.5.5 藝術(shù)字 ··············································································143 4.5.6 公式 ·················································································144 4.6 郵件合并·····················································································145 4.6.1 郵件合并的幾個基本概念 ······················································145 4.6.2 郵件合并的基本方法 ····························································145 4.6.3 郵件合并規(guī)則 ·····································································147 4.6.4 與郵件合并有關(guān)的域操作 ······················································149 4.7 引用···························································································150 4.7.1 目錄 ·················································································150 4.7.2 腳注和尾注 ········································································151 4.7.3 題注 ·················································································152 4.7.4 索引 ·················································································153 4.7.5 交叉引用 ···········································································154 4.8 頁面布局·····················································································156 4.8.1 頁面設(shè)置 ···········································································156 4.8.2 頁面背景 ···········································································157 4.8.3 封面 ·················································································158 4.8.4 分欄 ·················································································159 4.8.5 分節(jié) ·················································································159 4.8.6 頁碼 ·················································································160 4.8.7 頁眉和頁腳 ········································································161 思考題 ······························································································162 第 5 章 電子表格處理軟件 ·········································································163 5.1 Excel 基礎(chǔ)知識·············································································163 5.1.1 Excel 的基本概念和術(shù)語························································163 5.1.2 Excel 2016 窗口的組成··························································164 5.1.3 工作簿的操作 ·····································································165 5.1.4 工作表的操作 ·····································································166 5.2 工作表數(shù)據(jù)的輸入與編輯································································168 5.2.1 工作表數(shù)據(jù)的輸入 ······························································.168 5.2.2 工作表的編輯 ·····································································173 5.3 公式和函數(shù)··················································································175 5.3.1 公式 ·················································································175 5.3.2 函數(shù) ·················································································178 5.4 格式化工作表···············································································187 5.4.1 設(shè)置單元格格式 ··································································187 5.4.2 調(diào)整工作表的行高和列寬 ······················································189 5.4.3 隱藏行或列 ········································································189 5.4.4 凍結(jié)窗格 ···········································································190 5.4.5 條件格式 ···········································································191 5.4.6 套用表格格式 ·····································································192 5.5 圖表···························································································193 5.5.1 圖表的創(chuàng)建 ········································································193 5.5.2 圖表的編輯與格式化 ····························································195 5.5.3 迷你圖的創(chuàng)建 ·····································································197 5.6 數(shù)據(jù)管理·····················································································198 5.6.1 數(shù)據(jù)清單 ···········································································198 5.6.2 數(shù)據(jù)排序 ···········································································199 5.6.3 數(shù)據(jù)篩選 ···········································································200 5.6.4 分類匯總 ···········································································203 5.6.5 合并計算 ···········································································205 思考題 ······························································································206 第 6 章 演示文稿制作軟件 ·········································································207 6.1 演示文稿的啟動與界面···································································207 6.1.1 PowerPoint 2016 的啟動·························································207 6.1.2 PowerPoint 2016 的窗口和視圖方式··········································207 6.1.3 退出 PowerPoint 2016····························································209 6.2 演示文稿的創(chuàng)建與保存···································································209 6.2.1 新建空白演示文稿 ·······························································210 6.2.2 利用模板或主題快速創(chuàng)建演示文稿 ··········································210 6.2.3 保護(hù)演示文稿 ·····································································210 6.3 幻燈片的編輯···············································································211 6.3.1 創(chuàng)建和組織幻燈片 ······························································.211 6.3.2 編輯幻燈片 ········································································214 6.3.3 格式化幻燈片 ·····································································216 6.3.4 插入對象 ···········································································217 6.3.5 用節(jié)管理幻燈片 ··································································220 6.3.6 幻燈片外觀的修飾 ·······························································221 6.4 幻燈片動畫與切換設(shè)計···································································225 6.4.1 設(shè)置幻燈片動畫效果 ····························································225 6.4.2 設(shè)置幻燈片切換效果 ····························································227 6.4.3 插入超鏈接和動作 ·······························································227 6.5 幻燈片的放映與打包······································································229 6.5.1 設(shè)置幻燈片放映 ··································································229 6.5.2 演示文稿的放映 ··································································230 6.5.3 排練計時 ···········································································231 6.5.4 演示文稿的導(dǎo)出與打印 ·························································231 思考題 ······························································································234 第 7 章 算法與程序設(shè)計 ············································································235 7.1 算法···························································································235 7.1.1 算法的概念 ········································································235 7.1.2 算法的特征 ········································································235 7.1.3 算法的評價 ········································································236 7.1.4 算法的描述 ········································································237 7.1.5 典型算法舉例 ·····································································239 7.2 程序設(shè)計語言···············································································241 7.2.1 程序設(shè)計語言概述 ·······························································241 7.2.2 高級語言程序的執(zhí)行 ····························································242 7.3 程序設(shè)計方法···············································································243 7.3.1 結(jié)構(gòu)化程序設(shè)計方法 ····························································243 7.3.2 面向?qū)ο蟪绦蛟O(shè)計方法 ·························································245 7.4 Python 基礎(chǔ) ·················································································246 7.4.1 Python 簡介 ········································································246 7.4.2 Python 開發(fā)環(huán)境配置 ····························································247 7.4.3 運行 Python 程序 ·································································248 7.4.4 數(shù)據(jù)類型 ···········································································251 7.4.5 常量和變量 ········································································253 7.4.6 運算符與表達(dá)式 ··································································253 7.4.7 流程控制語句 ·····································································255 7.4.8 函數(shù) ·················································································259 7.4.9 復(fù)合數(shù)據(jù)類型 ·····································································259 7.4.10 turtle 庫畫圖······································································261 7.4.11 Python 編程示例·································································263 思考題 ······························································································266 第 8 章 計算機網(wǎng)絡(luò)與 Internet ····································································267 8.1 計算機網(wǎng)絡(luò)概述············································································267 8.1.1 認(rèn)識計算機網(wǎng)絡(luò) ··································································267 8.1.2 計算機網(wǎng)絡(luò)的分類 ·······························································270 8.1.3 計算機網(wǎng)絡(luò)的網(wǎng)絡(luò)協(xié)議與網(wǎng)絡(luò)體系結(jié)構(gòu) ····································273 8.2.4 計算機網(wǎng)絡(luò)的組成 ·······························································277 8.2 Internet 基礎(chǔ)·················································································292 8.2.1 Internet 的起源與發(fā)展 ···························································292 8.2.2 IP 地址與子網(wǎng)掩碼·······························································294 8.2.3 域名地址和 DNS··································································296 8.2.4 接入 Internet 的方式······························································298 8.3 Internet 服務(wù)及應(yīng)用 ·······································································300 8.3.1 WWW 服務(wù) ········································································300 8.3.2 電子郵件服務(wù) ·····································································302 8.3.3 搜索引擎 ···········································································304 8.3.4 圖書館電子資源檢索 ····························································307 思考題 ······························································································310 參考文獻(xiàn)··································································································31
你還可能感興趣
我要評論
|