Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved
    Quiz 100% Result
    • CS001 Assignment 3 Solution and Discussion

      zaasmi

      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:
      [email protected]

      Questions No 01 10 marks
      Create a worksheet in excel with the name “Question 1” with the following data as shown below:
      1f22cc90-9885-489c-9712-fe4fd1836393-image.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:
      a37ee4d5-bea8-4b86-8db8-2fce454d2d62-image.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.

      CS001- Computer Proficiency License
    • CS001 Assignment 2 Solution and Discussion Spring 2020

      zaasmi

      Re: CS001 Assignment 2 Solution and Discussion

      CS001- Computer Proficiency License
    • CS001 Assignment 2 Solution and Discussion Spring 2020

      zaasmi

      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:
      [email protected]

      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.

      847de894-7d6b-44ea-903b-bd104f841208-image.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
      CS001- Computer Proficiency License
    • CS001 Assignment 1 Solution and Discussion

      zaasmi

      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:
      [email protected]

      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 ca23d1fa-6b6c-4555-87a2-e3ff4046a333-image.png 9 Pin Serial Port Connector Female ee7e3a69-76d3-42eb-96ff-3564d0d1252e-image.png Universal Serial Bus Connector. 8eff7443-0d1d-4393-a9c9-6e7594d25f22-image.png Ethernet Rj45 Connector 4a999e76-7a65-4047-aa7e-7f42480e30d3-image.png PS/2 Port Is A 6-Pin Mini-DIN Connector f16e6432-b94e-41f0-8242-b25546a6828b-image.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 - - - -
      CS001- Computer Proficiency License
    • CS001 GDB 1 Solution and Discussion

      zareen

      CS001 GDB 1 Solution and Discussion

      CS001- Computer Proficiency License
    • CS001 Assignment 3 Solution and Discussion

      zareen

      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:
      [email protected]

      Questions No 01 10 marks

      Create a worksheet in excel with the name “Question 1” with the following data as shown below:
      20bb380d-6f34-42f4-b282-934f33556e03-image.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:

      2a87879a-817f-46c5-a1b3-89913cc57c16-image.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.

      CS001- Computer Proficiency License
    • CS001 Assignment 2 Solution and Discussion

      zareen

      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:
      [email protected]

      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.
      1060b225-c7d7-4e2d-8d1f-ca602daaba24-image.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- Computer Proficiency License
    • CS001 Assignment 1 Solution and Discussion

      zareen

      Computer Proficiency License
      (CS001)
      Fall 2019
      Assignment # 01

      Total marks = 20

      Deadline Date
      13th November 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 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:
      [email protected]

      Questions No 01 15 marks

      Identify Storage, software, input and output devices from the given list.

      List Storage Software Input Output Keyboard( For example) - - Yes -

      1 Microphone - - - -
      2 Multimedia Projector - - - -
      3 Modem card - - - -
      4 Plotter - - - -
      5 Memory card - - - -
      6 ROM - - - -
      7 Microsoft Excel - - - -
      8 Scanner - - - -
      9 PowerPoint - - - -
      10 Touchpad - - - -
      11 Visual Display Unit (VDU) - - - -
      12 Punch card reader - - - -
      13 Speaker - - - -
      14 Adobe reader - - - -
      15 Network Interface cards - - - -

      1ae3c818-d65c-475f-9369-7027b5c58954-image.png

      Questions No 02 05 marks

      Fill the missing values in column “B” by accurate answer

      Column “A” Column “A”
      4 Bits 1 _______.
      1024 Bytes 1 _______ Byte
      1024 Kilo Bytes (KB) 1 _______ Byte
      1024 Mega Bytes (MB) 1 _______ Byte
      1024 Giga Byte (GB) 1 _______ Byte
      1152a4c8-d9b8-41c7-9312-c0c4dbd44a5f-image.png

      CS001- Computer Proficiency License
    • Handouts / Power Point Slides

      M

      Download Link Handouts

      CS001- Computer Proficiency License

    Handouts / Power Point Slides

    CS001- Computer Proficiency License
    1
    1
    17
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      moaaz Cyberian's Gold last edited by

      Download Link Handouts

      1 Reply Last reply Reply Quote 1
      • First post
        Last post

      50% Off on Your FEE Join US!

      Quiz 100% Result If you want to know how you can join us and get 50% Discout on your FEE ask Cyberian in Chat Room! Quiz 100% Result Quiz 100% Result
      solution1241 discussion1193 fall 2019813 assignment 1425 assignment 2295 spring 2020265 gdb 1246 assignment 382 crw10174 spring 201955
      | |
      Copyright © 2021 Cyberian Inc. Pakistan | Contributors
      Live Chat