Asee peer logo

A Case Study In Stoichiometry Course Using Excel And Power Point Presentation

Download Paper |

Conference

1997 Annual Conference

Location

Milwaukee, Wisconsin

Publication Date

June 15, 1997

Start Date

June 15, 1997

End Date

June 18, 1997

ISSN

2153-5965

Page Count

3

Page Numbers

2.3.1 - 2.3.3

DOI

10.18260/1-2--6442

Permanent URL

https://peer.asee.org/6442

Download Count

580

Request a correction

Paper Authors

author page

M. Hossein Hariri

Download Paper |

Abstract
NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Session 3513

A Case Study in Stoichiometry Course Using Excel and Power Point Presentation

M. Hossein Hariri Department of Chemical Engineering Rose-Hulman Institute of Technology Terre Haute, IN 47803

Abstract

Production of syngas from coal was considered as a case study project for the stoichiometry course. In this case study we showed the students how to divide a complex process such as above to smaller single units as the first step. The flowsheets of each single unit was drawn on a slide using Microsoft Power Point. Then we showed how to produce spreadsheets for the single units in an Excel workbook and link the spreadsheets together. With Power Point Presentation we could present the flowsheet of a single unit and switch to the corresponding Excel sheet for the calculations in a Windows 95 environment. The linkage of the spreadsheets are useful for parametric studies on the overall process.

Introduction

This case study was assigned to sophomore students in order to reinforce the material they learn in the stoichiometry course. The case study problem involves the production of syngas from coal1. The syngas produced in this case study is intended to be used downstream in the production of methanol.

A case study of this sort takes a considerable amount of time and effort from students. In the past case studies were either not assigned to students in stoichiometry class or the assignment came late in the term. The result was, therefore, a marginal engagement of students. In order to improve the situation, we decided to assign the project right from the beginning of the course. The intent was that the students can work on parts of case study as they make progress in the course. This requires a careful sequence of materials to be assigned. We designed a proper sequence assisted by spreadsheet format and Presentation slides. Application of spreadsheets in sophomore year not only helps students to improve their computation skills, but also facilitates scale up of the process as well.

Preparing the Case Study in an Assisted and Proper Sequence

The detail of the process of production of syngas from coal, which was the subject of case study, is given in the reference1. In this process ground coal is fed to a gasifier to react with oxygen at high pressure and temperature (in the order of 6000 kPa and 1000oC) to make syngas containing carbon monoxide, hydrogen, carbon dioxide and water vapor in

1

Hariri, M. H. (1997, June), A Case Study In Stoichiometry Course Using Excel And Power Point Presentation Paper presented at 1997 Annual Conference, Milwaukee, Wisconsin. 10.18260/1-2--6442

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 1997 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015