|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/create-your-own-gradebook-and-attendance-sheet/
课程评论：没有评论
课程名称：精通教育中的Excel：创建自定义成绩单 课程概述：您是一名教育工作者、培训师、导师或教练，希望优化评分和考勤跟踪过程吗？本课程专为您量身定制，旨在帮助中级Excel用户提高技能，创建个性化的成绩单和考勤表模板。我们建议参加者具备基本的Excel知识。无论您是希望增强现有技能，还是希望进一步提升Excel能力，本课程都非常适合您。 在课程中，我们将逐步指导您创建自定义成绩单和考勤表。想象一下，拥有能够轻松评估学生进展和跟踪考勤的模板将为您节省宝贵的时间和精力。 课程内容包括： - 使用公式 - Excel公式中的操作优先级 - 平均函数的使用 - VLOOKUP函数的使用 - 绝对与相对引用 - COUNT、COUNTA和COUNTIF - 条件格式化 在第一部分，学生将学习如何在十个步骤内创建成绩单，包括创建空白表、输入姓名、排序姓名、输入成绩、计算最终成绩、插入查找表、使用VLOOKUP函数、调整VLOOKUP函数、插入平均值及格式设置。 在第二部分，学生将学习如何在十一条步骤内创建考勤表，包括从成绩单复制姓名、插入日期、为日期着色、插入下拉列表以记录考勤、插入新的计算列以及更多格式设置、统计缺勤天数、计算缺勤百分比、冻结窗格以及对第一周进行考勤和条件格式化。 准备好释放Excel的全部潜力，彻底改变您的评分和考勤跟踪方式了吗？立即报名参加我们的课程，开启一段提升生产力和简化行政任务的变革之旅。不要犹豫，迈出迈向教育中Excel精通的第一步！
Are you an educator, trainer, mentor, or coach looking to streamline your grading and attendance tracking process? Look no further! Our specialized Excel course is tailored specifically for you. Designed to empower intermediate Excel users, this course will elevate your skills and enable you to create personalized grade book and attendance sheet templates.To make the most of this course, it is recommended to have a basic understanding of Excel. Whether you're looking to enhance your existing knowledge or take your Excel proficiency to the next level, this course is ideal for expanding your expertise.Throughout the course, we will guide you through the step-by-step process of creating customized grade books and attendance sheets. Imagine the convenience of having templates that assess your students' progress and track attendance effortlessly on a daily basis. By implementing these templates, you'll save valuable time and effort in the long run.Our comprehensive instruction will ensure that you gain the necessary knowledge and skills to become proficient in Excel. You'll be equipped to design professional-grade books and attendance sheets that meet your specific needs. No prior experience in creating such templates is required - we'll guide you through the process from start to finish.Are you ready to unlock the full potential of Excel and revolutionize your grading and attendance tracking? Enroll in our course today and embark on a transformative journey that will enhance your productivity and simplify your administrative tasks. Don't delay - take the first step towards mastering Excel for educational purposes now.topics: How to use FormulasThe order of operator precedence in Excel FormulasHow to use the Average Function How to use VLOOOKUP FunctionAbsolute and Relative References COUNT, COUNTA, and COUNTIFConditional FormattingIn the first sections students will learn how to create their grade book in ten steps as follows:Creating a blank Sheet Entering Names Sorting Names Entering The Grades Calculating The Final Mark Inserting The LOOK UP Table Inserting VLOOKUP Function Adjusting The V LOOKUP Function Inserting The AverageFormatting In the second sections students will learn how to create their grade book in eleven steps as follows:Copying The Names From GradeBook Inserting Days & Dates(Timeline) Shading Off Days Inserting Drop Down List to Take Attendance Inserting New Calculation Columns Formatting More Formatting Counting Number Of Absent Days Calculating the % of Absence Freezing Panes Taking Attendance of The First Week Conditional Formatting
