IS Week 6

This week in class we worked largely with Excel manipulation and usage. We worked on basics like column naming and data input, but then moved on to more sophisticated data manipulation measures. We first learned count and sum functions. These tally the values of a set of cells automatically, decreasing the processing time of data. We also learned how to implement excels logical functions like IF, AND, and OR, which allow for conditional commands to be applied to data in order to manipulate only select data points. Cell references were also covered, with the distinctions between absolute, relative, and mixed references particularly emphasized. Relative references change when they are pasted or filled, whereas absolute references do change, as they are hardcoded to a given cell. Entry of dates and times using slashes, dashes, and colons were also reviewed. Text functions, such as those that allow for the synthesis of two different string cells, were also covered and included. Lookup functions were covered next. These include but are not limited to HLOOKUP, VLOOKUP, MATCH, INDEX, and CHOOSE. CHOOSE gets a value from a given list of values. HLOOKUP retrieves data from a given row, while VLOOKUP retrieves data from a given column. INDEX returns the value at a given position in an array. MATCH searches for a value in a given range of cells. The ROUND functions round values either up, down, or to the closest value in excel. Finally, we covered array formulas, common errors, sort, filter, and conditional formatting.

https://www.excel-easy.com/basics.html


Comments

Post a Comment

Popular posts from this blog

IS Week 12

This week we continued our discussion of Information Based Processes and Process Analytics. Specifically, we discussed Process Time Analysis. Process Time Analysis is the calculation of the execution time and cost of a process, using expected cost to account for branching. This must first be done via a time study. Time studies measure how long each activity in a process takes, how long a unit has to wait before processing starts, and then sum the processing and wait time to get flow time. Time studies take branching into account by identifying the likelihood of each branch occurring. Execution time is generally estimated by either observation or random sampling. Alternatively, several experts can be called in to give estimates, followed by a delphi analysis that will weight each of these estimates and provide a master estimate. This is known as single band delphi. Alternatively, wide band delphi can be employed. This is where each expert provides a pessimistic, optimistic, and expected...
Read more

IS Week 11

This week in class we covered information based processes, information flows, and process analytics. There are two prominent ways to model information flows. Every information based process has a couple of inalienable traits: an explicit and measurable goal, specific inputs in the form of information, specific outputs in the form of new information, the use of resources, and having an effect on multiple organizational units. Data is generally modeled via Data Flow Diagrams, whereas activities are generally modeled through Flow Charts. The first thing an analyst must do when modeling a process is identify where the process begins and where it ends. If it is ever unclear how detailed a process should be, an analyst should air on the side of generality, choosing instead to refer to subprocesses that can in turn be modeled on their own. In the modeling of processes, different actors become involved. Popular actors include customers, employees, suppliers, and regulatory agencies. Process mo...
Read more

IS Week 2

This week in IS2000 we largely discussed ontologies. An ontology is the design of formal conceptual structures for a given domain of inquiry. The objective of ontologies, and building them, is to represent abstract, real world physical concepts and their relations in a tangible manner. OOIs represent ontologies within and with regard to information systems. Ontologies describe entities, their attributes, and the relationships between them. Entities are things, physical objects, and abstract concepts. Attributes are properties of entities, as well as measurements of quantitative data with regard to them. Examples of relationship matrices include taxonomies, partonomies and associations. Multiplicities and cardinalities are both examples of constraints. We also sought to answer the question of why we use ontologies. The creation of ontologies forces rigorous analysis and facilitates unambiguous discourse about domains. This is critical for information science, and within the field it i...
Read more