CS130 - Introduction to Software Tools
CS230 - Introduction to Advanced Software Tools
Class Times: TTh 6:00 PM- 7.30 PM
Location: Marsh LL12
In many disciplines and careers, the ability to gather, manipulate, analyze, graph, and present data is one of the most important assets a person can possess. This introductory course will provide you with experience using various software tools that have proved indispensable towards this end: Excel, StatView, Word, and PowerPoint. The students in CS 230 cover the same material as the students in CS 130 during the first ten class meetings. They will then move on to learn about databases using Access and Visual Basic for Applications during the next five class meetings. All meetings will include in-class lab projects.
Prerequisite and Corequisite:
- Math125: Precalculus (prerequisite for both CS130 and CS230).
- Math226: Calculus 1 (corequisite for CS230 only).
Textbooks:
-
No textbook is required for this course. All material will be provided by the instructor.
Tentative Grading (CS130):
-
6 assignments: 40%.
-
1 midterm: 30%.
-
1 final: 30%.
Tentative Grading (CS230):
-
7 assignments: 40%.
-
2 midterms: 40%.
-
1 final project: 20%.
Percent Breakdown:
92-100 |
A |
|
90-92 |
A- |
|
|
|
88-90 |
B+ |
|
82-88 |
B |
|
80-82 |
B- |
78-80 |
C+ |
|
72-78 |
C |
|
70-72 |
C- |
68-70 |
D+ |
|
60-68 |
D |
|
|
|
0-60 |
F |
|
|
|
|
|
|
Dates of Exams:
-
Midterm 1: Thursday, March 14, 2004.
-
Final (Midterm 2 for CS230): Thursday, April 15, 2004.
-
Final Project for CS230: Tuesday, May 18, 2004.
Course Notes and Assignments:
WEEK 1
|
Connecting to Winter html - pdf - doc
Excel: html - pdf - doc
- Introduction to Excel (worksheet basics, menu bar, toolbar)
- Simple formulas
- Operator precedence and associativity
|
Tuesday
February 3, 2004
|
|
CS130 questionnaire html
Excel: html - pdf - doc
- Absolute and relative cell reference
- Cell filling (up, down, left, right)
- Common error messages
|
Thursday
February 5, 2004
|
Assign. 1
html - pdf - doc
|
WEEK 2
|
Excel: html - pdf - doc
- Built-in functions
- Function arguments
- Nested functions
|
Tuesday
February 10, 2004
|
|
Excel: html - pdf - doc
- Financial functions
- What-if analysis
- Goal-seeking
|
Thursday
February 12, 2004
|
Assign. 1 Due
Assign. 2
html - pdf - doc
|
WEEK 3
|
Excel: html - pdf - doc
- Worksheet formatting
- Printing worksheets
- Chart wizard
- Importing data from other sources
- Working with large datasets
|
Tuesday
February 17, 2004
|
|
Excel: html - pdf - doc
- Comparison operators
- IF built-in function
- Logical operators
|
Thursday
February 19, 2004
|
Assign. 2 Due
Assign. 3
html - pdf - doc
|
WEEK 4
|
Excel: html - pdf - doc
- Logical operators
- More IF function examples
|
Tuesday
February 24, 2004
|
|
Excel: html - pdf - doc
- Scatterplots and trendlines
- Linear regression
- Regression coefficient
|
Thursday
February 26, 2004
|
|
WEEK 5
|
Excel: html - pdf - doc
- Nonlinear regression
- Logarithmic functions
- Exponential functions
|
Tuesday
March 2, 2004
|
|
Midterm 1
|
Thursday
March 4, 2004
|
Assign. 3 Due
|
WEEK 6
|
StatView: html - pdf - doc
- Creating a simple dataset
- Importing data from other sources
- Sorting data
|
Tuesday
March 9, 2004
|
|
StatView: html - pdf - doc
- Statistical and visual summaries
- Descriptive and inferential statistics
- Histograms
- Single and multiple variables
|
Thursday
March 11, 2004
|
Assign. 4
html - pdf - doc
|
WEEK 7
|
StatView: html - pdf - doc
- Hypothesis testing
- One-sample t-test
- Unpaired t-test
- Z-test
- Unpaired t-test
|
Tuesday
March 16, 2004
|
|
StatView: html - pdf - doc
|
Thursday
March 18, 2004
|
Assign. 4 Due
|
WEEK 8
|
Spring break
|
Tuesday
March 23, 2004
|
|
Spring break
|
Thursday
March 25, 2004
|
|
WEEK 9
|
PowerPoint: html - pdf - doc
- Design templates
- Slide master
- Text animation
- Audio and video
|
Tuesday
March 30, 2004
|
Assign. 5
html - pdf - doc |
Mail Merge: html - pdf - ppt
- Introduction to mail merge in Word
- Using mail merge with Excel
|
Thursday
April 1, 2004
|
|
WEEK 10
|
PowerPoint Demonstrations
|
Tuesday
April 6, 2004
|
|
No Class
|
Thursday
April 8, 2004
|
|
WEEK 11
|
Review and more examples html - pdf - doc
|
Tuesday
April 13, 2004
|
|
Final for CS130 and Midterm 2 for CS230
|
Thursday
April 15, 2004
|
|
WEEK 12
|
Access: html - pdf - doc
- Database management system (DBMS)
- Tables
- Records
- Fields
- Primary keys
|
Tuesday
April 20, 2004
|
|
Access: html - pdf - doc
- Database queries
- Joining tables
- Calculating statistics
- Creating AutoForms and AutoReports
- Validation rules
- Referential integrity
|
Thursday
April 22, 2004
|
|
WEEK 13
|
Access: html - pdf - doc
- Validation rules
- Referential integrity
- Complex forms
- Subdatasheets
- Including images in forms
|
Tuesday
April 27, 2004
|
Assign. 7
|
Visual Basic for Applications:html - pdf - doc
- Variables
- Assignment statements
- If statements
- SubroutinesModules
|
Thursday
April 29, 2004
|
Final Project
|
WEEK 14
|
Visual Basic for Applications: html - pdf - doc
- Variables
- Assignment statements
- If statements
- SubroutinesModules
|
Monday
May 3, 2004
|
Final Project
html - pdf - doc |
Visual Basic for Applications:
- Variables
- Assignment statements
- If statements
- SubroutinesModules
|
Tuesday
May 4, 2004
|
|
Visual Basic for Applications:
- Event-driven programming
- Operators
- Looping
|
Thursday
May 6, 2004
|
|
Policies:
-
Assignments are to be submitted in the course drop box by 6.00 PM
on the day in which the assignment is due.
-
Programs can be turned in 24 hours late with a penalty of 20%.
Anything later will not be accepted.
-
Attendance
at every class is critical to your success in this class. I expect you to be on
time and ready to go once it's 6:00 PM. Any missed lecture is your
responsibility to make up. Do not expect me to repeat missed material in class.
-
The
instructor reserves the right to raise or lower a student's grade based on class participation and attendance.
-
No
early or late exams/finals will be given under any circumstances.
-
The cheating policy is defined in Pacific Stuff & the Pacific
Catalog as well as the Academic Policy that each of you signed upon
entering Pacific University. Be sure you read or reread this policy
carefully.
-
Neither computer failure, software failure, nor lack of computer access
are accepted as excuses for late programs; therefore, start work on the
programs as soon as they are assigned, don't put them off until the last
minute. Further, corruption of programs due to bad disk media is also not
accepted as an excuse for late programs; therefore, always keep a current
backup of all programs on a separate disk.
-
I do not want to hear any electronic devices go off during lecture;
therefore, make sure you silence these devices before lecture starts.
Important Dates:
- February 13: Last day to add and drop courses.
- March 22-26: Spring Break.
- April 9: Last day to withdraw from courses.
- April 15: Final Exam for CS130.
- May 11: Last day of class for CS230.
- May 12: Reading Day.
- May 18: Final Project for CS230.
|