Intro

This fully-functioning training and educational program hosted on TalentLMS was developed to teach entry-level project management employees how to create and use data visualizations in Microsoft Excel in order to communicate business insight and make data-informed business decisions.

Link / Enroll / View

Visit the following link to enroll in and view the course:

https://noeysun.talentlms.com/catalog/info/id:126

Knowledge

  • Bloom’s taxonomy (revised)
  • Adult learning theory
  • Permissions and licenses
  • Backward design (Understanding by design)
  • UDL Principles
  • Design theory and principles
  • Basic image editing

Skills and Responsibilities

  • conducting a Learner and Needs Analysis
  • determining instructional problems and defining learning goals
  • applying Bloom’s taxonomy to create learning objectives and tasks
  • alignment of learning tasks, objectives, assessments, and goals
  • instructional design for training and development
  • eLearning development
  • storyboarding
  • visual design
  • TalentLMS course creation and administration

Tools

  • Canva for graphic editing
  • Google Docs for storyboarding
  • Microsoft Excel for learning material creation
  • TalentLMS for course creation and LMS hosting

What is the training and development issue?

Audience

The target group consists of newly-hired entry-level project management employees. The employees work at an organization that specializes in creating E-learning solutions for K-12 and higher education. Their age ranges from early twenties into late forties, and many of the employees have associate’s or bachelor’s degree in business administration, marketing, and even communications. Several employees also don’t have degrees but have previous experience in customer-facing and administrative roles.

Motivations and Issues

Professional development, process improvement, and efficiency are major motivations for learning new concepts. Many new-hires are familiar with the basics of data visualizations and how to generate them using spreadsheet software, but many of them are unsure if they are using them effectively.

The team leads feel there isn’t any time to train new-hires on using important spreadsheet functions and visualization principles, and as a result the new-hires are worried they may not learn the skills and knowledge they need to improve as workers. They know there are many tutorials available on the internet, but they’re not sure of all topics necessary to develop their skillset and would prefer a company representative or learning specialist guide them. They also prefer to learn asynchronously in a digital environment. 

Instructional Problem

For this particular e-learning module, learners aren’t familiar with the best data visualization practices and spreadsheet functions necessary to communicate data to stakeholders and colleagues in an efficient, effective, and ethical manner.

The solution?

Considering the learners’ needs for guidance and flexibility (both in terms of pace and scheduling), as well as the general topic surrounding data visualizations and communication, we created an hour long, asynchronous learning module that utilizes active learning tasks and scenario-based problems to allow learners to apply their knowledge and skills in realistic situations.

How I came to this solution

This section is currently being drafted for publication.

Image Samples of the Learning Module