| 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 September 2nd |
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 |
| Week #2 Assignments Week of September 9th |
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 of September 16th |
Instructions if you are using COBOL with XP or 2000 Be sure to keep backups of what you send! 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 of September 23rd |
I have been having modem problems - first it got hit by lighting and then the
replacement lasted a week! I am back on line and will try to get to things as
soon as possible, but as you can imagine there is a tremendous backlog! 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 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 of September 30th |
If you are using C++, try to do some research on using files effectively. In your
C++ classes you have covered sequential and relative file processing. If you are using COBOL, review VSAM and if you are using VB, review ADO connections. Please be sure to 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. We will look at this more next week. Assignments: Internal sort/module program: Sort program specifications sortdata.dat Data to use with sort program. |
| Week #6 Assignments Week of October 7th |
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 of October 14th |
We are going to start the week continuing to look at relational databases. Review your notes from either Oracle or Access - if you are working in VB be sure to review ADO controls. Order entry programming assignment Please look at the PowerPoint on screens with multiple lines of entry (COBOL) and the PowerPoint on this assignment. |
| Week #8 Assignments Week of October 21st |
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 #9 Assignments Week of October 28th |
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. You should also get a systems analysis and design book either from the library or you can borrow one from me that can be passed around. You should be reading some of the fundamentals of systems analysis and design - we are not doing depth here - if you go on to a four year school they will give you the depth course - we are trying to look at the basics. A good book if you are interested in acquiring a basic text is Systems Analysis and Design in the Shelly Cashman series by course technology. There is valuable information about the information in each chapter at Shelly and Cashman supplemental information to accompany each chapter Programming wise you should be working on the order entry project. |
| Week #10 Assignments Week of November 4th |
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 #11 Assignments Week of November 11th |
We are going to deal with object-oriented COBOL and an introduction to CICS in COBOL this week. Information on object-oriented COBOL Assignment: Game assignment |
| Week #12 Assignments Week of November 18th |
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. No assignments! |
| Week #13 Assignments Week of November 25th |
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 |
| Week #14 Assignments Week of December 2nd |
Note that my web site is having problems. It is accessible through dial up
connections and at BCC. There is a problem with the ATT Broadband domain name
server that will hopefully be fixed this week. Continue working on assignments. |
| Week #15 Assignments Week of December 9th |
Final Exam Stauts Sheet CIS91 does not appear to be posted on the final exam schedule. If you find it let me know. Since my last final is at 3:15 on December 20th, I am going to say that your exam is due then. Email it to me by that time at both my regular home email and my email at pgrocer@bristol.mass.edu. Let me know if there are any problems. |