MATTHEW DYER, MLIS
  • Home
  • Video Interviews - New!
  • MLIS Portfolio & Practicum
    • Portfolio
    • MLIS Practicum >
      • Internship Log
  • Download Résumé
  • Contact

Daily Logs

Day 12: Formulatin'

9/20/2016

 
September 20, 2016 (Tuesday), 12:15PM-2:30PM
Hours completed: 2h 15m
Accumulated on-site hours completed: 53h 45m
Accumulated off-site hours completed: 2h 15m

Total Hours Accumulated: 56h

Spent time today scrubbing data from the classification database data dump (18,580 rows in a CSV file), and browsing template options. 
My "master" spreadsheet now lists the following columns, thanks to a few VLOOKUP formulas:
  • Job Code
  • Pay Grade
  • As Of Date
  • OBM Total Positions
  • Statewide Total Positions
  • Job Title
  • Classification Concept Statement
  • Series Purpose Statement
  • Status (BU or Exempt)
  • Competency 1
  • Competency 2
  • Competency 3

Comments are closed.

    Practicum Objective

    To map available State Library of Ohio resources to the 27  job  competencies impacting the 66 job classifications and 253 employees at the Ohio Office of Budget and Management.

    Posts By Month

    November 2016
    October 2016
    September 2016
    August 2016

    Posts By Category

    All
    Daily Log
    Final Assessment

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • Home
  • Video Interviews - New!
  • MLIS Portfolio & Practicum
    • Portfolio
    • MLIS Practicum >
      • Internship Log
  • Download Résumé
  • Contact