Nevşehir Hacı Bektaş Veli University Course Catalogue
|
|||||
| Year/Semester of Study | 1 / Spring Semester | ||||
| Level of Course | 1st Cycle Degree Programme | ||||
| Type of Course | Compulsory | ||||
| Department | ENVIRONMENTAL ENGINEERING | ||||
| Pre-requisities and Co-requisites | None | ||||
| Mode of Delivery | Face to Face | ||||
| Teaching Period | 14 Weeks | ||||
| Name of Lecturer | SEMA ATASEVER (sema@nevsehir.edu.tr) | ||||
| Name of Lecturer(s) | |||||
| Language of Instruction | Turkish | ||||
| Work Placement(s) | None | ||||
| Objectives of the Course | |||||
| To gain the ability to use the spreadsheet software program at basic and intermediate level. | |||||
| Learning Outcomes | PO | MME | |
| The students who succeeded in this course: | |||
| LO-1 | Be able to use the spreadsheet preparation program. |
PO-1 In mathematics, science and engineering fields related to environmental engineering to have these fields in use for the solution of theoretical and practical knowledge of engineering, PO-2 Environmental Science and Environmental Technology on the engineering problems to identify, formulate, and solve engineering problems, for this purpose, select and apply appropriate analytical methods and modeling techniques, PO-3 The modern techniques and tools necessary for engineering practice to select and use skills, ability to use information technology effectively, |
Examination |
| LO-2 | Be able to make table operations in Excel. |
PO-1 In mathematics, science and engineering fields related to environmental engineering to have these fields in use for the solution of theoretical and practical knowledge of engineering, PO-2 Environmental Science and Environmental Technology on the engineering problems to identify, formulate, and solve engineering problems, for this purpose, select and apply appropriate analytical methods and modeling techniques, PO-3 The modern techniques and tools necessary for engineering practice to select and use skills, ability to use information technology effectively, |
Examination |
| LO-3 | Be able to operate with formulas in Excel. |
PO-1 In mathematics, science and engineering fields related to environmental engineering to have these fields in use for the solution of theoretical and practical knowledge of engineering, PO-2 Environmental Science and Environmental Technology on the engineering problems to identify, formulate, and solve engineering problems, for this purpose, select and apply appropriate analytical methods and modeling techniques, PO-3 The modern techniques and tools necessary for engineering practice to select and use skills, ability to use information technology effectively, |
Examination |
| PO: Programme Outcomes MME:Method of measurement & Evaluation |
|||
| Course Contents | ||
| Excel formulas, table usage, charts, macros, filtering and sorting operations. | ||
| Weekly Course Content | ||
| Week | Subject | Learning Activities and Teaching Methods |
| 1 | Excel startup screen, basic components of excel, workspace view, workbook and worksheet concepts, active cell naming conventions. | Distance Education, Description Method and Computer Applications. |
| 2 | Excel create a new workbook, cell operations and data entry, shortcut keys for excel command buttons, adding / removing commands to the quick access toolbar, changing tab color. | Distance Education, Description Method and Computer Applications. |
| 3 | Format Cells (Wrap text, orientation text, add borders, fill and add patterns) window options, customize status bar, simple addition using + operator. | Distance Education, Description Method and Computer Applications. |
| 4 | Getting help, conditional formatting, formula writing and cell reference system, operators used in spreadsheets, IF Function. | Distance Education, Description Method and Computer Applications. |
| 5 | Special paste options, Cell-Row-Column insertion, deletion, hiding operations, sorting data in range or table. | Distance Education, Description Method and Computer Applications. |
| 6 | Creating calculated fields using formulas, filtering data lists, drawing a chart, creating a pivot table, data validation | Distance Education, Computer Applications. |
| 7 | Midterm | Distance Education. |
| 8 | mid-term exam | |
| 9 | Four operations in formulas, basic functions, column chart sample application, creating a macro record in excel | Distance Education, Computer applications. |
| 10 | Graphics applications with Excel | Distance Education, Computer applications. |
| 11 | General repetition, the way the cell contents are displayed, COUNTA function, sample applications. | Distance Education, Computer applications. |
| 12 | General repetition: Data Sort, SUMIF, COUNTIF, COUNTA functions, sample applications. | Distance Education, Computer applications. |
| 13 | General repeat, date and time functions, example applications. | Distance Education, Description Method and Computer Applications. |
| 14 | General repetition, generating different values based on a condition, using autosum, using Excel as a calculator, using nested IF, enabling Flash Fill in Excel, sample applications. | Distance Education, Description Method and Computer Applications. |
| 15 | An overview. | Distance Education, Description Method and Computer Applications. |
| 16 | final exam | |
| Recommend Course Book / Supplementary Book/Reading | ||
| 1 | Anadolu Üniversitesi Temel Bilgi Teknolojileri-I, https://www.anadolu.edu.tr/uploads/anadolu/ckfinder/web/files/BIL101U.pdf | |
| 2 | Frye, C.D. Microsoft Excel 2016 Step by Step. Microsoft Press, 2015. | |
| 3 | Harvey, G. Excel 2016: All-in-One For Dummies. Wiley, 2016. | |
| 4 | https://acikders.ankara.edu.tr/course/view.php?id=4085 | |
| Required Course instruments and materials | ||
| Computer, lecture notes, auxiliary resources. | ||
| Assessment Methods | |||
| Type of Assessment | Week | Hours | Weight(%) |
| mid-term exam | 8 | 2 | 40 |
| Other assessment methods | |||
| 1.Oral Examination | |||
| 2.Quiz | |||
| 3.Laboratory exam | |||
| 4.Presentation | |||
| 5.Report | |||
| 6.Workshop | |||
| 7.Performance Project | |||
| 8.Term Paper | |||
| 9.Project | |||
| final exam | 16 | 2 | 60 |
| Student Work Load | |||
| Type of Work | Weekly Hours | Number of Weeks | Work Load |
| Weekly Course Hours (Theoretical+Practice) | 3 | 14 | 42 |
| Outside Class | |||
| a) Reading | 1 | 10 | 10 |
| b) Search in internet/Library | 1 | 12 | 12 |
| c) Performance Project | 0 | ||
| d) Prepare a workshop/Presentation/Report | 0 | ||
| e) Term paper/Project | 0 | ||
| Oral Examination | 0 | ||
| Quiz | 0 | ||
| Laboratory exam | 0 | ||
| Own study for mid-term exam | 1 | 7 | 7 |
| mid-term exam | 2 | 1 | 2 |
| Own study for final exam | 1 | 10 | 10 |
| final exam | 2 | 1 | 2 |
| 0 | |||
| 0 | |||
| Total work load; | 85 | ||