Re: CS001 Assignment 3 Solution and Discussion
Computer Proficiency License
(CS001)
Assignment # 03
Total marks = 20
Due Date
27th July 2020
Please carefully read the following instructions before attempting the assignment.
RULES FOR MARKING
It should be clear that your assignment would not get any credit if:
The assignment is submitted after the due date.
The submitted assignment does not open or file is corrupt.
Strict action will be taken if the submitted solution is copied from any other student or the internet.
You should consult the recommended books to clarify your concepts as handouts are not sufficient.
You are supposed to submit your assignment in xls or xlsx format.
Any other formats like scan images, Doc, Docx, PDF, zip, rar, ppt, and BMP etc will not be accepted.
Topic Covered:
• Module 4 (Spreadsheets):
o Introduction to Microsoft Excel
o Saving an Excel File
o Creating Complex Formula
o Sorting Data
Note: Create an excel file with two sheets, one for Question 1 and other for Question 2.
NOTE
No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date.
If you people find any mistake or confusion in assignment (Question statement), please consult with your instructor before the deadline. After the deadline no queries will be entertained in this regard.
For any query, feel free to email at:
cs001@vu.edu.pk
Questions No 01 10 marks
Create a worksheet in excel with the name “Question 1” with the following data as shown below:
[image: FNBA7dZ.png]
Create a formula in the Quantity column to calculate the total of each type of Medical Goods statistics in a store sold/Item. Quantity = number goods sold in January + number goods sold in February + number goods sold in March + number goods sold in April + number goods sold in May.
Create a formula in the Sales column to calculate the sales value of each type of Medical goods.
Sales = Quantity * Price.
In the row Grand Total, create a formula to calculate the total number of Medical goods sold per month.
One new row at the bottom of the Worksheet added and label “Mod sale item Name”. Create formulae in these rows to calculate the Maximum goods name sold per month.
Questions No 02 10 marks
Create a worksheet with the name “Question 2” with the following data as below:
[image: IrEqUSe.png]
Enter the formula to find the number of Male Quarantine patients in cell “G8” and the number of Female Quarantine patients in cell “G9” respectively.
In cells “H8” and “H9”, enter the formula to calculate the total Stipend for Male Quarantine patients and Female Quarantine patients.
In cells “I8” and “I9” calculate the average Stipend for Male Quarantine patients and Female Quarantine patients using the values calculated in question 2.
In cells “J8” and “J9”, calculate the number of Male Quarantine patients and Female Quarantine patients having pay more than 5,000.
Note: Create an excel file with two sheets, one for Question 1 and another for Question 2.
Re: CS001 Assignment 2 Solution and Discussion
Computer Proficiency License
(CS001)
Assignment # 02
Total marks = 15
Deadline Date
15th June 2020
Please carefully read the following instructions before attempting the assignment.
RULES FOR MARKING
It should be clear that your assignment would not get any credit if:
The assignment is submitted after the due date.
The submitted assignment file does not open or file is corrupt.
The submitted solution is copied from any other student or the internet.
You should consult the recommended books to clarify your concepts as handouts are not sufficient.
You are supposed to submit your assignment in .doc or .docx format.
Any other formats like scan images, PDF, zip, rar, ppt, and BMP, etc will not be accepted.
Topic Covered:
Module 3 (Word Processing):
o Introduction
o Using Application
o Formatting
o Table (Basic part for practice)
NOTE
No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignments in the last hour of the deadline. It is recommended to upload the solution file at least two days before its closing date.
If you people find any mistake or confusion in the assignment (Question statement), please consult with your instructor before the deadline. After the deadline, no queries will be entertained in this regard.
For any query, feel free to email at:
cs001@vu.edu.pk
Question No 01 7 marks
Suppose you are working as an IT manager in an IT and electronics company; you are required to write a commercial sales letter to one of your customers (Letter format has been well explained through a template/figure below) using Microsoft Word.
Consider the following requirements while writing the letter:
• Insert the system date at the specified location.
• Insert a permission request for your team for the installation of the network and UPS.
• Insert a table stating the customer’s complete order details.
[image: 3dJL8jv.png]
Question No 02 8 marks
Write the keyboard shortcut keys for the following actions in Microsoft Word:
Sr. No
Action
Shortcut key
1
Search a document
2
Justify a paragraph
3
Decrease font size
4
Bulleted list
5
Open the Font dialog box
6
Increase font size
7
Switch to the next window
8
Insert a copyright symbol
Re: CS001 Assignment 1 Solution and Discussion
Computer Proficiency License
(CS001)
Spring 2020
Assignment # 01
Total marks = 20
Deadline Date
1st June 2020
Please carefully read the following instructions before attempting assignment.
RULES FOR MARKING
It should be clear that your assignment would not get any credit if:
The assignment is submitted after the due date.
The submitted assignment does not open or file is corrupt.
Strict action will be taken if submitted solution is copied from any other student or from the internet.
You should consult the recommended books to clarify your concepts as handouts are not sufficient.
You are supposed to submit your assignment in .doc or docx format.
Any other formats like scan images, PDF, zip, rar, ppt and bmp etc will not be accepted.
Topic Covered:
• Module 1 (Introduction to Computers):
o Introduction
o Hardware
o Input Devices
o Software
o Pointing
o Storage
NOTE
No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date.
If you find any mistake or confusion in assignment (Question statement), please consult with your instructor before the deadline. After the deadline no queries will be entertained in this regard.
For any query, feel free to email at:
cs001@vu.edu.pk
Questions No 01 05 marks
Match the Column “A” with accurate name as per the pictures given in column “B”.
Column “A”
Column “B
9 Pin Serial Port Connector Male
[image: knvTXZM.png]
9 Pin Serial Port Connector Female
[image: gVV6mvF.png]
Universal Serial Bus Connector.
[image: IuuGsqC.png]
Ethernet Rj45 Connector
[image: xAHo0Za.png]
PS/2 Port Is A 6-Pin Mini-DIN Connector
[image: 4hgGf2u.png]
Questions No 02 15 marks
Categorize the Storage, Software, Input and Output Devices from the given list.
S No.
List
Storage
Software
Input
Output
0
Microsoft Word (For example)
-
Yes
-
-
1
Read Only Memory
-
-
-
-
2
Microsoft PowerPoint
-
-
-
-
3
Keyboard
-
-
-
-
4
Plotter
-
-
-
-
5
Memory card
-
-
-
-
6
Microsoft Excel
-
-
-
-
7
Scanner
-
-
-
-
8
Multimedia Projector
-
-
-
-
9
Read Only Memory
-
-
-
-
10
Adobe Reader
-
-
-
-
11
Touchpad
-
-
-
-
12
Visual Display Unit (VDU)
-
-
-
-
13
Speaker
-
-
-
-
14
Joystick
-
-
-
-
15
Network Interface Cards
-
-
-
-
Computer Proficiency License
(CS001)
Assignment # 03
Total marks = 20
Due Date
23th January 2020
Please carefully read the following instructions before attempting assignment.
RULES FOR MARKING
It should be clear that your assignment would not get any credit if:
The assignment is submitted after the due date.
The submitted assignment does not open or file is corrupt.
Strict action will be taken if submitted solution is copied from any other student or from the internet.
You should consult the recommended books to clarify your concepts as handouts are not sufficient.
You are supposed to submit your assignment in xls or xlsx format.
Any other formats like scan images, doc,docx,PDF, zip, rar, ppt and bmp etc will not be accepted.
Topic Covered:
• Module 4 (Spreadsheets):
o Introduction to Microsoft Excel
o Saving an Excel File
o Creating Complex Formula
o Sorting Data
Note: Create an excel file with two sheets, one for Question 1 and other for Question 2.
NOTE
No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date.
If you people find any mistake or confusion in assignment (Question statement), please consult with your instructor before the deadline. After the deadline no queries will be entertained in this regard.
For any query, feel free to email at:
cs001@vu.edu.pk
Questions No 01 10 marks
Create a worksheet in excel with the name “Question 1” with the following data as shown below:
[image: 921cNhj.png]
Then, perform the following tasks in the worksheet for the given data:
Create a formula in the Quantity column to calculate the total quantity of each type of Paper Goods sold from September to January. In simple words,
Quantity = Total number of goods sold for each type from September to January
Create a formula in the Sales column to calculate the total price of quantity sold from September to January for each type of goods.
Total Price of Goods Sold = Quantity * Unit Price
In the row Grand Total, create a formula to calculate the total number of goods of all types sold per month.
Grand Total = Total number of goods sold for all paper types in each month
Create a new row with label Mod Sale Item under the row Grand Total. In Mod Sale Item row, for each respective cell of month column, create a formula to find the Maximum quantity of goods sold for any type. For example, in month of September, Toilet papers were sold the most which were 115. So, our formula in Mod Sale row should display 115. You should calculate the same for each month.
Create a new row with label Mode Sale Goods at the end of the worksheet. In this row, you will create a formula to calculate the mode value for quantities of each goods type sold during a particular month and then displays the name of the goods representing the mode value.
Questions No 02 10 marks
Create a worksheet with the name “Question 2” with the following data as below:
[image: x7sT7ML.png]
Enter the formula to find the number of Computer science scholars in cell “G8” and number of Management scholars in cell “G9” respectively.
In cells “H8” and “H9”, enter formula to calculate the total pay for Computer science scholars and Management scholars.
In cells “I8” and “I9” calculate the average pay for Computer science scholars and Management scholars using the values given in Pay column (column D).
In cells “J8” and “J9”, calculate the number of Computer science scholars and Management scholars having pay more than 50,000.
Note: Create an excel file with two sheets, one for Question 1 and other for Question 2.
Computer Proficiency License
(CS001)
Assignment # 02
Total marks = 15
Deadline Date
4th December 2019.
Please carefully read the following instructions before attempting assignment.
RULES FOR MARKING
It should be clear that your assignment would not get any credit if:
The assignment is submitted after the due date.
The submitted assignment file does not open or file is corrupt.
The submitted solution is copied from any other student or from the internet.
You should consult the recommended books to clarify your concepts as handouts are not sufficient.
You are supposed to submit your assignment in .doc or docx format.
Any other formats like scan images, PDF, zip, rar, ppt and bmp etc will not be accepted.
Topic Covered:
Module 3 (Word Processing):
o Introduction
o Using Application
o Formatting
o Table (Basic part for practice)
NOTE
No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date.
If you people find any mistake or confusion in assignment (Question statement), please consult with your instructor before the deadline. After the deadline no queries will be entertained in this regard.
For any query, feel free to email at:
cs001@vu.edu.pk
Question No 01 7 marks
Suppose you are running an online bookstore; you are required to write a commercial sales letter to one of your customers (Letter format has been well explained through a template/figure below) using Microsoft Word.
Consider the following requirements while writing the letter:
• Insert the system date and time at the specified location.
• Insert a hyperlink on “Fast Courier ®” of address www.fastcourier.com.pk
• Insert a table stating customer’s complete order details.
[image: 9FiNDdm.png]
Question No 02 8 marks
Write the keyboard shortcut keys for the following actions in Microsoft Word:
#
Action
Shortcut key
1
Open the Font dialog box
2
Justify a paragraph
3
Decrease font size
4
Extend selection to the end of the line
5
Switch to the next window
6
Insert a copyright symbol
7
Bulleted list
8
Search a document
CS001 Quiz 1 Solution and Discussion
CS001- Computer Proficiency License
1
Posts
1
Posters
376
Views
1
Watching
PAK VS BAN Live
File Sharing
