need help for this

 Hide Assignment InformationInstructions

This assignment will address CO1: Create communication documents using assigned software applications.

The scenario:

All That Glitter Jewelry is considering an expansion of the company website to sell more merchandise. Wanda Delana, the US Sales Director, has asked you to complete a business letter for a proposal.

For this assignment, you will need the following files:

New blank Word document  

You will save your files as:

Lastname_Firstname_Memo x

1. Create a memo in Microsoft Word®  (preferably)

From: All That Glitter Jewelry

          12589 Crystalline Lane

          Paris, Texas 78956

1. Address the memo to Michael Cavern, President, 53300 Francis Street, Wilmar, Delaware 45678
2. Add the current date
3. Subject: Web site expansion
4. Add the following content (cut and paste this content): 

The All That Glitter Jewelry Web site has been more successful than we originally anticipated. We had planned to expand the Web site late next year; however, considering the success we have seen, we would like to move up the expansion date.

The following worksheet and chart highlight the projected sales data for the first four quarters that the expanded Web site is in operation:

1. Create a table with the following information:

All That Glitter Jewelry  

Projected Web Site Sales

Quarter                       Low End Sales          Expected Sales         High End Sales

First Quarter               3500                           12500                          17500

Second Quarter          15000                          21000                          19000

Third Quarter             13750                          16750                          23750

Fourth Quarter           10000                          25000                          35000

Totals                        

1. Add formulas to calculate totals of each column in the table.
2. Create a 3-D Cluster Chart containing the data in the chart (graph)- see the video in the Week 1 Lesson, Reading and Resources area. Add chart title and the legend information as written in the table (without the total row).

Upload the completed assignment files in the Assignment area.

• Special Instructions: Use the Supporting Materials provided in the Week 1 Lesson, Reading and Resources area as illustrated below to complete the project.
• Grading: Please review the rubrics for particulars.

ITCC200 Week 1 Assignment (JAN 2024)
Course: ITCC200 D001 Winter 2025

Criteria
Exemplary
25 points

Accomplished
21.25 points

Developing
18.75 points

Beginning
13 points

Did Not

Attempt
0 points

Criterion
Score

Create a

Word

memo

with

provided

data

/ 25

Create

table

with

provided

data

/ 25

Insert

Sum

function

in table

/ 25

The memo

contains

appropriate

text and

objects and

is formatted

to

create a

professional

appearance

Most text is

appropriate,

but at least

one object is

missing, or

the

formatting

does not

create a

professional

appearance

Some text is

inappropriate,

but at least

one object is

missing, or

the

formatting

does not

create a

professional

appearance

Most text is

inappropriate,

and at least

one object is

missing, or

the

formatting

does not

create a

professional

appearance

Student

failed to

address this

item.

The table is

created and

displays data

appropriately

The table is

created, and

most data

displays

appropriately

The table is

created, and

some data

displays

appropriately

The table is

created, but

the data does

not

display

appropriately

Student

failed to

address this

item.

The SUM

function is

inserted, and

all

values

display

correctly

The SUM

function is

inserted, but

not all values

display

correctly

The SUM

function is

not inserted,

but values

displayed

correctly

The SUM

function is

not inserted,

but not all

values

displayed

correctly

Student

failed to

address this

item.

Total / 100

Overall Score

Criteria
Exemplary
25 points

Accomplished
21.25 points

Developing
18.75 points

Beginning
13 points

Did Not
Attempt
0 points

Criterion
Score

Create

3-D

Cluster

chart

from

table

/ 25The 3-D

Cluster chart

is created

and displays

data

appropriately

The chart is

not a 3-D

Cluster chart

or does not

have a chart

style applied,

but displays

data

appropriately

The chart is

not a 3-D

Cluster chart

or does not

have a chart

style applied,

but partially

displays data

appropriately

The chart is

not a 3-D

Cluster chart

or does not

have a chart

style applied,

and does not

display data

appropriately

Student

failed to

address this

item.

Exemplary
90 points

minimum

Accomplished
80 points

minimum

Developing
70 points

minimum

Beginning
60 points

minimum

Did Not

Attempt
0 points minimum