Fermé

More automation and easy reporting on our new training system

We are implementing a formal training system for our workplace. It has several elements, most of which have been created as Microsoft Excel files.

It is a lot of manual work to record employee training and assessment results, as well as report on progress. We would like a quote on updating our Excel files to achieve more automation and easy reporting.

We have done some testing using Adobe fillable PDF forms for people to track training and competency results, but it is time consuming and we’re unsure how to use the data collected from PDF.

The requirements can probably be met by using Excel but we’re open to using other methods like writing a database. However, we need to continue using JIBs in the format they have (Important Steps, Key Points, etc). Note that we have already created many JIBs using our current Excel template.

We have access to Windows tablet PCs with stylus pens which can be used by trainees and trainers. The solution has to be Windows based and hosted inside our network.

Elements of new training system.

- Job Instruction Breakdowns (training scripts for specific work tasks)

- Operator Development Plan (training plan for an employee, listing JIBs and other training materials to be completed for each work area or work machine)

- Master Development Matrix (overall record of employee training progress)

- Other training content hosted internally (e-learning videos, simulations)

Requirements for JIB:

- We want a master file that is blank where a trainer can add the specific Important Steps, Key Points and Reasons Why then save it as a specific JIB.

- Protect the Excel file from user data entry mistakes (possibly use a data entry form or protected fields).

- A Simple Standard Way of Operating which contains the training script of the JIB but we can add pictures to it and list hazards and control measures. This becomes a reference on how to do that job for employees in our factory.

- A Self Assessment form where the trainee can mark that they believe they are competent in each item.

- An Assessment form where a Assessor can mark the trainee as competent or not yet competent in each item.

- The trainee and assessor need to be able to sign off on being competent.

- Record this data in a way that can be easily reported on. For example, report on trainee John Smith’s competence in a specific JIB.

- Collate the data so we can report an overall competence for a trainee in a group of JIBs. These are normally grouped into a machine or process.

Site operational reporting requirements:

- As well as any data or reporting about JIBs, we’d like an easy way to report on how many employees are competent in each machine or process at our site.

Managing training plan requirements:

- We’d like an easy way to track training plans for each employee with a timeframe for completion.

- It would be nice to assign training tasks to people.

- It would be nice to be able have reminders on who is overdue for their assigned training times.

Compétences : Excel, Rédaction de Rapport

Voir plus : i need to redo a flyer with new information and a more sober and institutional style on white background, i need a new website i need you to design and build a landing page want a simple landing page with a, i need a new website i need you to design and build a landing page want a simple landing page with a image of a complete facenec, i need a new website i need you to design and build a landing page want a simple landing page with a image of a complete face(ne, hello though i am new here i have more than 3 years of experience as a professional graphic designer and have worked on many sim, sql server reporting automation, training experience manz automation, training job easy, devices automation training lahore, sql reporting automation, hp quality center automation tool training singapore, perl automation training hyderabad, microsoft action pack training assessments easy, free script training automation testing, portfolio reconciliation automation reporting derivatives, simple pictures easy describe, industrial automation training india, easy automation qtp loadrunner, automation programing training india

Concernant l'employeur :
( 0 commentaires ) Australia

N° du projet : #12670903

36 freelances ont fait une offre moyenne de 21 $ /heure pour ce travail

21 $ AUD / heure
(150 Commentaires)
6.7
erinkennedy

Hi, I would like to use my experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that you're satisfied. I'm really interested in Plus

22 $ AUD / heure
(122 Commentaires)
6.8
sheak

Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hear from you soon. Thanks!

27 $ AUD / heure
(140 Commentaires)
6.8
coolwriter30

I am a competent academic writer, with high lead times and turnaround time, proposal writer, masters level dissertation writer, PHD level dissertation and thesis writer, PHD defense PowerPoint presentation writer, argu Plus

22 $ AUD / heure
(60 Commentaires)
5.9
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus

26 $ AUD / heure
(82 Commentaires)
5.6
citijayamala

Expert in Excel, Excel formulas, and all excel functions, macros, lookup concepts. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Can complete on time with Plus

22 $ AUD / heure
(37 Commentaires)
4.9
ksriniravi

Greetings! Having driven Competency Development initiative myself for my department in my last full time job for a Fortune 100 company, it is really gladdening to see the level of detailed planning in your organizat Plus

20 $ AUD / heure
(35 Commentaires)
4.9
OwnersPride1

Hello I'm creative with superb writing skills and a passion for the job. I don't just get over projects but I always effort to deliver the best as per clients' requirements and leave them satisfied. Kindly give me more Plus

22 $ AUD / heure
(20 Commentaires)
4.7
ksinghrajeev

I would suggest to go for access and excel. If you have large user base then go for MS Sql server along with access and excel. I can do this work for you depending on your choice. Below are few examples of my wor Plus

22 $ AUD / heure
(7 Commentaires)
3.7
super2lao

Familiar interface and simple algorithm encourage your work. • Main Section: Website & Mobile 01Languages: Objective C , Swift , PHP, Java, SQL, HTML, CSS, JavaScript, C, C++, C#, • Web Frameworks: Laravel , Wordp Plus

21 $ AUD / heure
(1 Commentaire)
2.6
nevo1234

Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over Plus

27 $ AUD / heure
(4 Commentaires)
2.1
inspireplatinum

Using Excel and managing data is critical for my job, so am proficient with formulas and additionally can code. Have done HR and evaluation work as well, hence have some background understanding to your requirements. Plus

25 $ AUD / heure
(1 Commentaire)
0.7
22 $ AUD / heure
(1 Commentaire)
0.3
eClickApps

Hi, After reading your project description, I know I can help you! as we have worked on various projects similar to your requirements. ►►Please check some of our previous reputation below-- [url removed, login to view] Plus

15 $ AUD / heure
(1 Commentaire)
0.4
AlexIsha

A proposal has not yet been provided

22 $ AUD / heure
(0 Commentaires)
0.0
Attia12

A proposal has not yet been provided

16 $ AUD / heure
(0 Commentaires)
0.0
22 $ AUD / heure
(0 Commentaires)
0.0
Flohibbins

Hi, I think I may be able to assist you as I have run my own training both for a large corporate and my own company, so I am familiar with many of the tasks you require. This appears to be quite an intensive programme Plus

22 $ AUD / heure
(0 Commentaires)
0.0
LinkonDas

A proposal has not yet been provided

22 $ AUD / heure
(0 Commentaires)
0.0
epoxa

At the first glance your business task is definitely requires a database. All JIB-s (protected Excel or PDF forms) can be generated automatically from the information stored in the database. If to speak about all exis Plus

27 $ AUD / heure
(0 Commentaires)
0.0