Volkers Web Site

Programming Logic - Intermediate
Last revised: March 26, 2015

Syllabus

Instructor's Notes  
Text Files
     Basics of Classes
     Standard Dialog Boxes
Unit 1 YouTube Videos
Instructor's notes for processing text files.
Notes for how to create a basic, custom class
Notes for how to implement C#'s standard dialog boxes
Input Validation
Unit 2 YouTube Videos
Instructor's notes for thorough data validation techniques
Database Basics
Unit 3 YouTube Videos

     Database Access Concepts (PowerPoint)
     Database Access Concepts (PDF)
 
Instructor's notes for accessing databases using Visual Studio

PowerPoint/PDF of Form-to-Database connectivity concepts.

Database Basics II
Unit 4 YouTube Videos
Instructor's notes for how to add a professional touch to your database applications.
Crystal Reports
Unit 5 YouTube Videos
Instructor's notes for creating Crystal Reports and displaying/printing them from Visual Studio
 
Arrays and Collections Instructor's notes for implementing arrays and collections
Menus, Toolbars and Status Bars Instructor's notes for implementing menus, toolbars and status bars.
Printing in C#.Net How to create custom reports in C#.Net
C#: How To How to accomplish tasks that I always seem to forget how to do and can never find again in my resources.


Assignments  
Due Date Policies Policies regarding assignment due dates, NQA coupons, updates and tickets
Tickets Daily mini-assignments required to get into the next class period.
Pseudocode Standards Standards for pseudocode used in this class
Programming Standards Course programming standards to be applied to all projects
String Function Journal Create a journal documenting the String functions demonstrated in class
Unit 1 : Text File Processing Update the Assignment Tracker program to save assignments to a file.
Unit 2 : Gas Estimate Validation Modify last semester's Gas Estimate program to incorporate a business class that validates data.
Unit 3 : Database Basics
            Part 1
            Part 2
            Part 3

     Assignment Databases:
     Students
     DVDs
     Members
     Car Maintenance
 
Assignment to create a data entry form.

 



Access databases used for the assignments.
(Right-Click, Save Target As)

Unit 4: Database Applications-Phase II
            Part 4
            Part 5
            Part 6
 
    Assignment Databases:
     Students
     DVDs
     Members
     Car Maintenance
 
Assignment to add insert record and duplicate record check capabilities (among others)

 

 

Access databases used for the assignments.
(Right-Click, Save Target As)

Unit 5: Crystal Reports Assignment to create Crystal Reports
Unit 6: Arrays and Lists Assignment to create an on-line quiz or a matching game.

Labs Guided Learning Exercises
Unit 1 - Standard Dialog Boxes Lab to demonstrate and experiment with Open and Save dialog boxes.
Unit 2 - GUI Validation Programming Lab to demonstrate how to use Error Providers to display business class errors in the GUI.

Evaluation Sheets Evaluate your own programs before turning them in.
Unit 1 - Text File Processing Evaluation sheet for the Assignment Tracker project.
Unit 2 - Gas Estimate Validation Evaluation sheet for the Enhanced Gas Mileage project.
Unit 3 DVD Part 1 Evaluation sheet for the DVD database project (Part 1).
Unit 3 DVD Part 2 Evaluation sheet for the DVD database project (Part 2).
Unit 3 DVD Part 3 Evaluation sheet for the DVD database project (Part 3).
Unit 3 Car Maintenance Part 1 Evaluation sheet for the Car Maintenance database project (Part 1).
Unit 3 Car Maintenance Part 2 Evaluation sheet for the Car Maintenance database project (Part 2).
Unit 3 Car Maintenance Part 3 Evaluation sheet for the Car Maintenance database project (Part 3).
Unit 3 Club Member Part 1 Evaluation sheet for the Club Member database project (Part 1).
Unit 3 Club Member Part 2 Evaluation sheet for the Club Member database project (Part 2).
Unit 3 Club Member Part 3 Evaluation sheet for the Club Member database project (Part 3).
Unit 3 Student Part 1 Evaluation sheet for the Student database project (Part 1).
Unit 3 Student Part 2 Evaluation sheet for the Student database project (Part 2).
Unit 3 Student Part 3 Evaluation sheet for the Student database project (Part 3).
Unit 3 Student Select Part 1 Evaluation sheet for a student selected database project (Part 1).
Unit 3 Student Select Part 2 Evaluation sheet for a student selected database project (Part 2).
Unit 3 Student Select Part 3 Evaluation sheet for a student selected database project (Part 3).
Unit 4 DVD Part 4 Evaluation sheet for the DVD database project (Part 4).
Unit 4 DVD Part 5 Evaluation sheet for the DVD database project (Part 5).
Unit 4 DVD Part 6 Evaluation sheet for the DVD database project (Part 6).
Unit 4 Car Maintenance Part 4 Evaluation sheet for the Car Maintenance database project (Part 4).
Unit 4 Car Maintenance Part 5 Evaluation sheet for the Car Maintenance database project (Part 5).
Unit 4 Car Maintenance Part 6 Evaluation sheet for the Car Maintenance database project (Part 6).
Unit 4 Club Member Part 4 Evaluation sheet for Club Member database project (Part 4).
Unit 4 Club Member Part 5 Evaluation sheet for Club Member database project (Part 5).
Unit 4 Club Member Part 6 Evaluation sheet for Club Member database project (Part 6).
Unit 4 Student Part 4 Evaluation sheet for the Student database project (Part 4).
Unit 4 Student Part 5 Evaluation sheet for the Student database project (Part 5).
Unit 4 Student Part 6 Evaluation sheet for the Student database project (Part 6).
Unit 4 Student Select Part 4 Evaluation sheet for a student selected database project (Part 4).
Unit 4 Student Select Part 5 Evaluation sheet for a student selected database project (Part 5).
Unit 4 Student Select Part 6 Evaluation sheet for a student selected database project (Part 6).
Unit 5 Crystal Reports - DVD Evaluation sheet for the DVD Crystal Reports project.
Unit 5 Crystal Reports - Student Evaluation sheet for the Student database Crystal Reports project.
Unit 5 Crystal Reports - Car Maintenance Evaluation sheet for the Car Maintenance Crystal Reports project.
Unit 5 Crystal Reports - Members Evaluation sheet for the Members Crystal Reports projects.
Unit 5 Crystal Reports - Student Select Evaluation sheet for the Student Select Crystal Reports project.

Handouts  
Visio Instructions Quick and dirty instructions for using Visio to create flowcharts
Go To Microsoft Dreamspark Site Link to the site where you download/request free software
Registering for Free Software How to register to get free program development software from the Microsoft DreakSpark.
Installing Visual Studio 2013 Tips on how to install Visual Studio 2013 using the least amount of hard drive space and in the quickest time possible.
ASCII Table Web page showing the ASCII value of each character
Image Manipulation
Image Manipulation Video
How to change existing images: format, size, cropping, transparency. Demo using Paint.Net
3-Tier Architecture Visual diagram of the the 3-tier architecture of program design

Programming Tips
Interface Hall of Shame What NOT to include in your interface.

Icons, Clip Art and Other Graphics
Icon Archives Well organized, lots of icons

 
MSTC Stevens Point