Epuit.net



4692015-289560-27114529210Module (Course Syllabus) Catalogue2020-20201College/ Institute Koya Technical Institute DepartmentInformation TechnologyModule NameFundamental of Information TechnologyModule CodeDegreeTechnical DiplomaSemesterFirst SemesterQualification PhDScientific TitleLecture Credits6Module typeXPrerequisite Core Assist.Weekly hours4Weekly hours (Theory)( 2 )hr Class( )hr WorkloadWeekly hours (Practical)( 2 )hr Class( )hr WorkloadLecturer (Theory)Dr. Syamnd M. AbdullahE-Mail & Mobile NO.Syamnd.abdullah@epu.edu.iq+964 7711550154Lecturer (Practical)Rezan Shera SabrE-Mail & Mobile NO.07736986319 Course nameFundamental of Information TechnologyLecturer in chargeDepartment/ CollegeInformation TechnologyContactSyamnd.abdullah@epu.edu.iqTel: +964 7711550154 Time (in hours) per weekTheory: 2Practical: 2Course Code Office hours Availability of the lecturer to the student during the weekTeacher's academic profileCurrently, I'm a lecturer for undergraduate students at Koya technical institute in Information Technology department. KeywordsCourse Overview: The aims of fundamental Computer is provides students with an opportunity to develop understanding of the basic operations of a computer system and computer applications software. In additional, this course gives more information about internet, computer network and using email. Course objective: The Objective of Fundamental Computer prepares a student for basic knowledge using computer to solve data processing problems in daily life After completion of the course, students should be able to:1 – develop among students the programming techniques and the problem solving skills through programming.2 – Show an awareness of what the major computer components are and how they act as system.3 - Demonstrate a knowledge and understanding of using computers to solve problems related to practical applications.4 - use computer applications software to solve problems5 - understand and discuss software and hardware in easy way of part of the computerStudent Obligation 1 - deal with in a certain way all students with love and emotion2 - respects the value of being just and honest to all students irrespective of their caste.3 - Attendance is an essential requirements for all students even if in class or exam. for example if students missed the exam without any authorized letter from Dean or Ass. Dean and Head of department will be loss the mark for exam, otherwise will be repeated the exam in appropriate time.Forms of teachingThere are a number of forms of teaching with a variety of different styles, such as Data Slide Show in Power point employ during the class. However, inside the have to put picture, chart, table and some notice write with powerful explain the class. The first class in two hours will be talk about background of class and the main Principles. Plus, in the end half hours of class should be review all the class and discussion between student and lecture to answer the question students. Finally, the next class will be able to do practical of the theory previous class. Assessment schemeStudents assess based on seasonal exams and preparing reports in the mid of season and short presentation about their report with attendance and contribution in the daily activates. At the end of the course, they should take a final exam. All the above assessments will be marked.Grading policyBreakdown of overall assessment and examinationsHomework…………………………………………………………. 14Class Activity………………………………………………………….2Report, Seminar, Paper, Essay and Project…………..10Lab Report and Activates (Practice)…………………….14Quiz ( Theory + Practice )……………………………………..4Mid Term (Theory)……………………………………………….6Final (Theory)…………………………………………………….15Mid Term (Practice)…………………………………………….10Final (Practice)……………………………………………………25Total grade or mark……………………………………………100Student learning outcome:Upon successful completion of this subject, students should:be able to define and appropriately use information technology terms; be able to identify computer hardware components and describe their function; be able to describe the essential elements of the computer's architecture and discuss how this architecture functions; be able to describe the characteristics and representations of data, and interpret and compare data in different representations; be able to identify and describe telecommunication components; be able to describe the characteristics of operating systems and compare different operating systems;be able to discuss the general trends in technologies including examples of leading edge developments; be able to compare the roles of different sectors of the information technology industry.Course Reading List and References:Key references:Mathews Leon, Introduction to Information Technology, 2013.Magazines and review (internet):Computer Fundamentals Tutorial (Lecturer provides it in pdf).The Topics:Lecturer's nameNo. of WeekCategory Syllabus Sections1 and 2Basic concepts in information technologyComputer SystemInformation Technology.Type of Computer.Parts of computerEquipmentThe Central Processing Unit.Input DevicesOutputInput/output DevicesMemory, storage andPerformanceKind of memoryForms of Primary MemoryPower CutsData Representation in the MemoryMemory ChipsSecondary StorageStorage DevicesStored DateComputer PerformanceComputer Software.InterfaceSystem DevelopmentMultimediaComputers at workComputers and peopleComputer UseComputer Applications in BusinessComputer Applications in GovernmentalInstitutionsComputer in HospitalsComputer in EducationTele workingE-commerce 3 and 4 Introduction to softwareUnderstanding SoftwareIntroduction to Operating System (O.S)Introduction to Windows 7Starting windowsTurning off your computerUsing mouseDesktopTask BarStart MenuChange the start menu styleOperating a programMinimize, Maximize, closeSwitching between RunningMoving windowsResizing WindowsMy documentsMy Recent DocumentsRemove My Documents ItemsMy Pictures & My MusicControl PanelControl panel ViewsScreen saverChanging the Look of Windows ElementsScreen Colors SettingsDate and TimeRegional SettingsSet, Change Keyboard LanguageVolumeAssigning Sounds to system EventsReversing Your Mouse ButtonsAdjusting the Double Click SpeedPointers SpeedAdding / Removing ProgramsRecycle BinStartShut downFolders, Files, Renaming and DrivesMy ComputerPart of WindowsCopy File and Folder5 and 6MS Word BasicsIntroduction to MS Word 2010Getting Started Word 2010Explore Window in Word 2010Backstage View in Word 2010Entering Text - Microsoft Word 2010How to Switch the Language to English orArabicMove Around in Word 2010Save Document in Word 2010Open Document in Word 2010Close Document in Word 2010Editing DocumentsInsert Text in Word 2010Select Text in Word 2010Delete Text in Word 2010Move Text in Word 2010Copy, Cut & Paste in Word 2010Find & Replace in Word 2010Spell and Grammar Check in Word 2010Zoom In and Zoom Out in Word 2010Special Symbols in Word 2010Undo and Redo the Changes in Word 20107 Formatting TextSetting Text Fonts and Size in Word 2010Text Decoration in Word 2010Change Text Cases in Word 2010Change Text Colors in Word 2010Text Alignments in Word 2010Indent Paragraphs in Word 2010Create Bullets & Numbering in Word 2010Set Line Spacing in Word 2010Borders and Shades in Word 2010Copy and Apply Formatting in Word 2010Formatting PagesAdjust Page Margins in Word 2010Add Header and Footer in Word 2010Add Page Numbers in Word 2010Insert Page Breaks in Word 2010Insert Blank Pages in Word 2010Cover Pages in Word 2010Page Orientation in Word 2010Working With TablesCreate a Table in Word 2010Rows & Columns in Word 2010Move a Table in Word 2010Resize a Table in Word 2010Merging Table Cells in Word 2010Split a Table in Word 2010Split a Table Cells in Word 2010Add Formula to a Table in Word 2010Table Borders & Shades8Advanced OperationsQuick StylesUse TemplatesUse Graphics in Word 2010Auto Correction in Word 2010Auto Formatting in Word 2010Create Table of Contents in Word 2010Preview Documents in Word 2010Printing Documents in Word 2010Email Documents using Word 2010Translate Word 2010 DocumentCompare Documents in Word 2010Document Security in Word 2010Set Watermark in Word 20109Introduction to SpreadsheetThis section will explain what a Spreadsheet is and how it is benefited. Using the ApplicationExplain how many ways to open a spreadsheet applicationThis section gives an overview of the Excel screen elementsWorkbookDefine workbook and consistsWorksheetExplain rows and columnsExplain move in a worksheet.Create a new spreadsheet based on default templateIn this section, the file will first be saved as a workbook documentSave a spreadsheet to a location on a driveSave a spreadsheet as another file type like: template, text file, software specific file extension, version numberSwitch between open spreadsheetsUnderstand that a cell should contain only one element of dataEnter text in a cellSelect a cell, rang of adjacent cellsSelect a range of non-adjacent cellsSelect an entire worksheetEdit cell content, modify existing cell contentUse the undo, redo commandUse the search command for specificUse the replace command for specific content in a worksheetUse the replace command for specific content in a worksheet Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic orderascending, descending alphabetic order Copy the content of a cell, cell range within a worksheet, between worksheets, between openUse the autofill tool/copy handle tool to copy, increment data entries Move the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets, Delete cell contents Explain move in a worksheet..Create a new spreadsheet based on default template In this section, the file will first be saved as a workbook document Save a spreadsheet to a location on a drive Save a spreadsheet as another file type like: template, text file, software specific file extension, version number Switch between open spreadsheets Understand that a cell should contain only one element of data Enter text in a cell Select a cell, rang of adjacent cells Select a range of non-adjacent cells Select an entire worksheet Edit cell content, modify existing cell content Use the undo, redo command Use the search command for specific content in a worksheet Use the replace command for specific content in a worksheet Sort a cell range by one criterion in ascending, descending numeric order, ascending, descending alphabetic order Copy the content of a cell, cell range within a worksheet, between worksheets, between openspreadsheetsUse the autofill tool/copy handle tool to copy,increment data entriesMove the content of a cell, cell range within aworksheet, between worksheets, between openspreadsheetsDelete cell contentsSelect a range of non-adjacent cellsSelect an entire worksheetEdit cell content, modify existing cell contentUse the undo, redo commandUse the search command for specific content in aworksheetUse the replace command for specific content in aworksheetSort a cell range by one criterion in ascending,descending numeric order, ascending, descendingalphabetic orderCopy the content of a cell, cell range within aworksheet, between worksheets, between openspreadsheetsUse the autofill tool/copy handle tool to copy,increment data entriesMove the content of a cell, cell range within aworksheet, between worksheets, between openspreadsheetsDelete cell contentsSelect rows and columnsInsert rows and columnsDelete rows and columnsModify column widths, row heightsFreeze, unfreeze row and column titlesApply validation rule based on cell contentApply conditional formatting based on cellcontentSwitch between worksheetsInsert a new worksheet10Managing WorksheetsCopy, move worksheets between spreadsheetsRename worksheetDelete a worksheetHide, show rows, columns, worksheetsChange cell content appearance: font sizes, fonttypesApply formatting to cell contents: bold, italic,underline, double underlineApply different colours to cell content, cellbackgroundCopy the formatting from a cell, cell range toanother cell, cell rangeEnter and format numbers and datesFormat cells to display a currency symbolFormat cells to display a date styleFormat cells to display numbers as percentagesFormat cells to display a specific number ofdecimal placesFormat cells to display numbers with, without aseparator to indicate thousandsApply text wrapping to contents within a cell, cellrangeAlign cell contents: horizontally, vertically.Adjust cell content orientationMerge cells and Centre a title in a merged cellAdd border effects to a cell, cell range: lines,colorsRecognize good practice in formula creation:refer to cell references rather than type numbersinto formulasCreate formulas using cell references andArithmetic Formulasarithmetic operators (addition, subtraction,11multiplication, division)Identify and understand standard error valuesassociated with using formulas: #NAME?,#DIV/0!, #REF!Use sum, average, minimum, maximum, count,Functionscounta, round functions.Use the logical function if (yielding one of twospecific values) with comparison operator: =, >, <ChartsCreate different types of charts from spreadsheetdata: column chart, bar chart, line chart, pie chartChange worksheet margins: top, bottom, left,rightChange worksheet orientation: portrait,Landscape. Change paper sizeAdjust page setup to fit worksheet contents on aspecified number of pagesAdd, edit, delete text in headers, footers in aworksheetInsert and delete fields: page numberinginformation, date, time, file name, worksheetPrepare Outputsname into headers, footersCheck and correct spreadsheet calculations andtextTurn on, off display of gridlines, display of rowand column headings for printing purposesApply automatic title row(s) printing on everypage of a printed worksheetPreview a worksheetPrint a selected cell range from a worksheet, anentire worksheet, number of copies of aworksheet, the entire spreadsheet, a selected chartIntroduction toThis section will explain what a PowerPoint isPowerPointand how it is benefited.Explain how many ways to open a PowerPointUsing the ApplicationapplicationThis section gives an overview of the PowerPointscreen elementsNew PowerPoint DocumentFind and apply a templateAdding Additional SlidesManaging PowerPointView Slides vs. OutlinesFormatting TextSlide TransitionsSlide Animations12 and 13Starting a Slide ShowPrint PreviewPrepare OutputsPrint LayoutSlide ColorSaving SlidesInsert Header & FooterInserting PicturesInserting Clip ArtInsert ShapesAdditional FeaturesInserting WordArtInserting Smart ArtInserting Tables or ChartsInserting HyperlinksCreating a Photo AlbumConcept of InternetInternetApplications of InternetConnecting to the InternetTroubleshootingWorld Wide Web (WWW)Popular Web Browsing Software14 and 15Popular Search Engines / Search for contentAccessing Web BrowserSearch EnginesUsing Favorites FolderDownloading Web PagesPrinting Web PagesUnderstanding URLSurfing the webUsing e-governance websiteInformation SecurityComputer in everyday lifeProjects18. PracticalTopics (If there is any)nonenoneTheory and practice the same topics19. Examinations:1. Defile the following items briefly:4.Control Panel 5.Page setup1. Computer system 2.Memory 3.CPU2. True or false type of exams:In this type of exam a short sentence about a specific subject will be provided, andthen students will comment on the trueness or falseness of this particular sentence. Examples should be provided.3. Multiple choices:In this type of exam there will be a number of phrases next or below a statement,students will match the correct phrase . Examples should be provided.EXAMPLE/ Computer consist two main parts …………… and…………….d/systemc/ programb/ software a/ Hardwareb/a/ and Answer/ 20. Extra notes:Here the lecturer shall write any note or comment that is not covered in this template and he/she wishes to enrich the course book with his/her valuable remarks.21. Peer review ????????????? ?????? This course book has to be reviewed and signed by a peer. The peer approves theContents of your course book by writing few sentences in this section. (A peer is person who has enough knowledge about the subject you are teaching; he/she has to be a professor, assistant professor, a lecturer or an expert in the field of your subject).??? ????????? ?????? ??????? ????????? ??????????? ???? ?????? ? ???????? ?????????? ??????? ????? ???? ? ???? ??????? ???????? ????? ????? ???????? ??????? ? ?????? ????? ????. ?????? ??? ???????? ??????? ?????? ????? ??????? ? ?????? ???? ?????? ?? ??????? ????? ?????? ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download