Discuss internet safety with the students. Students should not share any personal information.
In this project, students will use Google accounts to create chemistry-themed apps, with no programming required. They will create a Google Drive spreadsheet containing scientific information, and link it to a free account on Glideapps.com. They will personalize the app on the Glideapps website. The resulting app will be available to view on devices that have the correct link.
Middle and High School
This project will help prepare your students to meet the performance expectations in the following standards:
- Scientific and Engineering Practices:
- Obtaining, Evaluating, and Communicating Information
By the end of this project, students should be able to
- Compile relevant chemistry facts from reliable sources.
- Enter and manipulate information in a spreadsheet.
- Design an appealing and functional app.
This project could support student understanding of
- Review material
- Elements and the Periodic Table
- Molecules & Bonding
- Acids & Bases
- Physical & Chemical Properties
Teacher Preparation: 30 minutes (to learn about and practice creating an app)
Lesson: ~90 minutes:
- 30-40 minutes to teach students the process
- 60 minutes to complete the project tasks
- Computers or Chromebooks (at least one per group, ideally one per student)
- Discuss internet safety with the students. Students should not share any personal information.
- Glideapps is a website that creates an app from a Google spreadsheet.
- It is simple to use, and doesn’t require any programming or significant tech skills to use it. Previous spreadsheet use is helpful, but not necessary.
- Create a teacher app before doing it with the students. Follow the instructions on the Student Handout and use the resources at Glideapps.com to become familiar with the process.
- Students can work in groups of 1 to 3. Larger groups should be avoided because there will be fewer opportunities for individual members to contribute to app customization.
- Encourage students to be creative and explore all of the possible functions at Glideapps.com.
- Create a Google spreadsheet where student share the links to their apps so the teacher and other students can view all of the work quickly.
- Show students a simple example spreadsheet and resulting app before they decide on a topic:
- This project could be used for review, or for an introduction to a specific topic. Some suggestion for possible project topics include:
- The Elements and the Periodic Table
- Acids and Bases
- Physical and Chemical Properties
- Note: To insert images or videos into a spreadsheet cell, right click on an image/video, select “Copy Image Address” or “Copy Video URL”, and then paste it into the cell.
- After all apps are submitted, students can vote on their favorites.
For the Student
You will create an easy-to-use and visually appealing app that conveys valuable chemistry information.
You will need a Google account and a computer or Chromebook with internet access.
Never share any personal information in your Google spreadsheet. Anything in the spreadsheet will appear in the app and be openly available on the internet. This includes information like your name, location, and school.
- Your teacher has discussed possible topics for your app. Talk to your group and decide which topic to pursue, or ask for your teacher’s approval on a new chemistry topic.
- One student per group should create a “Chemistry App” Google Sheets spreadsheet in their Google Drive account. They should share this spreadsheet with all group members and the teacher.
- Decide what information needs to be added for a useful and interesting app. Make a list of this information.
- Create column headings for this information. For example, if you are creating an app about elements, create column headings like "Element Name", "Element Symbol”, Atomic Number", "Atomic Mass", “Image", and “Video”.
- All members of the group can open the spreadsheet on different devices and concurrently add information to the rows. Divide the work in an equitable manner so that everyone contributes.
- One member of the group should navigate to Glideapps.com.
- Sign up for Glideapps using the same Google account that your group used to create the spreadsheet.
- Select "New App".
- Link the "Chemistry App" Google Sheet to the Glideapps website.
- Customize the appearance of the app in Glideapps.
- Customize the entries in the spreadsheet as needed.
- Go back and forth between editing the spreadsheet and adjusting the settings in Glideapps until you are satisfied with your app.
- At the bottom left of the Glideapps screen, select "Share app". This will give you the option of looking at the app on a computer/Chromebook, or copying a link to your app.
- Copy the link into an email and send it to your teacher and every team member, or paste the link into a Google spreadsheet shared with your teacher and the whole class.
- When the link is opened on an Android device, it will give you the option of installing the app. On other devices, the app will open in a browser.