ChatGPT X Excel

Creating Report Comments in Excel

I have always used excel to track and record student attainment. I have even used excel along with mail-merge in word doc to help me write detailed, personalised reports for each and every student. ChatGPT has enabled me to make the report writing process even more time efficient! Here's how:

Key Excel Terminology:

1. Setup

The first thing you will need to do is to create your excel template. The first row will contain each of your headings my suggestions are "Name" for column A row 1, followed by the topics examined in row 1 column b,c,d etc. I like to include an overall result column for myself also. Once you have filled in your template and the first students results now is the time to go to ChatGPT.

2. Go to ChatGPT and Start Simple

Start simple - In plain english explain what it is you would like. Keep it simple to start out. Check that it works and add more with each iteration.

Prompt 1:

ChatGPT Response 1:

Excel Result 1:

3. Give ChatGPT Feedback

Give Feedback - The last iteration didn't quite give me what I wanted. It did not extract the name from the "Name" cell in A2. Tell ChatGPT this and it will make an adjustment accordingly.

Prompt 2:

ChatGPT Response 2:

Excel Result 2:

3. Build Your Formula Slowly

Build Your Formula Slowly - With each iteration add something to the comment. Be sure to check it functions as desired after each adjustment. If it doesn't work go back and tell ChatGPT what didn't work and why. The more information you can provide it, the better.

Prompt 3:

ChatGPT Response 3:

Excel Result 3:

Prompt 4:

ChatGPT Response 4:

Excel Result 4 :

Comment Result:

Harry performed well in Sequences and Series, Complex Numbers. Harry will however need to spend some time revising Calculus, Algebra ahead of the exams in June.

Here you might want to add finishing touches and personal details about the students' efforts etc. ChatGPT can also help you do this.

Prompt 5:

ChatGPT Response 5:

Excel Result 5 :

Comment:

Harry performed well in Sequences and Series, Complex Numbers. Harry will however need to spend some time revising Calculus, Algebra ahead of the exams in June. Overall, Harry's effort in maths this year has been fair. He will need to work to improve this result if he is to receive the result he truly deserves in maths.

Still not getting exactly what you want? Play around with it! ChatGPT is like the tech expert colleague that you would look to for advice.

4. Drag and Drop

Drag and Drop - Once you have perfected your comment, go ahead and input the rest of the student data into the excel spreadsheet and drag and drop the formula into the rows below to apply the same formula to each row! You may find the formula doesn't quite transfer as you wish on the first attempt. Thats ok, go back to ChatGPT and tell it what the problem is like I did here:

Prompt 6:

ChatGPT Response 6:

As you can see this did not actually work for me. It pulled the values from the wrong rows...

Excel Result 6 :

So I went back to ChatGPT and asked it to fix it....

Prompt 7:

ChatGPT Response 7:

Excel Result 7 :

Dont forget to add your personal touch at the end of the

Final Version of Comments:

Harry performed well in Sequences and Series, Complex Numbers. Harry will however need to spend some time revising Calculus, Algebra ahead of the exams in June. Overall, Harry's effort in maths this year has been fair. He will need to work to improve on this result if he is to receive the result he truly deserves in maths. Well done Harry keep up the good work.

Ron performed well in Sequences and Series he will however need to spend some time revising Complex Numbers, Calculus, and Algebra ahead of the exams in June. Overall, Ron's effort in maths this year has been poor. He will need to work to drastically improve on this result if he is to receive the result he truly deserves in maths. Enjoy the summer Ron and come back in ready to turn things around in September!

Hermione performed very well in all topics examined included Sequences and Series, Complex Numbers, Calculus, and Algebra. Overall, Hermione's effort in maths this year has been excellent. She will need to work to maint ain this result if he is to receive the result she truly deserves in maths. Enjoy the well earned break Hermione! See you in September.

Page updated

Google Sites

Report abuse