DAT 115 Concepts Note that while this course is described as “code-less” that does not mean that we will not use code. Quite the contrary -- it is impossible to learn the programming concepts without learning a great deal of code. Examples will primarily use Visual Basic but other “languages” such as DOS, HTTP (as used by WWW browsers), and Novell batch languages or applications such as Excel and Access or processes such as on-line DataBase searches may also be used to illustrate points in the text and discussion. Introduction To Computer Programming Data vs. Information, Hardware, Software, Data organization, Programming Process, Symbols Flowcharts Definition, Advantages and Disadvantages, Symbols (OPEN, READ, MOVE, WRITE, STOP, CLOSE), Coding For Symbols. Introduction To Structured Techniques Straight Line vs. Structured Programming, Advantages and Disadvantages of Structured Programming, Rules, Sequence Structure, Decision (Selection) Structure, Looping (Iteration) Structure, Psuedocode, Initialization (Housekeeping) Functions, Termination Functions. Reports and Displays With Headings and Footings Types of Reports, Report Contents and Formatting. Control Fields, Control Breaks and Non-Report Output Control Fields, Control Breaks, Non-Report Output, Output Files, Input Files Programs That Include Totals Single and Sub Totals, Counters, Types of Sub-Totals Input Validation. Interactive Input, and Menu Driven Programs Types of Input Validation, On-Line Data Entry, Batch Data Entry, Interactive Input, and Menu Driven Programs Extract Programs What an Extract Program Does, Criteria, Logical Operators (AND, OR, Exclusive OR, NOT), Efficiency Using Tables Definition, Table vs. Non-Table Processing, Tables In Extract Programs, Table Initialization and Compile Time vs. Execution Time Tables, Tables In Validation Programs, Sequential vs. Binary Search, Multidimensional Tables. Working With Sequential Files: Merging, Matching and Updating Programs File Access, Sequential File organization and Processing, Matching, Merging. Non-Sequential Processing Advantages and Disadvantages, Random and Indexed File organization and Processing, Pointers, Chains and Rings, Selecting A File or Database organization, Why Use A Database, What Is A Database Management System, Models (Hierarchical, Network, Relational). Sorts Definition, Embedded, Interchange Sort, Bubble Sort, Shell Sort, Advantages and Disadvantages of sort Methods. C:\!DOCS\MSOFFICE\WINWORD\TEMPLATE\NORMAL.DOT DAT 115 CONTENTS Charles V. Balch Charles V. Balch DAT 115 Concepts Note that while this course is described as “code-less” that does not mean that we will not use code. Quite the contrary -- it is impossible to learn the programming concepts without learning a great deal of code. Examples will primarily use Visual Basic but other “languages” such as DOS, HTTP (as used by WWW browsers), and Novell batch languages or applications such as Excel and Access or processes such as on-line DataBase searches may also be used to illustrate points in the text and discussion. Introduction To Computer Programming Data vs. Information, Hardware, Software, Data organization, Programming Process, Symbols Flowcharts Definition, Advantages and Disadvantages, Symbols (OPEN, READ, MOVE, WRITE, STOP, CLOSE), Coding For Symbols. Introduction To Structured Techniques Straight Line vs. Structured Programming, Advantages and Disadvantages of Structured Programming, Rules, Sequence Structure, Decision (Selection) Structure, Looping (Iteration) Structure, Psuedocode, Initialization (Housekeeping) Functions, Termination Functions. Reports and Displays With Headings and Footings Types of Reports, Report Contents and Formatting. Control Fields, Control Breaks and Non-Report Output Control Fields, Control Breaks, Non-Report Output, Output Files, Input Files Programs That Include Totals Single and Sub Totals, Counters, Types of Sub-Totals Input Validation. Interactive Input, and Menu Driven Programs Types of Input Validation, On-Line Data Entry, Batch Data Entry, Interactive Input, and Menu Driven Programs Extract Programs What an Extract Program Does, Criteria, Logical Operators (AND, OR, Exclusive OR, NOT), Efficiency Using Tables Definition, Table vs. Non-Table Processing, Tables In Extract Programs, Table Initialization and Compile Time vs. Execution Time Tables, Tables In Validation Programs, Sequential vs. Binary Search, Multidimensional Tables. Working With Sequential Files: Merging, Matching and Updating Programs File Access, Sequential File organization and Processing, Matching, Merging. Non-Sequential Processing Advantages and Disadvantages, Random and Indexed File organization and Processing, Pointers, Chains and Rings, Selecting A File or Database organization, Why Use A Database, What Is A Database Management System, Models (Hierarchical, Network, Relational). Sorts Definition, Embedded, Interchange Sort, Bubble Sort, Shell Sort, Advantages and Disadvantages of sort Methods. ////0%632 //?/0 #"654632 #"&547> ZxR% .@'B=1.' =941' Normal Heading 1 Heading 2 Heading 3 Heading 4 Heading 5 Heading 6 Default Paragraph Font Header Footnote Text List Table Footnote Reference Bibliography Example Quote Question Answer Heading UVZc0 Telecom_Out Telecom_In Page_Heading Title_Heading Charles V. Balch C:\!DOCS\DAT115\CONTENTS.DOCÿ@PostScript Printer LPT3: pscript Apple LaserWriter Plus Apple LaserWriter Plus Symbol Palatino Courier Courier New DAT 115 CONTENTS Charles V. Balch Charles V. Balch