CS 107: thunkable

Lesson# 3

Spreadsheet and Map App

What you will do in this lesson:

Use a spreadsheet to store and retrieve data
Add markers to a Digital Map
Connect to a 3rd party image hosting site with an API

What you will learn in this lesson:

How to store and retrieve data from a Spreadsheet
How to store custom images in an app

Vocabulary

Database:
Persistence:

Agenda/Lesson Steps

0. Set up a Spreadsheet

Connect App to Spreadsheet

2. Design an info screen

3. Display data from the sheet

4. Code a "Next Button to allow navigation within app

5. Refactor to define a function and eliminate redundant code

6. Design a map screen

7. Set a map’s properties

8. Design an input screen

9. Store user-entered data in a spreadsheet

10. Add Back buttons for navigation

Extra Credit:

11. Allow the user to choose an image, and store that in cloud

12. Allow the user to choose an image, and store that in cloud, pt 2

Slidedeck/MiniLesson

5-3 Spreadsheet and Map app

Intro to App:

Activity

0. Make a Copy of Spreadsheet and populate it with at least 3 entries

2. Connect App to Spreadsheet

3. Display Data

4. Code a Next Button

5. Define a Function to Display Data

Explanation of How Spreadsheet ID Works

6. Design a Map Screen

7. Set Map Properties

8. Design an Input Screen

9. Store User Input

10. Add Back Buttons

Extra Credit

Store Images in the Cloud Part I

Store Images in the Cloud Part II

Handout

5-4 Spreadsheet and Map Database App 2.0

Closeout

Universal Supports

Google Sites

Report abuse