| 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 when I teach in class, I record 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 and some from Spring 2020. |
|---|---|
| HELP schedule | I will try to 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 tutors available for this class. You can check with the tutoring center or contact me for times and days. I will post the information when I get it. If you want to meet on Zoom with me, 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. |
| Week #9 Week of October 27th |
INFORMATION: 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 are playing against the computer which should be a random number. I did a random number example in the guess number program.Extra Credit: A loop in the Rock/Paper/Scissors program so that the user can choose to play again. There are problems with document.write in a loop because of browser changes, the choice of playing again is extra credit and will require some research - also I recommend alert as opposed to document.write) Career and mentor paper: The mentors are professionals who went through the CIS program at Bristol 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. 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. Your paper should contain information about your mentor's job or degree program with several quotes from your mentor. You should also include information and quotes from the panel of CIS alum 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. The paper is due on November 28th by midnight. If you have trouble contacting your mentor, let me know and pass in the mentor part late (the research part must be on time to get full points). If you are too far behind on work and you need to send me a lot of work, I may not send you a mentor until you are more caught up and proved you are participating in this course. If you do not get a mentor this week and you think you should have be sure to contact me so we can figure out any problems. |
| Week #8 Week of October 20th |
INFORMATION: 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. My apologies - rescheduled Zoom for October 23rd at 8:30PM. We can go over logic and JavaScript. 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: Alum Forum/Panel. 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 October 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 tutors).Second JavaScript assignment Extra credit if you do logic flowcharts or pseudocode for Second JavaScript as well as the assigned coding in JavaScript. You can have some extra time on this assignment if you need it and PLEASE contact Tom or Sabrina or me if you have JavaScript problems. Check back! |
| Week #7 Week of October 13th |
INFORMATION: This week we are going to continue with logic. There are two videos 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.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 previous semesters. 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 PRESENTATIONS:These have a problem - the Topic Videos cover the material 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 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 - work in progress! |
| Week #6 Week of October 6th |
INFORMATION: As always I am available to set up a Zoom meeting with you or with a group!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. You can just show the messages to cut down on the writing. If you decide you would like to do this with a group, you need to let me know by Oct 8th and I will assign you to a group. Otherwise it will be an individual assignment. Please get it in by Oct 16thAnother Logic Assignment - individual assignment Don't forget QUIZ #2 is due on October 9th and I do take off points for late quizzes.
|
| Week #5 Week of September 29th |
INFORMATION: If you would like to set up a Zoom meeting to go over anything, please let me know. I am available a lot from Wednesday on.When you send the Access, it may look like it is not getting through. I am probably still getting it - I just have to move it from Outlook to process. Sending a zip file can help. 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. Ideally by the end of October. If you bought the optional text, read chapter 1 and then check out the material that goes with the work we are doing. Compiler definition Compiler vs interpreter Types of software Memory and RAM Programming Process Pseudocode and Flowcharts If statements Loops Data types Note taking Skills for college success include knowing how to do effective 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) Video about group project 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: 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: Two assignments: database using SQL and Quiz #2Database 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. Quiz #2: This needs to be passed in by October 9th - late quizzes loose some points. Use my notes and the Internet for information. Quiz #2 Topic: Access Please check back as always! |
| Week #4 Week of September 22nd |
INFORMATION: Looks like I am free Wednesday, Sept 24th from 12 to 1 so I can be available on Zoom (I have sent the address a few times but contact me
if you need it) to answer questions and go over material.
We are going to continue with Access this week. I am putting up a group project, I will send you information about your group early this week
(it has been sent). If you are struggling with the assignment from last week you may find working with others on the group project is helpful.I can set up a help session this week if that would help! 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. I do not want you to divide up the questions, I want everyone contributing their thoughts on each problem. You have two weeks to do this. 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 Be sure to CHECK BACK and see how things are going! |
| Week #3 Week of September 15th |
INFORMATION: Looks like I am free Wednesday, Sept 17th from 11 to 1 so I can be available to answer questions and go over material. Let me know if you would like to come for help or to answer questions.This week we will start to look at databases and specifically we will work with Microsoft Access which is part of Office 365. Please look up a definition of a database and specifically one using Access. Here are some suggestions: What is a database Intro to databases What is Access Access can be downloaded through apporto (what we used last week to upload your pages to the web.) It is one of the possibilities under software. 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 Bristol serverExample I used in video my server TOPIC VIDEOS: Using Access in Apporto Note that downloading the word document puts it in the Downloads unless you have made changes to your system.Using Access - this is an old version using horizon instead of apparto computer 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 Please note that 17 really is not greater than 17 - woops More Access Queries (youtube version) The easiest approach, I think is downloading Access within Microsoft Office 365 and having Access on your machine. So there are two approaches... Downloading Access to your system or using Access in Apporto. 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 NOTES: Notes on getting to Access using apporto.
I should also add that gathering the infomation to send me pictures of the Access screens using apporto you should also open word and then you will find information at Insert/Screenshot/Tell me more. If you prefer to download and install you can log into Bristol and bring up Microsoft 365 apps and click on it. At the top right you will see Install apps and you want to click on that. From there you click on Microsoft 365 apps. That will lead you to the Install Office and Access is part of that. ASSIGNMENTS TO DO: This is a database assignment (it is due on Sept 25th) Access Database Assignment on BCC College Resources This assignment must be done with the Access user interface covered in the notes and examples. It should not be done with SQL - next weeks assignment will deal with SQL. It is acceptable to leave some data blank and makeup some data, but you should find some data on your own as well.There have been questions about the plan to use code in the past. 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. Feel free to make up data and leave some fields blank.The goal here is mostly testing the Access so look at the queries and see what fields are tested and therefore needed and try to make a pattern that works. Alternative: Instead of pasting on a document, you may send me the database you created as an attachment. It will look like there is a problem, but I can work around it usually when I receive it. CHECK BACK! |
| Week #2 Week of September 8th |
INFORMATION: Continue working on the web page. I will be loading the information you need to put it up on the web.TOPIC VIDEOS: Loading up your page has some complications, so I want you to spend some time looking at the video notes.Upload html page to cisweb Another on uploading using WinSCP Note that I need to be in the virtual machine to connect to cisweb via winscp and apporto gets me into the virtual machine Finally when you have it uploaded onto cisweb, you need to figure out the address to give to others to see the file or files you upload. There is a very short video on that. See page in browser If you get confused (I did too!) I want you to have time to work with me or the tutoring center. If you wanted to do more with WinSCP you should look at the notes I left under Older Notes on WinSCP and cisweb. OLDER NOTES ON WINSCP AND CISWEB: Before we started using Horizon. These are notes about some of the things you can do when you are connected to 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. Remember the host is cisweb.bristolcc.edu and the port is 220. ASSIGNMENTS TO DO: Assignment: Upload your web page(s) and images introducing yourself to the cisweb server and send me the address.Don't forget that you need to upload all the pages if you have more than one and all the images you used. I waited to give you a little more time to do your pages so the pages loaded online/on the internet assignment is not due until Sunday (Sept 21) and the basic pages from assignment one are still due on September 11th. Other work will be assigned in week #3 so I suggest you get the pages online on the web as soon as you can. Quiz #1: Quick Quiz that is due next Thursday (Sept 18th). There is a penalty for late quizzes. Check back! |
| Week #1 Week of September 1st |
INFORMATION: Lots of information this week!Intro to Fall 2025 CIS120 Intro to Spring 2025 CIS120 Intro to Fall 2024 CIS120 Intro to Spring 2024 CIS120 Intro recording from 9/4/2024 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 at your Bristol email acount. Please be sure to check for it. We will use it 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: 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 Another 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 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 Thursday, September 11th. I would try to get it in sooner because their will be a couple of assignments the second week of classes. Your assignment for this week: HTML pages to introduce yourself (needs to include CSS and two pages linked together) 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. The HTML code needs to be code you write, you should not use a tool that generates code. Even if in the real world you decide to generate code, you need a basic understanding of how it works and you get that by writing your own code. If you use extra HTML that you research and use to create the page you need to explain the commands for extra credit. Note: You do not need to put your web page(s) on line the first week. We will do that in the future. |