Rose Ferro
Office K218, Fall River

Bristol Community College
Rose.Ferro@bristolcc.edu
(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!

Homework Assignments and Related Materials

Week #5

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"

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".

Assignment - Coding in SQL (due Tuesday, March 3 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.

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 winscp.net.

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 cisweb.bristol.mass.edu. However, you should instead use cisweb.bristolcc.edu.

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
HTML:
http://www.w3schools.com/html/html_intro.asp
https://html.com/
https://www.tutorialspoint.com/html/index.htm

Cascading Style Sheets (CSS):
http://www.w3schools.com/css/default.asp/
https://www.geeksforgeeks.org/css-tutorials/
https://www.csstutorial.net/css-intro/introductioncss-part1.php

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:
http://www.mindtools.com/mnemlsty.html
http://www.educationplanner.org/students/self-assessments/learning-styles-quiz.shtml
https://www.how-to-study.com/learning-style-assessment/
http://www.acceleratedlearning.com/method/test_flash.html

Information about time management can also be found online. Here are some sample articles:
http://www.mindtools.com/pages/article/newHTE_88.htm
http://www.mindtools.com/pages/main/newMN_HTE.htm
http://www.mindtools.com/pages/article/time-management-mistakes.htm

https://focusme.com/blog/7-tools-and-techniques-to-improve-your-time-management/
http://collegelife.about.com/od/academiclife/a/timemanagement.htm

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.