Skip to content
You asked, we listened. Applied Digital Skills is now better integrated with Google Classroom. Seamlessly import your classes, student roster, and more.

5. Use Data Validation to Set Status and Task Owners

Playback Speed:
Transcript

In this video, you will use data validation to assign task owners and track the status of each task. Data validation enables you to create a drop-down list of possible choices within a cell. Limiting choices to a list saves time and reduces the possibility of errors when organizing your club.

As your group organizes a club, you will use the drop-down list to track each task and view whether it has been started, is in progress, or is finished. You will also use a drop-down list to assign who is responsible for completing tasks.

To begin, select one group member to add data validation to the status column.

Next, type the text that you want to use to describe the different stages of your project.

Now, use the drop-down list to change the status of tasks. The data validation acts as a checklist to ensure each task is completed on time and nothing is forgotten.

As your group continues to organize your club, update the status of each task.

Data validation can also be used when assigning task owners. The owner is the person responsible for completing each task. Use data validation again, this time listing each group member’s name. Add “All” to the list of names for tasks that everyone will work on, such as brainstorming your club’s topic.

Use the drop-down list to assign an owner to each task.

Now, it’s your turn: Use data validation to update the status of each task. And use data validation to assign an owner to each task.

Instructions

  1. Use data validation to update the status of each task.
  2. Use data validation to assign an owner to each task.