Rose Ferro
Office K218, Fall River

Bristol Community College
(508) 678-2811 x2027

CIS 120 Home

Welcome to CIS120 (Programming: Logic, Design and Implementation)!

Course Description: This course gives students an understanding of popular computer operating systems. The operating systems covered include Windows and Linux. The course leads students through basic and advanced file management tasks from a command line interface as well as from a graphical interface. Topics are covered from both an end-user and an administrative standpoint. Topics covered include hard disk management, desktop security awareness, and system configuration. Three class hours a week. Instructional Support Fee applies. Competency met: Critical Analysis (1.0), Technical Literacy (8.0) 3 credits.

This website will be updated often and will be your resource for learning about weekly homework assignments, quizzes, etc. Be sure to check it frequently! If you have any questions, please feel free to contact me via email. I am available for in person meetings if requested. I look forward to having all of you in my class and I look forward to a successful semester!

Course Meeting Schedule

Updated 9/11 Email Notifications (Do Not Delete): You should have received an email with your CISWeb account login information (not from me). Do not delete this email. You will need it to post and manage your portfolio throughout the semester.

Updated 9/11 DreamSpark Updates: I was made aware that students will no longer be receiving DreamSpark account access as part of this course since the software that was previously only accessible through DreamSpark has now been made available (for free) through alternative means. As discussed in class, MS Office (including MS Access) can be downloaded and installed for free by logging into accessBCC and navigating to Office 365. Once we get to the point where we will need to utilize Visual Studio, additional details will be provided.

Week #6 (Distance Learning on October 10)

To Submit (due by midnight on Thursday, October 19):

Create a database with one table that contains both the content and queries identified within the the following SQL Assignment Instructions. Please let me know if you have any questions.

Week #5 (In Class Meeting on October 3)

Additional Resources:

In Class Exercise / SQL Review

The Lucky Dog Grooming Parlor maintains data about each of its clients in a table named tblClients. Attributes include each dog's name, breed, and owner's name, all of which are text attributes. The only numeric attributes are an ID number assigned to each dog and balance due on services. the table structure is tblClients (dogId, name, breed, owner, balanceDue). Write the four separate SQL statements in an MS Word or Notepad file that would include each of the following:

A) Names and owners of all Great Danes
B) Owners of all dogs with balance due over $100
C) All attributes of dogs named "Fluffy"
D) All attributes of poodles whose balance is no greater than $50

To Submit (due by midnight on Thursday, October 12):

Use the InClassBookDB.accdb database to write and/or match the SQL queries provided to you on this reference sheet. For your reference, here is an MS Word document containing the SQL code from the book09 database. Note: You are not permitted to use the Query Design tool when creating SQL queries. You must write your SQL statements from scratch. Don't forget to test your results!

Week #4 (Distance Learning September 26)

You should have received an email from me on Sunday indicating that we will not be meeting today. Our next in class meeting will take place on Tuesday, October 3. My apologies for any inconvenience this may have caused. We will continue to work within MS Access this week. In the meantime, I have posted some additional resources to help you with your current assignments.

If you look below, you should see some additionally modified due dates for your assignments. If you have any questions, please do not hesitate to contact me. Thank you for your understanding.

To assist you with Queries (Week #2, MS Access), please review the following videos:

Week #3 (Distance Learning September 19)

This week we will continue to work in MS Access. You should begin reviewing the related material in advance of our next in class meeting which is where we will explore this together in more depth. Please come with questions and/or feel free to email your questions to me as they come up (using the course required email subject as outlined in the course syllabus).

Read / Review: You should have already read Chapter #1 in the textbook. However, I would also like you 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.

Downloading MS Access - Follow these instructions

Additional Resource: Creating A Simple Select Query in Microsoft Access 2010

To Submit (due by midnight on EXTENDED to Thursday, October 5): Open the books09 database within MS Access and answer the questions that relate to this database. Follow the instructions provided to you within the MS Word document and submit the completed assignment to me, via email, by the due date referenced above.

If you have any questions, please do not hesitate to ask. As you know, the best way to reach me is via email, but I ask that you use the course required email subject as referenced in the course syllabus to ensure a timely response.

Week #2 (In Class Meeting on September 12)

Portfolio (Intro to semester-long project)
This week we are going to start looking at XHTML/HTML5 and begin to develop the basics of a portfolio. I have provided several examples which we will be reviewing in class (see link below). If you already have experience with HTML/XHTML/HTML5, you are welcome to elaborate on the basics that I will present.

  • To learn more about the purpose as well as additional details regarding the portfolio, please go to:
  • Click here to take a look at an example of a portfolio.
  • Updated 9/11 How to upload your Portfolio to the server/internet: You should be using WinSCP to upload your files to the school server. You can download WinSCP from home by going to To learn more about how to post to cisweb, click here for a tutorial. For an example that is more specific to the portfolio, click here. In the linked references for posting to cisweb, please note that it identifies the host name as However, you should instead use

PowerPoint Presentation Reference: Using Relational Databases
Access Sample References: Access 2013 example explanation (PDF) and Access 2010 example explanation (PPT)

Assignment, Part 1 - Portfolio (due Sunday, September 17)

Last week I posted a link to an example that I wanted you to reference to give you an idea about how to develop your web portfolio. This week I would like you to begin structuring your portfolio and post it to the BCC server. Keep in mind that you will be using this portfolio throughout the semester to post your weekly assignments, therefore, your structure should make sense.

If you are new to HTML, you are welcome to reference the example that I posted last week to get ideas about how to structure your pages. However, anything that too closely resembles the example(s) with very little modification, will not be eligible for full credit on this assignment. The highest grade you will be eligible for is a C. To be eligible for a higher grade, I would like to see more creativity incorporate into the design. In additional to the examples that I have posted to this website, you may want to reference the following tutorial: HTML and CSS help, especially if you are new to HTML and/or CSS.

If you are comfortable with HTML or would like to learn more about it, please work to develop an interesting and professional website. All sites should be prepared with the idea that a future employer will be looking at it and evaluating you, in part, based on its content.

For your assignment, you will need to post two pages online and email the URLs to me. The first page must link to the second page. At this point the second page can just say something about it being an index to your programming examples, other course assignments, etc. The second page does not have to have any working links except for a working link back to the first page. Although your other links do not have to be active, they should still appear as links to be updated at a later time.

Assignment, Part 2 - MS Access (Due Tuesday, September 19 see below)

Considering that we did not have the opportunity to review Queries, specifically, during our last in class meeting, I am still requesting that all MS Access Databases be submitted (minus the query portion of the assignment). For those of you that have already completed the assignment (in full) and submitted it via email, you will be eligible for extra credit. If you feel as though you have any changes to make, you may make those adjustments an resubmit your database by the new deadline without penalty. Those of you that have not yet submitted anything, I will give you until the end of the day (11:59PM) on Thursday, September 21 to submit your MS Access database (minus the queries). The new deadline for the database and queries will be Saturday, September 30. If you have any questions, please let me know.

Click here to view the Access Database that I am asking you to develop.

MS Access: As a reminder, as discussed in class, MS Office (including MS Access) can be downloaded and installed for free by logging into accessBCC and navigating to Office 365 and following the instillation instructions.

Additional Resources

Week #1 (In Class Meeting on September 5)

Reading Assignments:

Additional Resources

Cascading Style Sheets (CSS):

Assignment (due Tuesday, September 12 by midnight): Read at least two articles, in each category, (of which I have provided the links) below. Most importantly, I would like you to become comfortable with your learning style and the need for time management. Be sure to complete at least one quiz, included within the provided resources.

Using the information that you have obtained, I want you to create a page in XHTML (from scratch) that will introduce yourself to me as well as identify your learning style and time management plan, both of which are important considerations for personal and professional success. Upon completion, you will need to send your .html page(s) and your picture to me as an email attachment.

Information about learning styles can be found online. You are suggested to begin with the following articles:

Information about time management can also be found online. Here are some sample articles:

Once you have identified your learning style as well as determined your time management plan, I would like you to begin constructing your XHTML. The following components are required:

  • Your name.
  • Your major. If you are a CIS major, please identify which concentration you have chosen (or plan to choose) such as networking, forensics, game development etc.
  • A little about you....
    • What kind of jobs have you had?
    • Is this your first semester in college?, etc.
  • What led you to come to BCC and choose the major you have selected?
  • What are your goals or plans after BCC? Do you plan to transfer to another school? If so, where and in what major?
  • Include an appropriate picture of yourself.
  • Include information you found about your learning style and how you can use that information to help you in your courses.
  • Include a plan about how you will manage your time to handle homework, reading, and studying.
  • Your source code must pass validation (more points for Strict)!
  • Extra credit #1: If you find other interesting articles on learning styles and time management, send me the links along with an explanation of why you found the articles interesting and helpful as part of your submission.

You should be using a lot of the HTML that has either been reviewed in class and/or has been provided as a resorce such as lists, tables, images, CSS, etc. to get the best grade. Extra credit #2: If you applied additional HTML that you researched on your own, if you effectively explain the code, you may be eligible for additional extra credit, however, you must identify what you applied along with your resources.