The Journey of Learning: Five Important points
Alex Mazonowicz is the editorial director of Packt’s Workshop Learning program. Prior to joining Packt, he worked in business intelligence publishing and as a teacher. A strong proponent of life-long learning, here Alex tells us about how challenges in previous projects inspired the teaching methodology in Packt’s Workshop publications.
The issue, according to my managing editor, was that they had to start ingesting the data into a platform, but to do this, all the spreadsheets needed reformatting — all 10,000 spreadsheets.
We had looked at the possibility of getting freelancers to fix the spreadsheets manually, but that would budget at around 30,000 euro for the whole job, and it would take approximately six months. We needed another solution.
They say necessity is the mother of all invention, so it was time to get creative.
I’ve always thought of learning as a journey. At the beginning of the journey, you can’t do something, and at the end, you can. If you don’t understand your starting point, you don’t know which way to go; and if you don’t know your destination, you won’t know the right path to take.
Back to my spreadsheets
Here is the first thing I found out about myself — I learn by doing.
The first thing I did in my journey was to look online for examples of simple scripts that would do easy stuff like copy information from one spreadsheet cell to another or move sheets between folders. Copying this code and seeing all the different things GAS could do taught me form and function. When I say “form,” I mean the all-important syntax of the language, and with “function,” it’s what all the different commands do. I learned syntax typing in the script (or even mistyping!), and function when I saw it work.
In Packt’s Workshop Learning Products, you will be coding from the very beginning. All new concepts are demonstrated in exercises, which our authors have designed to give you as much hands-on experience with the new technology as possible. By regularly and systematically typing out your code either into the integrated coding environments on our websites or onto recommended coding environments such as IDE or Jupyter notebooks, you learn and remember the right syntax and see the tech come alive right from the start.
I do need SOME theory
Of course, we all need some help. Even languages like Python can seem baffling and counter-intuitive at times. Staring at code samples and knowing what they did only got me so far. Concepts that now seem so familiar (such as the difference between a while and if clause, or why I kept adding up 1 and 1 and getting 11) were baffling.
But when I turned to traditional textbooks, I found myself wading through reams of useless information before I got to what I needed, described in obscure ways. Neither memory diagrams nor the history of version development were of much use to me. Just like I don’t much care how my car engine works when I’m driving to the airport, I don’t care what’s going on under the hood in a programming language.
In workshop learning, we have directed all theory to what you need to know to achieve your goals. Theory sections are clear, with ideas covered in a concise but complete way. This brings me to my next point.
Context, not history
The best theory and coding examples I came across were not from academic texts but from the perspective of problem solvers — that is, people who do meaningful work with languages to create things that are used every day. My boss wasn’t going to be happy with an amazingly complicated program that did nothing useful while thousands of spreadsheets went unformatted.
This is why we have worked with industry professionals with real experience to create our Workshop Learning courses. This is also why we have filled them with examples of how technology is used in real life. Realistic examples and scenarios show how the concepts and techniques are applied to create efficient and useful outcomes. And this is what keeps us engaged and learning.
I’m not a parrot
Of course, learning is more than merely copying code. I couldn’t simply look up the exact script needed for my spreadsheet problem. It didn’t matter how many times I showed my boss how to turn all the cells in a sheet rainbow colors, I had a problem to solve. So, I started small. How do I create a script to list 10 sheets and add five rows to each one?
It’s with small challenges like this that we begin to discover how far we’re actually getting in our journey. After all, this is the point of learning a technology. To find solutions to problems. Once I’d solved a small problem, I worked out how to categorize different sheets for different formatting, how to format in bulk, and how to check formatting is correct.
And, of course, you’ll find Packt’s Workshop is full of challenges to help you on your journey. Each unit of learning includes an activity that sets up a real-life scenario with some (minor) hints set out to help you keep your bearings. The activities build on what you know but also allow you to practice problem solving skills. And don’t worry if you get stuck; all solutions are provided in text and video form.
Mixing it up
Once I’d achieved my goal (12,000 spreadsheets reformatted to much relief in the company), I realized two things.
Firstly, there isn’t one magic key to learning. Learning is a multi-faceted activity, including repetition (completing exercises), well-structured theory, real-life context, and of course, setting challenges to build those all-important problem-solving muscles and track my own progress. But not only that, I had learned from a variety of materials. I used text, official documentation, public forums, videos, and guided coding environments all for different parts of my journey.
All of these ideas are present in Packt’s Workshop Learning courses. The books set out a structured, hands-on, guided journey in learning new languages, but they also give access to an online learning environment with videos, coding environments, assessments discussion forums, and customer support. You can even earn a certificate upon completion.
With all the skills I’ve picked up and the lessons I’ve completed, those spreadsheets seem like a distant memory; but like everyone else, I had to start somewhere. So, make that first step and dive into some Workshop Learning, and then when you’re done with one, keep going. This is a long and rewarding journey. Sign up for your workshop here!