Computer Science
Generic Course Syllabus
(For actual course syllabi please consult the schedule of classes, determine the instructor for the courses and consult his or her home page.)
 
 
 
Course #: A107
Course Title: Programming Within Applications (Advanced Microcomputing) 
Prerequisites: A106
Credits: 3
Text Book: Text: TBA
Supplemental Texts: TBA
Course Information:  This course is designed to increase students' ability to perform tasks using the personal computer. Advanced study and use of the Microsoft Office productivity suite (Word, Excel, Outlook, Access, PowerPoint) will be one focus of the course with an emphasis on database design and development. We will show how the Office capabilities can be enhanced through the use of programming. Visual Basic for Applications, or VBA, is a powerful programming language included in the Office suite that allows users to write programs to provide custom solutions for specific business and personal needs. Students with a solid working knowledge of Office will find VBA to be a relatively easy language to learn and can quickly use it to enhance the existing functionality of the Office applications. To become "good" at writing programs, basic concepts of programming logic, principles and techniques will be studied. The course will also take a look at the Windows operating system as well as the design, construction and publishing of web pages.
Other Information:
Topics
At the successful completion of this course the student will be able to:
  • write macros to automate frequently performed tasks in Excel and Word;
  • use the Visual Basic Editor to write and debug procedures for MS-Office applications;
  • use the Object Browser to locate information about objects and their properties, methods and events;
  • design and implement a database system using Access;
  • summarize program requirements using pseudocode or flow charts;
  • become versed in the basic functionality of the Windows operating system and gain an understanding of how to customize various features to meet individual needs;
  • learn the fundamentals of good web page design;
  • successfully construct and publish a web page given a starting design.
    •