Josh "The Darkness" Harkness

Assignments from ISC 110, Introduction to Information Science

Click on a link below to look at my assignments

  1. Number Systems Assignment

    2. The link below discusses how ASCII converts binary symbols into hexadecimal symbols. It also explains how it converts bytes into an output for the user to see.

    ASCII

  2. Metadata Assignment

    3. In the assignment below, I conducted an expirement based on the exiftool and it's ability to interpret metadata; data within data. In this experiment, I wanted to see just how private social media really is. Are you curious too? Click a link and find out!

    Metadata Experiment | Metadata Questions and Answers

  3. Nutrition Spreadsheet Assignment:

    4. The two links below show the difference between using excel and a pdf in the web browser. In this assignment, a given set of information needed assessment. First the caloric value was calculated in a single cell then copied to the approriate cells. Then the calculated value was subracted from the origanl value to provide a difference. For some additional information, I then calculated the avergae values for each category and graphed them. The graph provides a better insight into the types of foods both to consume and avoid.


    1. Excel file
    2. pdf file

  4. Spreadsheets

    5. This next project deals with my favorite sport, football. In the project, a spreadsheet was created to analyze the various ages between different caliber teams and determine if any link exists.

    Spreadsheets Project

  5. Entity-Relationships

    6. Entity-Relationships was one of my favorite topics. In this assignment, multiple tables were created to store different types of data that were still all related in various ways. Creating the different tables with relationships shared using primary and foreign keys allowed for the elimination of redundant data and greater ease when searching for specific data.

    Entity-Relationship Diagrams

  6. Reverse Engineering a Database

    7. In this project, we were given a real life, work scenario. We were given an incomplete work assignment by a company after an employee left. For the project, we had to reconstruct the database and their relationships by determining the primary and foreign keys. We also determined which table is the junction table, and added a primary key to ensure no values would repeat. The relationships are as follows:

    One to One

    • Client to Registration
    One to many
    • PrivateOwner to PropertyForRent
    • Staff to PropertyForRent
    • Branch to PropertyForRent
    • Branch to Staff
    • Branch to Registration
    • Staff to Registration
    Many to Many
    • Client through Viewing to PropertyForRent

    Dream Homes Database

  7. Database Project

    8. As a final project, our class was tasked with finding data that we could represent using Entity Relationship Diagrams (ERD) on Microsoft's Access. Being a Call of Duty fan and having friends I compete with for better stats, I figured this was a great opportunity for me to finally track our stats and compare them to one another.

    Database Project