Transcript Clarity lecture slides

Clarity
ACIS 1504 - Introduction to Data Analytics & Business Intelligence
Business
Intelligence
Quality
Information
Functions
SDLC
Design
• Spreadsheet*
• Database
Data
Analytics
Big Data*
Methods
•
•
•
•
•
Data Mining*
Text Mining*
OLAP*
Visualization*
Query
Database
Benefits 
Components 
Implement with:
* Excel
 Access
Concept Map
Data
Analytics
Implementation
Design
Formatting
Clarity
Freeze
Panes
Sort
Conditional
Format
Objectives
• Explain the Clarity Design Goal and the four
principles that comprise this goal.
• Demonstrate Excel features that support
Clarity.
Segment A:
Unity
Clarity Principles
• Unity
• Delineation
• Order
• Emphasis
Unity
• Fonts
• Colors
• Borders
• Number Formats
• Freeze Panes
• Print Titles
Display Problem
Freeze Panes
Mac Users:
Windows Menu
First position cursor below &
to the right of headings
Printing Problem
Print Titles
Segment B:
Delineation
Delineation
• Fonts
• Colors
• Borders
• Number Formats
• Indent/Wrap
• Row Height/Column Width
Balance
Sheet
Example
Delineate Worksheet Zones
• Heading
• Data
• Calculations
Nashville Hotels Example
Open Nashville Hotels.xlsx
Familiarize yourself with the data.
Apply appropriate Excel features to support
Unity and Delineation.
Nashville Hotels – formatting w/purpose
1. Apply formatting including fonts,
background colors and borders to clearly
identify at least the heading, data and
calculation zones of Sheet1 and Sheet 2.
2. Apply number formatting so all dollar
figures display a dollar sign.
3. Add a title that describes the entire
worksheet.
Nashville Hotels – Unity w/Big Data
4. Setup Sheet1 so that column and row
headings remain on the screen no matter
where you scroll. Ensure that these
headings appear on every printed page as
well.
Segment C:
Order
Sort
Sort by Last Name.
If two students have
the same last name,
sort by First Name as
well.
First, select data range.
Grades Example - Sorting
Sort the data chronologically. Within one
semester, sort students alphabetically.
1. What is the earliest semester
represented in this data set?
2. Who is the last student alphabetically in
the earliest semester?
3. What is the next semester
chronologically?
Custom Sort
Nashville Hotels Example - Sorting
Group hotels within the city they are physically
located. Sort these cities alphabetically.
Within each city group, list hotels by size; hotels with
the most rooms would appear first.
If two hotels in one city have the same number of
rooms, list them alphabetically.
Nashville Hotels Example - Sorting
Re-sort the hotels by price, listing pricing groups
lowest to highest (Budget, Economy, Midprice,
Upscale, then Luxury). Within each price category,
sort hotels alphabetically.
Segment D:
Emphasis
Conditional Format
First, select data range.
Conditional Formatting Example
Emphasize Accounting majors.
First, select data range.
Emphasize Exam Scores Example
1. Emphasize perfect Exam 1 scores from
all students.
2. Using only the first 10 students in your
worksheet, emphasize the highest
Exam 2 score.
3. Display a green icon for A’s, yellow for
B’s and C’s and red for lower grades.
Emphasize Hotel Rooms Example
• Highlight hotels with a large meeting room
(largest room over 10,000 sq ft). Don’t use
the default formatting choices, build your
own.
• Display one icon for large hotels (>200
rooms), a second icon for medium sized
hotels (100-200 rooms) and a third icon for
small hotels (<100 rooms).