- 56 (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:
- Protected: • Loading a word processing programme
- Protected: • Using a word processing programme: i. Inserting Objects ii.Text Formatting iii.Page Formatting iv. Mail merging
- Protected: • Working with tables: i. Creating tables ii. Formatting tables: Merging cells, Splitting cells, Shading cells, Cell borders
- Protected: • Working with columns
- Protected: • Sorting
- Protected: • Bullets and numbering (Insertion and customization)
- Protected: • 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:
- Protected: • Features of PowerPoint
- Protected: • Developing and Creating Presentation templates and backgrounds
- Protected: • Run a presentation
- Protected: • Viewing and editing presentations
- Protected: • Working with slides: i. Inserting new slides ii.Inserting duplicate slides iii.Deleting slides iv.Rearranging slides
- Protected: • Working with Graphics/Video/Sound: i. Graphics ii. Video iii. Sound
- Protected: • Working with animation: i.Customized ii.Timing
- Protected: • Printing Presentation: i. Single slides ii. Handouts iii. Notes Page
7. Spreadsheet Application:
• Page formatting:
- Protected: i. Formulas and functions:
- Protected: ii. Common Math operations:
- Protected: iii. Add numbers
- Protected: iv. Calculate the average of numbers in a range
- Protected: v. Calculate the smallest number in a range
- Protected: vi. Calculate the largest number in a range
- Protected: vii. Convert measurements from one unit to another
- Protected: viii. Count cells that contain characters
- Protected: ix. Divide numbers
- Protected: x. Multiply numbers
- Protected: xi. Raise a number to a power
- Protected: xii. Round numbers
- Protected: xiii. Subtract numbers
• Copying formulas and functions:
• Creating conditional formulas:
• Looking up values in a:
- Protected: i. Horizontal list and ii. Vertical list
- Protected: iii. Date operations
- Protected: • Adding dates
- Protected: • Adding times
- Protected: • Calculating the difference between two dates
- Protected: • Calculating the difference between two times
- Protected: • Inserting the current data and time in a cell
- Protected: • Inserting other dates in a cell
• 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
Although this course was very long and enduring. The information was displayed in a excellent way. The explanations were simple and easy to understand. This course was simply great G- Gratifying R- Reliable E-Enthusiastic A-Amazing T- Tremendous
I can truly say that this course has served as a refresher as well as a boost in my overall knowledge of applications used in our day to day lives. I must commend the lecturer for this lengthy but straight forward lesson plan.
This Course has been an excellent guide through in understanding the terminologies of Modern Computing Concepts. It was a great experience.
This course was remarkable, learnt a lot of new information. Being able to learn the history of computers and technology in general, was incredibly interesting. Learning about the different computers, software's, operating systems and functions in MS Office applications was just extremely helpful & useful. The course taught me how to practically do a lot of things that i either never tried before or never knew about. One of the most interesting and intriguing courses i have come across. As i kept reading through the lessons, it just kept me going because of how much interesting information there is. Excellent course.
This course was nothing short of excellent. This course explains everything, starting from the old, to the new, thus the name 'Modern Computing Concepts.' It is always great to know where things started, so that when creating modern technology, you won't make the same mistakes and this course gave a detailed history on computing in the ancient days. Furthermore, with the great inclusion of videos, which makes learning easier, there were detailed lessons on how each prominent workplace Microsoft Applications work. Not only does this course cater for the 2015+ applications but it also facilitates the earlier versions for those that might have it. Before starting the course, i thought i knew everything about the Office applications but i actually did not. I can now say after completing this course that I have a full knowledge and understanding of how the Microsoft Office Applications work. It would be a huge lie if someone finished this course and says they do not know how to use Microsoft Word, Access, Excel and PowerPoint in detail. Excellent Course and I would recommend it to anyone who wants to learn the basics and complexities of Microsoft Applications.