|
Description of Individual Course UnitsCourse Unit Code | Course Unit Title | Type of Course Unit | Year of Study | Semester | Number of ECTS Credits | G115B2 | Information and Computer Technologies | Compulsory | 1 | 1 | 4 |
| Level of Course Unit | First Cycle | Objectives of the Course | Introduction to the main principles in computer technology, study and practice of some programes as MS Word, MS Excel and Power point. Emphasizing the importance of Internet in profesional life. | Name of Lecturer(s) | Dr.Öğr.Üyesi Mustafa Alptekin ENGİN | Learning Outcomes | 1 | To be informed about the general principles of computer technology. | 2 | Learn to write text using MS Word program. | 3 | Learn to edit text using MS Word program | 4 | Using of MS Word program for visual operations. | 5 | Learn calculations by MS Excel program. | 6 | Learn using of functions of MS Excel program. | 7 | Drawing graphics using MS Excel program. | 8 | Demonstrate the possibilities for personal and professional development by using Internet. | 9 | Learn to prepare the presentation by MS Power Point program. |
| Mode of Delivery | Normal Education | Prerequisites and co-requisities | None | Recommended Optional Programme Components | None | Course Contents | History of computer science; Main consepts; Windows system; Introduction and using of MS Word; Internet system, electronic comunications; Introduction and using of MS Excel; Specific calculations by using MS Excel functions; Preparation of tables and graphic by MS Excel; Introduction and using of Power point. | Weekly Detailed Course Contents | |
1 | Main Consepts in Computer science; Windows System; | | | 2 | Use of MS Word programme: introduction and application-preparation of new document; cut/copy/paste; format words and paragraph;use of pullet and numbering; adjust page setting; check spelling;view pages; | | | 3 | Use of MS Word programme:working with lond documents; format text with style; using of “find” and “replace” ; set tabs; insert breaks; employ header and footers; | | | 4 | Use of MS Word programme:employ drop caps; insert picture; printing; print envelop and lables; count words; insert table of contents; | | | 5 | Electronic mail and Internet – screening in library; different ways to reach the databases; the way to acces the information in “web of science” ; | | | 6 | Microsoft Excel program, presentation and applications - a workbook window of the presentation; worksheet creation: entering data, multiple page, input data into a new page, add the page, change the name, save the workbook to workbook, close and delete a file to the window, load a document to a workbook ,get a worksheet from the printer, | | | 7 | MS Excel software applications-the presentation and worksheet editing: create a table, format change, the data copy and delete, enter a formula to-decimal hen to the increase and decrease, copy by inverse, changes in rows and columns, delete / insert of rows and columns, entering formulas by marking method,insert and delete lines,move rows and columns,do basic calculations; | | | 8 | Midterm exam | | | 9 | MS Excel Introduction and applications - excel functions, software, guidelines, examples of excel functions: taking average to receive the largest and the smallest number,find the relative value number, , "if" function, "and" function ,"if" function and "and”used together, more than one "if" function to use; finding sv,use of paste function, naming different regions | | | 10 | MS Excel program applications - other Excel operations: absolute cell addressing- display zero, display the window separately to use the formula shown, data protection, manual and automatic calculations, create charts, functions | | | 11 | Applications of MS Excel - regression analysis, linear and nonlinear equation, matrix processing | | | 12 | Applications of MS Excel - graphics: selection of data for graphic, make changes on the graph: a giving names to axes, draw grid lines, change the chart type | | | 13 | Applications of MS Excel - data base operations: sort records, search records, prepare summary tables report | | | 14 | MS Powerpoint - presentation of the program and applications- create new slides, insert a new slide, add pictures, edit text, add tables, change the slides, save presentations | | | 15 | MS Powerpoint program – applications, use the option-animation, add sound to the slide, set animated objects, create presentations | | |
| Recommended or Required Reading | Taşbaşı, A.;Altınbaşak, 0,1999, Bilgisayara Giriş,Altaş Basım Yayın Dağıtım, İstanbul, 589 pp. Anonymous,Microsoft Word",Catapult Inc, Washington (1997). Anonymous, "Microsoft Excel", Catapult Inc, Washington (1997). | 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 | 2 | 2 | Final Examination | 1 | 2 | 2 | Attending Lectures | 14 | 2 | 28 | Laboratory | 2 | 15 | 30 | Individual Study for Mid term Examination | 1 | 15 | 15 | Individual Study for Final Examination | 1 | 17 | 17 | Performance | 13 | 2 | 26 | |
Contribution of Learning Outcomes to Programme Outcomes | LO1 | | | | | | | LO2 | | | | | | | LO3 | | | | | | | LO4 | | | | | | | LO5 | | | | | | | LO6 | | | | | | | LO7 | | | | | | | LO8 | | | | | | | LO9 | | | | | | |
| * Contribution Level : 1 Very low 2 Low 3 Medium 4 High 5 Very High |
|
|
|
|