luiscollado26 at gmail dot com
Hunter SoE ISTE Standard Mapping - in summer of 2024 I worked with the Hunter School of Education Frankfort Center for Learning and Scholarly Technologies to build a website that would present survey data collected by the CUNY Hunter College School of Education in an intuitive and user-friendly way. The data represented the extent to which each course and course sequences had implemented the ISTE Standards for Computing in Education into curricula. Courses' adherence to the standards was presented within the context of a course sequence, so that administrators could see the pace of the "learning arc" of a single standard across many semesters. Involved web scraping, data cleaning, templating, and creating dynamic elements that also adhere to WCAG standards and use semantic elements to display data while adhering to accessibility requirements. Mostly Python and Javascript.
Crop-It! (2024 - present) - made possible through a grant from the Library of Congress Teaching with Primary Sources Program, Crop-it! is an activity where teachers give students a picture and prompts, and students crop parts of the picture to answer teacher prompts. Made as part of the Agile Teacher Lab team. Crop-it is under active development and maintenance, and we use data from teacher and student use of crop-it to develop new research and further refine crop-it. PHP, SQLite, Javascript, Python for analyzing data.
In this video, a teacher enters the URL of an image that they would like students to analyze using crop-it. The teacher selects the questions and thinking prompts for the student, and then generates a unique link for students to work with.
Create your own crop-it here.
In this video, a student completes the activity created in the video to the left. The student uses the zoom functionality, answers questions by cropping the picture, and responds to thinking prompts with the Notes feature. At the end of the activity, the student can print their crops and written responses to turn in to the teacher.
Play this crop-it here.
Hours of Sunlight - In Spring of 2024 I served as an expert witness asserting the maximum amount of sunlight that basketball courts in a fieldhouse would receive through their windows. Using the dimensions of the floor, the latitude and longitude of the fieldhouse, its orientation, the height and dimensions of the windows, and conventional constants and approximations for the eccentricity of Earth's orbit and the effective angle of the sun to the horizon, I was able to determine whether a specific point on the fieldhouse floor was receiving sunlight at any given time of day. This project brought me through a cool mix of astronomy, trigonometry, Python optimizations, and matplotlib
documentation. Below was the cumulative product, a day-by-day representation of each square foot of the fieldhouse floor's UV exposure over the course of a year. It was cool to watch the math account for the eccentricity of the earth's orbit and create different length shadows inside of the simulation.
Post-its - a virtual Post-it implementation. Useful for making seating charts, class groupings, and other tasks that benefit from spatial sorting. Originally was hosted on Replit with a bunch of PHP/SQLite code for you to host your own instance and have a database of saved postits. You can see that repo here.
Morning Meeting - During Morning Meeting, a short SEL check-in about which animal you are feeling like can be the perfect start to your day. A different student every day picks the comparison animal and every student chooses one animal that best describes them. Clicking the same button twice shuffles the options.
Bingo Card Maker - A fork of this website for making bingo cards for multiplication practice (I used it mainly with 3rd graders).
Sierpinski's Triangle - an implementation in Processing.js of a self-generating Sierpinski triangle for triangles that the user can resize (not only equilateral triangles.) User can modify how large the "dots" that populate the triangle are. Bigger dots reveal the pattern faster, smaller dots reveal a more finely-detailed pattern.
Letter Frequency Distribution - An interactive website that shows in real-time what the letter frequency distirbution is for typed text. This was used for a cryptography-related elective that was using the tool to break simple caesar ciphers.
Last updated April 2025