| 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. 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. |
| Week #6 Flex Start Week of March 20th |
INFORMATION: How about trying Wednesday at 9PM on Zoom for questions.This week we are going to continue with JavaScript so please continue looking at the rest of the examples under the JavaScript. Eventurally we will look at them all up through and including the series of Guess Game scripts/programs. The book if you bought it is a reference book, check out the logic explanations. Here is an online Zoom meeting on JavaScript (after the introductory material). Recording from 3/8/21 The passcode is oZ!^&30k EXAMPLES TO LOOK AT: Look at the JavaScript examplesFor 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 SMARTBOARD AND AUDIO NOTES FROM Fall 2019: More JavaScript (10/10/19 11:00) Accompanying audioMore JavaScript (10/10/19 11:00) Accompanying Smartboard presentation More JavaScript (10/10/19 12:30) Accompanying audio More JavaScript (10/10/19 12:30) Accompanying Smartboard presentation 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).Second JavaScript assignment Extra credit if you do a logic flowchart or pseudocode for Second JavaScript as well as the assigned coding in JavaScript. Check back! |
| Break/Catch-up 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 Check back! |
| 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.I will hold the optional Zoom meeting at 11 on Tuesday to discuss JavaScript. 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.Start the week by looking at the logic components and then move on to JavaScript. We will continue with topics like if and loops next week. Some of the material on JavaScript will definitely be continued next week. Note that document.write can be tricky to use because in a loop it tends to hold the information to the end. I suggest using alert to show the output when you are using loops. Be sure to go over the Topic Videos on JavaScript and the examples and again I recommend the Smartboard and audio from last year. Our goal in the next few weeks is to be able to use logic to figure out how to solve a problem and then write a script/program with JavaScript. The next topic is the introduction to JavaScript and above all else, I want you to understand the examples so that you to can write the code. EXAMPLES TO LOOK AT: Please look at the JavaScript examples at this address.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 assignmentExplanation of the IF statement Powerpoint presentation Explanation of the loop Powerpoint presentation Introduction to JavaScript Decisions in JavaScript Decision where one thing has to be true and either of two others Debug JavaScript in Firefox Loops in JavaScript SMARTBOARD AND AUDIO NOTES FROM Fall 2019: Logic ifs and loops (9/26/19 11:00) Accompanying audioLogic 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 Intro JavaScript (10/3/19 11:00) Accompanying audio Intro JavaScript (10/3/19 11:00) Accompanying Smartboard presentation Intro JavaScript (10/3/19 12:30) Accompanying audio Intro JavaScript (10/3/19 12:30) Accompanying Smartboard presentation JavaScript if and loop (10/8/19 11:00) Accompanying audio JavaScript if and loop (10/8/19 11:00) Accompanying Smartboard presentation JavaScript if and loop (10/8/19 12:30) Accompanying audio JavaScript if and loop (10/8/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. First JavaScript assignment |
| Week #4 Flex Start Week of February 27th |
INFORMATION: We will be sstarting JavaScript soon so I will be doing an introduction to it on Zoom on Tuesday at 11:00AM.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.Practice exercise Practice continued TOPIC VIDEOS: Topic Video to go with example 1 in practice exerciseTopic 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 audioIntro 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 READING Reading - there is not a required text but there is reading that will add to your knowledge base and that is required.The readings below should be done sometime in the next few weeks. If you bought the optional text, read chapter 1 (you might note that at Amazon much of the first chapter is available for Just Enough Programming Logic and Design in the Look inside feature). Might help you decide about the book and chapter #1 is a key chapter for some of the basic knowledge I want you to acquire. Compiler definition Compiler vs interpreter Types of software Memory and RAM Programming Process Pseudocode and Flowcharts If statements Loops Data types I also want to include some information on skills, so please listen to this video and read this handout about note taking. Note taking plus other techniques for being successful -I suggest checking out the other links on this page . Cornell method of note taking 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: Database21.accdb Explain Database21.accdb 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: Inventory database 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 AccessQuick example of using CIS pool to get Access (youtube version) Access review Access review (youtube version) SQL queries SQL queries (youtube version) SMARTBOARD AND AUDIO NOTES FROM Spring 2020 and Fall 2019: Queries using SQL (9/19/19 11:00) Accompanying audioQueries 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. Database Questions: 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 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 videoTOPIC VIDEOS: Downloading WinSCP on your PC by SI Joe FletcherUsing 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. WINSCP 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. Check back! |
| 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) Past introductions: 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.htmlHTML5list.html HTML5headers.html HTML5CSSheaders.html HTML5CSSlist.html HTML5CSSimage.html HTML5centeredimage.html HTML5CSStable.html HTML5CSScenteredtable.html HTML5linkpage.html HTML5morelinks.html fileInSubHTML5.html anotherpage.html TOPIC VIDEOS: (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 audioFirst 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 priscilla.grocer@bristolcc.edu.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.. |