2025年1月22日 星期三

🌟 Puti-Ai School-wide Student Performance Management System - Setup Guide

 


## 📝 Overview

This is a free, open-source student performance management system designed for teachers. It allows you to:

- Track student behavior and performance in real-time

- Award positive and negative points

- View student scores by class

- Customize reasons for points

- Access via mobile devices


## 🚀 Setup Instructions


### Step 1: Create a Copy of the Spreadsheet

1. Open [this link](your_spreadsheet_link)

2. Click `File` → `Make a copy`

3. Name your copy (e.g., "My School Performance Management System")

4. Click `OK`


### Step 2: Configure the Spreadsheet

The spreadsheet contains several sheets:


#### 帳密 (Account)

- Contains teacher login information

- Columns:

  - Username

  - Password

  - Teacher Name

- Add or modify teacher accounts as needed


#### 班級設定 (Class Settings)

- Lists all class names

- One class name per row

- The system will automatically create buttons for each class


#### Records

- Automatically records all scoring history

- Do not modify this sheet manually

- Columns:

  - Date

  - Teacher

  - Student

  - Score

  - Reason


#### 正負 (Positive & Negative)

- Configure scoring reasons

- Two columns:

  - Positive behaviors

  - Negative behaviors

- Add or modify reasons as needed


#### Class Sheets

- Create a sheet for each class

- Name must match exactly with Class Settings

- Columns:

  - Student (學生)

  - Score (分數)


### Step 3: Deploy as Web App

1. Open Script Editor

   - Click `Extensions` → `Apps Script`


2. Replace Code

   - Copy and paste the provided code into corresponding files

   - Make sure all files are present:

     - Code.gs

     - index.html

     - javascript.html

     - stylesheet.html

     - language.html


3. Deploy

   - Click `Deploy` → `New deployment`

   - Click `Select type` → `Web app`

   - Configure:

     - Description: "Student Performance Management System"

     - Execute as: "Me"

     - Who has access: "Anyone"

   - Click `Deploy`

   - Authorize the app when prompted


4. Save the URL

   - After deployment, you'll get a web app URL

   - Share this URL with your teachers


### Step 4: Add to Home Screen

For easier access on mobile devices:

1. Open the web app URL in your browser

2. Add to home screen:

   - iOS: Share button → Add to Home Screen

   - Android: Menu → Add to Home Screen


## 💡 Usage Tips

1. **Login**

   - Use your assigned username and password

   - Check "Remember me" for faster access


2. **Adding Points**

   - Select class

   - Select student(s)

   - Choose score (+1 to +5 or -1 to -5)

   - Select or add reason

   - Click Submit


3. **Custom Reasons**

   - Click "Custom Reason" to add new reasons

   - Custom reasons are stored locally

   - Frequently used reasons should be added to the spreadsheet


4. **Viewing Scores**

   - Click "View Scores"

   - Select class to view

   - Scores are automatically sorted


## ⚠️ Important Notes

1. **Backup**

   - Regularly backup your spreadsheet

   - Keep a copy of the original template


2. **Security**

   - Change default passwords

   - Don't share admin access

   - Log out on shared devices


3. **Customization**

   - Modify reasons to match your school's needs

   - Add or remove classes as needed

   - Update teacher accounts annually


## 🤝 Support

This system is:

- Free to use and share

- Open for educational purposes

- Created by Teacher Huang Chao-Jung from Houzhong Elementary School, Pingtung County


## ⚖️ License

- Free for educational use

- Commercial use strictly prohibited

- Copyright infringement is not allowed


## 🔄 Updates

- The system may be updated periodically

- Check the original template for updates

- Backup your data before updating


For questions or support, please contact the developer through appropriate channels.


沒有留言:

張貼留言