Kenna File Format Conversion Improvement

Case revision date: 
5 pages (Case Study)

The Kenna Group is a Toronto based corporation specializing in the delivery of sales and marketing solutions. Kenna provides services from the analysis and storage of client data to the creation of client websites. Kenna’s technology group provides programming and technology based services to in-house requests and its clients. Kenna sends out daily newsletters to subscribers. They receive the content of the newsletters as a Microsoft Publisher file.The information must be converted into HTML before sending out to subscribers. Kenna’s current solution for conversion involves copying and pasting text and tables manually from the Publisher file to the HTML editor. However, as there is incompatibility between Publisher and HTML, Kenna personnel must use a word processor to format the text before pasting into the HTML editor. This process is inconvenient, and Kenna wishes to find a more efficient conversion method.

Matt Books, a first year electrical and computer engineering co-op student from the University of Waterloo, was asked by Kenna’s technology group to investigate methods to improve the file conversion process for the daily newsletter, with the ultimate goal of developing an application that can perform the conversion automatically.

conversion process outline

Conversion process outline

Learning objectives: 

This case explores the improvement of file format conversion for a daily newsletter. Students will use the engineering design process to evaluate potential solutions, arriving at a conclusion and making a recommendation based on quantitative analysis.

Key words: 
Software life cycle; logic progression; Programming; Decision matrix
CEAB attributes: 
Problem Analysis; A knowledge base for engineering; Use of Engineering Tools
Module 01 – Case Study
Module 02 – Need Analysis
Module 03 – Design Alternatives
Module 04 – Design Analysis
Module TN – Teaching Note

Request This Case!

If you would like to see more information on this case study, click here

You can request this case study and a WCDE staff member will get back to you.