Shereen Khoja

Assistant Professor of Computer Science

Email: shereen@pacificu.edu

Phone: 503-352-2008

Office: Strain 203C


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:

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: 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: Wednesday, January 21, 2004  
Access: Thursday, January 22, 2004  
Visual Basic for Applications: 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.