Classroom Seating Plan Manager

There are two main ways to start:

• Import from a file: Go to the Classroom tab. Under "Upload Students," choose an Excel (.xlsx) or .xls file. The file should have columns named "Name" and "Gender". Click "Import Students". This will load your student list and automatically create a default layout of seats for them.
• Manual Setup: In the Classroom tab, use the "Classroom Setup" controls. Enter the number of seats you need and click "Create Seats". Then, you can double-click any empty seat to manually create a new student and assign them to it.

After setting up, enter a name for your class in the "Class-Name" input field and click the main "Save Class" button at the top of the page. This will save your new class to the Google Sheet.

This application is powered by a Google Sheet, which acts as your database. All data is fetched from and saved to this sheet.

• Saving: Any change you make (moving a seat, renaming a student, logging behavior) will mark the class as "Unsaved". Click the main Save Class button in the header to push all current data—student lists, seat positions, and behavior scores—to the Google Sheet.
• Loading: In the Classroom tab, select a class from the "Load Class" dropdown menu and click Load Class. This will pull the latest saved version of that class from the Google Sheet and render it on the screen.
• Save Status: The status indicator in the header tells you the current state: "No class loaded", "Unsaved Changes", "Saving...", or "All changes saved".

Layout Templates allow you to save and reuse just the physical arrangement of seats, without any student data attached. This is useful if you have standard classroom layouts (e.g., "Group Pods," "Exam Rows," "U-Shape") that you use for different classes.

• To Save a Layout: Arrange the seats in the classroom view exactly how you want them. Then, in the "Layout Templates" section, type a name for your layout (e.g., "Group Pods") into the input field and click Save Layout.
• To Load a Layout: Select a saved layout from the dropdown menu and click Load Layout. This will clear the current seats and replace them with the saved arrangement. Your student list will remain, and you can then use the "Assignment" buttons to place students into the new layout.

The Dashboard tab provides a high-level overview of student behavior data for the currently loaded class.

First, load a class in the "Classroom" tab. Then, switch to the "Dashboard" tab. It will automatically fetch and display a card for each student, showing:

• A breakdown of positive and negative behaviors logged.
• A "Net Score" (total positive minus total negative behaviors).
• Students are ranked by their Net Score, with the top three receiving medals (👑, 🥈, 🥉).

This view is read-only and is perfect for getting a quick pulse on classroom dynamics.

The Grades tab is a powerful gradebook integrated with your Google Sheet.

• Loading Grades: First, load a class in the "Classroom" tab. When you switch to the "Grades" tab, it will automatically load all students and their saved grades for that class.
• Adding Assessments: Use the "Add Assessment Column" control to create a new column for a quiz, test, or assignment.
• Entering Grades: Simply click into any cell and type the grade. Changes are not saved automatically.
• Reordering: You can drag-and-drop student rows to reorder them. You can also drag-and-drop assessment columns to change their order.
• Saving: When you are finished entering or editing, click the Save All Grades button. This saves all grades and the current row/column order to your Google Sheet.
• Exporting: Click Export to XLSX to download the current gradebook view as an Excel file.

The MYP Reports and IGCSE Reports tabs use a template-based system to generate comments from data in your Google Sheet.

For both:

1. Ensure you have a dedicated "Report" sheet in your Google Sheet for the class (e.g., "Grade 9 Science Report").
2. Select the class from the dropdown and click the "Generate Comments" button.
3. The system reads grades from the report sheet, looks up corresponding comment snippets from other sheets (e.g., "Assessment A", "Assessment B"), and combines them.
4. A modal will appear with the generated comments, which you can copy individually.

The specific logic for each report type is described on its respective page in the app.

The AI Assistant tab provides powerful, context-aware AI tools, especially when run inside the Poe platform as a Canvas App.

• General Prompting: You can type any prompt into the main text area, optionally upload a file for context, and send it to the AI for a response.
• Specialized Generators: The cards at the bottom are for specific, pre-programmed tasks. For example, the "IGCSE Report Generator" uses a detailed, fine-tuned prompt to analyze student reflections and produce high-quality, actionable feedback. Simply upload the required file, select an AI model, and click the button.
• Poe Canvas Integration: These features work best inside Poe. If you run the app outside of Poe, the AI buttons will show a message explaining that the API is not available.