本書是《大學計算機基礎》的配套實驗教材,主要內容包括:Windows 10 操作系統(tǒng)、文字處理軟件、電子表格處理軟件、演示文稿制作軟件、算法與程序設計、計算機網絡與 Internet 等。 本書結合大學計算機基礎課程的基本教學要求,參考了全國計算機等級考試二級 MS Office 考試大綱要求,是為提高讀者的實際操作應用能力而編寫的實驗教材。實驗內容在主教材的基礎上做了進一步擴展,實驗步驟詳細,讀者可自行上機操作。
徐群叁,現任魯東大學信息與電氣工程學院講師。長期從事計算機教育、計算機應用等領域的研究工作。先后在《計算機工程》、《計算機工程與應用》等雜志及各類國際學術會議上發(fā)表論文10余篇。近年來主要參與《計算機系統(tǒng)組裝與維護》、《計算機文化基礎》、《PhotoShop》、《Dreamweaver》等課程的課程建設等工作。
第 1 章 Windows 操作系統(tǒng)············································································1
1.1 實驗 1—Windows 桌面操作 ·····························································1
1.2 實驗 2—Windows 窗口操作和設置 ·················································.12
1.3 實驗 3—Windows 文件操作 ··························································.20
1.4 實驗 4—Windows 設置 ································································.28
習題 ·································································································.35
第 2 章 文字處理軟件 ···············································································.38
2.1 實驗 1—文檔編輯 ······································································.38
2.2 實驗 2—文檔排版 ······································································.46
2.3 實驗 3—表格制作 ······································································.54
2.4 實驗 4—圖文混排 ······································································.58
2.5 實驗 5—郵件合并 ······································································.64
2.6 實驗 6—引用 ············································································.72
2.7 實驗 7—頁面布局 ······································································.76
習題 ·································································································.81
第 3 章 電子表格處理軟件 ·········································································.85
3.1 實驗 1—Excel 基本操作·······························································.85
3.2 實驗 2—公式和函數的使用 ··························································.94
3.3 實驗 3—工作表格式化設置 ··························································101
3.4 實驗 4—Excel 的圖表操作····························································108
3.5 實驗 5—Excel 的數據管理操作······················································115
習題 ·································································································121
第 4 章 演示文稿制作軟件 ·········································································128
4.1 實驗 1—演示文稿的創(chuàng)建與幻燈片管理 ···········································128
4.2 實驗 2—幻燈片的編輯與修飾 ·······················································135
4.3 實驗 3—幻燈片動畫設計與幻燈片切換 ···········································142
4.4 實驗 4—演示文稿的放映與輸出 ····················································149
習題 ·································································································153
第 5 章 算法與程序設計 ············································································155
5.1 實驗 1—配置 Python 開發(fā)環(huán)境 ······················································155
5.2 實驗 2—Python 程序簡單應用·······················································160
5.3 實驗 3—Python 程序綜合應用·······················································163
習題 ·································································································167
第 6 章 計算機網絡與 Internet ····································································171
6.1 實驗 1—組建局域網和接入 Internet ················································171
6.2 實驗 2—發(fā)送和接收郵件 ·····························································179
6.3 實驗 3—Internet 信息檢索 ····························································184
習題 ·································································································191
參考文獻··································································································195