CSCI 112 - Applications Programming
Fall 2021 Course Outline

This document is available at URL: http://csci.viu.ca/~liuh/112/OutlineCSCI112.html

Course Motivation and overview

This course is intended to give interested students an introduction to a variety of forms and levels of application programming: from the use of built-in environments in applications such as Excel, to independent development of small scale applications using visual environments such as Visual Basic. Time permitting, the course may include topics such as the extraction and manipulation of data from sources such as web sites and databases. Theoretical topics will be discussed in the lectures, while the weekly labs will guide the students through the use and application of the various tools, languages, and programming techniques. A more detailed topics list is included in the Topics section below.

Contact information

• Lecturer: Huizhu Liu
• Office: Building 315 (Physics Building), Room 211
• Email: Huizhu.Liu@VIU.CA
• Course web site: http://csci.viu.ca/~liuh/112/
• Office Hours:
• 10:00 - 11:30, Mondays
• 10:00 - 12:30, Fridays
• By appointment

Materials

• Textbook: None
• Web material: some material will be made accessible online. Possible online material includes lecture notes, assignments, labs, sample programs, practice problems, and links to external documentation and tutorials.
• Software resources: we will be using the following software
• Microsoft Excel
• Visual Basic for Applications (VBA)

Timetable

• Lectures:
  13:00 - 12:30, Tuesdays and Thursdays
• Labs:
  Section F21N01: 11:30 - 13:30, Mondays
  Section F21N02: 13:30 - 15:30, Mondays

Assessment

• About 10 Assignments/Quizzes -- 50% (5% each)
• 2 In-class Midterms -- 20% (10% each)
• Final Exam -- 30%

The instructor reserves the right to modify this grading scheme during the term as necessary.

Labs/Tutorials

You must be enrolled in, and fully participate in, the weekly lab sessions. During these sessions the students will apply the concepts discussed in lectures. Exercises completed in the labs will form a significant portion of the overall course mark.

Software evaluation

Most of the assessment in this course is focused on the production, adaptation, or extension of software applications. To evaluate the quality of such work we will consider four factors:

• functionality: does the product get the job done
• usability: is the product easy to learn, intuitive and efficient to use, and effective at guiding and supporting the user
• robustness: does the product handle adverse conditions and unexpected input in an appropriate manner
• maintainability: will it be easy to revise/adapt the software to handle predictable changes over the life cycle of the product

Computer accounts

To work on your tutorials and assignments, you will be given accounts for the computing labs. There is a user id and password associated with each account. Each student is responsible for their account, and for following both the departmental and university policies. These may be found through www.viu.ca/computingscience/resources.asp#Lab_and_Computer_Usage_Rules

Topics

Learning Outcomes:

Upon completing this course, students should be able to:

• Identify basic computer architecture/components and functionalities
• Use spreadsheet, espcially Excel, to collect and store data
• Use spreadsheet formula to process data and establish simple models
• Design, implement and test VBA procedures to process data and build data models as per specification
• Design user interface to collect user input effectively using VBA userform
• Write event-driven procedures to handle userform related tasks

Appeals of Grades:

Any exercise or examination grade may be appealed. However, the appeal must be made to the instructor, in writing and attached to the work in question, and within 7 days of the grade being made available to the class. The instructor reserves the right to re-grade the entire piece of work submitted on appeal, not necessarily just the component that the student believes is in error.

Grade Conversion:

The following grade scale will be used:

Guidelines Concerning Academic Misconduct

All students taking this course are subject to the Vancouver Island University Policy and Procedures:

The official policies of Vancouver Island University can be viewed at http://www.viu.ca/policies/.

To quickly view some policies and procedures concerning student academic code of conduct and academic misconduct, etc, go to http://csci.viu.ca/~liuh/AcademicGuidelines.html.