Grantham Univercity Education Oriented Websites Research Paper View the two worksheets and complete them in fullPLEASE MAKE SURE THAT THERE IS NO PLAGIARIS

Grantham Univercity Education Oriented Websites Research Paper View the two worksheets and complete them in fullPLEASE MAKE SURE THAT THERE IS NO PLAGIARISM AT ALLI need all answers correct please to score well on these two worksheetsThe additional data you need for the two worksheets are attached as well Exercise Pro
2018 Regional Sales to Health Clubs
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Northeast 225794.5 210670.5 183555.3 226634.9
Southeast 126898.1 144865.3 133106.8 155574.8
West
294216.7 247841.5 266774.1
291697
Total Sales
% of Total Sales
Trend
ASSIGNMENT 08
K02 MS Office Applications I
1. Start Excel and open e01_Regional_Sales. Save the presentation using your own name as
Lastname_Firstname_Regional_Sales
2. Change the Theme to Circuit. Set the width of column A to 95 Pixels and the widths of
columns B:H to 110 pixels.
3. Merge and center the title across columns A:H. Apply the Title style. Merge and center the
subtitle across columns A:H and apply the Heading 1 Style.
4. Apply Center formatting to all seven column titles. Apply the Heading 4 Cell Style.
5. Use the Quick Analysis tool to Sum the Quarter 1 Sales. Copy across to the remaining
quarters.
6. Use the Quick Analysis tool to Sum the Northeast Sales for the four quarters. Use the second
sum option which will display the column selection in yellow. Copy the formula down to cell
F7.
7. Apply the Accounting Number format to the first row of sales figures and to the total row.
Apply the comma style to the remaining sales figures. Format the totals in row 7 with the
Total Cell Style.
8. Insert a new row 6 with the row title Midwest Add the following figures for each quarter:
110975.45, 119764.92, 101549.40, and 120598.14 Copy the formula from cell F5 to cell F6.
9. In cell G4, construct a formula to calculate the Percent of Total Sales for the first region.
Copy the formula down to the remaining regions. To the completed percentages, apply
percent style with two decimal places. Center the percentages.
10. In the range H4:H7 insert line Sparklines. Do not include the totals. Show the Sparkline
markers. Apply the Sparkline style Colorful 1.
11. Insert a Clustered Column Chart that represents the sales figures for the four quarters. The
regions should be the x category and quarters the legend.
12. Apply Chart Style 7 and Color 2 under Colorful. Position the chart so that the upper right
corner of the chart aligns with cell F10. Change the chart title to 2018 Regional Sales to
Health Clubs
13. Deselect the chart. Change the page orientation to landscape. Center the worksheet
horizontally on the page. Insert a footer with the file name in the left section.
14. Enter the tags of health club, sales. For the subject, type your course name and section
number. Your name should display as the author.
15. Save the workbook. Print a PDF electronic image. Close the file and Excel.
Grading Rubric
Please refer to the rubric on the next page for the grading criteria for this assignment.
TASK
Exemplary
Start Excel and open e01_Regional_Sales. Save the presentation using 5 points
your own name as Lastname_Firstname_Regional_Sales
Student provides a correct
result.
Change the Theme to Circuit. Set the width of column A to 95 Pixels
5 points
and the widths of columns B:H to 110 pixels.
Student provides a correct
result.
Merge and center the title across columns A:H. Apply the Title style.
5 points
Merge and center the subtitle across columns A:H and apply the
Student provides a correct
Heading 1 Style.
result.
Apply Center formatting to all seven column titles. Apply the Heading 5 points
4 Cell Style.
Student provides a correct
result.
Use the Quick Analysis tool to Sum the Quarter 1 Sales. Copy across to 10 points
the remaining quarters. Use the Quick Analysis tool to Sum the
Student provides a correct
Northeast Sales for the four quarters. Use the second sum option
result.
which will display the column selection in yellow. Copy the formula
down to cell F7.
Satisfactory
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
8 points
Student provides a mostly
correct result.
Unsatisfactory
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
5 points
Student provides a weak or
unclear result.
Unacceptable
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
Apply the Accounting Number format to the first row of sales figures
and to the total row. Apply the comma style to the remaining sales
figures. Format the totals in row 7 with the Total Cell Style.
10 points
Student provides a correct
result.
8 points
Student provides a mostly
correct result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Insert a new row 6 with the row title Midwest Add the following
figures for each quarter: 110975.45, 119764.92, 101549.40, and
120598.14 Copy the formula from cell F5 to cell F6.
10 points
Student provides a correct
result.
8 points
Student provides a mostly
correct result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
In cell G4, construct a formula to calculate the Percent of Total Sales
for the first region. Copy the formula down to the remaining regions.
To the completed percentages, apply percent style with two decimal
places. Center the percentages.
10 points
Student provides a correct
result.
8 points
Student provides a mostly
correct result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
In the range H4:H7 insert line Sparklines. Do not include the totals.
Show the Sparkline markers. Apply the Sparkline style Colorful 1.
10 points
Student provides a correct
result.
8 points
Student provides a mostly
correct result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Insert a Clustered Column Chart that represents the sales figures for
the four quarters. The regions should be the x category and quarters
the legend. Apply Chart Style 7 and Color 2 under Colorful. Position
the chart so that the upper right corner of the chart aligns with cell
F10. Change the chart title to 2018 Regional Sales to Health Clubs
10 points
Student provides a correct
result.
8 points
Student provides a mostly
correct result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Deselect the charge. Change the page orientation to landscape.
Center the worksheet horizontally on the page. Insert a footer with
the file name in the left section.
10 points
Student provides a correct
result.
8 points
Student provides a mostly
correct result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Enter the tags of health club, sales For the subject, type your course
name and section number. Your name should display as the author.
5 points
Student provides a correct
result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Save the workbook. Print a PDF Electronic image. Close the file and
Excel.
5 points
Student provides a correct
result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
We offer prize-winning content for your students and a broader range of detailed coverage of chosen
subjects for instructors to use in their lesson plans. Our company has a state of the art web production
team that works behind the scenes to create interactive multi-media content for all of your current and
future needs.
Our company would like to get feedback from you about our websites. We are looking for feedback on
the features that you would like to see for future developments. We also would like to know about
which of our current subjects would be helpful for you to have with interactive web content.
The following is a list of features are available:
Historic interactive timelines
Photos taken on the set during the production of the film
Interactive educational games
Fast facts and flashcards
Quizzes and exams
When you are submitting requests for website development for current films and videos from our
company, please list:
The video below provides a summary of our online content. For further information, please feel free to
contact us at infor@huronproductions.com or call us at (503)-555-0221 during the following days and
times:
Monday-Thursday
9 a.m. to 5 p.m.
Friday 9 a.m. to 2 p.m.
Saturday
9 a.m. to noon
ASSIGNMENT 04
K02 MS Office Applications I
1. Start Word and display a blank document. Display formatting marks and the ruler. Save the
document as Lastname_Firstname_Websites using your first and last name.
2. Type Education Oriented Websites and press Enter. Type Sturgeon Point Productions is
offering website access with each educational video program that we have available, at
no additional cost. Press spacebar and insert the text from the student data file
w01G_Education.
3. Change the line spacing for the document to 1.5 and the spacing after to 6 pt.
4. For each of the four paragraphs that begin with, Sturgeon Point Productions, As educators,
When submitting, and The Video, apply a first line indent of 0.5.
5. Change the font size of the title to 36 and the line spacing to one. Center the title. With the
title selected, display the Text Effects and Typography gallery. Apply the Fill-White, Outline
– Accent 1, Shadow.
6. Click at the beginning of the paragraph below the title. Insert the picture w01_ Media.
Change the picture Height to 2 and the layout options to square. Format the picture with soft
edge rectangle. Change the picture position so that the Horizontal alignment is right relative
to the margin and the vertical alignment is top relative to the line.
7. Select the five paragraphs beginning with Historic interactive timelines and ending with
Quizzes and essay exams. Apply Checkmark Bullets.
8. In the paragraph after the bulleted list, click after the colon. Press Enter to remove the first
line indent. Type a numbered list with the following three items:
The title of the video
The subject and name of the course
Online tools you are interested in
9. Insert a SmartArt graphic at the end of the numbered list. Select the Circle Process. In the
first shape, type Observe In the second, type Network and in the third, type Evaluate
Change the SmartArt color to Colorful Range – Accent Colors 2 to 3. Apply the 3D Metallic
Scene. Change the height of the SmartArt to 1.5 and the width to 6.
10. Change the layout options to square, the horizontal alignment to centered relative to the page,
and the vertical alignment to bottom relative to the margin.
11. Select the days and times at the end of the document and set a right tab with dot leaders at 6”.
12. Click in the blank line below the tabbed list and center the line. Insert an online video. In the
Bing Video Search Box, type Pearson Higher Education Learning and insert any of the
videos. Change the video height to 1.68 and the width to 3.
13. Below the video, insert a Donut Shape. Change the shape height to 1.25 and the width to 2.5.
In the Shape Styles Gallery, apply Subtle Affect – Gray 50%, Accent 3. Change the position
so that both the Horizontal and Vertical alignment are centered relative to the margin. In the
Donut, type Sturgeon Point Productions and press Enter. Type Partnering with Teachers
Change the font size to 12.
14. At the top of the document, insert a text box over the title. Change the height of the text box
to 0.5 and the width to 3.5. Type Sturgeon Point Productions and change the font size to
26. Center the text. Position the text box so that the Horizontal Alignment is centered relative
to the page and the vertical absolute position is 0.5 below the page. With the text box still
selected, display the Shape Fill Gallery. Select Orange, Accent 2. Change the Shape Outline
to Blue Accent 5.
15. Apply a Page Border to the document. Use the Shadow Setting and apply the color Orange,
Accent 2.
16. Change the Top Margin to 1.25 and insert the file name in the footer.
17. Add the tag, website and for the subject type your course and section number.
18. Save the document and close Word.
Grading Rubric
Please refer to the rubric on the next page for the grading criteria for this assignment.
TASK
Start Word and display a blank document. Display formatting marks
and the ruler. Save the document as Lastname_Firstname_Websites
using your first and last name.
Type Education Oriented Websites and press Enter. Type Sturgeon
Point Productions is offering website access with each educational
video program that we have available, at no additional cost. Press
spacebar and insert the text from the student data file w01_Video.
Exemplary
5 points
Student provides a correct
result.
5 points
Student provides a correct
result.
Satisfactory
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
Unsatisfactory
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
Unacceptable
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
Change the line spacing for the document to 1.5 and the spacing after 5 points
to 6 pt.
Student provides a correct
result.
For each of the four paragraphs that begin with, Sturgeon Point
5 points
Productions, As educators, When submitting, and The Video, apply a Student provides a correct
first line indent of 0.5.
result.
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
Change the font size of the title to 36 and the line spacing to one.
Center the title. With the title selected, display the Text Effects and
Typography gallery. Apply the Fill-White, Outline – Accent 1, Shadow.
5 points
Student provides a correct
result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Click at the beginning of the paragraph below the title. Insert the
5 points
picture w01_ Media. Change the picture Height to 2 and the layout
Student provides a correct
options to square. Format the picture with soft edge rectangle.
result.
Change the picture position so that the Horizontal alignment is right
relative to the margin and the vertical alignment is top relative to the
line.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Select the five paragraphs beginning with Historic interactive timelines 5 points
and ending with Quizzes and essay exams. Apply Checkmark Bullets. Student provides a correct
result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
In the paragraph after the bulleted list, click after the colon. Press
Enter to remove the first line indent. Type a numbered list with the
following three items:
The title of the video
The subject and name of the course
Online tools you are interested in
5 points
Student provides a correct
result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Insert a SmartArt graphic at the end of the numbered list. Select the 10 points
Circle Process. In the first shape, type Observe In the second, type
Student provides a correct
Network and in the third, type Evaluate Change the SmartArt color to result.
Colorful Range – Accent Colors 2 to 3. Apply the 3D Metallic Scene.
Change the height of the SmartArt to 1.5 and the width to 6.
8 points
Student provides a mostly
correct result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Change the layout options to square, the horizontal alignment to
centered relative to the page, and the vertical alignment to bottom
relative to the margin.
5 points
Student provides a correct
result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
Select the days and times at the end of the document and set a right
tab with dot leaders at 6”.
5 points
Student provides a correct
result.
Click in the blank line below the tabbed list and center the line. Insert 10 points
an online video. In the Bing Video Search Box, type Pearson Higher
Student provides a correct
Education Learning and insert any of the videos. Change the video
result.
height to 1.68 and the width to 3.
4 points
Student provides a mostly
correct result.
8 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
5 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
Below the video, insert a Donut Shape. Change the shape height to
5 points
1.25 and the width to 2.5. In the Shape Styles Gallery, apply Subtle
Student provides a correct
Affect – Gray 50%, Accent 3. Change the position so that both the
result.
Horizontal and Vertical alignment are centered relative to the margin.
In the Donut, type Sturgeon Point Productions and press Enter. Type
Partnering with Teachers Change the font size to 12.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
At the top of the document, insert a text box over the title. Change
the height of the text box to 0.5 and the width to 3.5. Type Sturgeon
Point Productions and change the font size to 26. Center the text.
Position the text box so that the Horizontal Alignment is centered
relative to the page and the vertical absolute position is 0.5 below the
page. With the text box still selected, display the Shape Fill Gallery.
Select Orange, Accent 2. Change the Shape Outline to Blue Accent 5.
Apply a Page Border to the document. Use the Shadow Setting and
apply the color Orange, Accent 2.
5 points
Student provides a correct
result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
5 points
Student provides a correct
result.
Change the Top Margin to 1.25 and insert the file name in the footer. 5 points
Student provides a correct
result.
Add the tag, website and for the subject type your course and section 5 points
number.
Student provides a correct
result.
Save the document and close Word.
5 points
Student provides a correct
result.
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
4 points
Student provides a mostly
correct result.
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
3 points
Student provides a weak or
unclear result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
2 points
Student provides a poor
result.
World Wide Web
Fle Edit View Help
Go
http://www.
COMPANY NAME
DEX
BRINGING THE FUTURE TO YOU
SEARCH
World Wide Web
World Wide Web
pww.
HOME
COMPANY ACCOUNT SETMASCHCR
GO
CEK
p.
1 ABOUT US
LATEST NEWS
HEALTH WEB TEMPLATE
Get the answers to
ALL your health questions.
PS
EMPLOYMENT
Art Website
SERVICES
Rainbow Colored Theme
TESTI…
Purchase answer to see full
attachment