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 Zoom - see HELP section below.

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 all students to use under Audio and Smartboard.
HELP schedule Joe Fletcher is my SI. To contact Joe use moocowoftech@gmail.com. He will be available for open labs Monday from 2 - 4:30, Tuesday from 10-12, Wednesday from 2-4:30, Thursday 10-12, Friday 11-2. Joe's meeting id is 7159615258 students just go to Zoom Meeting and click join they will then be prompted for the meeting id.
My office hours are 1 on Monday, 10 on Tuesday, 10 on Wednesday, 1 on Thursday. If it turns out other hours work better for students these may change, so check back.
I will send out the information to contact me on Zoom. I will post availability but you can also set something up with me.
I had to take down the Zoom address I had posted so the answer to the quiz question is to contact 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.
Week #4
Week of September 28th

INFORMATION:

During my office hours, I am available to go to Zoom if you contact me and arrange a time. If my office hours do not work let me know and we can arrange another meeting.
In response to some questions about Access, I added a few more resources uner week #3, so check them out.
Please pass in one assignment (all parts of the assignment) in one email so if there are two assignments/quizzes for a week I want separate emails. Make correcting easier.
If you have a question make that clear in the subject.
Please get in touch if you have questions - I really do not want to see anyone fall behind.
This is Enrollment Verification week 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.
I want to look at SQL (Structured Query Language) this week. I am including some references that will help and I suggest you do some research on your own.
Introduction to SQL
W3Schools on SQL
Inventory database and explanation:
Inventory database
Some SQL examples Let me know if you find a typo.
Reading - there is not a required text but there is reading that will add to your knowledge base and that is required.
The readings below should be done sometime in the next few weeks.

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 and chapter #1 is a key chapter for some of the basic knowledge I want you to acquire.
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

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:

This assignment was originally done in class, but life has changed. Be sure to get back to me or to Joe with questions. This assignment involves the user interface and logic - it does not get into SQL.
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
Check back - I will be posting a database to query with SQL.
Week #3
Week of September 21st

INFORMATION:

During my office hours, I am available to go to Zoom if you contact me and arrange a time. If my office hours do not work let me know and we can arrange another meeting.
Last week I asked you to look at using Access to develop databases. This week we will continue exploring Access. Be sure that you have looked carefully at the notes I put up for you to look at last week.
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)
Here is another sample database I created:
Database21.accdb
Explain Database21.accdb

EXAMPLES TO LOOK AT:

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

TOPIC VIDEOS:

Quick example of using CIS pool to get Access

ASSIGNMENTS TO DO:

Access Database Assignment on BCC College Resources This assignment must be done with the user interface covered in the notes and examples last week. it should not be done with SQL - next weeks assignment will deal with SQL. It is acceptable to leave some data blank but you should find some data on your own as well.
Check back!
Week #2
Week of September 14th

INFORMATION:

I will go to my Zoom area during office hours this week.
This week I will have you load your page up to the server and then we will start looking at the concepts of a database and how to create one in Access. The notes and examples for getting started with Access are shown.
Access is part of Office 365 and can be accessed there or it can be accessed through the CIS pool.
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
Quick example of using CIS pool to get Access
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 Zoom 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 tells how to contact him.
Assignment #2: Upload your web page introducing yourself to the cisweb server and send me the address.
Quiz #1: Quick Quiz that is due next Thursday. I DO NOT accept late quizzes.
Week #1
Week of September 7th

INFORMATION:

Lots of information this week!
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.
We will set up virtual help session/labs using Zoom and other tools. Joe Fletcher, my SI is available for virtual help there. Joe's hours in Zoom will be posted above under Help Schedule. I will also set up office hours on Zoom 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:

Starting an HTML page NEW
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 priscilla.grocer@bristolcc.edu with a cc to the email address I will send you. I like to have backup.
Assignments are due the Thursday of the week after they are assigned. So assignments for this week are due next Thursday, September 17th.
I would try to get it in sooner because frequently there are a couple of assignments in a 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