| 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 tape all my classes and capture notes on the Smartboard in the spring and fall. The recordings (audio) and the Smartboard are available for summer students to use under Audio and Smartboard. |
|---|---|
| HELP schedule | To contact Joe use moocowoftech@gmail.com. He will be available from 9-2 on Mon thru Fri for open labs at this address:
Collaborate For hours outside of that he will be using Microsoft Teams which is available to you through Office 365. Send him an email from your bcc account with the classes you want to connect to and you will get a link to join. Here is a brief run down on how it works and what to expect: Microsoft Teams overview There is access to WiFi from your car under the solar canopies on the Fall River Campus. An ex-student/SI, David Bourgeois has volunteered to help students with questions in the evening. You can contact him at dbourgeois14@bristolcc.edu |
| Final | Final Exam Due May 14, 2020 This is an open notes/open book final. The only person you should ask questions of is me. The final will take more than 2 hours so you should plan accordingly. Essentially you will have to do research, look up answers and problem solve during the week you are taking the final as opposed to studying for the final and then taking it. The status sheet posted below is a requirement. I do not correct finals unless I have a status sheet. The status sheet is my way of making sure that your records match with my records. If I do not have something you say you passed in and it will effect your grade, I will contact you. I am running out of correcting time so I suspect that the ASCII assignment may end up being a check off assignment. We will see! |
| Week #14/#15 Week of April 27th/May 4th |
Catch up weeks! Makeup/Extra Credit Quiz I will be posting information about the final, so check back. You will have one week to do the final. Required status sheet I do not correct the final unless I get a status sheet as well |
| Week #13 Week of April 20th |
You should review HTML briefly and start to look at Access database with multiple tables. We will look at relational databases and implementation in Access. Normalization (3rd normal form) Student 4 table database Student 4 table data needed We will work on this database. Here are some notes to help you (remember there is an 11 section and a 12:30 section, I would look at both and listen to one) Databases (10/31/19 11:00) Accompanying audio Databases (10/31/19 12:30) Accompanying audio Databases (10/31/19 11:00) Accompanying Smartboard presentation Databases (10/31/19 12:30) Accompanying Smartboard presentation Assignments: Donation database you need to do |
| Week #12 Week of April 13th |
Continue working on Visual Basic. If you need help with something, let me know. Alumni talks to previous classes. I am not doing the mentor emails this semester because everyone is so overwhelmed. If you would like to talk to a mentor some time in the future, let me know and I will try to set it up. I want you to listen to several of these alumni discussions that happened in class. Note that in the fall, I have two classes of CIS120 so I would pick different dates. Alum talk at 11 on Nov 5, 2019 Alum talk at 12:30 on Nov 5, 2019 Alum talk at 11 on April 9, 2019 Alum talk at 11 on November 27, 2018 Alum talk at 12:30 on November 27,2 018 Alum talk at 11 on April 12, 2018 Assignments: Career Paper: As you listen to the alum talk about their jobs, I want you to note what they say about working in computing. Then I want you to research a job you think you would like in computing. Combine and site from these sources and write a paper about working in this field. Include information about what the job involves and the skills that that are needed. I would also like you to include the soft skills that are important. Check back! |
| Week #11 Week of April 6th |
I hope you are asking questions of Joe during his help sessions - see above. We will continue with Visual Basic this week. Please look at all my examples and look at the Smartboard and listen to the audio from when I went over these in a previous semester. Intro Visual Basic (11/12/19 11:00) Accompanying audio Intro Visual Basic (11/12/19 12:30) Accompanying audio More Visual Basic (11/14/19 11:00) Accompanying audio More Visual Basic (11/14/19 12:30) Accompanying audio And more Visual Basic (11/19/19 11:00) Accompanying audio And more Visual Basic (11/19/19 12:30) Accompanying audio Intro Visual Basic (11/12/19 11:00) Accompanying Smartboard presentation Intro Visual Basic (11/12/19 12:30) Accompanying Smartboard presentation More Visual Basic (11/14/19 11:00) Accompanying Smartboard presentation More Visual Basic (11/14/19 12:30) Accompanying Smartboard presentation And more Visual Basic (11/19/19 11:00) Accompanying Smartboard presentation And more Visual Basic (11/19/19 12:30) Accompanying Smartboard presentation Repeat of getting started with VB: Audio/video of starting a VB problem Here is a PowerPoint about Arrays in Visual Basic and JavaScript and then the same presentation with audio: VB arrays VB arrays (audio/video) Assignments: Second Visual Basic assignment Please check back! |
| Week #10 Week of March 30th |
I will give extra credit to anyone who goes to the Collaborate site (see link in HELP above) and either works with Joe on something
they need help with or shows him something they have done for the course. Send me an email and let me know what you did. Actually this
applies to doing something with Joe using Teams app as well. This week we are going to start with Visual Basic. I am giving you the link to download a free copy. We had VB 2019 installed at the college but 2015, 2017 would be fine and even earlier if that meets your needs. If you have problems with being able to download and install for your use, we need to talk about alternatives. Download Visual Studio from Microsoft Use Community edition. Here are Powerpoints about getting started with Visual Basic in Visual Studio. You should also listen to the audio and look at the Smartboard presentation for a previous semester where these topics are discussed. Intro Visual Basic (11/12/19 11:00) Accompanying audio Intro Visual Basic (11/12/19 12:30) Accompanying audio Intro Visual Basic (11/12/19 11:00) Accompanying Smartboard presentation Intro Visual Basic (11/12/19 12:30) Accompanying Smartboard presentation There are a set of zipped Visual Basic programs that you should download, unzip and try running in VB. This week we are looking at the things up through ifs. I have discussed several in the VB calc, if, variables Powerpoints. Starting Visual Basic Audio/video of starting a VB problem Existing Visual Basic VB calc, if, variables Assignments: The first Visual Basic assignment is to do the first JavaScript assignment but this time it should be done using Visual Basic. When you pass in a Visual Basic assignment, you need to zip up the folder containing everything you and VB created and send me the zipped file. The first JavaScript assignment was under week 6. If you have problems, let Joe or I know. Check back! |
| Week #9 Week of March 23rd |
Officially there are no classes and no assignments this week. However, I decided to post this weeks work anyway so you can get
started on it if you choose to. I feel that choosing to do the work this week will spread the work out better and make the end of
the semester easier no matter how it is handled. I will keep putting out the work for each week as originally planned to give you
more flexibility. Late points will not be taken. Again, it is your choice whether you do the work this week or leave it for next week. ASCII notes ASCII and portfolio (10/29/19 11:00) Accompanying audio ASCII and portfolio (10/29/19 12:30) 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 Smartboard presentation Assignments: 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 BCC 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 assignment is due by the end of April. ASCII assignment Check back! |
| Week #8 Week of March 9th |
I will not be on campus Thursday, March 12th - the material for the class will be online. The group
advising session is also cancelled, we will reschedule if possible. Please read chapter #4 and #5 if you have the book. If not be sure to do some reading about logic flowcharts and pseudocode. This week we are going to take a break from programming and look at numbering systems. 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 in class and look at the link below. Reference for ASCII Assignments: Number conversions You must pass in the work to get a grade higher than C on this assignment Check back! |
| Week #7 Week of March 2nd |
We will continue with JavaScript this week. We will work through the JavaScript we started last week. It is located at: JavaScript Examples Check back! Assignments: Assignment #1: Second JavaScript Assignment Assignment #2: Write a version of the Rock, Paper, Scissors game in JavaScript. You should include a question to the user about playing again. Note that if you use code that was not covered in class, you need to include an explanation of the code and what it does. |
| Week #6 Week of February 24th |
I will not be on campus Thursday, February 27th. It is an online day. Joe will be available for help during class time. Check back! We will continue with the logic shown in last weeks writeup. We will go over the presentations on if statements and loops. The plan is to also look at JavaScript and we did. We started looking at the if statement. The JavaScript is under programs. If you have the book I suggest reading chapters #2 and #3. If you do not have the book continue with the articles I suggested in week 4 and throughout the course. Actually I think everyone should read the articles. Basic video Assignments: 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 5th. First Java Script If you are having any doubts or questions about JavaScript, I strongly urge you to come to class Thursday where you can get questions answered by Joe. |
| Week #5 Week of February 17th |
We will continue with logic and concepts this week. Practice exercise: Practice exercise Practice continued Be sure to look at the solutions to the practice and I also recommend listening to the accompanying audio. Presentation on using pseudocode to play computer Separate speaker notes to accompany presentation on using pseudocode to play computer For help on if statements, look at this presentation: Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Please look at this PowerPoint on loops and repetition: Presentation on structure (focus on loops) Separate speaker notes to accompany presentation structure (focus on loops) Assignments: Logic Assignment In class logic exercise - if you were not in class (proved by signing the list) you need to do this check off assignment and send it to me. Follow the logic flowchart and process the input, then tell me the output. Show the answers for the first four and then you can just show the messages. Note if you were in class to do it you can check the assignment off as done. Logic PowerPoint assignment Play computer and determine the output. I will do more with loops next week, so you can have a little extra time on this if you need it. Check back! |
| Week #4 Week of February 10th |
My husband is in the hospital recoverying from open heart surgery. I will not be on campus so the information and
assignments will be at my web site - an online week. 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. I strongly recommend setting up study groups that can meet when help is available. This is Enrollment Verification week and I have to verify you are in the class. If you have not passed in work or the email a week verifying you are in the class, then you need to contact me now to make sure you are not withdrawn from the class. Reading - there is not a required text but there is reading that will add to your knowledge base and that is required: 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. Compiler definition Compiler vs interpreter Types of software Memory and RAM Programming Process Examples: Pseudocode and Flowcharts 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: Database assignment to query with SQL: I strongly recommend that you listen to my audio and look at the Smartboard from last semester to be sure you have learned the material you need to do the assignment. 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 When I talkabout "Microsoft fixed", I am talking about the excessive about of parenthesis that get added. I want you to write your code using needed parenthesis but not the excessive number that makes the query hard to understand. Check back! |
| Week #3 Week of February 3rd |
My husband is having emergency surgery this week so I will not be in for class on Tuesday and Thursday. Joe will be there on
Thursday to facilitate an inclass group exercise. For students in class on Thursday, you will break up in groups of 3 and choose a leader who will be responsible for mailing me your answers with a cc to you so you know that it came through. Note, there is no makeup/resubmit on group projects. Note students taking the class online can choose to come and participate in the group project in class even if we can't find you a seat. For students who are not in class (online or absent students), I will contact you. Please note that in the groups everyone should work on all the problems! You are working together as a group! Note: On the flowcharts in the assignment, sometimes the word Technology is cut off and you see Course instead of Course Technology. Group DB assignment Group DB assignment (html version) Answer sheet for group project Book Database to use in answering questions (Access2016, 2013) I have decided to make this a check off assignment. If you were not in class for the group assignment last Thursday or if you are an online student, you should do it on your own and submit it. Joe Fletcher is available for help if you encounter probems - check the help session above and look for him in K101 for the 11:00 class and the 12:30 class. 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) I strongly recommend that you look at the Smartboard notes and listen to the audio from last semester. Look under Smartboard and audio for the information dated 9/12/19. There was an 11:00 class and a 12:30 class. You can use one or both. Note that we will not start the SQL part until next week. On Thursday, we started a database that was named Database21.accdb. I could have/should have given it a more meaningful name. I added some queries to that database and wrote up an explanation of those queries. Database21.accdb ExplainDatabase21accdb.docx Check back! Assignments: Assignment #1: Access Database Assignment on BCC College ResourcesThis assignment must be done with the user interface we have looked at in class, 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. Assignment #2: Group assignment which should be done individually if you were not in class to do it with a group. It is a check off assignment. |
| Week #2 Week of January 27th |
See the help hours above. This week we will look at uploading a web page to our cisweb. Please bring your user name and password for working with cisweb to class on Tuesday. The information was sent to you at your bcc email. More about soft skills - please read We will also start looking at Microsoft Access 2016 this week. If you would like a copy for your computer you could choose to download Microsoft Access 2016 from Office 365. Access 2016 using Office 365 Please do not change any of the passwords we have given you. I need to be able to get to your site as does the IT staff if there is a problem. Several of you have asked about words for different colors. Here is a link: Color Names Uploading to the Web: In my notes I talk about cisweb.bristol.mass.edu. Things have changed and you should now use cisweb.bristolcc.edu. you need to also change the port to 220. We will look at login to cisweb this week so check the notes on the Smartboard and the accompanying audio as well as the notes below. 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, we are now using cisweb.bristolcc.edu as the host although the old one is still supported). 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 Again, please remember to change the port to 220. Access2013 example and explanation: Sample Access 2013 database Note there is an accompanying Smartboard explaining this database under presentations Access 2013 example explanation - database is under examples Other examples are at my site under Examples and under presentations. 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) If you did not create the database and table during class on Tuesday, 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 Presentation going over first few HTML examples I created it to send to some students who were having trouble with HTML Assignments: Note: Assignments are not due until the week after they are assigned. You are welcome to pass them in early. Assignment #1: Upload your web page introducing yourself to the cisweb server and send me the address. Extra credit if you experiment with linking and try links that involve subfolders going back and forth and a link to an outside page. Assignment #2: Quick Quiz #1 (Quizzes are usually three day quizzes that are due three days after they are posted.) This quiz is due in a week so it is due February 4th. Note that I do not accept late quizzes Check back, there may be an Access assignment added. |
| Week #1 Week of January 20th |
Lots of information this week! Each week, I will post information prior to the start of the Tuesday class. Please check back several times during the week because I may add information and/or assignments as the week progresses. I am setting up extra labs where students can come for questions and help - the schedule is not available yet but I will be available in my office (K-112) around 2:00 on Thursday this week. 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 will be getting invitations and login information in the next few weeks at your BCC email acount. Please be sure to check for them. After each class (usually that night or the next day), I post the Smartboard notes and the audio of the class. If you were not in class or have questions, please look at the Smartboard notes and listen to the accompanying audio. I leave up the Smartboard Notes and audio lectures from previous semesters since much of the material is the similar. You should look up Smartboard presentations on topics that you want to go over. I record most of the classes where I deliver a lecture so you should always assume that the class is being recorded. If you want to know, just ask! I then post the audio and the Smartboard notes so you can follow and/or review what happened in class. We will start looking at HTML/HTML5 to develop a web page this week. Please look at the samples under Examples. These are the pages you need to go over and understand: HTML5intro.html HTML5list.html HTML5linkpage.html HTML5CSSlist.html HTML5headers.html HTML5CSSheaders.html HTML5CSSimage.html HTML5centeredimage.html HTML5CSStable.html HTML5CSScenteredtable.html HTML5morelinks.html fileInSubHTML5.html There is an HTML presentation that also looks at writing code with HTML. It is under presentations and it is zipped. Note that it does not use examples with the optional DOCTYPE on the first line. A great reference for writing HTML is W3Schools Note that I will not always repeat the address here in the week of - I will just point you to where it can be found. Please note that this class used to be CIS17 and some of the handouts will say CIS17, that is why I refer to the class as CIS120/CIS17. Remember that the CSS (College Success Strategies) skills are embedded in this course. For example time management and learning style readings will help you to write the web page introducing yourself and telling me how you are going to handle your time and use your knowledge about learning styles to be successful in this course. If you complete this course, you do not have to take the College Success Strategies course. For us there are two definitions of CSS - one is the College Success Strategies and one is Cascading Style Sheets. Here are some links where you can find information on HTML and CSS: I frequently search with the word "tutorial" and the subject when I want basic information. HTML: http://www.w3schools.com/html/html_intro.asp http://www.tizag.com/htmlT/ http://www.html.net/tutorials/html/ Cascading Style Sheets: http://www.w3schools.com/css/default.asp/ http://www.tizag.com/cssT/ www.csstutorial.net/ Remember that to see the code you wrote, right click and view source. I used Firefox to make my examples. A member of the last class found this article interesting: Improve your time management Assignments: All assignments must be turned in using the email addresses that I sent you. Assignments are due the Thursday of the week after they are assigned. So assignments for this week are due next Thursday, January 30th. There is also an Assignment Summary (look under Weekly Schedule in the menu on the left). 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. Email me if you have questions! If you need an extra day or two on this, send me an email and let me know. I definitely want it by Saturday. the first of February. |