Programming Concepts - CIS52

Weekly Schedule

Schedule by week Information to cover - links are from other locations at this site
NOTE: This page will be updated during the week - the information posted should be checked multiple times during the week.
Week #1 Assignments
Week of June 3rd
Instructions if you are using COBOL with XP or 2000
Read the notes and view the PowerPoint presentation on name flip (data manipulation).
Name flip assignment
I will send you possible solutions when I get yours.
Review the use of functions in the languages you have taken - if your CIS51 did not cover functions, please read the notes on COBOL functions etc. They are under reference modification notes, notes on string and unstring, language features and especially functions. Be sure to review functions in C++, SQL and/or VB (whatever languages you have taken).
Review of COBOL PERFORM - look at the sample program under misc. Also look at COBOL sample programs using COPY and CALL. Notes also available under CIS51.
Review subroutines in VB (Notes under CIS56) and/or C++ and/or Oracle (Notes under CIS50).
Name flip assignment using functions This assignment must be passed in by the end of next week.
Week #2 Assignments
Week of June 10th
After you have submitted the name flip assignment - you can ask me to send you some solutions done by other students.
Label assignment: To be written in the language of your choice
Label Assignment
Data for the label assignment you need to create the file
Be sure to look at relevant notes and Powerpoint presentations!
Note - I messed up on some of my title codes in the label assignment - Miss Donald for example. Your choice, fix it when you create the data file or fix the table or stick with Miss Donald!
Week #3 Assignments
Week of June 17th
Start looking at the notes, presentations and samples for two and three file matching. Note that there is information for COBOL, VB and Oracle.
Note, both assignments can be written in the language of your choice.
Be sure you look at the examples on looping vertically through the files that I have added under COBOL and VB and the PowerPoint presentation.
Assignments: Please make the corrections to the program called one many that is noted to have errors. Some of the logic concepts are shown in the PowerPoint presentation on onemany. The running program should be passed in. Modify the files as needed to test completely - be sure that you test 111 on both files, 111 missing on the first file, 111 missing on the second file!
Three file assignment!
The next topic is going to be internal sorts. Please go to the following web site to see the algorithm for the bubble sort given in Java or C++:
Bubble Sort more information at: Bubble Sort
You should also look at the solutions I put out which use the DO until rather than the FOR loop to give you a different approach (VB).
Week #4 Assignments
Week of June 24th
Please review notes on random files with indexes and relative files in at least two languages.
Please look at the program examples on multiple files with random access (in COBOL only).
Internal sort/module programming assignment:
Sort program specifications
sortdata.dat Data to use with sort program - you need to create the file compatible with whatever language you are using.
Week #5 Assignments
Week of July 1st
Please review notes on random files with indexes and relative files in at least two languages.
Please look at the program examples on multiple files with random access (in COBOL only).
Review information on relational databases, normalization etc. You will find information under CIS50 and CIS61 since these are the two database courses.
Relational database notes and examples Goes with notes Introduction to multiple tables (relational) - joins - uses donor, donations and drive tables
      Separate speaker notes for relational database presentation
Normalization - information on third normal form
      Separate speaker notes for normalization presentation
Relational database examples - order system
      Separate speaker notes for relational database examples - order system
Student system relational database example
      Separate speaker notes for student system relational database example
Introduction to third normal form
Contribution system notes
Student data system notes
Notes on basic order entry
Payroll data notes
Medical clinic notes
Text book notes
Definitions
Notes on contribution or donation database design
Notes on very basic student database design
Relational database using donor
      Separate speaker notes to accompany relational databse using donors presentation
Relational Database Student System
      Separate speaker notes to accompany relational database student system presentation
Relational database order system example
      Separate speaker notes to accompany relational database order system example
Also start to look at the information about screens. This is COBOL only since languages handle screens so differently!
Review how to handle forms/screens in another language.
Week #6 Assignments
Week of July 8th
Start the week continuing to look at relational databases.
Order entry programming assignment
Be sure to look at the PowerPoint on screens with multiple lines of entry (COBOL) and the PowerPoint on this assignment.
If you are working in VB, be sure to review ADO controls (you can find information about them at this site and under both CIS56 and CIS67 - the two VB classes). If you are using C++ or Java for this assignment, you need to find a text on using random files with these two languages.
Assignment:
Order entry programming assignment
The good news is that this is the last major assignment!
Week #7 Assignments
Week of July 15th
Continue working on your programming projects.
Be sure you review ADO, research file handling in C++ if you plan to use it and spend some time looking at COBOL programs - be sure to look at the sample COBOL programs on screens - I suggest you download and run some of them to get a true view of how the screen looks.
We are also going to look at the concept of variable length records. The site has some COBOL samples that you should look at. Also please read the following:
Interesting explanation of variable length records and their practical application
I have a handout on unstructured programming in COBOL - send me an email with your address and I will send you a copy.
It is a good idea to have some idea of the development of programming styles: unstructured, structured and now object-oriented. The best I could find on the web dealing with unstructured programming:
some notes on unstructured
Other notes on unstructured (note it is a .pdf)
Week #8 Assignments
Week of July 22nd
Continue working on programming assignments.
Look at the information about COBOL Report Generators and relate to report generators you have seen in other languages and databases.
For information about the report generator in VB, please go to CIS67 and look at the sample programs dealing with data environment and reports and the sample PowerPoint presentations dealing with this topic.
Also review the notes on generating reports in Oracle and/or Access depending which course you took.
Also, please look at this information about Crystal Reports:
Crystal Reports
Another on Crystal Reports
Look at the PowerPoint Presentations on date conversion and the sample programs on date conversion. You will find samples at this site on COBOL and VB. Be sure you are comfortable with the concepts involved in working with dates.
Check back to see if I have added anything during the week next week.
Week #9 Assignments
Week of July 29th
We will now spend some time looking at systems analysis and design. Please read the notes under Systems Analysis and Design for Programmers and Business systems - notes for discussion.
Programming wise you should be working on the order entry project.
Week #10 Assignments
Week of August 5th
Some more on systems analysis and design.
Check out the following site for drawing software:
SmartDraw
There are also tutorials at this site - for example, the tutorial for DFDs is:
DFD Tutorial
And examples:
DFD Examples
Looking at Entity Relation Diagrams:
Entity Relation Diagrams
Looking at Systems Flowcharts (variety of styles):
Variety of Systems Flowcharts styles
Interesting information on flow
Assignment:
Assignment: Dairy System Assignment
What I need is for you to analize the dairy system, determine the output, input, files and processing that needs to be done. You are essentially responsible for giving me a plan - you can do a written analysis and a data flow diagram or a systems flowchart etc. You should also give me the layout of the files in a relational database. If you are doing this over the web we will probably need to go back and forth multiple times so be sure to say Dairy in the subject so I deal with it quickly!
Week #11 Assignments
Week of August 12th
We are going to deal with object-oriented COBOL and an introduction to CICS in COBOL this week.
Information on object-oriented COBOL
Look over the information at this site and sent you address to me at both my home and pgrocer@bristol.mass.edu so that I can mail you some handouts.
We will also cover lists, stacks and queues and linked lists. Examples in COBOL using stacks and queues are on the site. I will send you information on this topic as well.
Interesting potential site to use to get answers to questions: COBOL and CICS
Assignment:
There are three programs under Data structures in the COBOL examples. These examples deal with stacks and queues. Convert one of these three programs to another language and submit a running version of the program.
Week #12 Assignments
Week of August 19th
The topic left to look at is embedding SQL - the examples are using COBOL SQL - if you have taken VB you have seen SQL in VB - also can use with C++.
Information is available to be sent if you send me your address requesting it.
Final will be posted!
Week #13
Week ending August 26th
The final must be passed in 4:00 on Monday, August 26th. All students must take the final whether or not they will complete the course on time. The final is given on the honor system and I trust you to respect that - the only person you can discuss the final with is me!
If you have not passed in the final by 4:00 on Monday, August 26th, points will be subtracted. The status sheet is a requirement of the course - it is also your insurance to make sure that you and I have the same information - I will contact you if there is a problem!
Please send me the final using the usual email address and also send a copy to me at pgrocer@bristol.mass.edu.
Final Exam
Status Sheet - required
If you need a little extra time to complete the work, let me know. The summer involves the same amount of work with less time so I will be as flexible as I can. However, if something is going to be late, we must have agreed via email or penalty points will be taken from your grade.

Back to the Top


Send e-mail to Mrs. Grocer:
pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page