How to insert a score into a Google Drive lesson plan

Many Creative Sequence users enjoy the online Google Drive lesson plan templates. Being able to access and share lesson plans anywhere, from any device, is certainly handy. However, there are some limitations to Google Spreadsheets. One major limitation is images. If you paste an image into the spreadsheet, it floats over top of the form, and does not stay where you want it.

To insert a score into the “repertoire” cell, use the following formula in that cell:


However, this assumes you have a url (web address) for your image. If you have the score image on your computer, how do you upload it to a url? Well, if you have a Google Drive account, then you also have a Google+ (plus) account (all Google offerings are now linked together in one account).

To find Google+, look for the square of nine little squares in the top right of your Drive window. Click on this, then choose the “g+”. If it’s your first time in Google+, you may have to answer some setup questions. Once through this process, look for the “Home” button on the top left. Click this to open a menu, then choose “Photos”. From here, there is an “Upload Photos” button, or you can drag and drop images from your computer.

Once you have a score saved on Google+, open the image, then right-click (ctrl-click on Mac) and choose “Copy image url”. Finally, go back into your Lesson Plan spreadsheet, and replace “” with the copied address. Once you hit “enter”, you will see your score in the cell! Resize to make it fit better, and you’re done.imageexample

So…one more question. How do we make those scores in the first place?

Creating a digital score with Noteflight

Creative Sequence users have seen many clean, simple scores for folk songs and other children’s music. These scores have been created with Noteflight. Noteflight is an online music notation software, that allows you to create, edit, and retrieve scores from any device, at any time (similar to the way Google Drive works with documents and spreadsheets).

If you are new to Noteflight, you will have to sign up for an account. It is free for the basic membership, but there are limitations to score options and the number of files you can save. Full access is about $50 per year, relatively inexpensive compared to desktop notation software.

Once you have created a score, the simplest way to save it as an image is by taking a screenshot. On Windows machines, use the Snipping Tool (you can search for the tool, it’s location varies depending on your edition of Windows). On Mac, press¬†alt-shift-4. In both cases, this will bring up crosshairs that you can drag around your score, and quickly snap an image. Once you find where the image is stored, you can upload the image and use it for your online lesson plans.