| 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. For now I will continue with Tues and Thurs at 10AM and Mon and Wed at 1PM if you tell me you would like me to be there. 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 #14 Week of May 2nd |
INFORMATION: I will be around this afternoon and evening (Friday the 6th), most of the time at my Zoom site if you have questions.I have also been asked for help working with VB and I will go over this at 4:00 on Saturday the 7th on Zoom. See yourself in STEM, a guest speech I have been told about on May 5th at 11:00AM. I will be on at 9:00PM on Monday, May 2nd for questions about the final. The status sheet and final are posted under week #13. |
| Week #13 Week of April 25th |
INFORMATION: I will do an online session about Visual Basic on Monday, April 25th at 9PM.I will post information about the final later this week. If you are having problems with VB, you can also access it via the intranet. Contact Milo or me if you want more information. This week you should continue looking at VB and continue last weeks assignment. FINAL: REQUIRED STATUS SHEET I will post the final on Friday, April 29th and you will have one week to do it so it is due on Friday, May 6th. The required status sheet must also be turned in. Note that I only correct finals where the student has turned in the required status sheet. The status sheet is your way of being sure I have all your assignments. If you do not match my records, I will contact you. FINAL EXAM The final is open notes and open book but the only one you can ask questions to is me. Milo is not involved in the final. It is an individual project. I will take homework the following week which is the last week of classes. Homework is due on Wednesday, May 11th but I will take a few assignments through Friday, May 13th. I just do not have the time to correct a lot of assignments passed in on Friday because my grades are due. EXAMPLES TO LOOK AT: We are continuing with the Visual Basic examples using the same address we used last week.Visual Basic Programs to download and unzip TOPIC VIDEOS: Input, work areas and loopsArrays - compare JS and VB Write and read files SMARTBOARD AND AUDIO NOTES FROM Fall 2019: And more Visual Basic (11/19/19 11:00) Accompanying audioAnd 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 EXTRA CREDIT ASSIGNMENTS TO DO: CATCH-UP WEEK! Please spend your time doing outstanding homework assignments and extra credit assignments.Makeup/Extra Credit Quiz Extra Credit Visual Basic assignment I really thing it would be great to do the VB extra credit so high extra credit. Speech on Hacking from Thursday, April 28th Passcode is: F^Xd!90y Extra credit if you write a short paper on some things you learned from this speech. Check back! |
| Week #12 Week of April 18th |
INFORMATION: CATCH-UP WEEK - no new work or assignments |
| Week #11 Week of April 11th |
INFORMATION: The CIS Alum round table/panel is being held on Zoom on Tuesday, April 12th at 12 noon. It will last until sometime between 1 and 1:30 but you can leave when you need to.PLEASE try to come for all or part. The discussion about careers that Bristol CI alum have is really interesting and the insite into the jobs out there is valuable. You also have the chance to ask the questions you want to know the answers to and get a variety of perspectives. Recording alum 4/12/22 Passcode: G0YiY?=w Office hours by appointment since I am not getting attendance. Let's plan a time that works! The end is in sight. We are going to look at Visual Basic and that is the last real topic for the semester. We are starting Visual Basic this week. The current version is VB2022. Most of the examples are from previous versions but they work, it is the interface that has changed. The first example goes into version 2022 and there is a video to accompany it. Download Visual Studio from Microsoft Use Community edition. EXAMPLES TO LOOK AT: Visual Basic Programs to download and unzipTOPIC VIDEOS: Make first Visual Basic using version 2022Make first Visual Basic program using previous versions of VB Two introductory Visual Basic programs IF Visual Basic program If where one thing has to be true and either of two others More IF examples in VB SMARTBOARD AND AUDIO NOTES FROM Fall 2019: Intro Visual Basic (11/12/19 11:00) Accompanying audioIntro 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 ASSIGNMENTS TO DO: Visual Basic AssignmentNote, this is the last topic before the final (unless I forgot something). I will post some extra credit assignments as well. We are having problems with sending zipped files with executables inside using Bristol email. So... for now at least send your zipped Visual Basic from your own email (unless it is gmail because gmail has the same problem) to the regular addrss if you can and to p.grocer@rcn.com. If you have gmail, you can try zipping it up and changing the extension to jpg and sending it. When I get it I will change it back to zip to open. Sounds like fun! An alternative approach is to upload the zipped file or files to cisweb and send me the address(es) so I can download it(them). Contact me if you have problems with this!!! Check back! |
| Week #10 Week of April 4th |
INFORMATION: Remember that I am available at 9:00PM Monday night to go over things.Note that there will be a week devoted mainly to catch up before the end of the semester. April 8th is the last day that students can withdraw from their classes. If you are far behind you should do a realistic analysis and decide if you want to withdraw. If you have questions, we can talk!!! You should also talk to financial aid if you have financial aid and you want to be sure you understand the impact of failing and the impact of withdrawing. This week we are going to go back and take another look at databases, but this time we are going to use multiple tables. This is a brief introduction to the concepts so that it will make a little sense when people talk about a relational database and 3rd normal form. There are entire courses on this topic, so again my goal is familiarity. 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 databasesExample 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 doAs always, check back... |
| Week #9 Week of March 28th |
INFORMATION: I will be online at Zoom at 9:00PM Monday, March 28th to go over JavaScript and answer questions. If you are having problems try and attend or setup an alternate time with me. I have this meeting every Monday at 9:00PM.This week I am assigning you a mentor who is an alum from the CIS program at Bristol and is working in the field. This is an opportunity to ask questions and connect. I think it is one of the most important assignments. Check back! ASSIGNMENTS TO DO: 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 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 April 21st 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 be sure to contact me so we can figure out any problems.As always, check back! There will be an assignment on ASCII etc. ASCII assignment ASCII assignment |
| Week #8 Week of March 21st |
INFORMATION: I will be online at Zoom at 9:00PM Monday, March 21st to go over JavaScript and answer questions especially on numbering systems. I recommend you try to attend.Last semester a group of alum spoke (we will do it again this semester). They talked about their jobs and careers. If you are interested, the link information is here: Alum panel Password is egc8Vpz% This week we are going to wrap up JavaScript and we are going to take a little break from learning coding and look at numbering systems. For those of you that bought the optional book, there are a lot of logic examples that you should reference. If you did not get the book some research on logic flowcharts and pseudocode might be helpful. 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 which is not covered and look at the link below. Reference for ASCII You can start looking this week, but the assignment on this will be next week. 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 audioNumbering 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 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. You are playing against the computer which should be a random number. I did a random number example in the guess number program.Portfolio Project to start (must be done using HTML that you write): I want you to start creating an online portfolio. For CIS majors you can work on this throughout your time at Bristol and develop a portfolio to help you when you are looking for a job. For now we are going to do a basic start. You should make a title page with basic information and a link to a second page that should contain a menu with links to a database that you upload, two JavaScript problems you have written and other work for this or another course. You can certainly incorporate your introductory page from week 1. 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 Check back! |
| Break Week of March 14th |
Catch up week! |
| Week #7 Week of March 7th |
INFORMATION: On Monday, March 7th at 9:00PM I will lecture on some JavaScript topics and take questions at my usual Zoom address. If you have other questions we can address those as well. Please let me know if you plan to attend.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 24th because of vacation (actually make that the 25th because the 24th is a no classes day). . 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.Second JavaScript assignment Check back! |
| Week #6 Week of February 28th |
INFORMATION: I will do an introduction to JavaScript which I strongly recommend you attend if you have no experience with programming. I will do it at 9:00 Monday night and I can set up other times if you give me some times that work for you.Women in STEM Panel on Wednesday, March 2 (11AM-12:30PM). You may register here for the event: https://forms.office.com/r/w6ps kiBhH6 This week we are going to continue with logic - I added a Powerpoint presentation about playing computer into last weeks layout. I think it will be helpful with the Logic Assignment. There are also two Powerpoint presentations 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 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 fall. 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: 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 You need to also do either a logic flowchart or pseudocode for each problem. The flowchart can be done on paper and you can take a picture or it can be done using some app. |
| Week #5 Week of February 21st |
INFORMATION: There is a thirty question assignment this week. I will start it in a series of optional Zoom meetings and see how far we get. If you attend the Zoom meetings you only need to do the questions we did not do on Zoom. So when you pass in the assignment, let me know which session you were at if you were at a Zoom meeting. I will do one at 9:00PM on Monday, one at 5:00PM on Tuesday and one at 12:00 noon on Wednesday.Recording from a past year Passcode: U0r=mrK& 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. My office hour at 10 on Thursday is cancelled. 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) PRESENTATION: Presentation on using pseudocode to play computer (This will be helpful for the Logic Assignment.)Separate speaker notes to accompany presentation on using pseudocode to play computer 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. This is the one I will do three times this week in Zoom meetings that you can choose to attend. The problems you do on your own you can just show the messages to cut down on the writing.Another Logic Assignment Check back! |
| Week #4 Week of February 14th |
INFORMATION: I will do a Zoom at 9:00 PM Monday at my Zoom site to go over Access. It is optional but I believe helpful. 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. During my office hours, I am available to go to Zoom if you contact me and arrange a time. If my office hours do not work let me know and we can arrange another meeting. 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: SQL queriesSQL queries (youtube version) Access review put up October 3rd 2020 Access 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 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: First assignment: 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 March 3rdThis 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 Second assignment: 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. 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 #3 Week of February 7th |
INFORMATION: I will do a Zoom at 9:00 PM Monday at my Zoom site to go over Access. It is optional but I believe helpful. The first Zoom meeting is Tuesday, February 8th at 2:00 PM. I sent an email with information about logging in to Zoom for the meeting.During my office hours, I am available on Zoom. If my office hours do not work let me know and we can arrange another meeting. 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 AccessQuick example of using CIS pool to get Access (youtube version) Access review Access review (youtube version) ASSIGNMENTS TO DO: Be sure to look at the Access videos under Week #2.Access Database Assignment on BCC 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 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. |
| Week #2 Week of January 31st |
INFORMATION: After the last big storm, I lost power for over a week, so just in case I am posting next weeks work before the storm.I will go to my Zoom area during office hours this week. This week I will talk about HTML5 and how it works on Monday, January 31st at 1:00PM for anyone who is interested. I will also experiment with some other times, so tell me what works for you and check back. This week I will have you load your page up to the server and then 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 it can be accessed through the CIS pool. 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 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: 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. 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: 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: Upload your web page introducing yourself to the cisweb server and send me the address. Quiz #1: Quick Quiz that is due next Thursday. I DO NOT accept late quizzes. |
| Week #1 Week of January 24th |
INFORMATION: Lots of information this week!Introduction to CIS120 - Spring 2022 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. 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: 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 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 3rd. 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: 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. |