Computer Applications (Module 1)
.docx
keyboard_arrow_up
School
Sheridan College *
*We aren’t endorsed by this school
Course
COMPUTER S
Subject
Computer Science
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by ChefPantherMaster56
Computer Applications: Module 1
Case1: Cross State Problem
1.
Open the NP_EX_1-2 Workbook 2.
Change the name of the Sheet 1 worksheet using Travel Log as the name, and then move
it to the end of the workbook.
Rename this sheet as “Travel Log” and moved to the end of workbook.
Rename the Sheet 1 as “Documentation” in the TAB below. 3.
In the documentation sheet, enter your name in Cell B4 and the current date in Cell B4, Move the Documentation sheet to the front of the workbook. o
To enter the current date in cell B4
Type the formula =Today()
4.
Go to the Travel log Worksheet. Resize the columns to that all the data is visible in the cells. o
Make a new column between columns H and J to that the column “I” is made. o
Name the column as “Miles” in I4.
5.
Between the Odometer Ending column and the Hours column and the hours column, insert a new column. Enter MILES as the column label in cell I4
6.
In the Miles column, in the range I5:I25, enter formulas to calculate the number of miles driven each day by subtracting the odometer beginning value from the odometer ending
value. o
For the first day, we get the value as 476
o
To get this number the formula to enter In the formula bar would be
=H5-G5
7.
Between the price per gallon column and the Seller column, insert a new column. Enter Total Fuel Purchase as the label in cell N4.
Insert a new column between (M) and (O) which will be (N) and name it total fuel purchase.
To insert a new column
o
Right click the column (M) and a new column appears between. o
Name the column (N) as Total Fuel Purchase. 8.
In the Total Fuel Purchase column, in the range N5:N25, enter the formulas to calculate the total amount spent on fuel each day by multiplying the gallons value by the price per
gallon value.
For the first day in cell N5, total amount is calculates as 227.6703
o
To calculate this number add the following formula in the formula tab bar o
=L5*M5
9.
In Cell B5, use the COUNT function to calculate the total number of driving days using the values in the Date column in the range D5:D25.
Total days of driving is calculated in cell B5 using the COUNT function in the range D5:D25. The total days would be 21
o
To get the total days 21 enter the following formula in the formula tab. o
=Count (D5:D25) 10. In cell B6, use the SUM function to calculate the total number of driving hours using the values in the hours column in the range J5:J25.
Total hours of driving is calculated in cell B6 using SUM function. The total hours is 156.75
o
To get this number enter the formula in the formula tab bar.
=SUM(J5:J25)
11. In cell B7, enter a formula that divides the hours of driving value (cell B6) by the days of driving value (cell B5) to calculate the average hours of driving per day.
Average hours of driving per day is calculated in cell B7, the amount is 7.46
o
To get this number enter the following formula
=B6/B5
12. In cell B9, using the SUM function to calculate the driver’s Total expenses for the month for fuel, tolls and miscellaneous expenditures using the nonadjacent range N5:N25, P5:Q25.
Total Expenses for the month is calculated in cell B9 using the SUM function o
Enter the formula =SUM(N5:N25:, P5:Q25) the expenses come out to be $5,347.72
o
This function essentially adds values 13. In cell B10, use the SUM function to calculate the total amount the driver spent on fuel using the range N5:N25. In cell B11, use the SUM function to calculate the total amount spent on tolls and miscellaneous expenses using the range P5:Q25.
Total fuel expenses for the month is calculated using the SUM function o
Total expenses is found as $4,021.73 o
To get this number enter the formula
=SUM(N5:N25)
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
10-13. Verify User: The final listing for remember_me.py assumes either that the user has already entered their username or that the program is running for the first time. We should modify it in case the current user is not the person who last used the program.
Before printing a welcome back message in greet_user(), ask the user if this is the correct username. If it’s not, call get_new_username() to get the correct username.
arrow_forward
Task 4
Assume, you have been given a tuple with details about books that won the Good Reads Choice Awards.
book_info = (
("Best Mystery & Thriller","The Silent Patient",68821),
("Best Horror","The Institute", 75717),
("Best History & Biography","The five",31783 ),
("Best Fiction", "The Testaments",98291)
Write a Python program that prints the award category, the book name, and its total votes earned as shown below.
[Must use Tuple unpacking for printing and need to handle the quotation marks as a part of the output]
Output:
The Silent Patient won the 'Best Mystery & Thriller' category with 68821 votes
The Institute won the 'Best Horror' category with 75717 votes
The five won the 'Best History & Biography' category with 31783 votes
The Testaments won the 'Best Fiction' category with 98291 votes
arrow_forward
Fill in the loop table with the correct values, Each row should represent the values of the variables at the line
with the comment LOCATION. You don't necessarily need to fill out all of the rows on the provided fable. If you
don't fill up the whole table, that isn't necessarily wrong!
1 - 2
a - 10
name - 'AL'
while i < 9:
if name 'AL':
1: 2
nam AL intinl
else:
if name < 'NAPOLEON':
name - 'NASH
elif name < 'NATE':
name - 'SAM'
else:
name- 'AL '
# LOCATION
arrow_forward
Truth table:
Please make sure the truth table is correct and it has no mistakes.
Correct the truth table if there are mistakes.
arrow_forward
The Problems - contains only problems from the last 2 contests
Separate Un-Attempted, Attempted and All cards Problem Difficulty Rating - The
Featured drop-down menu has different difficulty ranges so you can try problems that
best suit your experience.
Popular topics and brands Like most users, Chef didn't know that he could add
problems to his personal to-do list by clicking the magic "+" symbol in the upper
right corner of each problem page. But once he found out about it, he went crazy and
added a lot of problems to his to-do list without looking at their difficulty rating.
Rajesh is a beginner and ideally should only try to solve problems strictly below
10001000. Given the difficulty rating list of problems in Chef's to-do list, please help
him determine how many of these problems Chef should remove from his to-do list
so he is left with only problems with a difficulty rating of less than 10001000.
Note: Please answer the question in Python only:
Input
1
4
999 1000 1001 1002…
arrow_forward
This solution does not work for the question asked. The question submitted clearly shows 2 list boxes on form 1. Is there an updated code?
arrow_forward
Please create a constraint file using the images below. The code that is in one of the images is a Verilog code for the M1 chart. Use the M1 chart and the Verilog code to create a constraint file.
arrow_forward
List names of all customers who live in a given zip code
Feature 18: List names of all customers living in a given zip code.
Input: Create a procedure with Cust_name, Cust_Zip and a cursor to store the select
statement output into the cursor.
Output: Displays a list of all the customer names for a specific zip code with the cursor.
Example of calling the feature:
Exec customer_name_by_ZIP(‘Daisy Brown’, 64277);
using an exception too
arrow_forward
4- Sell a book. Ask the user to enter the ISBN of the book he wants to buy, search for books by
ISBN. If the book is found in the list and the number of copies is greater than zero then
decrease the number of copies for that book by one.
arrow_forward
Make a use case description table for the Shoppee app's BUY ITEM function. Shopee is a
method for buying things online.
arrow_forward
The Financial officer at RGI wants you to develop an application that will evaluate the
company's asset's annual depreciation using the double-declining balance and sum-of-the
years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and
salvage value (which is the value of the asset at the end of its useful life). The sample of the
application can be seen in Figure 2. The interface provides text boxes for entering the asset
cost and salvage value. It also provides a list box for selecting the useful life, which ranges
from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use
the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are
correct). Create a windows form application using the name RGI annual asset depreciation
App. You can use the visual basic's Financial.DDB method to calculate the double-declining
balance depreciation and use its Financial.SYD method to calculate the…
arrow_forward
The Financial officer at RGI wants you to develop an application that will evaluate the
company's asset's annual depreciation using the double-declining balance and sum-of-the
years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and
salvage value (which is the value of the asset at the end of its useful life). The sample of the
application can be seen in Figure 2. The interface provides text boxes for entering the asset
cost and salvage value. It also provides a list box for selecting the useful life, which ranges
from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use
the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are
correct). Create a windows form application using the name RGI annual asset depreciation
App. You can use the visual basic's Financial.DDB method to calculate the double-declining
balance depreciation and use its Financial.SYD method to calculate the…
arrow_forward
The Financial officer at RGI wants you to develop an application that will evaluate the
company's asset's annual depreciation using the double-declining balance and sum-of-the
years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and
salvage value (which is the value of the asset at the end of its useful life). The sample of the
application can be seen in Figure 2. The interface provides text boxes for entering the asset
cost and salvage value. It also provides a list box for selecting the useful life, which ranges
from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use
the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are
correct). Create a windows form application using the name RGI annual asset depreciation
App. You can use the visual basic's Financial.DDB method to calculate the double-declining
balance depreciation and use its Financial.SYD method to calculate the…
arrow_forward
Use Laravel only(MVC PROGRAMMING)Create blade template containing a form having thefollowing form controls: case and submit button. After thevalue of the case field is filled by the user, an appropriateresponse should be generated. For example, if user enters1, the result should be “First Case” and so on. You have touse switch case directive to complete this task.
arrow_forward
2.
An instructor created a submission folder for coding submissions from students. The instructor wants to maintain all access to the folder for herself, but wants to give the grading assistants 'read' and 'execute' permission to the folder. However, the grading assistants cannot change anything in the folder. She adds a group 'grader' with the grading assistants for the folder. Nobody else should have any access to the submission folder. The instructor should use : chmod ________ to set the access permission for the submission folder to achieve the above goal.
Hint:
Indicate the decimal number corresponding to the permission.
arrow_forward
What parameters are required when setting the cursor position with INT 10h?
arrow_forward
LAB ASSIGNMENTS
IMPORTANT: you should complete the PDP thinking process for each program. Turn in items:
1) fullname_regex.py - Ask the user to enter the source text to search, such as the name_source variable here:
name_source=input('Enter full name in this format - first middle last').
Then, you can adapt the first two code lines from lesson slide 13, to search this new source. Edit the code to match
the new situation and change the regex pattern to identify text that could be a full name.
Hints: Initially write your regex pattern to check if the user enters three words separated by a space. Then, strive to
make the regex adaptable if the person's full name has more than or less than 3 words. Then, think about allowing!!!
(not requiring) common characters like a period, hyphen or '. Slides 11-13 should be helpful.
For printing, end with a conditional block that provides an appropriate message if there is a match or not.
Match
No Match
Challenge 1
Enter your full name: first middle…
arrow_forward
LAB ASSIGNMENTS
IMPORTANT: you should complete the PDP thinking process for each program. Turn in items:
1) fullname_regex.py - Ask the user to enter the source text to search, such as the name_source variable here:
name_source = input('Enter full name in this format - first middle last').
Then, you can adapt the first two code lines from lesson slide 13, to search this new source. Edit the code to match
the new situation and change the regex pattern to identify text that could be a full name.
Hints: Initially write your regex pattern to check if the user enters three words separated by a space. Then, strive to
make the regex adaptable if the person's full name has more than or less than 3 words. Then, think about allowing
(not requiring) common characters like a period, hyphen or '. Slides 11-13 should be helpful.
08
For printing, end with a conditional block that provides an appropriate message if there is a match or not.
Match
Enter your full name: first middle last Betty Lou Who…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Related Questions
- 10-13. Verify User: The final listing for remember_me.py assumes either that the user has already entered their username or that the program is running for the first time. We should modify it in case the current user is not the person who last used the program. Before printing a welcome back message in greet_user(), ask the user if this is the correct username. If it’s not, call get_new_username() to get the correct username.arrow_forwardTask 4 Assume, you have been given a tuple with details about books that won the Good Reads Choice Awards. book_info = ( ("Best Mystery & Thriller","The Silent Patient",68821), ("Best Horror","The Institute", 75717), ("Best History & Biography","The five",31783 ), ("Best Fiction", "The Testaments",98291) Write a Python program that prints the award category, the book name, and its total votes earned as shown below. [Must use Tuple unpacking for printing and need to handle the quotation marks as a part of the output] Output: The Silent Patient won the 'Best Mystery & Thriller' category with 68821 votes The Institute won the 'Best Horror' category with 75717 votes The five won the 'Best History & Biography' category with 31783 votes The Testaments won the 'Best Fiction' category with 98291 votesarrow_forwardFill in the loop table with the correct values, Each row should represent the values of the variables at the line with the comment LOCATION. You don't necessarily need to fill out all of the rows on the provided fable. If you don't fill up the whole table, that isn't necessarily wrong! 1 - 2 a - 10 name - 'AL' while i < 9: if name 'AL': 1: 2 nam AL intinl else: if name < 'NAPOLEON': name - 'NASH elif name < 'NATE': name - 'SAM' else: name- 'AL ' # LOCATIONarrow_forward
- Truth table: Please make sure the truth table is correct and it has no mistakes. Correct the truth table if there are mistakes.arrow_forwardThe Problems - contains only problems from the last 2 contests Separate Un-Attempted, Attempted and All cards Problem Difficulty Rating - The Featured drop-down menu has different difficulty ranges so you can try problems that best suit your experience. Popular topics and brands Like most users, Chef didn't know that he could add problems to his personal to-do list by clicking the magic "+" symbol in the upper right corner of each problem page. But once he found out about it, he went crazy and added a lot of problems to his to-do list without looking at their difficulty rating. Rajesh is a beginner and ideally should only try to solve problems strictly below 10001000. Given the difficulty rating list of problems in Chef's to-do list, please help him determine how many of these problems Chef should remove from his to-do list so he is left with only problems with a difficulty rating of less than 10001000. Note: Please answer the question in Python only: Input 1 4 999 1000 1001 1002…arrow_forwardThis solution does not work for the question asked. The question submitted clearly shows 2 list boxes on form 1. Is there an updated code?arrow_forward
- Please create a constraint file using the images below. The code that is in one of the images is a Verilog code for the M1 chart. Use the M1 chart and the Verilog code to create a constraint file.arrow_forwardList names of all customers who live in a given zip code Feature 18: List names of all customers living in a given zip code. Input: Create a procedure with Cust_name, Cust_Zip and a cursor to store the select statement output into the cursor. Output: Displays a list of all the customer names for a specific zip code with the cursor. Example of calling the feature: Exec customer_name_by_ZIP(‘Daisy Brown’, 64277); using an exception tooarrow_forward4- Sell a book. Ask the user to enter the ISBN of the book he wants to buy, search for books by ISBN. If the book is found in the list and the number of copies is greater than zero then decrease the number of copies for that book by one.arrow_forward
- Make a use case description table for the Shoppee app's BUY ITEM function. Shopee is a method for buying things online.arrow_forwardThe Financial officer at RGI wants you to develop an application that will evaluate the company's asset's annual depreciation using the double-declining balance and sum-of-the years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful life). The sample of the application can be seen in Figure 2. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are correct). Create a windows form application using the name RGI annual asset depreciation App. You can use the visual basic's Financial.DDB method to calculate the double-declining balance depreciation and use its Financial.SYD method to calculate the…arrow_forwardThe Financial officer at RGI wants you to develop an application that will evaluate the company's asset's annual depreciation using the double-declining balance and sum-of-the years' digit method. The Financial officer will enter the asset's cost, useful life (in years), and salvage value (which is the value of the asset at the end of its useful life). The sample of the application can be seen in Figure 2. The interface provides text boxes for entering the asset cost and salvage value. It also provides a list box for selecting the useful life, which ranges from 3 to 20 years. The depreciation amounts are displayed in the list boxes. (You can use the DDB and SYD functions in Microsoft Excel to verify the amounts shown in Figure 2 are correct). Create a windows form application using the name RGI annual asset depreciation App. You can use the visual basic's Financial.DDB method to calculate the double-declining balance depreciation and use its Financial.SYD method to calculate the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning