c++ student::_Excel Student时间追踪器：2011年电子表格日

c++ student::

Happy Spreadsheet Day! I hope you're making time to cell-ebrate this special day. October 17th was selected as Spreadsheet Day, because that is the date that VisiCalc was first shipped.

电子表格日快乐！ 希望您能花些时间在这个特别的日子里尽情放松。 选择10月17日作为Spreadsheet Day ，因为那是VisiCalc首次发货的日期。

学生电子表格 (Student Spreadsheets)

The theme for this year's Spreadsheet Day is Student Spreadsheets. If you have uploaded a free, useful template or add-in for students, or posted a spreadsheet tip, please send me the link so that I can share it.

今年电子表格日的主题是学生电子表格。 如果您为学生上传了免费的，有用的模板或加载项，或发布了电子表格提示，请给我发送链接，以便我分享。

Or, post your links/tips on Twitter, using the hashtag -- #spreadsheetday – so we can find them.

或者，使用#spreadsheetday＃标签在Twitter上发布您的链接/提示，以便我们找到它们。

学生时间追踪器 (Student Time Tracker)

My contribution for Spreadsheet Day 2011 is a Student Time Tracker. You can keep track of your lecture hours, and course work hours, to see what the weekly totals are.

我为2011年电子表格日所做的贡献是一个学生时间跟踪器。 您可以跟踪您的授课时间和课程工作时间，以了解每周的总计。

To start, you'll enter the Semester start and end dates, in the blue cells.

首先，您将在蓝色单元格中输入学期的开始和结束日期。

Next, enter your courses, and the scheduled lecture and lab hours per week.

接下来，输入您的课程以及每周安排的讲座和实验时间。

添加您的作业 (Add Your Assignments)

As the semester progresses, enter any assignments that you get, and other tasks, like preparing for tests and exams. As you finish your assignments, enter the completed date and actual task time. This will help you improve your time estimating skills.

随着学期的进行，输入您获得的所有作业以及其他任务，例如准备考试和考试。 完成作业后，输入完成日期和实际任务时间。 这将帮助您提高时间估计技能。

For large assignments, you can use the Course Work Time Estimator sheet, to enter all the steps, and the time each step should take. Then, add a buffer percentage, to include extra time in the estimate. This will cover all those little things that can go wrong along the way.

对于大型作业，您可以使用“课程工作时间估算器”页面输入所有步骤以及每个步骤应花费的时间。 然后，添加一个缓冲区百分比，以在估算中包括额外的时间。 这将涵盖所有可能在此过程中出错的小事情。

检查每周时间 (Check the Weekly Hours)

On the Weekly Hours Time Estimator sheet, you can see the total hours for each week in the semester. The Work Hours are calculated by using the SUMIF function to get the hours for each week.

在每周工作时间估算器表上，您可以查看该学期中每周的总工作时间。 通过使用SUMIF函数来计算每周的工作时间。

At the top of the sheet, enter your target hours for each week – the maximum number of hours that you want to spend on classes and assignments.

在表格顶部，输入您每周的目标时数-您要在课程和作业上花费的最大时数。

In the screen shot below, the target is 25 hours (that's pretty low!), and there is conditional formatting to highlight weeks that exceed that target. If you see a heavy week coming up, you might be able to complete some assignments early, to ease the workload.

在下面的屏幕快照中，目标是25小时(非常低！)，并且有条件地格式化以突出显示超出该目标的周。 如果您看到一个沉重的一周，您也许可以尽早完成一些任务，以减轻工作量。

下载学生时间追踪器 (Download the Student Time Tracker)

To see how the time tracker works, you can download the Student Time Tracker template. Go to my Sample Files page, and in the Functions section, look for FN0037 - Student Time Tracker

要查看时间跟踪器的工作原理，您可以下载学生时间跟踪器模板。 转到我的示例文件页面 ，然后在“功能”部分中查找FN0037 - Student Time Tracker

The file is in Excel 2007/2010 format, and zipped. There are no macros in the file. ___________________

该文件为Excel 2007/2010格式，并已压缩。 该文件中没有宏。 ___________________

翻译自: https://contexturesblog.com/archives/2011/10/17/excel-student-time-tracker-spreadsheet-day-2011/

c++ student::