{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","BC template options","Example Job","Job 1","Job 2","Job 3","Job 4","Job 5"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["How to Use the Job Creation Template:"]
["While users will not have access to the system prior to July 1, 2024, we have designed the Job Creation Template in excel to allow supervisors to prepare now to enter their recalibratied jobs in JobX. It includes all the fields in the new system, with required fields indicated with a red asterisk (*). "]
[]
[]
[]
["Here are some keys to ensure that the spreadsheet is easy to use:"]
["·         When opening this template, make sure to enable macros if prompted. "]
["·         Double blue asterisks (**) indicate that there is a dropdown list with predetermined responses to be selected. Please choose from the available items as follows: "]
["1.     Click on the cell that you are trying to fill."]
["2.     Click the arrow on the bottom right of the selected cell to prompt the dropdown menu "]
["3.     From the dropdown menu, select from the listed options. Choose what best fits the necessary information. Once you click on an option, the cell will populate with that response. "]
["a.     To delete responses: Click on the field and hit backspace or delete on your keyboard. "]
["b.    For Select all that apply prompts: Repeat these steps as many times as needed to include multiple selections."]
[]
["Other important reminders:"]
["·         Each column is formatted for one job. You may compile the details for up to 7 job listings on each tab filling in successive columns to the right.  If needed, you can duplicate the sheet to create more."]
["·         Your response in the category description field is based upon your response in the job category field. Please select the number in the Job Description field that corresponds to the number from the Job Category field "]
["·       Please contact Lifeworks@berry.edu with any questions"]
[]
["Feedback:"]
["We welcome your feedback! Do you find the prompts confusing? Self-explanatory? Are we missing vital options in the drop-down menus? Do you have concerns about this job description template? Reach out and let us know @ Lifeworks@berry.edu"]

{"sheet":"BC template options","index":1,"n_rows":126,"n_cols":7,"rows_kept":126,"cut":false,"hidden":true,"merged":[]}
["Departments","Job Categories","Position Classification","Time Frame for this Job:","Career Readiness","Technical Skill","Soft Skill"]
["Academic Affairs","Accounting / Finance ","Entry","Academic Year","Entry: Professionalism: Demonstrate dependability (e.g., report consistently, and on time, for work or meetings). Communication: Write in a way that conforms to the basic principles of spelling, grammar, and punctuation; Promptly inform relevant others when needing guidance with assigned tasks. Teamwork: Listen carefully to others, taking time to understand and ask appropriate questions without interrupting. Build strong, positive working relationships with supervisor and team members/coworkers. Equity and Inclusion: Treat other people, including those of different backgrounds, beliefs, and gender, with fairness and respect. Keep an open mind to diverse ideas and new ways of thinking. ","Account Management","Accountable for Results"]
["Academic Services","Agricultural Operations","Intermediate","Summer ","Intermediate: 1. Professionalism; 2. Communication; 3. Technology; 4. Teamwork; 5. Critical Thinking; 6. Career & Self-Development; 7. Equity and Inclusion","Accounting","Adaptability and Flexibility"]
["Academic Support Center","Animal Care / Services","Advanced","Fall","Advanced: 1. Professionalism; 2. Technology; 3. Critical Thinking; 4. Leadership","Accounting Software","Assertiveness"]
["Admissions","Artistic Performance (Music, Theatre, Dance, etc)","Pre-Professional","Spring","Pre-Professional: 1. Critical Thinking; 2. Leadership","Accounts Payable","Attention to Detail"]
["Advancement - Administration","Athletic / Fitness Training","Graduate Assistant",null,null,"Accounts Receivable","Build Partnerships"]
["Advancement - Annual Giving","Athletic support / operations",null,null,null,"Acquisitions","Collaboration"]
["Advancement - Campaign & Leadership","Childcare",null,null,null,"Addition and Subtraction","Commitment"]
["Advancement - Operations","Data Analytics",null,null,null,"Administrative","Communicate Effectively"]
["Advancement - Stewardship","Event Planning/Setup ",null,null,null,"Analytics","Competitiveness"]
["Alumni Center","Facilites services (Skilled trades)",null,null,null,"Application Programming Interface (API)","Conceptual Thinking"]
["Animal and Plant Sciences","Facilities services (Grounds, Housekeeping, etc)",null,null,null,"Archival Collections","Confidence"]
["Aramark","Food Services / Preparation",null,null,null,"Auditing","Cooperation"]
["Art","Fundraising",null,null,null,"Big Data Analysis","Courtesy"]
["Athletic Administration","Hospitality / Guest Services",null,null,null,"Bilingual or Multilingual","Creativity and Innovation"]
["Auto Shop","IT / Computing",null,null,null,"Bookkeeping","Critical Thinking"]
["Basketball - Men'2","Laboratory Support ",null,null,null,"Budgeting","Customer Focus"]
["Basketball - Women's","Marketing/Communications",null,null,null,"Business Analysis","Decision Making"]
["Baseball","Media Production (Video, photography, etc) ",null,null,null,"Business Process Modeling","Deductive Reasoning"]
["Beef Cattle","Office / Administration",null,null,null,"Carpentry","Delegation and Shares Responsibility"]
["Berry Center for Integrity in Leadership","Other (C&I)",null,null,null,"Cataloging","Determination"]
["Berry Elementary School","Other (On Campus) ",null,null,null,"Cloud Networking","Development and Continual Learning"]
["Berry Student Enterprises","Peer Coaching / Advising",null,null,null,"Communication","Diplomacy"]
["Biology","Program Management / Coordination",null,null,null,"Competitor Research","Dispute Resolution"]
["BOLD","Recreation Services",null,null,null,"Computer Technology","Efficiency"]
["Bonner Center - Enrichment","Research",null,null,null,"Construction","Empathy"]
["Bonner Center - Leadership","Residence Assistance",null,null,null,"Content Management Systems (CMS)","Enthusiastic"]
["Bonner Center - Service Learning","Sales / Retail",null,null,null,"Contract Management","Following Instruction"]
["Bonner Center for Community Engagement","Teaching / Tutoring",null,null,null,"CPR","Goal Oriented"]
["Bonner Scholars Program","Tour Guide / Docent",null,null,null,"Customer Relationship Management (CRM)","Goal Setting"]
["Bookstore","Writing / Editing",null,null,null,"Customer Service","Improvisation"]
["Business Office",null,null,null,null,"Data Analysis","Independence"]
["Business, Dean's Office",null,null,null,null,"Data Entry","Influence"]
["Cage Center",null,null,null,null,"Data Mapping","Initiative"]
["Campbell School of Business",null,null,null,null,"Data Mining","Interaction with People"]
["Camps and Conferences",null,null,null,null,"Database Management","Interpersonal Skills"]
["Campus Carrier",null,null,null,null,"Deliverable Management","Leadership Presence"]
["Campus Outreach",null,null,null,null,"Digital Archiving","Listening"]
["Campus Programs",null,null,null,null,"Digital Information Management","Logical Thinking"]
["Campus Safety",null,null,null,null,"Digital Marketing and Branding","Manage Conflict"]
["Campus Scheduling",null,null,null,null,"Digital Preservation","Mentors and Coaches"]
["Career Center",null,null,null,null,"Digital Printing","Negotiation"]
["Center for Instructional Technology",null,null,null,null,"Document Management","Networking"]
["Center for Teaching Excellence",null,null,null,null,"Drafting","Nonverbal Communication"]
["Central Stores",null,null,null,null,"Educational Software Platforms","Open Minded"]
["Chaplain's Office",null,null,null,null,"Electrical Engineering","Patience"]
["Chemistry",null,null,null,null,"Electrical Technology","People Focus"]
["Child Development Center",null,null,null,null,"Employee Relations","Persistence"]
["Classic Fare Catering",null,null,null,null,"Enterprise Resource Planning ","Persuasion"]
["College Bowl",null,null,null,null,"Expense Reports","Positive Impact"]
["College Shop",null,null,null,null,"Filing and Paper Management","Problem Management"]
["Communication",null,null,null,null,"Financial Investment","Problem Solving"]
["Computer Science",null,null,null,null,"Financial Projections","Professionalism"]
["Counseling Center",null,null,null,null,"Gallery Management","Public Speaking"]
["CPPD Dean's Office",null,null,null,null,"Gathering Information","Punctuality"]
["C-SEED",null,null,null,null,"General Business Knowledge","Quality Focus"]
["Dairy",null,null,null,null,"Graphic Design","Resourcefulness"]
["Dance ",null,null,null,null,"Graphic User Interfaces (GUI)","Respectful"]
["Dean of Students Office",null,null,null,null,"Infographics","Results Oriented"]
["Diversity and Belonging",null,null,null,null,"Information Security","Self Confidence"]
["E Comm Svcs",null,null,null,null,"Interactive Media Design","Self Motivation"]
["Education & Human Sciences - Dean's Office",null,null,null,null,"Learning and Development","Team Collaboration"]
["English Rhetoric and Writing",null,null,null,null,"Logo Creation","Time Management"]
["Enrollment Management - Operations",null,null,null,null,"Managing Timelines","Trust"]
["Enrollment Management Office",null,null,null,null,"Marketing and Branding","Verbal Communication"]
["Environmental Compliance and Sustainability",null,null,null,null,"Marketing Campaign Management","Work Independently"]
["Environmental Sciences",null,null,null,null,"Marketing Plan Development","Written Communication"]
["Environmental Studies",null,null,null,null,"Marketing Research"]
["Equestrial Team",null,null,null,null,"Mathematics"]
["Faculty Research",null,null,null,null,"Mechanical"]
["Financial Aid",null,null,null,null,"Media Engagements"]
["Fitness",null,null,null,null,"Mobile Development"]
["Food Service",null,null,null,null,"Negotiation"]
["Football",null,null,null,null,"Network Administration"]
["Forensics",null,null,null,null,"Network Security"]
["Gate Scholarship Program",null,null,null,null,"Numerical Competence"]
["General Expense - Switchboard",null,null,null,null,"Nursing"]
["Geology",null,null,null,null,"Operating Systems"]
["Golf - Men's",null,null,null,null,"Optimization"]
["Golf - Women's",null,null,null,null,"Organizational Structures"]
["Government and International Studies",null,null,null,null,"Paperwork and Record-Keeping"]
["Graduate Studies - MED",null,null,null,null,"Patient Care and Assistance"]
["Grounds - Athletic Field Maintenance",null,null,null,null,"Photo Editing "]
["Grounds - House O'Dreams",null,null,null,null,"Photography"]
["Grounds - Main Campus",null,null,null,null,"Physical Space Management"]
["Grounds - Mountain Campus",null,null,null,null,"Pipefitting"]
["Grounds - Oak Hill",null,null,null,null,"Planning and Organizing"]
["Guest Cottages",null,null,null,null,"Preservation"]
["Gunby Equine Center",null,null,null,null,"Process Improvement"]
["History",null,null,null,null,"Processing Cash Transactions"]
["Honors Program",null,null,null,null,"Product Development"]
["Horticulture",null,null,null,null,"Programming Language"]
["Housekeeping - Main Campus",null,null,null,null,"Project Management"]
["Housekeeping - Mountain Campus",null,null,null,null,"Project Scheduling"]
["Human Resources",null,null,null,null,"Public Speaking"]
["Humanities - Dean's office",null,null,null,null,"Quality Assurance"]
["Information Technology",null,null,null,null,"Reference Materials"]
["Institutional Research",null,null,null,null,"Relationship Building"]
["Interdisciplinary Studies",null,null,null,null,"Research and Data Analysis"]
["International Programs",null,null,null,null,"Responsive Design Principles"]
["Kids College",null,null,null,null,"Revenue Recognition"]
["Kinesiology",null,null,null,null,"Risk Assessments"]
["Krannert Center",null,null,null,null,"Sales"]
["Lacrosse - Men's",null,null,null,null,"Sales Pipelining"]
["Lacrosse - Women's",null,null,null,null,"Scientific Computing"]
["Land Resources",null,null,null,null,"Search Engine Optimization (SEO)"]
["LifeWorks Operations Office",null,null,null,null,"Social Media Marketing"]
["Mail Services",null,null,null,null,"Software Development"]
["Math & Comp Science",null,null,null,null,"Statistical Analysis"]
[null,null,null,null,null,"Storyboarding"]
[null,null,null,null,null,"Studio arts"]
[null,null,null,null,null,"Systems Administration"]
[null,null,null,null,null,"Talent Acquisition"]
[null,null,null,null,null,"Tax Accounting"]
[null,null,null,null,null,"Team Building"]
[null,null,null,null,null,"Team Management"]
[null,null,null,null,null,"Technical Writing"]
[null,null,null,null,null,"Testing/Debugging"]
[null,null,null,null,null,"Trend Research"]
[null,null,null,null,null,"Typography: spacing, line height, layout, choosing fonts"]
[null,null,null,null,null,"User Interface Design"]
[null,null,null,null,null,"Video Production"]
[null,null,null,null,null,"Windows Operating System"]
[null,null,null,null,null,"Wireframes"]
[null,null,null,null,null,"Word Processing and Editing"]
[null,null,null,null,null,"Workforce Planning"]

{"sheet":"Example Job","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Field","Status","Field Type"]
["Job Classification**","Entry","Choose from dropdown"]
["Job Category**","Office / Administration","Choose from dropdown"]
["Job Title*","Administrative Assistant ","Freeform"]
["Career Readiness skills - based on position classification chosen**","Entry: Professionalism: Demonstrate dependability (e.g., report consistently, and on time, for work or meetings). Communication: Write in a way that conforms to the basic principles of spelling, grammar, and punctuation; Promptly inform relevant others when needing guidance with assigned tasks. Teamwork: Listen carefully to others, taking time to understand and ask appropriate questions without interrupting. Build strong, positive working relationships with supervisor and team members/coworkers. Equity and Inclusion: Treat other people, including those of different backgrounds, beliefs, and gender, with fairness and respect. Keep an open mind to diverse ideas and new ways of thinking. ","Informational only"]
["Technical Skills Needed** Select all that apply","Data Entry, Bookkeeping, Analytics, Customer Relationship Management (CRM), Customer Service","Choose from dropdown"]
["Job Description*","Department Summary:\nThe Administrative Assistant will join the Administrative Services department, which is dedicated to providing efficient and effective administrative support across various functions within the organization. The department's mission is to streamline processes, enhance productivity, and ensure seamless operations.\nPosition Summary:\nThe Administrative Assistant will play a vital role in supporting daily administrative tasks, contributing to the smooth functioning of the department. This entry-level position offers an opportunity to gain valuable experience in administrative functions and develop essential skills for future career advancement.\n\nEssential Functions:\n•\tAssist in managing departmental correspondence, including emails, letters, and memos.\n•\tMaintain and update departmental records and databases accurately.\n•\tProvide administrative support for meetings, including scheduling, preparing agendas, and taking minutes.\n•\tAssist with basic research tasks and compile information as required.\n","Freeform"]
["Job Requirements*","\n•\tStrong organizational skills with keen attention to detail.\n•\tProficiency in Microsoft Office Suite (Word, Excel, Outlook).\n•\tExcellent verbal and written communication skills.\n•\tAbility to prioritize tasks and manage time effectively in a fast-paced environment.\n","Freeform"]
["Physical Work Location*\n(Building/room # or street address if not on campus)","Krannert 320 (CPPD)","Freeform"]
["What is the primary work environment for this position?**","Office/Desk work","Choose from dropdown"]
["Number of Available Positions",2,"Freeform"]
["Anticipated Hours Per Week**","6-10 hours","Choose from dropdown"]
["Start Date*","2024-08-25"]
["End Date*","2025-05-10"]
["For which terms do you wish this position to be available?** Select all that apply","Summer ","Choose from dropdown"]
["Pay Rate*","System populated","System generated"]
["Primary Contact Person*","Phillip Edge"]
["Primary Contact Person Phone Number*","706.3XX.XXXX"]
["Primary Contact Person Email*","pedge@berry.edu"]
["Secondary Contact","Secondary Contact Name"]
["Secondary Contact Person Phone Number","706.3XX.XXXX"]
["Secondary Contact Person Email","secondarycontact@berry.edu"]
["Notes or Messages to LifeWorks office:","N/A","Freeform"]
["Do you wish to collect online applications for this job?**","Yes"]

{"sheet":"Job 1","index":3,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Field","Status","Field Type"]
["Job Classification**",null,"Choose from dropdown"]
["Job Category**",null,"Choose from dropdown"]
["Job Title*",null,"Freeform"]
["Career Readiness skills - based on position classification chosen**",null,"Informational only"]
["Technical Skills Needed** Select all that apply",null,"Choose from dropdown"]
["Job Description*",null,"Freeform"]
["Job Requirements*",null,"Freeform"]
["Physical Work Location*\n(Building/room # or street address if not on campus)",null,"Freeform"]
["What is the primary work environment for this position?**",null,"Choose from dropdown"]
["Number of Available Positions",null,"Freeform"]
["Anticipated Hours Per Week**",null,"Choose from dropdown"]
["Start Date*"]
["End Date*"]
["For which terms do you wish this position to be available?** Select all that apply","Academic Year","Choose from dropdown"]
["Pay Rate*","System populated","System generated"]
["Primary Contact Person*"]
["Primary Contact Person Phone Number*"]
["Primary Contact Person Email*"]
["Secondary Contact"]
["Secondary Contact Person Phone Number"]
["Secondary Contact Person Email"]
["Notes or Messages to LifeWorks office:",null,"Freeform"]
["Do you wish to collect online applications for this job?**"]

{"sheet":"Job 2","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Field","Status","Field Type"]
["Job Classification**","Entry","Choose from dropdown"]
["Job Category**",null,"Choose from dropdown"]
["Job Title*",null,"Freeform"]
["Career Readiness skills - based on position classification chosen**",null,"Informational only"]
["Technical Skills Needed** Select all that apply",null,"Choose from dropdown"]
["Job Description*",null,"Freeform"]
["Job Requirements*",null,"Freeform"]
["Physical Work Location*\n(Building/room # or street address if not on campus)",null,"Freeform"]
["What is the primary work environment for this position?**",null,"Choose from dropdown"]
["Number of Available Positions",null,"Freeform"]
["Anticipated Hours Per Week**",null,"Choose from dropdown"]
["Start Date*"]
["End Date*"]
["For which terms do you wish this position to be available?** Select all that apply","Summer ","Choose from dropdown"]
["Pay Rate*","System populated","System generated"]
["Primary Contact Person*"]
["Primary Contact Person Phone Number*"]
["Primary Contact Person Email*"]
["Secondary Contact"]
["Secondary Contact Person Phone Number"]
["Secondary Contact Person Email"]
["Notes or Messages to LifeWorks office:",null,"Freeform"]
["Do you wish to collect online applications for this job?**"]

{"sheet":"Job 3","index":5,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Field","Status","Field Type"]
["Job Classification**","Entry","Choose from dropdown"]
["Job Category**",null,"Choose from dropdown"]
["Job Title*",null,"Freeform"]
["Career Readiness skills - based on position classification chosen**",null,"Informational only"]
["Technical Skills Needed** Select all that apply",null,"Choose from dropdown"]
["Job Description*",null,"Freeform"]
["Job Requirements*",null,"Freeform"]
["Physical Work Location*\n(Building/room # or street address if not on campus)",null,"Freeform"]
["What is the primary work environment for this position?**",null,"Choose from dropdown"]
["Number of Available Positions",null,"Freeform"]
["Anticipated Hours Per Week**",null,"Choose from dropdown"]
["Start Date*"]
["End Date*"]
["For which terms do you wish this position to be available?** Select all that apply","Summer ","Choose from dropdown"]
["Pay Rate*","System populated","System generated"]
["Primary Contact Person*"]
["Primary Contact Person Phone Number*"]
["Primary Contact Person Email*"]
["Secondary Contact"]
["Secondary Contact Person Phone Number"]
["Secondary Contact Person Email"]
["Notes or Messages to LifeWorks office:",null,"Freeform"]
["Do you wish to collect online applications for this job?**"]

{"sheet":"Job 4","index":6,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Field","Status","Field Type"]
["Job Classification**","Entry","Choose from dropdown"]
["Job Category**",null,"Choose from dropdown"]
["Job Title*",null,"Freeform"]
["Career Readiness skills - based on position classification chosen**",null,"Informational only"]
["Technical Skills Needed** Select all that apply",null,"Choose from dropdown"]
["Job Description*",null,"Freeform"]
["Job Requirements*",null,"Freeform"]
["Physical Work Location*\n(Building/room # or street address if not on campus)",null,"Freeform"]
["What is the primary work environment for this position?**",null,"Choose from dropdown"]
["Number of Available Positions",null,"Freeform"]
["Anticipated Hours Per Week**",null,"Choose from dropdown"]
["Start Date*"]
["End Date*"]
["For which terms do you wish this position to be available?** Select all that apply","Summer ","Choose from dropdown"]
["Pay Rate*","System populated","System generated"]
["Primary Contact Person*"]
["Primary Contact Person Phone Number*"]
["Primary Contact Person Email*"]
["Secondary Contact"]
["Secondary Contact Person Phone Number"]
["Secondary Contact Person Email"]
["Notes or Messages to LifeWorks office:",null,"Freeform"]
["Do you wish to collect online applications for this job?**",null,"Choose from dropdown"]

{"sheet":"Job 5","index":7,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Field","Status","Field Type"]
["Job Classification**","Entry","Choose from dropdown"]
["Job Category**",null,"Choose from dropdown"]
["Job Title*",null,"Freeform"]
["Career Readiness skills - based on position classification chosen**",null,"Informational only"]
["Technical Skills Needed** Select all that apply",null,"Choose from dropdown"]
["Job Description*",null,"Freeform"]
["Job Requirements*",null,"Freeform"]
["Physical Work Location*\n(Building/room # or street address if not on campus)",null,"Freeform"]
["What is the primary work environment for this position?**",null,"Choose from dropdown"]
["Number of Available Positions**",null,"Freeform"]
["Anticipated Hours Per Week**",null,"Choose from dropdown"]
["Start Date*"]
["End Date*"]
["For which terms do you wish this position to be available?** Select all that apply","Summer ","Choose from dropdown"]
["Pay Rate*","System populated","System generated"]
["Primary Contact Person*"]
["Primary Contact Person Phone Number*"]
["Primary Contact Person Email*"]
["Secondary Contact"]
["Secondary Contact Person Phone Number"]
["Secondary Contact Person Email"]
["Notes or Messages to LifeWorks office:",null,"Freeform"]
["Do you wish to collect online applications for this job?**"]