Make your own Ohio scholarship map—and start finding relevant opportunities
For the first of many Ohio Tech Day celebrations, Joot partnered together with OhioX and Dolr to create this coding tutorial. Join us as we walk through the fun and free process of making a customized scholarship map with data from DataOhio and Julia open-source software.
Ohio Tech Day scholarship map
Pro Tip
Your finished map will look like this. Move around and zoom in or out of the map to find what you're looking for. Click the circles for more information about the various scholarship providers. Have fun—and make your own!
How does this work?
 Download & Install: Use the provided links to get the apps and files you need to follow along.
 Do Some Coding: Learn some coding basics as you complete a quick and easy lesson.
 Make Your Map: Create your very own map of relevant scholarship opportunities throughout Ohio.
What's Julia and what's it good for?
Julia is a programming language often used for scientific computation. Whoa, hold on. That sounds pretty complicated. But like many tools, you can dive deep or skim the surface to get what you need. Plus, it’s free, so there’s no harm in trying it out. Here are just a few things you can do with Julia.
 Analyze data
 Compare & contrast data
 Sort & filter data
 Manipulate & transform data
 Visualize data
 Map data
 Use data to understand preferences
 Use data to make predictions
 Use data to track trends
Let's get started!
Download & install Julia
Let's begin by downloading Julia—a free programming language. This download creates the files needed to run Julia. Tap this button and follow the instructions for your system. No need to change any settings in the downloader.
Download & install Visual Studio Code
Visual Studio Code is a free interface that allows you to write Julia scripts. Now that you've downloaded and installed Julia, tap this button and download Visual Studio Code. You can read the page that opens for a quick intro to using Julia in Visual Studio Code and then use the Download link in the top navigation to get Visual Studio Code for your system. Follow all the prompts and leave the settings as they are.
Download the dataset
Now you're ready to download the data needed to build your map. This tutorial uses a dataset provided by our friends at DataOhio. Tap this button to go to the search screen shown here. Type "scholarship" in the search bar and click "Filter." Then select "Ohio Scholarship Provider Interactive Directory" to download and save a CSV file to the same location as your R downloads. Name the file "scholarship_providers.csv."
Pro Tip
Check out this handy reference for mapping data in Julia. The various examples give helpful advice on building and customizing your map to make it your very own.
Open Visual Studio Code
Go ahead and open the Visual Studio Code app you downloaded earlier. Here's the intro screen of the interface.
Open Visual Studio Code
Create a Julia script
After the interface loads, you're ready to create a new Julia script for your code. Go to File → New File, as shown here.
Create a Julia script
Add basic info to your script
An untitled window will appear next. Here, you can add the script's author (your name), date, and title. Be sure to use a hash symbol (#) before each entry to indicate these are comments and not code.
Pro Tip
Clearly commenting your code is considered good coding etiquette. Remember: you're part of a coding community! Pay it forward and help others follow along. And be sure to give credit to any sources you consult when writing code.
Add info to your Julia script
Save your script
Now is a good time to save your script. Go to File → Save As and select the same location where you saved your scholarship data. Name your script (we chose "julia-map-scholarships.jl") and click "Save."
Save your Julia script
Open a terminal window
Next up: open a terminal window so you can install the packages you'll need to create a map. Go to Terminal → New Terminal and you'll see a new terminal open up right in Visual Studio Code. That's pretty neat!
Open a terminal window
Install your packages
Now that you have your terminal open, go ahead and install some packages to read data and make a map.

You'll need the PlotlyJS, DataFrames, and CSV packages. Type "julia" into your terminal and hit Enter. Then hit the "]" key to open the package installer and type "add DataFrames PlotlyJS CSV," hit Enter, and wait for the packages to install. Bam. You're ready to explore the data and build a map.
Install your packages
Run your code
Before running your code, load the packages you just installed with the using directive. Simply type "using PlotlyJS," "using DataFrames," and "using CSV" into your script, as shown here.

Now you're ready to roll! Tap the play button at the top right of the script window. Voilà!
Pro Tip
It's good coding practice to pay attention to any alerts that appear after running your code.
Run your code
Load your data
Here's where things get interesting. Let's load the data! Since you've already downloaded the data, all you need to do is call a ""the-file-name.csv", DataFrame)" DataFrames method and enter the file name surrounded by quotes, as you see here. Then run the code to clean the data.

The data-cleaning code shown here does a couple things:
 It finds all the scholarships intended for high school students.
 It prints the first five rows of the data for you to inspect.
Pro Tip
Check out this helpful overview of DataFrames for more info on a range of DataFrames methods.
Load your data
Make your map
Watch your map come to life in this last step. The "scattergeo" function uses the latitude and longitude values in the dataset to place the markers on the map. The commands shown in the code displayed here give various values to the circles, making them user-friendly by adding names and other info about the scholarship providers. To explore all the details you can add to your map, tap the button below to discover more about PlotlyJS.

Finally, run your code to display the map in a browser window. Optionally, use "savefig(you_plot, "filename.html")" to save your map as a web page and use the source code there to embed it in a website like this one.
Done! Here's the code.
And there you have it! You've now created your very own scholarship map. Use it to find relevant opportunities and update it to get the information you need, when you need it. Have fun adapting this tutorial for your own projects.

Here's the code we used in this tutorial, for your reference.
Ohio Tech Day Julia tutorial code
Share your work!
Don't forget to share your map with your learning community! Use a free website builder like Google Sites to publish your map for the world to see. Tag us with hashtags #OhioTechDay and #JootForGood.

We can't wait to see your unique work.
Who are we?
Karen Mauk, Director of Marketing @ Joot
Karen Mauk, Director of Marketing @ Joot
Phillip DiSilvestri, Sales & Marketing Intern @ Joot
Phillip DiSilvestri, Sales & Marketing Intern @ Joot
At Joot, we love data. Our technology and services are powered by data. And our marketing is data-driven too.

Our marketing team uses code to analyze data and—with the help of our engineering and services teams—turn those insights into product and service developments. We know that a little data can go a long way in improving people's experiences—and opening doors to new opportunities every day.

We'd love to hear how you use data and see all the amazing things you build with code. Please get in touch!
We love data © Karolina Grabowska

Adapted from © Karolina Grabowska

Back to Top