| Assignments due in one week unless otherwise stated.
I may add some things during the week, so double check the schedule
each week! For almost all the assignments I want to see the code you write and the output it produces. So send me
the address and a copy of the code. With play computer assignments give me the code and the output as you feel it
would be generated. Please keep copies of all work you submit until you receive your final grade
at the end of the semester.
Remember that I record/tape all my classes and capture notes on the Smartboard. These are available to you under Audio and Smartboard.
|HELP schedule||I will set up some optional class Zoom meetings that you can attend. Check the week of information to see the times and dates.
Milo is the tutor or SI for this class. I will send you the information about Milo's Zoom address and his hours. My office hours are 11 on Monday, 2 on Tuesday, and 11 on Wednesday. I hold my office hours on Zoom, but let me know you are coming. If it turns out other hours work better for students these may change, so check back. I am also available by request (give me a few time options) especially while we get other support in place. I have been meeting with a lot of students that request it, maybe something you should consider doing. You can email me with a couple of times you can meet and usually one of those will work.
I will send out the information to contact me on Zoom. I will post availability but you can also set something up with me.
Downloading WinSCP on your PC by SI Joe Fletcher
There is access to WiFi from your car under the solar canopies on the Fall River Campus.
Notes on downloading Office 365 which contains Access: 1) To get Access (part of Office 365) you first log in to accessBCC 2) You then select Office 365 Dashboard 3) You will see some Office products listed on the side and on the right you will see a button that says Install Office - click on the button 4) You want the first choice in the popup you see - Office 365 apps 5) Save the OfficeSetup.exe and then run it (when asked about making changes I said yes) 6) Now it downloads office including Access.
|DUE DATES||Homework is due on May 14th.
I will take a few things after that if we have an email conversation, but everything is due on May 17th.
Because of the technical problems there will be no final unless you personally request one. We would need to talk about dates etc.
One of the things I do at this point is cover sending emails. We are still going over it but I am not sure that we will be able to test emails. IT is working on it now. If we do not get it working, you can just send me the code.Milo has changed his hours to help. On the week of May 15th he will be available at these hours:
Monday 2pm - 5pm , 7pm - 9pm
Tuesday 1:30pm - 5pm , 7pm - 9pm
Wednesday 1:30pm - 5pm
Week of May 8th
INFORMATION:REQUIRED STATUS SHEET
The status sheet must be passed in - I cannot grade until I have checked your work to see if anything is missing!
Week of May 1st
INFORMATION:At the beginning of the week we will look at images.
Then we will look at email, cookies and sessions.
Please read the following:
More on sessions
EXAMPLES TO LOOK AT:Images First Group PHP zipped
Images Second Group PHP zipped
Email Group One PHP zipped
Email Group Two PHP zipped
cookies session zipped
More on session guess games
TOPIC VIDEOS:Images in First Group
Images in First Group continued
Images in Second Group
Images in email
Using databases in email
Form using header(location)
Sessions using guess game
SMARTBOARD AND AUDIO NOTES FROM Spring 2018/2019/2020 and Fall 2019:Images first group (4/18/19) in PDF format Partial accompanying audio
Third Arrays and first images (4/18/19) Accompanying Smartboard presentations
Images second and email first (4/23/19) in PDF format Partial accompanying audio
Second images and first email (4/23/19) Accompanying Smartboard presentations
Email and sessions and cookies (4/30/19) in PDF format Partial accompanying audio
Email and sessions and cookies (4/30/19) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:Quiz: Quiz on databases and images Just to clarify when you bring up a random picture I want the address taken from the database table to be used. Really more like homework!
One of the things I do at this point is cover sending emails. We are still going over it but I am not sure that we will be able to test emails. IT is working on it now. If we do not get it working, you can just send me the code.You need to identify yourself on the emails you send through PHP so I know who sent them. I have had some that were unclaimed in previous years, so if you have not heard back, resend
First: Make a email using html and php. It should include an image, color and several different html features.
Second: Set up a database table with idno, name, email and major. Send an email to everyone in the database. Clearly I should be in the database.
Please test sending it to yourself and only send me the email when it is working - you need to send it to my Bristol email.
Actually the Bristol email seems to have problems with images so test things out with your own email address.
Sessions assignment: Write the Rock Paper Scissors game where you use sessions and gather information on one page and check it on another page. Check back!
Week of April 24th
INFORMATION:We are going to continue looking at arrays this week. We are also going to look at updating.
EXAMPLES TO LOOK AT:Array Group Second PHP zipped Started last week.
Array Group Third PHP zipped
EXAMPLES TO LOOK AT updating:Here are some examples of updating.
The program RecordUpdate3OK.php deals with add, change and delete.
TOPIC VIDEOS:Misc in Second Array Group
Array second another2dim (first two)
Array second another2dim (next two)
Misc examples from third array group
Misc examples from third array group continued
Sequence of programs about rainbow colors
TOPIC VIDEOS on updating:Insert into MySQL using PHP
Delete and update MySQL using PHP
More on insert, update, delete MySQL using PHP
Continuing ACD (add, change, delete) MySQL using PHP
SMARTBOARD AND AUDIO NOTES FROM Spring 2018/2019/2020 and Fall 2019:Second/Third Arrays (4/16/19) in PDF format Partial accompanying audio
Note the Smartboard was a problem and the second part of Third Arrays was lost. I suggest you look at Spring 2018 c159Apr1218.pdf).
Second/Third Arrays (missed the first part) (4/16/19) Accompanying Smartboard presentations
More arrays (4/10/18) Accompanying audio
More arrays (4/10/18) Accompanying Smartboard presentations
Even more arrays (4/12/18) Accompanying audio
Even more arrays (4/12/18) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:Solve using arrays
Update program: Write a very basic updating program. I suggest you use a file with only a few fields and follow my model. You can write on your own or use another model you find and modify (if you do this give me the address of the code you used). I should add that I do not want the data to add or change etc hard coded in the program.
Full credit if you add, change and delete. Partial credit if you do one of them. Check back!
Week of April 17th
INFORMATION:I have been sick (not Covid) so I got behind. I am feeling better and will try to get caught up this weekend.
Because of the difficult beginning of the semester, I have decided not to have a final this semester. This means that the homework/quizzes etc will count for 90% of the grade instead of 80% to make up for no final. If you truly want a final, you need to contact me and we can make a plan. This will also give you some free time at the end of the semester.
This week we are going to start to look at arrays. We will return to updating after we cover arrays.
EXAMPLES TO LOOK AT:Array Group First
Array Group Second PHP zipped Start this - it will also be next week.
TOPIC VIDEOS:Introduction to arrays using using PHP
Two dimensional array using PHP
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019:Intro arrays and guest speaker (4/9/19) in PDF format Accompanying audio
Intro arrays and guest speaker (4/9/19) Accompanying Smartboard presentations
Arrays continued (4/11/19) in PDF format Accompanying audio
Arrays continued (4/11/19) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:Math Array
Assignment:The statements Multiply by 0, Multiply by 1 are stored in a one dimension array and displayed. You need to extract the message from the array and display it before you show each group. You are going to display the math facts and the answers. The answers need to be stored in a two dimensional array. Set up a two level table to print out the math facts and get the answer from the two dimensional array. The two multipliers are the indexes that allow you to extract the answer. I used a nested while loop to do this and another time I used a nested for loop.
To clarify (I hope)... So there should be one array that has messages in it: Multiply by 0, Multiply by 1 etc. Every time you change to multiply by a different number, you display one of them. Then you are going to set up a loop with i and j or x and y whatever. To get the answer you want to display you need to go to a two dimensional array that contains the answers and extract them using the i and j or x and y or whatever. So for the first problem i is 0 and j is 0 so you use those to go to the two dimensional table and extract the answer of 0. For the last problem k is 4 and j is 4 so you use those to go to the two dimensional table and extract the answer of 16. It is kind of like extracting the miles from one city to another using two indexes (from city and two city). Here you are using two indexes that are the two numbers you are multiplying.
Week of April 10th
INFORMATION:This week we will look at functions in PHP.
EXAMPLES TO LOOK AT:FunctionGroupPHP.zip
get proc 1 and 2
get proc 3 and 4
ASSIGNMENTS TO DO:Please listen to last weeks recording of the CIS Alum panel if you haven't.
CIS Alum Panel Spring 2023
Week of April 3rd
INFORMATION:Now we will move on to ThirdConnectGroup.
EXAMPLES TO LOOK AT:Third Connect Group zipped
Sometimes you may find an extra program being discussed or some small change made when you look at the videos. I experiment sometimes!
TOPIC VIDEOS:Insert into MySQL using PHP
Delete and update MySQL using PHP
More on insert, update, delete MySQL using PHP
Continuing ACD (add, change, delete) MySQL using PHP
Misc other things using PHP and MySQL
Rest of the misc exmples in Third Connect Group using PHP and MySQL
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019:Connecting PHP and MySQL cont (3/19/19) in PDF format Accompanying audio
Connecting PHP and MySQL cont (3/19/19) Accompanying Smartboard presentations
Third Connect Group (3/26/19) in PDF format Accompanying audio
Third Connect Group (3/26/19) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:Please listen to todays recording of the CIS Alum panel.
CIS Alum Panel Spring 2023
PHP connect quiz
Third Connect Group Assignment
Week of March 27th
INFORMATION:On April 5th there will be a round table discussion of CIS alum talking about their careers and the paths they took. It is always a great session and students tell me how much they benefit from it. There is a question and answer session. The roundtable runs from 12:00 to about 1:00 to 1:30 depending on the conversation. I will send you the address.
We will look a some more at SQL, relational databases and then move on to linking MySQL into PHP.
We will finish up our quick introduction to MySQL and using SQL and start incorporating it into PHP.
EXAMPLES TO LOOK AT:First Connect Group zipped
Second Connect Group OK
TOPIC VIDEOS:First Connect Group
Second Connect Group part 1
Second Connect Group part 2
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019:Finishing SQL & Connecting (3/3/20) in PDF format Accompanying audio
Finishing SQL & Connecting (3/3/20) Accompanying Smartboard presentations
Relational database (3/5/20) in PDF format Accompanying audio
Relational database (3/5/20) Accompanying Smartboard presentations
Connecting MySQL and PHP (3/10/20) in PDF format Accompanying audio
Connecting MySQL and PHP (3/10/20) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:Basic Connect
Week of March 20th
INFORMATION:We will move on with our overview coverage of SQL within MySQL.
We will be using putty to work with MySQL. Two sites that can be used to download PuTTY are:
Using Putty (copy and paste)
EXAMPLES TO LOOK AT for MySQL:Keys, indexes etc.
TOPIC VIDEOS:Keys and indexes etc
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019:More MySQL (thru indexes) (2/26/19) in PDF format Accompanying audio
More MySQL (thru indexes) (2/26/19) Accompanying Smartboard presentations
MySQL (thru functions) (2/28/19) in PDF format Accompanying audio
MySQL (thru functions) (2/28/19) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:workingwithSQL.doc Play computer (do not actually run) and show me the output that would be produced.
SQL Assignment 2
Week of March 13th
|In working with the temporary fix using vdi.bristolcc.edu I found that Chrome and Edge worked for me - had trouble with my usual
Note that what I put in for March 20th was for later in the semester. It has been fixed. I knew trying to keep ahead was going to mess me up at some point and it did. So... If you did the work it will be due - just there were other things before I got to them! Sorry!
Week of March 6th
INFORMATION:We will start out by looking at the layout of tables when we create a database. Specifically we will look at third normal form. Then we will look at SQL focusing on the notes from last week. Next week we will look at multiple tables in SQL among other things.
Notes on relational database
I have an eye infection problem so my eyes need some rest time during the day and I am continuing to get behind. Sorry!
The MySQL notes from last week and this week will be the major source of information to do the assignments.
Be sure to look at the notes I sent about using Horizon and putty (they are notes and videos from Janelle).
Two sites that can be used to download PuTTY are:
Using Putty (copy and paste)
My office hour at 10 on Thursday is cancelled.
EXAMPLES TO LOOK AT for MySQL:Beginning MySQL notes (repeat from last week)
TOPIC VIDEOS:3rd normal form - intro student
3rd normal form - order and donor
3rd normal form - one to many
MySQL more SQL
MySQL more SQL continued
ASSIGNMENTS TO DO:SQL assignment I know the directions say picture of screen but in fact I would prefer just copying the output and pasting it in so it is more readable - check putty directions for doing this!
Note that in the sample, I took an example I had used in Oracle. You need to check out how to do the date in MySQL. For students taking Oracle and MySQL I wanted to highlight the similarity in SQL.
Week of February 27th
INFORMATION:We will start out by looking at or continuing to look at GroupThreePlusPHP Boston Tea Party, GroupFourPHP and GroupFivePHP.
Please note that when you are dealing with a database in MySQL, the IT people have set up 2 databases for students to use. The databases for each student are studentid_1 and studentid_2 so jdoe11_1 and jdoe11_2 would be an example.
EXAMPLES TO LOOK AT for PHP:Some are repeated from last week since these topics really run over last week. Third Group Plus PHP zipped
Fourth Group PHP zipped
Boston Tea party example PHP zipped
Fifth Group PHP zipped
TOPIC VIDEOS for PHP example:Group 5 examples explained
Topic videos for 4 and Boston Tea are under last week. Coverage of these spread over two weeks.
In using these notes remember that the port is now 220.
EXAMPLES TO LOOK AT for MySQL:Beginning MySQL notes
Things that change! Note that the host is cisweb.bristolcc.edu, the port is 220 and the prompt does not have MariaDB in it.
MySQL and putty
Using Putty in MySQL as of Feb 16,2016
Experiment with MySQL please.
TOPIC VIDEOS for MySQL examplea:MySQL introduction
MySQL introduction continued
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019:Introduction to MySQL (2/19/19) in PDF format Accompanying audio
Introduction to MySQL (2/19/19) Accompanying Smartboard presentations
Continuing Intro to MySQL (2/21/19) in PDF format Accompanying audio
Continuing Intro to MySQL (2/21/19) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:Assignment #1: I would like you to write an educational game for kids about some event or series of facts. It should be something along the lines of what I did for the Boston Tea Party. It should have a minimum of 4 pages.
Assignment#2: Basic Queries
Week of February 20th or if you do not need the week to deal with catch up move on to week #6
INFORMATION:I have emailed you information that Janelle developed for using Horizon and then getting in with putty. So you can now start using PHP. I asked about this week being a figure it all out week or a moving on week and I got mixed feedback. So... I have decided to let you choose in a sense. So... If you feel it would be more beneficial to work on getting things set up then you have a week to do that and finish redoing the assignments in PHP. If you want to get things working and finish redoing the PHP assignments and still move on you can finish up and then go to the posting under Week #6. I will put up next weeks information and you can go to that and I will keep doing that for the rest of the semester. So everyone can just move on doing all of the postings that I put up and pretty much ignoring the week of and date and just making sure that you do them all. Clearly we will have real flexibility in due dates.
Week of February 13th
INFORMATION:It looks like the tech problem may be almost solved so I am waiting until Monday to post the weeks work. Make that Tuesday.
I am afraid I was overly optimistic. I sent you the information from Milo on loading PHP on your own computer and it looks like that is what you need to do. So this week I am suggesting you do that - contact Milo for help! Then start doing the assignments from week 2 and 3 and send them to me - program and screen shots of it working. Sorry that we have to go through this but I do not want to go any further without you actually running and executing code.
Week of February 6th
INFORMATION:There are tech problems and we still do not have access to writing PHP. We are all getting more and more frustrated, but IT is working diligently with experts in the field to overcome the many obstacles. You can download PHP onto your local computer and work on it there if you want to consider that. Hopefully we will get access to PHP ths week, but... No promises!
I think it might to good to have a general question session on Zoom, so lets try noon on Monday.
Hopefully I will know about access tomorrow but in the meantime K104 and K130 are available for use. PHP is available to use.
When things are up and running we will take a little time to actually play around with PHP. It is now available in the computer labs in K building especially K104 and K130. You should have a password etc so you can work if you can get to campus.
Continuing with PHP Basics. We are looking at Group 3, Group 4 and Boston Tea this week and into next.
EXAMPLES TO LOOK AT:You can find Third Group Plus PHP at Third Group Plus PHP
Fourth Group PHP zipped
You should also work on the Bston Tea Party educational example.
Boston Tea Party PHP zipped
TOPIC VIDEOS:Group 3+
Group 3+ continued
Group 4 while loop
Group 4 do while loop
Group 4 for loop misc
Group 4 loop within loop
Boston Tea Party
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019:PHP Fourth Group LOOP (2/7/19) in PDF format Accompanying audio
PHP Fourth Group LOOP (2/7/19) Accompanying Smartboard presentations
Boston Tea, Third Plus Group, Fifth Group (2/12/19) in PDF format Accompanying audio
Boston Tea, Third Plus Group, Fifth Group LOOP (2/12/19) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:Loop Quiz: without loop program Please download this program and modify it three times. Once to use a while loop, once to use a do...while loop and once to use a for loop.
Program to write: Write a program to do the algebraic equation x = a +a(b+4)/2 multiple times within loops that vary a and b. The variable a should start at 1 go to 10 and increment by 1. The variable b should start at 2 and go to 10 and increment by 2. When you display the answer show the formula in php. I want you to do this three times: once with a for...next, once with a do...while and once with a while.
Week of January 30th
INFORMATION:The recovery is going well and PHP should be available this week. So... I am putting up the material I want you to go over but I am holding back on some things, especially the assignment. Because a text book is not required, I want to point you to a few good PHP tutorials/ references that you can use throughout the semester. I will also put up sites related to current topics periodically.
Tutorials Point (PHP)
The W3 schools tutorial gives you option to test things
A slow moving basic tutorial
To load things up on the Internet, we use WINSCP. Please read the WINSCP and cisweb information: (note that in my examples I use cisweb.bristol.mass.edu as the host, we are now using cisweb.bristolcc.edu as the host. The port has also changed to 220.
Here is information about using cisweb and WINSCP at BCC
Talks more specifically about portfolio We will be looking at making a portfolio later in the semester.
If you want to download WINSCP at home, you can find it at this address.
EXAMPLES TO LOOK AT:We will continue with PHP looking at Second Group PHP and we will start Third Group PHP. You can find Second Group PHP at Second Group PHP
You can find Third Group PHP at Third Group PHP
TOPIC VIDEOS:Group 2 payroll examples
Group 2 sentence examples
Misc from Group 2
Group 3 if and
Group 3 if or both
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: (not available now because of Bristol technical problems)PHP Second Group (1/31/19) in PDF format Accompanying audio
PHP Second Group (1/31/19) Accompanying Smartboard presentations
PHP Third Group IF (2/5/19) in PDF format Accompanying audio
PHP Third Group IF (2/5/19) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:I was hoping things would be up by now, but next week looks real promising. I want you to write this code so you are able to run it this week or next week if things are working.
Assignment: Memo assignment Make up 5 names and use the 7 days of the week. and notice in my example I have you select a first name but I put out the whole name. You can make up the names. Also note that the select is Wed but in the memo I use Wednesday.
Week of January 25th
INFORMATION:Introduction to CIS159 - Spring 2022
We will start off the semester with a quick review of HTML if needed and then we will actually start the PHP. If you have already had CIS122/44 or have previous experience, this will be a review. If you have taken CIS120/17, you have already been introduced to HTML. For others I suggest that you use resources at the sites for CIS120/17 and CIS122/44 or other resources on the web to accquaint yourself with HTML.
There are a lof of examples under CIS122 Internet Developer.
A great reference for writing HTML is W3Schools
The students in this class have a variety of backgrounds, so for some HTML is review and for others it is relatively new.
Handout on using WinSCP3 Note instead of the host as cisweb.bristol.mass.edu we are now using cisweb.bristolcc.edu.
The port is now 220.
WinSCP3 is available as open source software and you can download it for home use.
You should be getting a username/password for the BCC site at the end of this week.
We will be working exclusively off the BCC cisweb site. You do not need to install PHP or MySQL, they are on the server.
EXAMPLES TO LOOK AT:When we start to look at PHP log into cisweb and copy my examples from First Group PHP up to the site.
You can find First Group PHP at First Group PHP revised - a few things have been added
TOPIC VIDEOS:FirstGroupPHP - hello world through name
FirstGroupPHP - html to PHP
SMARTBOARD AND AUDIO NOTES FROM Spring 2019/2020 and Fall 2019: (not available until technical issues resolved)First day, review HTML, intro PHP (1/23/20) in PDF format Accompanying audio
First day, review of HTML, introPHP (1/23/20) Accompanying Smartboard presentations
First group PHP (1/28/20) in PDF format Accompanying audio
First group PHP (1/28/20) Accompanying Smartboard presentations
ASSIGNMENTS TO DO:If you are new to HTML, I want you to build a web page. The page should include at least: list table, CSS and form.
If you are experienced with HTML, I want you to develop a page that challenges you and uses elements that you stretch your knowledge - this is the time to explore more CSS or forms - experiment!
Due the Thursday after the week it is assigned so due February 2nd.(Note that homework is always due the Thursday of the week after it is assigned unless I give a specific due date.
For all assignments and quizzes, send me the address that I can run in the browser to test your program and also send a copy of the code.