This project utilized advanced lookup functions in Excel to analyze and display Texas Education Agency school performance data into an accessible and interactive Excel or Google Sheets comparison tool. Users can easily compare multiple schools side-by-side, making informed decisions about educational institutions through clean data visualization and intuitive design.
- Key Features:
- Side-by-Side Comparison: Compare multiple schools simultaneously with a clean, organized layout
- Interactive Search & Filter: Quickly find school performance metrics
- Interactive Data Display: Instant updates as users modify their selections
- Performance Metrics Visualization: Clear presentation of key educational indicators
- Clean User Interface: Minimalist design focused on usability and data clarity
- Technologies Used:
- Excel (advanced lookup functions, pivot tables, pivot charts, etc.)
- Google Sheets
- Data Processing and Preparation: Utilized various file formats and processes for cleaning and structuring the TEA dataset