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!

Online Help

Online Help Sessions with Loren are outlined below and can be accessed by clicking on the following link: https://us.bbcollab.com/guest/48ac1f4cca9644aa9bd96ff55e222cec

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

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

Homework Assignments and Related Materials

Week #15

Reminder: As part of your final exam submission, you will be required to email your Portfolio URL to me. As part of your course Portfolio (that you created at the beginning of the semester), you must update it to display your functioning JavaScript Assignments. For each link, you should provide a description of what your code does.

Final Exam (due Sunday, May 17 by 11:59PM)

Posted (5/4): This is a take home final exam - it is also an individual assignment. You may receive clarification ONLY from me. If you have a question, it is your responsibility to email me (at Rose.Ferro@Bristolcc.edu) within a timely manner to ensure that I have the opportunity to provide you with a response prior to your submission.

Your final exam must be submitted no later than 11:59PM on Sunday, May 17 using the instructions included on the first page of your final. Please take the opportunity to review it as soon as possible so that I may address as many questions as possible in advance of the due date.

Any outstanding work should also be submitted by the final exam due date to be considered toward your overall course grade. If Loren is available, you are welcome to ask her questions regarding your assignments, but not any questions regarding your final exam. You should contact me directly for clarification.

Week #14

As part of your final exam submission, you will be required to email your Portfolio URL to me. As part of your course Portfolio (that you created at the beginning of the semester), you must update it to display your functioning JavaScript Assignments. For each link, you should provide a description of what your code does.

JavaScript #3 (due Sunday, May 10 by 11:59PM)

Complete and submit (via email) your third JavaScript Assignment. Be sure to reference your completed Algorithm Process to help you organize your assignment before you begin. Your filenames should reference the following naming convention: CIS120_YourName_JSHW3_Problem1.html , CIS120_YourName_JSHW3_Problem2.html , etc. and should include the algorithm process as part of your submission along with your individual JavaScript problems (all in one email), zipped into a single folder. Please let me know if you have any questions.

Extra Credit (due Monday, May 11 by 11:59PM)

Binary/ASCII: To learn about this topic, go to the Numbering Systems and Computer Codes webpage for review. I am also including a link to an ASCII Table and Description for additional reference.

  • Complete and submit this Binary Worksheet. All correct solutions will be considered for extra credit.

Week #13

I am still working on email responses to the submissions that I have been receiving. I am hoping to have them finished within the next few of days. With that in mind, I have extended the deadline for the next JavaScript assignment to May 3. If you have any questions or concerns, please be sure to email me.

JavaScript #2 (due Sunday, May 3 by 11:59PM)

JS HW #2: Complete and submit (via email) your second JavaScript Assignment with your individual JavaScript problems (all in one email), zipped into a single folder. Your filenames should reference the following naming convention: CIS120_YourName_JSHW2_Problem1.html , CIS120_YourName_JSHW2_Problem2.html , etc.

Be sure to use the Algorithm Process to help you organize and create sample test problems before you begin writing your code. You are not required to email the algorithm process to me for review, but that is where you should begin. Please let me know if you have any questions or concerns.

Week #12

This week you will be transitioning from last week's Algorithms to writing actual code using JavaScript. This will be combining your knowledge of HTML, pseudo code (loops and if statements), and algorithms.

Intro to JavaScript (due Tuesday, April 21 by 11:59PM)

Based on the feedback that you receive for your algorithm sheet submission, complete and submit (via email) your first JavaScript Assignment. Your HTML pages / filenames should reference the following naming convention: CIS120_YourName_JSHW1_Problem1.html , CIS120_YourName_JSHW1_Problem2.html , etc. within a single zipped folder. Please let me know if you have any questions.

Additional Resources

The JavaScript examples below are best viewed using Firefox. If you do not have Firefox on your personal computer, you may download it (for free) from www.mozilla.com. Similar to what you did in HTML, click on the links below (follow the prompts as necessary) and then right click on the page to view the "source code" to view the JavaScript for reference.

Week #11

If you have not been checking your Bristol email, please do so. I have sent out multiple emails requesting a response and I am missing responses from a few of you. Please check your email and respond ASAP.

This week you will be working on Algorithms in preparation for your upcoming JavaScript assignments. As you may recall, we started the semester off working with HTML. We will be picking that back up next week as JavaScript runs within webpages.

Intro to Algorithms (due Sunday, April 12 by 11:59PM)

To help you better understand how to approach JavaScript, let's first look at the breakdown of the Algorithm Process. This process is designed to help you outline how to solve a problem by 1) identifying the anticipated input, 2) identifying the logical processing (what should happen within the program), and 3) identifying the anticipated output.

Within the following solutions sheet, I have presented you with 5 different problems. Using the example that I have included for your reference, I would like you to provide me with the appropriate algorithm components (input, processing, output) as well as sample values that I should use to test your solution. Please remember that you will need to submit two sample solution sets for the last problem. Once I review your completed assignment, I will provide you with feedback prior to proceeding to your next assignment which will be to code these same problems via JavaScript. Please don't hesitate to reach out to me if you have any questions.

Additional Resources / Reading Assignments:

Week #10

If you have not been checking your Bristol email, please do so. I have sent out multiple emails requesting a response and I am missing responses from a few of you. Please check your email and respond ASAP.

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

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