RHT 3010 - Advanced Computer Applications
Clock Hours: 100
Delivery Mode
on-ground
Prerequisites: RHT1020 or RHT2020
Industry Certifications IC3 Certification
Course Description:
This course covers key applications used for productivity in the business world as well as the ability to work in a networked environment. Student will gain knowledge on all the common features of basic productivity applications and how to successfully use them in a variety of career fields. At the end of this course, the student will be well prepared to take the Certiport IC3 Certification.
Student Learning Outcomes:
Course Competencies:
A. Demonstrate proficiency with Key Applications
1. Describe the difference between apps and applications.
2. Identify various types of apps and applications and identify which types are best suited for particular tasks.
3. Use an app store and install, delete, and recover apps.
4. Start, exit and identify common screen elements in Microsoft Word
5. Create, save and open documents in Word
6. Insert, select, modify, and format text in Word
7. Change margins, paper size, and orientation using Word
8. Insert or remove page breaks and page numbers
9. Print and preview documents, insert pictures, and work with tables in Word
10. Understand basic terminology and concepts for spreadsheets
11. Create new worksheets or use templates both online and within the spreadsheet program
12. Start, exit, and identify common screen elements in Microsoft Excel
13. Enter and edit data in a worksheet
14. Change column width, row height, create simple formulas and use common built-in functions
15. Insert and edit data in a worksheet to enhance it
16. Work with charts
17. Preview and print a report using Excel
18. Understand the purpose and function of relational databases
19. Enter and edit database information inside the Excel spreadsheet
20. Understand database elements and database relationships in Excel
21. Define Structured Query Language (SQL)
22. Know the difference between table metadata and primary key functions
23. Define the differences among “One-to-One”, “One-to-Many” and “Many-to-Many” relationships within tables
24. Run a database query
25. Plan and design a multimedia presentation using Microsoft PowerPoint
26. Create, save, close, open, and switch between presentation files
27. Manipulate text and objects on slides
28. Insert pictures and multimedia objects on slides
29. Change view displays
30. Insert, modify and delete slides
31. Change the layout and order of slides
32. Apply transitions and animation to slides
33. Share presentation with others
34. Publish slides
B. Work in a Networked Environment
1. Explain the nature of the internet and the role and function of web browsers
2. Explain how web sites are organized
3. Identify common web page elements
4. Perform basic tasks using web browser
5. Conduct research and evaluate information found on the internet
6. Identify and use various digital communication technologies
7. Coordinate with contacts using email and calendars
8. Practice good digital citizenship
9. Manage online identity
10. Recognize health risks associated with computing
|
