Week 7

March 9, 2014

The week’s lab assignment was to work with PhpMyAdmin.  To start with, I named my database and added a table that contained 3 columns, using the suggested column names from the assignment.  Then I went ahead and tried to import the file input.csv.   This didn’t work (surprise) because this file contained information that would go into 12 columns rather than into 3.   I dropped the original 3 columns and went added 12 columns naming them almost the same way as they were named in the csv file that I downloaded  from the assignment sheet.  At this point, I wasn’t taking screenshots and I worked all the way through the assignment getting errors here and there for various issues until I finally was able to get the information imported correctly.  Then I had to go back and try to recreate the errors I made the first time, only to make new errors as I went.  Below are the results of my efforts:

The first screen shot below shows where I inserted the column names into the table.  Notice that I typed Zip instead of ZIP, which is how it’s given in the CSV file:

NamingColumns

 

ImportingTable

 

SQLErrorQuery

CSVFormat

CSVColumnNames

IncorrectColumnImport

 

InvalidColumnErrorName

CorrectingColumns

 

Database-Complete

 

 

 

 

 


Week 6

March 2, 2014

This week’s assignment was to create a Web page from scratch using HTML in Notepad and the blog assignment is to briefly describe my experience in learning HTML.  Actually the first time I took an HTML class was in several years ago.  It was an extra class UT offered to students and it didn’t count for any credit  but I did receive a certificate of completion.  So my point is, that it’s hard for me to describe my learning of HTML since I did it before over 10 years ago.  Doing the exercise this time was an HTML refresher, and once I got the basic page structure in place, a lot of it started to come back to me.  I did forget my closing tags on a couple of lines and when I saved my work and refreshed in the browser,  I got some strange results.

Also, I never did master Cascading Style Sheets.  For simple assignments, it’s probably okay to do the formatting piece by piece, which is the approach I took this time, and I understand the concept but was never able to get the results I wanted.


Week 4

February 16, 2014

Assembly Language Simulator

The major assignment for week 4 was to work with the Assembly Language Simulator,  running 4 different sets of instructions, or programs, to see how computers work at the lowest level and to see how each line of code functions to produce the output.

 

The first program was the simplest:

READ 15
WRITE 15
STOP

The Assembly Language Simulator reads one instruction at a time, and in order to move from one instruction to the next, it was necessary to use the “STEP” button.   The first program had 3 lines, so it was necessary to click “STEP” 3 times.

When the program is run and the first step initiated, the first line, READ 15, produces a dialog box that prompts the user to input a number, which is then stored at location 15.  If the first line had been, “READ 7,” then the number would have been stored in RAM at location 7.

The line, WRITE 15, produced a dialog box that stated the output, which was the was number entered in step 1.  The third line of the program produced a dialog box that informed me of the following, “Program has stopped.”

This first program was not very exciting, but was necessary.   The programs were increasingly more complex and thus more illustrative of how computer instructions work.

 

The second program had 7 lines so it was necessary to click the “STEP” button 7 times.  This program accepted two user inputs at lines 1 and 2 (READ 15 and READ 14) and stored them at their respective locations in RAM (locations 15 and 14).  Line 3 of the program loaded the value stored at RAM location 15 to the register, and line 4 of the program added the value stored at location 14 to register 1. In step 5, the value obtained in step 4 was moved to a location in RAM, and step 6 produced the output by displaying the value stored at location 13, which was the sum of the inputs from steps 1 and 2.   In simpler terms, this programs takes 2 numbers as input by the user, adds them together, and displays the sum:

READ 15
READ 14
LOAD 15,R1
ADD 14,R1
STORE 13,R1
WRITE 13
STOP

 

Program 3 had 8 lines, one of which consisted of a value, so the program actually only had 7 instructions to carry out.  This program prompted the user to input a number at line 1 that was stored at a RAM location, and at line 2 that value was moved to a register.  Line 3 added the value stored at the location to value in the register.  In short, this program takes the number input by the user and doubles it, and subtracts 3.  It will always subtract 3, as specified by the last line of the program.  I experimented a little and changed the value in the last line to 2 or 7 and the output changed accordingly.  What I had trouble comprehending was line 4.  I understand that this is where the subtraction part comes in, and that the value to subtract is stored at location 7 in RAM, but I tried to see if I could change the 7 to an 8 and see how the program responded and at that point I got lost.  (I will have to revisit that I guess).

READ 15
LOAD 15,R1
ADD 15,R1
SUB 7,R1
STORE 15,R1
WRITE 15
STOP
VALUE 3

 

And finally, Program 4 was the most interesting but I’m still trying to figure this one out.  It required no user input.   As the program was executed, the first output was the number 5, and it decreased in increments of 1 until the the final output was one, at which point the program stopped. Lines 7 and 8 contained the values used to obtain the outputs as the program was executed.    These values were 1 and 5 stored at locations 6 and 7 respectively.  LOAD indicates that a value is loaded from a register to memory, so the number 5 went to RAM location 7 at this point, I’m assuming.  WRITE 7 produced the output of 5 at the first step.  SUB 6,RO indicates the subtraction of the  value stored at RAM location 6 from the register.  STORE 7, RO indicates the value obtained in the previous step is stored at that location and I’m assuming JUMP 1 RO is the instruction that had something to do with the fact that output could not go below one?  Anyway, I obviously need to study this a bit more.

LOAD 7,R0
WRITE 7
SUB 6,R0
STORE 7,R0
JUMP 1,R0
STOP
VALUE 1
VALUE 5

 


Week 3

February 9, 2014

 Building My Own Computer

I’m not a computer science major, an IT professional, or a tech enthusiast, but the desktop system I am using now to complete the blog assignment for week 3 of CSIT-1110 is custom built.  The only part I chose myself was the case and that was just because I wanted a really cool-looking case.  In fact, the main reason that I have a custom built system is only because I wanted a really-cool looking case.  A secondary reason is that at the time, I wanted to be more tech savvy, but all that ended up happening is that someone selected and ordered all the parts, and then provided very detailed instructions and close supervision of the building of my machine.  I learned the importance of being grounded so that the internal components didn’t get fried, and I ended up with a really cool case that had lighted, multicolored fans, but other than that, I can’t really recall a lot as far as why we were using the parts that we used.  And by the way, my case is an XCLIO gaming case, and I’ve received many compliments on it from various people that have visited my house who are accustomed to pre-assembled machines.  What they don’t know is that while the XCLIO looks really cool, it houses an everyday, ordinary system (no, it’s not a super computer) and it has no special features.  The fans are junk, and apparently, they’re no longer for sale through Newegg.

So, with all that being said, if I were building my own PC, by myself, without help, all my selections would be based around the case.  Perhaps as I learn more, the reasoning behind my decisions will change, but for now, it’s all about the case (we all have to start somewhere).

Below is a list of parts that I would buy if I were building my own computer.  As I was doing this assignment, I started to feel overwhelmed, so what we have below, is a list of parts that for the most part would be sold together, and this thing will probably work if I got it together.  For me it’s all about the case, and the mechanical keyboard, which makes a lot of satisfying noise as you’re typing  (I’m dying to take one to work to irritate my coworkers with).  Basically, I need a few more days to do this assignment and help, so I’m just turning in what I could.  I totally deserve a low grade on this one.

Computer Case

Rosewill BLACKHAWK Gaming ATX Mid Tower Computer Case

This case, as the description would suggest, is for a person who is into gaming, which I am not.  However, it does have blue lights and it doesn’t look like an ordinary computer case, (i.e. it looks really cool).  It also boasts five fans, with room for the installation of additional fans.  Keeping the inner workings of your system is of utmost importance from what I gather, so to my novice mind, the more fans, the better.  Also, did I mention that is has blue lights?  This case will set my home desktop system apart from the average, prepackaged Dell and HP systems, so no matter what I have going on inside the case, I know to other people like me, my computer system will look really awesome and a lot more impressive than it actually might be.

 

Motherboard

ASUS – P8Z77-V LK 

It’s my understanding that the motherboard and processor must be compatible so my motherboard and processer selections chosen based on their compatibility.

http://www.newegg.com/Product/Product.aspx?Item=N82E16813131837

 

 

Processor

Intel i5-3570k CPU

http://www.newegg.com/Product/Product.aspx?Item=N82E16819116504

 

RAM

Kingston HyperX Black Series 8GB

 

http://www.newegg.com/Product/Product.aspx?Item=N82E16820104381

 

 

 

Hard Drives

Seagate Barracuda ST2000DM001

http://www.newegg.com/Product/Product.aspx?Item=N82E16822148834

 

Power Supply

Rosewill Stallion Series Power Supply

http://www.newegg.com/Product/Product.aspx?Item=N82E16817182278

 

Operating System

Microsoft Windows 7 Professional

http://www.newegg.com/Product/Product.aspx?Item=N82E16832116992

 

Keyboard

Corsair Vengeance K95

http://www.newegg.com/Product/Product.aspx?Item=N82E16823816013

 

Mouse

Razer Naga – Green

http://www.newegg.com/Product/Product.aspx?Item=N82E16826153087

 

Monitor

ASUS VS Series VS197D-P Black 18.5″ 5ms LED Backlight Widescreen LCD Monitor 250 cd/m2 ASCR 50000000:1

http://www.newegg.com/Product/Product.aspx?Item=N82E16824236204

 

 


Week 2

February 2, 2014

This week’s topic was Information and Binary and the assignments all required a bit more effort on my part than last week’s assignments.   It is almost overwhelming. As I sit here and type this blog entry on this computer, I now know that each letter is represented by some combination of 1’s and 0’s.  All the graphics and sounds that I take for granted are also represented by a different series of 1’s and 0’s.  It almost makes my head hurt and I want Tylenol now.  It’s  helpful to remember this bit of information from the lecture notes: “One important thing to keep in mind as we look at how each type of information is encoded as numbers: it is more important to be able to follow the process and become convinced that it is possible to encode each particular type of information as numbers than it is to memorize the entire process required to convert each type of information to numbers. ”

I feel the need to make myself a few charts so that I can keep all this straight in my head:

Base 2 = Binary

Base 10 = Decimal

Base 16 = Hexadecimal

A = 10, B = 11, C=12, D=13, E=14 F=15

 

One Bit = Either 1 or 0

Byte = 8 bits

Kilobyte (KB) = 1024 bytes

Megabyte (MB) 1024 KB

Gigabyte (GB) 1024 KB

Terabyte (TB) 1024 GB

Petabyte (PB) 1024 TB)

*fun fact 4 bits = nibble or nybble

B -> KB -> MB -> GB -> TB -> PB

I was most delighted to discover how to use the calculator application to convert binary numbers to decimal numbers and vice versa.  This came in handy when checking my answers for the quiz.  I still managed to miss one though (too many 1’s and 0’s and not enough Tylenol I guess).  Start –> Run –> Calc = Lifesaver.

“There are only 10 types of people in the world: those who understand binary and those who don’t.”

 

 

 

 

 

 

 

 

 

 


Week 1

January 26, 2014

My name is Sara Ogle, and I’ve been a non-degree student here at Pellissippi State for many semesters (not all consecutively) since the late 90’s when I was also enrolled at the University of Tennessee in Knoxville.  I graduated from UT in 2001 with a BA in English, and then went on to work several temporary jobs before I took a permanent position as a clerical employee in an accounting office.   Soon after accepting the clerical job, I enrolled in school again at UT, then Pellissippi, and then Tennessee Wesleyan College, where I took a lot of accounting classes so that I might find a better paying accounting job.  Eventually I did find that better paying accounting job, but I still feel the need to be learning apparently, so here I am.

When I was at UT, I took a couple of Web related classes that included creating pages using HTML and Dreamweaver (before it was taken over by Adobe) and then after that, it went downhill from there.  I’m feeling somewhat technologically inept these days as  the accounting work that I do involves using only a handful of applications to do a few repetitive tasks, so I’m really looking forward to learning something else here in this class.

I used to be more active on the Web, with a Facebook account (and before that, Myspace) but all that seems to have lost its freshness.  I’ve still got my Facebook gaming profile open,  https://www.facebook.com/sara.rhinehart.5, but other than that, I don’t have much going on so this is the only link I have to share at this point.  Actually,  I don’t even log into this Facebook profile anymore.  I shouldn’t admit this, but I used to play Sorority Life and it was terribly addictive, but Playdom (Playdumb) has closed the game now.  It was a terrible game actually, that involved accumulating a virtual wardrobe, accessories, boyfriends and cars that all had defense and offense points values, and the object of the game (I guess) was to build your stats by virtually attacking and slapping other players.  Some people had “bots” which were programs that would play the game for them in their absence.  I never mastered this, and perhaps if I had taken a class like this before now, I too could have had a “bot.”  Another game I played, which is also closed now, was called Fluff Friends, and this game involved creating pieces of art using the graphics provided in the game.  You were somewhat limited with what you could do as you could only use 20 graphics per piece, but some people were very talented and could make stunning art work.  There were art contests, and I actually won a prize in one of them.  I also spent money on these games (another thing I shouldn’t admit) and then the games were taken away, I guess because people lost interest in them after awhile, or maybe they felt foolish spending money on virtual entertainment.