Updating the Master Course List

The master course list is a spreadsheet that catalogs information about all of the training products we currently have available. We regularly update it to reflect the creation of new training materials as well as changes to existing training materials.

The web department uses this spreadsheet to create a database for our course catalog. Employees in every department, as well as resellers and affiliates outside the company, can use the course catalog as a resource.

Understanding the Content

The information on the master course list is organized within an Excel spreadsheet which has six main tabs across the bottom:

- Master: contains the collective information from the other five tabs 
- Online: contains information on all of our online training courses
- Kit: contains information on all of our DIY kits
- TTT: contains information on all of our Train-the-Trainer courses
- Video: contains information on all of our full-sized video courses
- Pre-Op Inspection: contains information on all of our pre-shift inspection courses

Rows

The rows in each spreadsheet correspond to different training topics. The training topic's official name is listed in the first cell of each row. The information in the other cells in the row corresponds to that specific training topic.

Important: Any time you use the name of a training topic on the website, drives, or LMS, it must be spelled as it is listed on the master course list. Notify the appropriate department if you find and/or fix naming discrepancies.

Columns

Each column in the spreadsheet corresponds to a particular detail about our training courses. While most of this information is displayed using regular text, some of it is displayed using HTML code. 

The information in each column is as follows: 

- Course Name: the training topic's official name
- Type: the type of product it is (OL, Kit, TTT, Video)
- OSHA (Y/N): do we have an OSHA version of the topic—yes or no?
- CAN (Y/N): do we have a Canada version of the topic—yes or no?
- CAL (Y/N): do we have a Cal/OSHA version of the topic—yes or no?
- SPAN (Y/N): do we have a Spanish version of the topic—yes or no?
- OSHA Standards: the U.S. standards that the course complies with
- CAN Standards: the Canadian standards that the course complies with
- CAL Standards: the California standards that the course complies with
- US Price: the price of the OSHA version in USD
- CAN Price: the price of the Canada version in CAD
- CALOSHA Price: the price of the Cal/OSHA version in USD
- SPAN Price: the price of the Spanish version in USD
- Alternate Names: the other names that the training topic might commonly be called in our drives and on the internet
- Topics Covered: the main topics covered in the training 
- Category: the category that the topic is categorized under on the website
- Duration: the approximate length of time it takes to complete the training
- Expiration: the length of time the certificate is valid following completion of the training
- Date of Creation: the date the course was first uploaded to the LMS
- Date of Translation: the date the translated version of the course was first uploaded to the LMS
- Last Website Update: the date the training was last updated on hardhattraining.com 
- Last OSHA LMS Update: the date the OSHA online course was last updated on Talent
- Last CAN LMS Update: the date the Canada online course was last updated on Talent
- Last CALOSHA LMS Update: the date the Cal/OSHA online course was last updated on Talent
- Last SPAN LMS Update: the date the Spanish online course was last updated on Talent
- Last Audit: the date that the quality assurance department last audited the training 
- What Changed in Last Update: any major changes that learning development made to the course
- Version Differences: notable differences between the OSHA, Canada, and Cal/OSHA versions

Adding New Entries

Each cell of the spreadsheet must be formatted correctly in order to make it populate accurately in the Course Catalog. The web department specifically coded the database to work only if we have all the same rows and columns on each sheet.

Because of this, when you add a new entry to the master course list, you will need to add a new row for the training to each tab (excluding master) even if the training topic doesn't correspond to a product in that particular category.

• A new course titled Tower Crane would need to be added to the Online, Kit, TTT, Video, and Pre-Op Inspection tabs, even though Hard Hat Training doesn't have a video or pre-operation inspection version of that training. The Tower Crane topic must occupy the exact same row number on each sheet, as well. 

Note: Prevent coding errors by matching the formatting of new spreadsheet entries to other information in that column.

Locating Information for the Master Course List

You may occasionally need to track down information for older courses because the master course list is missing information or is inaccurate. Here are some suggestions for where to search for specific pieces of information. 

- Course Name: Course naming is a collaborative effort between quality assurance, learning development, and web development, so you should talk to learning development and the SEO specialist in the web department.
- Version: Look for each different version on the computer drives first, then go to Talent, and finally check the website. If the version is on one of these three platforms, it should be on all of the others. If this is not the case, make note and speak to learning development and web development. 
- Standards: Check the standards slide in the PowerPoint file. If there are no standards or there seems to be a problem with the standards, speak to learning development.
- Price: Check the Talent course price first and then verify that the website reflects that price. If you notice any discrepancies, talk to learning development and web development. 
- Alternative Names: Search our computer drives for versions of the training with different names, then search the training name on Google. You should be looking for any alternate names that are clearly distinct from the original name. You can ignore slight variations in names. 
- Topics Covered: Open the PowerPoint and copy the main module topics,
- Category: Check the website or speak to the web department. 
- Duration: Estimate based on slide count (100 slides equals roughly 45 minutes)
- Expiration: Check certificates on Talent or look at the certificate JPEGS
- Date of Creation: Download a .csv file from Talent by going to the courses menu and clicking the "Save as CSV" button next to the search bar at the bottom of the page. It will be the dates listed under "Created on" in the CSV. 

- Date of Translation: Download a .csv file from Talent by going to the courses menu and clicking the "Save as CSV" button next to the search bar at the bottom of the page. It will be the dates listed under "Created on" for any Spanish courses in the CSV. 
- Last Website Update: Speak to the web department to get access to their records.
- Last LMS Update: Download a .csv file from Talent by going to the courses menu and clicking the "Save as CSV" button next to the search bar at the bottom of the page. It will be the dates listed under "Last updated on" in the CSV. 
- Last Audit: Speak to the quality assurance manager and check their records.
- What Changed in Last Update: Speak to the person who updated the training (if possible).
- Version Differences: Open the OSHA online version of the PowerPoint. Click the Review tab at the top of the screen. Click Compare, then locate another online version of the same course and click Merge. This will open a menu on the right showing which slides between the two versions have difference.