| Week | Information |
|---|---|
| You may do these programs in the language of your choice, however be sure you are comfortable with file management using sequential and randomly accessed files in the language you choose. NOTE: This page will be updated during the week - the information posted should be checked multiple times during the week. Also note the new format - week 1 is at the bottom. | |
| Week #15 Assignments Week of December 11th |
Contact me when you are ready for the final. |
| Week #14 Assignments Week of December 4th |
Please continue to work on assignments and your portfolio. |
| Week #13 Assignments Week of November 27th |
Please continue to work on assignments and on your portfolio. |
| Week #12 Assignments Week of November 20th |
I would like you to look at Decision tables and CPM/Pert this week - I would also like you to go
to Microsoft and download the Project Manager and play with that. Project Manager Assignment: I want you to produce an electronic portfolio at the end of the course with projects you have done. Start thinking about how to do this. Pert/CPM assignment Extra Credit: Use the project manager to set up a project of your own design. Include an explanation of what you did. Just maybe decision tables will most likely show up on the final. |
| Week #11 Assignments Week of November 13th |
This week we will cover lists, stacks and queues and linked lists. Examples in
COBOL using stacks and queues are on the site. Assignment: Continue working on projects! Set up a del.icio.us site this week (del.icio.us is the web address) and find some links that deal with using lists, stacks and queues and bookmark them at del.icio.us. Send me the address. |
| Week #10 Assignments Week of November 6th |
This week we will continue to look at business systems. You should be working on
the processing for the dairy system. Assignment: Game assignment Note that this needs to be a different game then the one you did in CIS67 or any other class for that matter. Send me the idea of the game you decide to do for approval. For the dairy system, you need to send me a systems flowchart along with a brief explanation of the processing that is being done. |
| Week #9 Assignments Week of October 30th |
We will start to look at a business system. Assignments: 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 should send me a list. Then we will move on to designing the processing. |
| Week #8 Assignments Week of October 23rd |
If you know VB, please review ADO this week. If you are in C++ or Java please
review and research how to work with files. If you are in COBOL, please review
VSAM. The Order Entry program is best done in COBOL or VB unless you are
heavily into files. You might explore and see if you can find something like
ADO for the C++ under Visual Studio On the subject of variable length records, please read the following: Interesting explanation of variable length records and their practical application You should also do a little reading on unstructured programming: 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) I assume you have all had a course that dealt with object-oriented programming. I want you to basically think about the transition that programming has gone through from unstructured programming, to structured procedural programming to object-oriented programming. Be sure you are reading the information about design. We will discuss the concepts of analysis and design this week. Assignments: Continue working on your programming assignments! |
| Week #7 Assignments Week of October 16th |
Continue to look at relational databases. Assignments: Order entry programming assignment Be sure to look at the PowerPoint on screens with multiple lines of entry (COBOL) if you are using COBOL and the PowerPoint on this assignment. This is the major assignment for the semester! I will give you several weeks to work on it. |
| Week #6 Assignments Week of October 9th |
Notes on design you
should read In the systems text you have, start reading about design. After you have read the fundamentals of analysis and design, I will give you a small system to analyze and then design a solution for. 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 #5 Assignments Week of October 2nd |
Please start to research file handling in a variety of languages that you know:
COBOL, VB, C++, Java or whatever languages you are comfortable with. Internal sort/module program: Assignments: Sort program specifications sortdata.dat Data to use with sort program. |
| Week #4 Assignments Week of September 25th |
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. The next topic is going to be internal sorts. Please go to the following web site to see the algorithm for the bubble sort (note I have not tried the code, so...) Bubble Sort Bubble Sort VB You should also do some sorts on your own and see what you find. Assignments: Three file assignment |
| Week #3 Assignments Week of September 18th |
Start looking at the notes, presentations and samples for two and three file. Read information about Systems Analysis (books are really available in my office). Be sure your reading includes Data Flow Diagrams (DFD) and Data Dictionaries. Do some research on your own, and check out the links I found (under links - Data Flow Diagrams and then the ones I just found are under Look at these - check out the others as well). If you do not know HTML/XHTML I want you to learn the basics so you can create a portfolio. You can get the information from my CIS17 website, my CIT11 website and/or my CIS44 website. Please let me know whether or not you are comfortable with basic HTML. Assignments: Continue working on the label assignment. 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! One to many assignment |
| Week #2 Assignments Week of September 11th |
Read about Prelimiary Investigation and the Systems Life Cycle. Check some of the links at the
site. Notes on systems and life cycle Assignments: Continue working on the label assignment. |
| Week #1 Assignments Week of Spetember 4th |
This is the capstone course for the programming option. You will be writing complex
programs in the appropriate language of your choice. You should develop a portfolio
of your work as the semester progresses. I want you to create an online portfolio where you can show case your work this semester and previous work that you have done. We can decide what should be in the portfolio as the semester progresses.Br> You can also research some applications for setting up portfolios or you can do it using HTML. If you do not know HTML, we will include the basics in this course, so let me know. This class will also deal with basic concepts of systems analysis and design along with programming. I have provided notes at the site for the systems portion of the course, but I would also like you to acquire a book. You can get a book from the library or contact me to borrow a book or purchase a book on the topic. If you decide to purchase a book, I recommend Systems Analysis and Design by Shelly and Cashman. Recommended text When you get a systems book start reading it on a regular basis so you have completed the book by the middle of this course. If you have problems getting a book, let me know and I will lend you one. Read the notes and view the PowerPoint presentation on name flip (data manipulation). 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) and.or Perl (Notes under CIS47). If you have a project your are interested in pursuing, please send me a proposal and we may be able to include it as part of the course. Assignments: 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! Note, some students have displayed the two-up labels on the screen rather than printing. That is acceptable, but you should figure out how to print as well. |