|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 record all my classes and capture notes on the Smartboard in the spring and fall when I teach online. The recordings (audio) and the Smartboard are available for all students to use under Audio and Smartboard. This semester you should use the information from 2019 and some from Spring 2020.
I will set up some optional class Zoom meetings that you can attend. Check the week of information to see the times and dates.
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.
Here are some videos you may find useful to connect to resources. Some of these apply to Mac users.
Downloading WinSCP on your PC by SI Joe Fletcher
Connecting to the CIS Pool
Where you used to use (http://view.bristolcc.edu/) you should now use (https://vdi.bristolcc.edu/). Although to do manipulating of data you should use the Horizon login information on the sheet and videos from Janelle.
How to log into Bristol vlabs using a web broswer
Filezilla on the Mac
There is access to WiFi from your car under the solar canopies on the Fall River Campus.
|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.
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 1st
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 #11 Flex
Week of April 24th
INFORMATION:Contact Milo or me if you want more information about VB.
This week you should continue looking at VB and continue last weeks assignment.
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
The index or first page should have basic information. The second page should link to at least four things that you have done. An html page has a .html extension. The database has a .accdb extension. Check with me if you have problems.
NOTE: The portfolio does not have to be online this semester. If you make it online extra credit.
Shows how to connect to horizon and includes putty and winscp
This is due on May 12th.
EXTRA CREDIT ASSIGNMENTS TO DO:Makeup/Extra Credit Quiz
Extra Credit Visual Basic assignment
I really thing it would be great to do the VB extra credit so high extra credit.
If you can think of an interesting project to do that shows what you learned and takes that a step further you can send me an extra credit proposal. Be sure to label as such in the subject so I will look at it quickly.
|Week #10 Flex
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.
The end is in sight. We are going to look at Visual Basic and that is the last real topic for the semester. We are starting Visual Basic this week. The current version is VB2022. Most of the examples are from previous versions but they work, it is the interface that has changed. The first example goes into version 2022 and there is a video to accompany it.
Download Visual Studio from Microsoft Use Community edition.
EXAMPLES TO LOOK AT:Visual Basic Programs to download and unzip
TOPIC VIDEOS:Make first Visual Basic using version 2022
Make first Visual Basic program using previous versions of VB
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:You can try sending me the zipped folder with all of the files in it, but we have had trouble with it going through with the executable so... I suggest you send pictures of the screen that shows the code and pictures that show testing your program.
Visual Basic Assignment
|Week #9 Flex
Week of April 10th
This week we are going to go back and take another look at databases, but this time we are going to use multiple tables. This is a brief introduction to the concepts so that it will make a little sense when people talk about a relational database and 3rd normal form. There are entire courses on this topic, so again my goal is familiarity.
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 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
As always, check back...
|Week #8 Flex Start
Week of April 3rd
INFORMATION:The CIS Alum Zoom Panel will be April 5th at noon at my regular Zoom account - I sent you the information in an email today. Please try to attend - it always gets great reviews!
I will be online at Zoom at 11:00AM on Tuesday. If you are having problems try and attend or setup an alternate time with me. I can do most days and evenings.
Last week I assigned you a mentor who is an alum from the CIS program at Bristol and is working in the field. This is an opportunity to ask questions and connect. I think it is one of the most important assignments.
This week we are finishing our quick look at numbering systems and codes.
ASSIGNMENTS TO DO:Please listen to todays recording of the CIS Alum panel.
CIS Alum Panel Spring 2023
ASCII assignment ASCII assignment
|Week #7 Flex Start
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. It would give you some good information to add to your career paper.
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 which is not covered and look at the link below.
Reference for ASCII You can start looking this week, but the assignment on this will be next week.
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
Number conversions You must pass in the work to get a grade higher than C on this assignment
Career and mentor paper: The mentors are professionals who went through the CIS program at Bristol 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. You should also ask your mentor about the soft skills they find are important and why. Your paper should contain information about your mentor's job or degree program with several quotes from your mentor. You should also include information from the panel of CIS alum. 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 on May 1st by midnight. If you have trouble contacting your mentor, let me know and pass in the mentor part late (the research part must be on time to get full points). If you are too far behind on work and you need to send me a lot of work, I may not send 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 week and you think you should have be sure to contact me so we can figure out any problems.
|Week #6 Flex Start
Week of March 20th
INFORMATION:How about trying Wednesday at 9PM on Zoom for questions.
The book if you bought it is a reference book, check out the logic explanations.
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
Review of programs and comments on Rock, Paper,Scissors
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 March 30th. . The flowcharts are my (not so successful) experiment with a drawing toy! Let me know if you have questions. Remember it is a test so no working with anyone but me (that includes Milo).
Week of Match 13th
|This is break/catch-up week. I will be around especially Monday, Tuesday and Friday. I will have a Zoom meeting Tuesday at 11AM|
|Week #5 Flex Start
Week of March 6th
INFORMATION:CIS Alum Panel was held on Oct 19, 2022 You absolutely should listen to this - it was great! I am putting together another one for this semester.
NOTES/EXAMPLES TO LOOK AT:As always, be sure you listen to the videos. They go over the topics. For backup there are the Smartboard and audio from a previous class which are the lectures that I delivered in class - a lot of students find those very helpful.
Specifically look at the examples up through if statements and next week we will move on through finaltotals.html and maybe beyond..
TOPIC VIDEOS:Explanation of the Logic Powerpoint assignment
Explanation of the IF statement Powerpoint presentation
Explanation of the loop Powerpoint presentation
Decision where one thing has to be true and either of two others
SMARTBOARD AND AUDIO NOTES FROM Fall 2019:Logic ifs and loops (9/26/19 11:00) Accompanying audio
Logic ifs and loops (9/26/19 11:00) Accompanying Smartboard presentation
Logic ifs and loops (9/26/19 12:30) Accompanying audio
Logic ifs and loops (9/26/19 12:30) Accompanying Smartboard presentation
Inclass ifs (10/1/19 11:00) Accompanying audio
Inclass ifs (10/1/19 11:00) Accompanying Smartboard presentation
Inclass ifs (10/1/19 12:30) Accompanying audio
Inclass ifs (10/1/19 12:30) Accompanying Smartboard presentation
ASSIGNMENTS TO DO:CIS Alum Panel held on Oct 19th at 12:00 You absolutely should listen to this - it was great!
Logic PowerPoint assignment Play computer and determine the output.
|Week #4 Flex Start
Week of February 27th
Please get in touch if you have questions - I really do not want to see anyone fall behind.
Note that the beginning of the course is heavier in assignments then the end when things get more complicated!
I want to continue to look at SQL (Structured Query Language) this week. I am including some examples that will help and I suggest you do some research on your own.
Some SQL examples Let me know if you find a typo.
We are going to start looking at logic this week. Logic is truly the key to successful computing, it is at the root of instructing computers.
The optional book is a reference book so,if you got it use it to help you understand logic.
The first thing to do is the Practice exercise. I would listen to the video for the first one and make sure you understand and then I would try the second one alone before listening to the video. Finally you also want to go through the logic concepts and the file processing video.
As always I suggest listing to the audio along with the Smartboard from the previous classes.
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.
TOPIC VIDEOS:Topic Video to go with example 1 in practice exercise
Topic Video to go with example 1 in practice exercise (youtube version)
Topic Video to go with example 2 in practice exercise
Topic Video to go with example 2 in practice exercise (youtube version)
Topic Video introducing some logic concepts
Topic Video introducing some logic concepts (youtube version)
Topic Video to go with file processing in practice continued
Topic Video to go with file processing in practice continued (youtube version)
Video introducing the 30 question assignment below. (youtube version)
SMARTBOARD AND AUDIO NOTES FROM Fall 2019:Intro logic (9/24/19 11:00) Accompanying audio
Intro logic (9/24/19 11:00) Accompanying Smartboard presentation
Intro logic (9/24/19 12:30) Accompanying audio
Intro logic (9/24/19 12:30) Accompanying Smartboard presentation
READINGReading - 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 vs interpreter
Types of software
Memory and RAM
Pseudocode and Flowcharts
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
ASSIGNMENTS TO DO:If you need a little extra time, take it.
30 question logic exercise Follow the logic flowchart and process the input, then tell me the output. Starting with probem 5, you can just show the messages to cut down on the writing.
Another Logic Assignment
Quiz #1: Quick Quiz that is due next Thursday (the 9th). Please notice the quiz code question ahead of time so you will be able to connect with Milo and get the answer. Check back!
|Week #3 Flex Start
Week of February 20th
INFORMATION:If you would like a Zoom meeting to go over the material, let me know and suggest a few days and times.
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:
Please get in touch if you have questions - I really do not want to see anyone fall behind.
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:
Some SQL examples Let me know if you find a typo.
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
Quick example of using CIS pool to get Access (youtube version)
Access review (youtube version)
SQL queries (youtube version)
SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: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:Database assignment to query with SQL-softskills database: You need to send me the database and a list of the SQL queries you wrote so that if the queries get "Microsoft fixed" I can see what you wrote. I also want you to send me the output that was generated. 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 So I want two things: the database and a printout showing the SQL code and the resulting output.
I used to put a group assignment here but because of the tech problems I am making it an individual project this semester.
This assignment involves the user interface and logic - it does not get into SQL. This is NOT an assignment that can be resubmitted.
Note: On the flowcharts in the assignment, sometimes the word Technology is cut off and you see Course instead of Course Technology.
DB assignment (html version)
Answer sheet for project
Book Database to use in answering questions
|Week #2 Flex Start
Week of February 13th
INFORMATION:When is a good time to meet on Zoom. For now I am suggesting Wednesday at 11:00AM when I will talk about Access.
I have sent you Milo's Zoom address and his hours. Let me know if you did not get them or have questions.
At this point, you cannot upload your HTML page to the internet. I have included the information on how to do it in the hope that things will be fixed soom.
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 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
Using WinSCP to upload to cisweb (youtube version)
Quick example of using CIS pool to get Access
Quick example of using CIS pool to get Access (youtube version)
Introduction to using Access
Introduction to using Access (youtube version)
Access from Smartboard with flowcharts
Access from Smartboard with flowcharts (youtube version)
More Access Queries
More Access Queries (youtube version)
SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019:(probably not available yet)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.
Remember the host is cisweb.bristolcc.edu and the port is 220.
ASSIGNMENTS TO DO:If you need a little extra time, please let me know.
Assignment #1: You need to go into Zoom and talk to Milo or me (if his hours do not work for you) and ask us any questions you might have. Then let me know you went!
Assignment #2: Access Resource Assignment
This assignment must be done with the user interface we have looked at in class. It is acceptable to leave some data cells blank, you can make up some data but some of the data should be from the Bristol web site.
Note that even if you get a symbol indicating you can not send it, I can usually forward and open it.
|Week #1 Flex Start
Week of February 6th
INFORMATION:Lots of information this week!
As you know, there is a serious technology problem at Bristol. The IT department is diligently working to get everything straightened out, but it takes time. There some things like Smartboard and audio from a previous semester are not yet available.
I am using the introduction from last Fall to tell you about the class (and I included some others just to be sure).
Introduction to CIS120 - Fall 2022 (youtube version)
Introduction to CIS120 - Fall 2021
Introduction to CIS120 - Summer 2021
Introduction to CIS120 (5/27/20)
Introduction to CIS120
Each week, I will post information at 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.
Check the help session for support!
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.
Please check the examples, the topic videos and the other resources posted at my site that I list and that relate to what we are covering.
There are lots of resources at my site, some that we will never use. Please use the resources I tell you to use about the current topic beinging covered.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.
So, to summarize. This week look at the examples under EXAMPLES TO LOOK AT and the explanation of these examples under TOPIC VIDEOS. You should also try out the SMARTBOARD AND AUDIO NOTES so you can hear the lecture and see the notes from the class.
EXAMPLES TO LOOK AT:HTML5intro.html
TOPIC VIDEOS: (Use youtube versions)This is an intro from a previous semester in case you want to here a slightly different version (this is also out on youtube)
Starting a NEW HTML page
Starting a NEW HTML page (youtube version)
Introduction to HTML
Introduction to HTML (youtube version)
Continuing HTML and introducing CSS
Continuing HTML and introducing CSS (youtube version)
Adding images and tables to your page
Adding images and tables to your page (you tube version)
linking between pages
linkingbetween pages (youtube version)
SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: (not available)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 email@example.com.
Assignments are due the Thursday of the week after they are assigned. So assignments for this week are due next Thursday, February 16th.
I would try to get it in sooner because their will be a couple of assignments next week. 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 when connections are fixed..