|
|
| ENF 146 | Basic Computer - II | 3+1+0 | ECTS:4 | | Year / Semester | Spring Semester | | Level of Course | First Cycle | | Status | Compulsory | | Department | DEPARTMENT of CIVIL ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face | | Contact Hours | 14 weeks - 3 hours of lectures and 1 hour of practicals per week | | Lecturer | -- | | Co-Lecturer | The lecturers of the department of Informatics | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | | To make and edit data lists by means of spreadsheet software, to achieve data processing, analysis and report events in the spreadsheets, to make interactive reports in the style of table and charts. |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | make data lists and edit these lists in the spreadsheet software | 9,10,11 | | | LO - 2 : | process these data lists to derive new results | 9,10,11 | | | LO - 3 : | design scenarios and dynamic reports as using data in the spreadsheet | 9,10,11 | | | LO - 4 : | chart data that they have. | 9,10,11 | | | LO - 5 : | use a spreadsheet software as a professional user | 9,10,11 | | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
Introduction to Microsoft Excel 2003
WorkbooksFormatting
WorksheetsData Input Processes
Formulas and Functions
Charts
Data Lists
PivotTable and PivotChart
ReportsForming Scenarios
Printing Processes
Macros
Working with External Data
Combining Excel with Other Programs
Collaborating with Colleagues |
| |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | | | | | | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | | | | |
|