图书简介:
第一部分 办公软件高级应用 第 1章 Word高级应用···········································································3 1.1 Word 2010相关知识 ..........................................................................................3 1.1.1视图......................................................................................................3 1.1.2 样式......................................................................................................6 1.1.3 目录......................................................................................................9 1.1.4索引 ...................................................................................................12 1.1.5脚注与尾注........................................................................................16 1.1.6页眉与页脚........................................................................................16 1.1.7题注与交叉引用................................................................................16 1.1.8分节 ...................................................................................................17 1.1.9 域........................................................................................................18 1.2案例一 制作高校录取通知书......................................................................23 1.3 案例二 多人协同编辑文档..........................................................................31 1.4 案例三 索引与书签 .....................................................................................36 1.5 案例四 毕业论文综合排版..........................................................................42 1.6 案例五 Word VBA制作选择题.....................................................................56习题..........................................................................................................................62第 2章 Excel高级应用······································································· 64 2.1 Excel 2010相关知识 ........................................................................................64 2.1.1 单元格引用........................................................................................64 2.1.2 数组公式............................................................................................64 2.1.3 高级筛选............................................................................................65 2.1.4数据透视表与透视图........................................................................66 2.1.5常用函数............................................................................................68 2.2案例一学生成绩统计.................................................................................83 2.3案例二教工信息管理.................................................................................92 2.4案例三个人理财管理...............................................................................101 2.5案例四手机市场调查问卷.......................................................................106 2.6案例五学生成绩管理系统.......................................................................114习题........................................................................................................................123第 3章 PowerPoint高级应用 ·························································· 127 3.1PowerPoint 2010相关知识 .................................................................................127 3.1.1演示文稿和幻灯片..........................................................................127 3.1.2主题..................................................................................................128 3.1.3母版..................................................................................................129 3.1.4动画..................................................................................................129 3.2案例一 宁波东钱湖简介 ................................................................................ 130 3.3案例二 计算机基础考试 ................................................................................ 141习题........................................................................................................................148第二部分 多媒体技术应用 第 4章 多媒体技术基础···································································· 152 4.1多媒体技术的基本概念 ...............................................................................152 4.1.1媒体 .................................................................................................152 4.1.2多媒体技术......................................................................................153 4.2 多媒体计算机系统.......................................................................................154 4.2.1 多媒体硬件系统..............................................................................154 4.2.2 多媒体软件系统...............................................................................155 4.3 多媒体中的媒体元素及特征.......................................................................156 4.4 多媒体数据压缩技术...................................................................................157 4.5 多媒体技术应用软件...................................................................................159 习题........................................................................................................................159第 5章 图像编辑与处理——Photoshop ········································· 161 5.1 图像基础知识 ...............................................................................................161 5.1.1 图形和图像......................................................................................161 5.1.2 图像的基本属性 ..............................................................................163 5.1.3 色彩..................................................................................................163 5.1.4 颜色模式..........................................................................................164 5.1.5 图像数字化 ......................................................................................166 5.1.6 图像文件格式 ..................................................................................167 5.1.7 图像编辑软件..................................................................................169 5.2 Photoshop CS5相关知识..............................................................................169 5.2.1 常用工具...........................................................................................169 5.2.2图层...................................................................................................177 5.2.3 路径...................................................................................................181 5.2.4 图像的变换.......................................................................................183 5.2.5蒙版...................................................................................................186 5.2.6通道...................................................................................................192 5.2.7Photoshop快捷键..............................................................................195 5.3 案例一 快乐小天使...................................................................................196 5.4 案例二 显示器广告...................................................................................204 5.5 案例三 特效边框.......................................................................................207 5.6 案例四 雨景效果.......................................................................................210 5.7 案例五 动态水波效果...............................................................................212 5.8 案例六 渐隐的图像效果...........................................................................219 5.9 案例七 光盘盘贴.......................................................................................221 5.10 案例八 旋转文字 .....................................................................................223 5.11 案例九 汽车海报 ......................................................................................225 5.12 案例十 雄鹰展翅 .....................................................................................228 习题........................................................................................................................230第 6章 动画设计与制作——Flash ················································· 234 6.1 动画基础知识 ...............................................................................................234 6.1.1 动画基本概念..................................................................................234 6.1.2 动画的原理......................................................................................234 6.1.3 动画的分类......................................................................................235 6.1.4 动画制作流程..................................................................................235 6.1.5 动画文件格式 ..................................................................................236 6.1.6 动画制作软件 ..................................................................................237 6.2 Flash CS5.5相关知识....................................................................................237 6.2.1 Flash界面 .........................................................................................237 6.2.2帧.......................................................................................................240 6.2.3图层...................................................................................................242 6.2.4元件...................................................................................................243 6.2.5对象...................................................................................................244 6.2.6 逐帧动画...........................................................................................245 6.2.7 形状补间动画...................................................................................245 6.2.8传统补间动画...................................................................................246 6.2.9补间动画...........................................................................................247 6.2.10引导动画 ........................................................................................248 6.2.11遮罩动画........................................................................................250 6.2.12 Flash快捷键 ...................................................................................252 6.3 案例一旋转的风车...................................................................................253 6.4 案例二动态书写文字...............................................................................258 6.5 案例三图片遮罩效果...............................................................................262 6.6 案例四放大镜...........................................................................................264 6.7 案例五 红星闪闪.......................................................................................269 6.8 案例六月球绕地球转...............................................................................271 6.9 案例七兔子跑步.......................................................................................274 6.10 案例八 移动的球 .....................................................................................278 6.11 案例九 文字特效 ......................................................................................280 6.12 案例十 拼图游戏 .....................................................................................282习题........................................................................................................................287第 7章 音频编辑与处理——Audition ··········································· 291 7.1 音频基础知识................................................................................................291 7.1.1 音频的基本概念..............................................................................291 7.1.2 音频数字化......................................................................................292 7.1.3 音频文件格式..................................................................................293 7.1.4 常用声音编辑软件..........................................................................295 7.2Adobe Audition CS6简介..............................................................................296 7.3案例 古诗录制编辑配乐.............................................................................297 习题........................................................................................................................305第 8章 视频编辑与集成——Premiere ··········································· 307 8.1 视频基础知识 ...............................................................................................307 8.1.1 视频概述..........................................................................................307 8.1.2 视频的采集和处理..........................................................................308 8.1.3 视频信息表示..................................................................................308 8.1.4 视频文件格式..................................................................................309 8.1.5 常用的视频编辑软件......................................................................311 8.2 Adobe Premiere CS6简介 ............................................................................311 8.3 案例一十二生肖视频制作.......................................................................312 8.4 案例二微机组装.......................................................................................322习题........................................................................................................................327参考文献································································································ 329
展开
微软公司的 Office系列软件是目前世界上昀流行的办公自动化软件,在社会各行各业中的应用非常广泛。提高办公自动化软件的应用能力,特别是 Office系列软件的应用能力已成为各类办公人员的迫切需求。多媒体技术的发展日新月异,多媒体技术的应用已经渗入日常生活的各个领域,如图像处理、动画设计、视频点播、视频会议、远程教育和游戏娱乐等。本书可作为“计算机应用基础”后续课程的配套教材,是对前一学期“大学计算机应用基础”课程的拓展和延续,旨在帮助学生进一步提高和扩展计算机理论知识和实践能力。本书以案例及实际应用为主线,将办公软件高级应用与计算机多媒体知识有机地融入实际应用中,结合日常办公软件应用的典型案例进行讲解,举一反三,遵循“计算机以用为本”的理念,有助于学生迅速提升办公软件高级应用水平,从而提高工作效率,也有助于学生发挥创意,灵活有效地处理工作中的问题。本书借鉴 CDIO[构思( Conceive)、设计(Design)、实现( Implement)和运作( Operate)]的相关理念,采用“做中学”“学中做”的教学方法,以学生为主、教师为辅,让学生在体验中自由掌握技术应用,而非教师“满堂灌”的强行灌输方式。此外,本书注重理论与实践相结合,以练为主线,尽量通过一些具体的可操作的案例来说明或示范,也给出了具体的教学方法,使学生在“做中学”,教师在“做中教”。本书共分为两部分,第一部分为办公软件高级应用,包含前 3章内容。第 1章Word高级应用,以 5个案例为基础,介绍 Word 2010软件制作长文档和特殊文档的方法与技巧。第 2章Excel高级应用,以 5个案例为基础,介绍 Excel 2010软件对数据进行管理和分析的方法与技巧。第 3章PowerPoint高级应用,以 2个案例为基础,介绍PowerPoint 2010软件制作演示文稿的方法和技巧。第二部分为多媒体技术应用,包含后 5章内容。第 4章多媒体技术基础,介绍多媒体技术的基本概念等。第 5 章以 10 个案例为基础,介绍Photoshop CS5图像编辑与处理的方法。第 6章以 10个案例为基础,介绍 Flash CS5.5动画设计与制作方法。第 7章以 1个案例为基础,介绍Audition CS6音频编辑与处理方法。第 8章以 2个案例为基础,介绍Premiere Pro CS6视频编辑与集成的方法。通过学习本书,学生能运用 Office办公处理软件编辑各种文档,掌握文本编辑和美化的基本方法与高级技巧;能使用 Photoshop软件进行平面设计,并根据任务需要进行处理与修改,掌握图像制作的基本方法与技巧;能运用 Flash软件绘制矢量图形、制作二维动画,并能运用动画制作方法与技巧进行简单动画作品的创作;能使用 Audition音频编辑软件根据任务需要进行音频裁剪、合成等后期编辑;能运用 Premiere软件编辑视频,制作特技效果和字幕,合成和发布主题视频作品等。
本书得到了宁波大学信息科学与工程学院计算机科学与技术专业的资助,在此对有关专家、教师长期以来对本书的关心、支持与帮助表示衷心的感谢。由于编者水平有限,虽经反复修改,书中难免存在疏忽与不足之处,恳请专家和广大读者批评指正。本书配有案例和素材资料,可供教师与学生参考使用,有需要者请与作者(宁波大学信息学院,邮编 315211,联系。编 者 2018年 12月
展开