Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | BİM11620109128 | COMPUTER USAGE-II | Compulsory | 1 | 2 | 2 |
|
Level of Course Unit |
Short Cycle |
Objectives of the Course |
To create various types of tables
To calculate
To convert the digital data to the chart table |
Name of Lecturer(s) |
Öğr. Gör. Dr. Devrim Karademir |
Learning Outcomes |
1 | To use MS Excel 2010 program. | 2 | To write formulas in MS Excel | 3 | To create a table in the program. | 4 | To perform data analysis in the program. | 5 | To create a chart from a table. |
|
Mode of Delivery |
Formal Education |
Prerequisites and co-requisities |
None |
Recommended Optional Programme Components |
None |
Course Contents |
Features of MS Excel,
Creating Excel Workbook,
To make control over Worksheets,
To use formatting,
Introduction of the formula used in the program,
Formula writing rules,
To create a table,
To perform data analysis,
To convert tables |
Weekly Detailed Course Contents |
|
1 | Introduction to Excel 2010 program. | | | 2 | To format cells and worksheets | | | 3 | To work with Worksheets and Workbooks. | | | 4 | To work with functions. | | | 5 | To work with functions. | | | 6 | To work with functions. | | | 7 | To work with functions. | | | 8 | Midterm Exam | | | 9 | To create table | | | 10 | To review on the tables | | | 11 | Database Operations | | | 12 | Data analysis | | | 13 | Data analysis | | | 14 | To work with Graphics. | | | 15 | PivotTable and Chart | | | 16 | Final Exam | | |
|
Recommended or Required Reading |
- Basılmamış Ders Notları
- Elektronik Tablolama Modülü, MEGEP
- Microsoft Excel 2010, Osman GÜRKAN
|
Planned Learning Activities and Teaching Methods |
|
Assessment Methods and Criteria | |
SUM | 0 | |
SUM | 0 | Yarıyıl (Yıl) İçi Etkinlikleri | 40 | Yarıyıl (Yıl) Sonu Etkinlikleri | 60 | SUM | 100 |
| Language of Instruction | Turkish | Work Placement(s) | None |
|
Workload Calculation |
|
Midterm Examination | 1 | 1 | 1 |
Final Examination | 1 | 1 | 1 |
Attending Lectures | 14 | 2 | 28 |
Practice | 14 | 1 | 14 |
Self Study | 14 | 1 | 14 |
Individual Study for Mid term Examination | 1 | 2 | 2 |
Individual Study for Final Examination | 1 | 2 | 2 |
|
Contribution of Learning Outcomes to Programme Outcomes |
LO1 | | | | 5 | 3 | 5 | | | 2 | 3 | | | | 4 | | | | | | 3 | LO2 | | | | 5 | 3 | 5 | | | 2 | 3 | | | | 4 | | | | | | 3 | LO3 | | | | 5 | 3 | 5 | | | 2 | 3 | | | | 4 | | | | | | 3 | LO4 | | | | 5 | 3 | 5 | | | 2 | 3 | | | | 5 | | | | | | 3 | LO5 | | | | 5 | 3 | 5 | | | 2 | 3 | | | | 5 | | | | | | 3 |
|
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|
Ordu University Rectorate Building ,Cumhuriyet Campus , Center / ORDU / TURKEY • Tel: +90 452 226 52 00
|