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

 

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
  • StatView examples
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.