|Schedule by week||Information to cover|
Free PowerPoint viewer for 97,2000,2002 users|
Note that the speaker notes are provided on a separate Word document if you are having trouble accessing them! You should check the schedule multiple times a week, sometimes I add things during the week. Please keep copies of all work you submit until you receive your final grade at the end of the semester.
|After finals||I have spent the last week at the hospital in NY because of serious complications with the birth of my granddaughter, so my grades will not be posted for about a week. I am working on them slowly, I just did not want you to be concerned.|
Week of December 12th
|I will not be in this week, for family reasons.
Just rechecked the calendar and Friday is officially the last day of classes.
I can be contacted via email and Mark and Wayne will be there for all of my classes to help with any problems.
There will be an open lab from 9:30 to 3:15 on Tues and Thurs and Mark and Wayne will be there for help.
I will email you your final by this Tuesday the 13th and it is due by noon on Tuesday the 20th.
|Week #13/#14 Assignments
Week of November 28th/December 5th
|Catch up week.
Be sure you have read the entire textbook including the things at the back of the book, the appendix.
Finish up portfolio, projects and New Century.
Week #14 is continuing the projects but also please check back!
Week of November 21st
| I will be around on Tues for catch up and help from 1:45 until around 5.
Good news! Week #13 will be a catchup week!
If you have not finished creating an electronic portfolio, now is the time.
Please be sure you have read the entire book - your final will definately be easier if you have.
The dairy project should include the following documentation: description of the system, DFD, systems flowchart, programs (list all and document 1), files (list and layout fields for all and document 1 (dictionary)), reports (list and layout fields for all and document 1 (dictionary)), input (list and layout for all document 1). I also want an implementation plan. If you have questions, please contact me. I would go with the examples in your book.
Week of November 14th
|Read chapter #10 - we will not cover it this week but I want to keep you reading one chapter
at a time, so...
We need to start getting me the systems flowchart for the dairy. When that is set, I want you to pull together a documentation package that will include the listing of input and output and files, the DFD, the systems flowchart and documentation. We will talk about what that means this week.
Evaluate two of the software packages I asked you to find. You want to understand what functions they can accomplish (payroll, order entry, accounts receivable, accounts payable, inventory etc.). You want to look at them related to the business notes I had you read and your own experience and evaluate whether they would work for a small company trying to set up a portion of their business with this software. Look at ease of use, whether the package works, whether it is flexible, whether in fact you could recommend it to a client.
Week of November 7th
| This week we will continue looking at systems design including systems flowcharts and talking
about some standard business systems.
Please read chapter #9 in the text.
Read the information on Systems Analysis and Design Toolkits (if you haven't already) up through part #4 with special focus on PERT/CPM charts - you will also find notes at the site on this topic.
I think it would be beneficial to meet or set up a webhuddle meeting or try instant messaging or something - this tends to me the place where people have trouble.
Pert/CPM assignment We worked on this in class so if you were in class, you do not need to pass it in - extra credit if you finish the project and pass it in.
I want you to continue working on the dairy system. This week I want you to draw the systems flowchart and explain briefly what each of the programs does.
Continue with New Century Health Clinic.
The good news is that the last few weeks will be catcu up weeks. If you need to meet with me on any of this let me know and we will set up a time.
Week of October 31st
Please read chapter #9 in the text and start into the next chapter. We will still continue studying design, databases,
First, you need to design a DFD for this project and I want you to draw one.
Second, we are going to decide on the storage/database etc that will be needed. I want you to make a list of tables in third normal form including keys/indexes.
(Be sure to include fields)
Continue with New Century Health Clinic.
Start working on the portfolio.
Week of October 24th
|Please read chapter #8 in the text. We will continue studying design, databases, IO etc.
Dog Store Database assignment
We will be working on this via email for a couple of weeks. I would suggest that you make some time to go over this with me through email conversation or in person.
First, I want you to decide on the output and input that would be produce and give me a list.
Continue with New Century Health Clinic.
Week of October 17th
Please read chapter #7 in the text.
You should spend this week being sure you are comfortable with Access, relational databases and normalization - hopefully the assignment will have introduced you to the concepts.
Sorry I have gotten behind in correcting - we all need to work on this - you getting assignments in and me getting them back!
Assignments: Credit Union Assignment
Continue with New Century Health Clinic. I want the essence of what the chapter goes over - not all the questions and not all the details. I just want you to follow the development through chapter by chapter.
Week of October 10th
|Please read chapter #6 in the text. You should also look at the additional information
about relational databases and normalization at this site. We will spend
time on that this week.
Since most of you are comfortable with Access (if you aren't be sure to look at the Access tutorials), I am going to ask you to start thinking about normalization as you follow these two example/tutorials.
Assignments: Using Access, I want you to create the following two databases:
Student database example
Payroll database example
Continue working on the New Century Health Clinic at the end of the chapter.
Week of October 3rdt
You can get books related to this course from the BCC LRC on line if you are looking for things to supplement. Contact the LRC and ask about how!
This week we are going to spend time on DFD diagrams.
Please go over the Systems Analysis and Design Toolkits for Communication Tools, Case Tools and Financial Analysis Tools in your textbook.
Be sure to check for notes under notes and handouts that would be helpful in understanding the analysis phrase.
I decided to wait until next week to assign chapter #6.
Tickets DFD assignment
You need to send me a draft of your design and we need to go back and forth. So, to do this I would like you to set up a google doc account and put your draft up there and invite the other student taking this class to take a look and comment.. Please do not go into comment until you have something you have put up that you can share.
Week of September 26th
Please read chapter #5 in the text.
We will start focusing on Data Flow Diagrams.
I want you to spend a lot of time going over the examples in the text (chapter #4) and the example out on one of my presentations very carefully. Be sure you understand them.
I want you to do a Data Flow diagram for something you are familiar with. Processes that you do at work would be ideal. Put together a diagram and send it to me with an explanation. I am not going to grade this assignment, I am just going to check it off (maybe a check plus for more details).
Continue answering the questions about the New Century Health Clinic at the end of the chapters. At the end of the semester, you should have worked your way through the complete case.
|As you have probably gathered, we will use the text book as only one of our resources to
understand what analyzing a system is about. This week I would like you to read chapter #4 in
the text book.
I want you to look at decision tables this week. Please read the information posted under notes and handouts and do some research on the web. I also want you to look at the information about data flow diagrams very carefully and I would also like you to research them on the web as well. We will look at them both this week and next.
Decision Table assignment
I want you to start working on the New Century Health Clinic project in the back of the chapters. Go back to chapter #1 and start to sketch out the project. This project will span the semester.
|Remember that this is a capstone course - you should keep a portfolio of your work to pass in at
the end of semester (it should be web based). I would like you to upload
samples of things you have done during your studies in this major. We will look more at your final
portfolio later in the semester.
Read chapter #3 in the text.
I would like you to do some reading about copyright and fair use. Some suggested sites are:
University of Maryland Copyright and Fair Use
Stanford Copyright and Fair Use
Copyright crash course
Medical Library Association on copyright and fair use
I would also like you to read some information on computer ethics:
The Ten Commandments of Computer Ethics
ACM code of ethics
Computer Ethics (explore some of the information at this site)
Please take this quiz. This is a check off assignment and not a graded assignment so be honest and test yourself. Tell me which ones you got right and which ones you got wrong.
Quiz on copyright and fair use
Write a short paper explaining copyright, fair use and ethics in a way that could be put in a company handbook and that would apply to web development and Internet resources..
|Read chapter #1 and #2 in the text. I can ask the bookstore to order the text if you need me
to, but since I believe there are only one or two people taking the course I would suggest
an online purchase. Explore some of the information and resources at the text book site.
Text book site
Part of your work this semester will be to prepare a portfolio of your work. You should spend some time this week looking at sites that talk about what should be part of an electronic portfolio and figuring out what you want to have in yours.
While you are getting the textbook, please start with some research on ecommerce and some review of spreadsheets. If you are not comfortable with spreadsheets and need more information, let me know and I will find a text book for you to use.
First e-commerce assignment: eCommerce
Spreadsheet assignment: Southworth Nursery spreadsheet due in two weeks to give you time to review Excel