data and information using industry standard formatting protocols.
data into logical structures and meaningful layouts.
charts, graphs and other visualizations of data.
three-dimensional formulas to calculate data on multiple worksheets.
formulas to ensure accuracy.
Excel and Word into a compound document.
Excel is a
popular application used in many fields and organizations. This program allows
people to work faster, more efficiently, and with greater accuracy, due to its
familiar Office interface, features to improve workflow, and numerous built-in
calculations, amongst many other qualities.
For this assignment you will modify a partially
completed workbook. Some instructions will tell you exactly what you need to
do, while some other ones will give you some creative freedom.
You may work individually or with another student (no more
than two in a group). If you work in a group, you must complete the “Personal
and Peer Evaluation Form”. If the work appears evenly divided then the group
shares the mark. However, marks will be adjusted at the instructor’s discretion
if there appears to be an imbalance of work. Not submitting the evaluation form
results in a 5% deduction for this assessment.
Examine the exercises, tutorials and other provided
materials in Brightspace under their respective modules so that you are able to
utilize the software features appropriately. Several of these will need to be
completely outside of class time, plan accordingly.
It can also be helpful to explore some of the many templates
that are included with Excel. To see them, follow these steps:
Type your search keyword in the textbox at the top
of the window or select File >
New if Excel has already been launched. Type your search keyword.
Choose words such as budget, cost estimate or
Wait a moment for the templates to load.
Click on the template you wish to see.
Repeat as necessary to view other templates.
Quality of Writing:
Ensure that your work sounds professional. Use business language and complete
sentences, and review your drafts several times to make sure there are no
errors in grammar, spelling or punctuation.
If you use any sources in your work:
the content and paraphrase it. Do not just copy and paste, unless it is a short
quote, for example.
IEEE citation. This means you must include in-text citations and a references
section at the end of the document with the full list of sources.
SAIT’s citation guides for more information: http://libguides.sait.ca/ieee
SAIT takes academic misconduct very seriously. Do not:
Intentionally, or unintentionally, use material
from other sources without proper citation.
Share any assessment files in any way, shape, or
form with anyone else.
Submit any work for grading that was given to
you and which is not of your own creation.
Such actions are considered plagiarism and are forms of
academic misconduct. There are three outcomes for a student charged with
offence: Zero mark for the assessment and a letter on file for seven years
offence: Expulsion from SAIT for one academic year
offence: Permanent expulsion from SAIT
To avoid such circumstances:
assessment files yourself from
Do your own work.
cite all sources you have
SAIT’s Student Code of Conduct (AC.3.4.1): http://www.sait.ca/programs-and-courses/full-time-studies/academic-calendar-information/academic-and-institute-regulations
all criteria to earn full marks; partial marks are not awarded.
time. Ensure you follow your program policy regarding late and no
assignment submission, as a zero mark might apply unless SAIT acceptable
documentation can be supplied to the instructor.
the appropriate application functionality
when completing tasks in order to earn marks. For example, do not manually type
values (e.g., page numbers, calculated values, etc.). Please note that marks
might be deducted for improper formatting, incorrect citations, and other
issues in the submitted work at the instructor’s discretion.
Please read the instructions carefully, and
complete all of the following tasks as required.
Open the COMP264_AssignmentData.xlsx
file, and save it as (replace FirstName and Lastname with
your name); be precise:
If you are working in pairs:
Rename each sheet to the doctor’s name
that is represented in the cell A1 on each sheet.
Insert a new column between the “Date” and the “Male” columns, name the column “# of Patients” on each doctor’s sheet.
each doctor’s sheet:
Enter a function
in the cell below the heading “# of
Patients” that will total the number of patients each doctor has seen
#Patients = Male + Female + Children
(do not include “No shows” in this
Change the format to number to zero (0) decimal
Autofill the function to the remaining