Course Details
Course Details
Course ID
683
Course Name
Computer Spreadsheet Applications for Wastewater Treatment
Contact Hours
5.0
Approved Industry
Wastewater
Partner Name
Eastern Pennsylvania Water Pollution Control Operators Assoc., Inc.
Primary Contact
Marykay Steinman
office@epwpcoa.org
610 670 6072 Ext.
Website
Description
There are many areas of daily operations in a wastewater treatment plant that involves repetitive calculations and data management. The use of a spreadsheet can automate many of those tasks and provide an assurance of consistency in their calculations.
A spreadsheet can also be used to manipulate and graph data, thus giving the operator a tool to see their plant performance over a long period of time. This will allow the operator to spot trends.
A spreadsheet can also be used to schedule routine tasks using its date function and sorting ability. A operator can then automate routine maintenance work orders and maintain an equpment maintenance history at the same time.
Course Level
Basic thru Intermediate
Course Content
* Overview of the spreadsheet tool bar
* Basic commands such as opening files, saving files, entering formulas and basic functions
* Formatting cells, using multiple worksheets, graphing hyperlinks
* Students will work on individual projects throughout the day
Target Audience
Wastewater management/operation personnel
Training Format
Classroom