Class Record Generator

SIAS Class Record Generator — User Manual

This tool generates ready-to-use class record spreadsheets for all your classes by pulling student data directly from your SIAS account. Each class gets its own .xlsx file — pre-filled with your instructor details, subject info, schedule, and complete student list — all packed into a single ZIP file.

Requirements

1. A modern web browser (Google Chrome recommended)
2. Valid SIAS instructor credentials
3. The .xlsx template file must be available for your selected template
4. Stable internet connection

Step-by-Step Guide

Step 1 — Enter Your SIAS Credentials

Type your SIAS Username and Password in the fields provided. Use the eye icon beside the password field to show or hide your password. The tool will log into SIAS on your behalf to retrieve your class list and student rosters.

Step 2 — Select a Template

Choose the class record template that matches your department from the Class Record Template dropdown. Each template defines how your data is mapped to specific cells in the spreadsheet. If your department's template is not listed, click Request one below the dropdown to learn how to submit it.

Step 3 — Generate & Download

Click the GENERATE & DOWNLOAD button. The tool will:

1. Log in to SIAS with your credentials
2. Fetch your complete class list with student rosters
3. Load the selected .xlsx template file
4. Fill in each class record with your name, subject info, schedule, and student list
5. Package all files into a single .zip archive and download it automatically

A green status bar at the top of the form confirms success and shows how many class records were generated.

Generated Files

One .xlsx file is produced per class, named:

1. [Section] - [SUBJECT NAME].xlsx — e.g., BSIT 3A - INTERNET OF THINGS (IOT) (ELECTIVE 4).xlsx

Each file is pre-filled with:

1. Instructor name — pulled from your SIAS account
2. Subject code, name, and units
3. Section code
4. School year and semester — from your active SIAS period
5. Schedule — days (e.g., M,W,TH), time (e.g., 7-10am,1-3pm), and room
6. Student IDs and names — listed sequentially starting from the row defined in the template

All files are bundled inside a single ZIP archive named [YourCode]_CLASS_RECORDS.zip.

Requesting a Template

If your department's class record format is not yet available, click the Request one link below the template dropdown. Send your blank .xlsx template file to [email protected] — it will be added to the system as soon as possible.

Troubleshooting

1. Login failed — Double-check your username and password by logging into the SIAS portal directly first.
2. No classes found — Your account may have no assigned classes for the current period, or the class list API is temporarily unavailable.
3. Failed to load template file — The selected template's .xlsx file is missing from the server. Contact the administrator or request it to be re-uploaded.
4. Unexpected error — This is usually a temporary issue with the SIAS API. Wait a few minutes and try again, or contact your system administrator.