-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here is the exercise.
And here is the spreadsheet to complete the exercise [In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx].
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here is the exercise.
And here is the spreadsheet to complete the exercise [In-Class Exercise 8.2 – OnTime Airline Stats [Jan 2014].xlsx].
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Some quick instructions:
You must complete the quiz by the start of class on October 24.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. […] -
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Some quick instructions:
You must complete the quiz by the start of class on October 24.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign in. […] -
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Leave your response as a comment on this post by the beginning of class on October 19. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]
-
The only mistake I have made on Taber’s list of Stupid Data Corruption Tricks is number 4; however, I have made the mistake several times. While taking the online excel course offered through Temple, a lot of the homework and quiz problems involved sorting data. Though, sometimes the data would have empty columns resulting in only parts of the data to be sorted. It’s not a big deal; a simple undo fixed it, however, it was very irritating to have to fix it multiple times. For future reference, either the spreadsheets used in the course should not have empty columns, or Microsoft should fix this simple mistake.
-
I haven’t used excel much in the past, so I haven’t had the chance to really make one of the mistakes mentioned in the article. But, I’m sure it will happen at one point or another. I think it is very important to avoid not doing a full back up that way, all of your work is up to date, you don’t have to back-track because you already saved it. When working, especially when in a rush or for long periods of time, it is easy to forget something as important as backing up your work. The mind becomes focused on other things and the obvious falls to the background.
-
When I used to work in the Accounting department, my number one mistake is # 10. Opening a CSV file directly into Excel. Due to having a large data, the only way I can export data was through csv export. Working in the e-commerce and Logistics industry, we work with a lot of data that include numbers, such as domestic and international tracking numbers. These numbers range from 8 digits to 25 digits, depending on destination country and shipping carrier. When opening a CSV file, it turns all these numbers into scientific notation.
-
Yes, I made the mistake of missing the data type. One time in excel I was performing a V Look Up. For some reason I entered the dates as just a string of integers without and dashes or slashes to make a differentiation that it is in fact the data. So, when I performed my V Look Up I could not get the values that I wanted.
-
This semester I was required to take an excel class which in return had me using excel quite a bit. One of the problems I experienced while using excel dealt with the VLOOKUP feature. As explained in the article, the feature is really intricate in regards to getting it to do what you want. There was a whole section dedicated to the VLOOKUP feature during my excel class and even with all the studying I made a mistake during the final exam. Excel requires you to fill out four different categories to complete the VLOOKUP function and I must’ve filled it out incorrectly which lead to multiple wrong answers on my final exam.
-
Personally, I have made a few mistakes that are listed in the following article, whether it was opening a CSV file right into Excel, or working in a workbook and editing info without having a backup copy that was untouched. However, the mistake that I made most often, especially this summer at my internship, was the mistake of accidentally using VLOOKUPs fuzzy match. This made things way more complicated if you did not provide a “true” or “false” at the end of the function, and would drastically change the lookup values. While there are many mistakes that I made unintentionally, messing up the VLOOKUP can cause a lot of problems and decrease efficiency.
-
The mistake I made is “Number 6: Miss the data type”. When I use excel, I used to focus on the data(only the number), so I usually forgot about the data type. The most serious one was when I typed date without type. It automatically changed to integers, so I could not write down what I really want to type. I tried more than 50 times to type date but I failed to do.
I recognized that what I typed were changed to integer form after I typed more than 100 dates. I had to delete all the things and type again.
I learned a lot of things from that accident.There are many things to consider when I want to type exact data using excel.
-
I have made a few of these excel mistakes during the excel class temples requires you to take. Number 9 copy formulas that use relative coordinates when doing one of the assignments in the excel class. I went to go copy the formula but it stop because of a blank cell so instead of back tracking I just started the assignment over with the backup copy I saved. Number 3 is very important because with out a backup I would of had to start from scratch on the assignment. Having a backup of the file and remembering where you saved it and what you named it can allow you to fix something instead of starting over.
-
I have never spent much time on excel before this class. I’m pretty bad with all this online data stuff like excel and tableau, so knowing me I will make a few of the mistakes that are listed in the article. Number 3 is one of the most important mistakes to avoid. If you don’t do a full back up before starting your assignment, you risk working with inaccurate data, so it’s very important to make sure you have all the correct information.
-
I have never experienced any of these problems when using Excel, because I only have limited experience using it. I think the most important mistakes to avoid would be confusing the data types, because you would then have to go back and re-enter the correct data manually. However, all of these mistakes seem to have messy consequences that could potentially set you back in your work.
-
I have always had problems with #8 VLOOKUP. It is so easy to make a little mistake when using this function. The function requires more than one reference to refer back to so its important to have all your information ready when inputting the function. Excel can be confusing, especially when using this function because of the specific information you need to input for it to work. Once it works, it is quite useful, the hardest part for me is just getting the initial function together.
-
A common mistake that I have done in the past to corrupt my data is, number 3: Start working on the database without doing a full backup first. I have done this several times in excel, where I work on assignment for a lengthy amount of time at one time and forget to save throughout that time. I will create a large mistake that corrupts all my data and will have to start over at the point where I last saved my work. Now, I have tried to create a habit of trying to save my work throughout the time I work out to try to avoid this type of issue of happening again.
-
I don’t have much experience with excel in regards to databases, although if I had to pick the most important mistake to avoid it would likely be making sure you are logged into the correct system. I see it that was due to the fact that the system you are on dictates if anything else you do would be a mistake, even if you do what would be correct on the proper system avoiding all of these other issues mentioned in the article. The rest of these mistakes are drastic, but at least you are aware of what you are currently working on. When logged into the wrong system you can easily destroy work you wouldn’t have even considered an option at first.
-
Almost like everyone else, I have made mistake number 7. When working with a handful of data, it is so easy to mix up values with references to other data sources. Although, my mistake wasn’t exactly like how the article described; one time I was working on a column that was meant for “Names”, however the column next to it was for “School”. A lot of school names are actual people’s names usually named after someone of importance. In one row, I accidentally shifted everything with columns.
-
I do not have much experience with Excel. However, Number 3 on the “Stupid Data Corruption Tricks” compilation seems to be the most pertinent. It’s vital to do a full backup on any computer software application. I’ve completely restarted multiple MIS 0855 assignments when I was too confused to continue, and not having the original data set each time would have made things extremely difficult.
-
One of my reasons for taking this class was to gain skills and experience since I do not use Excel very often at all. Because of this I have not made any of the mistakes listed in “Stupid Data Corruption Tricks,” however I feel the most important one to avoid is number seven. Organization is something I have to constantly put effort into, so I could see it being something I’d slip up on. Being organized is one of the easiest fixes to set yourself up for success!
-
Personally, I haven’t run into any of these “Stupid Date Corruption Tricks”, mainly due to the fact that I don’t use Excel that often. Having taken an Excel course this semester, I will most likely be able to avoid these tricks. However, I believe the most important one to avoid is number 3, “Start Working on a database without doing a full backup first”. The article puts this perfectly, in that you’re basically doing work without saving at all. You’re practically waiting for it to kick you off, and have you lose all of your data and work. Making sure you do a backup before hand is essential.
-
I personally do not use excel that often and cannot think of a time ran into any of the problems listed in the article, but I can see how many of them could be nightmares when working in excel. To me the most important of them all to avoid would be number 3. If you start working on any project without doing a full backup you run the risk of losing all of your work. If you pay mind to number 3 you can avoid many other problems and make even more a lot easier to fix.
-
I don’t have much experience with Excel, so I haven’t made any of these mistakes. But I do think it is very important to avoid the mistake of “Sort a spreadsheet, but not include all the columns.” When working with the data and then realizing that you are missing certain rows that can mess up all of the data. That is such a huge loss of time and then you would have to start over with all of the data that was forgotten.
-
I have had issues with number 6, ‘Miss the Data Type’. A common issue that I frequently run across in Excel is when I work and input zip codes. A lot of New Jersey zip codes start with a 0. So if the cells are not formatted correctly, those zip codes that begin with a 0 are corrupted and the 0 would not register. Also, date of births, if not entered correctly, can become corrupt. Formatting a cell is very important and when logging data, you need to verify that the data type is correct in order to have the data useful and accurate.
-
A problem I’ve had was with number 9: Copying formulas. When I was on excel I went to copy and past a cell into my formula & I accidentally cut the cell and the cell moved over & messed up the rest of the rows because the same formula that was in the cell was in all of the cells so when it was erased it messed up the rest.
-
I have not used Excel in many advanced ways that would allow me to make most of the mistakes listed. However, I can certainly see how troublesome some of the problems could be. I think that sorting data without including all of the columns would be very problematic. For example, if a business had a list of clients in Excel with several columns with different information about each client, sorting them incorrectly would pose a big problem. Obviously if you were to notice right away that a mistake was made then clicking undo would be an easy fix. However, if it took some time to realize that the mistake was made then it would be much more cumbersome to fix.
-
The mistake that I’ve made most often on the list is number four, sorting a spreadsheet but not including all of the columns. I’ve been using Excel more this semester than I ever have before, especially in Temple’s one credit Excel class. This technique was a valuable one to use, if one knew how to use it. I would often forget to select the entire spreadsheet before sorting, which was an irritating mistake. Luckily the undo button is only a click away, however it is still a sloppy yet simple mistake I often make.
-
The only mistake I have ever made from Saber’s “Stupid Data Corruption Tricks” article was clicking “yes” without clearly evaluating the message. This actually happened to me a few times this semester because I am new to Excel. I agree 100 percent Taber that Excel should be more specific on what is being deleted and where it is being deleted from. The few times I made this mistake the file completely was unrecovered.
-
When I first began using excel, I made the mistake of using incorrect cell references in my formula. I had not learned how to use absolute cell references yet, and assumed that was the default. This was very frustrating, as my accounting assignments never seemed to end with the correct values, and rather than use the formulas, I would manually enter each value which took much longer.
-
After reading Saber’s “Stupid Data Corruption Tricks” I found out that I do not make any of the 10 mistakes. I have had 2 internships over the past 2 summers that have been excel based. Due to this, I feel like I am a master of the program. The most important to avoid is copying formulas that use relative coordinates. Formulas, in my opinion, are the hardest thing to really learn in excel, so by copying formulas it makes it easier to get the desired result. However, by doing this it can actually give inaccurate data.
-
Yes, I have done some of these mistakes. The most common mistake is simply typing data in wrong. Sometimes I try and do my work fast and hit the wrong numbers when inputing my data on spreadsheets. I eventually realize that it happened so I do not think this is the worst mistake that could happen, unless I don’t realize it.
-
One of the biggest mistakes I always make in excel is number 3 and it always ends up backfiring for me horribly. Current in one of my classes I have to do an excel every week and last week I completely messed up and didn’t have a clean excel spreadsheet to go back to. Luckily my friend had saved the original copy and provided me with a version otherwise I would have really been in trouble. I have attempted to make sure that going further I do not forget about saving a backup file on my assignments.
-
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Leave your response as a comment on this post by the beginning of class on October 19. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]
-
I believe mistake number 3 is the most important to avoid. Failing to backup the database could be a real nightmare if there are any accidents. Saving the progress made should be done frequently, not only for peace of mind but to prevent all the work being done for naught.
-
I’ve made the mistake of sorting a spreadsheet and not including all the columns (#4) before and it was the worst thing I could have done. I hadn’t noticed until after I did more parts to my assignment and ended up having to redo the entire thing because I would have had to undo everything I had spent hours doing. The names of organizations were sorted alphabetically, but I didn’t sort the addresses, phone numbers, and websites accordingly, so everything was a big mess.
-
All of the listed “data corruption tricks” can be detrimental to extracting information from the data within Excel, however I believe sorting a spreadsheet and not including all of the columns, #4, is the most important to avoid. I believe this is the worst mistake as when this happens you may not realize it and extract invalid assumptions from the data set. While only one column or a portion of the columns is sorted, you may draw invalid conclusions about correlations with other columns in the data set without any way to tell.
-
The mistake that I have done that was listed in the article was #10, opening a CSV file directly on Excel. After making edits to the CSV file on Excel and trying to save it, I discovered that it did not save my edits.
-
I believe that #3 would be my most common mistake. I get into the habit of getting into “the zone” while doing work on any databases. I get way too focused that I forget to to save the file every 15 minutes or so that a technological error happens and I end up losing all my progress. The sad part is, it a very preventable issue but lots of people like myself tend to forget about it.
-
When I was creating an expense report at my internship this summer, I was copying information from Microsoft NAV and did not include all the columns. Because the information from NAV was sorted differently than the excel sheet, I had to copy and past the correct columns and rows into the correct columns and rows in the excel file. By copy and pasting information, it is easy to leave out some columns, or accidentally delete entire columns, causing my expenses to be incorrect.
-
Although I can’t recall a time where I personally made any of these mistakes, I would have to sati would be most important to avoid number 3. Number 3 is that you start working on a database without doing a full backup first. This could be a very common mistake, especially if you have worked on a database for a longtime not realizing you never saved your changes. When going in to do more work on the database, you might not realize that you never saved changes from last time and just continue working on it, missing a lot of information.
-
In my Digital Analytics and Reporting class, we spend a copious amount of time on Excel. One thing that I always mess up on is when I’m sorting data and I forget to include a row or column during selection. In doing so, when answering follow up questions on homework, I find that I get the answer wrong because the number in (for example) Column J is not synonymous with Column A after the data has been sorted. It’s a simple mistake but it can be disastrous to your data!
-
Although I have not come across any of these mistakes, I think the most important to avoid would be #1. I find that even when not working with data, this happens in general where the system will try to correct an error by saying something very vague and because of that we tend to let it fix it for us without really knowing what was wrong in the first place. When working with data this is especially important to look out for because by agreeing to letting the server fix your “problem” you could potentially lose all of your data, or come out with incorrect data.
-
I have made the first mistake of clicking “yes” without carefully evaluating the message that says “do you want to remove this from the server?”. I can see why myself and others have made this mistake, and that is because no one actually reads through, instead they just click “yes”. So something has been removed and I had no idea it was from me clicking “yes”. Pop up boxes are annoying and most people, like myself, will click anything to get them to go away.
-
After looking over the “Stupid Data Corruption Tricks” article, I have realized that I have made the sixth mistake, “Miss the data type” many times. In high school I took a computer class which concentrated on applications like Excel, Word, and PowerPoint. During the Excel portion of the year, I made that mistake multiple times, skewing my data and documents. I am also in Statistics for Business this semester and I have an Excel project due every Friday. I also make this mistake in my Statistics class, but need to stop doing it.
-
In my opinion, the most important thing to remember from the article is the number three. It is very vital to always have backup for every set of data. We will never know if our working with the data set can disrupt the data. I f we do not have backup, there is possibility that you might have to start from scratch again which is, recollecting back the data.
-
I think mistake #6, “missing the data type,” is the most important to avoid. It is imperative to know what data you’re working with, and what unit it is measured in. If this mistake happens, all of the data can be skewed, and the analysis can be extremely wrong.
-
Number 3 is definitely the most important one to avoid because if you do all this work but something happens and you forget to save it at certain points then it is as if you didn’t do all that work. This has happen to me but not for a database, I was working on a 12-page research paper for my criminal justice class and I never saved it while I was typing and my roommate spilled his soda on my laptop and it made it freeze so all the work I did had to be redone. From that day on I save my documents after every paragraph and email it to myself just in case something ever goes wrong like that again.
-
Mistake number three, in my opinion, is the most important mistake that should be avoided. Technology is very unpredictable; your computer can shut off, crash, or freeze on you at any moment. And if you do not save your work, you will lose all the progress that you made. Saving your work and keeping a back up seems like a simple mistake that many would not make, but it is definitely the most common and the most costly.
-
Although I have never personally made any of the mistakes listed in the article, I believe #4 would be most important to avoid. If you don’t use all the columns, you’re missing data in your analysis. If you don’t have all the data then all the work you do with it could essentially be useless.
-
The one mistake that I have made many times in the past is #3 Start working on the database without doing a full backup first. This past summer I spent several weeks doing work in excel for my internship. I automatically assumed that the computer systems would have already had a backup set in place in case I lost my work. However, when I was almost finished with my project I accidentally lost all of my work. When I went back in to get the backup, all the data was messed up and I had to start from the beginning again. Now, whenever I do work on the computer I always check to make sure I have a backup in case something goes wrong.
-
I believe that Number 4 is the most important to avoid. Sort a spreadsheet but, not include all of the columns because data will not be accurate if not everything is included. You may come to a conclusion that is incorrect because you corrupted your data.
-
I think that Number 3 is the most important mistake to avoid. Not backing up your data and then accidentally losing all of your work is one of the absolute worst things that can happen to you, especially when working with a deadline. I think the rule is most important because it goes across the board in a general sense too. If you don’t backup your work, especially when working with large amount of data, it can be totally detrimental to your entire project. No one wants to have to do all of their work over again. It’s smart to always save a dataset in two or more places.
-
At my job I use excel all of the time. I don’t necessarily use the formulas and functions, however I do use the sort and filter features all of the time to sort contact information for our companies and contacts. There have been plenty of times when sorting that I chose the “select all” when doing this but really only one column is selected and all of the data gets mixed up. I think this is such an easy mistake and sometimes I don’t even realize it happens but it really can mess up all of our data very quickly.
-
I have never used Excel before. My first time is for this class, so I have never made these mistakes before. But, I think sorting a spreadsheet, but not including all the columns (#4) is the most important to avoid. I think this because it can be very simple to forget to include a column. Forgetting a column will cause all the data to be skewed which is a very huge problem when cleaning data.
-
I have made mistake #8 which is “Accidentally use VLOOKUP’s fuzzy match” when working with excel. What happened was I was dealing with some spreadsheets for a class analyzing data. I kept forgetting the “false” parameter and I had trouble getting the right range of matches until I noticed what was wrong.
-
I have not made any of these mistakes before because i have never used these programs, and have rarely used excel if ever. This class is the first time i have used excel for nearly anything. To me however, the worst mistake to make would be number 2. This is the worst because it affects others. The example provided was how it affects clients A and B. When affecting clients to me that is the worst mistake to make.
-
The only mistake I have made that was mentioned in the article was using the incorrect data type. Specifically using the wrong data type when entering a date. It is probably the easiest mistake to make out of all ten mentioned in the article. It is also a tough one to catch right away, to avoid this mistake it usually takes looking over your data to catch.
-
The mistake I have made was #3. In high school I had to do a project, I left some of the columns blanks and told myself that I would come back to them. I never wrote it down and in a week or so I finished the project with empty columns (Not knowing). Since I left it blank some of the data didn’t appear making it very inaccurate, causing me to get points taken off. After making this mistake I never leave anything blank or when I have no choice but to leave it blank, I write myself a note.
-
I never made any of these mistakes in Excel or anything like that, however, number 3 is the most pertaining to me. Because, backing up a file or object is something I continually forget to do, via backing up my phone before it resets, or simply not saving an essay every few paragraphs, and then have the computer freeze and lose it all. So, while I never made the mistake in a data program, backing up a file is something I forget to do in other circumstances.
-
I have made a mistake doing number 6 on the list. There have been a few times where I have transferred data over to excel from external sources and forgot to format it correctly afterwards. This caused a huge mess in the spreadsheet, resulting in inaccurate data unclear results.
-
I think the most important to avoid is start working on the database without doing a full backup first. The first reason is if you don’t have a complete backup you may mess up the whole data file and don’t have a chance to rework for it. Second is the computer is not always that stable when we work in data we need to think about such emergency situation like power off or crash.
-
I have never made any of these mistakes. however I believe that number 1 is probably the most important to avoid because you can remove large amounts of data and configurations by making a simple click. It is very easy and tempting to just click yes. So I would say that this is the most important one to avoid.
-
Nothing of the mentioned mistakes have happened to me. However, I believe that the most important mistake to avoid is to start working on the database without doing a full backup first. Backing up is so important because things could go wrong. What if a device crash? all the data will be gone. That is why backing up is really important.
-
None of the above has happened to me. The most dangerous in my opinion is missing columns in excel. It is very hard to notice making it a bigger problem. This seems like the issue that affects the most amount of people.
-
Personally I cannot recall a specific instance where I made one of these mistakes, however I am more than willing to bet that I have at some point. The most detrimental mistake to one’s work here would likely be Number 3 as I think we can all relate to working very hard on a project or paper and having it be deleted just because we neglected to save it or back it up. This has easily cost me several hours and can rob anybody of their time.
-
The most common, number 3, has happened to me with smaller data sets that I was simply looking around in and large datasets I was working on for a client project. Regardless the magnitude of this error I found it be extremely frustrating after spending hours cleaning and recoding data. I learn to set up the autosave feature on my personal computer and set up an autosave for my work computer that saves directly to a server or some type of cloud storage. Once it happened a second time, I’ve learned to be cautious about preserving my work.
-
I think the most important data corruption trick to do it back up your data before you start to sort it. I feel that data is usually found to be corrupt during the process of organizing it. If you have a back up of the data it is easy to go back and look through the data to figure out what part was changed incorrectly, whether data got deleted, mis-categorized, etc. Having a back up is so important for so many reasons and I think it is the number one step when looking at data of any kind.
-
Number 3: Start working on the database without doing a full backup first.
Although now, Microsoft office has periodic back ups incase of sudden app closing or computer shutdown. It does not back up every second of what you did. I dont know the time interval that it uses but I do know it is always best to avoid since you do not want all your hard work to go down the drain
-
I think the most important mistake listed is #3 because even though this step might be one of the easiest, some people just always forget. Technology is so useful, but you never know when something can go wrong.If all your work suddenly vanishes and you didn’t save your work, you’ll have to start all over again, running the chance of leaving certain things out.
-
The only one that I have committed is #6. This isa gen-ed class for me and it’s the first time I have worked with data sets. During our assignment with the data about the cars I misunderstood what the category was and used horsepower instead of liters when talking about the cars’ engines. Other than that, due to my inexperience with the topic I can’t say I have done any of these other things in the list.
-
I have made a mistake listed in this article. I have made the mistake of number 6 multiple times. I miss type the data and it always comes back to confuse me and wastes my time fixing it. I would think mistyping the data is the more important to avoid cause if you put the data in incorrect fields you have to do more work to fix it.
-
Ive honestly never made any of these mistakes. The one that I think is most important is: Number 3: Start working on the database without doing a full backup first. You have to have multiple backups when you’re working on a data base. Theres so many different ways that you can backup a data base, it doesn’t make sense not to. If you put 8 hours of your time into building a data base and it suddenly crashes, that potentially millions of dollars wasted.
-
As I would see it, the most critical thing to recollect from the article is the number three. It is exceptionally fundamental to dependably have reinforcement for each arrangement of information. We will never know whether our working with the informational index can disturb the information. I f we don’t have reinforcement, there is plausibility that you may need to begin starting with no outside help again which is, recalling back the information.
-
Yes, I have made one of the mistakes listed in the article. Normally the answer would be no, but since I’m taking the online Excel course I’ve been using Excel more often. The mistake I made was the one with the Vlookup function. During input I forgot to put false in and it messed my stuff up. Thankfully there’s an undo button.
-
I’ve never made any of these mistakes, but number 3 is definitely the worst mistake to make. Anything out of your control can happen when you’re working and you don’t want that external factor to be the reason why you have to start your work over. You yourself can also make a mistake yourself at any time too so it’s still very important to back up your work frequently.
-
An error I have made before is #6. I missed the data type. When I was entering in Zip Codes for a data set, I forgot to change the data type to zip code. This is very like the class example but it is a mistake I have made before. I noticed my mistake upon revision and now I always double check when using Excel.
-
One of the data mistakes that I have made before if starting to do work on a database without doing a full backup first. When I was interning with the School district, I did not realize that data restore may not work all of the time even if the CRM software has continuous backup. I would always conduct a checkpoint save when doing my work but I did not realize I should have conduct a full backup when I start my work on a database.
-
The mistake I think is most important to avoid is number 3, to start working on the database without doing a full backup first. There is nothing worse than having your computer shut down and losing all of your work, that’s why I believe it important to backup your data right after you complete something. Even though new software can restore some of your work when your computer restarts, it’s important to backup your work because you never know if it can be fully recovered.
-
I haven’t made any of these mistakes but I think the worst one would be number 3. That is because it is important to do a full backup so you won’t lose any data.
-
Since I cannot recall a specific instance in which I have made one of these mistakes, I’ll say that the most important one to avoid is #3: Start working on the database without doing a full backup first. Not backing up an original version of a database before making edits can be catastrophic to its function and distort the information that is drawn from the database and used in analysis, even if the edits are apparently undone.
-
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here is the exercise.
And here is the dataset you’ll need [Vandelay Orders by Zipcode.xlsx].
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here is the exercise.And here is the dataset you’ll need [Vandelay Orders by Zipcode.xlsx].
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here are the instructions (in Word) (and as a PDF). Make sure you read them carefully! This is an assignment that should be done individually.
And here is the data file you’ll need: VandelayOrders(Jan).xlsx.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 11 months ago
Here are the instructions (in Word) (and as a PDF). Make sure you read them carefully! This is an assignment that should be done individually.
And here is the data file you’ll need: VandelayOrders(Jan).xlsx.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 12 months ago
Some quick instructions:
You must complete the quiz by the start of class on October 17.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign […] -
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 12 months ago
Some quick instructions:
You must complete the quiz by the start of class on October 17.
When you click on the link, you may see a Google sign in screen. Use your AccessNet ID and password to sign […] -
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 12 months ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 6 years, 12 months ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site INDUSTRY EXPERIENCE IN MIS-FALL 2017 6 years, 12 months ago
It’s hard to balance your schoolwork and your internship. Tell us how you are handling it and what tips you have for keeping it all together.
-
Although my internship was during the summer, I am also working during the school year. I am an ITA for Carey O’Donnell’s MIS 2101 course. Along with this teaching assistant position and my classwork, I am currently looking for an internship. The things I focus on most when trying to balance all of this are routines and organization. Having a weekly routine with classes, office hours and internship searching helps me manage all that I have on my plate. Since I only have classes Tuesday and Thursday, I dedicate a few hours Friday to searching for internships. I also keep my planner up to date with all of my assignments, office hours, and interview dates in it. This helps me know what to work on. Each day I look in and see what is due, what is upcoming, and anything else that I might have forgotten about. Keeping a planner is the best suggestion I can make to someone trying to handle many things at once.
-
For me I have been working since my freshman year of college, so this is normal at this point. What has always worked best for me is having an organized list of when all my assignments are due and constantly updating that and using that throughout the semester. I almost never have internship work to do at home so it works well just worrying about school at nights and the days I am at school. I think working has really helped me not be lazy and not push assignments off too much because really every hour is so precious I cannot afford to slack off too much.
-
Since my internship was in the summer, I was luckily able to give my complete focus on my job rather than attempting to balance an internship and college course load. However, I have held a job at Temple for the past 5 semesters so I have learned what it takes to balance work and school. While I’ve learned it can be tricky at times, the biggest takeaway I found to be successful is that you need to be organized. On a daily basis, I am constantly checking and updating my student handbook to remind myself of upcoming deadlines and events I need to attend. Another similar practice I found to be beneficial is to develop and stick to a schedule. Developing a uniform routine between sleep, class, studying, and other extracurricular activities helps you stay organized and on top of everyday things.
-
I had my internship over the summer and didn’t have any other classes then, but I due hold a part-time job during the school year. I work for the graduate admissions for Fox and find that creating a schedule and checklists for myself helps me stay on track. I like to set time after work to update my schedule so I know exactly what I have to do for the week, and any major assignments or tests in the coming weeks. It is challenging at times staying on top of things, but the schedule works as a guide to help balance school and work.
-
My internship took place during the summer, so it was not too consuming. I worked full time at my internship and it was definitely a different experience. I was the only one out of my friends who had an internship, so it was unfortunate to miss out on a few things that took place during regular work hours. I also noticed the lack of time compared to the school year when you factor in commute and time at the gym. It always felt like it was almost time to get to bed and do it all over. It was a nice experience to have because it showed what it was like to be an average person who works at an office five days a week.
-
Hello everyone, sorry for the late response.
My internship took place during the summer, so I had no stress of school work on top of the internship. However, I am working part time for a company right now and am managing my time well to complete my school work and my work from the part time internship. I had to cut time in my hobbies such as going to the gym and meeting up with friends due to the new busy schedule. Also I have noticed that cutting my sleep time is not a good way to manage all the work. In the beginning of the semester it was hard to manage everything but, now I am managing to finish everything with high quality.
-
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 7 years ago
Here is the assignment. It is due by midnight on October 31. Start early!
Want extra credit? Enter your deliverable in the Temple Analytics Challenge! You don’t need to do anything more to the assig […]
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 7 years ago
Here is the assignment. It is due by midnight on October 31. Start early!
Want extra credit? Enter your deliverable in the Temple Analytics Challenge! You don’t need to do anything more to the assig […]
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 7 years ago
Leave your response as a comment on this post by the beginning of class on October 12. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]
-
This article is about a day in the life of a London uber driver. Recently, London has placed a ban on uber partly because of their failure to report sexual assaults to the police. The article provides maps and graphs that show the route of an uber driver post-ban. It also shows how the ban has affected this uber driver’s usual income. I am studying abroad in London next year, so I find it interesting that uber might not be the best transportation option for me to use. I will have to look into London’s public transportation system and alternate transportation options if need be.
-
http://www.zdnet.com/article/microsoft-opens-up-testing-of-azure-data-box-its-amazon-snowball-rival/
This article is highlighting Microsoft’s direct competitor to Amazon’s snowball, the Azure Data Box. The Azure Data box is a 45 pound tamper resistant and manageable data source which safely and more efficiently move data to Azure. With Amazon already having a product, and Google coming out with a similar product, Microsoft wanted to truly penetrate the market until their were too many competitors to be successful in the market. The best thing about this device is that it provides more efficient data transfer, while providing more transparency throughout the company, increasing efficiency. -
This article discusses the recent hack of the personal information of 143 million user of Equifax. The hack has already caused for the resignations of three high-level employees. The most intriguing part of the article is that the Equifax auditor has avoided scrutiny even though he is a large part of the breach. The part of this article that is relevant to me is that as of right now I am still deciding a major. One of the majors I am very interested with is risk management, and an auditor is bred from the risk management field.
-
https://projects.fivethirtyeight.com/clinton-trump-hip-hop-lyrics/
This article from FiveThirtyEight discusses the changing attitude towards President Trump’s name being used in rap songs, supported by numerous infographics. The authors obtained data from the lyrics website, Genius, to analyze the trend of the 2016 presidential candidates names being dropped in rap songs, and whether the mentions were positive, negative, or neutral. The graphs show that although Trump’s name has increased in being mentioned since the election, the context of the lyrics are negative, rather than positive. I found this very interesting, because it shows how media can reflect the views of a group of people, without being explicitly political. -
This is article is interesting to me because it talks about how to use past data to predicted the future. This has always been something I have been interested in being that it means so much to a business. Furthermore, I see predictive analytics as the future of companies and the way they compete.
-
http://newsok.com/how-hollister-came-back-from-the-dead/article/5564648
Between the years the 2012 and 2016, sales for the once popular teenage retail store, Hollister, saw a major decline in their sales as foot traffic in malls decreased and their beach presentation was just not enough. Using various business techniques such as lower pricing of popular items such as jeans, increasing interaction between the employee and the customer, marketing, and renovating their stores, helped Hollister’s sales increase within the past year. I found this article to be interesting to me because I’ve been working with the company for several of years and I also shopped there as a teen, so I have witnessed how the brand has changed and evolved in real time over the years.
-
https://fivethirtyeight.com/features/what-the-world-thinks-of-trump/
Reading this article reminds me of one of Obama’s speeches back in 2016, regarding Donald Trump as the next US President. Obama states that Trump do not have the ability and the skills to govern a nation. Reading this article, it shows that other countries view US and Donald Trump with disapproving look. Ever since President Trump took office the favorability towards US have gone down tremendously.
-
http://www.law.com/sites/almstaff/2017/10/05/why-law-these-students-show-you-benefits-of-a-jd/?slreturn=20170909173841
i found this article very interested since I plan on going to law school and becoming a prosecutor in the future. Sometimes I have my doubts considering the fact I will be going to school for years and that I will be in debt with school loans for a long time. So, once I came upon this article, I realized that it will definitely be worth the wait and money. Law School Admission Test rose 20 percent in June and about 12 percent in September. A survey was taken to see what their reasoning was to wanting to become a lawyer, and numerous of people were motivated to make better changes in our society. Soon, I will also be making better changes to our society and helping victims who need support and someone to fight for them in near future. -
https://www.forbes.com/sites/jeffkauflin/2017/09/15/the-most-meaningful-college-majors-2017/#684178985b67
This article talks about some of the most meaningful majors to chose from in college. I enjoyed this article because I have just recently changed my major and it is hard doing so when you don’t really know what you want to do or if you’re going to get a good job when you graduate. This article maps out some of the popular and most meaningful majors and gives you an insight into what some options are. -
https://www.forbes.com/sites/hayleycuccinello/2017/10/05/the-worlds-highest-paid-radio-hosts-2017/#26cbd5b51fbc
Forbes recently announced the list of the world’s highest-paid radio hosts. I did not realize the many factors that go into how they make so much money. For example, Howard Stern has a contract with SiriusXM, but Ryan Seacrest hosts a variety of TV and radio shows. Many radio hosts also saw a significant spike or drop in their ratings post-election. By taking a stance on certain political platforms, the hosts can really hep or hurt themselves. I found this interesting because I am a fan of radio and podcasts, but had no idea how much money these people really earn. -
https://fivethirtyeight.com/features/the-worst-loss-in-the-history-of-u-s-mens-soccer/
This article discusses just how heartbreaking the loss of the U.S men’s soccer team is. I always enjoy watching that team play, even when there isn’t a world cup just around the corner. This article breaks down the stats of some of the teams worst losses in history, and this one really ranks up there. It actually is considered their worst loss in qualifying game history. It also breaks down the probability of this team winning the qualifying game, and also surveyed a ton of people on whether they believed the U.S would win this game. The results are incredible.
-
https://www.databreachtoday.com/following-disqus-breach-expert-discloses-more-old-breaches-a-10366
The article talks about an old breach from a website called “Disqus” which is a worldwide blog comment hosting service for web sites and online communities. The breach happen in 2012 and whoever breached the data got information on 17.5 million users that goes all the way back to 2007. Disqus took care of this by resetting passwords for all users. This breach makes me think about how many other breaches companies did not find yet and will surface later. It makes me more worried about putting my information online since companies do not find all the breaches. -
http://money.cnn.com/2017/10/05/technology/facebook-data-center-virginia/index.html
This article is about how Facebook is setting up a data center in Henrico County, near Richmond, Virginia. Facebook wants to invest money in the state and while creating over 100 new jobs. I found this interesting because I’m from Virginia and I like to see that even big companies like Facebook want to focus some of their time there. And by doing this Virginia will be advancing in more complex technology and will help expand useful data all over the state. -
https://www.reuters.com/article/us-spain-politics-catalonia-puigdemont/catalonia-will-apply-referendum-law-calling-for-independence-declaration-leader-idUSKBN1CD0TS
I find this article interesting because it deals with the on-going Catalan referendum in Spain. Although data is mentioned briefly, the article says that the Catalan government claims 90% of Catalans voted in favor of independence from Spain. Madrid discovered, however, that the voter turnout was only 43% of the population. This situation gives insight on how political leaders warp data in their favor, a phenomenon, I have noticed, that has been increasingly present in recent years. -
http://news.gold-eagle.com/article/gold-prices-week-and-next-weeks-forecast/784
I found this article and the data within it to be very useful and applicable to real life. The charts within the article are very informative and show patterns that occur within the market for gold. Additionally, it shows how the price fluctuations in gold reflect the overall feelings and emotions of investors in the markets. Also, the prices can reflect world affairs and overall confidence. -
https://fivethirtyeight.com/features/what-does-a-typical-sexual-harasser-look-like-we-dont-know/
This article is about how we can’t really identify what a sexual harasser would look like due to lack of data on sexual harassment. As most may know, most sexual harassment cases do not get reported. Amy Blackstone, a professor of sociology stated, “We’re limited in the data and information that’s available about perpetrators. That makes it more difficult to name and explain patterns of sexual harassment, because we’re missing information about who instigates this behavior and why”. I found this article interesting and sad because we should all be aware of this issue but instead we are completely unsure because cases unreported (or missing data).
-
This article was interesting because it says that nearly a quarter of companies world wide are hiring CDO’s, chief data officers. These people are hired specifically to make sure the data they are producing is reliable and accurate. It talks about how these people strategize what the best course of action to present the data is. I feel that this article really shows how technologically advanced we are becoming and how important data really is. -
https://fivethirtyeight.com/features/each-nl-playoff-teams-biggest-strength-and-weakness/
This article discusses the National League teams in the MLB playoffs, and compares each team’s strengths and weaknesses. More specifically it compares their batting vs. fielding, and starting pitchers vs. relief pitchers. It uses a statistic known as WAR (wins above replacement) to rate an individual player, and in turn, a specific team’s overall “rating.” This lead the article to compare the teams to each other, and predict a World Series winner. -
This article is about the Equifax hack. It states that UK customers’ info was reached in far greater numbers than previously thought. Nearly 700,000 users were/ are affected. The reason why this article is so interesting, is because of the vast amount of data that has been put in peril as a result of the hacks. 143 million social security numbers were casualties of the breach, as well as other data associated with individuals. On top of this, far more brits are now at risk as well.
-
https://www.wsj.com/articles/six-reasons-why-china-matters-1507742854
Title: six reasons why china matters
This article provides 6 reasons why China is important in global economy and it explains each reason using adequate data. First, it shows the graph showing nonfinancial debt at a percentage of GDP and second it shows bar graph about the price of imports from China. For the last data, it shows a bar graph about the number of private vehicles in China.This data is important to me because I’m so interested in Chinese market. This is the reason why I’m learning Chinese and participating a lot of activities related to China. I was sure about the fact that China will provide me a lot of opportunities as a business professional and this article provides me enough clues.
-
https://www.databreachtoday.com/how-significant-was-breach-6000-indian-enterprises-a-10367
This article focuses on the 6000 breaches in Indian Enterprises. While thousands of Enterprises information was discovered and sold, they are downplaying the incident and people are asking for answers. one enterprise IRINN down plays the breach mentioning it will do no significant damage because the information stolen had no importance. whereas another enterprise NIXI says they have strengthened there protocol to keep data safe to prevent more breaches in the near future.
-
https://fivethirtyeight.com/features/how-do-americans-feel-about-the-nfl-protests-it-depends-on-how-you-ask/
This article discusses the importance of considering how a data set is collected before drawing any sort of conclusions. Evidently when asked about the appropriateness of NFL protests the majority seem to be in favor, however spin the question as if they are “right” or “wrong” and suddenly the group becomes much more split down the middle. It is important to consider the possible biases that can occur from either the place data is source and if your questions are leading at all. The best type of questions for collecting data are often the most objective, although it can be hard to determine what an objective way of asking the question would be for most of America. -
This article discusses about “Reviving the Data-Centric Areas of Houston and Florida”. With all of the hurricanes occurring in Houston and Florida, we are focused on rebuilding houses and businesses. However, what about data centers in affected areas, such as the Johnson Space Center? Across the “Space Coast”, there is a huge opportunity to upgrade data centers that have been effective, making them first class. By improving these data centers, it will allow for the advancement of our understanding of different forms of data, advancing us as a nation and a civilization. -
https://www.accountingtoday.com/news/data-science-the-next-evolution-for-accountants
This article discusses how the development and eventual use of AI will cause major shifts in how companies process and report information, especially with accountants. As an accounting major, this idea of AI replacing human accountants is always at the back of my mind. Luckily, AI lacks something that all humans possess: judgment. Its that judgment that will need data science skills and accountants will want to make sure that they’re ready and able to leverage the opportunities that artificial intelligence, cognitive computing, and machine learning offer.
-
- Load More