| 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 online students or students who missed a class to use under Audio and Smartboard. |
|---|---|
| Week #12 Week of April 15th |
I will be around Tuesday and Thursday when I do not have advisement at 2ish. Lindsey is available Thursday 2-6. Dave will be available 4:00 - 7:00
on Tues and Wed and 10:30 -2:30 on Saturday. Jayson (from the tutoring center) is
available 9-12 Tues in New Bedford. We will 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 in class. 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. Donation database we will work on in class. |
| Week #11 Week of April 8th |
I am available at 10 in K112. I will be around Tuesday after class. Lindsey is available 2-4 on Monday and Thursday 2-6. Dave will be available 4:00 - 7:00
on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is
available 9-12 on Mon and Tues in New Bedford. On Tuesday a group of CIS graduates who are working in IT will come to class to talk about their work and answer questions. The last day for student withdrawal is April 11th. Let me know if you have questions. Assignments: Visual Basic Assignment #2 Check back! |
| Week #10 Week of April 1st |
I am available at 10 in K112. I will be around Tuesday after class. Lindsey is available 2-4 on Monday and Thursday 2-6. Dave will be available 4:00 - 7:00
on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is
available 9-12 on Mon and Tues in New Bedford. We will start Visual Basic this week. Download Visual Studio (scroll down a little for the 2017 version which is what we have in class) from Microsoft Use Community edition Assignments: Visual Basic Assignment #1: I want you to redo the first JavaScript assignment but this time write the programs using Visual Basic. When you have written all the programs, zip the folder for each one of them up and attach them to the email you send. Alternatively you can zip them up and put them on cisweb and send me the address to download each program. Career and mentor paper: The mentors are professionals who went through the CIS program at BCC 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. 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. This should include softskills. 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 by the end of April (earlier would be appreciated). 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 might 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 do not think you are that far behind, be sure to contact me. Check back! |
| Week #9 Week of March 25th |
I am available at 10 in K112. I will be around Tuesday after class. Lindsey is available 2-4 on Monday and Thursday 2-6. Dave will be available 4:00 - 7:00
on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is
available 9-12 on Mon and Tues in New Bedford. We will continue with numbering systems and codes. Assignments: ASCII assignment Check back! |
| Week #8 Week of March 18th |
Thursday is an open lab day from 9:30 or 10:00 until 6 in K101. Come for as many hours as you can and work to get caught
up with Lindsey or myself to answer questions. I am available at 10 on Monday in my office K112 and Tues at 2:00 in K101/K112. Lindsey is available 2-4 on Monday and 10-12:30 and 2-6 on Thursday. Dave will be available Tues and Wed from 4-7 and on Saturday from 10:30 to 1:00. Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford. Readings that will cover the information on if and loops. Decisions Decision making in JavaScipt IF at W3Schools Loops Looping in JavaScript Guess Game Logic Solution to practice exercises: While solution to problem #1 Do...while solution to problem #1 While solution to problem #2 Do...while solution to problem #2 Be sure you look at the guess game examples, they will help with taking in user input in a loop and with establishing a random number. Debug tool in Firefox On Tuesday we will wrap up JavaScript and then we will 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: Third Quick Quiz due on 3/28/19/ If you do not have the book, read the reading articles I recommended and review my Smartboard and audio Number Conversion Check back |
| Vacation Week of March 11th |
Dave is available for help on Tues and Wed from 4-7 and Sat from 10:30 to 2:30. He will
probably be in K101 or K118 but if not, the help desk will know where he is. |
| Week #7 Week of March 4th |
I am sick on 3/5/19. I would plan to come to class on work on your JavaScript assignment with someone
there to ask (Lindsey will be there during class time). Lindsey is available 2-4 on Monday and Thursday 2-6. Dave will be available 4:30 - 7:30
on Tues and Wed and 10:30 -2:30 on Saturday. I will be available at 2 on Tuesday (but double check). Jayson (from the tutoring center) is
available 9-12 on Mon and Tues in New Bedford. Please read chapter #4 if you have the book. It is extra material on logic and flowcharts. We will continue with JavaScript and embedded logic this week. Check back for an assignment after I see how far we get in JavaScript.. Assignments: Second Quick Quiz Second JavaScript assignment Please pass in the logic flowchart or pseudocode as well. |
| Week #6 Week of February 25th |
I am available at 10 on Monday in my office K112 and on Tues and Thurs at 2 in either K101 or K112.. Lindsey is available 2-4 on Monday
and 2-6 on Thursday. Dave will try to be available on Saturday from 10:30 to 2:30 on Saturday (he has some family health problems). Jayson
(from the tutoring center) is available 9-12 on Mon and Tues in New Bedford. We will continue with logic and concepts this week and introduce JavaScript. 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 I will add a few more. Actually I think everyone should read them. Basic video Assignments: Flowchart and Pseudocode assignment This is a quiz - however it is not due until next Thursday (March 7th) when homework is due - you need to work on it individually because it is a quiz (that also means no resubmit). This quiz also counts more than the quick quizzes - guess I should have called it a test. It counts like a high-end homework. I will accept it late, but late points will be subtracted. Extra Credit: The JavaScript example mathans.html checks for *. In class, we modified it to check for * and to check for /. For extra credit you can modify it to check for * or / or + or -. To get the extra credit it must be passed in before the start of class on February 28th. First JavaScript Assignment Check back! |
| Week #5 Week of February 18th |
I am available at 2 on Tues and Thurs. Lindsey is available 2-4 on Wednesday (Monday classes) and 2-6 on Thursday. Dave is available
4-7 on Tues and Wed and 10:30 to 2:30 on Saturday. Jayson (from the tutoring center) is available 9-12 on Mon and Tues in New Bedford. We will continue with logic and concepts this week. For help on if statements, look at this presentation: Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Assignments: 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. Check back! |
| Week #4 Week of February 11th |
I am available at 10 on Monday and 2 on Tues and Thurs. Lindsey is available 2-4 on Monday and 2-6 on Thursday. Dave is available
4-7 on Tues and Wed and 10:30 to 2:30 on Saturday. Jayson (from the tutoring center) is available 9-12 on Mon and Tues
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 We went over SQL last week. Here are some examples you may find helpful: Some SQL examples Let me know if you find a typo. 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. Practice exercise: Practice exercise Practice continued 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 Check back! |
| Week #3 Week of February 4th |
I will be available Monday at 10 in my office K112 and Tuesday at 2 in K101.
Lindsey will be available 0n Monday from 2-4 and Thursday from 2-6, Dave is available Tues and Wed from 4-7 and Sat from 10:30 to
2:30. There is a lot of support
and you should definitely use it if you have questions or encounter a problem. We are hear to help you succeed! Please take
advantage of that. To repeat: If you need help with something, now would be the time to ask your questions! Directions for downloading Access are located under Notes and Handouts. Using Office 365 to download the suite is probably the easiest approach. 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) Introduction to SQL W3Schools on SQL On Thursday we will look at SQL in Access. Examples of Access queries done in class: Query examples from 11:00 class Query examples from 12:30 class Assignments: For students in class on Tuesday, 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 email you with your group and group leader (probably Wednesday(. You can then communicate via email (I am waiting to see who is in class before assigning the web groups). I am sending out group assignments (students who have not passed in work are not assigned to a group until I have started receiving assignments). 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) If you do not receive a group assignment, get back to me. Database assignment to query with SQL: We will talk about SQL in class on Thursday, so I strongly suggest you do not start this assignment until we have gone over 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 Check back! |
| Week #2 Week of January 28th |
I will be available for help Monday at 10:30. At 2:00 Tuesday and Thursday there will be a help lab in K101 (we hope -
may have to find a different room) with either me or Lindsey (my SI and tutor). Lindsey will also be available 2 -4 on Monday in
K101 and on Thursday from 2 - 6 (I need to check the room). Dave will be available from 4 to 7 on Wed and Saturday from 10:30
until 2:30 in K101. Room numbers are not definite, the help lab will know where Lindsey and Dave are. 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 will not have that close a deadline - you need to pass it in by February 7th. Note that I do not accept late quizzes Assignment #3: 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. Check back! |
| Week #1 Week of January 21 |
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 Tuesday and Thursday this week. Each week I will post my availability at the beginning of the Week of posting. If you are just starting as a CIS major, I recommend that you double check your spring schedule with me. 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. Zipped version of Introduction to HTML 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 31st. 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. The due date on this assignment was extended until Feb 2nd Email me if you have questions! |