Rose Ferro
Office K218, Fall River

Bristol Community College
Rose.Ferro@bristolcc.edu
(774) 357-2027

CIT 113 Home

Welcome to CIT113 (Applied Technology Exploration)!

Course Description: This course gives students hands-on experiences in a wide variety of technology applications. The students work with projects in areas such as web design and development, social networking, multimedia, logic, programming, operation systems and databases. The students will also explore issues of security, privacy, ethics and networking. Throughout this course students develop an understanding of the components of information technology systems and will explore career opportunities in technology. Three lecture hours per week. Competency met: Critical Analysis (1.0) 3 credits Fall.

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 as well (please send me a request if my office hours are not conducive to your schedule). I look forward to having you in my class and I look forward to a successful semester!

Topic #10

Social Media / Multimedia (Final Exam - due by 11:59PM on 5/13)

WordPress

  • Do some research on WordPress. Be sure that you understand the difference between a .com and a .org WordPress site and include your explanation of the difference between the two as a part of your first post.
  • Create your own FREE WordPress.com website. You are not required to spend any money to create your site as part of this course. If you choose to upgrade your WordPress site, you may do so of your own volition, but again are not required to do so for this course.
  • Post #1 - Once your WordPress site is created, based on your research, (in one post) summarize the purpose of WordPress (in general and in addition to the .com and .org comparison), as well as how it is commonly used.

Post #2 - As part of your final exam, I would like you to compare and contrast 3 distinctly different companies (for example: Fidelity Investments, Staples, and American Heart Foundation) that successfully utilize social media as their form of marketing. In a separate WordPress post, thoroughly and effectively explain your findings. This should be no less than 7 paragraphs long.

Post #3 - Based on your research (within it's own WordPress post), I would like you to identify which forms of social media you feel would be most appropriate for your field of study. Your response should clearly justify your opinion (as well as your field of study) while providing resources and examples of successful companies utilizing such forms of social media. Your report should be at least 5 paragraphs long.

As you wrap up this semester, I am also interested in your overall opinion of this course. Identify the things you like most, least, and things that you would change and why. Please keep in mind that your feedback is required, however, it will have no bearing on your overall grade. It is simply a survey that would help me improve this course for future semesters. Please type up your feedback in MS Word and send it to me as an attachment.

Your final WordPress site/URL (and course feedback summary) should be sent to me within the same email by 11:59PM on 5/13. Feel free to let me know if you have any questions.

Topic #9

I am still working on responding to emails. You should receive feedback from me regarding your last assignment within the next few days. With that said, I am extending the anticipated deadline for this assignment. Thank you for your patience. Please reach out to me if you have any questions.

Homework: Queries in MS Access (due 5/3)

Using the MS Access Table that you created last week, create the following queries (and name them accordingly):

  • Query 1: Show only the name, phone and email fields for everyone
  • Query 2: Show all of the fields for everyone with the same last name
  • Query 3: Show only the name and (physical) address fields for everyone that lives in the same state
  • Query 4: Show all of the fields for everyone with the same city and state
  • Query 5: Show all of the name and (physical) address fields for everyone with a specific first name and specific last name

If you are unable to get a result for the required queries, please be sure to add additional records in order to display at least one result per query.

Reading Assignments/Reference Material:

Topic #8

Homework: Intro to MS Access (multiple due dates - see below)

Please be sure to email me if you are using a Chrome book or a Mac (non Windows Operating System). You will need additional instruction on how to proceed with MS Access.

This assignment will require multiple steps to complete. The steps and due dates are outlined below. The final goal of this multi-layered assignment is to create an MS Access Table (named Contacts) that will capture basic contact information. You will need to identify the appropriate field names and associated data types. Assume that all of the contacts will be in the U.S and that a physical address, email and one phone number would be sufficient contact points.

Part 1 (due 4/13) - Using MS Word, email a list of the exaxt field names (no spaces) and specific type (per field) along with the file(s) that you would use to designate as the Primary Key along with your justification for your selection.

Part 2 (due 4/18) - Based on the fedback that you received for your MS Word submission, build your MS Access database and submit it via email for review.

Part 3 (due 4/21) - Populate your table (records) accordingly such that your records match the requirements below. Upon completion, submit your completed database via email for review.

  • at least three records with the same state but different city
  • at least five records with unique (different from one another) first and last names
  • at least two sets of individuals with the same last name but different first names

Reading Assignments/Reference Material:

Topic #7: JavaScript Quiz (due 4/7)

Homework

Click here to view your JavaScript homework. Open it as well as complete it in MS Word following the instructions provided. Submit it (via email) with the subject "CIT 113 Your Name JavaScript Quiz". Feel free to let me know if you have any questions. 

College Status UPDATE

As you may already be aware, the college is making decisions on how to move forward with the semester as they received updates from the health and higher education authorities. Please note that, given that this is an online course, I will continue to post assignments as initially scheduled. With that said, I will be using Spring Break as an opportunity to get caught up with the feedback that I may owe you. Please do not hesitate to reach out should you have any questions or concerns. Please also be sure to check your Bristol email, ongoing, for additional updates.

Topic #6: More JavaScript (due 3/27 extended to 4/1)

Homework

Now that you have gained some experience with JavaScript, I would like you to work on your second JavaScript Assignment. Your HTML pages / filenames should reference the following naming convention: CIS120_YourName_JSHW2_Problem1.html, CIS120_YourName_JSHW2_Problem2.html, etc. and (all in one email), within a single zipped folder. Please let me know if you have any questions.

To help you complete this assignment, consider the algorithm process that you reviewed in preparation for your last assignment.

Reading Assignments: In addition to the resources previously provided to you, go to Free Code Camp for additional JavaScript examples.

Topic #5: Intro to JavaScript (due 3/5 3/8)

UPDATE: I know that some of you are still working on your JavaScript as you simultaneously correct your algorithms. Keeping that in mind, I have decided to extend the deadline for the JavaScript assignment to Sunday, March 8. Please do not hesitate to reach out to me if you have any questions or concerns.

Homework

Based on the feedback that you received from your Algorithm Assignment, you will be writing your first set of JavaScript webpages. This week you will be working on completing and submitting (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. (all in one email), within a single zipped folder. Please let me know if you have any questions.

Reading Assignments: To view the source code (HTML and JavaScript) for each of the examples below, click on the link. Once the new webpage has opened, Right Click within the body of the webpage and choose "View Source" / "View Page Source" option. 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.

Topic #4: Intro to Algorithms (due 2/25)

Homework

Now that you have experienced writing HTML code for webpages, we will move into learning how to program within webpages via JavaScript. Before we begin, 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:

Topic #3: Web Design (Multiple Parts due 2/16)

Homework Part A - Intro to Web Design

For this assignment, I would like you to begin evaluating what you feel makes a "good" vs. "bad" website design. Using MS Word, take a screenshot of five websites that you visit frequently. Ideally, you should have a mix of both good and bad examples. Under each screenshot, identify the following:

  • The full web address of the website
  • What is the purpose of the website?
  • Who is the target audience?
  • Would you categorize this website to be a "good" or "bad" design? What attributes led you to this conclusion? Be specific in your explanation.

Based on your overall evaluation of these websites, come up with a list of 10-15 attributes/considerations/requirements for creating a good website. Provide a detailed and through elaboration for each attribute. Upon completion, submit your assignment via email with the subject CIT 113 Your Name Web Design (Part A)

Reading Assignment:

Homework Part B - Web Quiz #1

Click here to view your Web Quiz homework. Open it as well as complete it in MS Word following the instructions provided. Submit it (via email) with the subject "CIT 113 Your Name Quiz 1". Feel free to let me know if you have any questions.

Topic #2: Intro to Web Development (due 2/9)

This assignment allows you to explore working with webpages/websites by creating your own HTML page with CSS incorporated. Since you are learning about webpages, I am going to give you creative rein with the overall look. I do, however, want your content to have a consistent theme. Pick something that you have interest in and write about that. You should have at least three to five paragraphs of information incorporated with the required components listed below. Please remember, that you must include BOTH HTML and CSS in your assignment submission.

  • A background color (all of your background/font color selections must be legible)
  • Two separate lists (it could be either ordered or unordered. Feel free to be creative.)
  • At least two links (to external websites)
  • Use of at least three different headers
  • Use of at least three different font colors
  • Two images (using relative references - not using and external URL)
  • Pargraph tags and div tags

It must also include a little bit about you:

  • Your name
  • Your major
  • Include an appropriate picture of yourself

Final Requirements

  • Your source code should pass validation (more points for Strict)!

You are not limited to the requirements above. You must have at least the requirements above incorporated into your assignment (and submit it via email on time) in order to be eligible for full credit. Please feel free to explore additional HTML/CSS components and further embellish the overall look and feel of your page.

Extra credit: If you applied additional HTML that you researched on your own, if you effectively explain the code within your HTML page, you may be eligible for extra credit, however, you must identify what you applied along with your resources.

Reading Assignments:

Topic #1: Welcome Intro (due 1/29)

Welcome to CIT 113. You should have received an email from me with your first homework assignment. Please email your completed survey as well as your resume to me by 1/29. Should you have any questions, please do not hesitate to reach out. As a reminder, my email address is at Rose.Ferro@Bristolcc.edu.

Reading Assignments: