| Week | Information |
|---|---|
| Assignments due in one week unless otherwise stated. I may add some things during the week, so double check the schedule each week! Please keep copies of all work you submit until you receive your final grade at the end of the semester. | |
| Week #15 Week of May 4th |
We will have open labs in K101 on Tuesday from 10 to 2 and then we will move to K118 hopefully for an hour or so
and Thurs from 9:30 until 2 and then we will move to K118 for an hour. This is a time to get some more things
in to finish off the semester. Your online final will be posted by Thursday, May 7th and it is due by 9:00AM on Thursday, May 14th via email. The required status sheet: REQUIRED Status Sheet Code you need for problem #2 Final Exam |
| Week #14 Week of April 27th |
I will be doing registration and helping this week so Monday at 10 and Tuesday and Thursday around 2. Pat is available
Tuesday and Thursday around 2 and Wednesday between 2 and 4. Don't forget to sign up to see your advisor! This week we will look at email, cookies and sessions etc. Please check back! Cookie/Session zipped Email Group Two PHP zipped Guess Session zipped Assignments: Set up a database table with idno, name, email and major. Send an email to everyone in the database. Experiment with a simple example of a cookie and of a session. |
| Week #13 Week of April 20th |
I will be doing registration and helping this week so Monday at 10 and Tuesday and Thursday around 2. Pat is available
Tuesday and Thursday around 2 and Wednesday between 2 and 4. Don't forget to sign up to see your advisor! Information about upcoming events through STEM under Posting/Notes on my home page. We will continue with functions this week and then move on to images and email. Function Group PHP zipped Email Group One PHP zipped Please check back! Assignments: Write the program to guess a number between 1 and 25. Use the random number function to generate the number to guess. This should be written on one php page meaning the input for the guess and the processing are on the same page. Be sure you are using function(s) in this assignment. Note: I want you to tell the user whether it is high, low or correct and let them keep guessing until it is correct. Send me a basic email and one with html to set up the page. Please test sending it to yourself and only send me the email when it is working - you need to send it to my BCC email. You need to also send something to my regular email account telling me it was sent and the date and time. |
| Week #12 Week of April 13th |
I will be doing registration and helping this week so Monday at 10 and Tuesday and Thursday around 2. Pat is available
Tuesday and Thursday around 2 and Wednesday between 2 and 4. Don't forget to sign up to see your advisor! We will continue looking at arrays at least at the beginning of the week. The STEM club on campus has set up a Facebook page. STEM Club Images First Group PHP zipped Images Second Group PHP zipped We might get to these. In either case, please look them over: Function Built In Group PHP zipped Please check back! Assignments: QUIZ: Array 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! |
| Week #11 Week of April 6th |
This is an online week and Pat will be available from
9:30 until around 2:30 mostly in K101 but moving to K118 at 1:45ish on both Tuesday, April 7th and Thursday,
April 9th. Please go over the examples in the ArrayGroupThirdPHP listed last week. Check back! |
| Week #10 Week of March 30th |
I am available at 10 on Monday in my office and Pat is available from 2-4 on Wed and both of us are available
on Tues and Thurs at 2 in K118. Remember, the week of April 6th is an online week. Pat will be available from
9:30 until around 2:30 mostly in K101 but moving to K118 at 1:45ish on both Tuesday, April 7th and Thursday,
April 9th. We will continue looking at arrays. First finishing ArrayGroupFirstPHP which was posted last week. Array Group Second PHP zipped Array Group Third PHP zipped Assignments: question 1 and question 2 in class students will work on this in class hopefully. Actually I do want it - sorry to the people I said it was not a pass in assignment. 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. |
| Week #9 Week of March 23th |
I am available at 10 on Monday in my office and Pat is available from 2-4 on Wed and both of us are available
on Tues and Thurs at 2 in K118 (actually Pat is available at 12:30). We will spend more time with connecting MySQL and PHP. Third Connect Group for class zipped Notes on different errors Maybe... We will start to look at arrays this week after we finish up a few things on maintenace of database tables. Array Group First PHP zipped Please check back! Assignments: Create a table through PHP with 5 fields at least one of which should be numeric and populate the table. I want you to write a program to update. The user should fill out the form as needed and pass to a php program. The form should have a place to fill in whether it is an A, C or D and an idno (this is one of your fields and it cannot be changed). Then if the user wants to add/insert they should fill in all the boxes. If the user wants to delete, the idno was enough the other boxes can be blank. If the user wants to update they should fill in the fields they want to change. The PHP program should then add/insert if the code said A, delete if the code says D and change if the code says U. Note that on the update I only want you to make changes to the database table where there is content in the field. Otherwise the data should stay the same. In other words if you have a field called city and on the form city was left blank then the city should stay the same. If the city changed then the database table record should contain the new city. |
| Catch up week Vacation Week of March 16th |
This is catch up week - I am hoping that a lot of you will get caught up with assignments that you owe me. If you are having problems Pat will be coming in on Tuesday and Thursdayfrom 10 to 3. He is planning on K101 but if other people are using it you may have to look for him or ask at the help desk. You can also email me with questions and problems as well as homework for me to check. |
| Week #8 Week of March 9th |
I will be available Mon at 10 in my office, Pat will be available from 11 to 3 on Tuesday and Thursday and
I will be available with him around 2, Pat will also be available Friday from 11 - 1. We will probably be in
K-118, if you can't find us check with the help desk. We will continue looking at connect MySQL and PHP. Second Connect Group zipped - connecting to a database Assignments: MySQL and PHP assignment Please do these in one program if you can. |
| Week #7 Week of March 2nd |
I will be available Mon at 10 in my office (snow permitting), Pat will be available Tues and Thurs from
11 to 3 and Wed from 2-4. If you can't find him ask at the help desk. I will be available Tues and
Thurs at 2 for at least an hour (I come and go a little but Pat is there. This week we will look at design of a database and multiple tables and then connecting MySQL with PHP. FirstConnectGroup.zip - initial connecting to a database Connect Explanation Second Connect Group zipped - connecting to a database Assignments: Exercise in class: Start MySQL with PHP These are examples using a table that I have, you need to change to your database and a table it contains. Assignment using multiple tables that should be done using MySQL in putty: 1) Create the donation and drive tables described in the handouts and populate them. 2) Query the database to see all donations to a particular drive. Show the donation information and the drive name. 3) Query the database to show donor idno, donor name and the drive they donated to where donations are greater than > 500. 4) Query the database to show some information from the donor table and some information from the drive table and add two conditions in an or relationship. 5) Query you database to show information from 2 or 3 tables with additional conditions such that one thing has to be true and either of two other things. |
| Week #6 Week of February 23rd |
The plan is for a normal week with me available at 10 on Monday in my office, Pat and I available 2ish in K118 on Tues and Thurs and Pat available
Wed from 2-4. Note that a representative from Meditech will be coming to the 11:00 class on Thursday. Notes on SQL - these also appear under week #5: Keys, indexes etc. Subqueries Multiple tables Functions Check back! Assignments: workingwithSQL.doc Something we will start in class SQL Assignment #2 It has been fixed... hopefully! |
| Week #5 Week of February 16th |
Pat from 8 - 4 on Friday and I am around after class on Thursday (1:40) and hopefully at 10AM (snow driving
assumed ok) in my office.
Hopefully we will be in K101 or K118 but if we are not there check with the help desk - we will be sure to report any changes. We will work with MySQL and Putty this week. There are a lot of resources on the web for reference. We will start with these and move on as time allows: Beginning MySQL notes Data types More SQL Notes: Keys, indexes etc. Subqueries Multiple tables Functions Assignments: 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. Check back! |
| Week #4 Week of February 9th |
Tuesday, February 10th is going to be an online day. I have over 2 feet of new snow and it is still snowing and it is 11PM.
So, I will post what you should cover in preparation for the Thursday class.
I believe (depends on his snow situation) that Pat will be in K101 from 11 until 2 and then he will move
to K118. Pat just confirmed that he will be in at 11. I will be available Thursday at 1:45 in K118. Check back for the information you need to cover! My plan was to look at loops. If you go back to what I did last year at this time you will see that I started loops on 2/6/14 and finished them on 2/11/14. I also did a little on alternate structures on 2/13/14 before I started working on databases. I would recommend looking at the Smartboard and listening to the audio for those dates. I will spend some time on Thursday on loops but I will not cover everything. Information on loops in PHP: Fourth Group PHP zipped - loops Fifth Group PHP zipped A little more about using end and not curly braces. Assignments: 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(b+6)/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. MySQL and putty:Next week we are going to work on MySQL through putty. It would be great if you experimented a little. Please work with getting in to mysql using putty. It would be great if you followed the notes that say Beginning MySQL notes and create a table. Not to pass in - just to make sure you are all set for next Tuesday. Beginning MySQL notes MySQL and putty |
| Week #3 Week of February 2nd |
Pat and I are available at 1:45 on Tues and Thurs and Pat is also available on Wed from 2 - 4. Depending on
weather, I may be available Monday at 10 in K112. We will continue working on information in FirstGroupPHP and SecondGroupPHP and then we will move on to the ThirdGroupPHP and ThirdGroupPlusPHP and BostonTeaPHP. Third Group PHP zipped Boston Tea party example PHP zipped Third Group Plus PHP zipped Please look at "Go West Across America with Lewis and Clark" which is where I got the idea for the Boston Tea Party game. Lewis and Clark adventure Assignments: 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 3 pages. IF Quiz |
| Week #2 Week of January 26th |
I will be available for help Monday at 10:00 in my office, I will be available Tuesday and Thursday at 2:00 in a lab check my office K112
for a note if I am not there. This week I believe Pat will be available on Tues and Thurs at 2. You can check my
office (K112) or ask at the help desk in the main lab. And then there is the matter of the snow... I live just south of Boston so if the snow is really bad, we may do a online class on Tuesday. Check back at this site and I will post whether I will be there or not. I made this Smartboard presentation to go over the problems in the FirstGroupPHP, so since we are working on line Tuesday, please go over these examples carefully. I would also suggest looking back at Spring 2014 and looking at the notes and audio for the second day and into the third day - covering FirstGroupPHP FirstGroupPHP.pdf If you need help with something, now would be the time to ask your questions! This week we will start PHP. Please look at the beginning PHP examples that I have listed below. There are additional examples from previous classes and PowerPoints available at the web site. Note that you are doing PHP and MySQL on the server so you do not have to attempt to set it up. It would certainly be a good idea to read about basic PHP in a book or in an online tutorial. Uploading to the Web: These are the handouts I give out in CIS120 that reference using cisweb. Note we now prefer cisweb.bristolcc.edu instead of cisweb.bristol.mass.edu. We will look again at login to cisweb this week so check the notes on the Smartboard and the accompanying audio as well as the notes below. 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 although the old one is still supported). 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. WINSCP The examples we will go over first are: First Group PHP zipped Second Group PHP zipped Assignments: For all assignments, send me the address that I can run in the browser to test your program and also send a copy of the code. Quiz this is one of those quizzes where you can talk things through with others in the class, but each person has to do it and pass in their version.Quiz Homework: 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 #1 Week of January 19th |
We will start off the semester with a quick review of HTML and then next week 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. This example covers some of the fundamentals: html5example.html 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. 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. Assignments: If you are new to HTML, I want you to build a web page and upload it to the server (that cannot be done until you get your username and password). The page should include at least list, tables, CSS and forms. 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 January 29th my midnight. |