My Day✳All blog articles ↗

Turn a spreadsheet lesson into a practice file you can inspect

Watching an explanation and producing a working result are different activities. Connect them with a clear practice task instead of treating video progress as task completion.

A practical example

Suppose a course lesson explains spreadsheet totals. Keep its continuation timestamp in the study material. Create a separate practice task to build a three-row example, check the total manually and save the file. The file, rather than the watched minutes, provides something concrete to inspect.

Choose the right action

Write the filename, first action and acceptance check in the task note. Select either study or an available end task for the day explicitly. Save the relevant daily result and update the lesson and practice notes separately.

Steps in My Day

  1. Create the course item in Study, enter its lesson and manual timestamp in Where I left off, and save the form.
  2. Create a practice project and a final task with an observable deliverable.
  3. Write the working file, first action and completion check in the task note; optionally set Planned for, then save.
  4. Choose the study item or available final project task for today explicitly.
  5. Save the actual result through the control for the screen you used, then update the lesson and task notes separately as needed.

Check the outcome

Before marking practice finished, open the actual file and compare the total with your manual calculation. My Day does not import video progress, run the spreadsheet or validate its formula for you.

  • Reopen the lesson note and the practice task; check the timestamp, output file and next action.
  • Inspect the actual practice output before marking it finished. Watching a lesson does not automatically complete the project task.