Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
550 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Coding in SQL, Python, VBA, JQuery and OfficeScript using AI tools Part seven of an eight-part series of blogs |
---|
One of the immediate and obvious ways to use AI tools is to boost your productivity as a programmer. This blog shows how you can use ChatGPT 4 and Google's Bard to write programs in SQL, Python, VBA, JQuery and Office Script (probably the 5 languages Wise Owl use most).
|
Finally, I thought I'd test to see whether AI tools can help me write JavaScript (although I've chosen the JQuery derivative language, on the grounds that if a tool can write JQuery, it can certainly write JavaScript too).
This is the one that I think could save me the most time, as I find the syntax of JavaScript/JQuery incredibly fiddly, and I find debugging it more difficult than with other languages too.
ChatGPT came up with a nice concise answer to my question:
I particularly appreciate the notes on how this function works, and even a tip for how to get at my browser's development tools!
By contrast, here's how Bard responded to my question:
A longer answer than for ChatGPT, although as we've seen this doesn't necessarily make it a better one!
What I like about this answer is that it gives me a code snippet to try, so that I can test out whether it's correct. Here's the output this program gave when I tried it on an HTML page:
The first two lines are the original table; the second two lines are the unordered HTML list built up by the Bard function.
i think this is the only example where I prefer the Bard code, although a purist would argue it doesn't quite do what it's asked (the Bard version searches a table for elements with a given class name, whereas the ChatGPT one searches individual cells as requested).
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.