|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.
|HELP schedule||I will set up some optional class Zoom meetings that you can attend. Check the week of information to see the times and dates. But first
you need to tell me some days and times that work for you.|
There will be a tutor available for this class, his name is Milo and I have sent you his Zoom address and available times.
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
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.
Week of August 15th
I can be available Wednesday at 9:00PM for questions and some other time if you let me know options.
Final Exam due August 20th
Required status sheet due August 20th or before
I do not correct exams unless I also have the required status sheet. This is your assurance that you are getting credit for everything you did. I compare my records to your records and let you know if something is missing.
Week of August 8th
INFORMATION:This is the last week of classes. This last week, we are going to briefly look at relational databases. Note that homework is due on the 20th. The final will be posted next week. It is an open notes, open book exam and is only worth 10% of your grade. Homework is worth 80% of your grade.
If we should talk, get in touch.
I will be available on Monday at 9PM.
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
Visual Basic quiz
Extra Credit Quiz
EXTRA CREDIT Visual Basic Assignment
Week of August 1st
INFORMATIONI am available for a Zoom meeting at 9PM on Monday.
We are starting to look at Visual Basic in Visual Studio. You can use version 2022 or an earlier version (my notes are 2019 I believe). Use the community edition. Download Visual Studio from Microsoft
EXAMPLES TO LOOK AT:Visual Basic Programs to download and unzip Through if statements covered in videos - loops and beyond are covered in the videos I added.
TOPIC VIDEOS:Make first Visual Basic program
Make first Visual Basic program (youtube version)
Two introductory Visual Basic programs
Two introductory Visual Basic programs (youtube version)
IF Visual Basic program
IF Visual Basic program (youtube version)
If where one thing has to be true and either of two others
If where one thing has to be true and either of two others (youtube version)
More IF examples in VB
More IF examples in VB (you tube version)
Continuing on with Visual Basic (videos you should look at)
Input, work areas and loops
Jnput, work areas and loops (youtube version)
Arrays - compare JS and VB
Arrays - compare JS and VB (youtube version)
Write and read files
Write and read files (youtube version)
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
Continuing on to the input, loops, arrays and read/write:
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
Redo this assignment in Visual Basic
Only the one Visual Basic assignment this week even though I have presented additional visual basic information.
Week of July 25th
INFORMATION:I will be online at the usual 9:00 and another time if I get some requests. This week we are going to start Visual Basic (I will load that later) and you are going to explore jobs in technology with help from some recordings of CIS alum and conversation with a mentor. Your mentor will be an alum of CIS at Bristol and will be someone working in the field. You will get information about your mentor early in the week.
Alumni talks to previous classes.
Last year a group of alum spoke via Zoom. They talked about their jobs and careers. If you are interested, the link information is here: Alum panel Password is egc8Vpz%
I would also like 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 and mentor paper: The mentors are professionals who went through the CIS program at BCC and are now working in the field or continuing their studies. They have generously volunteered to be an email mentor to discuss career and skills with current students. This assignment will need you to interview your mentor and listen to some of the alum talks. 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. You should also include information from the alum discussions posted above.
Your paper should contain information about your mentor's job or degree program with several quotes from your mentor. The second part should be researching a career in computing that interests you and writing about what the job involves and the skills that are needed. The paper should include notes citing your sources (I would estimate that you need at least a couple of pages to cover the goals well). In addition, send me a list of the questions you asked your mentor.
ASCII assignment This is a check off assignment.
I will be posting information about Visual Basic with an assignment next week, so check back... They are up under week #10.
Week of July 18th
INFORMATION:I will be available Monday night at 9:00 PM. As always, let me know if you want to meet another time and give me some choices.
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 from Fall 2019. You should also look at a couple of examples I wrote out.
Very basic portfolio example:
Portfolio - page 1 example
Portfolio menu - page 2 example
The last day for student withdrawal is July 23rd so you should evaluate your status and decide whether to with draw or not. If you are way behind you need to evaluate honestly. If you would like to talk, let me know.
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
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 July 11th
INFORMATION:As usual, I will do Monday and Tuesday at 9PM.
Check back to see if anything has been added.
For now we are skipping arrays but you should look at the rest.
TOPIC VIDEOS:Final totals etc.
Final totals etc. (youtube version)
Math facts programs
Math facts programs (youtube version)
Math facts continued
Math facts continued (you tube version)
Guess game programs
Guess game programs (youtube version)
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 21st.
I also want the flowchart or pseudocode for these problems.
Week of July 4th
Week of June 27th
INFORMATION:I will be available either Monday or Tuesday at 9:00PM - check back! I can do both so I will be on both Monday and Tuesday at 9:00 PM..
If you have the text book read chapters #2 and #3, if not be sure you go through the readings posted last week.
Specifically look at the examples up through finaltotals.html.
TOPIC VIDEOS:Explanation of the Logic Powerpoint assignment (Youtube version)
Decision where one thing has to be true and either of two others (youtube version)
ASSIGNMENTS TO DO: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.
Logic PowerPoint assignment Play computer and determine the output.
Week of June 20th
INFORMATION:I will be available for help Tuesday at 11:00 AM (Tuesday night just does not work this week - sorry). If nights work better, let me know and we can try for Wed or Thurs. We can set up other times - suggestions please!!!
I strongly recommend setting up study groups. If you are interested send me your name and I will sent the names to those who are interested.
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 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
I will be adding some information on logic that we will look at the last part of the week.
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 (you tube version)_
Topic Video introducing some logic concepts
Topic Video introducing some logic concepts (you tube version)
Topic Video to go with file processing in practice continued
Topic Video to go with file processing in practice continued (you tube version)
SMARTBOARD AND AUDIO NOTES FROM Fall 2019:Intro logic Smartboard looking at practice exercise and practice continued
ASSIGNMENTS TO DO:If you need a little more time on the group project because one or more people are not comfortable with Access yet, let me know and it is fine.
Check back, I will be adding something more.
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 of June 13th
INFORMATION:I will be available Monday at 9:00PM on my Zoom to discuss uploading to cisweb, Access and SQL. If you do not know the Zoom address, email me. I will try to add some more times if you let me know you want to meet and a few times that work.
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:
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
SQL Queries (youtube version)
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:I am holding back on the assignment to give you a chance to do the Access. I am posting a group assignment and I will send out your groups this weekend. Please check back!
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.
I will post the homework about SQL and Access next week, but do start looking at the information.
Week of June 6th
INFORMATION:I will hold a Zoom meeting about putting the website on line and an introduction to the Access database on Monday at 9:00PM. I can repeat later in the week. If you would like a help session at a different time, send me some times and days that work for you.
I have sent you Milo's Zoom address and his hours. Let me know if you did not get them or have questions.
If you get your login to cisweb, I would like you to upload the page you created to cisweb. If you do not get it soon, then we will extend the due date by a week. See the videos and notes about working with cisweb and WinSCP..
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: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 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! If you have already met me on Zoom, you need to send me an email confirming 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. Note if you do not get the login information for cisweb and WinSCP this week you can extend to next week.
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 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. You can avoid this by putting it up on cisweb and sending me the address or usually zipping also works or putting a jpg extension instead of the zip and telling me in the email to change the extension back to zip once I receive it. I do need to get the Access database sent.
Week of May 30th
INFORMATION:Lots of information this week!
I will be holding a Zoom introduction at 11:00AM, 2:00PM and 9:00PM on Tuesday, May 31st. They will all be basically the same - a chance to learn about my web site and my expectations. I will send you the address.
Introduction to CIS120- Spring 2022 (youtube version)
Introduction to CIS120 - summer 2022 Passcode: Q1@FtgU%
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 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: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: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, June 9th. (This was a big WOOPS! since I originally posted the date as June 2nd - Sorry!).
I would try to get it in sooner because their will be a couple of assignments next week. 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.