Rose Ferro
Office K218, Fall River

Bristol Community College
(774) 357-2027

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!

Online Help

Online Help Sessions with Loren are outlined below and can be accessed by clicking on the following link:

Mondays 11AM-2PM
12:30PM-1:30PM and 4:30PM-5:30PM
11AM-12PM and 1PM-2PM
9:30AM-10:30AM and 4:30PM-5:30PM

You may also reach out directly to Loren at I am also available for assistance, so please do not hesitate to reach out.

Homework Assignments and Related Materials

Week #10

This week will continue working with loops. If you have not submitted your Loop Quiz from Week 7, please do so ASAP. Also, if you have not received my feedback for your submission, please be sure to email me (using the course required email subject). I hope you are all staying healthy!

Loops cont. (due Sunday, April 5 by 11:59PM)

Complete and submit (via email) the following flowchart / pseudo code assignment using this solution sheet which includes the assignment instructions. Please note that #27 is unintentionally written twice within the assignment. The second #27 should really be #28.

To help you with this assignment, please view the following color coded images outlining the solution from Problem #1 of your homework.

Week #9 (March 23-27)

Per the college President, Laura Douglas, we will be moving entirely online for the next several weeks. Please check back here often for updates as well as your Bristol email accounts. I sent an eamil to the class with an update on March 23 (in case you have not checked your Brisol email recently). Please email me anytime you have any questions or concerns. Try to stay healthy!

Week #8 (Spring Break: March 16-20)

As a reminder, due to Spring Break, there will be no classes March 15-21. This would be an opportune time for you to catch up on any missing work up to this point. Please continue to check your email as you will be receiving additional feedback and updates from me. As always, please do not hesitate to reach out to me should you have any questions.

Week #7

Quiz on Loops (due Thursday, March 19 by 11:59PM)

The in class quiz that you began on Thursday, March 12 will be due via email by the end of the day on Thursday, March 19. Please don't hesitate to reach out should you have any questions.

Working with Loops - Introduction to Loops

This week we will be discussing loops.

To enhance our discussion on loops, you will be asked to complete the following exercises:

Assignment - Intro to Loops (due Tuesday, March 17 by 11:59PM)

Complete the following homework assignment on looping. Please be sure to follow the instructions as indicated to avoid losing additional points.

Week #6

Assignment - SQL within MS Access 2 (due Thursday, March 12 by 11:59PM)

Soft Skills Database with SQL: 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.

Assignment - SQL within MS Access (due Tuesday, March 10 by 11:59PM)

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 #5

Assignment - SQL in MS Access (due Thursday, March 5 by 11:59PM)

Using the database that was posted last week, books09 you will be reviewing and finalizing your answers to previously posted questions, by completing the following answer sheet. Upon completion, submit the completed assignment to me, via email, using the course required email subject (per the course syllabus) including the descrip

Additional Resources: Be sure to keep the comments from our in class discussions in mind when reviewing these resources.

Intro to SQL

SQL within Access: Please note that these are using an older version of MS Access, however, the SQL code is still relevant.

In Class Exercise - Lucky Dog Grooming Parlor

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
E) The names of all customers who own a Pug or Bull Dog named "Wrinkles"

Assignment - Intro to SQL (due Tuesday, March 3 by 11:59PM)

In pairs, I would like you to complete the following SQL worksheet. Add the initials of your team members (separated by and underscore) to the filename. Upon completion, email your completed worksheet using the description "SQL In Class Worksheet".

Week #4

Assignment - Continue Working with Queries

Using the database that was posted last week, books09 you will be reviewing and finalizing your answers to previously posted questions, by completing the following answer sheet. Upon completion, submit the completed assignment to me, via email, using the course required email subject (per the course syllabus) including the description "book09 Team Submission".  Your filename should be CIS120_book09_TeamAssignment_TeamMemberInitials(separated by underscores).

Additional Resources: Review the previously provided resources in preparation for today's class.

Week #3

Assignment - Individual In Class Activity (due by 11:59PM)

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, using the course required email subject as referenced in the course syllabus. 

Additional Resources: Review the resources below in preparation for next week's topic of SQL.

Week #2

CISWeb and WinSCP
As a reminder, you should already have received a CISWeb login (not from me) sent to your Bristol email account (which you can retrieve via accessBCC). If you do not believe that you have received the email with the necessary information, it is your responsibility to contact me ASAP. 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

Assignment, Part 1 (due Thursday, February 13 by 11:59PM)

As part of your week 1 posting, I included 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 Bristol 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.

To Do: For this assignment, you will need to post your first two portfolio pages online. The first page must link to the second page. The second page must have a working link back to the first page, but does not have to have any other active links for this submission.At this point, the second page can be a list or index of your upcoming programming examples, other course assignments, etc.

To Turn In: Upon completion of your draft portfolio, email your HTML pages to me along with the link to your online portfolio. Be sure to test your link from a different computer (one that you did not use to create your portfolio) before you email it to me. Your link and HTML pages should validate Strict and be submitted in a single email using the course required subject. Your HTML pages should also reflect the course required filename structure.

Assignment, Part 2 (due Thursday, February 20 by 11:59PM)

MS Access: As a reminder, you must be working on a Windows Operating System in order to do your MS Access homework. This program is not available to be downloaded on Macs or Chrome books. Once you are on a Windows OS, if you do not already have MS Access 2019, you may download it (for free) via accessBCC. This process will automatically include other MS Office products.

To turn it: Click here to view the Access Database that I am asking you to develop.

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

Additional Resources

Week #1

Reading Assignment:

  • Course Syllabus
  • Read Chapter 1 in the course book (Programming Logic and Design Comprehensive).

Course Book Reference: Chapter 1 PowerPoint Presentation.

Email Notifications (Do Not Delete): You may have already received an your login information (via email - not from me) for cisweb which is the server that you will be using to upload your webpages. Be sure to keep your login handy as you will need to reference it throughout this semester.

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.

Additional Resources

Cascading Style Sheets (CSS):

Assignment (due Thursday, February 6 by 11:59PM)

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/HTML5 (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/HTML5 page. The following components are required:

  • Your name.
  • An appropriate picture of yourself.
  • Your current major/concentration while in High School (if you have one) i.e. Computer Programming, Business, etc.
  • Do you plan on enrolling at Bristol Community College or any other college (where?) upon graduation of High School? Why or why not?
  • Your anticipated major in college. If you are interested in Computers/ Computer Information Systems (CIS), please identify which concentration you plan to choose such as networking, security, digital publishing, game development etc.
  • What are your goals or plans after you graduate college (or High School if you do not plan on going to college)?
  • A little about you....
    • What kind of jobs have you had (and may currently have)?
    • Is this your first semester in college?
    • Do you participate in any extra curricular activities (i.e. sports, clubs, etc.)?
  • 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.
  • Extra credit: 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 resource such as lists, tables, images, CSS, etc. to get the best grade. 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.