{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Job Post Template  Hourly","Job Post Template  Hourly (2)","Main Template Options"],"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 October, we have designed the Job Creation Template in excel to allow student employers to prepare now for the transition to Next Gen JobX. It includes all the fields in the new system, with required fields indicated with a red asterisk (*). "]
[]
["If you use the Job Post Template Hourly tabs in this document to write your position descriptions now, you will be prepared to copy/paste the information into JobX when you have access to the system this Fall. We hope that this helps smooth the process of job creation and posting as we transition to the new system this coming Fall/Winterim."]
[]
["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 Student.Employment.Office@dartmouth.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 @ Student.Employment.Office@dartmouth.edu "]

{"sheet":"Job Post Template  Hourly","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Field","Job #1","Job #2","Job #3","Job #4","Job #5","Job #6","Job #7"]
["Job Title*"]
["Job Category**"]
["Category description from Student Employment ** (choose corresponding number from selection above)"]
["Job Description*"]
["Job Requirements*"]
["Experience/Technical Skills Needed** Select all that apply"]
["Professional Competencies** Select all that apply"]
["Work Arrangement**"]
["Physical Work Location*\n(Building/room # or street address if not on campus)"]
["What is the primary work environment for this position?**"]
["What physical abilities does this job require?** Select all that apply"]
["Number of Available Positions**"]
["Anticipated Hours Per Week**"]
["For which terms do you wish this position to be available?** Select all that apply"]
["If job is not for full academic term(s), what is the need for this position?**"]
["Start Date*"]
["End Date*"]
["Should this be searchable as a short-term/one-time position?**"]
["Does this position require proficiency in a foreign language?**"]
["Minimum Academic Achievement Level**"]
["Pay Rate*","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site"]
["Funding Source*"]
["Is this job community service?**"]
["Type of Community Service** Select all that apply"]
["Is your position only available to students with Federal Work Study?**"]
["Primary Contact Person*"]
["Primary Contact Person Phone Number*"]
["Primary Contact Person Email*"]
["Secondary Contact*"]
["Secondary Contact Person Phone Number*"]
["Secondary Contact Person Email*"]
["Do you wish to collect online applications for this job?**"]

{"sheet":"Job Post Template  Hourly (2)","index":2,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Field","Job #1","Job #2","Job #3","Job #4","Job #5","Job #6","Job #7"]
["Job Title*"]
["Job Category**"]
["Category description from Student Employment ** (choose corresponding number from selection above)"]
["Job Description*"]
["Job Requirements*"]
["Experience/Technical Skills Needed** Select all that apply"]
["Professional Competencies** Select all that apply"]
["Work Arrangement**"]
["Physical Work Location*\n(Building/room # or street address if not on campus)"]
["What is the primary work environment for this position?**"]
["What physical abilities does this job require?** Select all that apply"]
["Number of Available Positions**"]
["Anticipated Hours Per Week**"]
["For which terms do you wish this position to be available?** Select all that apply"]
["If job is not for full academic term(s), what is the need for this position?**"]
["Start Date*"]
["End Date*"]
["Should this be searchable as a short-term/one-time position?**"]
["Does this position require proficiency in a foreign language?**"]
["Minimum Academic Achievement Level**"]
["Pay Rate*","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site","Questions Answered In Live Site"]
["Funding Source*"]
["Is this job community service?**"]
["Type of Community Service** Select all that apply"]
["Is your position only available to students with Federal Work Study?**"]
["Primary Contact Person*"]
["Primary Contact Person Phone Number*"]
["Primary Contact Person Email*"]
["Secondary Contact*"]
["Secondary Contact Person Phone Number*"]
["Secondary Contact Person Email*"]
["Do you wish to collect online applications for this job?**"]

{"sheet":"Main Template Options","index":3,"n_rows":73,"n_cols":6,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Dartmouth Hourly Job Categories","Description","Experience/Technical Skills Needed:","Professional Competencies Needed:","Work Arrangements","Time Frame for this Job:"]
["Arts (1)","(1) May include some or all of the following duties: working with, creating or supporting visual, technical, or performance arts; serve as gallery attendant; install/remove exhibits and maintain gallery spaces; operate film, slide, video, computer display and audio systems for theater or film productions;  musical vocal or instrumental performance; studio modeling; perform curatorial services;  stage/props management; maintain art studio(s); instructing/guiding in woodshop or pottery studio; providing logistical support for musical recitals/theater performances; prepare props and scene-related materials for rehearsals and performances; scene design; costume design; schedule and oversee rehearsals and performances, provide information to visitors and callers, etc.","American Red Cross Certification for CPR","Active Listening","In Person","Summer "]
["Athletics/Fitness (2)","(2) May include some or all of the following duties: work with athletic teams or within athletic facilities; provide instruction for athletic/fitness/recreational classes, lessons, or programs;  assist in sizing, maintaining, and renting athletic equipment; monitor use of and clean equipment/machines;  enforce gym protocols and safety policies; attend team practices; assist coaches with workouts; assist with equipment needs; attend meetings; drive to/from practices/races/competitions; facilitate communication between athletes and coaches; administrative duties, etc.","American Red Cross Certification for First Aid","Adaptable","Hybrid","Summer/Fall Interim"]
["Campus Services (3)","(3) Work within central campus services such as parking (patrol and monitor parking areas, issue citations, respond to inquiries); mail services (sort mail/packages, forward mail, calculate postage, maintain records and inventory); Environmental Heath, Safety, and Security (maintain public-access AED program, provide BLS event coverage, campus emergency planning/response, community environmental health education, CPR/First Aid instruction)","American Red Cross Certification for Lifeguard","Analytical/quantitative skills","Remote","Fall"]
["Child Care (4)","(4) May include some or all of the following duties: supervise and monitor the safety and care of children/youth in variety of settings; engage children in developmental and literacy activities; maintain clean classroom/child care facilities, etc.","App/Game Development (C#, Rust, JavaScript, Python, SQL, NoSQL, etc.) ","Client Service",null,"Winterim"]
["Marketing/Communications (5)","(5) May include some or all of the following duties: develop and distribute communication content using variety of formats, which may include print, video, audio, web content, podcasts, social media; coordinate and develop campaign and promotional elements (posters, banners, table tents, quizzes, info tables); administrative duties (email/phone/mail correspondence, storing/organizing/maintaining files, edit documents), etc.","Bilingual or Multilingual","Collaborative",null,"Winter"]
["Computing/Media/Tech Services (6)","(6) May include some or all of the following duties: set up/operate technical equipment; provide technical assistance and support for issues related to computer systems, software, and hardware; digitize and encode multimedia assets; maintain daily performance of IT/computing systems; respond to inquiries in person, over the phone, via email or video chat; administrative duties (email/phone/mail correspondence, storing/organizing/maintaining files, edit documents), etc.","Communications tools (presentation, video, written, etc.)","Commitment to incusion and diversity",null,"Winter/Spring Interim"]
["Food Service (7)","(7) May include some or all of the following duties: food serving, sandwich making, cleaning tables, washing dishes, portioning desserts and cut fruit, restocking, operate cash register, food prep, catering event set up/clean up, complete opening or closing procedures for dining area, etc.","Competent in several laboratory methods, procedures and techniques as well as equipment and instruments","Communication skills (verbal)",null,"Spring"]
["Libraries  (8)","(8) May include some or all of the following duties: assist patrons to locate library materials; answer electronic and in-person queries/making appropriate referrals; check items in and out of the library; shelve books and other materials; retrieve materials from stacks; monitor the facilities; open/close the physical spaces; scan articles from books and journals; file; search databases; book binding/repair; assist in preservation of library materials; index publications, etc.","Design (Adobe InDesign, Adobe Illustrator, Adobe Photoshop, Canva, PaintShop Pro, etc.)","Communication skills (written)",null,"Spring/Summer Interim"]
["Events/Programming (9)","(9) May include some or all of the following duties: plan, organize, market, execute, host, and evaluate events, programs, conferences or workshops;  provide logistical support and direct services to participants/attendees; respond quickly and effectively to resolve concerns or issues that arise in course of event or activity; engage with guest speakers/lecturers; oversee/coordinate event space set-up, technical equipment, clean-up, etc.","Experience working in an athletic environment/has an athletics background","Conflict Resolution"]
["Office/Administrative Support (10)","(10) May include some or all of the following duties: copy, scan, and file documents; prepare materials for distribution; create and work with databases; greet guests; answer phone calls, emails and other correspondence; make appointments; compile data and reports; maintain office equipment and supplies; data entry; general assistance with departmental needs; distribute office mail; miscellaneous office tasks and other projects as needed. ","Food industry experience","Creative thinking"]
["Other (11)","(11) See position description for details","Google Suite applications (Docs, Sheets, Forms, Gmail, and Slides)","Critical thinking"]
["Outdoor Conservation/Sustainability/Nature (12)","(12) May include some or all of the following duties: trail maintenance; energy conservation projects; renewable resource enhancement; forestry, nursery, cultural operations; conservation, rehabilitation, maintenance, and improvement of wildlife habitat, rangelands, parks, and recreation areas; assist in efforts to reduce climate change, work on environmenal issues or sustainability; planting, weeding, harvesting plants, etc.","Microsoft Suite applications (Word, Excel, Outlook and Power Point)","Decision making"]
["Research (13)","(13) May include some or all of the following duties:  use of laboratory equipment; set-up and observation of experiments/tests; work with chemicals; preparation of manuscripts; performing literature searches; data analysis, etc.","On-line literature and research searches","Delegation and Shares Responsibility"]
["Retail (14)","(14) May include some or all of the following duties: perform inventory and restocking, manage fiscal and retail transactions, cleaning, providing information to customers, completing opening/closing procedures, etc.","Photo/video (taking, editing, and publishing)","Detail oriented"]
["Teaching Assistant/Tutor (15)","(15) May include some or all of the following duties: grade papers, lead class discussions, manage class equipment, attend classes/labs, provide academic assistance to students outside of class, take class notes, provide individual or group tutoring in a particular subject or course, prepare instructional materials for tutoring session, etc.","Project Management (budgeting, project planning, risk management, task management)","Diplomacy"]
[null,null,"Retail experience ","Dispute Resolution"]
[null,null,"Scheduling and event planning","Efficiency"]
[null,null,"Social media platforms (Facebook, Twitter, Instagram, blogs, etc.)","Empathy"]
[null,null,"Statistical data analysis (SAS, STRATA, SPSS, MATLAB, etc.)","Empowers others"]
[null,null,"Video editing (iMovie, Camtasia, Adobe Premiere Pro, etc.)","Evaluation skills"]
[null,null,"Web development (HTML, CSS, PHP, JavaScript, WordPress, etc.)","Facilitative communication"]
[null,null,null,"Finanacial analysis"]
[null,null,null,"Flexiblity"]
[null,null,null,"Following Instruction"]
[null,null,null,"Forward thinking"]
[null,null,null,"Goal Setting"]
[null,null,null,"Independence"]
[null,null,null,"Influence"]
[null,null,null,"Initiative"]
[null,null,null,"Innovative"]
[null,null,null,"Interpersonal skills"]
[null,null,null,"Leadership"]
[null,null,null,"Logical Thinking"]
[null,null,null,"Maintain Confideniality"]
[null,null,null,"Management skills"]
[null,null,null,"Mentors and Coaches"]
[null,null,null,"Multitasking"]
[null,null,null,"Negotiation"]
[null,null,null,"Networking"]
[null,null,null,"Open-minded"]
[null,null,null,"Patience"]
[null,null,null,"People Focus"]
[null,null,null,"Persistence"]
[null,null,null,"Persistent"]
[null,null,null,"Personal motivation"]
[null,null,null,"Persuasion"]
[null,null,null,"Persuasive communication"]
[null,null,null,"Planning/Organizational skills"]
[null,null,null,"Positive Impact"]
[null,null,null,"Problem Management"]
[null,null,null,"Problem solving"]
[null,null,null,"Professionalism"]
[null,null,null,"Public Speaking"]
[null,null,null,"Punctuality"]
[null,null,null,"Quality Focus"]
[null,null,null,"Quick thinker/learner"]
[null,null,null,"Relationship building"]
[null,null,null,"Reliable"]
[null,null,null,"Research and investigative skills"]
[null,null,null,"Resiliance"]
[null,null,null,"Resourcefulness"]
[null,null,null,"Respectful"]
[null,null,null,"Results driven"]
[null,null,null,"Self Motivation"]
[null,null,null,"Strategic-minded"]
[null,null,null,"Strong work ethic"]
[null,null,null,"Supportive"]
[null,null,null,"Team building"]
[null,null,null,"Team Collaboration"]
[null,null,null,"Time Management"]
[null,null,null,"Work Independently"]
[null,null,null,"Writing skills"]