Images

WEEK 5: INDEPENDENT PROJECT: EXCEL 2019 IN PRACTICE – CH 6 INDEPENDENT PROJECT 6-6

 

Clemenson Imaging LLC monitors increased revenue from the use of CT scan equipment. You analyze the number of patients and procedures by technician and location.

[Student Learning Outcomes 6.3, 6.4, 6.5, 6.6, 6.7]

File Needed: ClemensonImaging-06.xlsx (Available from the Start file link.)

Completed Project File Name: [your name]-ClemensonImaging-06.xlsx

Skills Covered in This Project

  • Calculate the net present value of a purchase.
  • Use TRANSPOSE to rearrange labels into a column.
  • Concatenate cells to display full names.
  • Use SUMIFS to summarize data.
  • Calculate procedure times.
  • Format times with fractions.
  1. Open the ClemensonImaging-06 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.
  2. Determine the net present value of a new equipment purchase.
    1. Click the Financials sheet tab and select cell H5.
    2. Use NPV with a Rate argument of 4.25%.
    3. Select cells D7:D13 for the Value1 argument and click OK. This is the same as entering each value argument separately.
    4. Edit the formula to add both costs (cells D4 and D5) at the end of the formula. The net present value is $268,921.79.
  3. Use TRANSPOSE and CONCAT to display technician names.
    1. Click the Technicians sheet tab. The names are in rows.
    2. Select cells A4:A10, seven rows in one column.
    3. Select TRANSPOSE from the Lookup & Reference category and select cells A1:G1 for the Array argument.
    4. Press Ctrl+Shift+Enter to complete the array formula.
    5. Repeat the TRANSPOSE task for the first names in cells B4:B10.
    6. Select cell D4 and create a CONCAT formula to display the name in first name, last name order (Figure 6-111).ImagesFigure 6-111 CONCAT formula to display names
    7. Copy the formula in cell D4 to cells D5:D10.
    8. Click the Summary sheet tab, select cell A5, and create a 3D reference to cell D4 on the Technicians sheet.
    9. Copy the formula and preserve the borders.ImagesFigure 6-112 SUMIFS with absolute and relative references
      ImagesFigure 6-113 Change time format to display fractions
  4. Use SUMIFS to total number of patients by procedure and technician.
    1. Click the Summary sheet tab and select cell C5.
    2. Use the SUMIFS function with an absolute reference to cells $D$5:$D$41 on the Procedures sheet as the Sum_range argument.
      • The Criteria_range1 argument is an absolute reference to the image type column on the Procedures sheet, cells $E$5:$E$41.
      • The Criteria1 argument is a relative reference to cell B5 on the Summary sheet.
      • The Criteria_range2 argument is an absolute reference to the technician names column on the Procedures sheet.
    3. Select cell A5 for the Criteria2 argument (Figure 6-112).
    4. Copy the formula in cell C5 to cells C6:C11 and preserve the borders.
  5. Use SUMIFS to total number of patients by category and location in cells C14:C15.
  6. Look for and correct format inconsistencies.
  7. Calculate procedure times.
    1. Click the Times sheet tab and select cell F6.
    2. Build a formula to subtract the start time from the end time and multiply those results by 24. The result is shown in hours.
    3. Copy the formula to row 41.
    4. Select cells F6:F41 and open the Format Cells dialog box. On the Number tab, choose Fraction with a Type of Up to two digits (Figure 6-113).
  8. Save and close the workbook (Figure 6-114).
  9. Upload and save your project file.
  10. Submit project for grading.

Order # 10265

Title: ics (human factors web) homework -2800

Paper type Coursework

Paper format MLA

Course level High School

Subject Area Other (Not listed)

# pages 3   ( or 900 words Minimum)

Spacing Double Spacing

# sources 0

Paper Details

Assignment #5 – group project continued

You will continue this assignment with the same group you worked with on the last assignment.

If you have any major problems or issues in your group, please contact the instructor ASAP.

Overview of Assignment 5 and Assignment 6

For this assignment and the next one, you will continue the (re)design of the web site you chose in the last assignment. This (re)design process will span both assignments. Here is an overview of the entire process:

Assignment 5: Decide on what aspect(s) of your site you will (re)design, and build a prototype – this should be based on usability issues you found in Assignment # 4.

Assignment 6: Run user tests on your (re)design, refine the design based on the tests, build a new prototype, and run another set of user tests.

Assignment 5 Instructions

Step 1: Decide on what aspect(s) of your site you will (re)design. You will probably consider some combination of page design and navigation. Thinking in terms of user tasks, you should probably focus on a task or combination of tasks that should ideally take the user from three to five minutes; that’s long enough to be interesting but short enough to make creating the prototype and running the user tests manageable. If you have concerns over whether the aspects you have chosen are “enough” (or too much), send a message to the TAs or instructor or use Piazza.

Step 2: Sketch a number of possible re-designs on paper. Each person in your group should do at least 3 different sketches (on paper) for possible (re)designs of your site. These can be either visual (layout) or process (flow through the task) kinds of sketches. Use your HCI notebooks for inspiration. You should do these separately, and then compare your ideas. Think of this as visual brainstorming. Choose one sketch that will be the basis for the (re)design, or create a new composite sketch that gives a quick sense of what your (re)design will be.

Step 3: Using a prototyping tool of your choice (e.g., Balsamiq, Moqups, etc.), create a prototype of your (re)design. Your prototype should include all the alternative clicks/entries/actions/displays that the user may see or need while working through the task(s) (from Step 1) using the prototype.

Deliverables:

Include your Assignment #4 with Assignment #5. Consider it the same document for Assignments #4, #5 and #6 – essentially a design and evaluation report that you might create if you were doing this in a company. As such, consider a table of contents and/or good headings to make it clear what the different sections of the document are. See the section below for more on writing design reports. (overall form, layout, design of the document: 5 points)

Part A (10 points)

(about 200-300 words)

A description of the aspect of your site you decided to (re)design in Step 1 (3 points)

A detailed description of the task(s) you expect the user to be able to carry out in your prototype (7 points)

Part B (30 points)

The sketches that you produced in Step 2. Use a scanner or camera to capture the paper sketches, and paste into your document. These don’t need to be great quality, just good enough to read. Make sure the team member’s name is on the sketches she or he created. You should have a minimum of 9 sketches (3 per person). Also indicate/include the “final” sketch that was the basis for your prototype. (approximately 3 points for each sketch plus 3 extra points for the “final” sketch)

Part C (25 points)

Your prototype (all pages) from Step 3.

Part D (15 points)

(about 300-400 words)

A brief description of how your prototype works. If it is a redesign, what is different from the original? (5 points)

What issues were you trying to address in the design? (5 points)

How does your design represent the users/stakeholders you described in Assignment 4? (5 points)

Submit these materials as PDF(s) via Canvas. Make sure the document(s) include your team name and all the names of all your group members on first page of document (name the file “Lastname1_Lastname2_Lastname3_ICS4_HW5”)

A Note on Prototypes

Your prototype needs to be detailed enough that we are able to use them for usability testing in Assignment #6. That means that simple black-and-white wireframes that show layout but no content are probably not detailed enough. On the other hand, a fully realized web page is more detail than you need. Your prototypes should be somewhere in the middle.

These videos shows usability tests using paper prototypes. They offer a good sense of how detailed a prototype should be:

http://youtu.be/9wQkLthhHKA?t=1m20s

http://youtu.be/ppnRQD06ggY?t=98 (not great quality on this one, but enough to see what’s going on)

One caveat about the level of detail: if you are making a claim that more color, better imagery, better alignment, etc. will produce a better user experience with your site, you will need to provide more detail about those aspects, enough that we are able to recognize and evaluate the claims. In other words, the more important the feature is to your overall design, the more detail you will need to provide.

Writing Design/Evaluation Reports

A design report is a document that summarizes what you did on a design project. It is often used in organizations as a way to document the process and decisions made during a design project. In this class, Assignments #4, #5, and #6 together will form the meat of the design report (the complete report will be your deliverable for Assignment #6). There are many different formats for design reports, and many organizations have more formal processes for creating them, but they have a similar generic structure with three main sections:

Section 1: Describe the problem and background for the project. In a user-centered design project, this will include a lot of information about the stakeholders of the system. This section corresponds to Assignment #4.

Section 2: Describe the design itself and the process through which it was developed. This section corresponds to Assignment #5.

Section 3: Describe the evaluation of the design and any resulting changes. This section corresponds to Assignment #6.

You may also have additional sections including a title page, table of contents, or executive summary at the front, and lists of references, illustrations or appendices at the end.

For a nice guide to writing design reports, check out http://www.me.umn.edu/education/undergraduate/writing/How-to-write-a-Design-Report.pdf. It comes out of a mechanical engineering discipline, but is mostly applicable here. The style of report they describe is more detailed and slightly different from what we’ll be doing (e.g. their prototype description is in the evaluation section, whereas we have it in the design section), but overall it is a good overview.

attachment:

https://drive.google.com/drive/folders/1pSM7wxUr6cZd1FJzQGq-BfVTLgA7zDt2?usp=sharing

Preview the document

Grist

Grist – SciFi Movies

Printable document for Grist – SciFi Movies: 
Grist – SciFi Movies.docx

Actions

1) Create a new database by Importing the file below: 

Please download the excel import data SciFi Movie – Import.xlsxPreview the document to use as an import for this assignment

Import Document into Grist.

Be sure the following column options are as stated below:

  • Movie Number: Column Type – Text
  • Movie Name:  Column Type – Text
  • Year Made:  Column Type – Numeric   /   Alignment – Centered
  • Studio:  Column Type – Text
  • Rating:  Column Type – Integer   /   Alignment – Centered
  • Awards:  Column Type – Choice:  ADM, RBB, GGA, NOA, GTA
  • Length – Minutes:  Column Type – Numeric   /    Alignment – Centered
  • Director Number:  Column Type – Text

2) Rename the Table – Movies

3) Create another table called Directors by adding an empty table.

Add the following columns:

Director Number – Column Type – Reference:  Movies Table and Director Number

Director Name – Column Type – Text

# of Movies Directed – Column Type – Numeric    /    Alignment – Centered

Fill in the fields and data from the table below:

Director Number

Director Name

# of Movies Directed

CRN

Christopher Nolan

10

GEL

George Lucas

18

AYW

Andy Wachowski

11

JSC

James Cameron

22

RTZ

Robert Zemeckis

25

TYG

Terry Gilliam

19

JJA

J.J. Abrams

12

SNS

Steven Spielberg

52

AOC

Alfonso Cuaron

15

AWN

Andrew Niccol

7

IOH

Ishiro Honda

59

PLV

Paul Verhoeven

28

4)  Create a new page for an overview.  Add a widget to new page and select a table for the Movies table with summary data for the Director Number.  Remove the Count and Rating Columns.   

5) Rename the new page in the navigational bar Movie Overview.

6) Add Widget to page and select the card widget for the Movies table with summary data for the Movie Number.  Change the Theme to Blocks.  Customize the card by hiding the count field and moving Length-Minutes to the second row.  You will have 3 fields going across on the 2nd row.

7) Add widget to page and select the chart widget for the Movies table with a summary of data for the Awards.  Change the chart to a pie chart.  Hide all series except for Awards and count.  Customize layout appropriately. 

*When complete, your Movie Overview page should have a Movie summary of the Movies table, a Movies Card widget and a Movies Chart Widget.

8) In the Movies table create a new field name called Movie Rating. 
Column Type – Choice: R, PG and PG-13

Update the rest of the table to meet the data below.

Movie Names

Movie Rating

Aliens 

R

Back to the Future

PG

E.T.

PG

Gravity

PG-13

Godzilla

PG-13

Inception

PG-13

Gattaca

PG-13

Starship Troopers

R

Star Trek 

PG-13

Star Wars

PG

Terminator 

R

Twelve Monkeys 

R

The Matrix

R

9) Add widget to Movies page and select the chart widget for the Movies table with a summary of data for the Movie Rating.  Change the chart to a pie chart.  Hide all series except for Movie Rating and count.  Customize layout appropriately. 

Strategic Integration and Information technology roles and responsibility

Essay Assignment 1: Review the strategic integration section.  Note what strategic integration is and how it ties to the implementation of technology within an organization.

Essay Assignment 2: Review the information technology roles and responsibilities section.  Note how IT is divided based on operations and why this is important to understand within an organization.

The above assignment should be two pages in length (one page for each question) and adhere to APA formatting standards.

Discussion

 

This assignment should include at least two references.

What is the difference between VA(Vulnerability Assessment) and PT(Penetration Testing)? Per enterprise security assessments?

After reading the article, discuss which case study is interesting and why ERM is necessary?

Article:

 

Do,  H., Railwaywalla, M., & Thayer, J. (2016). Integration of ERM with  Strategy (p. 35). Retrieved from Poole College of Management, NCSU  website: https://erm.ncsu.edu/az/erm/i/chan/library/Integration_of_ERM_and_Strategy_Case_Study.pdf

After reading the above week’s article, and any other relevant research you locate, please discuss the following in your main post:.

  • Which case study in the paper was most interesting to you and why?
  • Do you think that ERM is necessary in the contemporary organization and why?

 A substantive post will do the following:

  • Ask an interesting, thoughtful question pertaining to the topic
  • Answer a question (in detail) posted by another student or the instructor
  • Provide extensive additional information on the topic
  • Explain, define, or analyze the topic in detail
  • Share an applicable personal experience
  • Provide an outside source (for example, an article from the UC  Library) that applies to the topic, along with additional information  about the topic or the source (please cite properly in APA 7)
  • Make an argument concerning the topic.

At least one scholarly source should be used in the initial  discussion thread. Be sure to use information from your readings and  other sources from the UC Library. Use proper citations and references  in your post.

Lab 15 HTML

 

  • Review the Multimedia PDF and the Web Development PPT
  • Download the Word document below and follow the instructions
  • HTML Lab
  • ZIP up your HTML file and your image file into a Lab15.zip file
  • Upload the ZIP file to Canvas for grading

3 pages—Assignment 01–will be submitted to Turnitin

This assignment will be submitted to Turnitin®. Please see  Rubrics attached. 

Instructions

It is a responsibility of the global firm to ascertain the level of importance of various aspects of culture. Companies’ operations need to recognize and adjust to the cultural environment. In this week’s Lesson, you will find eight elements of culture. For this assignment, there are four elements of culture that are most important when marketing products and services internationally: language, religion, manners and customs, and aesthetics. Indicate why each is important and provide examples in your response.

Write a paper of 3 pages, typewritten in double-spaced APA format (Times New Roman, 12 pt. styles), page margins Top, Bottom, Left Side and Right Side = 1 inch, with reasonable accommodation being made for special situations and online submission variances.

In your response, make certain that you include at least two outside references from search engines or scholarly sources from the APUS Online Library.

Your paper will be automatically submitted to Turnitin in the assignment dropbox. Originality reports will be returned to the faculty and student. Multiple submissions are allowed. For full credit, make sure that your Similarity Index does not exceed 20%.

In the Assignment dropbox, please attach your paper as a file, do not copy & paste. I will grade and return your file.

Please see  Rubrics attached.