Assignment #13   (20 points)

  1. Watch the video String Manipulation: Convert Addresses (Google Sheets) (CC).

  2. Create a document using Google Sheets and Javascript that contains two command buttons. The first command button "Test" should be able to extract the first two characters, middle two characters, last two characters, last character, position of "C" from a sample string. The second command button "Convert Addresses" should be able to extract the city, state, and zip code from addresses similar to the one developed in the video and shown in the image below. A list of addreses along with screen captures showing the JavaScript code can be downloaded from the Assignment #13 folder. For more information see: Extending Google Sheets and Learning Javascript.

  3. Share this file with your instructor: rosener@nsuok.edu

  4. Save your Google Sheets as a Microsoft Excel file "assignment13.xlsx" when you are finished.

  5. Upload this file to your YOUR-CLASS-WEBSITE. Help.


Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
Created a document using Google Sheets and Javascript that contains two command buttons. The first command button "Test" should be able to extract the first two characters, middle two characters, last two characters, last character, position of "C" from a sample string. The second command button should be able to extract the city, state, and zip code from addresses similar to the one developed in the video and shown in the image above. 20 0 10 20 __/20
Total points __/20