testing1
Use BPA Integrated Office Test or other tests as assessments?? Re-do some of the Excel to be more related to their business?
August 17 - Introductions
1. Roll Call--Fav Food/Where?
2. Ice Breaker Bingo
August 18 - Computer Terms
1. Roll Call--Favorite Place you have traveled to/where do you want to go?
2. Computer Kahoot; General Computer Knowledge Kahoot
3. Future Technologies
August 19 - File Management/One Drive
1. Roll Call--Activities/Athletics at SW (or outside)
2. File Management/Set Up Folders--clean out files; do Monterey update over the weekend to prep computer for our stuff
3. Set Up Office365 on Mac (to be able to work at home)
4. Set Up OneDrive (on Mac); create new folders for this class (PPoint, Word, Excel)
August 22 - Intro to Outlook/Email
1. Roll Call--Favorite TV Show/Movie
2. Welcome to Computer Apps! Syllabus/Tour de Canvas
3. Email Etiquette; Emailing a Teacher
4. Intro to Outlook/Email/Signature/Attachments/Calendar
5. Using the info you learned last class--send Mrs. Krewson an Introduction Email
6. Enter five upcoming things on your calendar; set reminder
August 24 - Choose Seats/All About Me PowerPoint
1. Choose seats for seat chart/Logging On
2. Set Desktop Background/Favorites--Canvas; set up OneDrive; are folders there?
3. Remind about email; screen check calendar items
4. Intro to All About Me Project; show examples
5. Intro to PowerPoint
August 26 - All About Me PowerPoint
1. Intro to PowerPoint; show pics, animations, transitions, sound, video, etc.
2. Work on All About Me Project
3. Save your work to OneDrive, PowerPoint Folder!
August 29 - All About Me PowerPoint
1. Finish All About Me Project
August 31 - All About Me Presentations
1. Begin All About Me Project Presentations
September 2 - Business Logo
1. Begin creating Your Own Business Logo (see list of possibles/example)
****Has to include your name as a a part of the logo and a graphic; save As Pic in PPoint; show icons
September 5 - NO SCHOOL - LABOR DAY
September 6 - NO SCHOOL - PROFESSIONAL LEARNING DAY
September 7 - Word
1. Finish creating Your Own Business Logo (see list of possibles/example)
****Has to include your name as a a part of the logo and a graphic; save As Pic in PPoint; show icons
2. Use logo to create a letterhead (show examples)
3. Intro to Word; ribbons/tools/menus
September 9 - Word
1. Intro to correct Business Letter Format (fill out your copy); key Example Letter for on-screen check
2. Assignment--Product Request Letter: Use the letterhead you just created to key a letter to a vendor requesting information about a new piece of equipment for your business; should introduce who you are and what your business is, request information about the product(s), and thank them for their time; follow example letter for spacing and formatting. Proofread and watch spelling/grammar/punctuation!
3. Save as Product Request Letter to OneDrive/Word folder; upload to Canvas for grading
September 12 - Word
1. Finish Assignment--Product Request Letter; upload to Canvas for grading
2. Correct Memorandum Format; when do we use these instead of letters?
3. Assignment--Business Memo: Key a memo to your business employees about an upcoming event they are required to attend. Be sure to give them the date and time of the event and what you expect them to do during the event. Follow example memo for spacing and formatting; Proofread and watch spelling/grammar/punctuation!
4. Save as Employee Memo to OneDrive/Word folder; upload to Canvas for grading
September 14 - Word
1. Formatting in Word
3. Assignment--Menu/Price List: Key a menu/price list for your business that contains your business logo, 12-15 items customers might buy from you, and dot leader tabs separating the item from the price; Proofread and watch spelling/grammar/punctuation!
4. Example Price List
5. Upload to Canvas for grading
September 16 - Word
1. Finish Price List; upload to Canvas for grading
2. Be sure your Product Request Letter, Employee Memo and Price List are all submitted to Canvas for grading
September 19 - Word
1. Finish Assignment--Menu/Price List: Key a menu/price list for your business that contains your business logo, 12-15 items customers might buy from you, and dot leader tabs separating the item from the price; Proofread and watch spelling/grammar/punctuation!
2. Upload to Canvas for grading
3. Intro to Tables; show table menus
September 21 - Word
1. Intro to Tables; show table menus
2. Create an inventory list for your business; see Canvas Modules; show examples
September 23 - Word
1. Finish inventory list for your business in Canvas modules
2. Show how to merge/split cells, center info, add check box symbol, etc.
3. Begin Employee Information Form; in Canvas Modules show examples
September 26 - Word
1. Finish Employee Information Form; in Canvas Modules; Upload to Canvas for grading
2. Work on any missing work; check Canvas for zeros and use any extra time to get caught up
September 28 - Employee Work Schedule Assessment
1. Show how to split table, do formulas, remove gridlines, etc. (do a class example)
2. Begin Assessment: Employee Work Schedule
September 30 - NO SCHOOL -- P/T CONFERENCES
October 3 – Newsletter
1. Finish Assessment: Employee Work Schedule; Upload to Canvas for grading
2. Formatting in Word
October 5 – Newsletter Project
1. Work on Newsletter Project
October 7 – Newsletter Project
1. Finish Newsletter Project; Upload to Canvas for Grading
October 10 – Mail Merge
1. Finish Newsletter Project; Upload to Canvas for Grading
2. Intro to Mail Merge--Practice Letter; Practice Data Source
3. Show Labels; Use Practice Data Source
4. Begin Mail Merge Assignment--Using Mail Merge, create a form letter to send to your customers about an upcoming customer appreciation event and send to 5 different recipients; Create mailing labels to go with your five letters; submit to Canvas when completed
October 12 - TESTING DAY
October 13 – Mail Merge (all classes)
1. Finish Mail Merge Assignment--Using Mail Merge, create a form letter to send to your customers about an upcoming customer appreciation event and send to 5 different recipients; Create mailing labels to go with your five letters; submit to Canvas when completed
October 14 - NO SCHOOL - END QTR 1
October 17 - Intro to Excel
1. Intro to Excel--Note Differences with Word
2. Intro to Excel--Practice: Grades
October 19 - Balance Sheet
1. Finish Balance Sheet; go over; Upload screenshot plus Excel formulas to Canvas
2. Begin Personal Finances; go over formula; Upload screenshot plus Excel formulas to Canvas
3. Show Income Statement and Basketball Spreadsheet; you will work on this next class with sub
October 21 - Personal Finance/Income Statement
1. Begin Personal Finances; go over formula; Upload screenshot plus Excel formulas to Canvas
2. Begin Income Statement--Upload screenshot plus Excel formulas to Canvas
October 24 – Basketball Spreadsheet
1. Begin Basketball Spreadsheet; follow directions and save; submit screenshot plus Excel formulas to Canvas by end of class
2. Finish anything else not submitted (Balance Sheet, Personal Finance, Income Statement)
October 26 – Basketball Spreadsheet
1. Go over Basketball Spreadsheet, Personal Finances and Income Statement
2. Review Excel Functions (Min, Max, Sum, Average, Round, Fill Handle)
3. Finish Basketball Spreadsheet; follow directions and save; submit screenshot plus Excel formulas to Canvas by end of class
4. Finish anything else not submitted (Balance Sheet, Personal Finance, Income Statement)
5. Go over all three documents to be sure everything was submitted correctly; give time to redo/resubmit if necessary
October 28 – Dive Log
1. Begin Dive Log--upload to Canvas
2. Finish anything else not submitted (Balance Sheet, Personal Finance, Income Statement, Basketball)
October 31 - NO SCHOOL - PROFESSIONAL LEARNING
November 2 - IF Statements
1. Intro to IF Statements
2. Practice File; If Statement Practice
3. Begin Pizza Palace
November 4 - Absolute Cell Reference
1. Review/Finish Pizza Palace
2. Intro to Absolute Cell Reference
3. Absolute Practice
4. Begin Dance, Dance (file)
November 7 - Sorting/Filtering
1. Finish/Review Dance, Dance (file)
2. Show Sorting Practice; Filtering Practice
3. Excel Test (BPA Test)
November 9 - Excel Graphing
1. Finish Excel Test (BPA Test)
2. Chart Types
3. Show Graphing--Skittles
4. Begin Ch.7 Charts/Graphs Assignments--intro to all assignments
November 11 - Excel Graphing
1. Work on Ch.7 Charts/Graphs Assignments; Upload each to Canvas
November 14 - Excel Graphing
1. Go over BPA Excel Test (Key)
2. Finish Ch.7 Charts/Graphs Assignments; Upload each to Canvas
3. Finish any other old assignments that haven't been turned in
November 16 - Employee Party Project
1. Begin Employee Party Project; Show good examples
November 18 - Employee Party Project
1. Finish Employee Party Project; Submit to Canvas
November 21-25 -- NO SCHOOL - THANKSGIVING BREAK
November 28 - Travel Project
1. Intro to Travel Project; Itinerary Format; Expense Sheet Format
November 30 - Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
December 2 – Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
December 5 - Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
December 7 - Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
2. Intro to Final Project--Utah Golf
December 9 - Travel Project
1. Finish Travel Project; Itinerary Format; Expense Sheet Format
2. Work on Final Project--Utah Golf
December 12 - Final Project
1. Intro to Final Project--Utah Golf
December 14 - Final Project
1. Work on Final Project--Utah Golf
December 19 - Final DUE
1. Finish Final Project--Utah Golf
2. CTE Survey (District)
Use BPA Integrated Office Test or other tests as assessments?? Re-do some of the Excel to be more related to their business?
August 17 - Introductions
1. Roll Call--Fav Food/Where?
2. Ice Breaker Bingo
August 18 - Computer Terms
1. Roll Call--Favorite Place you have traveled to/where do you want to go?
2. Computer Kahoot; General Computer Knowledge Kahoot
3. Future Technologies
August 19 - File Management/One Drive
1. Roll Call--Activities/Athletics at SW (or outside)
2. File Management/Set Up Folders--clean out files; do Monterey update over the weekend to prep computer for our stuff
3. Set Up Office365 on Mac (to be able to work at home)
4. Set Up OneDrive (on Mac); create new folders for this class (PPoint, Word, Excel)
August 22 - Intro to Outlook/Email
1. Roll Call--Favorite TV Show/Movie
2. Welcome to Computer Apps! Syllabus/Tour de Canvas
3. Email Etiquette; Emailing a Teacher
4. Intro to Outlook/Email/Signature/Attachments/Calendar
5. Using the info you learned last class--send Mrs. Krewson an Introduction Email
6. Enter five upcoming things on your calendar; set reminder
August 24 - Choose Seats/All About Me PowerPoint
1. Choose seats for seat chart/Logging On
2. Set Desktop Background/Favorites--Canvas; set up OneDrive; are folders there?
3. Remind about email; screen check calendar items
4. Intro to All About Me Project; show examples
5. Intro to PowerPoint
August 26 - All About Me PowerPoint
1. Intro to PowerPoint; show pics, animations, transitions, sound, video, etc.
2. Work on All About Me Project
3. Save your work to OneDrive, PowerPoint Folder!
August 29 - All About Me PowerPoint
1. Finish All About Me Project
August 31 - All About Me Presentations
1. Begin All About Me Project Presentations
September 2 - Business Logo
1. Begin creating Your Own Business Logo (see list of possibles/example)
****Has to include your name as a a part of the logo and a graphic; save As Pic in PPoint; show icons
September 5 - NO SCHOOL - LABOR DAY
September 6 - NO SCHOOL - PROFESSIONAL LEARNING DAY
September 7 - Word
1. Finish creating Your Own Business Logo (see list of possibles/example)
****Has to include your name as a a part of the logo and a graphic; save As Pic in PPoint; show icons
2. Use logo to create a letterhead (show examples)
3. Intro to Word; ribbons/tools/menus
September 9 - Word
1. Intro to correct Business Letter Format (fill out your copy); key Example Letter for on-screen check
2. Assignment--Product Request Letter: Use the letterhead you just created to key a letter to a vendor requesting information about a new piece of equipment for your business; should introduce who you are and what your business is, request information about the product(s), and thank them for their time; follow example letter for spacing and formatting. Proofread and watch spelling/grammar/punctuation!
3. Save as Product Request Letter to OneDrive/Word folder; upload to Canvas for grading
September 12 - Word
1. Finish Assignment--Product Request Letter; upload to Canvas for grading
2. Correct Memorandum Format; when do we use these instead of letters?
3. Assignment--Business Memo: Key a memo to your business employees about an upcoming event they are required to attend. Be sure to give them the date and time of the event and what you expect them to do during the event. Follow example memo for spacing and formatting; Proofread and watch spelling/grammar/punctuation!
4. Save as Employee Memo to OneDrive/Word folder; upload to Canvas for grading
September 14 - Word
1. Formatting in Word
- Margins, line spacing, font, paragraph, symbols, dates, superscript/subscript, letter spacing, align at tab
3. Assignment--Menu/Price List: Key a menu/price list for your business that contains your business logo, 12-15 items customers might buy from you, and dot leader tabs separating the item from the price; Proofread and watch spelling/grammar/punctuation!
4. Example Price List
5. Upload to Canvas for grading
September 16 - Word
1. Finish Price List; upload to Canvas for grading
2. Be sure your Product Request Letter, Employee Memo and Price List are all submitted to Canvas for grading
September 19 - Word
1. Finish Assignment--Menu/Price List: Key a menu/price list for your business that contains your business logo, 12-15 items customers might buy from you, and dot leader tabs separating the item from the price; Proofread and watch spelling/grammar/punctuation!
2. Upload to Canvas for grading
3. Intro to Tables; show table menus
September 21 - Word
1. Intro to Tables; show table menus
2. Create an inventory list for your business; see Canvas Modules; show examples
September 23 - Word
1. Finish inventory list for your business in Canvas modules
2. Show how to merge/split cells, center info, add check box symbol, etc.
3. Begin Employee Information Form; in Canvas Modules show examples
September 26 - Word
1. Finish Employee Information Form; in Canvas Modules; Upload to Canvas for grading
2. Work on any missing work; check Canvas for zeros and use any extra time to get caught up
September 28 - Employee Work Schedule Assessment
1. Show how to split table, do formulas, remove gridlines, etc. (do a class example)
2. Begin Assessment: Employee Work Schedule
September 30 - NO SCHOOL -- P/T CONFERENCES
October 3 – Newsletter
1. Finish Assessment: Employee Work Schedule; Upload to Canvas for grading
2. Formatting in Word
- Spellcheck/Thesaurus, Hyperlink, Format Painter, Headings, Table of Contents, Citations/References
- DS, Footnotes, Headings, Page Numbering, Indents, SmartArt, Works Cited and Hanging Indent
October 5 – Newsletter Project
1. Work on Newsletter Project
October 7 – Newsletter Project
1. Finish Newsletter Project; Upload to Canvas for Grading
October 10 – Mail Merge
1. Finish Newsletter Project; Upload to Canvas for Grading
2. Intro to Mail Merge--Practice Letter; Practice Data Source
3. Show Labels; Use Practice Data Source
4. Begin Mail Merge Assignment--Using Mail Merge, create a form letter to send to your customers about an upcoming customer appreciation event and send to 5 different recipients; Create mailing labels to go with your five letters; submit to Canvas when completed
October 12 - TESTING DAY
October 13 – Mail Merge (all classes)
1. Finish Mail Merge Assignment--Using Mail Merge, create a form letter to send to your customers about an upcoming customer appreciation event and send to 5 different recipients; Create mailing labels to go with your five letters; submit to Canvas when completed
October 14 - NO SCHOOL - END QTR 1
October 17 - Intro to Excel
1. Intro to Excel--Note Differences with Word
2. Intro to Excel--Practice: Grades
- Parts of window, formatting, formulas
October 19 - Balance Sheet
1. Finish Balance Sheet; go over; Upload screenshot plus Excel formulas to Canvas
2. Begin Personal Finances; go over formula; Upload screenshot plus Excel formulas to Canvas
3. Show Income Statement and Basketball Spreadsheet; you will work on this next class with sub
October 21 - Personal Finance/Income Statement
1. Begin Personal Finances; go over formula; Upload screenshot plus Excel formulas to Canvas
2. Begin Income Statement--Upload screenshot plus Excel formulas to Canvas
October 24 – Basketball Spreadsheet
1. Begin Basketball Spreadsheet; follow directions and save; submit screenshot plus Excel formulas to Canvas by end of class
2. Finish anything else not submitted (Balance Sheet, Personal Finance, Income Statement)
October 26 – Basketball Spreadsheet
1. Go over Basketball Spreadsheet, Personal Finances and Income Statement
2. Review Excel Functions (Min, Max, Sum, Average, Round, Fill Handle)
3. Finish Basketball Spreadsheet; follow directions and save; submit screenshot plus Excel formulas to Canvas by end of class
4. Finish anything else not submitted (Balance Sheet, Personal Finance, Income Statement)
5. Go over all three documents to be sure everything was submitted correctly; give time to redo/resubmit if necessary
October 28 – Dive Log
1. Begin Dive Log--upload to Canvas
2. Finish anything else not submitted (Balance Sheet, Personal Finance, Income Statement, Basketball)
October 31 - NO SCHOOL - PROFESSIONAL LEARNING
November 2 - IF Statements
1. Intro to IF Statements
2. Practice File; If Statement Practice
3. Begin Pizza Palace
November 4 - Absolute Cell Reference
1. Review/Finish Pizza Palace
2. Intro to Absolute Cell Reference
3. Absolute Practice
4. Begin Dance, Dance (file)
November 7 - Sorting/Filtering
1. Finish/Review Dance, Dance (file)
2. Show Sorting Practice; Filtering Practice
3. Excel Test (BPA Test)
November 9 - Excel Graphing
1. Finish Excel Test (BPA Test)
2. Chart Types
3. Show Graphing--Skittles
4. Begin Ch.7 Charts/Graphs Assignments--intro to all assignments
November 11 - Excel Graphing
1. Work on Ch.7 Charts/Graphs Assignments; Upload each to Canvas
November 14 - Excel Graphing
1. Go over BPA Excel Test (Key)
2. Finish Ch.7 Charts/Graphs Assignments; Upload each to Canvas
3. Finish any other old assignments that haven't been turned in
November 16 - Employee Party Project
1. Begin Employee Party Project; Show good examples
November 18 - Employee Party Project
1. Finish Employee Party Project; Submit to Canvas
November 21-25 -- NO SCHOOL - THANKSGIVING BREAK
November 28 - Travel Project
1. Intro to Travel Project; Itinerary Format; Expense Sheet Format
November 30 - Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
December 2 – Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
December 5 - Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
December 7 - Travel Project
1. Work on Travel Project; Itinerary Format; Expense Sheet Format
2. Intro to Final Project--Utah Golf
December 9 - Travel Project
1. Finish Travel Project; Itinerary Format; Expense Sheet Format
2. Work on Final Project--Utah Golf
December 12 - Final Project
1. Intro to Final Project--Utah Golf
December 14 - Final Project
1. Work on Final Project--Utah Golf
December 19 - Final DUE
1. Finish Final Project--Utah Golf
2. CTE Survey (District)