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 must be done by everyone. There is no makeup on quizzes and tests (some tests are accepted late - check).

Remember HELP is available with Joe on Collaborate - see HELP section below.

Your final exam is an online final that will be due Friday, August 14th. The last day of classes is Wednesday, August 12th and the semester ends Saturday, August 15th

The CIS pool is now available for students that need to access licensed software that they cannot use from home.
Remote access virtual desktop
Instructional video for using Remote Access Virtual Desktop - HTML

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. Play computer means to figure out the results yourself by evaluating the data rather than running the query.
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.
HELP schedule To contact Joe use moocowoftech@gmail.com. He will be available for open labs at this address: Collaborate
Joe will be available on Monday through Thursday from 11 to 4 and on Friday from 11 to 2.
Working with Collaborate by work study Steve DiPrimio
He will also be using Microsoft Teams which is available to you through Office 365. Send him an email from your Bristol account with the classes you want to connect to and you will get a link to join. Here is a brief run down on how it works and what to expect: Microsoft Teams overview
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.
Week #10
Week of August 3rd

INFORMATION:

This is the last week of classes. Your final will be uploaded by Friday the 7th and it is due by Friday the 14th at midnight. This last week, we are going to briefly look at relational databases.

EXAMPLES TO LOOK AT:

Normalization (3rd normal form)
Student 4 table database
Student 4 table data needed We will work on this database.

TOPIC VIDEOS:

Introduction to relational databases
Example of an order relational databases
Access Student Database
1 to 1, 1 to many and many to many relationships

SMARTBOARD AND AUDIO NOTES FROM Spring 2019 and Fall 2019:

I think the Spring versions have a little more information, but I would look at all of them.
Relational database (4/16/19) Accompanying audio
Relational Database (4/16/19) Accompanying Smartboard presentation
Relational database in Access (4/18/19) Accompanying audio
Relational Database in Access (4/18/19) Accompanying Smartboard presentation
Relational database continued (4/23/19) Accompanying audio
Relational Database in Access continued (4/23/19) Accompanying Smartboard presentation
Databases (10/31/19 11:00) Accompanying audio
Databases (10/31/19 11:00) Accompanying Smartboard presentation
Databases (10/31/19 12:30) Accompanying audio
Databases (10/31/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Donation database you need to do
Week #9
Week of July 27th

INFORMATION:

This week we are going to continue Visual Basic and you are going to explore jobs in technology with help from some recordings of CIS alum.
Week 10 we will revisit Access with one assignment. Your final is due on Friday, August 14th. It will be posted one week before it is due to give you time to work on it.

EXAMPLES TO LOOK AT:

We are continuing with the Visual Basic examples using the same address we used last week.
Visual Basic Programs to download and unzip

TOPIC VIDEOS:

Input, work areas and loops
Arrays - compare JS and VB
Write and read files

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

And more Visual Basic (11/19/19 11:00) Accompanying audio
And more Visual Basic (11/19/19 11:00) Accompanying Smartboard presentation
And more Visual Basic (11/19/19 12:30) Accompanying audio
And more Visual Basic (11/19/19 12:30) Accompanying Smartboard presentation
Arrays, read/write VB (11/26/19 11:00) Accompanying audio
Arrays, read/write VB (11/26/19 11:00) Accompanying Smartboard presentation
Arrays, read/write VB (11/26/19 12:30) Accompanying audio
Arrays, read/write VB (11/26/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Alumni talks to previous classes. I am not doing the mentor emails this semester because everyone is so overwhelmed. If you would like to talk to a mentor some time in the future, let me know and I will try to set it up.
I want you to listen to several of these alumni discussions that happened in class. Note that in the fall, I have two classes of CIS120 so I would pick different dates.
Alum talk at 11 on Nov 5, 2019
Alum talk at 12:30 on Nov 5, 2019
Alum talk at 11 on April 9, 2019
Alum talk at 11 on November 27, 2018
Alum talk at 12:30 on November 27,2 018
Alum talk at 11 on April 12, 2018
Assignments:
Career Paper: As you listen to the alum talk about their jobs, I want you to note what they say about working in computing. Then I want you to research a job you think you would like in computing. Combine and site from these sources and write a paper about working in this field. Include information about what the job involves and the skills that that are needed. I would also like you to include the soft skills that are important.
EXTRA CREDIT Visual Basic Assignment
Check back!
Week #8
Week of July 20th

INFORMATION:

This week we are going to start Visual Basic and then our last topic will be a return to Access using multiple tables. You will have some time to get caught up at the end hopefully!
There are Visual Basic examples under programs and then under Visual Basic. Download Visual Studio from Microsoft Use Community edition.
If you encounter problems, I suggest you go to Collaborate and talk to Joe.
The college would like me to use the priscilla.grocer@bristolcc.edu account. So please send assignments there with a cc to the rcn address we have been using.

EXAMPLES TO LOOK AT:

Visual Basic Programs to download and unzip

TOPIC VIDEOS:

Make first Visual Basic program
Two introductory Visual Basic programs
IF Visual Basic program
If where one thing has to be true and either of two others
More IF examples in VB

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Intro Visual Basic (11/12/19 11:00) Accompanying audio
Intro Visual Basic (11/12/19 11:00) Accompanying Smartboard presentation
Intro Visual Basic (11/12/19 12:30) Accompanying audio
Intro Visual Basic (11/12/19 12:30) Accompanying Smartboard presentation
More Visual Basic (11/14/19 11:00) Accompanying audio
More Visual Basic (11/14/19 11:00) Accompanying Smartboard presentation
More Visual Basic (11/14/19 12:30) Accompanying audio
More Visual Basic (11/14/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

ASCII assignment
I want you to redo the first JavaScript assignment, but this time I want you to do it in Visual Basic.
Redo this assignment in Visual Basic
Check back!
Week #7
Week of July 13th

INFORMATION:

Please read chapter #4 and #5 if you have the book. If not be sure to do some reading about logic flowcharts and pseudocode.
This week 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.
I suggest you look at the Smartboard and audio when I did this in class last Fall. You should also look at a couple of examples I wrote out.
The last day for student withdrawal is July 25th so you should evaluate your status and decide whether to with draw or not. There are only four weeks left in the semester.
Reference for ASCII

EXAMPLES TO LOOK AT:

A few examples of conversion using binary, decimal and hex.

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Numbering systems (10/22/19 11:00) Accompanying audio
Numbering systems (10/22/19 11:00) Accompanying Smartboard presentation
Numbering systems (10/22/19 12:30) Accompanying audio
Numbering systems (10/22/19 12:30) Accompanying Smartboard presentation
ASCII and portfolio (10/29/19 11:00) Accompanying audio
I forgot to turn on the recorder so I would suggest using the Audio and Smartboard from the 12:30 class. I did try to record some things from the beginning in a separate recording, but not so good...
ASCII and portfolio(10/29/19 11:00 first few minutes) Accompanying Smartboard presentation
ASCII and portfolio (10/29/19 11:00 rest) Accompanying Smartboard presentation
ASCII and portfolio (10/29/19 12:30) Accompanying audio
ASCII and portfolio (10/29/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Rock, Paper, Scissors Program: Write the Rock, Paper, Scissors using JavaScript and get it running. I know there are a lot of models out on the web. I want you to write your own code. If you do code that I have not covered,you need to explain what you did and how it works. You should have a loop so that the user can choose to play again.
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. Remember that the port is now 220. If it is html page then it has a .html extension. The database has a .accdb extension. Check with me if you have problems. This is due at the end of the tenth week.
Number conversions You must pass in the work to get a grade higher than C on this assignment
Week #6
Week of July 6th

INFORMATION:

We are going to continue on with JavaScript this week. Please see the videos and some notes. If you have the book I suggest reading chapters #2, #3 and #4. If you do not have the book continue with the articles I suggested in week 4 and throughout the couse. Actually I think everyone should read the articles.
Basic video
Check back to see if anything has been added.

EXAMPLES TO LOOK AT:

Please look at the JavaScript examples at this address.
For now we are skipping arrays but you should look at the rest.

TOPIC VIDEOS:

Final totals etc.
Math facts programs
Math facts continued
Guess game programs

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

More JavaScript (10/10/19 11:00) Accompanying audio
More JavaScript (10/10/19 11:00) Accompanying Smartboard presentation
More JavaScript (10/10/19 12:30) Accompanying audio
More JavaScript (10/10/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Flowchart and Pseudocode test This is a test. I will accept it late, but late points will be subtracted. As always it is due the Thursday of the week after it was assigned - so in this case July 16th.
Second JavaScript Assignment #2
Week #5
Week of June 29th

INFORMATION:

This week we will continue looking at logic and we will start implementing logic using JavaScript.
If you have the text book read chapters #2 and #3, if not be sure you go through the readings posted last week.
Check back!

EXAMPLES TO LOOK AT:

Please look at the JavaScript examples at this address.
Specifically look at the examples up through finaltotals.html.

TOPIC VIDEOS:

Explanation of the Logic Powerpoint assignment
Introduction to JavaScript
Decisions in JavaScript
Decision where one thing has to be true and either of two others
Debug JavaScript in Firefox
Loops in JavaScript

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Intro JavaScript (10/3/19 11:00) Accompanying audio
Intro JavaScript (10/3/19 11:00) Accompanying Smartboard presentation
Intro JavaScript (10/3/19 12:30) Accompanying audio
Intro JavaScript (10/3/19 12:30) Accompanying Smartboard presentation
JavaScript if and loop (10/8/19 11:00) Accompanying audio
JavaScript if and loop (10/8/19 11:00) Accompanying Smartboard presentation
JavaScript if and loop (10/8/19 12:30) Accompanying Smartboard presentation
JavaScript if and loop (10/8/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Logic PowerPoint assignment Play computer and determine the output.
Don't forget last weeks assignment to go to Collaborate and work with Joe and let me know you did.
First JavaScript assignment
Week #4
Week of June 22nd

INFORMATION:

I strongly recommend setting up study groups that can meet when help is available in Collaborate. Joe can help set them up.
Enrollment Verification is ending 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. I strongly recommend that you read this information from chapter 1, it is a nice outline of a lot of terms and concepts.
Compiler definition
Compiler vs interpreter
Types of software
Memory and RAM
Programming Process
Examples: Pseudocode and Flowcharts
Pseudocode and Flowcharts
If statements
Loops
Data types
I also want to include some information on skills, so please listen to this video and read this handout about note taking.
Note taking plus other techniques for being successful - I suggest checking out the other links on this page
Cornell method of note taking
Check back, I will be adding something more.

EXAMPLES TO LOOK AT:

This week, 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. Note that there are Smartboard and audio about these examples as well as Topic Videos.

Practice exercise
Practice continued

TOPIC VIDEOS:

Topic Video to go with example 1 in practice exercise
Topic Video to go with example 2 in practice exercise
Topic Video introducing some logic concepts
Topic Video to go with file processing in practice continued
Video introducing the 30 question assignment below.

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

Intro logic Smartboard looking at practice exercise and practice continued

ASSIGNMENTS TO DO:

Logic Assignment
30 question logic exercise Follow the logic flowchart and process the input, then tell me the output. You can just show the messages to cut down on the writing.
Check back!
Week #3
Week of June 15th

INFORMATION:

This week we are going to continue with SQL in Access.
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)
Introduction to SQL
W3Schools on SQL

EXAMPLES TO LOOK AT:

Inventory database and explanation:
Inventory database
Examples of SQL with logic flowcharts using Inventory database
Examples of Access queries done in class:
Query examples from 11:00 class (not sure which semester)
Query examples from 12:30 class (not sure which semester)

TOPIC VIDEOS:

SQL queries

SMARTBOARD AND AUDIO NOTES FROM Fall 2019:

The Smartboard and audio that introduced SQL is part of the listing from week #2.
Queries using SQL (9/19/19 11:00) Accompanying audio
Queries using SQL (9/19/19 11:00) Accompanying Smartboard presentation
Queries using SQL (9/19/19 12:30) Accompanying audio
Queries using SQL (9/19/19 12:30) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

Group Assignment: Please note that in the groups everyone should work on all the problems! You are working together as a group!
Note: On the flowcharts in the assignment, sometimes the word Technology is cut off and you see Course instead of Course Technology.
Group DB assignment
Group DB assignment (html version)
Answer sheet for group project
Book Database to use in answering questions (Access2016, 2013)
If you do not receive a group assignment, get back to me. If you have questions contact me.

Database assignment to query with SQL:
Please read the material on SQL available in this weeks weekly area.
You need to send me the database and a list of the SQL queries you wrote so that if the queries get "Microsoft fixed" (read about this in the Smartboard) 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
Week #2
Week of June 8th

INFORMATION:

This week you need to load the page you created up to cisweb. See the videos and notes about this.
Next we will start looking at Access. This tells how to find Access as part of Office365. It is for an earlier version but I have been assured it still works. Access download using Office 365

There is a lot happening this week so do not hesitate to contact Joe or me if you have questions or need help.

EXAMPLES TO LOOK AT:

Example I used in video

TOPIC VIDEOS:

Downloading WinSCP on your PC by SI Joe Fletcher
Using WinSCP to upload to cisweb
Introduction to using Access
Access from Smartboard with flowcharts
More Access Queries

SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019:

There were two sections of the CIS120 last Fall (11:00 and 12:30)and each had two days of Smartboard and audio. I am showing them all so you can choose what to watch. Note also that you should look at the introSQL part next week.
WinSCP and intro Access (9/10/19 11:00) Accompanying audio
WinSCP and intro Access (9/10/19 11:00) Accompanying Smartboard presentation
WinSCP and intro Access (9/10/19 12:30) Accompanying audio
WinSCP and intro Access (9/10/19 12:30) Accompanying Smartboard presentation
Access queries and intro SQL (9/12/19 11:00) Accompanying audio
Access queries and intro SQL (9/12/19 11:00) Accompanying Smartboard presentation
Access queries and intro SQL (9/12/19 12:30) Accompanying audio
Access queries and intro SQL (9/12/19 12:30) Accompanying Smartboard presentation
OLDER NOTES ON WINSCP AND CISWEB:
In my notes I talk about cisweb.bristol.mass.edu. Things have changed and you should now use cisweb.bristolcc.edu and the port number should be 220.
You can also check the notes on the Smartboard and the accompanying audio as well as the notes below.
Again: 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 and 22 as the port, we are now using cisweb.bristolcc.edu as the host and 220 as the port.
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
Remember the host is cisweb.bristolcc.edu and the port is 220.

ASSIGNMENTS TO DO:

Assignment #1: You need to go into Collaborate and talk to Joe and ask him any questions you might have. Then let me know you went!
Note that if you go to the HELP Schedule it gives you the word Collaborate to click on and also has a video about using it.
Assignment #2: 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 #3: Access Database Assignment on BCC College ResourcesThis assignment must be done with the user interface we have looked at in class. It is acceptable to leave some data blank, you can make up some data but some of the data should be from the Bristol web site.
Check back!
Week #1
Week of June 1st

INFORMATION:

Lots of information this week!
Introduction to CIS120
Introduction to CIS120
Each week, I will post information prior to the start of the week. Please check back several times during the week because I may add information and/or assignments as the week progresses. The summer session has less weeks than the spring or fall so there is more information and work packed into each week.
I have set up virtual help session/labs using Collaborate and other tools. Joe Fletcher, my SI is available for virtual help there. Joe's hours in Collaborate are posted above under Help Schedule. I will also set up office hours on Collaborate and you can contact me about other times.
If you are just starting as a CIS major, I recommend that you double check your fall schedule with me if you have questions.
You should have gotten login information in at your Bristol email acount. Please be sure to check for them. We will use them at various points in the course.
I am preparing Topic Videos to go with the work that is being covered. It is a new section that I have added on the left side of the screen along with Smartboard notes etc.
When this course runs in class, I record my lectures (under Audio) and capture my notes and examples using Smartboard. These are available some from the Spring of 2020 but mostly from the Fall of 2019. I strongly recomment you look at them as well.
We will look at HTML/HTML5 and CSS this week to develop a web page. Please look at the samples under Examples and reproduced here.

EXAMPLES TO LOOK AT:

HTML5intro.html
HTML5list.html
HTML5headers.html
HTML5CSSheaders.html
HTML5CSSlist.html
HTML5CSSimage.html
HTML5centeredimage.html
HTML5CSStable.html
HTML5CSScenteredtable.html
HTML5linkpage.html
HTML5morelinks.html
fileInSubHTML5.html
anotherpage.html

TOPIC VIDEOS:

Introduction to HTML
Continuing HTML and introducing CSS
Continuing HTML and introducing CSS
Adding images and tables to your page
Adding images and tables to your page
linking between pages

SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019:

First day and intro to HTML (1/23/20 11:00) Accompanying audio
First day and intro to HTML (1/23/20 11:00) Accompanying Smartboard presentation
Second day and more HTML/CSS (1/28/20 11:00) Accompanying audio
Second day and more HTML/CSS (1/28/20 11:00) Accompanying Smartboard presentation

ASSIGNMENTS TO DO:

All assignments must be turned in using the email addresses that I sent you.
Assignments are due the Thursday of the week after they are assigned. So assignments for this week are due next Thursday, June 11th.
I would try to get it in sooner because their will be a couple of assignments next week. 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:
Survey
Send me an email letting me know you have taken it.
Your assignment for this week:
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.
Note: You do not need to put your web page(s) on line this week. We will do that next week.

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