Today, after I marveled at how the mail merge yesterday worked, I sourced book cover images and added what I think will be the last additions to my master spreadsheet. Tomorrow, I plan on trying to mail merge the cover images into the guides. I realize some of the links will likely have to be rebuilt since I'm working from two different computers, but the bulk of the work is done.
The spreadsheet has 67 rows and 75 columns.
(Did you know there's a way to easily count columns in Excel? =COLUMNS(range)
I'll also look at how I can best categorize these guides. I spoke with a colleague briefly today and I asked her, "When you want to find out information about a position, where do you look?" She told me she tends to look at the state's job posting page to get information about the position. We talked a little bit longer and I mentioned this project to her and how I'm trying to think of the best way to take a step back from position titles (which is typically how she locates position information) and come up with broader groupings. She said she would likely look for something by skills needed or interest area. For instance, since she's good at budgeting, she might look for positions that are related to budgeting if she doesn't know the exact position title.
Good food for thought.
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
Posts By Category