- 6 (Registered)
We are living in a world that is characterized by rapid change, voluminous data, and complex dynamics, the graduate of the ICT Associate degree programme will be employed by organizations that are striving to remain viable in the Information Age. The use of technological tools instead of humans to perform many job functions will increase in popularity in years to come. As it is only through use of these tools that organizations will be able to improve the efficiency of their operations. This course is intended to prepare the graduate to become the driving force behind organisations as they seek to utilise various application tools to advance the productivity within the workplace. This course is important to include in the offerings for all majors in the ICT Associate degree programme as it seeks to develop relevant application utilisation skills in ICT student. These skills will enable graduates to achieve gainful employment, and equip them to ably assist others within the work environment to develop and hone technical application skills.
This course provides students with comprehensive exposure to the nature, purpose, functions and utilisation of application tools in different organisations. It entails a thorough introduction to computers, word processing, presentation, spreadsheets and database application uses and functions. It seeks to develop application usage skills in all students and provide multiple opportunities for students to use them to solve problems in their everyday life. This course has some theoretical experiences, but the majority of the contact hours that have been embedded are focused on providing students with hands-on experiences with these tools.
On completion of this course students should be able to:
- Describe and use different application software to solve real organisational problems
- Create a graphical representation of the history of computing.
- Write an essay on the genesis of the World Wide Web and use personal experiences to explain its value to modern society.
- Apply the principles of data processing, storage and output in real work settings.
- Draw and label the parts of a computer system
- Evaluate the usefulness of different computer application software
- Differentiate between type of computer, software and operating systems.
- Use a spreadsheet application to calculate and analyse data
- Use a word processing application to create, format and distribute different types of organisational support documents.
- Use a database application to create systems that will serve to store, organise and manage organisational data.
- Use a presentation and graphic application to create organisational present.
- Use an e-mail and web browser application to communicate, distribute and locate different kinds of informational documents.
- Use a web browser to locate information on different topics.
TEACHING AND LEARNING METHODS
- Instructor and Student Presentations
- Application Labs
- Whole and Small Group Discussions
- Group Presentations
- Group and Individual Projects
- Internet-Supported Research
- Instructor Demonstrations
|a) Mid Term||[20 Marks]|
|b) Oral Presentation||[20 Marks]|
|c) Research Project||[20 Marks]|
Final Examination (40%)
|Task / Assignment No. & Name||Due Date||Time||Weight||Type||Learning Outcomes|
|1. Oral Presentation||Sept. 30th||10 am||20%||Group / Summative||1,2,3,4,5|
|2. Research||Oct. 28th||10 am||20%||Project||6,7,8,9|
|3. Mid Term Examination||Nov. 25th||10 am||20%||Test||10,11,12,13|
|4. Final Exam||December||40%||Individual||1-13|
Nb: Dates are subjected to be changed.
TEXTBOOKS AND REFERENCES
- Shelly G.B., & Cashman, T.J. (2015). Discovering computers 2016 (Complete Shelly Cashman Series). KY: Course Technology Publishing.
- Long L., & Long, N. (2003). Computers: Information technology in perspective. (11th ed.). New Jersey: Prentice Hall.
- Shelly G., Cashman T., & Vermaat M. (2013). Microsoft Office 2016: Introductory concepts and techniques (Windows XP Edition). Complete concepts and techniques. KY: Course Technology Publishing.
1. The history of computers, the Internet and Worldwide Web:
2. Overview of computing:
SECTION A. Oral Presentation
3. Computer Software
4. Data Processing Concepts:
5. Word Processing Application:
- • Loading a word processing programme
- • Using a word processing programme: i. Inserting Objects ii.Text Formatting iii.Page Formatting iv. Mail merging
- • Working with tables: i. Creating tables ii. Formatting tables: Merging cells, Splitting cells, Shading cells, Cell borders
- • Working with columns
- • Sorting
- • Bullets and numbering (Insertion and customization)
- • Printing documents: i.Choosing a printer ii.Selection print quality iii.Printing multiple copies of the same document
SECTION B. Research
6. Presentation and Graphics Application:
- • Features of PowerPoint
- • Developing and Creating Presentation templates and backgrounds
- • Run a presentation
- • Viewing and editing presentations
- • Working with slides: i. Inserting new slides ii.Inserting duplicate slides iii.Deleting slides iv.Rearranging slides
- • Working with Graphics/Video/Sound: i. Graphics ii. Video iii. Sound
- • Working with animation: i.Customized ii.Timing
- • Printing Presentation: i. Single slides ii. Handouts iii. Notes Page
7. Spreadsheet Application:
• Page formatting:
- i. Formulas and functions:
- ii. Common Math operations:
- iii. Add numbers
- iv. Calculate the average of numbers in a range
- v. Calculate the smallest number in a range
- vi. Calculate the largest number in a range
- vii. Convert measurements from one unit to another
- viii. Count cells that contain characters
- ix. Divide numbers
- x. Multiply numbers
- xi. Raise a number to a power
- xii. Round numbers
- xiii. Subtract numbers
• Copying formulas and functions:
• Creating conditional formulas:
• Looking up values in a:
• Formatting cells:
• Formatting graphs:
8. Database Application • Creating and Maintaining a SQL Database:
- i. Learn the guidelines for designing database and setting field properties
- ii. Create a new database
- iii. Create and save a table
- iv. Define fields and specify a table’s primary key
- v. Add records to a table
- vi. Modify the structure of a table
- vii. Delete, move and add fields
- viii. Change field properties
- ix. Copy records and import tables from another database
- x. Delete and change records
• Querying a Database:
viii. Creating Forms and Reports:
- ix. Creating forms using the form wizard
- x. Create forms using auto format
- xi. Change a form auto Format
- xii. Find data using a form
- xiii. Preview and print selected form record
- xiv. Create a report using the Report wizard
- xv. Check errors in a report
- xvi. Insert a picture in a report
- xvii. Preview and print a report
SECTION C. Mid Term Examination
SECTION D. Final Exam