Course Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | İNG116 | Introduction to Computers and Information Systems II | Compulsory | 1 | 2 | 3 |
|
Level of Course Unit |
First Cycle |
Objectives of the Course |
This course aims to make students use electronic spreadsheet and presentation programs effectively. |
Name of Lecturer(s) |
|
Learning Outcomes |
1 | Making operations related to worksheets in an electronic spreadsheet.; | 2 | Data input into cells and adjusting cells in an electronic spreadsheet.; | 3 | Creating basic formulas in an electronic spreadsheet.; | 4 | Creating formulas using a certain address in an electronic spreadsheet.; | 5 | Using simple mathematical functions (Sum, average..etc.) in an electronic spreadsheet.; | 6 | Using logical functions (if..etc.) in an electronic spreadsheet.; | 7 | Making graphics in an electronic spreadsheet.; | 8 | Editting slides (adding, deleting, copying, moving) in the presentation program.; | 9 | Selecting a design template in the presentation program.; | 10 | Adding picture, automatic shape, sound, video in the presentation program.; |
|
Mode of Delivery |
Normal Education |
Prerequisites and co-requisities |
None |
Recommended Optional Programme Components |
None |
Course Contents |
|
Weekly Detailed Course Contents |
|
1 | Introduction to Course content, importance, requisites and rules of the course. | | | 2 | Worksheets in electronic spradsheet program. | | | 3 | Data input into cells in electronic spradsheet program. | | | 4 | Simple formulas in electronic spradsheet program. | | | 5 | Formulas using a certain address in an electronic spreadsheet. | | | 6 | Simple mathematical functions (Sum, average..etc.) in an electronic spreadsheet. | | | 7 | Logical functions (if..etc.) in an electronic spreadsheet. | | | 8 | Midterm | | | 9 | Graphics in an electronic spreadsheet. | | | 10 | Editting slides (adding, deleting, copying, moving) in the presentation program. | | | 11 | Design templates, pictures, automatic shapes, sound and video in the presentation program. | | | 12 | Slide transition in the presentation program. | | | 13 | Special animation effects for the objects in the presentation program. | | | 14 | Making presentations. | | | 15 | Review of the course. | | | 16 | Final Examination | | |
|
Recommended or Required Reading |
|
Planned Learning Activities and Teaching Methods |
|
Assessment Methods and Criteria | |
Midterm Examination | 1 | 100 | SUM | 100 | |
Final Examination | 1 | 100 | SUM | 100 | Term (or Year) Learning Activities | 40 | End Of Term (or Year) Learning Activities | 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 | 3 | 42 |
Practice | 14 | 2 | 28 |
Laboratory | 14 | 2 | 28 |
|
Contribution of Learning Outcomes to Programme Outcomes |
LO1 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | | LO2 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | | LO3 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | | LO4 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | | LO5 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | | LO6 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | | LO7 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | | LO8 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 2 | 1 | 1 | | | | | | LO9 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 2 | 1 | | | | | | LO10 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1 | 1 | 1 | | | | | |
|
* Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|