See Files for a Word copy of this KB.
How to run an LDA for Face to Face student rev. 8/2023
- Log in to Canvas and the course
- Click PEOPLE on the left-hand course navigation.
- Click ATTENDANCE on the left navigation
- Enter your START date and END date and enter the email address you want the report to be sent. For best results leave SIS Student ID blank. (You can also leave the Start and End dates blank and just run the report.)
- You’ll receive an email in your inbox with a CSV file. The CSV will open in Excel.
- When you open the file, you may notice a few columns contain ##### symbols. In order to view that information, you’ll need to adjust column width, follow these steps:
- Using your mouse, hover over the letter A for the first column. The pointer will change from an arrow to a black down arrow
- Without letting go of the mouse button, drag though the last column then let go of the mouse button. Notice how all columns are highlighted
- Move your mouse between any of the highlighted columns until your pointer becomes a double left/right arrow
- Double-click the double arrow. This will automatically resize all columns to the width of the widest cell in each column
7. With all columns still highlighted, click the Home tab in Excel
8. Under the Styles group, click Format as Table
9. Pick one of the table options from the available options
10. The following dialog box will appear. Make sure you check the box for My table has headers then click OK
11. Click the Filter arrow next to the Student Name header
12. Click the (Select All) checkbox to uncheck all students
13. Scroll down on the list and click the checkbox next to the student’s name then click the OK button
You will now have the records for only that student
14. Click the arrow next to Class Date
15. Click Sort Newest to Oldest then click the OK button
You should now be able to see the last date that the student attended class
