OMIS 2000 Data Analytics 4of7

OMIS 2000 Data Analytics 4of7 - OMIS 2000 Information...

Info icon This preview shows pages 1–8. Sign up to view the full content.

OMIS 2000 Information Systems – Data Analytics Quantitative Data Analysis Approaches Lecture 4 of 7 Gathering, Collecting and Organizing Data 1
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Table/List One thing that we see pretty much every Excel user doing with some frequency is working with tables/lists. Tables/lists can mean different things to different people so let us briefly define what we think of when we use the words table/list. A list is a collection of data arranged in columns and rows. Each column of a list is called a field. Each row is called a record. The first row in a list is called the label row and helps in identifying each column. Example: Sales spreadsheet
Image of page 2
Entering Data Begin by creating a column (with labels for column headings) for each field Adding a record is as simple as typing in another row You can always work directly with the data as entered, but sometimes it is advantageous to formally define the range as a TABLE in Excel (we will do this later today…) 3
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Error Management - Data Validation Specify and correct the kind of data that can be entered Specify an input message alerting users when they click a cell that only specific types of data can be entered in that cell Specify error messages, which appear when others persist and attempt to enter incorrect data 4
Image of page 4
Data Validation 5
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Data Validation To specify data validation criteria, click Data Validation in the Data Tools group on the Data tab On the Settings tab of the Data Validation dialog box, specify the type of data permitted in a cell Input messages consist of two parts: Title and input message Error alert message should be polite and should clearly state what the error is Use the Error Alert tab 6
Image of page 6
(Optional) Validate Data Another way to help prevent a user from
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern