Ohio Assessments for Educators: Assessment of Professional Knowledge (grade-band-neutral preparation) study materials
Ohio Assessments for Educators: Assessment of Professional Knowledge (grade-band-neutral preparation) study resources

First-Year Teacher: A Shared Spreadsheet With Sensitive Notes

Ohio Assessments for Educators: Assessment of Professional Knowledge (grade-band-neutral preparation) · Put your knowledge to work in context.

All case studies

First-Year Teacher: A Shared Spreadsheet With Sensitive Notes

Ms. Chen is a first-year seventh-grade teacher. During planning, a veteran colleague sends her a link to a shared spreadsheet labeled 'grade-level concerns.' It already lists 46 students by full name and includes columns for IEP status, counseling visits, behavior incidents, and family phone numbers. The colleague asks Ms. Chen to add notes about a student who has missed six assignments and recently disclosed a conflict at home. The colleague says, 'Everyone on the team can edit it, so we stay coordinated.' Ms. Chen has not received training on the platform, the principal has not approved the spreadsheet, and the district data policy is posted online but she has not read it. Later that day, a parent emails asking which student fought with her child in the cafeteria. Ms. Chen wants to be collaborative and responsive without creating harm.

1. What should Ms. Chen do about the spreadsheet before adding any notes? Explain the reasoning.

Read the worked answer

She should not add notes to the spreadsheet. The sheet contains sensitive information in an open, editable format that the principal has not approved and that she has not been trained to use. Before acting, she should read the district data policy and ask the principal or privacy contact which system is approved. Coordination can be done with de-identified notes or an approved secure platform, limited to staff with a need to know. She should not copy the file to a personal device or share it further. If the existing sheet is unauthorized, she should report it and follow the administrator's direction rather than deleting evidence on her own.

2. How should she respond to the parent's email about the fight?

Read the worked answer

Reply promptly and respectfully without confirming or naming the other student. Do not share discipline information or details about another family. Acknowledge the parent's concern for safety, explain that the administrator or counselor will follow up, and focus on what the school will do to support her child. Avoid promising a particular outcome or secrecy. Document the email and her response. Loop in the administrator or counselor before saying more. This response protects student confidentiality and still gives the parent a clear next step.

3. What should she do if the colleague continues to pressure her?

Read the worked answer

Restate the boundary calmly: she cannot add sensitive notes to an unapproved shared sheet. Offer an approved alternative, such as a de-identified coordination note or a meeting with the administrator. Ask the colleague to check the policy with her, which keeps the conversation collaborative. Document the request and her response. If pressure continues, escalate to the principal or privacy contact. She should not trade confidentiality for collegiality, and she should not try to interpret the policy alone if the district has a designated contact.