Introduction
Excel is a spreadsheet program. Excel is an application program that offers the opportunity to make calculation any data (especially numerical data) tables or lists and keep in and analysis you need on these data.
With Excel, you can draw graphs with the data easily and quickly, reports can prepared, summarized and reach the desired data, sort you can query.
In this lesson you will learn by watching and reading articles about Excel and at the end of the lectures you will be able to create your project.
Good luck.
Task
This web adventure; You will have knowledge on the subject that are; data entry in Excel, create a table, pay attention to visual elements, the collection process and the average transaction in excel, data sorting process.
I expect you to create a table that is about reading book in 1 year. You should create table title, students name and surname, mounths, total number of read book, avarage number of read book.
you should do shorting to find that most who read the book by students.
For example; Ahmet Kazım read 3 books in April, 2 books in May, 1 book in June. Mehmet Şimşek read 4 book in April, 3 books in May, 1 book in June. So Ahmet Kazım totally read 6 books, Mehmet Şimşek totally read 8 books. As you can see; Mehmet Şimşek, read more books than Ahmet Kazım. I want you to create this example in Excel.
Pay Attention: You have to add 15 students' data in your excel page and calculate them totally read book and avarege read book.
In your project I expect to see these objects used;
1.entering data,
2.to creating table,
3.to pay attention to the visual characteristics:
3.1. setting the row-column widths
3.2. case sensitive
3.3. coloring
3.4 grouping
4. Addition process in excel (using only formula when you addition.)
5. the avarage culculation
6. Data sorting process in Excel
NOTE: I expect from you to create your project and submite them before the deathline that is 15/06/2015
Process
you will be able to getting knowledge by using these links.
1) for the entering data in Excel
2) for the creating a table in Excel
http://www.youtube.com/watch?v=_hlhLnxvBSg
3)) for the pay attention to the visual characteristics
http://www.youtube.com/watch?v=0W_933RnCXM
4) for the addition process in Excel
http://www.youtube.com/watch?v=Jwzjb-sszuE
5) for the avarage culculation
http://www.youtube.com/watch?v=ynooYQfkY6w
6) for the Data sorting process in Excel
http://www.youtube.com/watch?v=1sE23m0oN9k
Evaluation
This evaluation form will be used when your submite your project for evaluate your performance.
|
5. Classes Computer Courses Excel Work Activity Evaluation Form |
||||
|
1. |
Data Entry in Excel |
Yes |
Partially |
No |
|
1.1
|
Can he/she do Data Entry in Excel? |
|
|
|
|
1.2 |
Did Arrange data as appropriate? |
|
|
|
|
2. |
Visualisation |
Yes |
Partially |
No |
|
2.1 |
Did he/she set the row-column widths? |
|
|
|
|
2.2 |
Attention was paid to the upper or lower case compliance? |
|
|
|
|
2.3 |
Used Coloring |
|
|
|
|
2.4 |
grouping |
|
|
|
|
3. |
Addition process in Excel |
Yes |
Partially |
No |
|
3.1 |
Make the collection process using a formula? |
|
|
|
|
4. |
The avarage culculation |
|
|
|
|
4.1 |
Avarage is culculated |
|
|
|
|
5. |
Data sorting process in Excel |
Yes |
Partially |
No |
|
5.1 |
Can The data be ordered by A-Z or Z-A? |
|
|
|
|
6. |
Use of Time |
Yes |
Partially |
No |
|
6.1 |
Did he/she use the time allocated for productive activities? |
|
|
|
|
7. |
Comprehension |
Yes |
Partially |
No |
|
7.1 |
Did he/she understand the purpose of Excel? |
|
|
|
NOTE:
Yes 2 points, Total Point by percentage :
Partially 1 point, Letter :
No 0 point and
Totally 24 Points.
%100 : ……….*4,16 =………..
|
Number |
Letter |
Number |
Letter |
|
90-100 |
A |
60-65
|
C
|
|
85-90 |
A- |
55-60
|
C-
|
|
80-85
|
B+
|
50-55 |
D+ |
|
75-80
|
B
|
45-50 |
D |
|
70-75
|
B-
|
40-45 |
D- |
|
65-70
|
C+
|
35-40 |
F |
Conclusion
Don't forget to use objectives that I wanted. And Please submit your project at the end of the deathline that is 15/06/2015.