ABCDEFGHIJKLMNOPQRSTUVW
1
LessonHoursDateTopicsLearning objectives
Learning outcomes
Column 5Column 6Column 7Column 8Column 9Column 10Column 11Column 12Column 13Column 14Column 15Column 16Column 17Column 18Column 19Column 20Column 21
2
3
Teacher's Name:
4
Module name:Application Software : Module 08
5
Class Group:CS200831
6
120 hrs - 9 hrs (Code 1, Remediation, Code 8) = 111 hours PURE TEACHING TIME
7
9
lesson #hoursDate - AM/PMTopicsExpected Learning OutcomeLearning activitiesLearning EnvironmentEvaluation for certificationAssessment in support of learningresourceshabits of practice (previous learning), review
10
 briefly decsribe the lessonexpected outcome / learning objectiveperformance criteriatheory, demo, practice LAB, classroom, 235, or out of the building
11
lesson 1311/20/2020 AMIntro - Give course outline, course format, explain procedures, overview application softwares, discussionspreknowledge
theory		classroomQuiz - what they already know to situate previous knowledgeHigh school computer classes
working in office software on your own, or in the workforce
12
611/20/2020 PMIntro - Use of application software in the workplace (computing support / IT related jobs), Common application softwares in the industry, Software Licensing, difference between Windows app and cloud appA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program
- Selection of the most appropriate program for a specific task		theory, demoLABchapter 2 pp. 2-4comptency 2, 5
13
lesson 2911/23/2020 AMMicrosoft Word: Understanding MS Word, common toolsA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
- Demonstration of the specific features of each program		theory, demolabchapter 2 pp. 5-10competency 2, 3, 5, 6
14
1211/23/2020 PMBasic editing, organizing documents, basic commands, checking properties.A. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
- Demonstration of the specific features of each program		demo, practicelabchapter 2 pp. 14-18competency 2, 3, 5, 6
15
lesson 31511/25/2020 AMInstalling and uninstalling applications, type of applications, hardware requirements, software compatibility, cloud-based version of apps (Google apps / MS 365)B. Install & uninstall software- Accurate interpretation of information on the minimum configuration required for the installation
- Complete verification of elements of the computers system to ensure they comply with installation requirements
- proper use of procedures for standard, complete and customized installation
- Consideration of the needs involved
- efficient solution of conflicts
- proper use of uninstallation procedures		theory, demolabyoutube video
MS support webpage		competency 2, 3, 5, 6
16
1811/25/2020 PMCharacter and Paragraph formattingE. Customize program interfaces- Proper setting of preferences and print manager
- Adaptation of menus and toolbars to user needs		theory, demo, practice labchapter 3 p. 42competency 2, 3, 5, 6
17
lesson 42111/26/2020 AMParagraph formatting, Manage text flowA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
- Demonstration of the specific features of each program		theory, demo, practice labquiz - main functions of word processing softwarechapter 3 p. 42competency 2, 3, 5, 6
18
2411/26/2020 PMCreating tablesA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
- Demonstration of the specific features of each program		theory, demoLABchapter 4 pp. 64-78competency 2, 3, 5, 6
19
lesson 52712/1/2020 AMCreating tablesA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		practiceLABchapter 4 pp. 64-78competency 2, 3, 5, 6
20
3012/1/2020 PMWorking with themes, style sets, backgrounds, quick parts and text boxesE. Customize program interfaces- Proper setting of preferences and print manager
- Adaptation of menus and toolbars to user needs		theory, demo, practice LABchapter 5 pp. 102-104competency 2, 3, 5, 6
21
lesson 63312/2/2020 AMUsing illustrations and graphicsA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		theory, demo, practice LABchapter 8 pp. 160-167competency 2, 3, 5, 6
22
3612/2/2020 PMFormatting a document / resume / research paperA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		theory, demo, practice LABchapter 3 p. 48-49competency 2, 3, 5, 6
23
lesson 73912/7/2020 AMMicrosoft Excel: Understanding MS Excel, Overview, Using Basic FormulasA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
- Demonstration of the specific features of each program
- Selection of the most appropriate program for a specific task		theory, demoLABquiz - advanced functions of word processing software; installation parameterschapter 10 pp. 213-217competency 2, 3, 4, 5, 6
24
4212/7/2020 PMCell references: relative and absoluteA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
- Demonstration of the specific features of each program		theory, demoLABchapter 11 pp. 222-227competency 2, 3, 4, 5, 6
25
lesson 84512/8/2020 AMCell references: relative and absoluteA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
- Demonstration of the specific features of each program		practiceLABchapter 11 pp. 222-227competency 2, 3, 4, 5, 6
26
4812/8/2020 PMFormatting Cells & RangesA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
- Demonstration of the specific features of each program		theory, demo, practice LABchapter 11 pp. 228-230competency 2, 3, 4, 5, 6
27
lesson 95112/10/2020 AMFormatting WorksheetsA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
- Demonstration of the specific features of each program		theory, demo, practice LABchapter 13 pp. 251-255competency 2, 3, 4, 5, 6
28
5412/10/2020 PMManaging worksheetsA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		theory, demo, practiceLABchapter 13 pp. 251-255competency 2, 3, 4, 5, 6
29
lesson 105712/11/2020 AMWorking with Data & MacrosD. Automate tasks- creation of macros based on user needs
- proper recordning and running of macros
- detection and correction of errors
theory, demo, practiceLAByoutube video
MS support webpage		competency 2, 3, 4, 5, 6
30
6012/11/2020 PMUsing Advanced FormulasA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
- Demonstration of the specific features of each program		theory, demoLABquiz - main functions of spreadsheet softwarechapter 12 pp. 233-239competency 2, 3, 4, 5, 6
31
lesson 116312/14/2020 AMUsing Advanced FormulasA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		practiceLABchapter 12 pp. 233-239competency 2, 3, 4, 5, 6
32
6612/14/2020 PMSecuring WorkbooksA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		theory, demo, practiceLABchapter 14 pp. 257-258competency 2, 3, 4, 5, 6
33
lesson 126912/15/2020 AMCreating ChartsA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		theory, demo, practiceLABchapter 15 p. 275competency 2, 3, 4, 5, 6
34
7212/15/2020 PMAdding Pictures and Shapes to a WorksheetA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		theory, demo, practiceLABchapter 13 pp. 255-256competency 2, 3, 4, 5, 6
35
lesson 137512/17/2020 AMMicrosoft Outlook / Gmail: Configuring (POP3, IMAP, SMTP), Multiple AccountsA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program
- Selection of the most appropriate program for a specific task		theory, demo, practiceLABquiz - advanced functions of spreadsheet software; installation parametersyoutube video
MS, Google support webpage		competency 2, 3, 4, 5, 6
36
7812/17/2020 PMRepairing PST files, difference between desktop mail and web-based mailA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program		theory, demo, practiceLAByoutube video
MS support webpage		competency 2, 3, 4, 5, 6
37
lesson 148112/18/2020 AMWord: Course summary reviewA. Examine the capabilities of computer programs
C. Research and propose procedures for using programs		- Demonstration of the specific features of each program
- Selection of the most appropriate program for a specific task
- Selection of pertinent information
- preparation of clear, concise instructions for using functions		practiceonlinetextbook chapters 1-9competency 2, 3, 4, 5, 6
38
8412/18/2020 PMExcel: Course summary reviewA. Examine the capabilities of computer programs
C. Research and propose procedures for using programs		- Demonstration of the specific features of each program
- Selection of the most appropriate program for a specific task
- Selection of pertinent information
- proper use of functions
- conversions of files from one program to another
- preparation of clear, concise instructions for using functions		practiceonlinetextbook chapters 10-15competency 2, 3, 4, 5, 6
39
lesson 158701/05/2021 AMSoftware Automation: Zip applications, PDF creator, Internet Browser, Video Editing Software, Snipping tool, Antivirus, Remote DesktopA. Examine the capabilities of computer programs- identification of similar fuctions:
--in programs in the same families
--in programs from different families
--in different versions of programs
- Demonstration of the specific features of each program
- Selection of the most appropriate program for a specific task		theory, demo, practicelabyoutube video
MS support webpage		competency 2, 3, 4, 5, 6
40
9001/05/2021 PMCreating Mailing List and GroupsE. Customize program interfaces- Proper setting of preferences and print manager
- Adaptation of menus and toolbars to user needs		theory, demo, practicelabyoutube video
MS support webpage		competency 2, 3, 4, 5, 6
41
lesson 169301/06/2021 AMApplication Software Project: Business Spreadsheet / Computer Support Spreadsheet projectA. Examine the capabilities of computer programs
C. Research and propose procedures for using programs		- Demonstration of the specific features of each program
- Selection of the most appropriate program for a specific task
- Selection of pertinent information
- proper use of functions
- conversions of files from one program to another
- preparation of clear, concise instructions for using functions		practiceonlinetextbook, youtube videos, MS and Google support pagescompetency 2, 3, 4, 5, 6
42
9601/06/2021 PMProject continuationpracticeonlineassessment - advanced spreadsheet applications; research a topictextbook, youtube videos, MS and Google support pagescompetency 2, 3, 4, 5, 6
43
lesson 179901/07/2021 AMExam Preparation and Reviewdemo, practiceonlinetextbook, youtube videos, MS and Google support pagescompetency 2, 3, 4, 5, 6
44
10201/07/2021 PMExam Preparation and Reviewdemo, practiceonlinetextbook, youtube videos, MS and Google support pagescompetency 2, 3, 4, 5, 6
45
lesson 1810501/08/2021 AMExam Preparation and Reviewdemo, practicelabassessment - key elements of application software (spreadsheet, word processing, email configuration)textbook, youtube videos, MS and Google support pagescompetency 2, 3, 4, 5, 6
46
10801/08/2021 PMCode 1
47
11101/13/2021 AMRemediation
48
11401/13/2021 PMBuffer
49
11701/14/2021 AMCode 8
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101