CIVE/INDE 1331 COMPUTING FOR ENGINEERS FALL 1997 Lecture: MW 1000-1050, W122-D3 Lab Section: You must be registered for one of the lab sections corresponding to this lecture section. Mon 12-2 PM, Tue 8-10 AM, Thu 7-9 PM Instructor: Dr. Christopher A. Chung, Dept. of Industrial Engineering, room D3-E213 tel. 743-4195, fax. 743-4190, email cchung@uh.edu Office Hours: It is my intention to be as accessible as possible to the students taking this class. In accordance, you may come by to see me any day, any time I am here and my door is open. You can also specifically arrange for an appointment. Description: Introduction to the computing environment; spreadsheets; matrix arithmetic, symbolic algebra tools, programming basics. Software used during this course includes Windows NT, Word, PowerPoint, Excel, Mathematica, Visual Basic, Netscape, Eudora, and WinQVT. CIVE1331 is intended for Chemical, Civil, and Industrial engineering students. Mechanical and Electrical engineering students should take the equivalent course as specified by their department. Prerequisites: Math 1431 Materials: Engineers Toolkit for Windows 95 and Mathematica, Spreadsheet Tools for Engineers, Excel 5.0, ISBN 0-07-024018-3 Visual Basic text is on order Grading: The final course grade will be based on three closed book/note exams, three projects, weekly laboratory exercise, a practical laboratory examination, and a laboratory notebook. The final course grades will be based on the following distribution: Exams (2) 30% Projects (2) 30% Proj 1=10%, Proj 2=20% Lab Exam 25% Lab Notebook 15% Total 100% Final grades will generally be curved around a B to B+. Very few of you who put forth a serious effort will receive a grade less than a B-. However, students who actively resist my efforts to educate them can expect to reenroll in a future semester. Attendance: You are expected to attend and participate in all lecture and laboratory sessions. Repeated absences will result in you being dropped from the course. Punctuality: It is my intention to instill the importance of meeting time performance requirements. As future engineers you will be expected to properly manage your time and submit all assignments, in class, on the due date. Late submissions will be penalized or not accepted at all. Exams: The closed book/note exams will generally consist of multiple choice, short answer questions, and computer code. You will be responsible for all material which has been presented or assigned prior to the exam. Make up exams will not ordinarily be permitted. Examples of exceptions are when you can document that you or an immediate family member (father, mother, sister, brother, spouse, or child) were in the hospital, court, or jail during the exam. Makeup exams may be written, oral, or practical. Honesty: The University’s Academic Honest Policy as outlined in the Student Handbook is in effect. Course Schedule: Week# WeekOf LectureTopic Comments 1 25-Aug-97 Admin Introduction, computer hardware problem solving Get computer account 2 1-Sep-97 Windows accessories, Word 3 8-Sep-97 Windows Excel Word, PowerPointIntroduction 4 15-Sep-97 Excel Functions 5 22-Sep-97 Excel Arrays, Matrix arithmetic 6 29-Sep-97 Excel linear regression, graphing 7 6-Oct-97 Excel Macros, review Exam 1 on 8 Oct 97 8 13-Oct-97 Visual Basic Introduction, variables, forms Proj 1 due 13 Oct 97 9 20-Oct-97 Visual Basic Controls, file input/output 10 27-Oct-97 Visual Basic Subroutines, functions 11 3-Nov-97 Visual Basic More Controls 12 10-Nov-97 Visual Basic Animation techniques, review 13 17-Nov-97 Mathematica Introduction Exam 2 on 17 Nov 97 14 24-Nov-97 Mathematica Functions, Statistical Process Control 15 1-Dec-97 Mathematica Graphing, review Lab Exam TBA PROJECTS 1. Introduction. There are three course projects which total 30% of your final grade. The project assignment sheet and data will be made available the week of the assignment. All of these projects require you to submit a written project report in addition to computer code on a 3.5 inch disk. Project assignments will be available from the following subdirectory on the engineering domain fish server: UHCOURSES\CIVE1331\FALL97\CHUNG\PROJECTS 2. Project Grading. The projects will be graded according to the following table. Technical requirements 50% Presentation requirements 20% Administrative requirements 10% Programming style 20% Total 100% 3. Technical Requirements. This is your ability to meet the technical requirements specified in the project assignment sheet. 4. Presentation Requirements. The report should be intelligible, neat, and free from grammatical, spelling, and formatting defects. It is to be organized in the general format. Title page Abstract - If you don’t know what it is find out! Table of Contents Introduction - with background information and formulas Problem statement Data - describe input and output Manual example Algorithm description and flowchart Solution code verification and validation Results Conclusions References Appendices Hard copy of input files Hard copy of output files Hard copy of program code or workbook cell formulas User instructions for code Project notes, hand written notes are acceptable in this appendix 5. Administrative Requirements. The report is to be submitted in a pressboard prong binder. Three ring binders are not acceptable. There is to be a label on the outside cover with the title of the assignment, the course number, your name, and the date. The 3.5 inch disk is to be attached inside the folder by a neat and secure means. The written report must be laser or inkjet generated 12 point Times-Roman or similar font print. All table of contents, equations, figures, flowcharts, and illustrations must be computer generated. Cut, paste, and photocopy is not acceptable. Your disk is to have report, source code, executable, workbook, input, and output files, as is applicable. The diskette must be labeled with the course number, project title, and your name. You are to scan your disks for viruses prior to submission. Any project submitted with a virus will automatically be penalized the complete administrative portion of the grade. 6. Programming Style. This is your ability to incorporate sound programming style. This specifically includes the use of mnemonic variables and labels, liberal program commenting, and an organized structure. GOTO statements should not be used. Lab 1. General. A lab assignment will be given each week. These assignments generally take the place of homework. The lab assignments will be available on the server at the beginning of each week. At the beginning of each lab session, you will be given an orientation to the lab by the TA. After the orientation, you are to work on the lab assignment. The lab report should include the assignment sheet, a summary of your results, any output, and your notes. It does not need to be as extensive as the project reports. Conversely, the project reports are to be more comprehensive than the lab reports. You may not complete each assignment during the laboratory meeting and may have to work on the exercises outside of the lab. You are to turn in the lab assignment to the TA at the beginning of the next session in a pressboard prong binder. When the labs are returned, keep them in a three ring binder. At the end of the semester, you will also receive a grade on your final notebook. There will be a two hour laboratory exam at the end of the semester. 2. Laboratory Schedule. Week# WeekOf Lab Topic 1 25-Aug-97 None No formal session, establish NT, VAX, NextStep accounts 2 1-Sep-97 Internet Internet apps, home page 3 8-Sep-97 Windows Word, Powerpoint, Paint, 4 15-Sep-97 Excel Excel Fundamentals 5 22-Sep-97 Excel Functions, Matrix arithmetic 6 29-Sep-97 Excel linear regression, graphing 7 6-Oct-97 Excel optimization 8 13-Oct-97 Visual Basic VB fundamentals 9 20-Oct-97 Visual Basic Controls 10 27-Oct-97 Visual Basic file input/output, printing 11 3-Nov-97 Visual Basic Subroutines, functions 12 10-Nov-97 Visual Basic Animation techniques 13 17-Nov-97 TBA TBA 14 24-Nov-97 Mathematica Introduction 15 1-Dec-97 Mathematica Functions Note: This syllabus may change due to extenuating circumstances. CIVE 1331 COMPUTING FOR ENGINEEERS LAB 1 - Setup Accounts - 25August 1997 1. Introduction. The objective of this lab to establish your Windows NT network account and your email / VAX account. These accounts are necessary for you to gain access to the computing facilities at the university. Both of these accounts are to be operational prior to the second week of class. 2. Deliverables. None. 1Computer Hardware In order to effectively use a computer it is important to have a knowledge of some of the important hardware which makes up the computer. One of the basic terms that is necessary to be familiar for discussing some of the hardware is the term "byte". The computer stores data and instructions in storage elements called bits. A group of eight bits is called a byte. Mother Board - All of the hardware elements plug into a main board called the Mother Board. Hard disk drive- User files and programs are stored in the computer on the hard disk. Technology in the area of hard disks has changed significantly in the last few years. In the early eighties when personal computers first started to become popular, the size of a hard disk for a computer was approximately 40 MB (mega bytes = 1,000,000 bytes). The sizes of hard disks has steadily been increasing over the years, however, the costs of these disks have decreased significantly over the last two years. Personal computers now come standard with 2.0-4.0 GB (Giga bytes = 1,000,000,000 bytes). 3.5 inch "floppy" disk drives - The term "floppy" originated with 5.25" disks which were relatively flexible. 3.5" disk drives have become the standard media for storing user files. The 3.5" disks have essentially replaced the 5.25" drives which were standard for several years. You can still get 5.25" drives, however the 3.5" drives are essentially the standard format. The 3.5" disks have capacities of 1.44 MB. Zip Disks - Compression disks which are more durable than "floppy" disks and can hold 100 MB of data. There are also drives which can hold up to 1 GB of compressed data. CD ROM Drives - CD ROM's have become standard hardware elements on personal computers. The speed of these drives have significantly increased in the last year. Current computers may come with 8X speed CD ROM's. Most current drives are "read only" drives, however "optical drives" are beginning to become more affordable. Optical drives allow reading and writing to CD's. A typical Optical disc can hold approximately 650 MB of data. DVD Drives - The latest technology in video/audio/data. The potential for data storage substantially exceeds conventional Optical (CD) discs. A single side - single layer of a DVD disc can hold 4.6 GB of data. The discs will probably eventually be double sided/double layered which will allow more than 17 GB per disc. The video is much better than conventional VCR tape and the audio capabilities have 5.1 channels which is better than conventional audio CD. RAM - The main memory of a computer is referred to as RAM. When you begin using the computer and starting programs and opening user files, the computer loads the programs into RAM which is fast memory that stops the computer from having to access the hard drive for information. Most computers now come standard with 16 MB RAM, however 32 MB RAM or higher are also used on PC's. Large servers may have hundreds or even GB's of RAM. CPU - The part of the computer that performs operations on the data which is stored in the memory of the computer is called the "central processing unit" (CPU). The technology of the CPU's for personal computers has changed dramatically over the several years. The older technologies of PC chips have been called 286, 386, or 486's. The latest technologies is actually a 586 chip, however it is usually referred to as a pentium chip. Pentium chips are also coming in a Pentium Pro format as well as dual processor configurations. These forms of the Pentium are designed for better performance of file servers or "number crunching" machines. When discussing the speed of a particular chip we also often refer to the "clockspeed" of the chip. This refers to the speed that the chip operates at. The clockspeed is referred to as a 166 Mhz (megahertz) Pentium. In addition to the above hardware items, different "cards" are also necessary to help the computer interface with elements such as the monitor (computer screen), and possibly a "network". Two such cards that would be used are a video card for the graphics, and an ethernet card that will interface with a "network". A "modem" may also be used to interface with phone lines to allow the user to call up a computer system from a remote location. Computer Software In contrast to "hardware", software generally consists of executable programs that provide instructions to be conducted by the CPU. The most fundamental piece of software consists of the "operating system" which allows us to interface with the computer. DOS - Original PC's (IBM compatibles) predominantly made use of DOS (Disk Operating System). In the mid-1980's there began to be a push to the Window's environment which was similar to the operating system on Macintosh computers. More recent versions of Windows have actually become the operating system. The new Windows operating systems still provide "DOS Prompt" applications, however these systems are actually emulating the DOS environment. Windows - The Windows environment provides a "Graphical User Interface" (GUI) that allows the user to navigate on the computer by pointing at objects on the screen with a device such as a mouse. The nice feature of a true Windows operating system is that it permits "multi-tasking" which means the user can perform different operations simultaneously. We can open several pieces of software and switch back and forth between the programs. The latest versions of Windows for PC's are Windows NT and Windows 95. The next successor to Windows 95 will probably be Windows 98 which will ship next around May of next year. MS Excel - Spreadsheet that allows the user to perform calculations on data, write programs within the spreadsheet to manipulate the data, or create graphs as well as a number of other functions. MS Word - Word processor that allows the user to create documents. The user can create tables with the document or embed figures created with other software. MS Powerpoint - Program for creating figures or presentations. Allows drawing simple figures or creating "bullet" charts. Setting up Shortcuts in Windows 95 or Windows NT 4.0 In past versions of Windows (Windows for Workgroups 3.1 or less, and Windows NT 3.51 or less), the windows environment consisted of different program groups that contained icons for the different programs. To start the program the user simply moved the pointer for the Mouse over the desired icon and "double-clicked" the left mouse button to start the program. The environment in Windows 95 and Windows NT 4.0 is quite different than past Windows environments. The programs and control settings can be found by moving the mouse pointer to the lower left hand corner of the screen to the "Start" button which will pop up with additional options. To find a desired program we go to the Programs Menu and an additional pop-up panel appears. We then find the program that we wish to use and select the program with the right mouse button. Starting programs that we use daily in the manner described above is generally a pain. If we know where the executable (filename.exe) file is located, however, we can form a shortcut to the program. A shortcut to a program is simply an icon on the background which starts the program when double-clicked. This saves us the trouble of having to go to the "Start" button-Programs-Program Group-Program each time that we want to use the program. We will be using a program named QVTNET32 in the next lab. QVTNET32 is simply a program which has tools for use on a computer network. Two of the programs which are often used are: TELNET - allows a user to log in to a computer from a remote terminal. However, the telnet session is a command line interface which requires some basic command knowledge of the user. FTP - File Transfer Protocal - allows a user to send and receive files from a file server. The version of FTP on QVTNET is also a command line interface, however, there are a number of GUI type versions for FTP. One of the more popular versions is WSFTP. QVTNET32 is located on the server FISH. The path to the executable is //FISH/pubapps/qvtn3988. To create a shortcut to the program, place the mouse cursor on the background (not above an existing icon) and push the right mouse button. A pop-up menu will appear from which you should select (with left mouse button) New and then Shortcut. Once you select Shortcut, a pop-up panel will appear that will allow you to put the pathway to the executable file or "browse" to find the executable. If you select "browse" (recommended), go to the "Network Neighborhood" and choose FISH then pubapps and then qvtn3988. The executable file will usually have a small picture (similar to the icon). Choose QVTNET32 and then select the "Next" button, and finally the "Finish" button. The shortcut icon will appear on the background. You can move the shortcut anywhere on the background that you wish by placing the pointer over the icon and holding the left mouse button down while you drag the icon to the desired position. To start the program you simply double click on the icon. As we begin to study new pieces of software this semester you will typically want to make new shortcuts to the software. Networks and Communication Networks A network is a collection of computers, communications channels, and appropriate software that allows the computers to communicate with each other in an organized way. Networks are used for a number of reasons. Networks not only make it easier for users, but significantly improve system maintenance for a large number of computer systems. Local Area Networks (LAN) •LAN's generally provide local file and printer sharing and electronic mail. •An example of a LAN is the UH campus and the Engineering College. Wide Area Networks (WAN) • A wide are network consists of a diverse collection of computers communicating with each other over long distance, generally over common carrier lines at lower speeds than provided by LAN's. •WAN's generally provide access to remote files and electronic mail. •An example of a WAN is the Internet. FILES and DIRECTORIES While working on the computer will be using and creating files and directories. Files can take many forms such as a letter or document, text files, program or executable files, utility files, etc. We can usually tell what type of a file we are dealing with by the filename: filename.ext filename can be anything but is usually a brief description that tells us what the file is for. In DOS the length of the filename was limited to 8 characters and the extension was limited to 3 characters. This is changing on Windows 95 and Windows NT in which you can have much longer names. The extension (ext) tells us what "type" of file it is: exe - executable program txt - text file doc - MS Word document dll - Utility file for a program -dynamic link library ppt - power point file xls - excel spreadsheet for - fortran code The files that we use or create are stored in a Directory structure. You can think of the network system as a large file cabinet and each drawer is a different hard disk on a computer. When we open a drawer there are a number of file folders many of which contain other folders and files. When a file is saved to the hard disk there is a particular path to that file. For example, many of our "application" software will be located on the file servers FISH and BIRD. You can think of BIRD and FISH as two different drawers in the file cabinet. If you open up either of the drawers there are a number of folders in each drawer. We will often be using the utility program NT Explorer to move around our file cabinet to manipulate files or folders. We can find NT Explorer by moving the mouse cursor to the lower left and corner of the computer screen and pushing the left mouse button which will cause a pop-up window to appear. Select NT Explorer by placing the mouse pointer over NT Explorer and pushing the left mouse button. If we open up the FISH there are a number of folders many of which have additional folders and files. The lecture notes for this course are located in \\FISH\UHCOURSES\CIVE 1331\FALL1997\HELWIG\LECTURES You can also move around the different servers with the software we will be using such as WORD, EXCEL, etc. Electronic Mail (Email) We will be using the program Eudora for Email. Double click on the Eudora Icon to start the program. Open the Special Menu and select Configuration. Under POP Account put your email address which was given to you. For example: POP Account: thelwig@tree.egr.uh.edu Real Name: Anything you wish to be called SMTP Server: post-office.uh.edu Return Address: thelwig@tree.egr.uh.edu Check mail every ____ Minutes Changing your password on your mail server 1. Double click on the Qvtnet32 shortcut that you made. 2. Double click on the terminal - This starts a telnet session. If your account is on tree.egr.uh.edu - for hostname use "telnet.egr.uh.edu" (don’t use the "" marks) Ø login --- put user name - thelwig Ø password: use the original password given to your account lonestar> passwd old password ****** new password (use the same one that you changed to on your NT account) reconfirm new password To end the telnet session, type "logout" ( or "exit") If your account is on jetson.uh.edu put "jetson.uh.edu" for the hostname of the telnet session . Ø login: put user name - thelwig Ø password: use original password Ø set password old password: use original password new password: (use the same one that you changed to on your NT account) To end the telnet session type "logout" ( or try "exit") From Eudora to send a message select "New Message" from the Message menu. You can also customize your email to include an automatic signature that includes your phone number or any information that you wish to include with each of your messages that you send. Choose Signature from under the Window Menu. CIVE 1331 Computers in Engineering Homework 11 Due at start of class April 16, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 11", and your name, student number, and lecture class time (10:00 or 5:30; the one you're registered in) and lab date&time at the top. Print out enough of the output to show you've been successful. 1. Do Problem 3.2 from the Blachman book. 2. Do Problem 3.3 from the Blachman book. 3. Do Problem 3.5 from the Blachman book. 4. Do Problem 3.6 from the Blachman book. 5. Do Problem 3.8 from the Blachman book. 6. Do Problem 3.11 from the Blachman book. 6. Do Problem 4.1 from the Blachman book. CIVE 1331 Computers in Engineering Homework 1 Due in class January 29, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 1", and your name, student number, and lab date&time at the top. 1. Open Windows Help under Start, and find the description of how to hide the task bar. Copy it (highlight it all, then hit control and C at the same time) and paste it into MS Word (put the cursor in an MS Word document, and hit control and V at the same time). 2. Use any computer drawing tool of your choice to draw a simple picture. Include at least one rectangle, one circle, and one diamond. 3. Use the equation editor to reproduce the following equation, and paste it in as your answer to problem 3: 4. Use the Notepad editor to write a Fortran language program which is called HW1, and writes out the following text: This is the output. This is the rest of the output. [Note: The second line is indented 7 spaces.] Compile and run this program. Submit the code and the output produced by running the program. 5. Telnet into your VAX account, and at the $ prompt type "dir". Give the first three lines of the result as your answer to problem 5. 6. At the DOS command prompt, create a new directory in your account called "TEST". Use the dir command to show that this directory has been created, and print out the result as your answer to problem 5. CIVE 1331 Computers in Engineering Homework 2 Due in class Februry 5, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 2", and your name, student number, and lab date&time at the top. Each FORTRAN program should have the steps of the Five Step method, including the problem statement, input/output list, hand example, pseudocode, FORTRAN code, and output. Later assignments will also call for a flowchart. Codeview may be helpful in doing this assignment. 1. Complete Problem 2 in Chapter 2 of the text. Save the working source code and the executable program in files named HW2_1.FOR and HW2_1.EXE. These files should be in your subdirectory for FORTRAN work (make a subdirectory), and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, pseudocode, FORTRAN code, and output. 2. Connect to UHCourses on the ECC server (one way to start is to look in 'My Computer'). Open the CIVE1331 folder, and the Spring 1997 folder inside that. Notice the documents related to this class which are available on the server - we will continue to post information here throughout the term. Open the file called: "File for HW2". Submit the contents of this file as your answer to this question. 3. Complete Problem 8 in Chapter 2 of the text. Save the working source code and the executable program in files named HW2_3.FOR and HW2_3.EXE. These files should be in your subdirectory for FORTRAN work (make a subdirectory), and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, pseudocode, FORTRAN code, and output. CIVE 1331 Computers in Engineering Homework 3 Due in class Februry 12, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 3", and your name, student number, andlecture class time (10:00 or 5:30; the one you're registered in) lab date&time at the top. Codeview may be helpful in doing this assignment. Remember that your .LST file is for looking at, not for making changes in your code. Save everything on a floppy drive, while you're working on it - this avoids any H: drive problems (and gives you unlimited storage to work from!). 1. Complete Problem 2 in Chapter 3 of the text. Save the working source code and the executable program in files named HW3_1.FOR and HW3_1.EXE. These files should be in your subdirectory for FORTRAN work (make a subdirectory if you have not; we will check on this sometime), and you should have a backup on a floppy disk. Submit the pseudocode, FORTRAN code, and output for INCR1=0.5 sec; INCR2=0.025. Only submit the last 10 or so lines of the output. 2. Complete Problem 7 in Chapter 3 of the text. Save the working source code and the executable program in files named HW3_2.FOR and HW3_2.EXE. These files should be in your subdirectory for FORTRAN work (make a subdirectory), and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, pseudocode, FORTRAN code, and output. 3. Complete Problem 8 in Chapter 3 of the text. Save the working source code and the executable program in files named HW3_3.FOR and HW3_3.EXE. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. 4. Complete Problem 10 in Chapter 3 of the text. Save the working source code and the executable program in files named HW3_4.FOR and HW3_4.EXE. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. 5. Complete Problem 1 in Chapter 4 of the text. Save the working source code and the executable program in files named HW3_5.FOR and HW3_5.EXE. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. 6. Complete Problem 4 in Chapter 4 of the text. Save the working source code and the executable program in files named HW3_6.FOR and HW3_6.EXE. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. We'll post a file for use with this program, here, by Friday morning. CIVE 1331 Computers in Engineering Homework 4 Due in class Februry 19, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 4", and your name, student number, and lecture class time (10:00 or 5:30; the one you're registered in) and lab date&time at the top. 1. Complete Problem 4 in Chapter 5 of the text. Save the working source code and the executable program in files named HW4_1.FOR and HW4_1.EXE. These files should be in your subdirectory for FORTRAN work, and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. In the book, the first "XX" is the location of the minimum in the array, and the "XXXXX" is its value. Use the following data to fill array K to test your program 49 2 73 88 18 89 5 3 38 76 94 21 91 58 34 21 89 81 8 94 67 58 19 45 25 22 19 22 68 19 90 63 66 93 35 68 -55 0 19 78 9 62 59 -81 46 84 16 89 30 3 2. Complete Problem 11 in Chapter 5 of the text. Save the working source code and the executable program in files named HW4_2.FOR and HW4_2.EXE. These files should be in your subdirectory for FORTRAN work, and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. Here are the contents of file FLIGHT. In a given row, the columns from left to right correspond to seats 1-6. 1 1 0 1 1 1 0 0 0 1 0 0 0 1 0 0 1 1 1 0 1 1 0 1 0 1 1 0 1 0 1 0 0 1 1 0 0 0 0 0 1 0 0 0 1 1 1 0 0 0 0 1 1 1 1 1 0 1 0 0 0 1 0 1 0 0 1 1 0 0 0 0 0 1 1 1 1 0 0 1 0 1 0 0 1 0 1 1 1 1 1 1 0 0 0 0 0 1 0 1 0 0 0 1 0 1 1 1 0 1 1 0 0 0 0 1 0 1 1 1 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 0 1 0 1 0 0 1 1 0 1 1 1 1 0 0 1 1 1 1 1 0 1 0 0 0 1 1 0 1 0 1 0 1 0 0 0 1 0 0 1 0 1 1 1 0 0 0 1 0 0 1 1 0 0 1 0 0 0 1 0 1 1 1 0 1 1 0 0 1 1 1 0 1 1 0 0 0 0 1 1 1 0 1 1 1 0 0 1 0 0 1 0 0 3. Complete Problem 13 in Chapter 6 of the text. Just submit the relevant statements. 4. Complete Problem 15 in Chapter 6 of the text. Just submit the relevant statements. 5. Complete Problem 16 in Chapter 6 of the text. Save the working source code and the executable program in files named HW4_5.FOR and HW4_5.EXE. These files should be in your subdirectory for FORTRAN work, and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. 6. Complete Problem 2 in Chapter 7 of the text. Just submit the subroutine code. 7. Submit a DOS dir listing of your FORTRAN subdirectory, showing (among any others) the files associated with this and previous homework assignments. CIVE 1331 Computers in Engineering Homework 5 Due at start of class February 26, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 5", and your name, student number, and lecture class time (10:00 or 5:30; the one you're registered in) and lab date&time at the top. 1. Complete Problem 7 in Chapter 8 of the text. Save the working source code and the executable program in files named HW5_1.FOR and HW5_1.EXE. These files should be in your subdirectory for FORTRAN work, and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. Take X = 0.40 2. Complete Problem 8 in Chapter 8 of the text. Save the working source code and the executable program in files named HW5_2.FOR and HW5_2.EXE. These files should be in your subdirectory for FORTRAN work, and you should have a backup on a floppy disk. Submit the steps of the Five Step method, including the problem statement, input/output list, hand example, flow chart, pseudocode, FORTRAN code, and output. Test your code with: 'ABCDEFGHIJJIHGFEDCBA' and 'EWDGERPFGERPFGERGJXU' CIVE 1331 Computers in Engineering Homework 6 Due at start of class March 5, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 6", and your name, student number, and lecture class time (10:00 or 5:30; the one you're registered in) and lab date&time at the top. 1. Complete Problem 1 in Excel Chapter 2 of the text. Print out or sketch enough of the worksheet to show that you have completed the problem. 2. Complete Problem 2 in Excel Chapter 2 of the text. Print out or sketch enough of the worksheet to show that you have completed the problem. 3. Complete Problem 3 in Excel Chapter 2 of the text. Print out or sketch enough of the worksheet to show that you have completed the problem. 4. Complete Problem 5 in Excel Chapter 2 of the text. Print out or sketch enough of the worksheet to show that you have completed the problem. 5. Complete Problem 14 in Excel Chapter 2 of the text. Include columns titled "Sample No." and "Diameter". Create a cell at the bottom of the "Diameter" column which averages the values you enter. Test your worksheet with the diameter data below. Print out or sketch enough of the worksheet to show that you have completed the problem. 67 28 69 73 48 34 28 83 75 25 15 94 72 86 90 74 26 41 24 45 6. Complete Problem 9 in Excel Chapter 3 of the text. Print out or sketch enough of the worksheet to show that you have completed the problem. IVE 1331 Computers in Engineering Homework 7 Due at start of class March 12, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 7", and your name, student number, and lecture class time (10:00 or 5:30; the one you're registered in) and lab date&time at the top. 1. Complete Problem 8 in Excel Chapter 4 of the text. Print out the chart to show that you have completed the problem. 2. Complete Problem 12 in Excel Chapter 4 of the text. Print out important formulas, and the plot. CIVE 1331 Computers in Engineering Homework 8 Due at start of class March 19, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 8", and your name, student number, and lecture class time (10:00 or 5:30; the one you're registered in) and lab date&time at the top. 1. Complete Problem 14 in Excel Chapter 4 of the text. Print out important formulas, and a few examples. 2. Complete Problem 15 in Excel Chapter 4 of the text. Print out important formulas, and a few examples. 3. Sort the following data by Column 1 (descending), and then (in the same sort, as a tie-breaker) by Column 2, descending. 20.9418367 85.4409997 37.1911212 75.1340711 12.8445917 54.0299524 67.8678716 51.499504 97.7613599 35.4480158 49.2951687 56.0957924 37.9100247 35.4850328 19.6402154 48.9848785 7.68861568 31.0273419 40.657137 14.8749172 1.62424891 7.69488201 92.5689411 40.7034096 69.3181893 72.8812929 95.06979 1.54068996 52.2487916 56.5154186 88.3104612 59.0584845 34.5091801 35.7907563 22.150028 18.1721125 56.5578 75.2862407 7.30266032 40.5596908 89.4495321 57.8557047 22.0086121 67.7118727 19.4347945 4.98744005 90.2496516 62.9615233 66.2531469 93.2879243 48.9848785 56.0957924 68.3875724 55.4810308 0.33582506 37.9345371 19.2706378 78.0661831 9.11732177 62.3498461 76.2216131 58.9715554 80.7784671 46.45785 83.6773234 93.5953375 16.1254427 89.1059043 30.2191157 3.0682107 Submit the sorted data set. 4. Complete Problem 6 in Excel Chapter 5 of the text. Print out important formulas, and the histogram. 5. (Look over the material at http://www.egr.uh.edu/College/OwnHomePage.html). Connect to the search service at http://altavista.digital.com/ Use this search engine to tell me what Tim Berners-Lee is famous for, and tell me the URL you got this information from. CIVE 1331 Computers in Engineering Homework 9 Due at start of class April 2, 1997 Submit all answers printed out in paper form. The document should be produced in MS Word, and have "Homework 9", and your name, student number, and lecture class time (10:00 or 5:30; the one you're registered in) and lab date&time at the top. 1. How are the following HTML tags used?