ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Pacing Guide Office Productivity
2
3
BU102YA: Keyboarding & Basic Word Processing
4
BU102YB: Introduction to Office Productivity
5
BU102YC: Office Productivity Applications
6
BU102YD: Digital Literacy
7
GP - Guided Practice, IP - Independent Practice, A - Assessment, P-Partner, TM/D - Teacher-Made and Class Discussion
8
1st 9-Weeks:
9
10
Standard(s)IndicatorsActivities/Resources
11
12
Multimedia Presentation Software
BU1O2YB - Introduction to Office Productivity: 2.00 Understand the purpose and procedures for developing a multimedia presentation.2.01 Understand uses of presentation software"Do's & Don'ts" example PowerPoint - class discussionTM/CD
13
2.02 Understand procedures for developing a presentationPowerPoint: Multimedia Presentatation Software
14
Multimedia Presentation Software ActivityIP/P
15
BU1O2YB - Introduction to Office Productivity: 3.00 Understand methods of presentation delivery and distribution.3.01 Understand various methods of delivery and distribution of a presentation"All About Me" PowerPoint (example) TM/CD
16
"All About Me" presentation - to be created by students using PowerPoint OR Google SlidesA
17
Rubric for self and peer evaluation
18
19
History of Computers
BU102YA-D: 1.00 Understand computer basics
1.01 Introduction to ComputersPowerPoint: History of Computers TM/CD
20
Written Assignment: Students describe how computers have evolved (will allow me to assess writing skills)IP
21
22
Binary Conversions (Machine Lang)
BU1O2YA-D: 1.00 Understand computer basics
1.01 Introduction to ComputersPowerPoint: Binary (Machine) LanguageTM/CD
23
Binary Practice ActivityGP
24
Binary Conversion AssignmentIP
25
26
Microsoft E-Learning Module (Digital Literacy -Computer Basics)BU102YD - Digital Literacy: 1.00 Understand Computer Basics1.01 Introduction to ComputersE-Learning Module through Microsoft, teacher-made activityIP/P
27
1.02 Common Computer Terminology
28
1.03 Computer Performance & Features
29
1.04 Computer Operating Systems
30
1.05 Career Opportunitities
31
32
ExcelBU102YB - Introduction to Office Productivity: 4.00 Understand the basics of spreadsheets4.01 Understand spreadsheets and components of spreadsheetsPowerPoint: Excel SpreadsheetsTM/CD
33
4.02 Understand spradsheet formattingExcel Intro ActivityGP
34
4.03 Understand spreadsheet operations
*Spreadsheets: FIRST and PRACTICE
GP
35
3.04 Understand spreadsheet programs
36
*Spreadsheets: RETAIL1, RETAIL2, SPORTINGGOODS, STUDENTS, TESTGRADES, NOVEXP, SALARIES, CAMDENIP
37
*Spreadsheets using Relative Cell Names
38
39
Assessment Review (Relative)CD/GP
40
SS Assessment (Written)A
41
SS Assessment (Application)A
42
43
BU102YC - Office Productivity Applications: 1.00 Understand the use of advanced functions and graphs and charts1.01 Understand advanced functions of spreadsheets
**Spreadsheets: FLOWERS, EXPENSES
CD/GP
44
**Spreadsheets using Absolute Cell Names
45
46
BU102YC - Office Productivity Applications: 1.00 Understand the use of graphs and charts1.02 Understand charts and graphs used in businessExcel Pie Chart Intro Activity using Excel Pie Chart Info Sheets (on Media Center Drive)
TM/CD/GP
47
1.03 Understand components of graphs and charts
Pie Chart Graphing Activity (Pie1, Pie2)
IP
48
1.04 Identify common charts used in businessBar/Column Graph ActivityGP/IP
49
Line Graph ActivityGP/IP
50
51
52
Assessments - Graphs (Application and Written)A
53
54
2nd 9-Weeks:
55
Interdisciplinary Project: Science Weather Data Spreadsheet/Graph ProjectStudents collect data through Science class (weather and cloud formations). Purpose of project is to teach "Weather Versus Climate" concept.Spreadsheet, Line Graph, Column Graph, questionsGP/IP
56
57
Interdisciplinary Project: Math - Planning a VacationPartner project - students take their 7 children on a week-long vacation to Williamsburg. Daily and weekly expenses include hotel accommodations, meals (vary according to ages), tickets to various sites (vary by ages and some include discounts), etc. Multi-step formulas required to calculate expenses.
Spreadsheet, Pie Chart, Column Graph
GP/IP/P
58
59
Microsoft E-Learning Module (Digital Literacy -Computer Security and Privacy)BU102YD - Digital Literacy: 4.00 Understand computer security and privacy4.01 Introduction to Computer Security and PrivacyE-Learning Module through Microsoft, teacher-made activityIP/P
60
4.02 Protecting Your Computer
61
4.03 Protecting Your Family from Security Threats
62
4.04 Keeping Your Computer Secure and Updated
63
4.05 Computer Ethics
64
65
CyberSense: Part 1: CyberEthics, Part 2: CyberSafety, Part 3: Cyber SecurityBU102YD - Digital Literacy: 4.00 Understand computer security and privacy4.03 Protecting Your Family from Security ThreatsVideo: CyberEthics, CyberSafety, CyberSecurity, ActivityCD/GP/IP
66
4.05 Computer Ethics
67
68
Social Media/NetworkingBU102YD - Digital Literacy: 4.00 Understand computer security and privacy4.01 Introduction to Computer Security and PrivacyPowerPoint: Social NetworkingTM/CD
69
4.05 Computer EthicsSocial Networking ActivityIP
70
71
4.01 Introduction to Computer Security and PrivacySocial Media Privacy Basics - online module (GCF LearnFree.org)CD/IP
72
4.05 Computer Ethics
73
Internet Safety & Security Assessment (Concept Map)A
74
75
Internet Research and Information LiteracyBU102YD - Digital Literacy: 4.00 Understand computer security and privacy4.05 Computer EthicsVideo: Effective Internet Research StrategiesCD
76
Video: Plagiarism 2.0: Information Ethics in the Digital AgeCD
77
Plagiarism Internet Scavenger HuntIP
78
79
Desktop PublishingBU102YC - Office Productivity Applications: 3:00 Understand business applications3.01 Understand design principlesPowerPoint: Desktop PublishingTM/CD
80
3.02 Understand the target audienceDesktop Publishing Written ActivityIP
81
3.03 Understand the purpose of a publication
Newsletter/Informational Brochure, Flyer, Invitation, Greeting CardGP/IP
82
83
Interdisciplinary Project: Social Studies: Newsletter/Informational Brochure - WWI Topic (provided by SS teacher)Online Research/Design and completion of a newsletter or informational brochure on social studies topicGP/IP
84
85
3rd/4th 9-Weeks:
86
87
Microsoft E-Learning Module (Digital Literacy - The Internet, cloud services, and the world wide web)BUO102YD - Digital Literacy: 2.00 Understand the Internet, cloud services, and the world wide web2.01 The InternetE-Learning Module through Microsoft, teacher-made activityIP/P
88
2.02 The World Wide Web
89
2.03 Using E-Mail
90
2.04 Other Methods of Communicating on the Internet
91
92
Databases (Access)BU102YC - Office Productivity Applications: 2.00 Understand the basics of databases
2.01 Understand database use and purpose
PowerPoint: DatabasesTM/CD
93
2.02 Understand data types, field properties, printingDatabase activityGP/IP
94
2.03 Understand database managementSorting Activities: CivilWar/Africa, Booklist, Rocks, PlanetsGP/IP
95
Sorting Quiz - PlanetsIP
96
Sorting AssessmentA
97
Creating a Database (Friends)GP/IP
98
Filtering Activities - CivilWar, AfricaGP/IP
99
100
Excellent Adventures Simulation (Microsoft Excel Simulation) - Partner ProjectStudents serve as Excel Specialists for Excellent Adventures (an amusement park) and complete a series of real-world activities- track monthly admission ticket sales, analyze average ride wait time, chart expenses, etc.IP/P