Introduction
~context~
( VBA:The Code)

"VBA"
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, including Excel.
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.


Submission 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 listed in the Resources you selected.

25 points

03

Your file must work

-

You must submit a working file,
Your file must be saved as script enabled.

*

04

Create a folder

-

Create a Google drive project folder.

Make the folder sharable with a link for all.

*

05

Submit the assignment

-

Upload your completed assignment to your project  folder. Create and include a word document that explains the tutorial you selected and why.

Submit your link to the folder containing your project and your document to 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.