top of page

Identify issues for NGOs and local businesses, then work with new friends from Hong Kong to solve them together.

Screenshot 2024-10-21 at 5.58.57 PM.png
Screenshot 2024-10-22 at 10.32.42 AM.png

Client's Problem

CICS, a Canada-based non-profit government organization founded in 1968, provides services and aid for migration, childcare, and training. The Centre of Learning, one of its platforms, offers tutorial courses for children, youth, adults, and retirees. The center relies heavily on Microsoft Forms and Excel for essential tasks such as course registration, managing children's profiles, course tracking, and email communication. However, the manual processes have led to frequent errors and wasted time in daily operations, prompting the need for a customized automation solution integrated with Microsoft Forms and Excel to streamline workflows and boost efficiency.

Challenges

Pain points in the manual process

1. Data Fragmentation in Excel-Data Integration
2. Inefficient data retrieval - Data Presentation
3. Disjointed View for Decisions - Search Function

Timeline

Our Team

Week 1.

Analyze Client's pain point

General Scope of Work

Individuals' Timeline

Week 2.

- Agile Workflow

- Developers merging data

- UX/UI Wireframes & Prototype

Week 3.

- Fine Tune

- Run Tests

- Presentation

Project Manager

Front-end Developer

Back-end Developer

UX/ UI Designer

Screenshot 2024-10-22 at 4.50.28 PM.png

Our Solution

- Customized AI Service for data processing

- Structured data fed into dashboard

- Encapsulate dependency

- Flexible and scalable

- AI-powered data management Dashboard

Fitness

Problem Statement

The absence of a unified dashboard hindered staff from effectively tracking and analyzing critical student, course, and payment data, necessitating the design of an intuitive, comprehensive MaterialUI-based interface to centralize and streamline information management.

My Focus

- Data Presentation -

Multiple Registration

Student registering for multiple classes or Summer camp weeks are combined into the same grid in Excel

Identification Challenges

This consolidation makes it difficult for staff to identify each registration separately

Dashboard Screens

Here are some screens I have created for the Dashboard

© 2024 by Ekata Ma. All Rights Reserved.

bottom of page