Task

Accept 5 numbers from a user and output the average.

(Files used in solution can be found here)

Solution using a for loop

Solution using a while loop

Note: The task requires bounded iteration, a while loop is not ideal in principle however it can be done.

© 2022  Vedesh Kungebeharry. All rights reserved. 

Excel File

1. Download the attached Excel file and complete the tasks listed in the sheet TUTORIAL TASKS. The Tasks are to be completed in sheet 1. Note, these tasks must be accomplished in Microsoft Excel and not google sheets. (SEE ATTACHED VIDEO INSTRUCTIONS).

2. After accomplishing the tasks, save your work.
3. Rename your File in the format “Last name, First name – Excel Exam”

3. Attach this file to to assignment and turn in your  submission before the deadline date.

Video instructions

https://youtu.be/YWw4rJDwKv0

© 2022  Vedesh Kungebeharry. All rights reserved. 

See the video below:

© 2021  Vedesh Kungebeharry. All rights reserved. 

There are various types of computers and used in the world today. You may already be accustomed to desktop computers and laptops, and this goes without saying – even your mobile devices.

Here, we take a more formal approach by creating an exhaustive list of categories based on the purpose of the computers in each category. The list includes:

• supercomputers
• mainframe computers
• mini computers
• Micro computers
  • desktop pc
  • laptop computer
  • tablet computer
  • mobile devices
    
    
• embedded systems

Supercomputers

(Los Alamos National Laboratory, Attribution, via Wikimedia Commons.)

Supercomputers are the fastest, most expensive computers in the world. They are specialized computers that are used mainly for scientific research and simulations. 

They are much faster than the regular general purpose computers (example: desktop PC) that we use every day, approximately 100 million times faster.

They are capable of storing a vast amount of data for processing.

They are very large, and can occupy the space of an entire floor in a  large building. Because of the high amounts of processing and the size of the supercomputer they consume a lot of electrical power which adds to the expense of running a supercomputer.

It should come as no surprise that’s super computers are very expensive. There aren’t a lot of supercomputers in the world for this reason, and scientists share their time with each other when using a supercomputer.

Supercomputers are used for various complex applications, most of them beyond on the scope of our study but one relatable  example would be in the simulation of weather systems for weather forecasting.

Mainframe Computers

(Erik Pitti from San Diego, CA, USA, CC BY 2.0 https://creativecommons.org/licenses/by/2.0, via Wikimedia Commons)

Mainframe computers were built to be used by many people and an organization at the same time. It is a very large computer system and can fill up an entire room.

Multiple users connect to the mainframe computer via multiple terminals which consist of at least a monitor and keyboard.  Many other peripheral devices are also connected to the mainframe computer example printers, scanners external disk drives etc.

Although mainframe computers are very fast and can store a lot of data, they are much less expensive than a supercomputer.

Mainframe computers are used by medium size to large businesses for example, banks and insurance companies.

Mini Computer

(K-202 minicomputer, Olaf, Public domain, via Wikimedia Commons)

Mini computers can be thought of as a smaller version of a mainframe computer intended to be more accessible and affordable to smaller businesses.

 Computers  Server

Multiple Servers in a server rack (Cskiran, CC BY-SA 4.0 https://creativecommons.org/licenses/by-sa/4.0, via Wikimedia Commons)

Computer servers do exactly what their names imply.  They provide services across a computer network to other computers known as clients computers. Client computers can be any class of micro computer ( desktop PC’s, laptop computers, tablet computers and mobile devices ) or even another Server itself.

The most common example would be a print server on a network or a website server on the Internet.

In the case of a print server in an office, workers can access the printer across the computer network to print various documents.  This reduces the need for multiple printers.

In the case of the web server on the Internet, web pages are served to different users who use web browsers on their computers to access the server via a web address.

Micro computers

A collection of 70's era microcomputers: SWTPC 6800, Altair 8800 (running a Dazzler program), an Altair 8800B, and an AC-30 Cassette tape interface. (John crane 59, CC BY-SA 3.0 https://creativecommons.org/licenses/by-sa/3.0, via Wikimedia Commons)

These computers fall into the category of average everyday personal use. they are not intended to be used by many people, only a single user at a time.

They include desktop PC’s, laptop computers, tablet computers and mobile devices.

Their  processing power is generally lower than a mainframe or mini computer but powerful enough to suit their needs of the user.

They are affordable enough to have widespread use across the entire world today.

Embedded computers

Network enabled embedded computer board - London Science Museum, 2015-03-19  (Binary Koala from Berlin / Saint-Petersburg, TCP/IP, CC BY-SA 2.0 <https://creativecommons.org/licenses/by-sa/2.0>, via Wikimedia Commons)

These are small specialized computer systems that are integrated into mechanical and or electrical machines.

For example, the microwave oven in your kitchen contains an embedded computer system which is able to be controlled via the keypad. the system is responsible for starting and stopping the operation of the microwave oven as well as controlling the power delivered to the microwave oven via the use of temperature sensors.

Embedded computers can be found in many household appliances and vehicles.

© 2021  Vedesh Kungebeharry. All rights reserved. 

Consider the following tasks below:

Task: a solution is required which prompts the user to enter a person’s name their gender and birth year. The solution should output a message stating the The person’s name, wheather they are an adult, teenager or child, as well as their gender.

E.g, If the user enters Khan Smith, male, 2000; the solution would output :

Khan Smith is an male adult who will be 21 years old this year.

or a similar message.

Flowchart Solution

This solution was created in Flowgorithm (Download files here):

Solution in Pseudocode

Start
    // Here we initialize variables for first use....
    personName = "Unknown"
    sex = "Unknown"
    currentYear = 2021
    birthYear = -9999
    
    // end initialization.
    // Get the data from the user....
    output "Please enter the person's  name"
    input personName
    output "Please enter the person's Year of Birth"
    input birthYear
    output "Please enter the person's sex, either M  for male, or  F for Female"
    input sex
    
    // start to process data...
    // Determine the sex form the entered character....
    if sex = "M" then
        sex = " is a male "
    else
        sex = " is a female "
    end If
    age = currentYear - birthYear
    if age > 19 then
        personType = " adult "
    else
        if age > 12 then
            personType = " teenager "
        else
            personType = " child "
        end If
    end If
    result = personName + sex + personType + "who will be " + age + " years in " + currentYear
    output result
    output "thanks for using my program!"
    
    // © 2021  Vedesh Kungebeharry. All rights reserved.
End

© 2021  Vedesh Kungebeharry. All rights reserved.