Jefferson-Morgan Middle/High School

Skip to main content

Computer Applications

Course Description

This required comprehensive course provides students with basic concepts in word processing, spreadsheet, and presentation applications by utilizing the most current programs available. Step-by-step exercises teach students necessary skills. Leveled activities and projects help students to practice and reinforce the aforementioned skills. Projects incorporate both real-world business situations and cross-curricular academics.

This class should be taken during freshman year.
Files from the Dream Team Packet are on the side.
 
 
Date Objective/Standard Description of Lesson Assignment/HW
8/29  First day of school
- Welcome
- Went over syllabus and rules
- Received folders
- Logged in and created folders in Google Drive
- Syllabus signed and back to me by Wednesday!
8/30  - Use Microsoft Word to create and format a business memo
- Did QOTD together in class (and received notebook for it)
- Worked on PG-1 in Dream Team packet
- Syllabus signed and back to me by tomorrow!
- PG-1 due tomorrow
8/31  - Same as 8/30
- QOTD
- Checked PG-1 in packet
- Started to type PG-1 in Word (different classes are at different places because of meetings 
 
9/1  - Same as 8/30
- QOTD
- Finished typing and formatting PG-1 in Word (Memo) and emailed teacher
- BONUS - Have parents subscribe to my Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/2 - Read non-fiction items and summarize 
- NO QOTD
- Students received an article to read (we read out loud as a class) and discussed
- Then, as a class, we correctly typed a five sentence summary of the article in correct MLA formatting with a Works Cited page
- Students also added the technology website to their favorites for independent use on the following Fridays.
- BONUS - Have parents subscribe to my Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class 
9/5 NO SCHOOL    
9/6 - Use graphic design software to create a professional team logo.
- QOTD
- Students filled out PG-2 in packets.
- Worked on a practice logo with teacher (except Period 2 because of being called out for Picture Day)
- Make sure PG-2 is completely filled out!
- BONUS - Have parents subscribe to my Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/7 Same as 9/6
- Created and saved a practice logo together as a class
- Students started to create their own logo in class
- BONUS - Have parents subscribe to my Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/8 Same as 9/6
- Finished logos in class and emailed the JPEG file to the teacher to grade
- Students worked on PG-3 in packet during class
- BONUS - Have parents subscribe to my Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
- PG-3 in packet due Monday!
9/9 - Read non-fiction items and summarize - NO QOTD
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
- BONUS - Have parents subscribe to my Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
- PG-3 in packet due Monday!
9/12
- Use the Internet and other resources to create a team roster. 
- Use Microsoft Excel to organize the Dream Team roster.
- QOTD
- Checked PG-3 in packet
- Students checked email from me concerning their technology article from Friday (with items to improve upon this week)
- Students typed their PG-3 in Excel and emailed to me
- BONUS - Have parents subscribe to my Computer Applications webpage
- BONUS - Bring in a canister/container of wipes for the class
9/13
- Use Microsoft Word to create a letterhead template
- QOTD
- Students created a sample letterhead using my logo
- Students then designed 3 (three) different letterhead for themselves in their packet
- HW: 3 (three) designs of letterhead if not completed in class
- BONUS - Bring in a canister/container of wipes for the class
9/14
- Same as 9/13
- NO QOTD
- Students created 3 (three) different letterhead designs in class
- BONUS - Bring in a canister/container of wipes for the class
9/15
- Use Microsoft Word to create and design a business size envelope
- QOTD
- Students created a business envelope for the team
- Catch-up day for the rest of the class perido
- BONUS - Bring in a canister/container of wipes for the class
9/16
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
- BONUS - Bring in a canister/container of wipes for the class
9/19
- Use Microsoft Word to create a block-style business letter.
- QOTD
- Students worked on filling out W-3 in packet
- HW: W-3 in packet (if not done in class)
- BONUS - Bring in a canister/container of wipes for the class
9/20
- Same as 9/19
- QOTD
- Students typed W-3 on the computer
- BONUS - Bring in a canister/container of wipes for the class
9/21
- Use Microsoft Word to create a press release
- QOTD
- Students worked on filling out W-4 in packet
- Periods 6 & 7 typed W-4 today as well in Word
- BONUS - Bring in a canister/container of wipes for the class
9/22
- Use the table feature in Microsoft Word to create an equipment inventory list
- QOTD
- Period 2 typed W-4 and filled out W-5 in packet
- Periods 6 & 7 worked on filling out W-5 in packet and typed W-5 in Word today
 
- BONUS - Bring in a canister/container of wipes for the class
9/23
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
- BONUS - Bring in a canister/container of wipes for the class
9/26
- Use the table feature in Microsoft Word to create a player personnel form
- Students worked on W-6 on the computer
- BONUS - Bring in a canister/container of wipes for the class
9/27
- Same as 9.26
- Students finished W-6 on the computer
- Worked on E-3 in packet
- BONUS - Bring in a canister/container of wipes for the class
9/28
- Use Microsoft Excel to organize your dream team schedule
- Students typed E-3 in Microsoft Excel today in class
- BONUS - Bring in a canister/container of wipes for the class
9/29
- Use Microsoft Excel to calculate ticket sales revenue
- Students worked on E-4 in their packet and then typed E-4 in Microsoft Excel today in class
- BONUS - Bring in a canister/container of wipes for the class
9/30
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
- BONUS - Bring in a canister/container of wipes for the class
10/3
- Use Microsoft Excel to calculate the average salary of your team
- Students typed E-2 on Microsoft Excel in class
 
10/4
- Use Microsoft Excel to create a chart comparing data
- We added a chart to our Top 5 salaries for our team
 
10/5
- Same as 10/4
- Catch up day
 
10/10
- Use desktop publishing software to design a business card
- We did a practice business card together in class
- Students sketched out three different business cards in the packet (DTP-1)
 
10/11
- Same as 10/10
- Students worked on 3 different samples of business cards for their team
 
10/12
- Same as 10/10
- Students worked on 3 different samples of business cards for their team
- DTP-2 in packet due tomorrow
10/13
- Use desktop publishing software to design a VIP pass for the team
- Students created a VIP using Microsoft Publisher in class
- DTP-3 in packet due Monday
10/14
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
 
10/17
- Use desktop publishing software to create a ticket for games
- Students received a sample ticket in an email. They created their own ticket based off of the sample
 
10/18
- Use desktop publishing software to design a t-shirt to sell at games
- Students created a front and back of a t-shirt to sell at their games
- DTP-4 in packet due tomorrow
10/19
- Use desktop publishing software to create a magazine ad to advertise for the opening game
- Students created a magazine ad (specific size) and included items to promote their first game
 
10/20
- Same as 10/19
- QOTD
- Students worked on DTP-5 in their packet
- Catch-up day
- DTP-5 in packet due Monday
10/21
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
- DTP-5 in packet due Monday
10/24
- Use desktop publishing software to create a cereal box cover
- Students created a cereal box cover for their team
 
10/25
- Same as above
- I checked DTP-5 in packet (HW) and then students finished their cereal boxes in class
 
10/26
- Use desktop publishing software to design a three-fold brochure
- Students worked on DTP-6 in packet and then started to create their brochure in Publisher
 
10/27
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
 
10/28
- Use desktop publishing software to design a three-fold brochure
- Students continued to work on their brochure in class
 
10/31
- Same as 10/28
- Students completed their brochure and worked on DTP-7 in their packet
- DTP-7 in packet due tomorrow
11/1
- Use desktop publishing software to create a team newsletter
- Students worked on finishing their brochures (catch-up) and then completed DTP-7 in packet, if not done yesterday
- DTP-7 in packet due tomorrow
11/2
- Same as 11/1
- Students started to create their newsletter today in Publisher
 
11/3
- Same as 11/1
- Students worked on their newsletters in class
 
11/4
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
 
11/7
- Same as 11/1
- It was catch-up day for students who needed to get caught up with their newsletter or any other work owed
- Did A-1 in packet
- A-1 in packet due Wednesday (I'm on a field trip tomorrow)
11/8 - Read non-fiction items and summarize
- Students worked on their typed five sentence summary of a technology article of choice and then typed the Works Cited with it as well
- A-1 in packet due Wednesday
11/9
- Create a basic database using Microsoft Access
- Create fields, record, and change field size
- Students typed up their A-1 in Access today
 
11/10
- Same as 11/9
- Catchup Day
 
11/14
- Research companies to be sponsor/advertisers for your team
- Same as 11/9
- Students researched and started to type their A-2 in Access today (Internet was down at times though)
 
11/15
- Research songs to play at halftime, before and after games, etc.
- Same as 11/14
- Students finished typing their A-2 in Access today (again the Internet was down at times though)
 
11/16
- Same as 11/15
- Students typed their A-3 in Access today
 
11/17  
- Catchup day (students could catch up on any owed work today in class)
 
11/18 - Read non-fiction items and summarize
- Students worked on their typed five sentence summary of a technology article of choice and then typed the Works Cited with it as well
 
11/21 - Create a PowerPoint presentation to help enhance presentation about team
- Start working on PPT-1. Talked about presentations and what to wear for it!
 
11/22 - Same as 11/21
- Students worked on their PowerPoints in class
 
11/23 - Same as 11/21
- Students worked on their PowerPoints in class
 
11/29 - Same as 11/21
- Students worked on their PowerPoints in class
- Should be done with PowerPoints by Friday
- Start presenting on Monday
11/30 - Same as 11/21
- Students worked on their PowerPoints in class
- Should be done with PowerPoints by Friday
- Start presenting on Monday
12/1 - Read non-fiction items and summarize
- Students worked on their typed five sentence summary of a technology article of choice and then typed the Works Cited with it as well
 
12/2 - Same as 11/21
- Catch up day (seeing there were many students absent because of field trips)
 
12/5 - Same as 11/21 - Students worked on their PowerPoints in class - Presentations will start on Wednesday!
12/6 - Same as 11/21
- Students worked on their PowerPoints in class
- We also went over what to say on each slide during presentations
- Presentations will start on Wednesday!
12/7 - Same as 11/21
- Presentations today!
 
12/8 - Same as 11//21
- Presentations today!
 
12/9 - Same as 11/21
- Presentations today!
 
12/12 - Same as 11/21
- Presentations today!
 
12/13 - Same as 11/21
- Presentations today!
 
12/14  
- STUDY HALL
- Students can work on their PPT1 with the extra time given
 
12/15 - Same as 11/21
- Presentations today!
 
12/16 - Same as 11/21
- Presentations today!
 
12/18 - Final encompassess all aspects of learning from entire semester 
- Starting talking about Final
- Pass out rubric to Periods 6 and 7
 
12/19 - Same as 12/18
- Talked about the Final and passed out rubric to Period 2
- No Periods 6 & 7 today because of the early dismissal!
 
1/3 - Final encompassess all aspects of learning from entire semester 
- Students worked on Final project in class
- Final project due January 12th
1/4 - Same as 1/3
- Students worked on Final project in class
- Final project due January 12th
1/5 - Same as 1/3
- Students worked on Final project in class
- Final project due January 12th
1/6 - Same as 1/3
- Students worked on Final project in class
- Final project due January 12th
1/9 - Same as 1/3
- Students worked on Final project in class
- Final project due January 12th
1/10 - Same as 1/3
- Students worked on Final project in class
- Final project due January 12th
1/11 - Same as 1/3
- Students worked on Final project in class
- Final project due January 12th
1/12 - Same as 1/3
- Students worked on Final project in class
- Final project due January 12th
1/13  
- Students brought in food from their restaurant project
 
1/17  
- End of class survey
 
       
1/18 - First day of class
- Welcome
- Went over syllabus and rules
- Received folders
- Received Dream Team packet and discussed
- Sent a test email
- Syllabus signed and returned by Monday
1/19 - Second day of class
- Did QOTD together in class (and received notebook for it)
- Worked on PG-1 in Dream Team packet
- Syllabus signed and returned by Monday
1/20  - Use Microsoft Word to create and format a business memo
Period 2
- Did QOTD
- typed PG-1 on computer and emailed to teacher for a grade
Period 5
- Catchup day (for new student)
- Syllabus signed and returned Monday
1/23
- Same as 1/20
- Use graphic design software to create a professional team logo.
-QOTD
- Students created a sample logo for my team as practice
- Students worked on PG-2 in packet
Period 5
- Did the same above as well as typed PG-1 on computer and emailed to teacher for a grade
- Syllabus due today!
- PG-2 in packet for tomorrow
1/24 - Use graphic design software to create a professional team logo.
- Students created their own logos today in class, saved the logo as a Publisher file and as a jpeg, then emailed the jpeg to teacher for a grade
 
1/25
- Use the Internet and other resources to create a team roster. 
- QOTD
- Students filled out information sheets in their packet (to help them later with font, color, and basic info about team)
- Students started to fill in PG-3 in their packets
 
1/26
- Use the Internet and other resources to create a team roster. 
- Use Microsoft Excel to organize the Dream Team roster.
- QOTD
- Students finished filling in their PG-3 in their packets
- We started to type our PG-3 roster in Excel
 
1/27
- Read non-fiction items and summarize
Period 2 only
- We read an article together and wrote a 5 sentence summary of the article, and typed in correct MLA formatting (including a Works Cited page)
Period 5 only
- Study hall because 75% of the class was missing!
 
1/30  
- Catchup day (students who needed to make up work had the time to do so in class, others had a study hall)
 
1/31 - Use Microsoft Word to create a letterhead template
 
- QOTD
- We made a sample letterhead using my team's logo and information
- Students then sketched out 3 different letterheads in the packet (W-1)
- W-1 due tomorrow
2/1 - Same as 1/31
- QOTD
- Students worked on creating 3 of their own letterhead
- Students emailed to teacher to grade
 
2/2  
- Catchup day
 
2/3 - Read non-fiction items and summarize
- Students read an article and wrote a 5 sentence summary of the article, and typed in correct MLA formatting (including a Works Cited page)
 
2/6 - Use Microsoft Word to create a block-style business letter.
- I was not in school today
- Students filled in W-3 in their packets 
 
2/7  
- Speaker from Pittsburgh Technical College today
 
2/8 - Same as 2.6
- QOTD
- Students typed their W-3 on the computer and emailed to me for a grade
- W-2 in packet due tomorrow
- W-2 in packet due tomorrow
2/9 - Same as 2/6
- Catchup day
- W-2 in packet due Monday
2/10 - Read non-fiction items and summarize
- Students read an article and wrote a 5 sentence summary of the article, and typed in correct MLA formatting (including a Works Cited page)
- W-2 in packet due Monday
2/13 - Use Microsoft Word to create and design a business size envelope
- QOTD
- Students created an envelope for my team as well as for their team
- They emailed their two envelopes to me for a grade
 
2/14 - Use Microsoft Word to create a press release
- Students worked on W-4 in their packet during class
- W-4 must be completed by Wednesday!
2/15 - Same as 2/14
- QOTD
- Students typed their press release in class and emailed to me for a grade
- Students then worked on W-5 in their packets
- W-5 must be completed for tomorrow!
2/16 - Use the table feature in Microsoft Word to create an equipment inventory list
- QOTD
- Students typed their W-5 on the computer and then emailed to me for a grade
 
2/17 - Read non-fiction items and summarize
- Students read an article and wrote a 5 sentence summary of the article, and typed in correct MLA formatting (including a Works Cited page)
 
2/21 - Use the table feature in Microsoft Word to create player personnel form
- Students followed along with the teacher to create a player personnel form for their players
 
2/22 - Same as 2/21
- QOTD
- Students finished their player personnel form
- Then students worked on E-3 in their packets
 
2/23
- Use Microsoft Excel to calculate the average salary of your team
- Use Microsoft Excel to create a chart to compare data
- QOTD
- Students filled in salaries for their players on their rosters and we did Total Salary, Average Salary, and Max Salary formulas
- We also selected the top 5 salaried players and charted their information using a pie chart
 
2/24
- Read non-fiction items and summarize
- Students read an article and wrote a 5 sentence summary of the article, and typed in correct MLA formatting (including a Works Cited page)
 
2/27
- Use Microsoft Excel to organize your dream team schedule
- QOTD
- We created our schedule in Excel today in class
- HW E-4 in packet
HW: E-4 in packet
2/28
- Use Microsoft Excel to calculate ticket sales revenue
- QOTD
- We created ticket sales in Excel today in class
 
3/1
- Use desktop publishing software to design a business card
- QOTD
- Talked about good, bad, and ugly business card designs
- Students sketched out 3 different business card designs in DTP-1
- No period 5 class because of early dismissal
 
3/2
- Same as 3/1
- Students designed a business card for my team, as practice. Followed along with me.
Students emailed their practice business card and then started working on their own
 
3/3
- Same as 3/1
- Internet was down, so there was no technology article today
- Students worked on their business cards (3 of their own) and emailed me all 3 when complete
 
3/6
- Same as 3/1
- Students worked on their business cards (3 of their own) and emailed me all 3 when complete
 
3/7
- Read non-fiction items and summarize
- Students read an article and wrote a 5 sentence summary of the article, and typed in correct MLA formatting (including a Works Cited page)
 
3/8  
- Catchup day
 
3/13 - Use desktop publishing software to design a VIP pass for the team
- QOTD
- Students designed a VIP pass for their team
 
3/14 - Use desktop publishing software to design a t-shirt to sell at games
- Students created a shirt design (both front and back) in Publisher and emailed to teacher for a grade
 
3/15  
- Catchup day
 
3/16 - Read non-fiction items and summarize
- Students read an article and wrote a 5 sentence summary of the article, and typed in correct MLA formatting (including a Works Cited page)
 
3/17 - Use desktop publishing software to create a magazine ad to advertise for the opening game
- QOTD
- Students created their own magazine ad for their team.
- Students then emailed it to the teacher for a grade
 
3/20 - Use desktop publishing software to create a cereal box cover
- Students filled out DTP-5 in their packet
- Catchup day after
- DTP-5 due tomorrow!
3/21 - Same as 3/20
- Students were able to create a magazine ad for bonus today
- After, they could make up work owed
- DTP-5 due tomorrow!
3/22 - Same as 3/20
- QOTD
- Students created their own cereal box today in Publisher
 
3/23 - Same as 3/20
- Students worked on their cereal boxes in class
- DTP-6 in packet
- DTP-6 in packet done for Monday
3/24 - Read non-fiction items and summarize - Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well  
3/27 - Use desktop publishing software to design a three-fold brochure - Students worked on their first side of their brochure today in class (DTP-6)  
3/28 - Same as 3/27 - Students worked on their second side of their brochure in class (DTP-6)  
3/29 - Same as 3/27
- Catchup day
- DTP-7 in packet
- Have DTP-7 done in packet
3/30 - Use desktop publishing software to create a team newsletter
- Students worked  on their newsletter (DTP-7) on the computer
 
3/31 - Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
 
4/3 - Same as 3/27
- Students finished their newsletter (DTP-7) on the computer
- Students worked on A-1 in packet
-A-1 in packet due tomorrow
4/4
- Create a basic database using Microsoft Access
- Create fields, record, and change field size
Period 2
- I checked A-1 in their packet and then we created a database together for our fan database. Students finished typing the database and emailed to me for a grade.
Period 5
- Students worked on A-2 in their packet
 
4/5
- Same as 4/4
Period 2
- Students worked on A-2 in their packet in class
Period 5
- Students typed their A-1 in class (fan database) and emailed it to me
- A-2 due tomorrow
4/6
- Same as 4/5
- Students typed A-2 (Advertiser Database) In Access and then emailed to teacher for a grade
 
4/7
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
- A-3 due Monday
4/18
- Create a PowerPoint presentation to help enhance presentation about team
- We went over the specifics on PPT-1 as well as the presentation portion
- Students started working on their slides for their PPT-1
 
4/19
- Same as 4/18
- Student worked on the PPT-1 on the computer in class
 
4/20
- Same as 4/18
- Student worked on the PPT-1 on the computer in class
 
4/21
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well
 
4/24
- Same as 4/18
- Students worked on the PPT-1 on the computer in class
 
4/25
- Same as 4/18
- We went over how to create mp3s from youtube videos
- Students created their mp3 files and inserted them into their PPT-1
 
4/26
- Same as 4/18
- Students worked on the PPT-1 on the computer in class - Presentations start Monday next week!
4/27
- Same as 4/18
- Students worked on the PPT-1 on the computer in class - Presentations start Monday next week!
4/28
- Same as 4/18
- Students worked on the PPT-1 on the computer in class - Presentations start Monday next week!
5/1
- Same as 4/18
- PRESENTATIONS!  
5/2
- Same as 4/18
- PRESENTATIONS!  
5/3
- Same as 4/18
- PRESENTATIONS!  
5/4
- Same as 4/18
- PRESENTATIONS!  
5/5
- Same as 4/18
- PRESENTATIONS!  
5/8
- Same as 4/18
- PRESENTATIONS!  
5/9
- Read non-fiction items and summarize
- Students worked on their type five sentence summary of a technology article of choice and then typed the Works Cited with it as well  
5/10
- Final encompassess all aspects of learning from entire semester 
- Students began working on Final project in class  
5/11
- Same as 5/10
- Students worked on Final project in class  
5/12
- Same as 5/10
- Students worked on Final project in class  
5/15
- Same as 5/10
- Students worked on Final project in class