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/28 First day of school
- Welcome
- Go over syllabus and rules
- Pass out folders that are to be taken home (not left in the classroom)
- Log in and create folders in Google Drive
- Signed syllabus due Wednesday
8/29 Second day of school
- Pass out notebooks for QOTD
- Do QOTD together
- Look at sample logos from last year's class
- Pass out Dream Team packets (textbook)
- Work on PG-1 in packet
- Signed syllabus due Wednesday
- PG-1 complete for Wednesday
8/30
- Use Microsoft Word to create and format a business memo
- QOTD in notebooks
- Send a test email
- Start typing PG-1 on computer in Word (Memo)
- Signed syllabus due today!
8/31
- Same as 8/30
- QOTD in notebooks
- Finish typing Memo (PG-1) in Word and email teacher
- Work on PG-2 in packet
- Teacher checked PG-1 in packet
- PG-2 complete for Friday
9/1
- Use graphic design software to create a professional team logo
- QOTD in notebooks
- Create a practice logo for my team (Crazy Cats)
- Save two ways - as a Publisher file and as a JPEG
- Will check PG-2 in packet on Tuesday
9/5
- Same as 9/1
- QOTD in notebooks
- Checked PG-2 in packets
- Create own team logo
 
 9/6 - Same as 9/1
- Internet was down and students could not even log in to the computers
- They studied for their history test instead
 
9/7 - Same as 9/1
- QOTD in notebooks
- Finish logos and email the JPEGs
- Fill out logo info sheet and contact ifo sheet
 
9/8 - Use the Internet and other resources to create a team roster
- Fill out PG-3 in packet
- Finish PG-3 if not finished in class
9/11 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article together in class
- As a class, type up a five sentence summary of the article along with a Works Cited page
 
9/12 - Same as 9/8
- QOTD in notebooks
- I checked PG-3 in workbooks (HW)
- Type up roster in Excel
 
9/13 - Same as 9/8
- QOTD in notebooks
- Finish roster and email roster to teacher
- Start designing 3 letterhead samples on own on W-1 in packet
 
9/14 - Use Microsoft Word to create a letterhead template
- QOTD in notebooks
- Create Letterhead 1 together in class
- Notebook check tomorrow!
9/15 - Same as 9/14
- Finish Letterhead 1 in class
- Work on other 2 Letterhead on own
- Notebook check today
9/18 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
9/19 - Same as 9/14
- Finish Letterhead 1,2,3 in class today
 
9/20 - Use Microsoft Word to create a block-style business letter
- Work on W-3 in packet
 
9/21 - Use Microsoft Word to create a press release
- Work on W-4 in packet
- W-3 and W-4 will be checked on Monday
9/22  
NO SCHOOL
 
9/25
- Use Microsoft Word to create an envelope
- Use Microsoft Word to create a block-style business letter
 
- Checked W-3 and W-4 in the packets
- Create an envelope for teams
- Start typing Letter to Commissioner
 
9/26 - Use Microsoft Word to create a block-style business letter
- QOTD in notebooks
- Finish typing Letter to Commissioner and email to teacher
 
 9/27  - Use Microsoft Word to create a press release
- QOTD in notebooks
- Type Press Release and email to teacher
- Work on W-5 in packet
- W-5 in packet due tomorrow
9/28 - Use the table feature in Microsoft Word to create an equipment inventory list
- QOTD in notebooks
- Check W-5 in packet (HW)
- Type Equipment List and email to teacher
 
9/29 - Type a summary in correct MLA formatting including a properly cited Works Cited page - Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited  
10/2 - Same as 9/28
- Catchup day
 
10/3 - Same as 9/28
- Finish and email teacher Equipment List
 
10/4 - Same as 9/28
- Catchup day
 
10/9 - Use the table feature in Microsoft Word to create a player personnel form
- Work on W-6 (player personnel form) in Word and email to teacher
 
10/10 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
10/11  
- Catchup day
 
10/12 - Use Microsoft Excel to calculate the total salaries for your team.
- QOTD in notebooks
- Typed salaries for our players, sorted the information by the largest salary and used a formula for the total salaries 
- Saved as Total Salaries in E folder and emailed teacher
 
10/13 - Use Microsoft Excel to add a chart to enhance data
- QOTD in notebooks
- Added a pie chart to the data in Total Salaries file in Excel
- Emailed to teacher
 
10/16 - Use Microsoft Excel to create a season schedule
- Typed Season schedule (E-3) in Excel and added formatting
- Emailed to teacher
 
10/17 - Use Microsoft Excel to calculate ticket sales and total sales from tickets
- Typed Ticket Sales (E-4) in Excel and added formatting
- Emailed to teacher
 
10/18 - Same as 10/17
- Students finished Ticket Sales (E-4) and emailed to teacher
- Catchup day
 
10/19 - Use desktop publishing software to design a business card.
- QOTD in notebooks
- Talked about the good, the bad, and the ugly business card design
- Learned how to properly shake hands when greeting someone
- Sketched out 3 different designs for their own business cards
- DTP-1 in packet due Monday
10/23 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
10/24 - Same as 10/19
- Students created a business card with teacher as a sample in class
 
10/25 - Same as 10/19
- Students finished three different business cards and emailed to teacher
 
10/26 - Same as 10/19
- QOTD in notebooks
- Students finished three different business cards and emailed to teacher
- Worked on DTP-2 in packets
- DTP-2 due Friday
10/27 - Use desktop publishing software to design a VIP pass
- QOTD in notebooks
- Students worked on their DTP-2 (VIP Pass) on computer and emailed to teacher
 
10/30 - Same as 10/27
- Catchup day (2 hour delay schedule so class was shortened)
 
10/31 - Use desktop publishing software to design a team shirt
- QOTD in notebooks
- Students worked on their DTP-3 (T-shirt) on computer and emailed to teacher
 
11/1 - Use desktop publishing to create a magazine advertisement
- Students worked on DTP-4 in workbooks
- Catchup day
 
11/2 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
11/3 - Use desktop publishing to create a magazine advertisement
- Students created DTP-4 (Magazine Ad) on the computer and emailed to the teacher
 
11/6 - Use desktop publishing to create a cereal box
- Students worked on DTP-5 in workbooks and started to create DTP-5 (Cereal Box) on computer in class
 
11/7  
- No class because of GCCTC tour
 
11/8 - Same as 11/6
- Students worked on DTP-5 (Cereal Box) on the computer and emailed to teacher
 
11/9  
- Catchup day
 
11/10  
- No School
 
11/13 - Use desktop publishing to create a brochure
- QOTD in notebooks
- Students started to create one side of DTP-6 (brochure) for their team
 
11/14 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
11/15 - Same as 11/13
- Students worked on the back side of DTP-6 (brochure) for their team in class
 
11/16 - Same as 11/13
- QOTD in notebooks
- Students finished and emailed DTP-6 (brochure) to teacher
 
11/17 - Use desktop publishing to create a newsletter
- Students worked on DTP-7 in packet and then started to create DTP-7 (newsletter) on the computer
- DTP-7 in packet due Monday
11/20 - Same as 11/17
- Students worked on DTP-7 (newsletter) on the computer
- Checked DTP-7 in packet for completion
 
11/21 - Same as 11/17
- Students worked on a bonus assignment
- Students continued to work on the DTP-7 (newsletter) and email to teacher
 
11/22 - Same as 11/17
- Catchup day
 
11/29 - Use database program to create a fan database
- Students worked on A-1 in their packet
 
11/30 - Same as 11/29
- Students typed A-1 (Fan Database) on computer and emailed to teacher
- Worked on A-2 in packet for tomorrow
- Received ornament template so they can make an engraved ornament using the new laser engraver
- A-2 due tomorrow
12/1  
- Catchup day because several students were absent
- Students worked on A-2 in packets and their ornament design
 
12/4 - Use database program to create an advertiser database
- Students worked on A-3 in their packets during class
 
12/5 - Same as 12/4
- Students typed A-2 (Advertiser Database) on Access and emailed to teacher for a grade
 
12/6 - Same as 12/4
- Students finished typing A-2 (Advertiser Database) and completed A-3 in their packet
A-3 due tomorrow
12/7 - Use database program to create a music database
- Students typed A-3 (Music Database) in Access and emailed to teacher for a grade
 
12/8 - Create a PowerPoint presentation to enhance your Dream Team presentation to the class
- We went over what is to be expected during the actual presentation (what to wear, the rubric, etc.)
- Students started on their PPT-1 (Meet the Team presentation) in class - first 2 slides
 
12/11 - Same as 12/8
- Students worked on more slides on their PPT-1 (Meet the Team presentation) in class
 
12/12 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
12/13 - Same as 12/8
- Students worked on downloading their top 5 songs to put into their PowerPoint presentation
 
12/14 - Same as 12/8
- Students worked on more slides on their PPT-1 (Meet the Team presentation) in class
 
12/15 - Same as 12/8
- Students worked on more slides on their PPT-1 (Meet the Team presentation) in class
 
12/18 - Same as 12/8
- Students worked on more slides on their PPT-1 (Meet the Team presentation) in class
 
12/19 - Same as 12/8
- Students worked on more slides on their PPT-1 (Meet the Team presentation) in class
- We also went over what to say during presentations
 
1/4 - Same as 12/8
- Because of the delay, only one student was able to present today
- She presented, we talked about how she did
- Students filled in a survey on how she did
- Presentations 1/5, 1/8, 1/9, 1/10 and 1/11
1/5 No School    
1/8 No School    
1/9 - Same as 12/8 - Students presented and the class filled in their surveys - Presentations 1/10 1/11, 1/12 and 1/15
1/10 - Same as 12/8 - Students presented and the class filled in their surveys - Presentations 1/11, 1/12 and 1/15
1/11 - Same as 12/8 - Students presented and the class filled in their surveys - Presentations 1/12 and 1/15
1/12 - Same as 12/8 - Students presented and the class filled in their surveys - Presentation 1/15
1/15 - Same as 12/8 - Students presented and the class filled in their surveys  
1/16   - Students worked on their final project  
1/17   - Students worked on their final project  
1/18   - Catchup day  
       
1/22   - Students wrote a 150 word paper introducing themselves  
1/23  
- Went over syllabus in class
- Students received folders and their Dream Team packet
- Students sent a test email
- Signed syllabus due 1/29
1/24  
- We did the QOTD together in class, so students know how to do it
- Students filled in PG-1 in their packets
- Signed syllabus due 1/29
- PG-1 in packet due tomorrow
1/25 - Use Microsoft Word to create and format a business memo
- QOTD in notebooks
- Students typed, along with the teacher, their PG-1 in the packet (to create a memo in Word)
- Signed syllabus due 1/29
1/26  
- Students read an article pertaining to technology together in class and discussed
- Signed syllabus due 1/29
1/29 - Same as 1/25
- QOTD in notebooks
- Students finished their Memo and emailed to teacher
- Students then worked on PG-2 in packet
- Signed syllabus due today!
- PG-2 in packet due tomorrow (and in color)
1/30 - Use graphic design software to create a professional team logo
- QOTD in notebooks
- Made folders for the class on the computer
- Teacher checked PG-2 in packet
- Students learned how to find good graphics using the Internet and how to save them correctly
 
1/31 - Same as 1/30
- No QOTD in notebooks
- Period 1 - students created a logo for my fictitious team and emailed me the final logo
- Period 2 - half the class was missing so worked on fixing their PG-2 in the packets
 
2/1 - Same as 1/30
- QOTD in notebooks
- Period 1 - Students started to work on their logos in class
- Period 2 - students created a logo for my fictitious team and emailed me the final logo
 
2/2 - Same as 1/30
- Students worked on their logos in class and emailed to teacher
 
2/5 - Same as 1/30
- No QOTD in notebooks
- Catchup day
 
2/6  
- PTC speaker in class
 
2/7  
- No School
 
2/8 - Use the Internet and other resources to create a team roster
- Students worked on PG-3 in their packets
 
2/9 - Same as 2/8
- QOTD in notebooks
- Students filled in For Your Contact Information sheet and For Your Final Logo sheet in packets
- Catchup day
- PG-3 in packet due Monday
2/12 - Same as 2/8
- No QOTD in notebooks
- Students started typing PG-3 (Roster) in Excel today
- I checked PG-3 in packets
 
2/13  
- Catchup day
 
2/14 - Use Microsoft Word to create a letterhead template
- QOTD in notebooks
- We created a letterhead for my team as practice today in class
- Students emailed me their practice letterhead
 
2/15 - Same as 2/14
- No QOTD in notebooks
- Students created 3 different letterheads for their team and emailed to the teacher
 
2/16 - Same as 2/14
- No QOTD in notebooks
- Students created 3 different letterheads for their team and emailed to the teacher
 
2/19
- Use Microsoft Word to create an envelope
 
- QOTD in notebooks
- Created an envelope for the teams (W-2) and emailed to the teacher
- Students worked on W-3 in their packets 
W-3 due tomorrow
2/20 - Use Microsoft Word to create a block-style business letter
- Teacher checked W-3 in packet
- Typed W-3 (Letter to Commissioner) on computer and emailed to teacher
 
2/21  
- Worked on W-4 and W-5 in packet
- Catch up day
W-4 and W-5 due tomorrow
2/22   - Read article with substitute and wrote down 5 sentence summary of the article (we will be using this next week to type the summary in correct MLA formatting)  
2/23   - Use Microsoft Word to create a press release
- Teacher checked W-4 in packet
- Typed W-4 (Press Release) on computer and emailed to the teacher
- Make sure W-5 is done for Monday!
2/26 - Use the table feature in Microsoft Word to create an equipment inventory list
- Teacher checked W-5 in packet
- Typed W-5 (Equipment List) on computer and emailed to teacher
 
2/27  
- Catchup day!
 
2/28 - Use the table feature in Microsoft Word to create a player personnel form
- Students worked on W-6 (Player Personnel Form) in class with teacher
- Emailed to teacher
 
3/1 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- As a class, we typed a summary of an article in MLA format, including Works Cited
- Students then emailed the teacher their practice summary
 
3/2 - Use Microsoft Excel to calculate the total salaries for your team.
- QOTD in notebooks
-Students typed in salaries for their players and saved that as Salaries in their E folders
- Then we sorted the data, graphed the top 5 players and their salaries, and found a total sum of all of the salaries for the team
 
3/5 - Same as above
- Students worked on E-3 and E-4 in their packets
 
3/6 - Use Microsoft Excel to add a chart to enhance data
- We finished working on our salaries file by adding a pie chart and making some formatting and layout changes to the pie chart
- Students emailed me their work for a grade
 
3/7 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
3/8 - Use Microsoft Excel to create a season schedule
- No QOTD but I collected notebooks to check!
- Period 1 - typed their E-3 (Schedule) on the computer in Excel, added formatting, and emailed to the teacher for a grade
- Period 2 - catchup day
 
3/12 - Same as above
- Period 1 catchup day
- Period 2 no class because of ALICE training
 
3/13  
- Students worked on the hour of code in class
 
3/14
- Use Microsoft Excel to create a season schedule
- Use Microsoft Excel to calculate ticket sales and total sales from tickets
- No QOTD but I went over how the notebooks were graded
- Period 1 typed their E-4 (Ticket Sales) on the computer in Excel, added formatting, and emailed the teacher for a grade
- Period 2  typed their E-3 (Schedule) on the computer in Excel, added formatting, and emailed to the teacher for a grade
 
3/15 - Use Microsoft Excel to calculate ticket sales and total sales from tickets
- No QOTD
- Period 1 Catchup day
- Period 2 typed their E-4 (Ticket Sales) on the computer in Excel, added formatting, and emailed the teacher for a grade
 
3/16 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
3/19 - Use desktop publishing software to design a business card.
- QOTD in notebooks
- Talked about the good, the bad, and the ugly business card design
- Learned how to properly shake hands when greeting someone
- Started to create one business card together in Publisher
 
3/20 - Same as above
- No QOTD
- We finished our practice business card together as a class
- Then students were able to work on their own business cards
 
3/21  
- Snow day
 
3/22  
- No QOTD
- Students finished business cards
 
3/26 - Type a summary in correct MLA formatting including a properly cited Works Cited page
 
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
3/27 - Use desktop publishing software to design a VIP pass 
- QOTD in notebooks
- Students looked at different VIP passes online and tried to recreate one for their team in their packets
- Students then started on their own DTP-2 (VIP pass) In Publisher
 
3/28 - Use desktop publishing software to design a team shirt
- No QOTD
- Students looked for an appropriate image of a shirt that they wanted to color in their team colors (in Photoshop)
- Students worked on DTP-3 (T-shirt) in class, then in Publisher, and emailed to the teacher for a grade
 
3/29  
- Catchup day
 
4/3 - Use desktop publishing to create a magazine advertisement
- No QOTD
- Students designed DTP-4 (Magazine Ad) in class in Publisher and emailed to the teacher for a grade
 
4/4 - Use desktop publishing to create a cereal box
- Kahoot about cereal boxes
- Students designed DTP-5 (Cereal Box) in class in Publisher and emailed to the teacher for a grade
 
4/5  
- Catchup day
 
4/6 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
4/9  
- Catchup day
 
4/10 - Use desktop publishing to create a brochure
- QOTD in notebooks
- Students will design the front side of their DTP-6 (Brochure) in class
 
 4/11   - Computer issues  
4/12  
- Computer issues
- Student handwrote their three paragraph story for their back side of their brochure
 
4/13  
- Computer issues
 
4/16  
- Computer issues
 
4/17 - Use database program to create a fan database
- Students filled out five entries in their A-1 in their packet (fan database)
- Students then typed the five entries in Access along with the teacher for the Fan Database
- A-2 in packet due Tuesday
4/18 - Use database program to create an advertiser database
- I checked A-2 in the students packets
- Students then typed their ten entries in Access for the Ad Database
 
4/19  
- Catchup day
- A-3 in packet due Monday
4/20 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
- A-3 in packet due Monday
4/23  
- Catchup day
 
4/24 - Use database program to create a music database
- I checked A-3 in the students packets
- Students then typed their ten entries in Access for the Music Database
- We went over, briefly, PPT-1 and the presentation specifics in class
 
4/25 - Create a PowerPoint presentation to enhance your Dream Team presentation to the class
- Students worked on slide 1 and slide 2 in the Dream Team PowerPoint
 
4/26 - Same as 4/25
- Students worked on slide 3 and slide 4 in the Dream Team PowerPoint
 
4/27 - Type a summary in correct MLA formatting including a properly cited Works Cited page
- Read an article from the approved website and type a five sentence summary in correct MLA formatting as well as Works Cited
 
4/30 - Same as 4/25
- Students worked on slide 5 and slide 6 in the Dream Team packet
- Students found out what day they are presenting next week
5/1 - Same as 4/25
- Students worked on slide 7, 8 and 9 in the Dream Team packet
- Presentations start next week!
5/2 - Same as 4/25
- Students worked on slide 10, 11 and 12 in the Dream Team packet
- Presentations start next week!
5/3 - Same as 4/25
- Students worked on their presentations
- Teacher went over what to say on each slide
- Presentations start next week!
5/4 - Same as 4/25  - Students worked on their presentations - Presentations start next week! 
5/7 - Same as 4/25 - Presentations!!!  
5/8 - Same as 4/25 - Presentations!!!  
5/9 - Same as 4/25 - Presentations!!!  
5/10 - Same as 4/25 - Presentations!!!  
5/11 - Same as 4/25 - Presentations!!!  
5/14 - incorporate all that the students have learned into their final project
- Start working Final project
- Presentations!!!
- Final project due May 24
5/15 - Same as 5/14
- Work on Final project
- Presentations!!!
- Final project due May 24
5/16 - Same as 5/14
- Work on Final project
- Final project due May 24
5/17 - Same as 5/14
- Work on Final project
- Final project due May 24
5/18 - Same as 5/14
- Work on Final project
- Final project due May 24
5/21 - Same as 5/14
- Work on Final project
- Final project due May 24
5/22 - Same as 5/14
- Work on Final project
- Final project due May 24