Ash (Project Lead): Skills, Tasks

CST Project Lead
Participated in project from Stage 2 to Stage 7
(CST Project Stages)

Technologies & Tools learned and applied

  • Google Cloud Platform -- Cloud hosting, Google software tools
  • Python-Django -- web application language and tools
    1. Creating a server
    2. Setting up the front-end
    3. Connection to a remote database
    4. Deployment
    5. API request
    6. Object-oriented Programming
  • BLS.gov -- job and career statistics, data source
  • PostgreSQL -- database management
  • Asana -- Project Mangement


Soft Skills learned and applied

  • Technical Leadership
  • Team building
  • Mentoring
  • Collaboration
  • Delegation
  • Task Management
  • Communication of Technical Information
  • Documentation of process


Primary Tasks

  1. Researched Database Technologies
  2. Lead for researching web application technologies
  3. Lead for the Django vs. Flask discussion
  4. Represented STEM-Away at Santa Clara Convention Event for outreach
  5. Lead for new project management organization and task delegation
  6. Lead for the python-django web app and virtual environment setup and deployment to Google Cloud Platform
  7. Co-Lead for “Weekly All-Team Meetings”
  8. Lead for coding the database schema (models.py) and coding the script to populate database tables
  9. Lead for embedding charts into the web app and Lead for CST admin
  10. Lead for web app comments, documentation


Tasks by stage highlighted below:

  • Stage 1: Getting Started
  • (June 2019)
    1. Researching prior work in this area
    2. Identifying technical requirements
    3. Identifying logistical requirements
    4. Creating organizational system for CST documents (Google Drive)
    5. Project Specifications document


  • Stage 2: Team Assembly
  • (June 2019)
    1. Recruiting. Team is a mix of interns and other students.
    2. Information meetings
      1. Understanding STEM-Away
      2. Understanding CST
    3. Project management tool
      1. Initial set of tasks identified and entered


  • Stage 3: Group Discussion and Assigning Responsibilities
  • (July 2019)
    1. First All-Team Meeting
    2. Assigning Tasks
    3. Researching
      1. Google Cloud Platform
      2. Data sources (API’s)
      3. Database technologies
      4. Web App technologies
      5. Visualization Tools
    4. Team Discussions
      1. Django or Flask (web app)
      2. BLS, CareerOneStop, Indeed API, Glassdoor API, or something else (data sources)
      3. PostgreSQL or mySQL (database)
      4. Data Studio, Pandas, Google API’s, Big Query, a combination, or something else (visualization)


  • Stage 4: Career Fair and The New Asana
  • (July 2019)
    Note: By now the whole team understands STEM-Away’s mission and the details of our specific project. We have researched, discussed, and decided which options suit the project best.
    1. Showcasing STEM-Away at Santa Clara Convention Center
    2. Asana, new project management structure created
    3. Weekly All-Team Meetings


  • Stage 5: Prototyping p.1
  • (August 2019)
    1. Creating the Python-Django virtual environment and web application skeleton
    2. Deploying to GCP
    3. Choosing/Researching visualization chart types
    4. Dashboard UI Prototype
    5. Making a request to BLS API
    6. Weekly All-Team Meetings


  • Stage 6: Prototyping p.2
  • (August 2019)
    1. Decoding BLS API URL codes
    2. Chart prototypes
    3. ERD
    4. Choosing BLS Data
    5. Designing the database schema
    6. Coding the database schema in the web application(models.py)
    7. Manual data entry (phase 1)
    8. Coding Script to pull data into our database tables (phase 2)


  • Stage 7: Present Day
  • (September 2019)
    1. Checking that the data persists and is accurate
    2. Final chart prototypes
    3. Embed charts into web application
    4. Written Work
      1. Database design documentation
      2. Python-Django app documentation & comments
      3. CST Admin
    5. Deciding future project goals
      1. Forum Integration
      2. Scripting all manual parts
      3. Machine learning