|
Official Course
Description: MCCCD Approval: 04/29/08 |
|||
|
CIS150AC
2008 Fall – 2009 Spring |
L+L |
3 Credit(s) |
4 Period(s) |
|
Programming
Fundamentals: Accounting |
|||
|
Introduction
to problem solving, systems organization, logic, and application of critical
thinking skills necessary to work effectively with structured data. Use of
Excel, Access, and Visual Basic for Applications (VBA) emphasized. Data
organization and data structure skills as well as programming concepts and
custom procedures covered. Prerequisites: CIS105 or permission of
Instructor. |
|||
Go to Competencies Go to Outline
|
MCCCD
Official Course Competencies: |
|
|
|
|
|
CIS150AC 2008
Fall – 2009 Spring |
Programming Fundamentals: Accounting |
|
1.
|
Describe the purpose and uses of information systems. (I) |
|
2.
|
Create workbooks with multiple spreadsheets utilizing
labels, values, formulas, and various functions. (II) |
|
3.
|
Format spreadsheets for screen display, analysis, and
printing. (III) |
|
4.
|
Perform data analysis by manipulating spreadsheet data and
creating charts. (IV) |
|
5.
|
Design and create databases. (V) |
|
6.
|
Maintain and query databases. (VI) |
|
7.
|
Create database forms and reports. (VI) |
|
8.
|
Explain the software development life cycle (SDLC). (VII) |
|
9.
|
Design and write procedures using the various control
structures with Visual Basic for Applications (VBA). (VIII) |
|
10.
|
Perform data validation and calculations using variables
and error-handling techniques. (VIII) |
|
11.
|
Use test data and debugging tools to verify code and find
logic errors. (VIII) |
Go to Description Go to top of
Competencies
|
MCCCD
Official Course Outline: |
||
|
|
||
|
CIS150AC 2008
Fall – 2009 Spring |
Programming Fundamentals: Accounting |
|
|
||
|
I. Information Systems
Overview A. Data Management B. Knowledge Management II. Spreadsheet Development
A. Labels, Values, Formulas
B. Financial, Statistical,
Logical, and Data Manipulation Functions C. Relative and Absolute
Reference D. Arithmetic and
Comparison Operators E. Order of Precedence F. Formula View G. Multiple Worksheets III. Spreadsheet Formatting
and Printing A. Value and Cell
Formatting B. Conditional Formatting C. Worksheet Layout D. Defining Print Range E. Margins, Headers, and
Footers IV. Spreadsheet Data
Analysis A. Sorting and Filtering B. Create Charts C. What-If Analysis V. Database Design and
Creation A. Data Modeling B. Normalization C. Entity Relationship
Diagram (ERD) D. Table Creation E. Data Validation VI. Data Management and
Retrieval A. Inserting, Updating, and
Deleting Records B. Forms C. Reports D. Queries E. Query-By-Example F. Generated Structured
Query Language (SQL) VII. Software Development
Life Cycle (SDLC) A. Problem Definition B. Algorithm Design C. Development D. Testing E. Implementation F. Maintenance VIII. Visual Basic for
Applications (VBA) A. Objects 1. Properties 2. Methods 3. Events B. Modules/Procedures 1. Subroutines 2. Functions 3. User-Defined Functions C. Variables, Data Types
and Scope D. Arithmetic, Relational,
and Logical Operators E. Control Structures 1. Sequence 2. Selection 3. Repetition F. Data Validation G. Data Input and Output H. Error-Handling I. Debugging Tools |
|
|