## 📝 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.