Page 1 / 4
TU170
Tutor-marked Assignment 01 – Fall 2013-2014
Cut-off date: Dec 8, 2013
Total marks: 100
TU170 Computing Essentials
Page 2 / 4
Part 1 [30 marks]
1. Use the common forum in LMS, in TU170 page, to initiate a discussion and to share your ideas with your classmates about one of the following topics:
Twitter
Speech Recognition
Google Docs
Smart Phones
Virus Protection and Internet Security
You should copy all the thread messages (not screenshots) and past it on your solution for this part. The thread should contain at least 10 messages.[10 marks]
2. Within the range of 150 – 200 word count and using your own words, describe any three LMS features. [4 marks]
3. Use your browser to search about blended learning system using one of the search engines such as Yahoo or Google.
a. Visit any two links from the search result and then copy few sentences or short paragraph that describes what blended learning system is. Make sure to put them between double quotations. [4 marks]
b. Using MS word processor, make citation and reference for your two quotations [4 marks]
c. Describe (using your own words) the steps you followed in creating the citation. [4 marks]
d. Why do you think it is important to make citation for the references you have used? [4 marks]
Page 3 / 4
Part 2 [22 marks]
Employee Name
January
February
March
April
Total
Salary classification
800
860
900
820
1000
1200
1000
1100
600
680
640
600
480
460
420
400
900
1000
900
960
820
900
860
800
700
780
760
760
1000
1100
1200
1300
400
420
460
480
Highest Salary
Lowest Salary
Average Salary
Number of high range salaries
Figure 1: Spreadsheet sample, salaries statistics for four months in a company
Using MS Excel:
1. Create a spreadsheet similar to figure 1 [2 marks]
2. Type in all text and add names to the employees in the first column [2 marks]
3. Use proper functions to find:
highest, lowest, and average salaries in each month [3 marks]
total salary for each employee [1 mark]
Whether the total salary for each employee is classified as High or Low range salary. If the total is greater than 2500 then it is classified as High range, otherwise Low range [2 marks]
number of employees who are classified to gain High range salary [2 marks]
4. Create two graphs:
A column chart representing the employees’ salaries in four months
A line graph representing the highest, lowest and average salaries in each month
Both charts must have chart title, x axis label, y axis label [10 marks]
Page 4 / 4
Part 3 [20 marks]
In many areas in the course textbook, you have been introduced with the concept of cloud storage and it is also described in “A look to the future” section in Secondary Storage chapter. Write an essay around 400 word count describing the following:
Definition of cloud storage [4 marks]
Cloud storage history [4 marks]
Two examples of cloud storage services [4 marks]
Advantages and disadvantages [4 marks]
How could this help with your studying at AOU [4 marks]
Part 4 [18 marks]
Use your own words to answer each question or statement below.
1. List and describe the three types of electronic commerce and explain how to ensure secure payment in electronic commerce? [3 marks]
2. Describe any three design principles that can be used to enhance the user interface usability? [3 marks]
3. The operating system act as an interface between the user and the computer system, explain. [3 marks]
4. Android and iPhone OS are two examples of mobile phone operating systems. What is the difference between them? [3 marks]
5. What is the difference between input and output devices? List two examples of devices which combine input and output capabilities. [3 marks]
6. How to improve the hard disk performance? [3 marks]
TMA presentation [10 marks]
The TMA word document must satisfy the following:
Header contains student’s name and id
Page numbering
No grammar and spelling mistakes
How to submit the TMA
Create a folder and name it as yourId_firstName_ Surname
The folder should contain the word document and the excel file
Right click on the folder > Sent To > Compressed (Zipped) Folder
Submit the compressed (Zipped) folder in LMS
TU170
Tutor-marked Assignment 01 – Fall 2013-2014
Cut-off date: Dec 8, 2013
Total marks: 100
TU170 Computing Essentials
Page 2 / 4
Part 1 [30 marks]
1. Use the common forum in LMS, in TU170 page, to initiate a discussion and to share your ideas with your classmates about one of the following topics:
Speech Recognition
Google Docs
Smart Phones
Virus Protection and Internet Security
You should copy all the thread messages (not screenshots) and past it on your solution for this part. The thread should contain at least 10 messages.[10 marks]
2. Within the range of 150 – 200 word count and using your own words, describe any three LMS features. [4 marks]
3. Use your browser to search about blended learning system using one of the search engines such as Yahoo or Google.
a. Visit any two links from the search result and then copy few sentences or short paragraph that describes what blended learning system is. Make sure to put them between double quotations. [4 marks]
b. Using MS word processor, make citation and reference for your two quotations [4 marks]
c. Describe (using your own words) the steps you followed in creating the citation. [4 marks]
d. Why do you think it is important to make citation for the references you have used? [4 marks]
Page 3 / 4
Part 2 [22 marks]
Employee Name
January
February
March
April
Total
Salary classification
800
860
900
820
1000
1200
1000
1100
600
680
640
600
480
460
420
400
900
1000
900
960
820
900
860
800
700
780
760
760
1000
1100
1200
1300
400
420
460
480
Highest Salary
Lowest Salary
Average Salary
Number of high range salaries
Figure 1: Spreadsheet sample, salaries statistics for four months in a company
Using MS Excel:
1. Create a spreadsheet similar to figure 1 [2 marks]
2. Type in all text and add names to the employees in the first column [2 marks]
3. Use proper functions to find:
highest, lowest, and average salaries in each month [3 marks]
total salary for each employee [1 mark]
Whether the total salary for each employee is classified as High or Low range salary. If the total is greater than 2500 then it is classified as High range, otherwise Low range [2 marks]
number of employees who are classified to gain High range salary [2 marks]
4. Create two graphs:
A column chart representing the employees’ salaries in four months
A line graph representing the highest, lowest and average salaries in each month
Both charts must have chart title, x axis label, y axis label [10 marks]
Page 4 / 4
Part 3 [20 marks]
In many areas in the course textbook, you have been introduced with the concept of cloud storage and it is also described in “A look to the future” section in Secondary Storage chapter. Write an essay around 400 word count describing the following:
Definition of cloud storage [4 marks]
Cloud storage history [4 marks]
Two examples of cloud storage services [4 marks]
Advantages and disadvantages [4 marks]
How could this help with your studying at AOU [4 marks]
Part 4 [18 marks]
Use your own words to answer each question or statement below.
1. List and describe the three types of electronic commerce and explain how to ensure secure payment in electronic commerce? [3 marks]
2. Describe any three design principles that can be used to enhance the user interface usability? [3 marks]
3. The operating system act as an interface between the user and the computer system, explain. [3 marks]
4. Android and iPhone OS are two examples of mobile phone operating systems. What is the difference between them? [3 marks]
5. What is the difference between input and output devices? List two examples of devices which combine input and output capabilities. [3 marks]
6. How to improve the hard disk performance? [3 marks]
TMA presentation [10 marks]
The TMA word document must satisfy the following:
Header contains student’s name and id
Page numbering
No grammar and spelling mistakes
How to submit the TMA
Create a folder and name it as yourId_firstName_ Surname
The folder should contain the word document and the excel file
Right click on the folder > Sent To > Compressed (Zipped) Folder
Submit the compressed (Zipped) folder in LMS