| 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 ending January 25th |
Read the notes and view the PowerPoint presentation on name flip (data manipulation). Name flip assignment This assignment must be passed in by Tuesday, January 29th because I want to go over solutions! 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 Thursday, January 31st. |
| Week #2 Assignments Week ending February 1st |
We will be looking at name flip solutions this week! 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! |
| Week #3 Assignments Week ending February 8th |
Instructions if you are using COBOL with XP or 2000 I am having trouble with my email - be sure to keep backups of what you send and get back to me if you have not had questions answered in a reasonable time. 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 - 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 #4 Assignments Week ending February 15th |
Continue looking at the notes, presentations and samples for two and three file matching. 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. |
| Week #5 Assignments Week ending February 22nd |
Remember that Sanford will give the lecture on Thursday. The topic is file handling in C++. Friday we will not go in the lab because I want to go over the sort assignment. If I finish before the class is over, we can go in the lab then. Internal sort/module program: Sort program specifications sortdata.dat Data to use with sort program. |
| Week #6 Assignments Week ending March 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 #7 Assignments Week ending March 8th |
We are going to 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. |
| Week #8 Assignments Week ending March 15th |
We are going to spend some time in class reviewing ADO controls at the request of the
inclass students. |
| Spring Break Week ending March 22nd |
A time for us all to try and get caught up! |
| Week #9 Assignments Week ending March 29th |
We will spend some time on COBOL this week - mostly asking you to look at things.
Finish looking 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 will also look at variable length records this week so look at the sample COBOL programs on that topic. On the subject of variable length records, please read the following: Interesting explanation of variable length records and their practical application I have given out a handout on unstructured programming in COBOL - if you are taking this course via Distance Learning send me an email with your address and I will send you a copy. 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) 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. Finally, 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. |
| Week #10 Assignments Week ending April 5th |
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 #11 Assignments Week ending April 12th |
We will continue working on systems analysis and design with emphasis on the business systems. |
| Week #12 Assignments Week ending April 19th |
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: 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 #13 Assignments Week ending April 26th |
We are going to deal with object-oriented COBOL and an introduction to CICS in COBOL this week. Information on object-oriented COBOL Please note that I had a very serious problems with my email today (4/24). I think I finally got everything, but if you sent me something today and I do not get it back to you sometime next week, please send me an email asking if I got it. |
| Week #14 Assignments Week ending May 3rd |
This week we will cover lists, stacks and queues and linked lists. Examples in COBOL using stacks and queues are on the site. Send me your address so I can send you some information from this week. |
| Week #15 Assignments Week ending May 10th |
I have not gotten any inqueries about the Bristol Dairy assignment - let me know
if you have questions. The topic left to look at is embedding SQL and CICS - the examples are using COBOL with CICS and 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. Interesting potential site to use to get answers to questions: COBOL and CICS The final must be passed in by 3:15 on Tuesday, May 14th. If you have not passed the final in by then, you must take the final during the scheduled time. Please send a copy of the final to the usual address and to pgrocer@bristol.mass.edu. The final is given on the honor system - you may not discuss with anyone but me! If you are definately planning to take an incomplete in this course, send me an email and lets discuss whether you should take the final or not. Final Exam Status Sheet - required |