|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/everyday-excel-projects
课程评论：没有评论
课程名称：日常Excel，第3部分（项目） 课程概述：“日常Excel，第3部分（项目）”是“日常Excel，第1部分和第2部分”的延续。这是一门以项目为基础的结课课程，您将应用之前学到的知识，解决更复杂且具有开放性的项目。每位学习者需完成3个“热身”项目（从3个中选3个），3个中级项目（从6个中选3个），以及3个主要（更难的）项目（从5个中选3个）。这些项目涵盖了广泛的兴趣和主题领域，预计将吸引不同背景的学习者。 本课程旨在通过项目实操，显著增强Excel工具、技巧和函数在现实项目中的应用能力。 课程大纲： 1. 简介和一般课程信息：本模块包含课程要求、如何获得课程证书及Mac用户相关信息。 2. 热身项目（选择三项）：您需要从5个热身项目中选择3个完成。数学倾向的学习者可以选择“最接近八分之一英寸”和“角落梯子”项目，而非数学倾向的学习者则可能更喜欢“世界银行查询”、“动态温度查询”和“动态摊销表”项目。 3. 中级项目（选择三项）：热身之后，进入更具挑战性的项目！您需要从6个中级项目中选择3个完成。“敏感性分析”和“历史天气查询（A部分）”是较简单的项目，而“动态数据清理”也很接近。 “13号星期五”项目较为有趣，但可能稍具挑战性，“面包店购物清单”和“晚餐报名”项目的难度介于两者之间。 4. 主要项目（选择三项）：本课程的核心在于主要项目！您将实施在“日常Excel”第1部分和第2部分中学到的许多技术和工具。这些项目比中级项目更复杂，不过我会提供很多提示和建议（主要通过视频讲解）来引导您完成这些项目。完成这些项目后，您将拥有一种自豪且值得的成就感！您需完成5个项目中的3个。 5. 荣誉项目：如果您渴望将您的Excel知识应用于更具挑战性的问题，那么荣誉证书适合您！要获得课程证书的荣誉称号，需完成两项项目：“Francesca的法式面包店”和“高顶礼帽整合器”。相关项目描述和要求信息如下，提供的提示和建议较少，因此需要您运用在本课程中学到的知识来解决这些开放性问题！
Name:Introduction and General Course Information
Description:This module contains introductory information regarding the course requirements, how to obtain a Course Certificate, and information for Mac users.
Name:WARM-UP PROJECTS (Choose Three)
Description:For the Warm-Up Projects, you must select three of five projects to complete. If you are more math-inclined, you might appreciate the "Nearest Eighth of an Inch" and "Ladder Around the Corner" projects. If you are not so math-inclined, you will gravitate towards the "World Bank Lookup", "Dynamic Temperature Lookup", and the "Dynamic Amortization Schedule" projects.
Name:INTERMEDIATE PROJECTS (Choose Three)
Description:Now that you're warmed up, let's transition to some more challenging projects! There are six possible projects for you to choose from for the Intermediate Projects, and you must complete three of them. The Sensitivity Analysis and Historical Weather Lookup (Part A) projects are perhaps the easier projects of the bunch, but the Dynamic Data Cleaning is not far behind. The Friday the 13th project is interesting but possibly a tad bit more challenging. The Bakery Shopping List and Dinner Sign-Up projects are somewhere in between. Have fun!
Name:MAIN PROJECTS (Choose Three)
Description:Now for the heart of the course - the Main Projects! You'll implement many of the techniques and tools that you've learned in Parts 1 and 2 of "Everyday Excel". These projects are more involved than the intermediate projects. However, in many cases I provide significant hints and suggestions (mainly through screencasts). Therefore, I "guide" you through these projects. You'll be left with a proud, well-earned sense of accomplishment after having done these projects! There are 5 projects to choose from, and you need to complete 3 of them. Good luck!
Name:For Honors!
Description:Are you chomping at the bit to apply more of your vast Excel knowledge to some more challenging problems?! If so, the Honors Certificate is for you! For Honors distinction on your Course Certificate, complete both projects. The two projects are Francesca's French Bakery and the Top Hat Consolidator. Peruse the information below for project descriptions and requirements for these two projects. Far fewer hints and tips are provided for these projects, so it is up to you to utilize what you've learned in these courses to solve these open-ended problems!
"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways). Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5). The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds. It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.
