|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/using-excel-for-teachers/
课程评论：没有评论
课程名称：使用Excel为教师服务 课程概述：您是一名教师或在教育领域工作吗？想掌握Excel的基础知识吗？是否发现大多数Excel课程面向商业领域而非教育？如果是，这门课程适合您。本课程将帮助您发展以下电子表格技能： - 设置页面或电子表格，包括添加页眉，以便适合打印。 - 输入和格式化数据，以确保呈现清晰且专业。 - 使用函数汇总数据和进行计算。 - 复制、粘贴或移动数据和公式，以避免重复工作。 - 利用条件格式突显特定数据。 - 使用查找表将成绩与分数对应，例如给分。 - 开发策略确保公式正确，通过更改和检查结果，尤其是在复制公式时。 该课程通过一系列项目呈现，项目的复杂性逐步递增，旨在制作教师或其他教育工作者能用得上的电子表格。这些概念可以轻松调整或个性化。课程项目包括： - 创建每周计划表。 - 制定时间表。 - 设置考勤表。 - 使用考勤表中的姓名生成签到表和座位图。 - 使用考勤表中的姓名制作成绩册。
Are you a teacher or do you work in education? Do you wish to master the basics of Excel? Have you only found courses on Excel aimed at people in business rather than education? If so, this is the course for you. The course will enable you to develop the following spreadsheet skills:Set up a page or spreadsheet, including adding a header, so that it is suitable for printing out.Enter and format data, so the presentation is clear and looks professional.Use functions in order to summarise data and make calculations.Copy and paste or move around data and formulas in order to save duplicating work.Use conditional formatting to highlight specific data.Use lookup tables to assign grades to marks, for example.Develop strategies to ensure that formulas are correct, by making changes and checking results, especially after copying formulas from one place to another within a spreadsheet.The course is presented through a series of projects, progressing in complexity, to produce the kinds of spreadsheets that a teacher or other educator should find useful. The ideas can easily be adapted or individualised. The projects are the following:Create a weekly planner.Create a timetable.Set up a register.Use the names from the register to produce a tick list and a seating plan.Use the names from the register to produce a mark book.
