|Schedule by week||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.
Work must be submitted by the Thursday after it is assigned.
Note that the audio and Smartboard presentations for each class are available from previous semesters.
Week of December 14th
|This Tuesday will be an open lab instead of classes in K101 from 9:30 to 3:30.
Your final and status sheet is due on Thursday, December 17th at 10:30AM. It must be turned in by the 10:30AM deadline or points will be subtracted.
I am posting your final and the required status sheet - I only correct the final if I also get the status sheet.
If you would like feedback on the status sheet, you can send it in prior to the final.
Required status sheet
Final Exam Note that with #1 you are using an Access database. Woops - for some reason I labeled three problems as 7 - so guess they are first 7, second 7 and third 7.
Week of December 7th
|This week there will be an open lab instead of classes. The labs will run on Tues and Thurs from 9:30 until 3:30
and you can come when you can and stay as long as you can. Carolyn and I will be there.
Your exam will be posted prior to the lab on Thursday the 10th. It is an open notes, open book, no help from other people exam and you will have one week to do it. The exam is due at 10:30 on Thursday the 17th and should be emailed to me prior to the due date and time. Late points will be taken!
Week of November 30th
|I will be available Monday at 10 in my office. Carolyn will be available 2-3:30 on Tues and 2-4 on Thursday and I will
be available at least some of that time. Don't forget advisement!
Read chapter #6 and chapter #7 and look at accompanying videos.
We need to finish up looking at I/O in VB and then move on to the last topic which is back to Access.
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.
Donor multiple table database
Soft Skills Paper Due at the end of the semester
Note, I have asked you to do seven soft skills. If you do more you will get extra credit and the amount of extra credit depends on how many extra soft skills you write about. You should cc me on the contact with your mentor. If I do not get the attempt and you do not include information from you mentor, the highest grade you can get is a B.
Makeup/extra credit quick quiz Due Tuesday the 8th
Week of November 23rd
|This week I am available Mon at 10 in my office and Carolyn is available Tues from 9:30 until 3:30.
No new homework assignments.
Week of November 16th
|This week I am available Mon at 10 in my office and Carolyn is available Tues at 2 and Thurs from 2-4 in K101. I will
be there some on Tues and Thurs but advisement is also happening.
Read chapter #5 and look at accompanying videos.
We will continue with Visual Basic this week and Pat McDonough who had Carolyn's job last year is coming in to speak.
Debug we will do in class: Debug the program below and get it working.
Second Visual Basic AssignmentYou have until the December 1st since next Thursday is Thanksgiving.
Quiz #4 QUICK QUIZ DUE by Tuesday, November 24th
Week of November 9th
|This week I am available Mon at 10 in my office and Carolyn is available Tues at 2 and Thurs from 2-4 in K101. I will
be there quite a lot on Thurs and some on Tues.
I hope you can go to the IT Roundtable!
A few people appear not to have received the mentor information. Needless to say, they get an extension.
This week we will start Visual Basic and we will have a guest speaker on Thursday from Meditech.
When you write the program, the solutions will be stored in a folder under the name you gave the project. You need to zip this up to send to me. Some browers do not send zipped files with executables in them so you may encounter a problem. A work around is after you zip it up, change the .zip extention to something like .jpg before you send it and tell me you did it in the email. I will then change it back to zip when I save it and everything will hopefully work. Check back!
Week of November 2nd
|Monday I am available at 10 in my office and Tues (2-3) and Thurs (2-4) Carolyn will run labs and I will drop in.
STEM events that start November 2nd: Interesting workshops through STEM
Test for upper case
You should have read through chapter #4, so if you haven't, please do!
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
Numbering systems and codes: To receive full credit, I need to receive your work. Send me the answers via email and if possible include an electronic version of the work - you can take a picture of your work and send that. If you cannot figure out a way to send it electronically, we can talk.
Numbering systems and codes assignment
On the last problem, you only need to give the characters for the top four lines.
EXTRA CREDIT ALICE ASSIGNMENT: There are examples called balls bounce that do the things that need to be done in this assignment and there are also PowerPoints that explains Alice as well. Alice can be downloaded for free from www.alice.org - please get version 2 and not version 3.
ballsbounce examples zipped
I want you to write a program using the following: objects, methods, a loop and a loop with the complicated feature, a while loop, an if/else and an if/else with an embedded if/else. I want you to do a startup/housekeeping/initialize method, a process method that handles other methods associated with objects that you write and a wrapup method all run from world.my first method. Look at my examples (zipped copies of the programs), PowerPoints on ballsbounce and Smartboard/audio from classes to help with this assignment! Partial extra credit if you get the basic parts of this done correctly.
Week of October 26th
|Monday I hope to be in my office at 10:30 I have an early meeting that may run late. Tues Carolyn will be
available for help in K101 at 2 and I will try to join her. On Thursday we will have an open lab from 9:30
to 3 in K101. I will not be there but Carolyn will be there to help.
Please read chapter 4 in the textbook and look at the accompanying videos.
I also want the logic that you used to develop the program - pseudocode or flowchart.
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. 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. 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 Thursday, November 12th 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). If you are too far behind on work and you need to send me a lot of work, I am not sending 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 weekend and you do not think you are that far behind, be sure to contact me. I may have missed sending it some how or it might not have gotten through.
Week of October 19th
|I am available Monday at 10 in K112. Carolyn is available Tues from 2-3 and Thurs from 2-4 in K101 and I will
drop in when I can.
October 29th will be an open lab day in K101 from 9:30 to 3. Carolyn will be here to help. You can come for as much of this time as you want. If you do not need help, then you have the day off. I am taking a personal day so I will not be present.
November 10th we are having a discussion with IT professionals at 5:00. The participants at the round table will be people who started their own IT company as well as people who work in the field. If you attend and give me a short write-up, you can get extra credit.
QUIZ - since I was late posting the quiz it will not be due until next Tuesday, October 27th at midnight: Quiz #3
Week of October 12th
|Carolyn is available Tuesday and Thursday from 2 - 4 in K101. As usual I will try to come as much as I can.
Tour of Lockheed Martin arranged as a STEM initiative
Extra credit: On #4, where you calculate the grade, if you show the letter grade as well as the numeric grade.
Week of October 5th
|I will be available for help Monday at 10:00 in my office, Carolyn will be available Tuesday at 2 in K101 and Thursday at 2 in K101.
Thursday she is available until 4. I will be back and forth on Tues and Thurs.
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)
If you did not read chapter #3, please read it.
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.
Logic PowerPoint assignment
Flowchart and Pseudocode assignment This is a quiz - however it is not due until next Thursday (October 15th) 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.
Week of September 28th
|Carolyn will be available Tues 2 - 3 and Thurs 2 - 4, I will come and go. I have an office hours Mon at 10
in my office.
Next I want you to move on and read chapter #3 and look at those videos as well. Please work on relating what we are doing in class to the textbook.
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.
Please listen to this video and read this handout about note taking.
Note taking video
Cornell method of note taking is the specific one to read. I also suggest checking out the other links on this page.
This is not assignment even though it says it is. We are going to do it in class. For online students you should definitely take the time to go over this because it deals with flowcharts and Access.
Access SQL project (document version)
Books database with SQL version
SQL code (document version)This is a copy of the SQL code in case it gets messed up
We will start looking at logic and will work on the practice exercise below.
Presentation on using pseudocode to play computer
Separate speaker notes to accompany presentation on using pseudocode to play computer
Quiz #2Usually quizzes are due in 3 days but since I am going away this weekend we will make the due date October 5th. If you have questions, let me know.
Week of September 21st
|Help: Carolyn will be available Tues at 2 and Thurs at 2 until 4 in K101. I will be joining her when I can.
If you need help with something, now would be the time to ask your questions!
Read chapter #1 in the text book. Be sure to watch the videos that go with the chapter (note there are 5 with a time of about 4 minutes each or less). You can download the videos from Cengage Chapter 1 videos
Directions for downloading Access are located under Notes and Handouts.
Next I want you to move on and read chapter #2 and look at those videos as well.
Check back to see what we are doing on Thursday.
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 mail you an email with your group and group leader. 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 (Access2013, 2010 or 2007)
Soft skills database 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.
Access Assignment: This assignment is for all students, it is not a group assignment. Database assignment
Week of September 14th
|Next 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.
We will start looking at Microsoft Access 2013 next week. If you would like a copy for your computer you can use the DreamSpark login information that was sent to you and download Access 2013. Specifics about downloading using DreamSpark are at DreamSpark notes
You could instead choose to download Microsoft Access 2013 from Office 365.
Access 2013 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:
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. Please note that we now prefer cisweb.bristolcc.edu instead of cisweb.bristol.mass.edu.
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.
Our next topic will deal with databases, and specifically we will use Access 2013: so be sure to download it if you want a copy at home. Otherwise, you are welcome to use our labs.
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
Note I am also linking to an Access2010 example that works fine under Access 2013.
Sample Access 2010 database Note there is an accompanying Presentation explaining this database under presentations
Access 2010 example explanation - database is under examples
The databases we created in class last year:
Created in 11:00 class (student.accdb)
Created in 12:30 class (studb.accdb)
Several things to do this week so please check back:
First: Upload your web page introducing yourself to the cisweb server and send me the address.
Second: 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 September 24th.
Third: 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.
I am attaching a list of the resources that I found that you can use in preparing your database.
College Resources - some things to help as you put data in the database Note that I did not find something for all fields - it is acceptable to leave some data blank but you should find some data on your own as well.
Note: Assignments are not due until the week after they are assigned. You are welcome to pass them in early.
Week of September 7th
|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 schedule with a CIS faculty member. You can talk to me about the best person to see.
Please read chapter #1 in Programming Logic and Design. If you can't get the book, next week is fine. The first topics do not rely on the book. We will start to look at the material in the text next week.
You will be getting an invitation to Dreamspark in the next few days (or you may have already received it) that will allow you to download the Microsoft software you will use in tis class.
You should also receive login information for cisweb which is the server you can upload web pages to.
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. We will start to look at them on Thursday and will look at the remaining ones next Tuesday.
These are the pages you need to go over and understand (They will be covered this week):
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. We will probably not look at CSS (Cascading Style Sheets) with HTML until Thursday.
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.
Cascading Style Sheets:
This weeks assignments are due by Thursday, September 17th at midnight. All assignments must be turned in using the email addresses that I sent you.
Note: Usually assignments are due the week after they are assigned. Specifically, they are due the Thursday of the next week which gives you a week to do them no matter when during the week I assign them.
You are welcome to pass them in early. Late assignments will loose points in the 10% responsibility category. 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:
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 we are discussing in class 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.
This assignment is due by Thursday, September 17th at midnight.
Email me if you have questions!