CE 101 Computer Applications
in Civil Engineering
DEPARTMENT OF CIVIL ENGINEERING
COLLEGE OF ENGINEERING AND COMPUTER SCIENCE
SPRING 2003
|
|
|
|
|
|
Develops a computer-based concept for problem solving and graphical presentation of results with applications in five areas of civil engineering: environmental, geotechnical, structural, transportation and water resources. Uses word processing, spreadsheets, structured programming (Visual BASIC with spreadsheets), and special purpose software packages. Lecture two hours; laboratory three hours.
Students
who complete this course successfully will be able to:
- Use Excel spreadsheets effectively and efficiently as a computation tool for problem solving in Civil Engineering. The students should be able to:
- Define and organize a template with input, algorithm, and output areas.
- Recognize the need to design a template based on usage.
- Incorporate Excel's computation and graphical power in solving problems.
- Import and export data from other sources and/or to Excel.
- Adopt algorithms used for solving engineering problems into Excel. The student should be able to:
- Recognize input , process, and output parts of algorithms.
- Select the most appropriate implementation of the algorithm (Excel versus Visual Basic).
- Translate the algorithm into an Excel template or Visual Basic.
- Divide the algorithm into smaller parts for implementation.
- Write simple programs in Visual Basic in Excel. Specifically, students should be able to:
- Identify type of variables (Single, Double, Integer, etc.)
- Apply conditional statement (IF statement)
- Apply repetition statements (For loops, Do While, and Loop Until)
- Develop and implement a user-defined function
|
Week #
|
Week of
|
Lecture
|
Reading | |
|
1
|
9/4 |
1 |
Course overview/Introduction to Spreadsheets |
Chapter 1 |
|
2
|
9/9
9/11 |
2
3 |
VB Programming: Program
components/Recording a Macro VB Programming: Type of Variables/Assignment Statements |
7.1 - 7.3 7.4, 8.1, and 8.2 |
|
3
|
9/16
9/18 |
4
5 |
VB Programming: Arrays Surveying Applications: Area of Traverse |
Notes Notes, 3.2 - 3.8 |
|
4
|
9/23
9/25 |
6
7 |
Surveying Applications:
Area of Traverse Surveying Applications: Area of Traverse |
Chapter 2 |
|
5
|
9/30
10/2 |
8
9 |
VB Programming: User-defined
functions VB Programming: Loops and Branching |
Notes Notes |
|
6
|
10/7
10/9 |
10
11 |
Geotechnical Engineering Geotechnical Engineering |
Notes |
|
7
|
10/14
10/16 |
12
13 |
VB Programming: User
interface VB Programming: User interface |
8.3 - 8.5 |
|
8
|
10/21
10/23 |
14
15 |
Solving
Equations: Bisection Method Solving Equations: Newton's Method |
Notes 6.1 - 6.4 |
|
9
|
10/28
10/30 |
16
17 |
Matrix
Algebra: Solution of Simultaneous Equations Matrix Algebra: Application to Truss Problem |
Chapter 4 |
|
10
|
11/4
11/6 |
18
19 |
Graphics in Excel Graphics in Excel |
Chapter 2 |
|
11
|
11/11
11/13 |
20
21 |
Linear Regression Linear Regression |
Chapter 5 |
|
12
|
11/18
11/20 |
22
23 |
Multiple Linear Regression Multiple Linear Regression |
Notes |
|
13
|
11/25
11/27 |
24
25 |
VB Programming: UserForms
and Events VB Programming: UserForms and Events |
Notes |
|
14
|
12/2
12/4 |
26
27 |
Student selected
topic (more on this later) Student selected topic (more on this later) |
Notes |
|
15
|
12/9
12/11 |
28
29 |
Final Exam Week |
|
Lab #
|
Week of
|
Document
|
Lab Topic
|
|
1
|
9/2
|
Lab 01
|
Introduction to Spreadsheets: Formatting, Formulas, addresses |
|
2*
|
9/7
|
Lab 02
|
Introduction to Visual Basic: Simple programming |
|
3
|
9/16
|
Lab 03
|
Introduction to Visual Basic: Automation and User Defined Functions |
|
4*
|
9/23
|
Lab 04
|
Spreadsheet Application: Surveying Problem |
|
5
|
9/30
|
Lab 05
|
Spreadsheet Application: Surveying Problem |
|
6*
|
10/7
|
Lab 06
|
Visual Basic: Surveying Problem |
|
7
|
10/14
|
Lab 07
|
Visual Basic: Geotechnical Engineering |
|
8*
|
10/21
|
Project
|
Project: Submit Initial Template |
|
9
|
10/28
|
Project
|
Project: Submit finished project |
|
10*
|
11/4
|
Lab 08
|
Spreadsheet Application: Solving Nonlinear Equations |
|
11
|
11/11
|
Lab 09
|
Spreadsheet Application: Matrix Algebra & Solution of Simultaneous Equations |
|
12*
|
11/18
|
Lab 10
|
Spreadsheet Application: Linear Regression |
|
13
|
11/25
|
Lab 11
|
Spreadsheet Application: Multiple Regression Thursday section need to finish the lab by Wednesday -- HAPPY THANKSGIVING |
|
14
|
12/2
|
Lab 12
|
Review for Final Exam |
|
15
|
12/9
|
FINAL EXAM will be during your lab session** |
** The final exam will be held during the "dead week" (before the finals week).
The grades are assigned with the general guidelines shown below.
|
A |
Outstanding achievement |
> 90 |
|
B |
Excellent performance; clearly exceeds course requirements |
80 - 89 |
|
C |
Average |
70 - 79 |
|
D |
Passed, but not at average achievement standards |
60 - 69 |
|
F |
Failure to meet class requirement |
< 60 |
|
Activity
|
Total Points
|
| Lab Assignments (11 Labs and a project*) |
260 (48%)
|
| Six quizzes |
120 (22%)
|
| Final Exam |
160 (30%)
|
Students will need an electronic mail account and computer access to the Web. All CSUS students enrolled in one or more units can create a SacLink account for electronic mail and Internet services. Although a home computer with a high speed modem running Netscape or Internet Explorer would be beneficial, students can use the Web from one of the campus student labs.
Computing RecommendationsYou should be comfortable using a computer and willing to browse the Web. This class requires online class participation on the Web assignments and electronic discussions.
You need:
- Macintosh compatible with System 8 or higher or Windows compatible Pentium running Windows 95/98 or Windows NT.
- 32MB of RAM, preferably 64MB
- 28.8K or faster modem - preferably 56K
- Microsoft Internet Explorer or Netscape 4.0 (or higher)
- SacLink or other Internet Account
- Word processing skills
Students need an electronic mail account and computer access to the Web. All CSUS students enrolled in one or more units can create a SacLink account for electronic mail and Internet services. Although a home computer with a high speed modem running Netscape or Internet Explorer would be beneficial, students can use the Web from one of the campus student labs.
Required: Larsen, Ronald W. Engineering With Excel, 2002. Prentice Hall, Upper Saddle River, NJ.
You can purchase books through the Hornet Bookstore. Check their Distance and Distributed Learning page at http://www.bookstore.csus.edu/bookstore/distance/ for ordering information.