chusa83

[chusa83]

Simple cross platform markdown editor

[chusa83]

Help / How to Use the AI Report Card Generator

This add-on helps teachers generate personalized, standards-based report card comments using AI. It supports Google Gemini, OpenAI, and DeepSeek. Below are detailed steps to set up your API key and use the tool effectively.

⚠️ Note: Some AI providers require payment or a billing setup to use their APIs. This add-on does not provide or resell API keys — you must obtain and manage your own.

1. How to Get an API Key

Google Gemini (via Google AI Studio):

Go to Google AI Studio.

Sign in with a personal Google account (not all school accounts work).

Click "Get API Key" and create a project if prompted.

Copy the API key provided and keep it safe.

⚠️ If you're using a Google for Education account, your school IT admin may need to enable access to Google AI Studio and allow Gemini APIs.

OpenAI (ChatGPT API):

Go to https://platform.openai.com/signup and create an account.

Once logged in, visit API Keys page.

Click "Create new secret key", name it, and copy the key.

⚠️ A ChatGPT Plus subscription does not include API access. The API is a separate service that requires setting up billing in the OpenAI Platform. New users typically receive $5 in free credits, valid for 3 months.

DeepSeek:

Go to https://platform.deepseek.com and log in or create an account.

In your dashboard, go to the API Keys section.

Click "Generate New API Key", name it, and copy it.

⚠️ DeepSeek may also require billing details or usage limits — check their dashboard for terms.

2. Launch the Sidebar

In your Google Sheet, click on the "AI Report Cards Comment Generator" menu.

Click "Open Sidebar".

3. Configure Your Inputs

Select your AI provider and paste the API key.

Click "Select Range" buttons to pick:

Headers Range: The row with column names (e.g., "Student Name", "Standard 1 Grade").

Data Range: The student data (below the headers).

Set your desired maximum character limit (default is 500).

4. Choose a Prompt Type

Guided Prompt: Fill in structured fields like class name, standards, and grading methods.

Custom Prompt: Write your own AI prompt manually if you prefer full control.

5. Preview and Generate

Click "Preview and Generate".

Review the generated prompt and click OK to confirm.

The AI will create comments and write them to the target column, with a backup in the next column.

6. Other Menu Options

Load Example Sheet: Loads sample student data to experiment with.

View Terms of Service: Read data usage responsibilities and conditions.

Help / How to Use: Reopen this guide.

If you're stuck, please make sure:

Your API key is correct and active.

Your headers and data ranges don’t overlap.

You’ve selected the right AI provider and inputs.

This tool was built to save you time and help students shine. You're in control — review each comment and personalize as needed!

[chusa83]

Terms of Service

By using this tool, you acknowledge and agree to the following terms and conditions:

You are solely responsible for handling any student or personal data in accordance with your local laws and your institution’s data protection and privacy policies.

You must not misuse this tool or distribute it for unauthorized or commercial purposes.

This tool provides AI-generated suggestions that are not guaranteed to be correct or appropriate; professional judgment is required to evaluate and edit outputs.

You must not enter sensitive or confidential information into any field that will be processed by external AI providers.

Data Privacy and API Key Use

This add-on does not store, access, or transmit any user data, student data, API keys, prompts, or generated outputs to any external server beyond the direct communication with your chosen AI provider.

All API key information and data you input is only used at runtime within your Google Sheet session and is never saved by this add-on. The privacy and security of your data depend entirely on the AI provider (e.g., OpenAI, Google Gemini, DeepSeek), and you are solely responsible for understanding and accepting their privacy terms.

If you use this add-on to process identifiable information, you must ensure that doing so complies with your institution’s policies and the terms of the AI services used. The authors of this tool cannot be held responsible for data exposure resulting from improper use or unsafe configurations.

Disclaimer of Liability

This tool is provided "as is" without any warranties, express or implied. No guarantees are made regarding its functionality, availability, accuracy, or suitability for any particular purpose.

CorredorParra.com and the developers of this add-on accept no liability for:

Loss of data, breaches of privacy, or accidental exposure of sensitive information.

Errors in AI-generated content.

Incompatibility with institutional technology policies or third-party services.

You use this tool entirely at your own risk. By continuing, you accept full responsibility for how it is used and for any consequences arising from that use.

[chusa83]

Privacy Policy

Effective Date: March 27, 2025

The AI Report Cards Comment Generator is a Google Sheets add-on developed to help educators generate standards-based report card comments using third-party AI providers.

1. Information We Collect

This add-on does not collect, store, or transmit any personal data from users. It operates entirely within the active Google Sheet session and processes data locally between the spreadsheet and the AI API you choose to connect to.

2. Use of API Keys

API keys for OpenAI, Google Gemini, or DeepSeek are entered by the user and used only during that session. The add-on does not store, log, or transmit API keys to any external server. The user is fully responsible for managing and protecting their API key.

3. Third-Party AI Services

This add-on sends selected spreadsheet data to a third-party AI provider (OpenAI, Google Gemini, or DeepSeek) based on your selection. You are responsible for understanding and accepting the privacy policy and data handling practices of the AI provider you choose.

Please refer to their respective policies:

OpenAI Privacy Policy

Google Privacy Policy (Gemini)

DeepSeek Privacy Policy

4. Data Ownership

You retain full ownership of your data. This add-on does not access any files or information outside of the sheet you are actively working in. All student data processed is temporary and never stored by this add-on.

5. Data Security

Since the add-on does not store any data or communicate with a developer-controlled server, the responsibility for secure use lies fully with the user. You are expected to follow your institution’s guidelines for student data privacy and ensure no sensitive or confidential information is shared with AI services.

6. Changes to This Policy

We may update this privacy policy from time to time. Changes will be posted publicly, and it is your responsibility to review the policy periodically.

7. Contact

If you have any questions or concerns regarding this privacy policy, please contact: chusa83@gmail.com

This tool was developed by a teacher, for teachers — with privacy, simplicity, and transparency in mind.

[chusa83]

Microsoft won't fix Windows handhelds, so someone else is finally trying

[chusa83]

Debloat and optimize Windows 10 and 11 with open-source WinScript app - Neowin

[chusa83]

[chusa83]

Some of my amazing students created this podcast to explore the roles of their teachers in Technology!

[chusa83]

Windhawk vs PowerToys: Which Windows customization tool is better?

[chusa83]

Tired of dealing with Windows updates? Here's how to automate them with PowerShell

[chusa83]

10 Best DC Omnibuses For Beginners

[chusa83]

Rebound 11 fixes Windows 11’s flaws — without altering system files! | BetaNews

[chusa83]

I put 7 leading AI image generators to the test with the same prompt — here’s the winner | Tom's Guide