Are you struggling to keep up with tracking student work and grading assignments during remote learning? Using Google Sheets can help you stay organized during distance learning!

The color-coded features already applied, allows for you to see patterns of work completed or not completed by each student, assignments that have low turn in rates, students with incomplete or late work.

These Google Sheets allow for complete customization! Set up your sheet by subject, periods, or even by student!

*BOTH OPTIONS ARE SET UP BY SUBJECT (MATH, READING, WRITING, SCIENCE, SOCIAL STUDIES) BUT TABS ARE EASILY EDITABLE FOR YOUR VIRTUAL CLASSROOM NEEDS!

Also included - step-by-step instructions:

• How-to setup auto fill
• How-to color code cells
• How-to add a drop-down list
• How-to add/delete sheets

2 OPTIONS AVAILABLE

OPTION 1:

-5 subjects:

• reading
• writing
• math
• science
• social studies

-Color-coded by week on each sheet.

-Formatted to auto-fill cell to grey when an assignment is tracked and/or graded.

OPTION 2:

-5 subjects:

• reading
• writing
• science
• social studies

-Color coded by week on each sheet.

-Drop down menu in the cell for quick auto-fill grading:

• completed
• incomplete
• late
• re-do
• assistance

-Formatted to auto-fill cell to grey when another option is marked.

★ Any questions? E-mail me! ★ teachingwithapoint@gmail.com

Happy Distance Learning ☺

★ CHECK-OUT MY OTHER DIGITAL RESOURCES ★

Positive Notes Home | Parent Communication | Distance Learning

Virtual Birthday Activity | Distance/Remote Learning

Distance Learning | End of the Year Awards & Certificates

Digital Opinion Writing Unit

Distance Learning Multiplication Task Cards

Student Check-In Google Forms

Digital Number of the Day

Claim, Evidence, and Reasoning

Disney Movie Emoji - Classroom Game

Rebus Puzzle - Classroom Game