-
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 26. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]
-
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 26. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your o […]
-
My example of a KPI that I use on a regular basis is the number of emails I receive every day. This is specific and measurable because it is an exact number of emails and I use my email a lot every day. It is also achievable because I can turn on my notifications to tell me when I get an email, so I can check it frequently throughout the day. Plus, it is relevant because I need to always check my email to make sure I do not miss anything important. Lastly, it is time-phased, or time-variant, because the time frame is that I check my email daily.
-
One example of a KPI that I use on a regular basis is the number of miles I ride my bicycle and the average speed. This is specific and measurable because it tracks the exact number of miles I ride, and the exact average speed of my ride. It is achievable because I can set a goal of how fast and how far I want to go on my ride. It is relevant to me because it keeps me in shape, and tracks my mileage, speed, and calories burned. Finally, it is time variant because I can look at my mileage, average speed, and calories burned for a day, or over a week or a month.
-
An example of a KPI I often use is the sales for my department. This is specific and measurable because it tells me exactly how much money my department has made.
This is achievable because I can set and meet sales goals.
This is relevant because the sales are directly linked to the success of the store.
This is time-phased because I can see the results on a daily, weekly, monthly and yearly basis. -
An example of a KPI I use is my time spent commuting to Temple. It is specific and measurable as I can track the time from when I leave my house to the time I arrive at Temple. It is achievable as I can alter my driving route depending on traffic and the time of day in order to reduce the time; and I can also set a time goal for myself each day. It is relevant as I commute each day of the week to Temple, so the time adds up in the long run. Finally, it is time-variant as I can log my commute times each day and compare different travel route’s times.
-
An example of a KPI that I use the number of miles I walk everyday around campus. This is specific and measurable, miles is a precise measure for distance. It is achievable, I can change my routes around campus. It is relevant, the more I walk the better it is on my health. It is also time-variant. I can look at my miles, over a week, day, or month.
-
An example of an KPI that I use is my phones battery life. It is specific and measurable because on the top right of my screen my phone tells me the percent at which my phone is at. It is achievable because I can use my phone in different ways and a different amounts of time. It is relevant because I need my phone to stay in contact, if I see the battery percentage is low then I can put my phone on the charger. The battery percentage on my phone keep my phone from dying. It is time-phased/variant because I check my phone hourly.
-
A KPI I use on a regular basis is the calorie and distance tracker on the treadmill. This is specific and measurable because miles ran and calories burned are both precise measures. It is achievable because I can set a goal of a certain number of miles I want to run or calories I hope to burn and alter my pace to reach those goals. It is relevant because it is how I stay in shape and improve my health. And lastly it is variant because I can look at miles run or calories burned each time I exercise.
-
One example of KPI that I can use is the number of assignment I manage to complete in 2 hours. It is specific and measurable as I have to count how many assignments I can finished from the available assignments for me. It is achievable as I would record my daily assignment complete in 2 hours. It is relevant for me as it shows whether do I manage the time appropriately and efficiently. It is time-phased because I benchmark it at 2 hours per day.
-
An example of a KPI that I use is the amount of storage I have on my phone. It’s specific and measurable because I can see which apps/what information on my phone takes up storage. It is achievable because if my phone storage is almost full, I can delete things on my phone so that I have more space. It is relevant because I can see if I need to use my phone storage more wisely or get a phone with more storage. It is time-variant as the storage will change day by day as I add/delete things to/from my phone.
-
An example of a KPI that I use is the amount of money I spend on food. It is specific and measurable because I can see an exact dollar amount of my total spend for the week and I can also break it down to individual purchases. It is achievable because I can review the amount of money I am spending, at any time of the week, and I can choose to make food rather than spend money on food. It is relevant because, as a college student, I don’t have hundreds of dollars a week to spend on food and it allows me to be more cost-effective and smart with my money. Finally, it is time-variant because I can compare weekly food spend, daily food spend, or even monthly food spend to better understand my spending habits.
-
An example of a KPI that I use on a daily basis is a weekly budget on groceries or food items. It is specific and measurable due to the fact that I have a certain amount of money I limit myself to each week, and while it is the same price if for whatever reason one week I go over the normal amount that I spend I am able to pin point what product or item it was that caused me to exceed my budget. This is achievable because based off of what I purchase I can review my receipts to see if the amount was in my budget range or outside of it. It is a relevant tool for me because it is easy to get caught up in spending, and for me being a college student it is important to keep track of what exactly I spend my money on. It is time-variant because by being consistent with my spending at the grocery store it allows me to evenly distribute my money fort the entire month, so that nothing goes over what it should.
-
An example of a KPI that I use almost everyday is the number of miles I run on a treadmill. Running in miles is a precise measure for distance. By running on the treadmill it is achievable because I can change the speed I run and how much I run. It is relevant, the more I run the better shape I stay in and the more endurance I build. It is time-variant because I can keep track of how much I run/how long I ran each day, and to see if I am improving.
-
An example of a KPI that I use five days a week is the treadmill. There are so many things I measure while running or walking on the treadmill. Somedays I want to focus on the distance and run at least 2 and a half miles, so that’s measuring the distance and MPH. Some days I want to measure the calories so I will walk on an incline at a speed of 3 MPH on a 15 degree incline. The time I spend on the treadmill is also a KPI and I usually spend 30 minutes. My heart rate needs to stay high while running or intensely walking so that’s also a KPI. Lastly, my goal is lose weight from working out is also a KPI.
-
One KPI that I see on a regular basis is the amount of diamond dollars I use in a day on campus. It is measurable because I can check my TUMobile app and see the exact amount I spent, where I spent it, and when. I can also see my remaining balance. This is relevant because I limit myself to 30 diamond dollars a week, and if I’m on track to spend more than that, then I know to bring a snack from home to campus with me. This ensures that my diamond dollars last all semester.
-
An example of a KPI that I use everyday is my Wells Fargo Banking App. It is measurable because I can check the amount of money I have in my account. And I can also monitor how much I spend based off of my recent purchases. This is an important KPI to manage because the amount I can spend is limited to how much I have.
-
One example of a key performance indicator that is used every day is a weight scale. It is specific and measurable: it tells you how much you weigh. It is achievable: I can set goals of how much weight I want to gain/lose. It is relevant: knowing my weight will affect how much I eat, exercise, and what I do in my free time. Lastly, it is time variant: you can check your weight, daily, weekly, or monthly.
-
A KPI I use everyday would be my Citi Credit Card app. I tend to not use my debit card as much because I would like to have actual money in my savings and also build my credit score. I like to view my credit score on a regular basis to see how well and fast I am regarding with my payments. It also allows me to check and see if I am budgeting properly. For example, if I have a credit card payment approaching, I evaluate my ability to pay the payment. If I am able to pay fee right away I feel like I am budgeting well, but if I can’t make the payment, it shows me I need help with my budgeting.
-
An example of a KPI that I use on a regular basis is the average time I spend studying for an exam. Its measurable using the SMART criteria like this:
Specific: How long I spend studying for the exam.
Measurable: the amount of time spent studying.
Achievable: To get the best grade possible by studying for more than usual.
Relevant: The more time I spend, the more likely I will perform better on the exam
Time: I can compare the times I study daily, or weekly. -
A KPI that I use regularly is the “miles until empty” feature on my car. It’s specific and measurable because it gives me exactly how many miles more I can drive until I run out of gas and is more measurable than a normal gas gauge. It’s achievable in the event that I want to only drive a certain amount of miles per week or fill my gas tank up to a certain amount of miles. It’s relevant because it can help me see more accurately how much I need to spend on gas to achieve the amount of miles I need per week, day, etc. allowing me to cut down my costs. And it’s time-variant because I can check how many miles I’ve gone over a certain period of time and use that to alter my driving habits in order to save money.
-
A KPI that I frequently use in my life is the distance I have run on my fitbit. Though certainly not perfect it gives me a rough estimate of how much I have run which I value. This measurement is specific/measurable since it is the exact number in miles I have moved. Since I can reach my goal of about 10 miles a day I have an achievable goal set. Since I referee soccer it is particularly relevant to me since I like to know how much I run during a game. As for being time phased my distance traveled is available right after I finish reffing a game and I can track my distance over many different games and compare how much I run per game.
-
A KPI I use everyday, especially since beginning my college career has been the number of things I cross off of my to-do list everyday. I keep a running list of everything I have to do, usually organized by what day i aim to have them done by and the list usually extends about a week into the future. They are specific tasks, like “MIS Reading Quiz”. Measurable, it is easy to determine how many things I have left on my list of things to do. Achievable, they are all tasks I need to complete, usually for classes so they should be achievable. Relevant, they are all relevant to my course work or basic needs. Finally time based, I usually have day marked where I need each task done by.
-
A daily KPI for me would be the amount of time (minutes) it takes me to get to work everyday from when I leave my house until I arrive at the door. This KPI is specific and measurable because I can look at the time exactly that I left and when I arrived. It is achievable because I can walk faster to make the number of minutes to go down to get there at a specific time. It’s relevant because it helps me decide when to leave for work. It is also time based since it let’s me see the amount of time it tkkk me to get from place A to place B.
-
One KPI I use daily is to measure my productivity using my study log hours as a gauge of how focused on school I was that day. I strive to achieve at least 2 and a half hours each day. I can elaborate even more and divide hours studied by assignments completed to find the average time I spent on each assignment. There could be outliers, but this gives me a relative gauge of how productive I was. If the average is too high I was not working diligently enough and if its low I was working efficiently.
-
A KPI that I use on a daily basis is the stationary bike at the IBC, because it tracks time, distance, RPM (rotations per minute), calories, and level of resistance. For example I do, 11 miles with an average mile time of 2 minutes and 50 seconds, at an average of 95 RPMs and typically 430 calories on resistance 15. This is a great KPI because it helps me keep track of pace and allows me to see if I go up in performance or down in performance. All of these factors recorded are huge for me because being a college basketball player before I transferred here, I want to make sure that my athletic ability either goes up or remains the same but never declines.
-
A KPI that I use on a daily basis is the amount of MB of cellular data that I use when not in WIFI. This is a prime example of a KPI because it is both specific and measurable. It tracks that amount of data I use each time I open a web page or app the requires an internet connection. Since I do not have an unlimited data plan each day I check to make sure that I am within my required range. This KPI allows me to stay on track each month by sending me updates as to when I have reached a certain percentage of my allocated amount for the month.
-
One example of a KPI is the Data plan on my phone. So I have 5G data plan per month, and when I used 2.5GB of the 5G, I will get the text from the mobile company. They will tell me I already used 50% data of this month and when is the bill ending. That can help me not overuse data otherwise I will pay more money for the data. on the other hand, I can check the data use on my phone by my self.
-
An example of a KPI is what I buy for groceries. This example is specific and measurable because I can know how many of what I buy, and at what prices. It’s achievable because I can find different sales, use coupons, and use my reward points to get better deals. It is relevant it is relevant because it impacts my budget for the week and reminds me of what I can and can’t spend. Lastly, it’s time-variant because I can buy groceries for the month, the week, or even just for the night.
-
An example of a KPI I use regularly is my Focus Keeper app on my i phone. Basically, I set the app timer and it keeps track of how many minutes I was able to focus on one task. Then, my focus sessions are charted and kept track of over certain time spans.
-This example is specific and measurable because I know exactly how long I stayed focused on one task which allows me to measure accurately by time. The program is achievable because it charts all my data which helps he set goals for my next study session.
-It is relevant because it shows how much time I am putting into school work
– It is time phased because I can set how much time I am trying to achieve and the timer begins -
A KPI that i would use is BMI. BMI refers to your body mass index and can help determine your health status in relation to height and weight. While not perfect, it gives rough estimates. This example is specific and measurable because i know what i will be getting by measuring my height and weight and connecting it with a BMI index. it is achievable because i can see how i fluctuate, health wise, by following the simple steps to measure it. It is relevant because i can alter workout plans for it, and time variant because i can use it weekly, monthly or yearly.
-
A KPI that I use every day is amount of time I spend doing schoolwork and studying. The purpose it serves is that it improves my grades. It is measurable simply because I am able to count the time that I spend doing it. I can set a goal in order to receive a certain grade and achieve that goal. This is very relevant to my success as a student. Lastly, the time increment can be anything I choose.
-
An example of a KPI that I use in a daily basis is my personal finance & Money app in my phone. Which I use to keep tracking my spending in different categories rent, bills, transportation, entertainment, etc. For example, I know that for last month I spent a lot on transportation because I used Uber more than usual. What makes the app relevant is that it makes put a budget and spending plan for my needs in each month.
-
An example of a KPI that I use on a daily basis is the amount of water I drink through my Fitbit app. It’s specific and measurable because I can measure how much water m cup hold and how much I actually drink of it. It’s achievable because I can set a goal, for example to drink 64 fl oz in a day anf I can ceck throughout the day to see if I need to drink more. It’s relevant because drinking water is good for my overall health. It’s time phased I can look to see what days I drank more water and what days I didn’t drink enough; I can also see the results for a day, a week, or a month.
-
One example of KPI I use daily is the battery percentage on my phone. It is specific because it tells me as the battery falls or rises even just 1%. It is measurable because the percentage ranges from 0-100%. This is a very time based feature because if I know that my phone battery is starting to run low, I can alter how much I am using it. This usually means stopping myself from using entertainment apps and just using it for communication means.
-
A KPI that I use is the number of assignments I can complete from day to day. It is specific because I am working on assignments to submit them for class. It is measurable because when I finish one, I get closer to completing all of my future assignments due. It is achievable because I am capable of completing and submitting all my homework. It is results-focused because I am working to get better grades in all of my courses. Finally, is time-bound because all of the assignments have due dates that I have to complete them by.
-
A KPI that I use on a regular basis is the number of floors that I climb on the stair climber at the gym. This is a specific and precise number. It also achievable as I can change the pace I am going to get more out of the exercise. It its relevant as the more I workout, the better shape I will be in and build more strength. Lastly, it is time variant because I can keep track of how many steps/floors I climbed and for how long.
-
A KPI that I use regularly would be me getting booked for gigs (I’m a DJ around Temple’s campus). Getting booked relates to the SMART criteria as the following:
Specific: Which dates I get booked for
Measurable: How many dates i’m booked for
Achievable: To DJ throughout the weekend (Friday and Saturday)
Relevant: The more gigs I get booked for the better DJ I can be
Time: How long the gigs I get booked for -
A KPI that I use regularly is the amount of emails I send on a weekly basis. This is specific because I send emails a lot due to the different programs and organizations I’m involved in, measurable because I can easily count how many emails I send/receive by looking in my Mail app, and also because I keep track of how many emails I send for each program/org to make sure I’m not sending too many each week. It’s achievable because each week, I plan out the emails I send considering the content of each email and what time I send them. It’s relevant because I use my emails to keep a thread of conversations about specific things with my team members and also send reminders, so they’re important, and time-variant because I can track how many emails I send each hour, day, week, month, etc., but I track on a weekly basis.
-
So one example of KPI that I use at my job are my sales in comparison to my tips. I am a lunch bartending in center city Philadelphia. Generally a bartender/server makes in tips 18% of their sales. If my tips are more than 18% of my sales, then I know I was giving good service during that shift. If my tips are below the 18% threshold, then I know I was giving bad service. It definitely follows the SMART criteria. As it is specific part of the restaurants compensation for servers, it is measurable in dollars, it is definitely achievable, it is relevant to success of the business by bringing in my sales, its more money for the bartender and business, and finally it is over a specific shift.
-
A KPI I look at is my bank account and credit account. It’s specific and measurable because I can see the monetary value in the accounts. It’s achievable because I can alter how much I spend to reserve money or work more to earn more money. It’s relevant, money runs the world. And it’s time-variant because I can look at my accounts every day over a week, etc.
-
A KPI I use is my wealth. Wealth is specific and measurable as I can track how much it lessens and grows. I can set a goal for the amount of wealth I would like to gain, which makes it achievable. Wealth is commonly used to measure a persons success. I can check the results of my wealth every day, pay day, weekly, etc. which makes it time phased.
-
A KPI that I often look at is the battery monitor on my laptop. It is Specific and Measurable because it displays to me both the remaining battery life expressed as a percentage and its remaining operational time. It is Achievable because I can affect and increase the remaining battery life through the available power settings. It is very Relevant, because my laptop is where I do all of my schoolwork and most of my correspondence, and without life in the battery I cannot accomplish my tasks. Lastly, it is time-variant because I can identify, to the minute, when my battery will die and adjust that projection accordingly.
-
In rowing we use our times on the ergs to determine our performance. It is specific and measurable because it is down to the tenth of a second and the lower your time is the better. It is also a pretty good indicator of how you will do on the water, usually. It is achievable because with enough work you can get your times lower and be faster. It’s relevant due to the fact that this is one of the very few ways to determine the ranking of rowers internally on the team. It is time variant because during a piece I can look over at who is next to me during a workout and adjust my splits accordingly.
-
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 7 years 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 7 years 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 7 years 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 7 years 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 7 years, 1 month ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 7 years, 1 month ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 7 years, 1 month 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 7 years, 1 month 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 7 years, 1 month 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 7 years, 1 month 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 7 years, 1 month 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 7 years, 1 month 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 7 years, 1 month 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 7 years, 1 month 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 7 years, 1 month ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site MIS 0855: DATA SCIENCE FALL 2017 7 years, 1 month ago
Here is the exercise.
-
Laurel Miller wrote a new post on the site INDUSTRY EXPERIENCE IN MIS-FALL 2017 7 years, 1 month 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, 1 month 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 […]
- Load More
A KPI that I frequently use is the amount of sleep I get in a night. I have sleeping issues, so when I don’t get a good 6+ hours in, I become irritable, groggy, anxious, and stressed. Sleep enables me to perform better in my classes and contributes to an overall healthier lifestyle. I measure my sleep by calculating how many hours I get each night to see if I achieve my desired goal. The amount of sleep I get is very relevant to the way in which my body and mind functions throughout the day. Lastly, this KPI is time-phased because I track my sleep down to the hours I get each night.
One KPI that I use on a regular basis is my school GPA, as it measures my overall school performance for the semester. This KPI fits the SMART criteria because GPA is a specific measure that tells you your overall grades for the year, and it is also achievable because if I study more, my GPA will most likely get better. Additionally, GPA is certainly a relevant measure, as a higher GPA is a major influence on the salary and prestige of my future post grad job. Finally, GPA is time variant, I can look at GPA over this semester only, or I could take all my semesters together to get a broader idea of my academic success.
The KPI I use most often and is probably most important to my life is the amount of money in my bank account. It determines how I am preforming in my fiscal responsibilities to myself. The higher it is, the better I’m doing. This fulfills the SMART criteria in the following ways:
SPECIFIC- Nobody else has access to my account, so this number is specific to me.
MEASURABLE- The data is measured in dollars that I own.
ACHIEVABLE- I definitely can afford all aspects of my life as long as I budget properly.
RELEVANT- How much money I have to my name is relevant to telling if I’m meeting my budgetary goals.
TIME BASED- Most of my bills and income are paid on a monthly basis.
I enjoy examining sport statistics and there are many different KPI’s evident in sports. The on I am going to describe in answering this question is in the NBA they use PPG (points per game) to describe how many points per game a player scores.
SMART criteria:
Specific- The PPG statistic refers to only one specific player’s statistic.
Measurable- The PPG statistic is measured in points per game.
Relevant- The higher the PPG the more money and more successful the player becomes. Thus PPG is very relevant to an NBA player’s career.
Time Based- The PPG statistic is based on a game to game basis.
One of the KPIs that I use all the time are my grades for school. Whether it’s the grade I receive on individual grades like assignments and exams or the final grades for classes. My grades conform to the SMART criteria in a few ways. I can be specific and look at each individual assignment, (measurable) and since each assignment is graded and I can see what classes I have to focus more on(achievable). I’ll study more for these classes and ask for additional help if I need to. Grades are put in all the time, so the the time base is the whole semester.
KPI I use most frequently is the number of steps I walked each day. I use mobile application, “SAMSUNG HEALTH” to count it.
This KPI is specific and measurable: The sensor on my mobile phone counts the number of steps automatically and I can check how long and how many steps I walked. It also translates the measure to calories I used.
Achievable: I can check the KPI any time I want and I can try my best to walk as much as possible. For example, I can use stairs instead of elevator if I think my number of steps is not enough.
Relevant: This KPI is directly related to my health and exercising. By walking a lot, I can make my metabolism active and although I don’t have enough time to go to gym, I can do enough exercise.
Time-variant: I can check total step I walked each day at the end of the day(12 am) and I can even compare it with other days.
KPI I use daily is the amount of water I drink each day. I use an app to track how much water I should drink based on my height and weight. This KPI is specific because I have to put in my height and weight and it tells me what a person my size should drink each day. It is measurable in oz, liters etc. it adds up the water as I input it. It is achievable because I can check how much water I drink and make sure I meet the goal all the time and if I don’t I know I need to drink more water. It is relevant because it is related to my health and by me drinking water I know I am hydrated enough for my body type. It is time-variant because I can check this app anytime, add the amount of water I drink and compare it to others of the week.
KPI I use most frequently is my online bank account. This follows the SMART criteria by being specific and measurable in the dollar amount, achievable by budgeting the money you allocate for each day, relevant to how much money you spend each day, and timely because you have to plan when you will need more money than usual.
A KPI I use on a regular basis is an app that records the amount of time I study in the tech center or library. This can help give me an idea of how I’m doing in my classes, based on how much time I spend studying. This information is also time-variant because it records both hours spent studying per day and per week.
A KPI that I use on a regular basis is one on my phone that tells me where the most battery percentage is being lost on my phone (which apps are using the most battery life). It measures the percentage I use on each app and even the time spent just having my phone on the home screen. This KPI can help me to balance the apps that I am using the most so it can keep my phone from dying as fast as it usually does.
My iPhone battery percentage is a KPI I use everyday. It is specific because only my individual battery is displayed. It is measurable out of 100%. It is relevant because my phone battery dictates how long I can use my phone, which I often use to communicate with my friends and family, send work-emails, and check my grades.
A KPI that I use on a regular basis is the battery percentage on my phone and laptop. Being a college student, most of time I use my phone and laptop throughout the whole day.
Specific: showing my personal percentage
Measurable: the percentage goes from 1% to 100%
Achievable: rechargeable
Relevant: it shows how much or little I’ve been on my device
Time: how much time you have left using the device
I regularly use my grades on tests and assignments as a KPI. They are specific, written clearly as a percent and therefore easily measurable. They can be set as goals and therefore achievable, as well as relevant and time oriented by being broken down into semesters in at Temple working toward graduation.
A KPI I use on a daily basis is the amount of money I spend a day on food. It is specific and measurable because it can be measured by keeping the receipts and looking at the specific amount of money I spent. It can be achieved because I can budget the amount of money I spend on food and limit my spending or work more often to make more money. It’s relevant because eating is something we do every day and sometimes the quickest way to obtain food is buying it ready to go. It is time-variant because I can measure the amount I’m spending whether it’s in a day or it’s in a month.
A KPI that is used in my everyday life are my school grades. They are very specific by class and by teacher. They are also measurable by the amount of points I have received for that class. They are extremely relevant if I want to do well in school. They are also achievable if I set realistic expectations for myself.
A KPI that i use in my daily life is keeping track of the amount of money i make from work every week. This is specific and measurable because every Friday I receive a check with a certain amount of money on it, depending on how many hours I had worked that week, and I know exactly how much I made. It is achievable, because I want to be able to balance how much money I put into my savings, versus how much money I put into checking. It is relevant because I look forward to receiving my check every Friday, and I base my weekly spending off of how much I make and how much I anticipate that I will make. It’s time variant because I receive it around the same time on every Friday of each week.
A KPI that I use daily are my grades in each class. It is specific, because the grades are mine, and are different for each class. I can measure my grades based off of their percentage number, making them measurable. It is achievable because my study habits and time spent in an individual class will affect my grades. It’s relevant, because my grade will reflect my effort and skill in that respective class. It is also time variant, as my grades will change every time a new assignment gets completed.
A KPI that I use daily is checking my bank account frequently. It is specific because it tells me what have been spending my money on. I can measure around what time of the month I tend to use my card the most. It is achievable because I want to save more spend less. It is relevant because as I start to budget I will see less withdrawls. Its time variant because as my money sits my interest will build up.
An example of a KPI is my Discover card.
Specific: this card on affects me and how much I spend on it.
Measurable- I can measurable it in dollars.
Achievable- I make sure I am not running up to high of a credit bill and that I pay it off on time.
Relevant- The amount of money I spend(or borrow) is based off of what I need and how many hours I work each week.
Time Based- I pay my credit card bill each month.
An example of KPI that I use on a regular basis is GPA. It is specific and measurable because it is the measurement of my academic performance while at Temple. I can work harder to achieve a higher GPA, or not work as hard and my GPA will drop. It is relevant because it is a key part of a resume. It is also time-phased because it is updated after every semester.
An example of KPI that I use daily is how many minutes I walk, I tried to get at least an hour of walking every day. I have an Android app that monitor how many steps and how many minutes I walk on a daily basis. I believe that this walking activity consists of all of the SMART criteria components.
A KPI that I use on a daily basis would be my GPA, this helps me understand my performance overtime as I can compare my GPA from semester to semester to track my progress and determine the most effective study methods for me. This KPI is a measure that is regularly updated that specfically pertains to my performance in school making it match the SMART criteria. My goal is to have a 3.0 or higher as this is what I and many other future employers consider as a “good” GPA.
A KPI that I used on a daily basis is weight. Not just my own personal body weight, but weight used for exercises in the gym. Being an athlete in college, it is important to keep a close eye on both of these things, as it indicates how I will perform on the ice. My goal is to maintain or lose .5 pounds a week, depending on how my weight is currently looking, as well as increasing weight for workouts, making it specific and achievable. It is time variant as well, as both numbers will increase/decrease over time.
A KPI that I use on a regular basis is my step counter on my fitbit. This is a KPI because it specifically measures my daily steps, lets me know when I attain the recommended amount, is relevant to my everyday life because I do not have a car so I walk most places, and is based in time since its daily.