SOLUTION: ACCT 2000 CSB Student Attendance and Score and Students Final Grade Worksheet

Course name and number
Purpose
Designer
Date
Instructions
ACCT 2000, Accounting I
Record student attendance/score and student’s final grade.
Xin Tang
2/3/2021
Record the class status in the “Dtae” header of each column, and enter X for
total number of absences will be calculated by the function settings in the “T
lumn, and enter X for the missing students. At the end of the semester, the
ction settings in the “Total Absences” column.
Date
students Name
Abdolell, Samir
Addah, Kekeli
Adderley, Joseph
Andersson-Hudson, Anna
Asare Adjei, Ama
Blinn, Logan
Burke, Mathew
Cox, Sebastian
Egbesola, Olatomiwa
George, Amal
Henry, Cassey
Hood, Isaiah
Kaur, Arshleen
Li, Shuai
MacDonald, Brenna
Muntzar, Romman
Ofori-Attah, Kwame
O’Neil, Rebecca
Rivera, Elyzel
Scribner, Johnathan
Shearer, Shawn
Shreekumar, Saurabh
Tang, Xin
Wang, Ziqi
Williams, Abdiel
2/1/2021
absence days
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2/2/2021
2/3/2021
2/4/2021
2/5/2021
2/6/2021
2/7/2021
2/8/2021
2/9/2021
2/10/2021
2/11/2021
2/12/2021
2/13/2021
2/14/2021
2/15/2021
2/16/2021
2/17/2021
2/18/2021
2/19/2021
2/20/2021
2/21/2021
2/22/2021
2/23/2021
2/24/2021
2/25/2021
2/26/2021
2/27/2021
2/28/2021
assignment grade
students Name
Abdolell, Samir
Addah, Kekeli
Adderley, Joseph
Andersson-Hudson, Anna
Asare Adjei, Ama
Blinn, Logan
Burke, Mathew
Cox, Sebastian
Egbesola, Olatomiwa
George, Amal
Henry, Cassey
Hood, Isaiah
Kaur, Arshleen
Li, Shuai
MacDonald, Brenna
Muntzar, Romman
Ofori-Attah, Kwame
O’Neil, Rebecca
Rivera, Elyzel
Scribner, Johnathan
Shearer, Shawn
Shreekumar, Saurabh
Tang, Xin
Wang, Ziqi
Williams, Abdiel
lowest grade
highest grade
avarage grade
median garde
range grade
assignment
project
midterm exam
final exam
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
0
10%
10%
30%
50%
0
0
0
0
0
total asignment greade
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
program grade
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
#DIV/0!
#DIV/0!
#NUM!
#NUM!
#NUM!
#NUM!
#NUM!
0
0
#NUM!
#NUM!
0
0
0
0
0
0
0
0
0
program grade
midterm exam grade
final exam grade
grade
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
#DIV/0!
0
#DIV/0!
0
#DIV/0!
0
0
#NUM!
0
#NUM!
0
#NUM!
0
0
0
0
0
0
0
0
INTE/CMPS 2245 ASSIGNMENT #1
Section 2, Winter 2021
Due Date: Part A: Monday, January 25, 2021
Remaining parts: February 1, 2021
Upload each file to the appropriate dropbox in Moodle. Enter all formulas so they can
be copied down a column or to the right. Proofread and spell check your work.
Bonus: Add a headshot image of yourself to your Moodle profile. Also due January 25.
Part A: Sales Comparison and Projection
Assume that you are employed by Chocolate Magic, a large company that sells specialty
chocolate gifts for home and office delivery. You will use Excel to analyze sales for the
2020 Christmas season and plan for this year.
1.
Open the file Christmas Season.xlsx. Review this file to understand the purpose of
the spreadsheet. Save the file as Christmas Season YourFirstName.xlsx (where you
replace YourFirstName with your first name).
2.
Insert one blank row after the title and add this subtitle in Row 2: Sales Analysis
by Your FirstName LastName.
3.
Center the title and subtitle over the width of the table.
4.
Insert two blank rows after the last gift item; and insert two blank rows after the
total row.
5.
To your list of chocolate gift items, add two more chocolate gifts. Estimate the
data for each, but it should be reasonable based on the other items you sold. (Be
creative or consult a website.)
6.
Center the column headings over each column and set them to wrap as needed.
7.
Bold the title, subtitle, column headings and the labels “Total” and “2020
Summary.”
8.
Use a 14-pt font for the title and subtitle; use a 10-pt font for everything else.
Change the font/typeface for the entire worksheet, ensuring that it is still readable.
9.
Complete the calculations using this information:
a.
Column G: the 2020 sales income (in dollars) from each gift item
b.
Column H: the percentage of the total income that came from the sale of each
item in 2020
1
c.
Column I: the quantity of each item you would sell this year if the quantity of
sales increased by the percentage shown below the main table
d.
Column J: the projected income for 2021, assuming your unit prices remain
the same
e.
Total row: complete as appropriate
10. Format all percentages to be percentage format with one decimal place.
11. Format with commas and dollar signs in the appropriate places. Use two decimal
places for money columns and zero decimal places for quantity columns.
12. Enter functions in the appropriate cells in Column B to calculate the values for the
2020 Summary.
13. Put a border around all cells containing summary information (not each cell), and
apply a light colour fill. Format the numbers appropriately.
14. Name the worksheet Christmas.
15. Put border lines above and below the column headings and above and below the
total row. Note that the line below the total row should be a double underline.
16. Create a header that contains your name and the date at the right margin. This
date should not change if the spreadsheet is printed on another day.
17. Create a footer that contains the worksheet name at the left margin, and at the
right margin, the complete path to your file.
18. Center this worksheet horizontally and vertically with landscape orientation.
19. Adjust the width of the columns and height of rows to ensure that all words are
readable and set the spreadsheet to fit on one page—letter or legal size.
20. After all other steps have been completed, copy the worksheet and name it
Projection 2. You decide that your percentage increase is low. Change it to a
higher percentage. Hint: A good approach will mean that you do not need to
change the formula in your table.
Part B: Complete Module 1 Case Problem 2 on pp. EX 1-63 & 1-64 of your
textbook. In addition, follow the instructions below:


Improve the table design by entering the Report date (with a label) in Columns A
and B. Keep the same date as in the original workbook. Edit the formula that
calculates Days of Employment; then delete the Report Date column.
In Columns A and B, add additional summary information to summarize the
number of employees per performance rating. Hint: Verify your formulas by
2


comparing the total number of employees in this range with a previous
calculation.
Format the summary table(s).
Format the employee data. Beginning in Column D, format the column headings
so that they wrap and stand out from the data below. Then autofit all columns.
Part C: Sales Report
You have been asked to assist the manager of FrostiWear to complete a workbook that
tracks sales for 2020 for three new products. FrostiWear operates out of five locations
in Atlantic Canada.
Open FrostiWear.xlsx and save it as FrostiWear YourFirstName.xlsx.
In the Documentation worksheet, fill in cells B3:B5.
The Sales worksheet lists, by month, the quantity of items sold of each of the three
new products. Replace the months 1-12 with words or abbreviations.
4. In Column C, the first region is identified as “Region 1.” Change the column
headings in Columns D to G to include the word “Region” as well as the number.
5. Calculate the totals by region and month.
6. Format the numbers for commas but no decimal places.
7. Center the title and subtitle over the width of the table. Apply the Title cell style to
the title, increase the size to 26 points and bold it. Apply the Heading 4 cell style to
the subtitle and increase its size to 16 points.
8. Format the range A6:A19 in this way: merge and center, middle align, rotate the
text up, apply the Accent1 cell style, change the font size to 18 points and bold.
With the Format Painter, copy these formats to the relevant ranges for the other
two products.
9. Apply the Table Style Medium 2 to the first table, excluding Column A. Turn off
banded rows. Center the column headings, and turn off the filter arrows. Apply a
Standard yellow fill colour to the total rows and bold this range. Repeat this step
for the other two tables.
10. Change the Office theme to a different one and select a new color theme that
works well with your data. Ensure that there is sufficient contrast between the
data and the colours you choose.
11. Apply data bars to the total column in each table. Set the type to go from the
lowest value to the highest value.
12. Apply conditional formatting to the regional data to highlight sales quantities below
300. In Row 4 add a legend.
1.
2.
3.
3
13. Insert page breaks at the end of each table and apply other page formatting so
that this worksheet will print on three pages. Set rows 1 to 4 to repeat at the top
of each page.
14. In a header using two lines, indicate the name of the theme and colour theme you
chose. (Theme: ___ Colour theme: ___)
15. In a footer, display the filename at the left and the page number at the right in this
format: Page X of Y.
16. Return to the Documentation worksheet and apply formatting consistent with the
formatting on the Sales worksheet.
Part D: Grade Book
Assume that you have been asked to set up a grade book for a professor who is
teaching an accounting class (ACCT 2000, Accounting I) this semester at MSVU. The
class meets twice a week on Mondays and Wednesdays. For this assignment, include
three worksheets and follow the guidelines below. Throughout the semester, we will
make enhancements to the workbook. Use a relevant file name, but also include your
first name as part of the file name. Later when you edit the workbook, your filename
should reflect that it is a different version than your original file.
Attendance : Prepare a worksheet to record attendance for the entire semester. Plan
for 24 students. Names may be copied from our class list (available from a class file),
or you may make them up. Use “date math” to enter the class dates as column
headings. Enter a function to calculate the number of times each student is absent.
Format this worksheet to be easy to read on the screen and in hardcopy.
Docum entation : At the beginning of this workbook, insert a Documentation
worksheet. Include the following information: Course name and number, purpose of
the workbook, your name as the designer, the creation date and instructions for
entering the attendance data. For example, tell the professor how to record attendance
so that your function to calculate absences will work. Apply simple formatting to the
worksheet. Remember to use separate cells for labels and for data.
Grades : Copy the attendance worksheet to a new worksheet so that you have the
names from the previous worksheet and any other formatting/text you wish to
duplicate. Rename the worksheet to fit its purpose. On this worksheet, plan the
structure for two tables: the main table will record and calculate grades and the second
table will provide summary data for the professor. Use the information below to set up
the table structure (row and column headings), but do not enter formulas or functions.
4
The evaluation is based on the following for this semester, but your workbook design
should make it easy to adjust the percentages in the future.
Assignments
Project
Midterm Exam
Final Exam
10%
10%
30%
50%
Details:

The professor plans to enter the grades as follows: Assignments, to be
recorded out of 10, the project to be recorded out of 20, and each exam out
of 100.

Eleven assignments will be given, and the lowest assignment grade will be
dropped.

The final grade should be in numeric form.
Below your main table, create another table to provide summary information for the
professor:

How many students completed each assignment, the project, and exams

The average, maximum, minimum and median grades on each assignment,
the project, and exams

The range of the grades on each assignment, the project, and exams (e.g.
the difference between the highest and lowest grade)
While in Assignment 1 you are not expected to format the grades worksheet, you may
format as you work, if you wish.
Format the Documentation and Attendance worksheets so that hardcopies will be easy
to work with. While no hardcopies should be submitted, I recommend that you print
each page to ensure that your format is suitable—for others’ eyes as well as your own.
If you do not have access to a printer, look at Print Preview.
5
INTE/CMPS 2245 Assignment 1 Part D Feedback and
Preparation for Assignment 2 Part D
Winter 2021
Name: Xin
Relevant Solution Filename—reflecting the purpose of the workbook  Avoid using an extra
dot in the file name; use only the dot before the file extension
Description
Attendance Worksheet:
• General design, including accommodating 24 students [.75/1] It’s not
necessary to add a row heading as you have done in A1. The column
headings tell us the purpose of the columns.
• Title; clearly identifies course & semester [0/1]
• Date math used for column headings [0/3]
• Correct dates [-.5]
• Took into consideration Caritas Day, Reading Week, & Easter Monday
[-.5]
• Function to calculate absences [0/2] No formula for the first student.
Incorrect range. Your formula does not match the instructions given on
your Documentation worksheet.
• Format [.75/1] A2: Use an initial cap for each word; add an apostrophe—
Student’s
Documentation Worksheet
• Course name and number [.5/.5]
• Purpose of the workbook [1/1]
• Your name as the designer & the creation date [.5/.5]
• Instructions for entering the attendance data [0/1] How did you choose
your words for these instructions? Your instructions do not match the
work on the Attendance worksheet. You do not have a column heading
named “Total Absences.”
• Formatting [.5/1] Left align the date. The instructions should be
formatted in Col. B, not merged with 7 extra columns. Apply formatting
to make this easy to read if it were printed.
Grades Worksheet Before submitting this workbook again, apply some of my
comments above to this worksheet. Spell check.
• Includes names from Attendance worksheet [.5/.5]
• Worksheet named clearly [.5/.5] The plural form would be better:
Grades.
• Main table [1/3] Review the instructions. No formulas should appear in
this worksheet at this time. -1.5
1
Your
Pts Score
8.0
.50
4.0
2.50
7.0
2.00
Description
o Column headings Check P1—wrong word. -.25 Use only one font
size in the table, including column headings. Use initial caps.
o Row headings
o Appropriate number of columns Based on the format, it is difficult
to see if you have the right number of columns. Merge cells to use
braced headings, where appropriate. What is the purpose of Col.
V, which has no column heading? -.25
• Summary table [0/3] You were asked to create a second table. -1 That
means keeping a blank row and/or column between tables. No formulas
or functions should be in this worksheet yet. -1.5
o Column headings
o Row headings Use initial caps for the row headings.
o Accommodates summary of the number of students completing
each course component, average, maximum, minimum, median,
range Reword “range grade”—possibly use Grade range.
Ready to Print
• Page formatting applied to Documentation and Attendance
worksheets: reasonable number of pages, appropriate font size, page
numbers used if multiple pages, course is identifiable on all pages
TOTAL POINTS:
Pts
Your
Score
2.0
.00
21.0
5.00
Xin, review my comments carefully. If you would like to speak before you submit the next part
of this case, please contact me. I’m happy to help.
Assignment 2 Part D Instructions:
• Review feedback on Assignment 1 Part D. Check with me if you have any questions.

Refer to Assignment 1 Part D instructions and add the formulas/functions to complete
both tables on the Grades worksheet. Enhance your original design, if needed, as you
complete these steps. Keep in mind the best practices covered in class. Format the cells
to show one decimal place for all grades (data and calculations).

Enter a sufficient amount of “fake” data so that you may test your formulas.

Edit the Documentation worksheet as follows:
o Below the creation date, insert a row to reflect the date you are updating this
workbook.
o Add instructions about how the professor should enter data in the grades
worksheet in order for the calculations to work properly. Include how missed
assignments should be recorded.

Format the Grades worksheet to be readable and professional in appearance on the
screen and in hardcopy.
2

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Our Basic features
  • Free title page and bibliography
  • Plagiarism-free guarantee
  • Unlimited revisions
  • Money-back guarantee
  • 24/7 support
Our Options
  • Writer’s samples
  • Expert Proofreading
  • Overnight delivery
  • Part-by-part delivery
  • Copies of used sources
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

AcademicWritingCompany guarantees

Our customer is the center of what we do and thus we offer 100% original essays..
By ordering our essays, you are guaranteed the best quality through our qualified experts.All your information and everything that you do on our website is kept completely confidential.

Money-back guarantee

Academicwritingcompany.com always strives to give you the best of its services. As a custom essay writing service, we are 100% sure of our services. That is why we ensure that our guarantee of money-back stands, always

Read more

Zero-plagiarism tolerance guarantee

The paper that you order at academicwritingcompany.com is 100% original. We ensure that regardless of the position you are, be it with urgent deadlines or hard essays, we give you a paper that is free of plagiarism. We even check our orders with the most advanced anti-plagiarism software in the industry.

Read more

Free-revision guarantee

The Academicwritingcompany.com thrives on excellence and thus we help ensure the Customer’s total satisfaction with the completed Order.To do so, we provide a Free Revision policy as a courtesy service. To receive free revision the Academic writing Company requires that the you provide the request within Fifteen (14) days since the completion date and within a period of thirty (30) days for dissertations and research papers.

Read more

Privacy and Security policy

With Academicwritingcompan.com, your privacy is the most important aspect. First, the academic writing company will never resell your personal information, which include credit cards, to any third party. Not even your lecturer on institution will know that you bought an essay from our academic writing company.

Read more

Adherence to requirements guarantee

The academic writing company writers know that following essay instructions is the most important part of academic writing. The expert writers will, therefore, work extra hard to ensure that they cooperate with all the requirements without fail. We also count on you to help us provide a better academic paper.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2020 at 10:52 AM
Total price:
$26
The price is based on these factors:
Customer Academic level
Number of pages required
Urgency of paper