|
|
|
|
|
CS130 - Introduction to Software Tools
CS230 - Introduction to Advanced Software Tools
Notes:
Class has been cancelled for Tuesday, January 6, Wednesday, January 7, and
Thursday, January 8 due to inclement weather conditions. As a result of this,
the course schedule has been modified. The most important changes are in the
exam dates. Note that the final for CS130 will now be on Tuesday, January 20.
Class Times: MTWThF 9:00 AM- 12.00 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):
-
5 assignments: 40%.
-
1 midterm: 30%.
-
1 final: 30%.
Tentative Grading (CS230):
-
6 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: Wednesday, January 14, 2004.
-
Final (Midterm 2 for CS230): Tuesday, January 20, 2004.
-
Final for CS230: Monday, January 26, 2004.
Course Notes and Assignments:
Connecting to Winter
Introduction to Excel:
-
Worksheet basics, menu bar, toolbar
-
Simple formulas
-
Operator precedence and associativity
-
Absolute and relative cell reference
-
Cell filling (up, down, left, right)
-
Common error messages
|
Monday, January 5, 2004
|
|
Class Cancelled |
Tuesday, January 6, 2004
|
|
Class Cancelled |
Wednesday, January 7, 2004
|
|
Class Cancelled |
Thursday, January 8, 2004
|
|
Excel:
-
Built-in functions
-
Financial functions
-
Payment or Ammortization Schedule
-
What-If Analysis and Goal Seeking
|
Friday, January 9, 2004
|
Assign. 1 |
Excel:
-
Cell formatting
-
Logical operators and IF function
-
Chart wizard
|
Monday, January 12, 2004
|
Assign. 1 Due Assign. 2
|
Excel:
-
Linear regression
-
Nonlinear regression
-
Logarithmic functions
-
Exponential functions
|
Tuesday, January 13, 2004
|
Assign. 2 Due |
Review
Midterm
|
Wednesday, January 14, 2004
|
Assign. 3 |
StatView:
-
Intro to StatView
-
Statistical and visual summaries
-
Descriptive and inferential statistics
-
Independent and dependent variables
|
Thursday, January 15, 2004
|
Assign. 3 Due |
Hypothesis Testing in StatView
-
One-Sample t-test
-
Paired t-test
-
Z-test
-
Unpaired t-test
|
Friday, January 16, 2004
|
Assign. 4 |
Mail Merge:
-
Introduction to mail merge in Word
PowerPoint:
-
Design templates
-
Text animation
|
Monday, January 19, 2004
|
Assign. 4 Due
Assign. 5
|
ReviewCS130 Final
|
Tuesday, January 20, 2004
|
Assign. 5 Due |
Access:
-
Database management system (DBMS)
-
Tables (record, field, primary key)
-
Database queries
-
Joining tables
-
Calculating statistics
|
Wednesday, January 21, 2004
|
|
Access:
-
Formatting rules
-
Referential integrity
-
Forms
|
Thursday, January 22, 2004
|
|
Visual Basic for Applications:
-
Basics (variables, assignment statement, IF)
-
Subroutines
-
Modules
-
Event-driven programming
-
Operators
-
Looping
|
Friday, January 23, 2004
|
Final ProjectAssign. 6 Due |
CS230 Final
|
Monday, January 26, 2004
|
Project Due |
Policies:
-
Assignments are to be submitted in the course drop box by 9.00 AM 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 9:00 AM. 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 circumstance.
-
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:
-
January 7: Last day to add and drop courses.
-
January 16: Last day to withdraw from courses.
-
January 20: Final Exam for CS130.
-
January 26: Final Exam for CS230.
|
|
|
|
|
|