|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.
For now, office hours will be 11 on Monday and Wednesday and 1 on Tuesday and Thursday by appointment. I hold my office hours in Zoom. 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
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 #3 Flex Start
Week of October 3rd
INFORMATION:I will be available for Zoom a lot the weekend of October 1st and 2nd. I will leave Zoom on a lot and you can set up an appointment with me via email as well.
I can do a Zoom at 9:00 Tuesday night and a day time one if you get back to me with what works.
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: 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.
Group Assignment: Well, I finally got the group project out and I would like it back in two weeks so lets say Oct 21st. If you did not get one it was a mistake or you were so far behind I thought you were not ready. Contact me if you did not get one and want to be part of a group.
This is a group assignment. You will get an email for your group designating a group leader. You can work with email or set up a Zoom account where you can work. The goal is to talk it over and figure out the answers. If you do not get a group assignment, contact me. You have two weeks to do this so due October 21st. The groups will be sent out Wed.
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 September 26th
INFORMATION:When is a good time to meet on Zoom. For now I am suggesting Wednesday at 11:00AM.
I had technical problems and was late getting on. I will also try again for Thursday at 11:00AM
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: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! 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 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. I messed up on the last code - I confused never used and have used so you can decide which name you want to give it and use that for the queries - my apologies!
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 #1 Flex Start
Week of September 19th
INFORMATION:Lots of information this week!
I will be available at 11:00AM on Monday at Zoom to go over my web site. I will also try to set up an evening later in the week so check back. I am going to be available for an optional meeting at 8:00PM on Tuesday and Wednesday at 1:00. The Zoom information will was e sent on an email.
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: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 firstname.lastname@example.org.
Assignments are due the Thursday of the week after they are assigned. So assignments for this week are due next Thursday, September 29th.
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:
The survey has been taken down so I am looking for a replacement to post another week.
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.