IFSM201 Case Study Part 1, 2 and 3

01

Open and save an MS Word document with the following name:

“Student’s Last Name Specs”
Example: Smith Specs

Set normal text to Arial, 12 point.

Create a Title Page which shows title, your first and last name, course and due date.

0.2

This is the font in normal paragraphs. Heading and title fonts may be a larger size.

The title must be

Specification for the Director
by
your name
the course
due date.

Center the title on the page

02

Use a footer to create page numbers for all pages except the title page.

Place the page numbers on the right side of the footer.

0.2

Take a look at the Sample Tables for ideas on how to best lay out your tables.

03

Table #1 - Create a table that identifies the manufacturer, type (desktop, laptop, tablet) and model of computer being recommended for purchase.If you are recommending a computer that is being built from components rather than purchased as a unit, indicate that in the type column. The table must be labeled “Recommended Computer.”

0.5

Remember that the requirement is to identify and configure only a single computer.

04

Table #2 - Create a table that shows all of the required Hardware devices. The table must be labeled “Hardware Devices.” User requirements are posted in the case study.

0.1

Remember to include any items that might be integrated with the system you have chosen.The table should have all the necessary columns, rows, and column headings to show the following:

05

· Input Devices – Identify each device type, including make/model, and show which specific user requirements are met.

0.5

For example, you might include the following information in your table to describe one Input Device:
Input Device – 1.2 Megapixel video camera, model, from xxxx supplier.
Requirements met – create video files.

06

· Output Devices – Identify each device type, including make/model, and show which specific user requirements are met.

0.5

Make, model and description are required.

07

· Communication Devices – Identify each device type, including make/model, and show which specific user requirements are met.

0.5

Make, model and description are required.

08

· Storage Devices – External (including portable) storage devices and show which specific user requirements are met

0.5

Make, model and description are required.

09

· Other Peripheral Devices – Identify each device type, including make/model, and show which specific user requirements are met.

·

0.5

Make, model and description are required.

10

Table #3-Create a table that shows the various required System Unit Components. The table must be labeled “System Unit Components.”

0.1

The System Unit Components must reflect the type of system identified for purchase by the Hardware devices table.

The table should have all the necessary columns, rows, and column headings to show the following:

11

· Processor – Include type and clock speed and state how processor type and clock speed meets the Director’s specific user requirements.

0.5

Identify manufacturer – Intel, AMD, Apple, etc.

12

· RAM – Include type and amount and state how RAM type and amount meets the Director’s specific user requirements.

0.3

Type and amount are sufficient.

13

· Adapter Cards – Identify each type and show which specific user requirements are met.

0.5

Types sufficient unless an unusual adapter card is required.

14

· Ports – Include types, how many of each type, and show which specific user requirements are met.

0.3

Types and number are sufficient. Be sure to include all that are integrated with the system you are configuring.

15

· Storage Devices – Identify internalsystem unit storage devices, size of hard drive, and state how each storage device and the hard drive size recommended meets specific user requirements.

0.5

Types and sizes are sufficient. Remember, this is internal storage, including the hard drive.

16

Table #4-Create a table that shows the various required Application Software. The table must be labeled “Productivity Software.” Specific product names MUST be listed.

0.1

Review the user requirements to ensure that software has been selected to meet each need.
The table should have all the necessary columns, rows, and column headings to show the following:

17

• Identify types of software, recommended specific product names, and how this software meets specific user requirements.

2.0

Be sure to include product name and version.

18

Table #5-Create a table shows that the various required System Software. The table must be labeled “System Software.” Include one operating system and at least three utility programs.

0.1

The table should have all the necessary columns, rows, and column headings to show the following, and each component must be tied to the computers in your Recommended Computers table:

19

· Operating System – Identify a specific operating system and version

0.75

Identify company supplying the OS (Intel, AMD, Apple, etc.). Include version #. Identify to which computer(s) this component will be assigned.

20

· Utility Programs – Include at least 3 utility programsthat do not typically come installed with the OS and state how each utility program meets specific user requirements.

0.75

Identify utility programs that do not come installed with the OS. For example, choose and include a particular security program such as Norton or McAfee, etc.

21

Table # 6-Create a table that shows the required Internet connectivity and Web-hosted applications and services. The table must be labeled “Internet Connectivity & Web Services”

0.1

Review what specific user requirements related to online work or file sharing that have been included in the Director's list of requirements.
The table should have all the necessary columns, rows, and column headings to show the following:

22

· Identify the specific ISP that should be used for Internet connectivity.

0.5

ISP type meets specific user requirements in the case study.

23

· Identify the specific Web services that should be used.

0.5

State how the Web services that were identified meet specific user requirements in the case study

24

Write a brief two-paragraph narrative that categorizes the user type, identifies the category of PC (s) required, and summarizes your recommendations.

NOTE: There are 13 office requirements listed in the case study. Each one will need the appropriate hardware and software that will improve the productivity in the office. The users are the people working in the office that will be affected by the 13 requirements. The type of PC could be anything from a laptop to a server. It is essential that you connect the requirements with your recommendations.

1.0

Two well-written, concise and organized paragraphs not to exceed one-half a page. Place narrative after the title page but before the tables.

25

Grammar, syntax, punctuation, spelling, and APA formatting as necessary. Points WILL be deducted if errors are found in the summary or in the tables.

0.5

Proofread your entire file before submitting.

TOTAL

01

· Launch MS Access and open a Blank Access database.

· Save the new database with the following name:

“Student’s First Initial Last Name Provider Information”
Example: JSmith Provider Information

0.1

Create a table with all the following fields and settings: (each letter indicates a separate field)

02

1. Provider ID (autonumber)
   Set as primary key and is auto number

0.1

The Provider ID field must be set as the primary key (*). If the Provider ID is not the primary key, 0.05 points will be deducted. If you have properly set the Provider ID field as the primary key, it will be numbered automatically (Auto Number).

03

B. Provider's Company Name (text)

0.1

04

C. Provider Contact-First Name (text)

D. Provider Contact-Last Name (text)

0.2

05

E. Billing Address (text)
(this is the street address)

F. City (text)

0.2

06

G. State (text—limited to 2 characters)

0.15

07

H. Zip Code (text—limited to 5 characters)

0.15

08

I.Phone number – area code (text—limited to 3 characters)

J. Phone number (text)
(Use xxx-xxxx format when entering the data)

0.25

09

K. YTD Orders (currency)
(At least one record must contain an amount when you enter the data)

0.1

10

L. Preferred Provider (Yes/No)
(Criteria must be provided in the Description field (Design View) which identifies what constitutes a Preferred Provider. Base your criteria on YTD amounts.)

0.15

11

All fields names are fully visible in Datasheet View (no truncated entries)

0.1

12

Name the table as follows: Provider Information Table

0.1

13

Use the Form Wizard to create a form that uses all the fieldsfrom the Provider Information Table.

0.2

Let the Form Wizard guide you through the completion of the form

Use a Columnar layout.

14

Select a theme – do NOT use the default theme which is Office.

0.1

15

Name the form as follows:

Provider Data Entry Form

0.1

You should be finished with the form at this point. It is best if you allow the Form Wizard to open the form to view and enter information.

16

Ensure that all field names are fully visible in each field in Form View (no truncated entries)

0.1

17

Use the form to enter data into the table

· Enter all the appropriate data for five providers (such as Best Buy, CDW, and CompUSA.)

· Mark at least one Provider as a Preferred Provider based on the criteria you identified in the Preferred Provider field.

It is important to complete all data entry prior to moving on to create the report. You should also use the table to manually review and audit all entries to ensure accuracy and consistency prior to report setup. If find any data entry errors or inconsistencies, simply go back the item in the form and make the appropriate corrections. Missing data or including data that should be ignored will result in a deduction.

1

When you are finished, the Provider Information Table should contain all the contact information for the providers. You may need to create fictitious information for contact names –other field information should be available from the provider's company website. For YTD Orders simply input fictitious values. Marking at least one provider as Preferred should be based on criteria for YTD Orders (those that exceed a specified YTD amount that you determine). That criteria must be included in the field Description for Preferred Provider.

The form will automatically populate the Provider ID for you because this is your primary key. Provider's Company Name will be your five providers.

18

Ensure that all entered datais fully visible in each field in Datasheet View of the Provider Information Table (no truncated entries)

0.1

19

Use the Report Wizard to create a report from the database that uses the following fields, presented in the following order from left to right in the final report:

· Provider's Company Name

· Provider Contact First and Last Name

· Complete Address (Street, City, State, Zip)

· Phone Number (including area code field)

0.3

Let the Report Wizard guide you through the completion of the report.
Use Landscape orientation

Make sure that you do not select the Provider ID field.

20

· Set up the report to be sorted by Provider Contact-Last Name.

Ensure that the order of the fields is still the same as identified above: company name, first name, last name, address, phone number.

0.1

21

· Ensure that all field names and entered dataare fully visible in all areas of the report (no truncated entries)

· Select an appropriate style that improves readability

0.1

You must apply a style OTHER THAN the default style which is the Office theme.

22

· Name the report as follows:

Provider Contact Information

Your report will include information for all your Providers.

0.1

After you name the report, you should allow the Report Wizard to let you preview the report. If you created the report correctly, you should see the items sorted alphabetically by Provider Last Name. (Only one Provider Contact Information report should be submitted for grading or points will be deducted.)

23

Create mailing labels for the provider list: Include

• Contact person’s full name
• full Provider's company name
• full mailing address.

Check the look of the report in Print view.

1

Be sure to view your mailing labels to ensure correct spacing of the name, address. etc. The format should appear as a typical address on an envelope.

24

· Save this report as "Provider Mailing Labels."

0.1

25

Create an MS Word document.

· Set it to

double space

normal text

Arial, 12 point.

Save the document as:

“First Initial Last Name Access Questions”
Example: JSmith Access Questions

Create a Title Page which shows your project title, your first and last name, the course id and the due date. See comment to the right for the project title.

In your MS Word document, answer both of these questions in 4 to 5 well written sentences.

Questions:

1. Your Director has approved the purchase of the computers that you recommended in your response to the Case Study – Part 1, the specification for the computers. The data in this database you created here is rather limited. What fields would you add to the database you created in this project that would help you in choosing a supplier or suppliers to use to fulfill the purchases?

2. Could you use an Excel spreadsheet to replicate the same activity that you completed for the Access database project? What advantages or disadvantages might using Excel have over using Access in this Case Study?

0.3 points of the score for this element is assigned to writing mechanics.

0.1

0.1

0.5

0.3

The title must be

PC Specifications for the Director
by
[insert your first and last name]
[insert course id]
[insert due date]

When submitting your project, be sure to attach BOTH the Access database (the table, form, and 2 reports will be included in the single database file) AND the Word document which contains answers to the two questions above.

TOTAL

6

01

Open a new, blank Power Point presentation file.

Save the Presentation using the following name:

“Student’s First Initial Last Name Presentation”
Example: JSmith Presentation

0.1

02

Select a design/theme template to define the format and background for your presentation slides. Do NOT use the default theme (Office). Also ensure that the theme you select or any other formatting changes you make do not make the presentation difficult to view on a computer.

0.1

From this point forward, let the design template automatically set font and style formats. This is the beauty of using a standard template over one that you designed yourself.

03

Slide 1: This is your Title Slide.

Select an appropriate title and subtitle that clearly conveys the purpose of your presentation.

0.25

No speaker notes required

04

Slide 2: Title this slide "Agenda for Today's Meeting"

Add the following bullet points for the agenda:

• Introduction/Overview
• Hardware Devices
• System Unit Components
• Productivity Software
• Summary of Recommendations

0.5

This is an outline of your presentation.

Your speaker notes will include your own introduction. Talk very briefly about the agenda.

05

Slide 3: Title this slide "Purpose of Presentation and Overview"

Identify audience and the reason for the presentation and provide a bulleted overview of what's to come. Include here the name and type of computers you are recommending (e.g., Dell Inspiron 1500 or Apple Mac desktop)

Use bullet points, not complete sentences.

0.5

Use the speaker notes feature to help you discuss the bullet points (four complete sentences minimum).

06

Slide 4: Title this slide "Hardware Devices."

Write and add a minimum of 3 – 5 bullets that best illustrate how the Hardware devices satisfy the requirements. You will summarize the hardware devices here, pointing out major components or differences in major components if more than one type of computer is being recommended. The devices include input, output, communication, storage, and "other."

0.5

Use the speaker notes feature to help you discuss the bullet points (four complete sentences minimum).The speaker notes should address the requirement met.

07

Slide 5: Title this slide "System Unit Components and System Software"

Write and add a minimum of 3 – 5 bullets that best illustrate how the System Unit Features satisfy the requirements. . You will summarize the system unit components here, pointing out major components or differences in major components if more than one type of computer is being recommended. Include information on the system software also (OS, utilities, etc.)

0.5

Use the speaker notes feature to help you discuss the bullet points (four complete sentences minimum). The speaker notes should address the requirement met.

08

Slide 6: Title this slide "Productivity Software."

Write and add a minimum of 3 – 5 bullets that identify the recommended application software and illustrate how the Application Software satisfies the requirements. You will summarize the software components here, pointing out major components or differences in major components if more than one type of computer is being recommended.

0.5

Use the speaker notes feature to help you discuss the bullet points (four complete sentences minimum). The speaker notes should address the requirement met.

09

Add a relevant graphic that enhances text on the Productivity Software slide (slide 6). If a photo is used, be sure to cite the source.

0.2

10

Slide 7: Title of this slide is "Internet Connectivity and Web Services."

Write and add a minimum of 3 – 5 bullets that best illustrate how the Internet Connectivity satisfies the requirements. You will identify the ISP and summarize the web services here, pointing out major components or differences in major components if more than one type of computer is being recommended.

0.5

Use the speaker notes feature to help you discuss the bullet points (four complete sentences minimum). The speaker notes should address the requirement met.

11

Slide 8: Title this slide "Summary of Recommendations"

Write and add 3 – 5 bullets that best illustrate why this is the best solution or supports the purpose you’ve defined for your presentation.

0.5

Use the speaker notes feature to help you discuss the bullet points (four complete sentences minimum).

12

Slide 9:

Add a Title Only slide. Type "Questions & Next Steps" in the title section. Move the title box so that is it centered on the slide (horizontally & vertically).

0.2

No speaker notes required

13

Create a footer using "Courtesy of Your Name" so that is shows on all slides including the Title Slide.

0.3

Replace the words "Your Name" with your actual name.

14

Create a footer for automated Slide Numbers that appears on all slides except the Title Slide.
Ensure that your name does appear on every slide, but the page numbers start on slide #2. This will involve slightly different steps to accomplish both.

0.35

Depending upon the theme you have chosen, the page number or your name may not appear in the lower portion of the slide. That is ok.

15

Apply a transition scheme to all slides.

0.2

One transition scheme may be used OR different schemes for different slides

16

Apply an animation on at least one slide.The animation may be on text or on a graphic

0.3

17

Proofread and Spellcheck your presentation.

Review again for any grammatical, punctuation or spelling errors. See the rubric for point deductions on errors.

0.5

Presentation should be well-organized with appropriate amount of text per slide.

TOTAL

6