What is wrong pg 118

Last Thursday, I was asked to do a presentation in front of the class about what is on page 118 of the Custom program for CIS. It is a WHAT IS WRONG problem out of the book. The situation that was giving me was when a lower skilled employee made a spreadsheet of projected sales for the near future and he tells me just to print it and present. Obviously, there was something wrong with it. I checked it and it was all wrong.

This is a real world experience. When I heard that Ernest Hemingway, one of the greatest writers, made a lot of mistakes when he would write. I made it a point to have myself and someone else check it for me.

Last semester, I was taking an English class and the teacher was strict on mistakes. The first paper I turned in was a D. I was determined not to have that happen again. On the second paper, I proofread myself, I found a lot of mistakes that I didn't even know were there. Then I had my wife proofread it. She found a lot more.

Another example just today. I went to have one of my tires replaced. The advertisement behind them read," Is your A/C running Godd." Obviously no one read that.

This is a great example of proofing what you present. How would it of been if I had just presented what the intern had given me. I would of been the laughing stock of the whole company.

Remember, proofread what you write in word, in excel, in power point, and in any other report type situation.

http://ezinearticles.com/?The-Writing-Style-of-Hemingway&id=70613

The Business Case

In class, for my presentation of chapter 2 (analyzing business cases) in systems designs and analyst, I started out by coming with an idea for a business that we could discuss in this presentation. It turned out to be a great success, to the point where we actually wanted to open this company. The idea was to open up an IT company that would specialize making IT systems for privately owned gyms.
We started out with a SWOT for our business. A SWOT is tool to determine your weaknesses, strengths, opportunities, and threats to our company or system. Some of the strengths would be an untapped market, better controls for their gyms, new technology, and a prepaid idea where someone could pay for 5 to 10 visits instead for a whole month or year. Weaknesses not enough money at first, programmers not experienced enough. Threats would be bigger gyms would want to sell their technology to these gyms. Opportunities would be untapped market and developing new technology and selling that also.
We went to the mission statement for our company. It is “Bring technology to Health.” We will help out these small businesses with good technology that would help control money flow, the customers, and put out a great competition.
This is actually not a bad idea to start. If you have the right people, this could take off. Some other technologies that we came up with is an application on their iphone to track your workout or another app that would tell you how many visits you have left. Another would be to rig the machines to a server and you scan a card that would tell you which machines you used and how long. If you have a personal trainer this would help him or her out a lot.
Stephen Lee

The IF Function

The IF function in excel is for testing data in certain cells in a spreadsheet. This data can be used to tell you if data is true or false. How you use the IF function is simple. First you type an = symbol then you type IF. For example, =IF(. This tells the excel sheet that you are about to do an IF function. Then in the parenthesis select a cell in the spread sheet, for example, B3. Then you tell it if it is greater than with this symbol > or less than < or equal to = then you type in a quotations if it is true or false. =if(b3>0,”love”,”not love”). If b3 is is greater than 0 it will say love in the cell, if it is not it will say not love. This function can be copied for a group of cells.
This Function can be implanted in businesses all over the world. This world can give you a logical test to say if you should sell if b3 is less than this or you should buy vice versa. Try and use this function in business situations and see what it can do for you.

Excel Problem with Worksheet

In excel there is an HLookup function that helps companies to narrow their search for data. This is a great tool to have if you have thousands of different cells of data. Instead of trying to look through all of the cells. You can put in a function to find what you are looking for in a couple of steps.

Today, the exercise that we got was to look at the formula and figure out what the problem is in the formula. In the formula =HLOOKUP($C$3,'Historical Data'!$B$2:$F$9,3,FALSE). I thought it was the first set of cells that it was getting wrong. The last number where the 3 is that is what row to look at on the sheet. But, it was on the other sheet, That was saying what row to look at on the other sheet. That was wrong. The last number should be 4. The rows on the other sheet start different. 2 is actually 3, 3 is actually 4. I didn't know this. That is the solution that I overlooked. The solution is this =HLOOKUP($C$3,'Historical Data'!$B$2:$F$9,4,FALSE)

 

The other problem in the worksheet is that the Vlookup didn't have a range lookup. This tells the solution what you are looking for if it is true or false. I simply put false at the end of the statement and it was right. =VLOOKUP($C$9,'Stock Data'!$A$2:$C$7,3,FALSE)

Learning Model - Teach One Another

The learning Model is a tool that helps students learn and remember what has been taught. In the scriptures, D&C 109:7 it reads;
And as all have not faith, seek ye diligently and teach one another words of wisdom; yea, seek ye out of the best books words of wisdom, seek learning even by study and also by faith.
We, at this school, use this scripture to teach one another what we have learned. Teaching one another is one of the best ways of learning. That means you are able to repeat what the teacher has taught, or what you have read. This has helped me through my academic career because sometimes, I don’t fully understand what the instructors have taught and having a student that understood it helps me with all that I didn’t understand.
This is one of the best ways of learning in the IT field. Teaching one another is just what it will be like in the workplace. If you don’t understand something you can ask someone for their help and vise versa. I have heard many examples of people asking their co-workers for a little help and it saved the company a lot of time.