Google Sheet for Report Card Comments

I need a Google Sheet to streamline report card comments generation. I have predefined comments for the following areas:

Reading
Writing
Math
Student Learner Outcomes (SLOs)

You will also need to incorporate a specific dropdown menu based on an example I will provide.

Ideal Skills and Experience:
- Proficiency in Google Sheets
- Experience with dropdown menus and data validation
- Attention to detail
- Ability to follow examples accurately