Assignment #14   (20 points)

  1. Watch the video Formulas and Charts (Google Sheets) (CC).

  2. Create a document using Google Sheets and Javascript that 1) converts Celsius to Fahrenheit using both a formula and a command button, 2) converts Inches to Centimeters using both a formula and a command button, and 3) creates a chart when the command button "Create Chart" is pressed. Your document should be similar to the one developed in the video and shown in the image below. The initial data can be downloaded from the Assignment #14 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 "assignment14.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 1) converts Celsius to Fahrenheit using both a formula and a command button, 2) converts Inches to Centimeters using both a formula and a command button, and 3) creates a chart when the command button "Create Chart" is pressed. Your document should be similar to the one developed in the video and shown in the image above. 20 0 10 20 __/20
Total points __/20