Build a google sheet or excel sheet that generates a personalized message based on different inputs

Job ID: 35779311

Budget: $30 – $250 USD

The purpose of the sheet is to make it easy for teachers to provide detailed and personalized student comments. The teacher would only be required to fill in a name and use a drop-down box for other criteria (gender, speaking ability, writing ability, listening ability, confidence level, and participation level). Then a text is generated based on the inputs.



Example sentences to be used:

Strong speaking: _____'s speaking ability is strong for his/her age and above average for the level.

Weak speaking: _____'s speaking ability is still improving. I suggest he/she gets more speaking practice at home.

Strong writing: His/her writing has improved quite considerably since he/she joined the course.

Weak writing: His/her writing can still be further improved with practice.



As an example, input:

Name: Bob

Gender: Male

Speaking: Strong

Writing: Weak



Desired output:

Bob's speaking ability is strong for his age and above average for the level. His writing can still be further improved with practice.



All English statements will be provided for the different criteria.