Introduction
To View a live webpage (the Scripture tracker) we need to first install a addon in PowerPoint. PowerPoint allows you to add interactive web content directly into your presentations using the Microsoft Office add-in for live web browsers. This guide will walk you through the steps to embed and display a live web page in your PowerPoint slides.
Steps to Add a Live Web Browser
- Open Your PowerPoint Presentation
-
Insert the Web Viewer Add-in
- Go to the Insert tab in the PowerPoint ribbon.
- Click on Get Add-ins.
- Search for Web Viewer in the Office Add-ins Store.
- Click Add to install the Web Viewer add-in.
-
Configure the Add-in
- Once the Web Viewer is added to your slide, you will see a field to input a URL.
- In the URL field, type https://brolittle.userhosted.tools/scripture-reading/presentation.php.
-
Preview the Web Page
- Click Insert or Apply to confirm the URL.
- You will see the live web page embedded within your PowerPoint slide.
Tips for Using the Web Viewer Add-in
- Ensure your computer has an active internet connection for live content.
- Always test the web page on the presentation machine to ensure compatibility.
- Use HTTPS links for better security and compatibility.
How to Use the Scripture Tracker
When you open the Scripture Tracker, you'll see a grid with four cells, each serving a specific purpose:
- Top Left Cell (A1): Enter the total number of students here. This cell expects a numerical value.
- Top Right Cell (A2): Enter the number of students who have read their scriptures. This is also a numerical input.
- Bottom Left Cell (A3): This cell automatically calculates the percentage of students who have read their scriptures based on the values in the other two cells.
- Bottom Right Cell (A4): Double-click this cell to view the formula used to calculate the percentage. It uses Google Sheets-style formulas, currently supporting "if" logic for dynamic calculations.
Each cell in the tracker is labeled with an ID:
- A1: Total Students
- A2: Students Who Read
- A3: Reading Percentage
- A4: Formula Display
The Scripture Tracker is fully customizable. You can easily modify its appearance and settings by visiting the configuration page.