The world runs on code. Most of the devices you use, the food you eat, the medication, or the services provided to you relies on the code to exist in today's world.
By the year 2020, there are projected to be 1.4 million additional programming jobs added to the global economy, while only 0.4 million computer science students will graduate at that time. Notwithstanding any people that make lateral career transitions, this projects a jaw-dropping 1 million more programming jobs than people to fill them.
Can you imagine? Recruiters won't just email you – they're going to start showing up at your house with fruit baskets, offering to dance for you. The demand for code is going to reach a fever pitch with no relief in sight and the pressure on us to crank out code as fast as humanly possible will continue to mount.
In this lesson, we will be learning how we can use code to manipulate Excel or any other application on a Windows machine. We will learn to wield the power of code to our desire. It’s not hard if you want to learn, however, this is not a subject that you can learn with partial attention.
Let's get started learning the power of code. By completing this lesson, you have proven that you can go as far as your attitude will take you into programming. Really think about joining the intro to coding classes next semester and giving yourself a chance as the digital future approaches.
The Code
In the previous assignment, we created a Dashboard in Excel. We now need to learn the language that allows Excel to be programmed to do much more. In this assignment you may choose to complete one of many VBA tutorials. Although this course is Excel, VBA is used on all of Microsoft's Office application.
What Is VBA?
The acronym VBA stands for Visual Basic for Applications. This is essentially an offshoot of the Visual Basic computer language that Microsoft created way back in the '90s that allows Microsoft programs to communicate with each other based on events or actions that take place within those programs. This language is not only used in Office programs like Excel and PowerPoint, but also in programs like NotePad and Paint. Since Microsoft created this language to go along with its own applications, the code is very user intuitive.
Preparation
The preparation section provides you with the elements needed to complete the requirements.
The following steps must be completed to receive the associated points for each step. Any item marked with a * must be completed to receive a score above 0.
01
Choose a Pipeline in the resources
-
Choose one of the VBA tutorials in the resources area.
*
02
Complete the Tutorial
-
Follow the video you selected listed in the resources.
25 points
03
Your file must work
-
You must submit a working file, Your file must be saved as script enabled.
Submit a post on your class's Discord channel explaining why you selected your chosen tutorial.
Take a screenshot of your discord post and submit it with your finished tutorial project file.
*
04
Create a folder
-
Create a Google drive project folder.
Make the folder sharable and unrestricted.
*
05
Submit the assignment
-
Upload your completed assignment to your project folder.
Submit your link to the Canvas
*
Note
Teams
-
If you are a team:
You must include a task list of all the members and the job they completed on the project.
All team members may or may not submit the same folder link.
*
50 Points
Total Points if all the above steps are completed and submitted.
5u
5 unit credits when you receive 100% for all assignments in this pipeline.