Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    LCU-COS 118 Course Content 2024

    Uploaded by

    emmanuelfisayo94

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    LCU-COS 118 Course Content 2024

    Uploaded by

    emmanuelfisayo94
    2 views3 pages

    Original Title

    LCU-COS_118_Course_Content_2024

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    2 views3 pages

    LCU-COS 118 Course Content 2024

    Uploaded by

    emmanuelfisayo94

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    LEAD CITY UNIVERSITY

    Faculty of Natural and Applied Sciences


    Department of Computer Science
    Second Semester 2023/2024 Academic Session

    COURSE PARTICULARS
    Course Code: LCU-COS 118
    Course Title: Application of Software Packages
    No. of Units: 3
    Status: Compulsory

    LECTURERS’ DETAILS
    Name: Dr Wilson Sakpere
    Qualifications: BEng. Hons. (Ilorin), MTech. (Cape Town), PhD. (Bologna)
    Phone: +234 913 779 2962
    Email: [email protected]
    Area of Specialisation: Computer Vision, Networks, Pattern Recognition

    Name: Dr E. G. Igwe
    Qualifications: MSc, PhD (Ibadan)
    Phone: +234 806 500 0573
    Email: [email protected]
    Area of Specialisation: Data Science, Health Informatics, Artificial Intelligence

    COURSE DESCRIPTION
    This is a hands-on course that introduces students to computer applications and software
    packages such as word processors, spreadsheets, database management, graphical
    presentation, MATLAB (Octave), R and SPSS. It equips them with basic skills to use up-to-date
    computer applications and software packages, to use the computer to collect, analyse and edit
    data, and to manipulate, process, present and communicate information. The course shall also
    explore scientific document preparation and publishing using appropriate packages such as
    Office Suite and Latex.

    COURSE OBJECTIVES
    The focus of this course is to enable students to develop an understanding of the principles and
    theory behind computer applications and software packages, At the end of the course, students
    should be able to:
    • Create, edit and format word processing files to produce assignments, research reports,
    letters and email messages.
    • Use spreadsheets to create and modify graphical charts.
    • Use spreadsheets to manage data and perform basic statistical analysis of research data
    with the analysis tool pack.
    • Create PowerPoint presentations that are composed of both text and graphical
    information.
    • Create and manage a flat-file database with Access.
    • Write simple codes for solving real-life problems using MATLAB (Octave) and R Packages.
    • Perform data analysis and visualization using R and SPSS.
    • Perform scientific document preparation and publishing using appropriate packages such
    as Office Suite and Latex.

    ASSESSMENT
    Class Attendance 20 marks
    Assignments 10 marks
    Test 10 marks
    Final Examination 60 marks

    LECTURE PLAN
    Week Topic
    Week 1 Microsoft Word: Screen layout, opening and creating documents, typing and
    inserting text, formatting paragraphs, styles, lists, tables, spelling and grammar,
    page formatting, table of contents.
    Week 2 Microsoft Excel: Spreadsheet basics, modifying a worksheet, formulas and
    functions, charts, page properties and printing.
    Week 3 Laboratory exercises.
    Week 4 Microsoft PowerPoint: Getting started with PowerPoint, screen layout, working
    with slides, adding content, working with text, colour schemes, and graphics.
    Week 5 Microsoft Access: Plan and design Access database, create a table using database
    wizard, modify a table by adding new data categories, use forms to add data to
    database tables, create and run a query, create and print reports, create data
    access page.
    Week 6 Laboratory exercises.
    Week 7 MATLAB (Octave): Introduction to MATLAB, visualization and programming, solving
    equations, curve fitting and numerical techniques, various functions and toolboxes,
    linear programming using MATLAB (Octave).
    Week 8 Linear Programming using R Studio. SPSS
    Week 9 Data analysis using SPSS.
    Week 10 Laboratory exercises.
    Week 11 Test
    Week 12 Revision.
    READING LIST
    1. Learning computer applications: Projects and exercises, by Bucki A. Lisa, Prentice hall, 2005.
    2. Discovering Computers 2011: Living in a Digital World, by Shelly B. Gary and Vermaat E.
    Misty, Cengage Learning, 2001.
    3. An Introduction to MATLAB, by David F. Griffiths, University of Dundee, 2015.
    4. LATEX Tutorials — A Primer, by E. Krishnan and G. S. Krishna, Indian TEX Users Group, 2003.
    5. MATLAB Demystified: A self-teaching guide, by David McMahon, McGraw-Hill, 2007.
    6. Introduction to R, by Woundjiague, Jomo Kenyatta University of Agriculture and Technology,
    Kenya, 2018.
    7. Statistical Programming with R, by J. K. Mung’atu, Department of Statistics and Actuarial
    Science, Jomo Kenyatta University of Agriculture and Technology, Kenya, 2013.
    8. SPSS statistics for data analysis and visualization by McCormick, K., and Salcedo, J. 2017.
    9. How to use IBM SPSS statistics: A step-by-step guide to analysis and interpretation.
    Routledge by Cronk, B. C. 2016.
    10. SPSS demystified. A step-by-step guide to successful data analysis by Yockey, R. D. 2011.

    You might also like