ChromebookScheduler

Welcome to ChromebookScheduler, an application developed to streamline the process of reserving Chromebooks at Merivale High School. This project was requested by Mr. Gibson in the math department to address specific needs related to Chromebook management and reservation.

Project Overview and Purpose

ChromebookScheduler is designed to facilitate the reservation and management of Chromebook tubs by teachers. The application satisfies the following requirements:

• Accessibility: Teachers must be able to access the application easily.
• Availability: Teachers can see which Chromebook tubs are free on which day and during which period.
• Location Tracking: Teachers can see where a Chromebook tub is located within the school.
• Advanced Booking: Teachers can book Chromebooks at least one month in advance.
• Cancellation: Teachers can cancel their bookings and reopen the slot for others.
• Login System: A login system for teachers.
• Activity Log: A record of who logged out which Chromebook tub, accessible only to Mr. Gibson.

Installation Instructions

Prerequisites:

• Python Installation:
  • Python can be installed by following this link.
  • All Python libraries used except Flask do not require additional installation. Installation instructions for Flask are outlined below.
• Flask Installation:
  • Flask can be installed by following this link.
  • An in-depth guide for Mac installation can be found here.

Steps to Run the Application:

1. Clone the GitHub repository: git clone https://github.com/brokentelescope/ChromebookScheduler
2. Move the folder into your code editor (e.g., VSCode).
3. Run the app.py file.
4. Open the link provided in the terminal in your browser.

Configuration and Setup

To configure school days and holidays:

1. Locate the INPUTGOOGLESHEET.txt file (it should be near the end of the list of names).
2. Follow the instructions in the text file to input data specifying the school day (1/2/3/4) or holiday.

Usage Instructions

Account Setup:

1. Sign up for an account.
2. Wait for your account to be verified by the admin.
3. Once verified, you can start reserving Chromebook tubs.

Booking and Managing Chromebooks:

• View available Chromebook tubs by day and period.
• Book a Chromebook tub for up to one month in advance.
• Cancel your bookings to free up the slot for others.

Midpoint-Based Date Range Update

The date maintained is determined by the dateMaintained.txt file, containing start and end dates in the format:

• Start year, month, day
• End year, month, day

In this approach, the system checks if the midpoint of the current date range exceeds the current date. If so, it triggers an update to extend the date range. This ensures that the system proactively adjusts its window to accommodate future needs, maintaining relevance and accuracy.

Clearing Data

To clear certain data within ChromebookScheduler, follow these steps:

• Reservation History:

  • To clear the reservation history, simply click the "Clear History" button on the reservation history page.

• User Database:

  • To clear the user database, navigate to the admin manage user page. From there, you can edit or delete users as needed.

• Chromebook Database:

  • To clear the Chromebook database, go to the manage bins section. From there, delete the Chromebook bins that are no longer needed.

Contributing

We welcome contributions to improve ChromebookScheduler! To contribute:

1. Fork the repository.
2. Create a new branch for your feature or bug fix.
3. Make your changes and commit them.
4. Submit a pull request to this repository.

Tech Stack

The application is built using:

• HTML
• CSS
• JavaScript
• Python

Contributors Contact Information

This project was developed by Owen Chen, Tianqin Meng, and Rex Li from Merivale High School.

For any questions or support, please reach out to:

• Tianqin Meng: tianqin.steven.meng@gmail.com
• Owen Chen: owenchenyp@gmail.com
• Rex Li: rli16@ocdsb.ca

Sources

[1] Chatgpt, https://chat.openai.com/ (accessed Feb. 9, 2024).

[2] “Download free vectors, images, photos & videos,” Vecteezy, https://www.vecteezy.com/ (accessed Feb. 9, 2024).

[3] R. Kattimani, “Flask Login page web application | sqlite backend login verification,” YouTube, https://www.youtube.com/watch?v=X7KAEyRVhEk&t=931s (accessed Feb. 29, 2024).

[4] DayIsGreenDayIsGreen, “Load HTML first before Javascript,” Stack Overflow, https://stackoverflow.com/questions/51300809/load-html-first-before-javascript (accessed May 27, 2024).

[5] Ian BrownIan Brown et al., “How to set input type date’s default value to today?,” Stack Overflow, https://stackoverflow.com/questions/6982692/how-to-set-input-type-dates-default-value-to-today (accessed Feb. 9, 2024).

[6] F. S. Oseberg, “Async await JavaScript tutorial – how to wait for a function to finish in JS,” freeCodeCamp.org, https://www.freecodecamp.org/news/async-await-javascript-tutorial/ (accessed May 2, 2024).

[7] T. Barua, “Message flashing in Flask,” Code 360 by coding ninjas, https://www.naukri.com/code360/library/message-flashing-in-flask (accessed Apr. 10, 2024).

[8] K. Singh, “How to modify a text file in python,” AskPython, https://www.askpython.com/python/built-in-methods/modify-text-file-python (accessed Mar. 21, 2024).

[9] A. Dyouri, “How to make a web application using flask in python 3,” DigitalOcean, https://www.digitalocean.com/community/tutorials/how-to-make-a-web-application-using-flask-in-python-3 (accessed Feb. 21, 2024).

[10] MozDevNet, “: The HTML select element - HTML: Hypertext markup language: MDN,” MDN Web Docs, https://developer.mozilla.org/en-US/docs/Web/HTML/Element/select (accessed Feb. 9, 2024).