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

Homework Part #1: Please be sure to schedule an in person meeting with me to meet no later than 12/12.

Homework Part #2: Social Media / Multimedia (Final Exam - due by 11:59PM on 12/18)

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: H&R Block, Zappos, and World Wildlife 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 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 12/18. Feel free to let me know if you have any questions.

Topic #8

Homework: Queries in MS Access (due 12/12)

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

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

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

Create an MS Access Table (named Contacts) that will capture contact information. You will need to identify the appropriate field names and associate 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 11/20) - 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 11/24) - Build your MS Access database and table based on the provided feedback and submit it via email for review.

Part 3 (due 11/27) - 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 #6

Homework: Quiz #2 - JavaScript (due 11/11)

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 Quiz 2". Feel free to let me know if you have any questions.

Topic #5

Homework: Programming Logic #2 (due 10/27)

This week you will be working on completing and submitting (via email) 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.

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

Topic #4

Homework: Intro to Programming Logic (due 10/20)

Reading Assignments: 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.

Programming Assignment #1 (due 10/20): Intro to Programming Logic

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.

Additional resources can be found below. Please don't hesitate to reach out if you have any questions.

Topic #3

Homework: Web Assignment #3 (due 10/8 - extended to 10/20) - Part B - 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.

Homework: Web Assignment #3 (due 10/1) - Part A

Reading Assignments:

Web Assignment #3 (due October 1): 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)

Topic #2

Homework: Web Assignment #2 (due 9/22)

Reading Assignments:

Web Assignment #2 (due September 25): How to Play Games

Identify three games of your choice (board games and/or electronic games). For each game, find an appropriate image to represent that game. Although the images you find may be larger than ideal, you will need to modify the size of the image using the height and/or width specifications outlined in your reading. Ideally, your image should be proportional and not exceed 1.5".

Each image must be a clickable link that leads the user to a different page with the name of the game, a larger version of the image, and a summary of the game and/or instruction on how to play. You may also include a review of the game on the individual game page if you would like to do so.

In addition to the three games of your choice, you will also be highlighting at least five different ways to win at Bingo. Using the following ways to win Bingo, you must choose five significantly different ways to win. Examples: Shapes that are similar to one another would be small kite, large kite, arrow and large arrow. Using the options that you have chosen, you will need to construct one sample winning card for each (of the five) game using tables. You can identify the selected cell the way you see fit such as by using an "x", an "o", a fill color, or something else creative and/or as reasonably legible. All five winning game cards should be on one idividual "Bingo" page.

Additional Requirements:

  • You must include an external CSS file. You may also include additional internal and inline CSS, but most of your style specifications must come from the external CSS.
  • Naming convention: Your CSS file should be named gamingCSS.css. Your subsequent filenames should include the name of the game being described (using camel casing - no spaces in between). For example, if you had a page for Battle Star Galactica, your filename should be BattleStarGalactica.html.
  • Each page should have a heading displayed on the page using the appropriate header tag. The title of each page should be consistent with the game being described. The title of the homepage (in your HTML code / <title> tag) should say Game Homepage.
  • Each individual game page must have a link (at the bottom of the page) that leads the user back to the homepage.
  • Your pages must be legible and look reasonably good.
  • Upon submission, remember to include all of your files (html and css) as well as all of your images.
  • Your assignment submission must be a zipped folder (with all of the required contents) and should be submitted via email using the course required email subject.

Topic #1

Homework:

  • Prior Knowledge / Intro Survey (due 9/5)
  • Web Assignment #1 (due 9/15)

Reading Assignments:

  • Read the Course Syllabus
  • Click here to view examples of XHTML/HTML5, CSS, and JavaScript files/code. Additional examples will be posted as we move through the semester. 

Additional Resources
HTML:
http://www.w3schools.com/html/html_intro.asp
http://www.tizag.com/htmlT/
http://www.html.net/tutorials/html/

Cascading Style Sheets (CSS):
http://www.w3schools.com/css/default.asp/
http://www.tizag.com/cssT/
www.csstutorial.net/

Web Assignment #1 (due September 13): 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 must 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.