ESC4201 Excel W24
.pdf
keyboard_arrow_up
School
Algonquin College *
*We aren’t endorsed by this school
Course
4201
Subject
Computer Science
Date
Feb 20, 2024
Type
Pages
6
Uploaded by DrStarlingMaster645
1 ESC4201 W23 Excel Assignment Due: Feb 2
nd
, 6am [All the files you need for this assignment are available: Excel]
ESC4201 Excel W24.docx
Student Files - Excel – W24.zip (containing four Excel files)
This assignment is out of 145 marks worth 5% of your term grade
When you download the Student Files.zip and unzip it, rename the folder ASAP to Lastname firstname o
Failure to follow naming convention will reduce your grade by 1% (1 out 5%)
You must leave these files inside this folder in order to complete this assignment.
Once your Excel assignment is complete, you will need to re-zip your folder o
This folder must be labelled as Lastname firstname o
This folder will have the 4 Excel files
Your zip file will be submitted through BrightSpace >> Assignments >> Excel (5%) o
Details at end of this document
Failure to submit file by Feb 2
nd
, 6am will result in 0 out of 5% o
No exceptions You are required to use the following four Excel files 1.Data Set.xlsx 2.Ontario.xlsx 3.Quebec.xlsx
4.Data Summary.xlsx Using the data available in 1. Data Set.xlsx
file, you will populate and conduct tasks in the following two files (
2. Ontario.xlsx & 3. Quebec.xlsx
). Once this is done, you will use those two files (
2. Ontario.xlsx & 3. Quebec.xlsx
) and populate the 4. Data Summary.xlsx
file. These files will now be dynamically linked, so when one file is updated, this could impact the other files. Because of this, it is critical that all your Excel files be in the same folder. NOTE: the numbers and values in this Word document are not the same as your Excel data
2 Task A
(0 marks) In the file (
1. Data Set.xlsx
), you will pick your data set by matching your last digit of your Student #
to the worksheet. For example, if your student number is 00000053
8
, you will be using the Eight
data worksheet. NOTE:
Failure to use the assigned data related to your Student #
will end up receiving zero for the assignment (0/145) Task B B1
(25 marks) You will copy the data from 1. Data Set.xlsx into the two files (
2. Ontario.xlsx & 3. Quebec.xlsx
). For example, copy the data from 1. Data Set.xlsx/Toronto column into the 2. Ontario.xlsx/Toronto column. 1. Data Set.xlsx
2. Ontario.xlsx
3. Quebec.xlsx
NOTE:
Do not Copy & Paste
. You must use absolute referencing when coping your data from the 1. Data Set.xlsx into 2. Ontario.xlsx & 3. Quebec.xlsx files. If not, you’ll receive zero for section B1 (0/25). Even if four columns are referenced properly, but one column was Copied & Pasted, you’ll lose the 25 marks.
3 The image below is an example of what absolute referencing between two difference files will look like. B2
(35 marks) The following steps must be completed for all five locations (Toronto, Ottawa, London, Montreal & Quebec City) and the two summary worksheets using these two files: 2. Ontario.xlsx
3. Quebec.xlsx Task for both files
Calculate the Low/Mid/High KPIs for the twelve months and the Totals for the five locations (7 marks)
Calculate the Summary worksheet’s Revenue, Low/Mid/High KPIs and Totals (14 marks)
For the seven worksheets, add a ‘Line’ sparkline in cell B17 (7 marks)
Each ‘Line” sparkline must show the min & max for the 12 months (7 marks) Deductions
Number formatting must be currency with two decimal places (7-mark deduction)
The KPIs (C18-E18) must be two decimals. For example, 0.85 or 85.00% are OK. (7-mark deduction) NOTE:
if one part of the formatting is missing, you will lose the full deduction
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
One way to place a copy of a file into a different folder is to hold down the ________ key and drag the file into the folder.
Multiple Choice
Control
Delete
Command
Option
arrow_forward
Pls help ASAP
arrow_forward
V:0.
Is a horizontal series of cells labeled
* with number
Columns
Cells
Row
Are used to store file and usually
appear in yellow color
Folder
File
Excel
Book in Microsoft Excel it is basic file
type in Excel
True
False
arrow_forward
The _____ option on an application file menu allows you to save the latest version of a file under its current name and its current location.
a) backspace
b) save as
c) save
d) delete
arrow_forward
M7Pro_Files
Upload your accounts python file here
What to do:
U are to create a report for users that will list their student id number, last name, and first name. Also, you will list their username and email address
The input file is linked below
studentInfo.txt
(opens in new window)
Note: You are to add YOUR first and last name in the first row ( instead fo Mr. Cameron's), the ID SHOULDN'T be your real ID, just a imaginary number there
The output file that your program will generate should look like the one linked below:
loginInfo.txt
(opens in a new window)
Given a text file , studentInfo.txt , linked above (or U can use one you created) that contains only last name( field size = 10) and first name(field size is 10) and student id numbers (field size is 7) you will create a report that will generate the usernames as well as student email accounts as shown in the loginInfo.txt linked above.
Notice that the login name consists of the first 7 characters of the last name, the…
arrow_forward
When the user selects a file with an Open or Save As dialog box, the file’s path andname are stored in this property.a. Filenameb. PathNamec. Filed. Item
arrow_forward
Q:
Allow the users to export list of records to an excel file in CSV / XLSX format
Course: Java
arrow_forward
LAB ASSIGNMENT
IMPORTANT: you need to complete the PDP thinking process for
each program. 2 programs and a data file:
1) Create your own original .csv file named lab16.csv, with at
least 3 columns and 6 rows of data. You can use PyCharm, Excel,
Notepad or another program to create a .csv file. But make sure
to put the .csv file in your project folder.
Now, create a program called csv_read.py to read the lab16.csv
file
The program should print the rows of data in column format.
●
Fully comment the program & upload lab16.csv and
csv_read.py
140-
ΟΣΤ ΟΖΤ
C
08
OTT OOT 06
csv.read.py works with a lab.csv file that you create
Name
Color
Pet Type
dog
cat
Rafa
Black and white
White w/tabby spots
Charles
Winston
White
dog
Grey
cat
dog
Silky Nelson
Dolly
Stanley
White w/black & tan spots
Tuxedo
cat
arrow_forward
LAB ASSIGNMENT
IMPORTANT: you need to complete the PDP thinking process
for each program. 2 programs and a data file:
1) Create your own original .csv file named lab16.csv, with at
least 3 columns and 6 rows of data. You can use PyCharm,
Excel, Notepad or another program to create a .csv file. But
make sure to put the .csv file in your project folder.
Now, create a program called csv_read.py to read the lab16.csv
file
●
The program should print the rows of data in column format.
Fully comment the program & upload lab16.csv and
csv_read.py
dog
cat
dog
cat
Name
Rafa
Charles
Winston
OST
Silky Nelson
Dolly
Stanley
OZT OFT
csv.read.py works with a lab.csv file that you create
Pet Type
dog
Color
Black and white
White w/tabby pots
White
C
Grey
White w/black & tan spots
Tuxedo
OOT
'06
08
arrow_forward
MULTIPLE CHOICE -The answer is one of the options below please solve carefully and circle the correct option Please write clear .
arrow_forward
Jro true or fales question
1. button should be put in the head section of files.
2. p DNe p tags should be added in the body section.
arrow_forward
The View tab contains commands that you can use to customize the display of items in the File Explorer window
true
false
Quick status displays more information about the applicationtruefalse
arrow_forward
When EnCase reports an alias for the file, the convention used is ______.
*FileType
*ConvFile
*.Ence
*.VerifyFile
arrow_forward
In the Properties box, pick Edit File Attributes from the menu that displays to alter a file attribute.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Related Questions
- One way to place a copy of a file into a different folder is to hold down the ________ key and drag the file into the folder. Multiple Choice Control Delete Command Optionarrow_forwardPls help ASAParrow_forwardV:0. Is a horizontal series of cells labeled * with number Columns Cells Row Are used to store file and usually appear in yellow color Folder File Excel Book in Microsoft Excel it is basic file type in Excel True Falsearrow_forward
- The _____ option on an application file menu allows you to save the latest version of a file under its current name and its current location. a) backspace b) save as c) save d) deletearrow_forwardM7Pro_Files Upload your accounts python file here What to do: U are to create a report for users that will list their student id number, last name, and first name. Also, you will list their username and email address The input file is linked below studentInfo.txt (opens in new window) Note: You are to add YOUR first and last name in the first row ( instead fo Mr. Cameron's), the ID SHOULDN'T be your real ID, just a imaginary number there The output file that your program will generate should look like the one linked below: loginInfo.txt (opens in a new window) Given a text file , studentInfo.txt , linked above (or U can use one you created) that contains only last name( field size = 10) and first name(field size is 10) and student id numbers (field size is 7) you will create a report that will generate the usernames as well as student email accounts as shown in the loginInfo.txt linked above. Notice that the login name consists of the first 7 characters of the last name, the…arrow_forwardWhen the user selects a file with an Open or Save As dialog box, the file’s path andname are stored in this property.a. Filenameb. PathNamec. Filed. Itemarrow_forward
- Q: Allow the users to export list of records to an excel file in CSV / XLSX format Course: Javaarrow_forwardLAB ASSIGNMENT IMPORTANT: you need to complete the PDP thinking process for each program. 2 programs and a data file: 1) Create your own original .csv file named lab16.csv, with at least 3 columns and 6 rows of data. You can use PyCharm, Excel, Notepad or another program to create a .csv file. But make sure to put the .csv file in your project folder. Now, create a program called csv_read.py to read the lab16.csv file The program should print the rows of data in column format. ● Fully comment the program & upload lab16.csv and csv_read.py 140- ΟΣΤ ΟΖΤ C 08 OTT OOT 06 csv.read.py works with a lab.csv file that you create Name Color Pet Type dog cat Rafa Black and white White w/tabby spots Charles Winston White dog Grey cat dog Silky Nelson Dolly Stanley White w/black & tan spots Tuxedo catarrow_forwardLAB ASSIGNMENT IMPORTANT: you need to complete the PDP thinking process for each program. 2 programs and a data file: 1) Create your own original .csv file named lab16.csv, with at least 3 columns and 6 rows of data. You can use PyCharm, Excel, Notepad or another program to create a .csv file. But make sure to put the .csv file in your project folder. Now, create a program called csv_read.py to read the lab16.csv file ● The program should print the rows of data in column format. Fully comment the program & upload lab16.csv and csv_read.py dog cat dog cat Name Rafa Charles Winston OST Silky Nelson Dolly Stanley OZT OFT csv.read.py works with a lab.csv file that you create Pet Type dog Color Black and white White w/tabby pots White C Grey White w/black & tan spots Tuxedo OOT '06 08arrow_forward
- MULTIPLE CHOICE -The answer is one of the options below please solve carefully and circle the correct option Please write clear .arrow_forwardJro true or fales question 1. button should be put in the head section of files. 2. p DNe p tags should be added in the body section.arrow_forwardThe View tab contains commands that you can use to customize the display of items in the File Explorer window true false Quick status displays more information about the applicationtruefalsearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LMicrosoft Visual C#Computer ScienceISBN:9781337102100Author:Joyce, Farrell.Publisher:Cengage Learning,
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage