Programming: Logic, Design and Implementation (CIS120/17)

Weekly Schedule

If when I return an assignment you do not get a grade it means that you have to go over the assignment and fix and resubmit. Remember, all assignments including inclass assignments must be done by everyone. There is no makeup on quizzes and tests.

At 1:00 on 12/9/17 my inbox is empty, so if you have not gotten something back then you need to resend it.

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.
Note that the audio and Smartboard presentations for each class are available from previous semesters.
Week #15
Week of December 11th
The plan is for Erik or I to be available Monday 11:00 to 4ish, Tuesday 9:30 to 4ish, Thursday 9:30 to 6. I say 4ish because we are planning to stay until 2 definitely and then 2 to 4 is dependent on people being there for help. So if you need help during the 2-4 be sure to speak to one of us or email one of us.
Your final will be posted on 12/11/2017 and is due by 10:30AM on Tuesday 12/19/2017. It is an open notes, open book exam that I trust you to do alone. Help from anyone but me is not allowed! Note, Erik does not help on final exams!
Final Exam
Status Sheet that must be turned in with or before the final:
Required Status Sheet
Week #14
Week of December 4th
I believe Erik will be available Tuesday 2-3:30 and Thurs 2-6. Remember if he has to change rooms he will tell the help desk. I will be around Tuesday and Thursday around 2 with some advisement going on. Contact me if you need advisement.
This week we will have a few alum come in and talk about careers in IT on Thursday and on Tuesday one will come in and talk about programming JavaScript. Tuesday we will work on the database assignment.
Next week there will be catchup labs on Tuesday and Thursday from 9:30 until around 3 on Tuesday and Thursday.
Note that there were problems with the recordings. I stopped the 11:00 record and then turned it back on and somehow it was held and included with the 12:30 class. And I would suggest looking at both Smartboards. I created the database in the 11:00 class and used it in the 12:30 class. Together they cover a lot related to the homework posted last week. Sorry and good luck!
Extra Credit Quiz: Extra credit/makeup quiz (Worth 10 points)
Status Sheet that must be turned in with or before the final:
Required Status Sheet
Week #13
Week of November 27th
Erik will be available Monday 2-3, Tuesday 2-3:30 and Thurs 2-6. Remember if he has to change rooms he will tell the help desk. I will be around Monday and Tuesday around 2 with some advisement going on. Remember to sign up for advisement.
We will return to looking at databases.
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 We will work on this in class.
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 if any/name of the page. If it is html page then it has a .html extension. The database has a .accdb extension. Check with me if you have problems.
I was sick this weekend, so I am definitely behind!
Check back!
Week #12
Week of November 20th
Erik will be available Monday from 2 to 3 in K101 and Tuesday from 2 to 3:30 in K101 as well. I will be around some but mostly doing advisement. If you have not signed up for advisement, you should.
We will finish looking at the Visual Basic examples hopefully.
Second Visual Basic Assignment
Week #11
Week of November 13th
I will be out on Monday and Tuesday of this week. Erik will be available Monday from 11:30 to 2:30 in K101, Tuesday from 9:30 to 3:30 in K101 and Thursday from 4:00 to 6:00 in K105. These are open labs that anyone can attend.
Download Visual Studio (they are highlighting the 2017 version) from Microsoft Use Community addition
Your Visual Basic assignment is to redo the first JavaScript assignment but write the programs in Visual Basic this time. You need to create a folder for each problem. Then zip up the contents of each folder and send me the zipped Visual Basic programs.
Quiz #4 Due Nov 28th
Week #10
Week of November 6th
Erik is available Tuesday, 2 - 3:30 in K101 and Thurs 2 - 5:30 starting in K101 and moving at some point to K105. I will be around doing advisement etc. Note that next week I will not be in on Monday or Tuesday so we are setting up open lab hours during the times I have classes and beyond. Everyone is invited to attend those labs.
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 30th 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/week and you do not think you are that far behind, be sure to contact me. There are a few that I am delaying a day or two on because I have not heard from a few of my usual mentors. I also may have missed sending some or it might not have gotten through.
Hex/ASCII/Dec assignment
Check back!
Week #9
Week of October 30th
Erik is available Monday 2-3 in K101, Tues 2 - 3:3- in K101 and Thurs 4-6 in K105.
Here is a handout I did on the guess games for CIS122 since the class was cancelled.
Guess Game Logic
If you have the text, you canread chapter #4.
Readings that will cover the information on if and loops.
Decision making in JavaScipt
IF at W3Schools
Looping in JavaScript
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
Apparently there was confusion over my calling two quizzes quiz 3 - sorry - people who got it in on time will get an excr point but I will also take the quiz due on Oct 24th from others up to Tues, Oct 31st.
Write the Rock, Paper, Scissors program/script in JavaScript. You need to use the basic concepts that have been covered. You need to ask the play again question within the script. The user needs to play against a computer generated random number. If you use techniques that were not covered in class, you need to carefully explain how they work.
Binary/Hexadecimal/Decimal assignment
Week #8
Week of October 23rd
Erik is available in K101 Monday 2-3, Tues 2:3:30 and Thurs 4-6 (in K105). I will be in and out.
We will continue with JavaScript this week. Go up to arrays and then do the guess game.
We are going to work on debugging these in class on Thursday. Notice they come up with a white screen because they have problems. If you are not in class please work on them as well.
Debug problem 1
Debug problem 2
Second JavaScript assignment
Week #7
Week of October 16th
I believe Erik will be available Mon at 2 and Tues 2-4 and Thurs from 4:30 to 6:30. I will be in and out during those times.
Next Thursday (October 19th) will be a catch up day. You can come anytime between the 9:30 and 2 hours to K101 and get help or just work to get caught up. There will be no lectures.
I am changing my office hour to Mon at 10 because I have several people who want that time.
Next Thursday (October 19th) will be a catch up day. You can come anytime between the 9:30 and 2 hours to K101 and get help or just work to get caught up. There will be no lectures.
This week we will continue working on JavaScript and looking at the examples. We will look at the examples dealing with loops.
People with the book would find chapters 2 and 3 helpful!
Check sheet you can use to make sure you are caught up. You can send it in filled in and I will tell you if my records differ.
First JavaScript quiz/test You can take longer on this if you need to. Students that get it in on time (Thursday, October 26th) will get extra credit.
Quick Quiz #3 due Tuesday, October 24th
Week #6
Week of October 9th
I believe Erik will be available Tuesday (BCC Monday) 2-4 and Thursday 2-6 (check back on this one). I will be in and out both days.
We will continue with logic and JavaScript this week.
Check back!
quick quiz #2 is due on Tuesday, October 17th. This is one of the quick quiz series so I will not accept it late. Since the textbook is not required, you will find the answers in the notes I asked you to read or in the classroom Smartboard notes. The material was definitely covered in class.
First JavaScript assignment
Check back!
Week #5
Week of October 2nd
e are trying different times, Erik will be available Monday from 2-3, Tuesday from 2-4 and Thursday from 4:30-6:30. I will come and go. I need to cancel my office hour on Tues at 2, I have a meeting. I will have an office hour Monday at 10. I will also be around later on Tues and Thurs afternoon. Check K101 or my office. I strongly sugggest you set up some study groups and meet when Erik is available to answer questions.
We will look at logic some more this week.
Here is some information on flowcharting and pseudocode:
Basic video
We are going to start looking at JavaScript as we continue with logic.
If you have the book I suggest reading chapter 2 and chapter 3.
Logic PowerPoint assignment
Flowchart and Pseudocode assignment This is a quiz - however it is not due until next Thursday (October 12th) 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.
Extra credit: take my example mathans.html and add code so it can do addition and subtraction in addition to multiplication and division.
Due with other homework on Thursday (October 12th).
Check back!
Week #4
Week of September 25th
We are trying different times, Erik will be available Monday from 2-3, Tuesday from 2-4 and Thursday from 4:30-6:30. I will come and go. I have an office hours Mon at 10 in my office. I strongly sugggest you set up some study groups and meet when Erik is available to answer questions.
Stem Activity
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
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 video
Cornell method of note taking is the specific one to read. I also suggest checking out the other links on this page.
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)
We will start looking at logic and will work on the practice exercise below.
Check back!
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 today you can check off the ones done in class as done.
Week #3
Week of September 18th
I will be available Monday at 10 in my office K112 and Tuesday and Thursday at 2 in K101 (hopefully). Erik will be available at 2 on Mon, Tues and Thurs and he will also be available one night at 6 - need to check with him. 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.
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)
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
Check back!
Week #2
Week of September 11th
I will be available Monday at 10 in my office K112. Erik will be available at 2 on Tues and Thurs and I will check with him about other times.
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 Things have changed and you should now use
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 as the host, we are now using 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.
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)
First: 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.
Second: 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 Semptember 19th. Note that I do not accept late quizzes
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.
Note that I had some problems uploading so if you downloaded the Access assignment before 9:00 on 9/9/2017 you might have gotten the wrong version, so check.
I am attaching a list of the resources that I found that you can use in preparing your database.
Notes on 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.
Check back!
Week #1
Week of September 4th
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 fall 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. We will start to look at them on Thursday and will look at the remaining ones next Tuesday.
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 .
These are the pages you need to go over and understand:
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.
Cascading Style Sheets:
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
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, September 14th.
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 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!

Send e-mail to Priscilla Grocer (if you have or are taking a course, use the email you were given for the class):

Back to the Top
Return to home page