Skip to main content

Vacancy Details

Grade: 09

1 Choose the ONE answer that best describes your education and experience. Answer to this question is required
  • EXPERIENCE: I have at least 1 year of specialized experience equivalent to at least the grade 7 level in the Federal service as described below.
  • EDUCATION: I have a master's or equivalent graduate degree (such as an LL.B or J.D., if related) or two full years of progressively higher level education.
  • I possess a COMBINATION of graduate level education as described above beyond the first full year of graduate education, and specialized experience as described below, that together meet the qualification requirements for this position.
  • I do not meet any of the requirements as described above.

Specialized experience is assisting in developing, organizing, and managing data to track and report on procedures, programs, or operations.

2 Choose the statement that best describes your highest level of experience organizing, managing, compiling, and maintaining management reports. Answer to this question is required
  • I have not had the education, training or experience in performing this task.
  • I have had specific training or education directly related to this task, although I have not performed this task on the job.
  • I have performed this task on the job with assistance from a team leader, supervisor or other employee to ensure compliance with proper procedures.
  • I have performed this task on the job independently with approval of the final product by a team leader or supervisor.
  • I have performed this task on the job independently without the need for approval of the final product by a team leader or supervisor.
3 Do you use Microsoft Access in your current job? Answer to this question is required
  • Yes
  • No

Grade: 11

1 Choose the ONE answer below that best describes your education and/or experience regarding the qualifications for this grade 11 administrative and management position. Answer to this question is required
  • EDUCATION: I have a Ph.D. or equivalent doctoral degree or 3 full years of progressively higher level graduate education leading to such a degree (or LL.M., if related). Such education demonstrates the knowledge, skills, and abilities necessary to do the work.
  • EXPERIENCE: I have at least 1 year of specialized experience at or equivalent to the grade 9 level or above in the Federal service as described below.
  • I have a combination of graduate level education (as described above) and specialized experience (as described below), that together meet the qualification requirements for this position.
  • I do not meet any of the requirements described above.
Specialized experience is assisting in developing, organizing, and managing data to track and report on the administration, investigation, and litigation of criminal and civil matters.
2 I have conducted research and analyzed data in order to: (Select all that apply) Answer to this question is required
  • Track program goals, deadlines, and other milestones.
  • Monitor compliance with program goals, deadlines, and other milestones.
  • Provide horizontal and vertical reporting output on program monitoring.
  • Evaluate completeness and accuracy of data, and identify data gaps.
  • None of the above.
3 Have you used automated databases (such as Microsoft Access) to provide routine and ad hoc reports on data, including financial and statistical reports, producing graphical and quantitative summaries of the results and supporting documentation? Answer to this question is required
  • Yes
  • No

Grade: 12

1 Do you have one year of specialized experience equivalent to at least the GS-11 level or above in the Federal service? Answer to this question is required
  • Yes
  • No
Specialized experience is experience developing and managing data through the use of Microsoft Access to track and report on the administration, investigation, and litigation of criminal and civil matters.
2 I have conducted research, analyzed data and made program recommendations in order to: (Select all that apply) Answer to this question is required
  • Track program goals, deadlines, and other milestones.
  • Monitor compliance with program goals, deadlines, and other milestones.
  • Provide horizontal and vertical reporting output on program monitoring.
  • Evaluate completeness and accuracy of data, and identify data gaps.
  • Develop and present written recommendations for greater program efficiency or effectiveness.
  • None of the above.
3 Select the one answer choice that best reflects your ability to manage and organize information from specialized data sources. Answer to this question is required
  • I have gathered simple information based on requests of others such as retrieving letters from files upon request.
  • I have gathered or created simple information based on requests of others and organized it based on predefined guidelines such as entering data into a database.
  • I have gathered and made determinations on how to organize moderately complex information based on requests of others, including creating tables, charts, or graphs to organize information.
  • I have identified information needs as well as gathered and organized moderately complex information in an electronic database (such as Microsoft Access), created tables, charts, or graphs using the information in the database.
  • None of the above.

Grade: All Grades

1 I have assisted in gathering, compiling, and evaluating data for the purpose of:(Select all that apply) Answer to this question is required
  • Tracking and reporting on program expenses and income/recoveries.
  • Making recommendations to management regarding staffing.
  • Monitoring and updating various required management reports associated with claim investigation or litigation.
  • Tracking the status of claims.
  • Providing historical data to management.
  • Ensuring the integrity and accuracy of reported data.
  • None of the above.
2 Select the response below that best describes your level of experience querying, analyzing, and presenting data to management. Answer to this question is required
  • I have had training or education directly related to these tasks.
  • I have performed these tasks on the job with assistance from a team leader, supervisor or other employee to ensure compliance with proper procedures.
  • I have independently performed these tasks with final approval from a team leader or a supervisor.
  • I have independently performed these tasks without the need for approval before presenting the data.
  • None of the above
3 Select the response below that best describes your experience preparing periodic reports used by senior management. Answer to this question is required
  • I have not had education, training or experience in performing this task.
  • I have had specific training or education directly related to these tasks, although I have not performed this task on the job.
  • I have performed these tasks on the job with assistance from a team leader, supervisor or other employee to ensure compliance with proper procedures.
  • I have performed this task on the job independently with approval of the final product by a team leader or supervisor.
  • I have served as a technical expert authority on these tasks, providing guidance or supervision to others because of my background.
4 Please select all of the following tasks that you have performed. Answer to this question is required
  • Prepared detailed analyses
  • Prepared management reports
  • Counseled and advised program managers
  • Provided administrative support services
  • Presented findings and made recommendations
  • None of the above
5 Select the one answer choice that best reflects your ability to manage and organize information from specialized data sources. Answer to this question is required
  • I have gathered simple information based on requests of others such as retrieving letters from files upon request.
  • I have gathered or created simple information based on requests of others and organized it based on predefined guidelines such as entering data into a database.
  • I have gathered or created moderately complex information based on requests of others to determine how to organize it. This may include creating tables, charts, or graphs to organize information.
  • I have identified information needs as well as gathered and organized the information such as creating a database for maintaining information for various professional liability matters.
  • I have been held responsible for maintaining a spreadsheet, graph, or database to accurately depict the current workload priorities of an office.
  • None of the above.
6 Select the response below that best describes your level of experience with Microsoft Access: Answer to this question is required
  • I have had training or education directly related to Microsoft Access.
  • I have used Microsoft Access on one or more occasions.
  • I regularly perform tasks using Microsoft Access, including maintaining and editing a database, and running reports.
  • In addition to regularly performing tasks using Microsoft Access, I have also created applications using Access.
7

Please select all of the following tasks that you have performed with Microsoft Access.  

Answer to this question is required
  • I have regularly updated data in an established Access database.
  • I have added fields or tables in an Access database.
  • I have created simple queries, forms, and reports in an Access database.
  • I have created complex queries in an Access database.
  • I have created an Access database without using a template.
  • I have copied data from another source into an Access table.
  • I have imported, appended, or linked data from another source into Access.
  • I am familiar with troubleshooting VBA code within an Access database.
  • None of the above.
8

Please select all of the following tasks that you have performed with Microsoft Excel

Answer to this question is required
  • I have regularly performed grouping, subtotals, and filtering functions in Excel.
  • I have regularly used formulas in Excel.
  • I have regularly used simple formatting functions in Excel (e.g., auto-fitting columns, adding rows and columns, adding borders).
  • I have regularly used advanced formatting functions in Excel.
  • I have used macros in Excel.
  • None of the above.
9 Are you a current or former Executive Branch political appointee who served on a political Schedule A or Schedule C appointment within the past 5 years? Answer to this question is required
  • Yes
  • No