Ultimate Points Tracker for Google Sheets

Welcome! This guide will walk you through everything you need to know to get the most out of the Ultimate Points Tracker.

1. Initial Setup (First-Time Use)

Getting started is quick and easy. Follow these steps to set up your spreadsheet and activate your license.

1.1. Install the Add-On

• Install the Ultimate Points Tracker from the Google Workspace Marketplace.

• Open a new or existing Google Sheet where you want to track your students.

1.2. Run the Setup

• After installing, a new menu named Ultimate Points Tracker will appear in your Google Sheets menu bar.

• Click Ultimate Points Tracker > Setup Add-On.

• This will automatically create all necessary sheets in your document (Students, Behaviors, PointLog, Teachers, Settings, etc.) and format them correctly.

1.3. Enter Your License Key

• To unlock the add-on, you must activate a valid license key for the specific spreadsheet.

• Click Student Tracker > Enter License Key.

• Paste the license key you received from Gumroad after your purchase.

• The add-on will verify the key and bind it to the current spreadsheet. Note: Each license key is valid for only one Google Sheets spreadsheet. If you need to use the add-on in multiple spreadsheets, you must purchase a separate license key for each.

• Upon successful activation, the license key and your Google account email will be stored in the Settings sheet and a secure Firestore database to ensure the license is used only with this spreadsheet.

1.4. Add Collaborators (Optional)

• To allow other users (e.g., teachers or paraprofessionals) to use the add-on in the same spreadsheet, add their email addresses to the Teachers sheet.

• Collaborators with editor access to the spreadsheet can use the add-on without needing their own license key, as long as the spreadsheet has a valid, activated license.

• Important: Do not share your license key with others outside your intended collaborators, as this may result in license deactivation.

2. Customizing Your Tracker

Before you start awarding points, take a moment to customize the tracker for your classroom.

2.1. Add Students

• Go to the Students sheet and list your students' names in the "Name" column.

2.2. Customize Behaviors

• Go to the Behaviors sheet. You can edit the list of behaviors, change the point values (use negative numbers for deductions), and specify if a behavior requires a note (Y for Yes, N for No).

2.3. Set Periods

• Go to the Periods sheet and list the different class periods or subjects you want to track (e.g., "Math", "Science", "Recess").

3. Using the Class Dashboard

The Dashboard is your command center for tracking points in real-time.

3.1. Opening the Dashboard

• Click Ultimate Points Tracker > Open Dashboard. This will open the main dashboard in a new browser tab.

• Ensure the spreadsheet has a valid license key activated to access the dashboard.

3.2. Awarding Points

• To Specific Students:

  1. Check the boxes next to the names of the students you want to award points to.

  2. Select a behavior from the "Points" dropdown menu.

  3. Select the current "Period" from the dropdown.

  4. Click the Award Selected button.

• To All Present Students:

  1. Select a behavior and period.

  2. Click the Award All button. This will give points to every student marked as "Present".

3.3. Marking Students Absent

• In the "Student Progress" table, double-tap or double-click the "Status" column for a student to toggle them between "Present" and "Absent".

• Absent students cannot be awarded points and will be grayed out. This status resets when you refresh the page.

3.4. Understanding the Charts

• Date Filter: Use the date pickers at the top to filter the data shown in all the charts below.

• Positive vs. Negative Points: A pie chart showing the ratio of positive to negative points awarded in the selected time frame.

• Points Distribution: A pie chart showing which behaviors are being awarded most frequently.

• Points Breakdown by Period: A bar chart that shows point totals for each behavior, broken down by class period.

• Cumulative Points Trend: A line graph showing the class's total points accumulating over time.

4. The Student Report Page

Dive deep into an individual student's progress.

4.1. Opening the Report Page

• From the Dashboard, click the View Student Report button.

• Alternatively, click Ultimate Points Tracker > Open Report from the Google Sheet menu.

4.2. Generating a Report

1. Select a student from the dropdown menu.

2. Choose a start and end date for the report.

3. Click Apply Filter.

4.3. Reading the Report

• The report will show a summary of the student's total points, their progress towards their personal goal, and their current badge.

• You will see detailed charts for their personal point distribution and trends.

• At the bottom, the Points Breakdown table lists every single point transaction for that student in the selected period, including any notes. Notes are important for adding context to certain points categories. Parents have reported valuing this feature as it explains reasons why their child is earning certain positive or negative points.

4.4. Printing & Exporting

• Click the Export as PDF button to open your browser's print dialog. You can print a physical copy or save it as a PDF to share with parents or administrators.

Go Beyond Total Points with Truly Personalized Student Goals

While the Students tab tracks a primary point goal, you can use the rich data in your reports to set and monitor highly specific objectives with your students (there is no option to set these in the add-on, but you can do this independently of the tracker).

Examples of Custom Goals

• Behavior Ratio: Challenge a student to achieve a 97% positive-to-negative point ratio for the week.

• Skill Focus: Set a target for a student to earn 15 "On Task" points during ELA by Friday.

• Ad-Hoc Interventions: Use a student's report to identify a challenge (e.g., negative points in Music) and create a mini-goal with them on the spot to turn it into a positive.

Other Considerations

• Use the class report or individual reports for different meetings: intervention, student support, IEP, family conferences, or other evidence-based needs.

• Print reports weekly to send home.

How to Leverage the Charts for Deeper Insights

Here’s how to frame the value of each chart:

Positive vs. Negative Points Chart

• Ask: "What is the overall tone of my environment?"

• Insight: In a classroom, it's a health check. A chart heavily skewed to the negative might suggest a need to focus more on positive reinforcement. For personal habits, it's a clear look at your weekly discipline.

Points Distribution (by Category) Chart

• Ask: "What is happening most often?"

• Insight: This tells you what to focus on. If "Being Disrespectful" is the biggest slice of the pie, you know what your next class meeting should be about. If "Read a Chapter" is a tiny slice, you might need to create more incentives for reading.

Points Breakdown by Period Chart

• Ask: "WHEN are things happening?"

• Insight: This chart reveals context and patterns. If "Distractions" are highest during your "ELA" block, maybe it's time to change up the lesson format. If a student's points are always positive except during "Recess," it gives you a specific area to investigate.

Cumulative Points Trend Chart

• Ask: "Are we making progress over the long term?"

• Insight: This is the motivation chart. It's perfect for tracking progress towards a big class reward (like a pizza party) or a personal long-term goal. Seeing the line go up is a powerful visual reward in itself.

Other Use Cases

Creative Uses for the Points Tracker

The core of the Ultimate Points Tracker for Google Sheets add-on is tracking quantifiable events (points) tied to categories (behaviors) for specific entities (students) over time (periods). By creatively redefining what those elements represent, you can unlock entirely new use cases.

1. For Students (Beyond Behavior Management)

Gamified Learning & Skills Mastery:

• Students: Still students.

• Behaviors: Academic skills or learning objectives (e.g., "Solved a Bonus Math Problem," "Used 5 New Vocabulary Words," "Completed a Science Lab," "Read a Chapter").

• Points: Experience Points (XP).

• Interpretation: The Points Distribution Chart instantly shows which skills the class is engaging with most. The Individual Report becomes a "Skills Transcript," showing a student's strengths and areas where they need more practice. The Cumulative Trend tracks overall academic engagement, not just behavior.

Classroom Economy & Jobs:

• Behaviors: Classroom jobs or responsibilities ("Watered Plants," "Cleaned Whiteboard," "Helped a Classmate," "Line Leader").

• Points: "Classroom Cash."

• Interpretation: The Dashboard acts as a bank ledger. The Period Breakdown Chart can show if certain jobs are being neglected during specific parts of the day or week.

2. For Personal Development & Productivity

Advanced Habit Tracking:

• Student: You.

• Behaviors: Habits you want to build or break ("Exercised for 30 mins," "Meditated," "Read 10 Pages," "Ate Junk Food," "Woke up on time").

• Points: Track frequency or completion. Use positive points for good habits and negative for bad ones.

• Interpretation: The Positive vs. Negative Chart gives you a high-level look at your discipline for the week. The Period Breakdown Chart is incredibly powerful here: "Do I always skip my workout in the 'Evening'? Do I only eat junk food on 'Weekends'?" It helps you identify your personal triggers and patterns.

Freelancer Project & Time Management:

• Students: Your Clients or Projects.

• Behaviors: Your Tasks ("Client Call," "Drafting," "Revisions," "Final Delivery").

• Points: Hours Worked or Tasks Completed.

• Interpretation: The Points Distribution Chart shows where your time is going. "Am I spending too much time on revisions?" The Individual Report for a client becomes a simple, powerful progress report you can share.

3. For Health & Wellness

Fitness & Nutrition Goals:

• Student: You or a client you're training.

• Behaviors: Health actions ("Completed Cardio," "Strength Training," "Ate 5 Servings of Veggies," "Drank 2L of Water").

• Points: Gamify the process, aiming for a certain "Health Score" each week.

• Interpretation: The Cumulative Trend Chart is perfect for visualizing progress towards a long-term goal (e.g., "30 workouts in 60 days").

Symptom & Condition Tracking:

• Student: A patient or yourself.

• Behaviors: Symptoms ("Headache," "Fatigue," "Back Pain") or Triggers ("Drank Coffee," "Poor Sleep").

• Points: Severity (e.g., a scale of 1-5).

• Periods: Time of Day ("Morning," "Afternoon," "Night").

• Interpretation: This is a game-changer for doctors. The Period Breakdown Chart could reveal that your "Headaches" (Behavior) are most severe in the "Afternoon" (Period), helping you or a doctor identify patterns that might otherwise be invisible.

• Disclaimer: The Ultimate Points Tracker for Google Sheets is not meant to diagnose, treat, or cure any disease. Consult your doctor if you have health concerns.

Thank you for using the Ultimate Points Tracker! We hope it becomes an invaluable tool in your classroom.

**The Ultimate Points Tracker is not meant to treat or cure any disease. If you have health concerns, consult your doctor.**