from slis to our careers n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
From SLIS to Our Careers PowerPoint Presentation
Download Presentation
From SLIS to Our Careers

Loading in 2 Seconds...

play fullscreen
1 / 23

From SLIS to Our Careers - PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on

From SLIS to Our Careers. April 30, 2012 SLIS S-511. Group Members. Katherine Harmeyer – Database Analyst Patrick Heisel – Technical Lead Stephanie Pike – Documentation Alan Rhoda – Documentation and Team Lead. Project Description. Our client : SLIS Career Services Office (CSO)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'From SLIS to Our Careers' - giacomo-herrera


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
from slis to our careers

From SLIS to Our Careers

April 30, 2012

SLIS S-511

group members
Group Members

Katherine Harmeyer– Database Analyst

Patrick Heisel– Technical Lead

Stephanie Pike – Documentation

Alan Rhoda – Documentation and Team Lead

project description
Project Description
  • Our client: SLIS Career Services Office (CSO)
  • Focus: SLIS online jobs database (http://www.slis.indiana.edu/careers/students.html)
  • Current database limitations:
  • Limited search functionality
  • Poor recall on keyword searches
  • Limited usefulness for career prep
project description1
Project Description

We think we can do better. Our proposed solution requires:

  • Additional tables for career types (positions), skill sets (skills), and SLIS courses
  • Controlled vocabularyfor positions and skills

Our solution will provide:

  • Better recall
  • Filtering by career type (position)
  • Career prep guidance

All with only minimal additional requirements for data entry.

database flow diagram
Database Flow Diagram

The revised database will affect information flow in two ways:

Job entry

Search and browsing of job postings

We’ll diagram these processes separately.

job entry
Job Entry

BEFORE

BEFORE

AFTERaddition shown in grey

search browse1
Search / Browse

AFTER

additions / changes shown in grey

preliminary functionality goals
Preliminary Functionality Goals

Minimally, the system should enable users to:

  • Browse all recent job listings
  • From a single job posting, find similar job postings and identify its associated career type (position), skills associated with that career type, and which SLIS courses provide training in those skills
  • From a career type, find all job postings of that type, associated skills, and related SLIS courses
full functionality goals
Full Functionality Goals

Eventually, we would like a database interface that enables users to:

  • Discover, from a SLIS course, the skills taught in that course, careers that emphasize those skills, and recent job postings related to those careers
  • Discover, from a given skill, which SLIS courses provide training in that skill, which careers emphasize it, and recent job postings related to those careers
user centered design decisions
User-Centered Design Decisions
  • Keep the appearance of the interfacesimilar to the familiar current SLIS interface
  • Keep data entry requirements similar to current
    • CSO staff do not have time for elaborate data entry
    • Hence, we only require the one additional step of associating each job posting with a position type
  • Enhance search functionality by enabling filtering by position type
  • Display related job, position, skill, and course information on the same page for easy cross-referencing.
business rules
Business Rules

The database requires four main entities (job, position, skill, and course) and three bridge tables (job_position, position_skill, and course_skill).

  • Each job has at least one job_position.Each job_positionbelongs to exactly one job.
  • Each position can belong to any number of job_positions.Each job_position belongs to exactly one position.
  • Each position has at least one position_skill.Each position_skill belongs to exactly one position.
  • Each skill has at least one position_skill.Each position_skill belongs to exactly one skill.
  • Each skill belongs to at least one course_skill.Each course_skill belongs to exactly one skill.
  • Each course has at least one course_skill.Each course_skill belongs to exactly one course.
assessment
Assessment
  • Validation of database against objectives
    • Database allows the user to view all recent job listings
    • Users can find similar job postings using a fuzzy search and/or position search
    • Users can find information on generic position types
    • Users can use the database to determine what courses to take and what skills each course develops
    • The database centralizes the storage of SLIS job postings
assessment1
Assessment
  • Weaknesses & limitations
    • Certain data about job postings is not stored in individual columns
    • Skills are linked to jobs through courses through positions.
    • International jobs are listed as “international” in the state (hold over from current SLIS database)
assessment2
Assessment
  • Possible future changes and upgrades
    • Add columns to the job table to accommodate additional data (e.g., employer contact information)
    • Implement columns and queries to sort jobs by type:full time, part time, internship, etc.
    • Add field for country to address international jobs issue