Excel Workbook Research Paper

The first artefact for my portfolio is Assignment 2 in Mdde 602, titled: Analyzing Quantitative Data. Part two of this assignment included an Excel spreadsheet which displayed the data. This assignment consisted of an Excel data spreadsheet containing multiple sets of data to perform the statistical analysis. The second component consisted of creating a response document on Microsoft Word in order to record the written answers to the assignment problem. The solution to each problem was only possible to solve after performing the data analysis in the Excel sheet first. The most challenging and exciting part of this assignment was explaining the concept to a person who had no understating of statistics and breaking down the material to be easily comprehensible.

I learned how to decompose a relation and what characteristics they keep acquiring base to the point of making everything table simple to understand but always keeping the integrity and proper function in the relation.

There are many diseases in the world that are age related and gender specific related, in which means that the diseases only affect a specific group or gender. Many people say that breast cancer is a gender specific disease, but in fact did you know that 15% of men actually also get breast cancer? Alzheimer is also said to be an age specific related disease but in fact Alzheimer can happen to anyone at any age. So what is a gender specific disease?

Before spreadsheet was invented, people used to do and solve calculations on a piece of paper or by calculators (they still use calculators even today). Spreadsheet was invented by Dan Bricklin and Bob Frankston in 1979. Visual calculator was in fact the first commercial spreadsheet program. After it was invented, it made peoples’ life much easier in terms of doing calculations automatically, speeding up the calculations, lots of calculations are done simultaneously and also saving up peoples’ time. Spreadsheets are so important today because many companies and organisations use a lot of spreadsheet models to manipulate complex data/ problems as it contains accurate data. Manipulation of data can be applied to non-numeric data. It is a

The challenge in this situation is that the user wants to use a program that is new to him. I will have to explain to the user the basic functions of Excel to see if those functions match what the user wants to do.

I believe that one of the most interesting and widely-used and seen human-computer interface devices is the desktop. Being only 20 years old, I have never personally owned a computer that did not have some kind of desktop. I had never thought to delve into why it was called the desktop until we discussed this in class.

(TCO 1) A spreadsheet can best be thought of as the computerized equivalent of a ____________ .

Reading your post, I went over to the function you mentioned, recently used. While doing so was thinking interesting; now I have more to play with, I did not even know I recently used some of these, nor where or when. I’m not sure I’ll ever fully know what all Excel and I are capable of especially when it gets to all the bells and whistles, but I am going to come very, very close.

There are several different ways this spreadsheet was developed. The title and subtitle were created by first using the Merge and Center button. Next the user changes the font by increasing the font size and changing the color. Then the user would move on to the table itself. After selecting the range, one option is to insert a table template with headers or the user could make their own template. The table has thick outside borders and thin inside borders as well as two different fill colors for the header and body of the table. Now the user would select AutoFit

In my mid semester report the area that identified that I could improve on happened to be working in Excel. During the second half of the semester I was able to improve in Excel by knowing what functions and information to use to record and graph accurate information. Improving in Excel helped prepare for the Lab Practical. Another area that I stated that I could improve upon was when collecting data to make to record the correct amount of significant figures needed for the data that was being recorded. I was able to improve on this when recording data and carefully examining the amount of what was being used in the experiment. By doing this I was able to make sure I was not forgetting any significant figures that would be valuable when reporting the end experiment.

I also learned how to use various software that I had not used before, for example I had learned how to use a software called the compendium, which I had not heard of before. What I had learned about the compendium which took me time to figure out, was how to draw the arrows.

Formulas in excel can make everything so much easier to do. Formulas are used to quickly and effectively accomplish something that might take up time or be difficult if you did it yourself. So, what are formulas anyway? Formulas are short bits of text (or sort of like code if you want to think of it like that) that will add, subtract, multiply, or divide the numbers in cells. Cells are the boxes that are all over the screen that you can write in.

The next set of valuable learnings in this unit came from advancing my use of functions. I have plenty of practice with the basic functions in Microsoft Excel; functions like SUM and AVERAGE are common place in spreadsheet work. However, I have not fully taken advantage of other functions like MIN, MAX, TODAY, and other useful options. Essentially, functions are a template of their own; they are pre-built functions that can save a lot of time and

Practice is great. I really feel like I learned some valuable information this week to efficiently manipulate data in a DBMS. I did have some frustration as I couldn’t find a way with the Open Office database to insert multiple rows with a single insert statement. I think this may be a restriction in Open Office, but during investigations, it was generally recommended to limit multiple entries at once

These resources have assisted me in becoming a better student and achieving my goals through helping me with everything that I need. Now, if I need additional aid in understanding a certain subject, I will take advantage of these resources and ask for help.