Information Technology
Hands on Training icon
Hands On Training
Hands on Training icon

API Quiz Game - JavaScript Project using Google Sheet Data

Course Cover
compare button icon

Course Features

icon

Duration

1.1 hour

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Teaching Type

Self Paced

icon

Video Content

1.1 hour

Course Description

Explore how to connect to a Google Sheet Data as a JSON feed and use the data to create a dynamic web quiz game application

Welcome to the course that will show you how you can apply JavaScript to connect to a web API - get JSON data and build a JavaScript Quiz game from scratch using the data coming from a Google Spreadsheet. As a bonus the course will also show you how you can setup your own spreadsheet webapp using Google Script so that you can customize the content and have your very own version of the questions in your application.

YOU MUST HAVE JAVASCRIPT EXPERIENCE FOR THIS COURSE.

Source code is included - please try the code as you work through the lessons.

Course Covers applying JavaScript code

How to setup the basic Project shell with HTML and CSS
How to use JavaScript query selector to select page elements as JavaScript objects
Use fetch to connect to the web app URL for data source
JSON data and how to prepare it in JavaScript
Creating a function to display data content in the web application
Logic to approach game design and building of the web application
Next steps for player and using Game data
Debugging and advancing game design
Apply styling for a better looking game
Conclude the game quiz - make it dynamic so driven by the JSON data and flexible to change as the data changes.
Create a Google Script web app using Google Spreadsheet data
Structure JSON from an array object
Connecting sheet data to your web application
Enjoy learning have fun!!!!

Try the code for yourself and explore what you can do with JavaScript

Fast Friendly support to help answer any questions you might have and to help clarify content is always available in the Q&A section. Taught by an instructor with over 20 years real world experience ready to help you learn more. Step by step training resources and source code is also included to get you started quickly.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Computer access and internet

JavaScript HTML and CSS

What You Will Learn

Anyone who wants to practice JavaScript with API connection

Explore Google Web App data from spreadsheet

How to connect to a web api

How to use JavaScript DOM to create page elements

Loop through JSON data

Course Cover