|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. This semester you should use the information from 2019.
|HELP schedule||I sent you the information about Kevin's availability. He is doing Wed 10-12, Thurs 1-3 and Sunday 4-6. Look for the email with his address.
I changed my office hours a little so I did not overlap with Kevin. My office hours are 1 on Monday, 10 on Tuesday, 1 on Wednesday, 10 on Thursday. 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.
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 of November 30th
INFORMATION:Please try to come to the CIS alum discussion of careers/jobs on Zoom on Dec 2nd at 12:00 noon. I sent out the link to the Zoom meeting - if you did not get it, please let me know and I will resend.
Continue working on Visual Basic - the topics posted for the last two weeks.
CATCH-UP WEEK! Please spend your time doing outstanding homework assignments. Extra credit assignment will be posted.
Week of November 23rd
INFORMATION:This week I am going to assign the career project which includes information from alum. Next Wednesday, December 2nd at 12:00, 8 alum are going to participate in a Zoom discussion about their careers. What they do, how they got there, what they enjoy and what they could do without. These presentations have, in the past, been in the classroom but this year it will be a Zoom event. I hope you can attend to here the valuable career information they will convey. Students tell me that this event really helps them understand the career potentials in the field. It is important that you try to attend so you can listen and ask questions if you have any. I will record but being there is important and will give some extra credit on the report you need to prepare. I will send you the address of the event.
If you are having problems with VB, you can also access it via the intranet. Contact me if you want more information.
This week you should continue looking at VB and continue last weeks assignment. We will continue it more next week.
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
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 TO DO:Career Paper Due in three weeks: 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. BE SURE you include information from the alum that spoke on Zoom for your class on Dec 2nd.
Week of November 16th
INFORMATION:After a little break from programming, we are going to start Visual Basic. You can download it from Microsoft. I am giving you the link to download a free copy. We had VB 2019 installed at the college. If you have problems with being able to download and install for your use, we need to talk about alternatives.
Monday office hours at 1:30-2:30.
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 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
As always, check back!
Week of November 9th
INFORMATION:Remember that there is a department wide advising session with CIS faculty on Monday Nov 9th from 12:00 to 2:00 and another on Thursday Nov 12th from 6:00 to 8:00. I have sent out the Zoom address, contact me if you do not have it. This is an excellent opportunity to ask CIS faculty questions about the curriculum and your schedule. Since 1:00 is advising on Monday, I will make an office hour on Friday at 5:00.
On Friday, November 13th there is a talk by William Morrison from Bay State College about digital forensics and cyber security. He will talk about his amazing lab and how they use it to effectively solve situations. Anyone who attends and sends me an email with brief comments about the talk will be given EXTRA CREDIT.
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 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
As always, check back...
Week of November 2nd
INFORMATION:I will not be available Tuesday at 10 since I have to go to a college wide faculty and staff meeting. I can be available Friday instead. For now, lets say 10.
The first thing I want you to do is look at the information on ASCII that you have on the schedule for week #8.
ASSIGNMENTS TO DO:ASCII assignment
Week of October 26th
INFORMATION:Kevin Dailey is our new SI. He will be available on Wednesday from 10-12 (except this week when it will be 1-3), Thursday 1-3 and Sunday 4-6. I will post the address.
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 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
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 of October 19th
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
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 Oct 29th. The flowcharts are my (not so successful) experiment with a drawing toy! Let me know if you have questions.
Week of October 12th
INFORMATION:Joe has a new programming job - congratulations and our best! However, we will miss him a lot. I am in the process of seeing up a study group and tutoring but I am not sure when it will be set. So in the meantime, I will be available a lot this week. Let me know if you need Zoom time. I will definitely do my office hours, but I am willing to do lots more including some evenings. So... Stay in touch!
This week we are going to continue with logic - I added a Powerpoint presentation about playing computer into last weeks layout. I think it will be helpful with the Logic Assignment. There are also two Powerpoint presentations on if and loops that you need to definitely 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 last fall 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
PRESENTATIONS:For help on if statements, look at this presentation: (There is a video that explains this as well)
Presentation on logical if structures
Separate speaker notes to accompany presentation on logical if structures
Please look at this PowerPoint on loops and repetition: (There is a video that explains this as well)
Presentation on structure (focus on loops)
Separate speaker notes to accompany presentation structure (focus on loops)
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:Logic PowerPoint assignment Play computer and determine the output.
Check back - work in progress!
Week of October 5th
INFORMATION:Let me know if you want Zoom during my office hours and suggest other times if my office hours do not work and you need some Zoom time.
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.
I have a dentist appointment at the time of my office hours on Tuesday so instead I will do an office hour at 1 on Friday.
The optional book is a reference book so 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.
Before you do the 30 questions I would listen to that 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 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.
PRESENTATION:Presentation on using pseudocode to play computer (This will be helpful for the Logic Assignment.)
Separate speaker notes to accompany presentation on using pseudocode to play computer
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
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.
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:
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 vs interpreter
Types of software
Memory and RAM
Examples: Pseudocode and Flowcharts
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
EXAMPLES TO LOOK AT:Inventory database and explanation:
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)
Review of Access put up October 3rd 2020 - corrected version Oct 5th Accompanying video
TOPIC VIDEOS:SQL queries
Access review put up October 3rd 2020
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 as a group assignment, 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. 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
Database assignment to query with SQL:
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. 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 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:
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.
There have been questions about the plan to use code and I think I gave a poor answer a few times. Anyway, the plan to use code is simply you saying whether you plan to use that resource. You can have a Y, N, M for yes, no, maybe.
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.
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 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
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 firstname.lastname@example.org 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:
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.