Programming: Logic, Design and Implementation (CIS120/17)

Weekly Schedule

If when I return an assignment you do not get a grade it means that you have to go over the assignment and fix and resubmit. Remember, all assignments including inclass assignments must be done by everyone. There is no makeup on quizzes and tests.

David Bourgeois is the SI/tutor for this class. You can reach him at dbourgeois321@gmail.com for online tutoring or to set up an appointment.

The last week of Dave help is coming up. He will be available the week of Aug 13 on Monday and Tuesday from 4 to 6.
Unfortunately Dave cannot make it Monday - he will try to find another time.

Schedule by week or unit Information to cover
Please note that the first assignment is at the bottom of the list posted here. You should do the work in order! I may add to the weekly schedule during the course of the week, so please check back multiple times. Please keep copies of all work you submit until you receive your final grade at the end of the semester.
Remember that I tape all my classes and capture notes on the Smartboard in the spring and fall. The recordings (audio) and the Smartboard are available for summer students to use under Audio and Smartboard.
Unit #15 Your final will be posted by the 13th of August and is due on the 20th of August. I will also take homework through the 22nd of August.
I am posting the final a day early - I have had some technical problems and so I am giving you the final from the Spring 2018 semester. It is still due on the 20th of August. Note that problem 3 is a little confusing in some browsers so here are some notes. The first flowchart in problem 3 has a decision that goes to the right if it is yes and to the left if it is no and then come together to display/write. The second flowchart establishes ct and then tests ct after ct + 1 is assigned to ct then loops back and come in to check ct again. The third one assigns 0 to ct, processes and then checks ct. If ct is less than 10 it branches in right after the ct = 0. Be sure to ask me questions if you are confused!
The final is due by 5PM on August 20th. Email it to the regular email for homework and to my BCC email priscilla.grocer@bristolcc.edu.
Final Exam
Required status sheet must be turned in by the 22nd.
Unit #14 We are returning to look at databases but this time they will contain multiple tables.
We will look at relational databases and implementation in Access.
Normalization (3rd normal form)
Student 4 table database
Student 4 table data needed We will work on this database in class.
Extra credit/makeup quiz (Worth 10 points) which is the same as the other quizzes so it can substitute for a missing quiz - the quizzes together are basically one homework assignment.
Assignments:
Last unit of assignments!
Donor multiple table database
Softskills paper (not an extensive paper)
Check back!
Unit #13 Continue looking at Visual Basic this unit. Be sure you look at all of the examples I gave under programs and also be sure to look at the Smartboard and audio for VB under unit #11.
Assignments:
Second Visual Basic Assignment
Check back!
Unit #12 We will continue to look at Visual Basic. Some of the programs to look at are: FirstMath, basicMath, work areas, userInput and loopswhile120; We will look at the other examples next unit. Note that the Smartboard and audio are listed under unit #11.
Assignments:
Portfolio Project to start (must be done using HTML that you write): I want you to start creating an online portfolio. For CIS majors you can work on this throughout your time at BCC and develop a portfolio to help you when you are looking for a job. For now we are going to do a basic start. You should make a title page with basic information and a link to a second page that should contain a menu with links to a database that you upload, two JavaScript problems you have written and other work for this or another course. You can certainly incorporate your introductory page from week 1.
The index or first page should have basic information. The second page should link to at least four things that you have done. You can put the work in the root of cisweb or you can put it in a folder.
The address should be cisweb.bristolcc.edu/~yourusername/folder if any/name of the page. If it is html page then it has a .html extension. The database has a .accdb extension. Check with me if you have problems.
Unit #11 This unit we will start to look at our second programming language, Visual Basic. I strongly suggest you look at the Smartboard and listen to the audio for either Spring 2018 or Fall 2017. I will be giving you the mentor information so check back.
I suggest that you skim over the remaining chapters in the optional text.
Download Visual Studio (they are highlighting the 2017 version) from Microsoft Use Community addition
Thus information on Visual Basic is for both this unit and unit #12.
Spring 2018:
Intro Visual Basic (4/10/18 11:00) Accompanying audio
Visual Basic ifs and loops (4/17/18 11:00) Accompanying audio
Visual Basic wrapup (4/26/18 11:00) Accompanying audio
Intro Visual Basic (4/10/18 11:00) Accompanying Smartboard presentation
Visual Basic ifs and loops (4/17/18 11:00)Smartboard presentation
Visual Basic wrapup (4/26/18 11:00)Smartboard presentation
I also recommend looking at the information under Fall 2017 for more explanations.
Visual Basic examples are located at:
zipped Visual Basic examples
Assignments:
Your Visual Basic assignment is to redo the first JavaScript assignment but write the programs in Visual Basic this time. You need to create a folder for each problem. Then zip up the contents of each folder and send me the zipped Visual Basic programs. You can send this in a little late since I will do more with IF statements nexts Tuesday.
Career and mentor paper: The mentors are professionals who went through the CIS program at BCC and are now working in the field or continuing their studies. They have generously volunteered to be an email mentor to discuss career and skills with current students. This assignment will need you to interview your mentor. I want you to write a paper about careers in the computer field. There should be two parts to the paper: The first part should be an interview with your mentor about the work he or she does in the computing field or if your mentor is continuing studies in computing, ask about the degree program he or she is in and what they would like to do when they complete their studies. Your paper should contain information about your mentor's job or degree program with several quotes from your mentor. The second part should be researching a career in computing that interests you and writing about what the job involves and the skills that are needed. The paper should include notes citing your sources (I would estimate that you need at least a couple of pages to cover the goals well). In addition, send me a list of the questions you asked your mentor. The paper is due the week before the final. If you have trouble contacting your mentor, let me know and pass in the mentor part late (the research part must be on time). If you are too far behind on work and you need to send me a lot of work, I am not sending you a mentor until you are more caught up and proved you are participating in this course. If you do not get a mentor this weekend/week and you do not think you are that far behind, be sure to contact me.
Unit #10 This unit we are going to take a break from programming and look at numbering systems.
Numbering systems and code
This handout covers binary and hex well, but it was written over 20 years ago and the code information is historical and not current. We will look at 8-bit ASCII code in class and look at the link below.
Reference for ASCII
I strongly urge you to look at the examples using Smartboard and the matching audio.
Wrapup JavaScript and numbering systems (3/27/18 11:00) Accompanying audio
Numbering systems and ASCII (3/29/18 11:00) Accompanying audio
Array, RPS, numbering systems (10/31/17 11:00) Accompanying audio
Array, RPS, numbering systems (10/31/17 12:30) Accompanying audio
Computer codes (11/2/17 11:00) Accompanying audio
Computer codes (11/2/17 12:30) Accompanying audio
Wrapup JavaScript and numbering systems (3/27/18 11:00) Accompanying Smartboard presentation
Numbering systems and ASCII (3/29/18 11:00) Accompanying Smartboard presentation
Array, RPS, numbering systems (10/31/17 11:00) Accompanying Smartboard presentation
Array, RPS, numbering systems (10/31/17 12:30) Accompanying Smartboard presentation
Computer Codes (11/2/17 11:00) Accompanying Smartboard presentation
Computer Codes (11/2/17 12:30) Accompanying Smartboard presentation
Assignments:
Bin/Hex/ASCII assignment
Check back!
Unit #9 If you need help, email me or check with Dave for his availability.
This unit we will continue looking at logic and applying it to writing code in JavaScript.
I suggest you read chapter #5.
Practice exercise we already looked at
Solution to practice exercises:
While solution to problem #1
Do...while solution to problem #1
While solution to problem #2
Do...while solution to problem #2
Be sure you look at the guess game examples, they will help with taking in user input in a loop and with establishing a random number.
Debug tool in Firefox
The Smartboard and audio I am posting include an introduction to numbering systems which is our next topic.
Smartboard:
Array, RPS, numbering systems (10/31/17 11:00) Accompanying audio
Array, RPS, numbering systems (10/31/17 12:30) Accompanying audio
Audio:
Array, RPS, numbering systems (10/31/17 11:00) Accompanying Smartboard presentation
Array, RPS, numbering systems (10/31/17 12:30) Accompanying Smartboard presentation
Assignments:
Your first assignment this week is to write the rock, paper, scissors program using JavaScript. I want you to write a basic version using the commands and techniques you have learned. Please stay away from the solutions on the web in developing your solution. Check back!
Unit #8 If you need help, email me or check with Dave for his availability.
We are continuing with JavaScript this unit. Please reference my examples as well as the Smartboard and audio.
Smartboard:
JavaScript IF and intro loops (10/17/17 11:00) Accompanying audio
JavaScript IF and intro loops (10/17/17 12:30) Accompanying audio
More JavaScript loops (10/24/17 11:00) Accompanying audio
More JavaScript loops (10/24/17 12:30) Accompanying audio
Debug and Guess game (10/26/17 11:00) Accompanying audio
Debug and Guess game (10/26/17 12:30) Accompanying audio
Audio:
JavaScript IF and intro loops (10/17/17 11:00) Accompanying Smartboard presentation
JavaScript IF and intro loops (10/17/17 12:30) Accompanying Smartboard presentation
More JavaScript loops (10/24/17 11:00) Accompanying Smartboard presentation
More JavaScript loops (10/24/17 12:30) Accompanying Smartboard presentation
Debug and Guess game (10/26/17 11:00) Accompanying Smartboard presentation
Debug and Guess game (10/26/17 12:30) Accompanying Smartboard presentation
Readings that will provide more information on if and loops.
Decisions
Decision making in JavaScipt
IF at W3Schools
Loops
Looping in JavaScript
Guess Game Logic
Assignments:
First JavaScript quiz/testThis is equivalent to a high-end homework assignment.
Second JavaScript assignment
Unit #7 Check with Dave for his availability.
Reading you can move on to chapter #4 if you have the logic book. The chapters deal with logic of if and loops which we are covering. You can check YouTube for some interesting coverage of flowcharts, pseudocode, if statements and loops.
We are going to start JavaScript so be sure to look at my examples under programs. JavaScript is embedded in HTML so you can do a view source of my examples and see the code.
Here are some Smartboard explanations from Fall 2017 (you can look at Spring 2018 as well):
Introduction JavaScript (10/5/17 11:00) Accompanying audio
Introduction JavaScript (10/5/17 12:30) Accompanying audio
JavaScript IF (10/12/17 11:00) Accompanying audio
JavaScript IF (10/12/17 12:30) Accompanying audio
Here are the accompanying audio that go with the Smartboard:
Intro JavaScript (10/5/17 11:00) Accompanying Smartboard presentation
Intro JavaScript (10/5/17 12:30) Accompanying Smartboard presentation
JavaScript IF (10/12/17 11:00) Accompanying Smartboard presentation
JavaScript IF (10/12/17 12:30) Accompanying Smartboard presentation
Assignments:
Flowchart and Pseudocode assignment You need to work on it individually because it is a quiz (no help from Dave or other students and that also means no resubmit). This quiz also counts more than the quick quizzes - guess I should have called it a test. It counts like a high-end homework.
First JavaScript assignment
Unit #6 Check with Dave for his availability.
If you have the optional textbook, I recommend reading chapter #2 and #3 that focus on logic. This information is a good supplement to the examples in my notes.
Here is some information on flowcharting and pseudocode:
Basic video
Here is some Smartboard notes and accompanying audio.
Loops(10/3/17 11:00) Accompanying audio
Loops(10/3/17 12:30) Accompanying audio
Loops (10/3/17 11:00) Accompanying Smartboard presentation
Loops (10/3/17 12:30) Accompanying Smartboard presentation
Assignments:
Logic PowerPoint assignment
Quick Quiz #2.
Check back to see if I add something to this unit.
Unit #5 Check with Dave for his availability. Remember there are 15 units and only 11 weeks including the week for the finals so you need to do multiple units many weeks.
We went over SQL last unit. Here are some examples you may find helpful:
Some SQL examples Let me know if you find a typo.
This unit, we will go over some of the principles from the readings above and start looking at logic. We will work on the practice exercise below.
Practice exercise:
Practice exercise
Practice continued
Presentation on using pseudocode to play computer
    Separate speaker notes to accompany presentation on using pseudocode to play computer
For help on if statements, look at this presentation:
Presentation on logical if structures
    Separate speaker notes to accompany presentation on logical if structures
Please look at this PowerPoint on loops and repetition:
Presentation on structure (focus on loops)
    Separate speaker notes to accompany presentation structure (focus on loops)
The notes are from the Fall of 2017 since I was out sick during some of the period in the spring of 2018. There are some notes for spring 2018 that you can look at, but they are not as complete. Note that there were two classes in the Fall, one at 11 and one at 12:s0. You can pick one to follow or check out both.
First the Smartboard:
Logic(9/26/17 11:00) Accompanying audio
Logic (9/26/17 12:30) Accompanying audio
Decisions(9/28/17 11:00) Accompanying audio
Decisions(9/28/17 12:30) Accompanying audio
Then the audio:
Logic (9/26/17 11:00) Accompanying Smartboard presentation
Logic (9/26/17 12:30) Accompanying Smartboard presentation
Decisions (9/28/17 11:00) Accompanying Smartboard presentation
Decisions (9/28/17 12:30) Accompanying Smartboard presentation
Finally, we will start looking at logic and will work on the practice exercise below.
Check back!
Assignments:
Logic assignment
logic exercise Follow the logic flowchart and process the input, then tell me the output. Show the answers for the first four and then you can just show the messages.
Unit #4 Check with Dave for his availability.
This unit we will look at the SQL, I need you to to over the presentation, and look at the database and the examples.
Here is a presentation and the database I modified to go with it.
An explanation of basic SQL
Accompany database with SQL queries
Some SQL examples Let me know if you find a typo.
Here are some outside references.
Introduction to SQL
W3Schools on SQL
Here is the Smartboard and audio from the Fall 2017 semester when I covered SQL (I was out with the flu in the spring).
Smartboard on SQL from Sept 21, 2017
Audio on SQL from Sept 21, 2017
It is time for Enrollment Verification and I have to verify you are in the class. If you have not passed in work or the email a week verifying you are in the class, then you need to contact me now to make sure you are not withdrawn from the class.
Reading - there is not a required text but there is reading that will add to your knowledge base and that is required:
If you bought the optional text, read chapter 1 (you might note that at Amazon much of the first chapter is available for Just Enough Programming Logic and Design in the Look inside feature). Might help you decide about the book.
Please read the following especially if you do not have the book.
Compiler definition
Compiler vs interpreter
Types of software
Memory and RAM
Programming Process
Examples: Pseudocode and Flowcharts
Pseudocode and Flowcharts
Data types
Syntax and logic errors
I also want to include some information on skills, so please listen to this video and read this handout about note taking.
Note taking video
Cornell method of note taking is the specific one to read. I also suggest checking out the other links on this page.
Assignments:
Database assignment to query with SQL:
You need to send me the database and a list of the SQL queries (text version so I would use notepad) you wrote so that if the queries get "Microsoft fixed" I can see what you wrote. Remember, the queries have to all be done in SQL. This is not a group project. It needs to be done individually.
Softskills database to query with SQL
Check back!
Unit #3 Dave Bourgeois is the SI/Tutor for this course and can be reached if you have questions or want to set up a meeting. His email is posted above. Obviously you can sent questions to me as well!
Directions for downloading Access are located under Notes and Handouts. Using Office 365 to download the suite is probably the easiest approach.
Here are some articles you can read if you want support in working with Access. Many go beyond what we are doing in class. They are a resource you can choose to use.
Create a table
Create a query
Create a table from Microsoft
Create a table (uses older version of Access)
Create a query (uses older version of Access)
There are no audio or Smartboard notes since this was done in the Spring during class time.
Assignments:
This project was given as a group assignment in the Spring but because you can pace yourself in the summer, it is an individual project.
Note: On the flowcharts in the assignment, sometimes the word Technology is cut off and you see Course instead of Course Technology.
DB assignment
DB assignment (html version)
Answer sheet for project
Book Database to use in answering questions (Access2016, 2013)
Check back!
Unit #2 You will need your user name and password to log into cisweb, so if you do not have it, please let me know.
More about soft skills - please read
We will also start looking at Microsoft Access 2016 this week. If you would like a copy for your computer you could choose to download Microsoft Access 2016 from Office 365.
Access 2016 using Office 365
Please do not change any of the passwords we have given you. I need to be able to get to your site as does the IT staff if there is a problem.
Last semester, several students asked about words for different colors. Here is a link:
Color Names
Uploading to the Web: In my notes I talk about cisweb.bristol.mass.edu. Things have changed and you should now use cisweb.bristolcc.edu.
We will look at login to cisweb this unit 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
A variety of information on creating an Access 2016 database. Note that Access 2013 is almost the same so I have included notes for that as well.
The databases we created in class a previous semester are shown below so you can take a look:
Created in 11:00 previous year (student.accdb)
Created in 12:30 previous year (studb.accdb)
I suggest you look at the notes in this presentation and try to create the table following the steps. Presentation on creating an Access 2016 database and table
Access2013 example and explanation:
Sample Access 2013 database Note there is an accompanying Smartboard explaining this database under presentations
Access 2013 example explanation - database is under examples
Other examples are at my site under Examples and under presentations.
Links to Smartboard and audio notes from Spring 2018.
Uploading HTML & intro Access (1/30/18 11:00) Accompanying audio
Uploading HTML & intro Access (1/30/18 11:00) Accompanying Smartboard presentation
Access and queries (2/1/18 11:00) Accompanying audio
Access and queries (2/1/18 11:00) Accompanying Smartboard presentation
There will be more notes under Unit #3
Assignments:
Assignment #1: Upload your web page introducing yourself to the cisweb server and send me the address. Extra credit if you experiment with linking and try links that involve subfolders going back and forth and a link to an outside page.
Assignment #2: Quick Quiz #1 The quiz must be passed in before you move on to Unit #3.
Assignment #3: Access Database Assignment on BCC College ResourcesThis assignment must be done with the user interface we have looked at in class, it should not be done with SQL - next units assignment will deal with SQL.
Resources for database data: I am attaching a list of the resources that I found that you can use in preparing your database.
Notes on College Resources - some things to help as you put data in the database Note that I did not find something for all fields - it is acceptable to leave some data blank but you should find some data on your own as well.
Check back!
Hopefully everyone has found my website and seen the assignments. Some of you may be having a late start. There is a lot of material especially if you started a few days late. So, you can try to get unit 1 and unit 2 done during the first two weeks and then you can do unit 3 the third week. There are a few weeks that are a little lighter later in the semester so you can get caught up. However, you may find it helpful to at least look at unit #3 for help with Access. There are notes there from external sources.
Unit #1 Lots of information in this unit!
There are more weeks in the spring/fall semesters than in the summer. So instead of weeks I use units. Each student must complete all the units so some weeks you will need to do two units or get ahead and do three units. I will post the units so that you have that flexibility. Please check back several times during the week because I may add information. If you are just starting as a CIS major, I recommend that you double check your fall schedule with me.
You have gotten or will be getting invitations and login information in the next few weeks at your BCC email acount. Please be sure to check for them.
If you go to audio and Smartboard you will find these recordings and captured Smartboard notes that should help you with the assignment. I took these from Spring 2018, you could also take them from Fall 2017 etc. Since they are separate, you need to work on a way to figure out when to move to the next page in the Smartboard notes.
First day and intro to HTML (1/23/18 11:00) Accompanying audio
First day and intro to HTML (1/23/18 11:00) Accompanying Smartboard presentation
Continuing HTML (1/25/18 11:00) Accompanying audio
First day and intro to HTML (1/23/18 11:00) Accompanying Smartboard presentation
Continuing HTML (1/25/18 11:00) Accompanying Smartboard presentation
We will start looking at HTML/HTML5 to develop a web page. Please look at the samples under Examples.
We will start looking at HTML/HTML5 to develop a web page. Please look at the samples under Examples. We will start to look at them .
These are the pages you need to go over and understand:
HTML5intro.html
HTML5list.html
HTML5CSSlist.html
HTML5headers.html
HTML5CSSheaders.html
HTML5CSSimage.html
HTML5centeredimage.html
HTML5CSStable.html
HTML5CSScenteredtable.html
HTML5linkpage.html
HTML5morelinks.html
fileInSubHTML5.html
There is an HTML presentation that also looks at writing code with HTML. It is under presentations and it is zipped.
Note that it does not use examples with the optional DOCTYPE on the first line.
Zipped version of Introduction to HTML
A great reference for writing HTML is W3Schools
Note that I will not always repeat the address here in the week of - I will just point you to where it can be found.
Please note that this class used to be CIS17 and some of the handouts will say CIS17, that is why I refer to the class as CIS120/CIS17.
Remember that the CSS (College Success Strategies) skills are embedded in this course. For example time management and learning style readings will help you to write the web page introducing yourself and telling me how you are going to handle your time and use your knowledge about learning styles to be successful in this course. If you complete this course, you do not have to take the College Success Strategies course.
For us there are two definitions of CSS - one is the College Success Strategies and one is Cascading Style Sheets.
Here are some links where you can find information on HTML and CSS:
I frequently search with the word "tutorial" and the subject when I want basic information.
HTML:
http://www.w3schools.com/html/html_intro.asp
http://www.tizag.com/htmlT/
http://www.html.net/tutorials/html/
Cascading Style Sheets:
http://www.w3schools.com/css/default.asp/
http://www.tizag.com/cssT/
www.csstutorial.net/
Remember that to see the code you wrote, right click and view source. I used Firefox to make my examples.
A member of the last class found this article interesting:
Improve your time management
Presentation going over first few HTML examples I created it to send to some students who were having trouble with HTML.
Assignments:
The subject line on the email should say the unit and which assignment it is. Only one assignment per email.
Suggested home work tracker
There is also an Assignment Summary (look under Weekly Schedule in the menu on the left).
We will be looking at soft skills later in the semester and as a foundation for that, I want you to take this survey:
Unit #1 Assignment #1 is a check off for doing the survey.
Survey
Send me an email letting me know you have taken it.
Unit #1 Assignment #2 is to create the HTML page described below.
HTML page to introduce yourself (needs to include CSS)
I should clarify that you should use a lot of the HTML in the examples so you should use things like lists, tables, images, CSS etc to get the best grade. If you use extra HTML that you research and use to create the page you need to explain the commands for extra credit.
Also extra credit for having more than one page and linking them.
Email me if you have questions!

Send e-mail to Priscilla Grocer (if you have or are taking a course, use the email you were given for the class):
Priscilla.Grocer@bristolcc.edu

Back to the Top
Return to home page