Jefferson-Morgan Middle/High School

Skip to main content

Advanced Computer Applications

Course Description

This comprehensive course provides students with advanced concepts in word processing, spreadsheet, presentation and database applications by utilizing the Microsoft Office Suite. The instruction in this class provides students the skills needed to become a Microsoft Office Specialist at the Expert level for Word and Excel; Specialist level for Access and PowerPoint.

To take this course, students must have successfully completed Computer Applications with a grade of C or better.
 
Date Objective/Standard Description of Lesson Assignment/HW
8/29
 First Day of School 
- Welcome
- Went over syllabus
- Logged in and created folders on Google Drive
- Reviewed how packets will look and how to utilize them
 - Syllabus returned and signed by Wednesday
8/30
- Insert a table
- Insert and delete rows and columns
- Modify rows and columns
-  Sort table data
- Split and merge cells
- Perform calculations in tables
- Customize a table format
  - Unit E Word pages 106 - 111 in class - Syllabus returned and signed by tomorrow 
8/31  Same as 8/30 - Unit E Word pages 112 - 121 in class - Syllabus due today
9/1 Same as 8/30  - Students will begin to work on their Unit E Word Skills Review, Independent Challenge 1, and Visual Workshop
- Graded projects are due by the end of class Friday
- Unit E Word Test Tuesday, September 6th
9/2  Same as 8/30 - Students finished their Unit E Word Skills Review, Independent Challenge 1, and Visual Workshop
- Graded projects due today
- Unit E Word test on Tuesday!
9/5 NO SCHOOL    
9/6 Same as 8/30 - Unit E Word test today!  - BONUS - Have parents subscribe to my Advanced Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/7 Same as 8/30
- Went over Unit E Word test today
- Learned about doing citations and bibliographies using Word
 - BONUS - Have parents subscribe to my Advanced Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/8
- Insert a graphic
- Size and scale a graphic
- Position a graphic
- Create a text box
- Create WordArt
- Draw shapes
- Create a chart
- Finalize page layout
- Unit F Word pages 130-137 in class
 - BONUS - Have parents subscribe to my Advanced Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/9
 
STUDY HALL (because we were missing students)
  
9/12  
STUDY HALL (because we were missing students)
  
9/13 Same as 9/8 - Unit F Word pages 138-145 in class - BONUS - Have parents subscribe to my Advanced Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/14 Same as 9/8 - Students will begin to work on their Unit F Word Skills Review and  Independent Challenge 1 - Graded projects are due by the end of class tomorrow
- Unit F Word Test Friday, September 16th
9/15 Same as 9/8 - Students finished their work on Unit F Word Skills Review and Independent Challenge 1 - Unit F Word Test Friday, September 16th
9/16 Same as 9/8 - Test today!  
9/19 Same as 9/8 - Went over test today  
9/20 - Utilize skills learned about tables to create the periodic table - Students created their own periodic table based off of one I emailed them  
9/21
- Apply styles to text
- Apply a theme
- Customize a theme
- Insert a sidebar
- Insert Quick Parts
- Add a cover page
- Create building blocks
- Insert building blocks
 - Unit G Word pages 154-159 in class   
9/22   STUDY HALL (because we were missing students)  
9/23   STUDY HALL  
9/26 Same as 9/21 - Student completed the rest of Unit G practice on their own  
9/27 Same as 9/21 - Unit G Word pages 160-165 in class   
9/28 Same as 9/21 - Students caught up to page 165 in class  
9/29 Same as 9/21 - Unit G Word pages 166-169 in class - Skills Review, Independent Challenge 1, and Visual Workshop due Monday
9/30 Same as 9/21 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop - Skills Review, Independent Challenge 1, and Visual Workshop due Monday
10/3 Same as 9.21 - Students finished their Skills Review, Independent Challenge 1, and Visual Workshop - Skills Review, Independent Challenge 1, and Visual Workshop due today
10/4
- Understand mail merge
- Create a main document
- Design a data source
- Enter and edit records
- Add merge fields
- Merge data
- Create labels
- Sort and filter records
 - We worked on pages 178-185 together in class  
10/5
- Same as 10/4
 - We worked on pages 186-193 together in class - Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
10/10 - Same as 10/4 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class - Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
10/11 - Same as 10/4 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Thursday (because of Academic Meet)
- Test Friday
10/12 - Same as 10/4 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Thursday 
- Test Friday
10/13 - Same as 10/4 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due today 
- Test tomorrow
10/14   STUDY HALL (because we were missing students)
- Test moved to Monday
10/17 - Same as 10/4 - Unit H Word Test today  
10/18 - Same as 10/4 - Went over tests today in class  
10/19   STUDY HALL  
10/20   - Students downloaded files needed for next lesson  
10/21   - Catch up day  
10/24 - Create own mail merge for holiday labels - Students created their own mail merge for their holiday card labels  
10/25
- Format data using text functions
- Sum a data range based on conditions
- Consolidate data using a formula
- Check formulas for errors
- Construct formulas using named ranges
- Build a logical formula with the IF function
- Build a logical formulas with the AND function
- Calculate payments with the PMT function
 - We worked on pages 106-111 in Unit E Excel packet for practice  
10/26
- Same as 10/25
 - Had all students out of class except one, so study hall  
10/27
- Same as 10/25
 - Catch up day for students that were absent on 10/25 and 10/26  
10/28
- Same as 10/25
 - Practiced using formulas learned on 10/25  
10/31   Worked on door project   
11/1 - Same as 10/25 - We worked on 112 through 115 today in class together for practice  
11/2 - Same as 10/25 - We finished Unit E Excel practice today
- Skills Review
Independent Challenge 1
- Visual Workshop due Monday
11/3 - Same as 10/25 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review
Independent Challenge 1
- Visual Workshop due Tuesday
11/4 - Same as 10/25 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review
Independent Challenge 1
- Visual Workshop due Tuesday
11/7 - Same as 10/25 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review
Independent Challenge 1
- Visual Workshop due Tuesday
11/8 - Same as 10/25 - Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review
Independent Challenge 1
- Visual Workshop due Tuesday
11/9 - Same as 10/25 - Catchup Day  
11/10 - Same as 10/25 - Catchup Day  
11/14 - Same as 10/25 - Reviewed for test - Unit E Excel test tomorrow
11/15 - Same as 10/25 - Unit E Excel Test today  
11/16 - Same as 10/25 - Catchup Day (half of the class was absent due to field trip)  
11/17 - Same as 10/25 - Catchup Day  
11/18   - Internet Down  
11/21 - Same as 10/25 - Catchup Day  
11/29
- View and arrange worksheets
- Protect worksheets and workbooks
- Save custom views of a worksheet
- Add a worksheet background
- Prepare a workbook for distribution
- Insert hyperlinks
- Save a workbook for distribution
- Group worksheets
 
 - We worked on pages 130 - 135 in Unit F Excel packet  
11/30
- Same as 11/29
 - Study Hall (Because half the class was missing)  
12/1
- Same as 11/29
 - Students worked in packet, on their own  
12/2
- Same as 11/29
 - Study Hall (Because half of the class was missing  
12/5
- Same as 11/29
 - Students worked in packet, on their own  
12/6
- Same as 11/29
 - Students worked in packet, on their own  
12/7
- Same as 11/29
 - Students worked on Skills Review in packet  
12/8
- Same as 11/29
 - Students worked on Skills Review in packet  
12/9   - Study Hall because Internet was down  
12/12
- Plan a table
- Create and format a table
- Add table data
- Find and replace table data
- Delete table data
- Sort table data
- Use formulas in a table
- Print a table
 - We started Unit G Excel practice together in class today (pages 154 through 161)  
12/13   - STUDY HALL  
12/14 - Same as 12/12 - We finished the in class practice for Unit G (pages 162 through 169)  
12/15 - Same as 12/12 - Students worked on their Skills Review for Unit G Excel  
12/16 - Same as 12/12 - Students worked on their Skills Review for Unit G Excel  
12/19 - Same as 12/12 - Students worked on their Skills Review for Unit G Excel  
12/20   - Early dismissal today  
1/3 - Same as 12/12 - Worked on Unit G Independent Challenge 1 as bonus  
1/4
- Filter a table
- Create a custom filter
- Filter a table with the Advanced Filter
- Extract table data
- Look up values in a table
- Summarize table data
- Validate table data
- Create subtotals 
 - Started Unit H Excel practice in class today  
1/5 - Same as 1/4  - Worked on Unit H Excel practice in class today  
1/6 - Same as 1/4  - Worked on Unit H Excel practice in class today  
1/9 - Same as 1/4 - Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class Unit H Projects due Thursday!
1/10 - Same as 1/4
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
 Unit H Projects due Thursday!
1/11 - Same as 1/4
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
 Unit H Projects due Thursday!
1/12 - Same as 1/4
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop in class
 Unit H Projects due today!
1/13 - Same as 1/4
- Catchup day
  
1/17  
- End of class survey
  
       
1/18 - First Day
- Welcome
- Went over syllabus
- Logged in and created folders on Google Drive
- Reviewed how packets will look and how to utilize them
 - Syllabus signed and returned by Monday
1/19
- Insert a table
- Insert and delete rows and columns
- Modify rows and columns
-  Sort table data
- Split and merge cells
- Perform calculations in tables
- Customize a table format
Worked on Unit E Word practice pages 106-111
 - Syllabus signed and returned on Monday
1/20
- Same as 1/19
- Catchup day (for new students and absent students)
 - Syllabus signed and returned on Monday
1/23
- Same as 1/19
- Worked on Unit E Word practice pages 110-115
 - Syllabus due today
1/24
- Same as 1/19
- Worked on Unit E Word practice pages 116-121
  
1/25
- Same as 1/19
- Students worked on Unit E Word Skills Review, Independent Challenge 1, and Visual Workshop for a grade on their own
- Unit E Word projects due Friday
- Test Monday
1/26
- Same as 1/19
- Students worked on Unit E Word Skills Review, Independent Challenge 1, and Visual Workshop for a grade on their own
- Unit E Word projects due Friday
- Test Monday
1/27
- Same as 1/19
- Students worked on Unit E Word Skills Review, Independent Challenge 1, and Visual Workshop for a grade on their own
- Unit E Word projects due Friday
- Test Monday
1/30
- Same as 1/19
- Students took Unit E Word test today
  
1/31
- Same as 1/19
- We went over the test together in class
  
2/1
- Same as 1/19
- Students worked on bonus in class (some chose NOT to do it though!)
  
2/2
- Insert a graphic
- Size and scale a graphic
- Position a graphic
- Create a text box
- Create WordArt
- Draw shapes
- Create a chart
- Finalize page layout
- We worked on Unit F Word practice pages 130 - 135
  
2/3
- Same as 2/2
- Catchup day for students who needed to get caught up on their work
  
2/6  
- I was out today so students looked up information on the MOS certification and wrote 100 words on how getting that certification will help them later in life
  
2/7  
- Speaker from Pittsburgh Technical College
  
2/8 - Same as 2/2
- We worked on Unit F Word practice pages 136 - 141
  
2/9 - Same as 2/2
- We finished Unit F Word practice pages 142 - 145
- Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
- Unit F Word Test Wednesday
2/10 - Same as 2/2
- Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
- Unit F Word Test Thursday
2/13 - Same as 2/2
- Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
- Unit F Word Test Thursday
2/14 - Same as 2/2
- Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
- Unit F Word Test Thursday
2/15 - Same as 2/2
- Students worked on their Skills Review, Independent Challenge 1, and Visual Workshop in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due today
- Unit F Word Test tomorrow
2/16 - Same as 2/2
- Students were given one more day to finish their Skills Review, Independent Challenge 1 and Visual Workshop in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due today
- Unit F Word Test tomorrow
2/17 - Same as 2/2
- Unit F Word Test today
  
2/21 - Same as 2/2
- We went over the Unit F Word Test today in class
  
2/22
- Apply styles to text
- Apply a theme
- Customize a theme
- Insert a sidebar
- Insert Quick Parts
- Add a cover page
- Create building blocks
- Insert building blocks
- We worked on pages 154-159 in class together (Unit G Word)
 
  
2/23
- Same as 2/22
- We worked on pages 160-161 in class together (Unit G Word)
  
2/24
- Same as 2/22
- Catchup day 
  
2/27
- Same as 2/22
- We worked on pages 162-165 in class together (Unit G Word)
  
2/28
- Same as 2/22
- We worked on pages 166-169 in class together (Unit G Word)
  
3/1  
- No class because of early dismissal
  
3/2 - Same as 2/22
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop
 Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
3/3 - Same as 2/22
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop
 Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
3/6 - Same as 2/22
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop
 Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
3/7 - Same as 2/22
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop
 Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
3/8 - Same as 2/22
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop
 Skills Review, Independent Challenge 1, and Visual Workshop due today (gave one day extension)
3/13 - Same as 2/22
- Catchup day
  
3/14 - Same as 2/22
- Catchup day
  
3/15
- Understand mail merge
- Create a main document
- Design a data source
- Enter and edit records
- Add merge fields
- Merge data
- Create labels
- Sort and filter records 
- We worked on pages 178-185 in Unit H Word together in class
  
3/16
- Same as 3/15
- Catchup day
  
3/17
- Same as 3/15
- Catchup day
  
3/20
- Same as 3/15
- Catchup day
  
3/21
- Same as 3/15
- We worked on pages 186- in Unit  H Word together in class
  
3/22
- Same as 3/15
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop for Unit H Word in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due Monday
3/23
- Same as 3/15
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop for Unit H Word in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due Monday
3/24
- Same as 3/15
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop for Unit H Word in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due Monday
3/27
- Same as 3/15
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop for Unit H Word in class
 - Skills Review, Independent Challenge 1, and Visual Workshop due Tuesday
3/28
- Same as 3/15
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop for Unit H Word in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
- Test Thursday
3/29
- Same as 3/15
- Students worked on Skills Review, Independent Challenge 1, and Visual Workshop for Unit H Word in class
- Skills Review, Independent Challenge 1, and Visual Workshop due Wednesday
- Test Thursday
3/30
- Same as 3/15
- Test today
  
3/31
- Same as 3/15
- Went over test in class
  
4/3
- Review basics concepts of Excel
- We reviewed basic concepts by typing up prom expenses and date expenses in Excel
  
4/4
- Format data using text functions
- Sum a data range based on conditions
- Consolidate data using a formula
- Check formulas for errors
- Construct formulas using named ranges
- Build a logical formulas with the IF function
 - Build a logical formulas with the AND function
- Calculate payments with the PMT function
- We started Unit E Excel practice in class today (pages 106-109)
  
4/5
- Same as 4/4
- We worked on Unit E Excel practice in class today (pages 110-113)
  
4/6
- Same as 4/4
- We worked on Unit E Excel practice in class today (pages 114-115)
  
4/7
- Same as 4/4
- We worked on Unit E Excel practice in class today (pages 116-121)
  
4/18
- Same as 4/4
- We reviewed Unit E Excel in class today (retaught because many students forgot over break.)
  
4/19
- Same as 4/4
- We reviewed Unit E Excel in class today (retaught because many students forgot over break.)
  
4/20
- Same as 4/4
- We reviewed Unit E Excel in class today (retaught because many students forgot over break.)
  
4/21
- Same as 4/4
- Students worked on Skills Review for Unit E Excel
  
4/24 - Same as 4/4
- Students worked on Skills Review for Unit E Excel
  
4/25 - Same as 4/4
- Students worked on Skills Review for Unit E Excel
  
4/26 - Review for MOS Word Test
- We started a review today in class for the MOS Word test
  
4/27 - Same as 4/26
- We continued reviewing for the MOS Word test today in class
  
4/28 - Same as 4/26
- We finished the MOS Word test review in class
  
5/1 - Same as 4/26
- Allowed students to catchup or do practice work for MOS Word test
  
5/2  
- We began doing Unit F Excel in class practice
  
5/3  
- We continued to work on Unit F Excel in class practice
  
5/4  
- Catchup day for students who missed the last two days of class
  
5/5  
- We finished Unit F Excel practice in class
  
5/8  
- Students started to work on the graded projects for Unit F Excel in class
 - Graded projects due Thursday
5/9  
- Students worked on their graded projects for Unit F Excel in class
 - Graded projects due Thursday
5/10  
- Students worked on their graded projects for Unit F Excel in class
 - Graded projects due Thursday
5/11  
- Students worked on their graded projects for Unit F Excel in class
 - Graded projects due Friday
5/12  
- Students worked on their graded projects for Unit F Excel in class
 - Graded projects due Friday
- Test Tuesday
5/15  
- No class because of early dismissal
- Test Tuesday