Requirements:

Grasp why you are being asked to prepare a work plan. The purpose of preparing a work plan is to:

Develop your ability to plan work on subsequent assignments involving data analytic work in this course and over your career. Employers have made clear that being able to plan data analytic work is an essential job skill, requiring training and practice. The inability to plan data analytic work will hinder career progression.

Organize and document your work on an assignment to:

Ensure you do all necessary tasks and avoid doing unnecessary ones.

Facilitate your return to work on an assignment after an interruption.

Create visual indicators that show where you are in the work and what work remains to be done.

Begin preparing the Gradebook work plan in Exhibit $1$ by completing the first three blank columns:

What I must do$.$ Dale, more experienced, is helping Pat figure out what to do in the Gradebook spreadsheet. Extract from the conversation all the tasks that Pat must perform in the spreadsheet. You are assuming the role of Pat in completing the spreadsheet.

What I must learn. If you do not immediately know how to perform a task in the spreadsheet, name it$.$ If you know how to do the task, leave the cell blank.

How I can learn it$.$ Although searching online for answers to general questions often works, the efficient way to learn something specific like a new Excel feature is to consult focused resources in an order that minimizes search time: flashcards, built$-$in Excel help, reference manual $($such as recent editions of Walkenbach's Microsoft Excel Bible$),$ and online searching.