Course Objectives
1) Students will be able to operate EXCEL basically.
2) Students will be able to use basic functions and formula.
Rubric
| Ideal Level of Achievement (Very Good) | Standard Level of Achievement (Good) | Unacceptable Level of Achievement (Fail) |
Evaluation 1 | Students will be able to operate EXCEL smoothly. | Students will be able to operate EXCEL. | Students will be unable to operate EXCEL. |
Evaluation 2 | Students will be able to use basic functions and formula, smoothly. | Students will be able to use basic functions and formula. | Students will be unable to use basic functions and formula. |
Assigned Department Objectives
Teaching Method
Outline:
Microsoft Excel are spreadsheet software created by Microsoft. Excel is an indispensable software for dealing with numerical data. Therefore, in this lecture, students will learn how to use Excel. Students will also learn the ability of presentations using electronic data.
Style:
This class will be a mix of lectures and exercise style.
Notice:
Those who receive a score of less than 60 points can petition for a supplementary examination. In a case that those who will be awarded credits by the examination, the score will be 60 points.
Characteristics of Class / Division in Learning
Course Plan
|
|
|
Theme |
Goals |
1st Semester |
1st Quarter |
1st |
Outline |
Explanation of the lecture schedule
|
2nd |
Basic operation of EXCEL |
Input data into cells
|
3rd |
Basic operation of EXCEL |
Editing worksheets; row, column and other format
|
4th |
Basic operation of EXCEL |
Position of character, and editing other formats
|
5th |
Data totalization |
Continuous data inputting and auto summation
|
6th |
Data totalization |
Auto average and refference of cells
|
7th |
Data totalization |
Absolute refference address and relative
|
8th |
Use of basic functions |
MAX, MIN
|
2nd Quarter |
9th |
Use of basic functions |
COUNT, COUNTA
|
10th |
Use of basic functions |
ROUND, ROUNDUP, ROUNDDOWN
|
11th |
Use of basic functions |
IF
|
12th |
Use of basic functions |
Exercise
|
13th |
Construction formula which is contains IF function. |
Complex use of IF function
|
14th |
Construction formula which is contains IF function. |
Exercise
|
15th |
Term examination |
Confirmation of the lecture contents
|
16th |
Confirmation of score |
Summalize the lecture and confirm the score.
|
2nd Semester |
3rd Quarter |
1st |
Outline |
Explanation of the lecture schedule
|
2nd |
Making charts |
Graphs; bar chart, stacked bar chart
|
3rd |
Making charts |
Line chart, circle chart
|
4th |
Making charts |
Exercise
|
5th |
Database function on EXCEL |
Sorting of data
|
6th |
Database function on EXCEL |
Use database functions
|
7th |
Database function on EXCEL |
Totalization with database on EXCEL
|
8th |
Middle examination |
Confirmation of the lecture contents
|
4th Quarter |
9th |
Making slides of presentation |
Format of slides for research presentation
|
10th |
Practice of presentation |
making of slides research theme
|
11th |
Practice of presentation |
making of slides research theme
|
12th |
Practice of presentation |
making of slides research theme
|
13th |
Practice of presentation |
making of slides research theme
|
14th |
Practice of presentation |
making of slides research theme
|
15th |
Practice of presentation |
making of slides research theme
|
16th |
Presentation |
Making presentation for research theme
|
Evaluation Method and Weight (%)
| Examination | Issue | Total |
Subtotal | 80 | 20 | 100 |
Basic Ability | 50 | 10 | 60 |
Technical Ability | 30 | 10 | 40 |
Interdisciplinary Ability | 0 | 0 | 0 |