| 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. 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. 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 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. 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 #8 Week of March 20th |
INFORMATION: How about trying Wednesday at 9PM on Zoom for questions.Check back! ASSIGNMENTS TO DO: Rock, Paper, Scissors Program: Write the Rock, Paper, Scissors using JavaScript and get it running. I know there are a lot of models out on the web. I want you to write your own code. If you do code that I have not covered,you need to explain what you did and how it works. You should have a loop so that the user can choose to play again. (Because of the problems in the browser changes, the choice of playing again is extra credit - also I recommend alert as opposed to document.write) You are playing against the computer which should be a random number. I did a random number example in the guess number program.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 #7 Week of March 6th |
INFORMATION: CIS Alum Panel held on Oct 19th at 12:00 You absolutely should listen to this - it was great! I am working on another alum forum this semester.Tuesday at 11AM on Zoom I will be available to talk about JavaScript - introduction, if, loops, games etc. 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. 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. See the notes on the examples. 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: CIS Alum Panel held on Oct 19, 2022 You absolutely should listen to this - it was great!Flowchart and Pseudocode test This is a test. I will accept it late, but late points will be subtracted. Because of vacation I am going to make it due on Thursday the 23rd of March. . 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! |
| Week #6 Week of February 27th |
INFORMATION: I will hold an optional Zoom help on JavaScript at 11:00 AM on Tuesday. I can do another one if you give me some days and times.I strongly recommend you attend if you have no experience with programming. 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. 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: Logic PowerPoint assignment Play computer and determine the output.First JavaScript assignment Check back! |
| Week #5 Week of February 20th |
INFORMATION: This would be a good time for a Zoom meeting - if you are interested, give me some days and times that work!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 ASSIGNMENTS TO DO: 30 question logic exercise Follow the logic flowchart and process the input, then tell me the output. In this after #4 you can just write the message to cut down on the writing.Another Logic Assignment If you have trouble reading this assignment let me know - some students have and others have not. Check back! |
| Week #4 Week of February 13th |
INFORMATION: I will hold a class to go over Access on Wed at 11:00AM. Trying a different day! If you want to come but this is not a good time, you need to tell me a variety of better times.When you send the Access, it may look like it is not getting through. I am still getting it - I just have to move it from Outlook to process. I am available to go to Zoom if you contact me and arrange a time. 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. 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. 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 EXAMPLES TO LOOK AT: Inventory database and explanation:Inventory database 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 Review of Access user interface and SQL - put up 2/18/2022 TOPIC VIDEOS: Access review put up October 3rd 2020Access review (youtube version) Review of Access user interface - put up 2/18/2022 Review of Access using SQL - put up 2/18/2022 SQL queries SQL queries (youtube version) SMARTBOARD AND AUDIO NOTES FROM Fall 2019: (probably not available yet) 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: 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. Check back! |
| Week #3 Week of February 6th |
INFORMATION: As you know, Access is available through Office 365 - Dashboard. If you have a Crome or Mac then things are not ready for you to run it at this time. You can however come into Bristol and work in K104. It will be installed there and the hours are M-F 8 to 8 and Sat 8-4.I will be on Zoom Monday night at 9PM and Tuesday at 11AM to go over Access. 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. When you send the Access, it may look like it is not getting through. I am still getting it - I just have to move it from Outlook to process. 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 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 (not available yet)Quick example of using CIS pool to get Access (youtube version) (cannot do yet) Access review Access review (youtube version) Video about group project that is an individual project this semester ASSIGNMENTS TO DO: Usually I put a group assignment here, but this semester I am making it an indivdual assignment because everyone is at different points and a group does complicate things, so... 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. Sometimes the flowcharts involve a little guessing on the text, tell me what you assumed if you want to clarify. DB assignment DB assignment (html version) Answer sheet for project Book Database to use in answering questions Quiz #1: Quick Quiz that is due next Thursday. I DO NOT accept late quizzes. Check back! |
| Week #2 Week of January 30th |
INFORMATION: We are going to start Access this week. I am also including the notes for getting your html page up online but that may well be delayed until next week. We are doing well on recovery, but there is a long way to go.I will be in Zoom at 9:00PM Monday and 11AM on Tuesday, to go over HTML and introduce databases and answer questions. 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. I can set up an Access introduction Zoom later in the week or the first of next week. Give me some times that work for you if you are interested. Access is part of Office 365 and can be accessed there or after technology is fixed you can go in through the CIS pool. If you do not have a Windows machine contact me. Currently you can get Access by going to the Bristol website and selecting accessBCC. After you login in from the Bristol page you select Office 365 - Dashboard which brings up Welcome to Microsoft 365. On the screen over to the right is the Install apps button. Click on it and select Microsoft 365 apps. Access is part of the package. There is a lot happening this week so do not hesitate to contact Milo or me if you have questions or need help. EXAMPLES TO LOOK AT: Example I used in video Bristol server (currently not available)Example I used in video my server TOPIC 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: (not available because of technical problems) 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: Again, it depends on the status of cisweb recovery whether we cover putting your page up on the server later in the week or postpone. 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. Note from the IT Help Desk in response to a student loosing files using a Virtual machine: "It sounds like this student is saving their files to the virtual machine local hard drive on the CIS or student pool. You cannot save anything to the desktop, documents or download folder. These virtual machines reset when you log off, so anything saved to the hard drive will erased. Not only that, but the odds of reconnecting to the same virtual machine the next time you log in are next to none. When using this system, students must save their files to their OneDrive to avoid losing their work." 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: Check back when we have a better idea of what has been recovered and what we can do and what we will postpone! Looks like next week will have everything we need - a lot is their now (Wed, Feb 1st).Assignment #1: You need to go into Zoom and talk to Milo and ask any questions you might have. Then let me know you went! Note that I have sent you Milo's Zoom link. Assignment #2: Access Database Assignment on Bristol 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, make up a little etc., but you should find some data on your own as well. There have been questions about the plan to use code. 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 or you can decide on your own codes. Note that we will leave loading to the web for next week, however I left the notes there just in case things came back. When you send the Access, it may look like it is not getting through. I am still getting it - I just have to move it from Outlook to process. |
| Week #1 Week of January 25th |
INFORMATION: Lots of information this week!I will be holding an optional Zoom introduction at 11:00AM on Wednesday, January 25th and again at 9:00PM on Thursday January 26th. They will both be basically the same - a chance to learn about my web site and my expectations. I will send you the address. Introduction to CIS120 - Fall 2022 (youtube version) Introduction to CIS120- Spring 2022 (youtube version) 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. 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 usually available some from the Spring of 2020 but mostly from the Fall of 2019. Due to our technology problems, these will not be available when classes start, but I am leaving them at my site hoping they will be active soon. 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. 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 the youtube versions, the other links do not work at this time) 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: (currently 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 2nd. I would try to get it in sooner because their will be a couple of assignments next week. Your assignment for this week (be sure to click on the link to see the whole assignment): 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 if the technology to do it is there. |