How to use the AP Computer Science A (CSA) spreadsheet

This guide covers how to use the AP Computer Science A (CSA) spreadsheet as a Lecturer or Recitation teacher.

TAB: Syllabus

For every class, list the date, topic, and notes for recitation teachers. Link the slides and video of each section (from a private YouTube channel).

TAB: Lecture Participation

After every class, evaluate each student on a scale of 1–3. Mark A for absent or T(# min) for tardy.

TAB: Assignments

Free Response and Practice: List and link resources for recitations. Homework: List and link all assignments; enter MC answers by expanding column H. Assessments: Link assessments; enter MC answers by expanding column AS.

TAB: Resources

Available to all: Link resources for students (textbook, CollegeBoard site, cheat sheets). Teacher only: Resources for educators only — not visible to students.

TAB: [Student Name] tab

Homework: See what each student has. Review incorrect problems. Expand column P to see how they answered. Lecture Material: See what the student covered in lecture. Assessments: View assessment scores.

TAB: Recitation Notes

After every class, mark what was covered and evaluate the student on a scale of 1–3.

TAB: Assignments

Free Response, Practice, Homework, and Assessment materials are listed here with answer keys. Student responses are found in their individual tabs.