(pressing HOME will start a new search)

 

Back Next

ASC Proceedings of the 26th Annual Conference
Clemson University Clemson, South Carolina
April 8,9,10l  1990              pp  91-94

 

A COURSE IN COMPUTER AIDED CONSTRUCTION MANAGEMENT (CACM)

 

Bruce L Yoakum

California State University- Chico

Chico, California

 

As computer aided construction management systems become more useful and economically feasible, it is increasingly important for the Construction Management graduate to be highly computer literate. Employers expect our grad­uates to be aware of the CACM systems available, to be able to use them effectively, and to make recommendations on the purchase of new software and/or hardware.

This paper will describe a new Computer Aided Construction Management (CACM) undergraduate course at California State University, Chico, whit was created to 1) better prepare the students for upper division CM coursework, 2) introduce them to a wide range of currently available construction specific software and hardware, and 3) better pre­pare them to use computer aided construction management tools in the workplace

 KEY WORDS: Computer Aided Construction Management, Construction Management education, microcomputers, computers.

 

INTRODUCTION

 

History of Computer Courses for CM Students

Through 1985, Construction Management (CM) students at Chico State were required to select from a typical set of programming courses offered by the Department of Computer Science. These courses gave students an introduction to writing simple computer programs in one of the standard programming languages, such as BASIC, COBOL, or FORTRAN. The objective was to provide the student with some working knowledge of a common programming language as well as some computer literacy. These courses usually con­sisted of two hours of lecture and two hours of lab per week.

In 1986 a management information systems course offered by the School of Business was added as an option in lieu of the more traditional computer programming courses offered by the Computer Science Department. This course also introduced computer programming, but was primarily directed at developing students utilization of management information systems software. The software used was Framework III, an integrated software, which incorporated spreadsheet, database management, and word-processor capabilities. This course also consisted of two hours of lecture and two hours of lab per week.

Need for the CM Computer Course

Although the computer courses were providing introduction to microcomputers most upper division CM students were not achieving the level of computer literacy needed to utilize the microcomputer for cost estimating, project planning and scheduling, and cost management courses. It became increasingly clear that the CM students were spending most of their study time in the CM computer lab trying to figure out the basic features of the spreadsheet and scheduling software, rather than using the computer as a tool to aid in solving construction problems. The exceptions were students who had learned the IBM disk operating system (MS-DOS) and other software, usually spreadsheet and cost estimating software, through an avenue other than the basic computer courses. These were the self-motivated students who used a computer at home or those who had operated one in the workplace. These students' exceptional degree of computer literacy indicated proficiency was related to time spent actually performing specific tasks, i.e. cost estimating, scheduling, etc. and solving problems using computers. By so doing these students had become familiar with 1) the op­erating system, 2) software, and 3) the hardware.

Further compounding the situation, because most students lacked computer literacy, most CM faculty were reluctant to introduce computer software into courses because of the long learning curve involved. Instructors need to know that students can quickly comprehend and use software so valuable class time is not spent teaching students how to use the computer.

As a result of the experience .cited above, the CM faculty decided to develop a basic microcomputer course within the Construction Management curriculum to better prepare CM students for future coursework and careers. The develop­ment of a course in Computer Aided Construction Management (CACM) was the result.

 

COURSE OBJECTIVES

 

The CACM course objectives were based primarily on

1)      the needs of the students as observed by the faculty,
2)      needs as dictated by upper division course requirements,
3)      needs indicated by employers and
4)      feedback from CM graduates

.The objectives follow:

  1. Develop a solid understanding of the IBM and IBM compatible disk operating system (MS-DOS).
  2. Develop an understanding of hardware architecture and provide an overview of the available hardware.
  3. Develop proficiency in the use of spreadsheet software.
  4. Introduce the use of database management systems.
  5. Develop proficiency in the use of a high-end word-processor.
  6. Introduce and demonstrate a variety of construction specific software and discuss criteria for selection of such software for the construction contractor.

 

COURSE FORMAT

 

Lecture and Lab Design

Our CM computer lab facility is housed in a normal-sized lecture room with five computers placed in the rear of the classroom and eight in an adjoining room. The computers are a mix of IBM PC's, XT s and AT's or compatibles. One of the computers was used for class demonstrations via a 25" monitor. A single one-hour lecture was conducted on Mondays for all 24 students and 2 three-hour lab sections were held each Tuesday and Thursday with 12 students per section, giving students seven contact hours per week. The students were given computer lab passes to allow them access to the lab 24 hours/day, 7 days/week since they frequently could not finish assignments during lab periods.

The lecture periods were a combination of lecture and software demonstration. As needed, the beginnings of some lab periods were used to complete lecture or demonstration topics. Where possible, upper division CM students with industry application experience demonstrated the construction specific software for the class.

Subject Matter

The course consisted of five modules. The first module (two weeks) covered an introduction to the computing environment which included basic terms, hardware, hardware architecture, and operating systems. The discussion of operating systems focused on the IBM and IBM compatible operating system, MS-DOS. The lecture and lab assignments were aimed at developing a good working knowledge of 1) the basic DOS commands and files, 2) the DOS nomenclature, 3) DOS's use of the storage media, 4) disk, file and directory names, 5) use of DOS s organizational structure using directories and subdirectories, 6) writing and using special files such as batch command files, 7) DOS's use of and access to executable files, and 8) some differences between versions of DOS. Lab assignments made use of Versions 3.0 through 3.3 of DOS, since these were the most common and trouble free versions.

The second module (five weeks) covered spreadsheets. The common features of computerized spreadsheets were discussed. The majority of the lecture and all lab assignments were based on the use of Lotus 1-2-3, Release 2.01. The spreadsheet lab assignments started out with step-by-step instructions for creating the first spreadsheet. The second phase required students to duplicate sample spreadsheets of increasing complexity. The final phase required students to use some advanced features of spreadsheets such as macros and data graphing with minimal written direction from the instructor.

The third module (one week) covered database management systems. This was an overview of the features and applications of computerized database management systems, both flat file and relational databases. dBASE IV was used for lab assignments to create a data base structure, a custom input screen and a printed report format.

The fourth module (three weeks) covered the features and use of word-processors. The lab assignments made use of WordPerfect 5.0 and were primarily step -by-step assignments emphasizing the use of the software's features.

The fifth module (three weeks) covered construction specific software. In this module we looked at specific software, most had been developed exclusively for the con­struction industry for such tasks as cost estimating and scheduling. We also spent some time looking at utility software such as file manager, file recovery, and backup software.

A lecture and lab schedule showing the topics and sequence is contained in Appendix A.

Course Materials

The students received a course syllabus and lecture/lab topic schedule at the beginning of the term. As new topics were introduced, students also received a copy of the lecture outline to assist with note taking and to help them identify key points in lectures and demonstrations.

Texts for the course were required for three of the five modules. We utilized books for the DOS, Lotus 1-2-3, and WordPerfect portions of the course. The books selected were paperback reference books available at most bookstores in the "Computer Reference" section. The books used are listed in Appendix B.

For the database management systems module, a handout developed by the University of Michigan Computer Center titled "Basic Concepts of Data Base Management" was used to supplement the lecture outline.

Other photocopy handouts such as magazine articles and excerpts from software documentation supplemented lecture material.

Lab assignments were given to students at the beginning of lab periods. These assignments were typed handouts except for most word-processor assignments which were taken di­rectly from the text.

Lab Activities

With the exception of software demonstrations at the end of the term, all lab assignments were "hands on". The amount of detailed step-by-step instruction varied with the task. The assigned work early in the term, when most of the students were unsure of themselves, tended to be more of the "follow the bouncing ball" type, as were most of the Word-Perfect exercises. The remaining lab assignments were specific as to results required, but determining the steps to get there was the students' responsibility. Some assignments included samples for the students to emulate.

Assignments were usually due at the beginning of the succeeding lab period; this provided adequate time for students to complete them. Many assignments were "doable" within the lab period for those students who had prior computer experience, but most students needed additional time.

Examinations

The students were given two midterms and a final examination. The first midterm covered DOS, the second covered Lotus 1-2-3, and the final was comprehensive with an emphasis on DOS and WordPerfect.

The exam questions were all objective. The midterms were a combination of closed book and open book while the final was all open book. The second midterm and final required the use of the computers to answer or at least verify an­swers to some questions.

All exams emphasized the recall of basic terms (particularly the DOS terms) and practical application of computers.

 

CONCLUSIONS

 

First Term Results

From 1) the writer's discussions with students, 2) feedback from other faculty, 3) exam and lab assignment performance, 4) students comments in an end-of-term questionnaire, and 5) the writer's observations, a list of the primary first term results evolved. This list follows:

1.         Although individual results varied, by the end of the term all students had become keyboard proficient, had developed a basic understanding of the MS-DOS operating system, and were able to use basic DOS commands and the DOS directory/subdirectory feature.
2.         The students learned some idiosyncrasies of the computers and printers in the lab, and they became confident in their ability to use unfamiliar equipment.
3.         They obtained a basic understanding of Lotus 1-2-3 and are now able to get around a spreadsheet without difficulty. At the end of the spreadsheet module, they were capable of setting up spreadsheets for future coursework and some were using them in concurrent courses.
4.         After the first week of the word-processor module, students were proficient enough to type their own term papers and other written assignments; and at the end of the module, they had a good grasp of the capabilities of currently available word-processing software.
5.         The students developed an understanding of the power of the computer and a feel for some of the software that is currently available, particularly software available for construction applications.
6.         Students demonstrated greater competence with software than those who had taken one of the Business or Computer Science courses. The last lab period provided an opportunity to compare the competence of upper division students who had another computer course with that of the students who had taken the CACM course. The final CACM lab period was dedicated to demonstrating the use of Primavera Project Planner which is also the software used in our planning and scheduling course. Since this software is installed on all computers in the lab, the students were shown some features of the software by operating the computer while I talked them through the process. All of the students in this final lab were able to move along very quickly and picked up the basic commands and keystrokes with very little difficulty. In contrast, since I also taught the scheduling and planning course, I was painfully aware of how difficult it was for those students who had taken one of the computer courses referred to previously to understand the most basic instructions to use the software. This would indicate that use of the computer in the scheduling and planning class should be much easier for these CACM students, ultimately resulting in their acquiring much higher skill in and understanding of CPM scheduling.

 Course Improvements

As with anything new we find some things we wouldn't change and others that could benefit from change. This course is no exception. Based on this writer's evaluation as well as feedback from the students, some suggestions for improvement follow:

1.         A third week of DOS inserted in the last third of the term would be very useful as it would help close the knowledge loop. Deciding where to start and what topic sequence to use in a course like this is difficult. It seems that one should learn the operating system first, but it doesn't make a lot of sense by itself. The operating system tends to be more understandable after one has spent time on the computer and developed minimal comfort with software. At the beginning, most students struggled with DOS, partly because the whole subject of computers was unfamiliar, and they didn't grasp the sig­nificance of the software's features. But, after spending a few weeks with Lotus 1-2-3, students began to develop a sense of the DOS features' uses.
2.         Two weeks rather than three weeks on WordPerfect appear to be sufficient and the use of exercises at the
3.         end of text chapters should be supplemented with additional assignments.
4.         One more week on database management. systems with the addition of a simple programming assignment would better demonstrate the power and capability of the high-end relational database management system software products currently on the market. dBase IV's screen and report generators used for the lab assignments had some bugs' which lead to frustrated students. (All part of the learning process.') The additional time spent on the topics should process students the opportunity to work through those problems successfully.
5.         A typing tutorial such as Typing Tutor should be available on the lab computers for students who come to the course without adequate typing skills. Some had little, if any, typing knowledge which slowed their pace in getting around the keyboard. Although many students had a typing course in high school, they had not done any typing m some time and needed a refresher. Establishing a minimum level of typing skill certainly would be helpful, but the lack such skill in most only required more time on their part and did not ap­pear to reduce their level of learning. Thus providing the opportunity for students to increase their own profi­ciency seems most appropriate.
6.         Students should actually perform the keystrokes rather than just watch a display on a remote monitor because they learn the use of software easier and faster when they are "at the keyboard" and "doing it" themselves. I believe the ideal teaching environment for this course is to have all students operating their own computer while viewing a large screen controlled by the instructor. The 25" demonstration monitor needs to be replaced with a video display device and overhead projector. This pro­vides a much larger image and allows students to be seated much further from the screen. Additionally, all computers need to be situated so that students can readily view the instructor's large display while remaining seated at their computer.

Final Comments

This course's objective was to improve CM students' com­puter proficiency and we believe that objective was achiev­ed. Students who took the CACM course immediately improved their performance in courses using computers. In addition, as more students gain proficiency, faculty will become less reluctant to introduce new software in those courses not currently using computers. Continuing to offer this course will result in better prepared students taking higher quality CM courses.

 

APPENDIX A

 

CACM Topic Schedule

WEEK 1

bulletLecture - Introduction, basics of computing & operating systems, MS-DOS commands
bulletLab #1 - Learn the lab equipment and the keyboard
bulletLab #2 - Learn DOS commands

 

WEEK 2 

bulletLecture - How DOS works, the data storage medium - diskettes & disk drives, disk and file names, directories & subdirectories, path, special files, batch files, versions of DOS
bulletLab #3 - Practice moving around the drives and
directories and naming files
bulletLab #4 - Create batch files, print ASCII files WEEK 3 Lecture - Introduction to spreadsheets, basics of moving around the spreadsheet, spreadsheet construction
bulletLab #5 - Practice moving around the Lotus 1­2-3 spreadsheet, saving and retrieving files
bulletLab #6 - Create a spreadsheet, entering data

 

WEEK 4 

bulletLecture - Appearance and function of the spreadsheet, printing the spreadsheet
bulletLab #7 - Improve the spreadsheet
bulletLab #8 - Print the spreadsheet on different size paper with different letter sizes

 

WEEK 5 

bulletLecture - The @ FUNCTIONS
bulletLab #9 - Build a Balance Sheet spreadsheet
bulletLab #10 - Build a parameter estimate spreadsheet

 

WEEK 6 

·        Lecture - Other 1-2-3 features

bulletLab #11 - Build a unit price bid spreadsheet
bulletLab #12 - Continue unit price bid

 

WEEK 7 

bulletLecture - 1-2-3 Macros
bulletLab #13 - Create macros
bulletLab #14 - Create macros

 

WEEK 8 

 Lecture - 1-2-3 graphs

Lab #15 - Create and print an XY Graph

Lab #16 - Complete spreadsheet assignments

 

WEEK 9

bulletLecture - Database management systems
bulletLab #17 - Create a database structure, index and sort database
bulletLab #18 - Create input screen and produce print­ed report

 

WEEK 10 

bulletLecture - Introduction to wordprocessors, Word­Perfect basic features
bulletLab #19 - Learn the keyboard
bulletLab #20 - Create, save, and edit a document

 

WEEK 11 

bulletLecture - Document retrieval, blocks, text format and enhancement
bulletLab #21 - Block text
bulletLab #22 - Format and enhance text

 

WEEK 12 

bulletLecture - Document format, print capability, seller, thesaurus, fist files, macros, file conversion, outlines
bulletLab #23 - Print and use speller, thesaurus and other options; list files

·        Lab #24 - Create an outline, import a 1-2-3 file into a WordPerfect document

 

WEEK 13 

bulletLecture - Other CALM software - file managers, backup and recovery utilities, quantity takeoff, estimating, job costing, scheduling
bulletLab #25 - Demo - QDOS II, Fastback, Norton Utilities
bulletLab #26 - Demo - Demo disks, estimating soft­ware

 

WEEK 14 

bulletLecture - Selection criteria for procurement of software and installation of new software on computers

·        Lab #27 - Demo - Timberline Precision Estimator

bulletLab #28 - Demo - Agtek Earthwork Quantity Takeoff

 

WEEK 15 

bulletLecture - Review

·        Lab #29 - Demo & use - Viewpoint scheduling software

bulletLab #30 - Demo & use - Primavera Project Planner

 

WEEK 16 

bulletFinal exam

 

APPENDIX B

 

Course Texts/References

1.         DeVoney, Chris MS-DOS User's Guide, Que Corporation, 1988.
2.         Jorgensen, Carolyn Mastering 1-2-3, SYBEX Inc., 1988.
3.         Stewart, Charles O. (III) Using WordPerfect, Que Corporation, 1988.
4.          Basic Concepts of Data Base Management, University of Michigan Computer Center.