How do I create a table to keep track of specific data but also take dates into account?

Hi Septus3,

create a new table with the following columns:

• Date
• Action
• Time period

Then, enter the data for each row, with the date in the first column, the action in the second column, and the time period in the third column.

For example, if you are tracking the following data:

• Action: Read, Write, Code
• Time period: Class 1, Class 2, Class 3
• Date: 2023-08-01, 2023-08-02, 2023-08-03

Your table would look like this:

Once you have entered the data, you can use the spreadsheet program to create a graph to visualize the data. For example, you could create a bar chart or a line chart to show the number of actions taken each day or the number of actions taken each week.

If you want to track the data over an ongoing period of time, you can simply add new rows to the table as new data becomes available.

Here are some additional tips for creating a table to track specific data but also take dates into account:

• Make sure that the date column is formatted correctly. The date column should be formatted as a date, not a text string. This will ensure that the spreadsheet program can correctly calculate the date differences and create accurate graphs.
• Use filters to view the data for specific dates or time periods. For example, you could filter the data to only show the data for a specific class or the data for a specific month.
• Use conditional formatting to highlight specific data points. For example, you could use conditional formatting to highlight all of the rows where the value in the "Action" column is equal to "Code".