Wednesday Aug. 30	Introduction: Read over the Syllabus The signoff page must be returned by Friday; however, if you return it tomorrow with both sets of signatures you will receive extra credit. If I do not receive your signoff sheet, you will receive zeros on assignments until I receive your sheet! Discuss the structure of the course (GMetrix, Certifications in Adv. Apps, Homework, Testing, etc.) Skyward passwords and assignments--Guidance Office or Ask me :) Permanent seating arrangements TODAY!--Keep in mind I lecture from the back of the room
Thursday Aug. 31	File Management & Getting Started: Log into your computers Mapping Network Drives--we will do this together the first time Create a folder within rm108users (Last Name First Name) Create a shortcut to your rm108users drive on the desktop Create folders within your rm108user folder Create a class website link on your Desktop Add the class website as a Favorite Setting Up Printers--Install sh108 K3920 printer--Update to default printer Pin Word, Excel, Access, PowerPoint, & GMetrix to the Start Menu
Friday Sept. 2	Operating Systems Mac vs. PC https://www.youtube.com/watch?v=M5BZou6C01w Standards: FT5.1-Demonstrate knowledge of features in the operating system FT5.2-Analyze operating system capabilities and restrictions Learning Target: Students will understand differences between operating systems. Students will create a presentation showcasing the capabilities, restrictions and features of the different operating systems.
	Syllabus Due If I do NOT receive a signed syllabus today, you will not be able to complete the following assignments
Monday Sept. 4	No School for Everyone
Tuesday Sept. 5	Operating Systems Mac vs. PC Standards: FT5.1-Demonstrate knowledge of features in the operating system FT5.2-Analyze operating system capabilities and restrictions Learning Target: Students will understand differences between operating systems. Students will create a presentation showcasing the capabilities, restrictions and features of the different operating systems.
Wednesday Sept. 6	Operating Systems Mac vs. PC Standards: FT5.1-Demonstrate knowledge of features in the operating system FT5.2-Analyze operating system capabilities and restrictions Learning Target: Students will understand differences between operating systems. Students will create a presentation showcasing the capabilities, restrictions and features of the different operating systems.
Thursday Sept. 7	PreTest Administered through a computer program called GMetrix Must be made-up if absent or newly transferred. A student account will be created in class.
Friday Sept. 8	PreTest
Monday Sept. 11	Word Chapter 1 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to identify and demonstrate how to format various elements of text.
Tuesday Sept. 12	Word Chapter 1 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to identify and demonstrate how to format various elements of text.
Wednesday Sept. 13	Word Chapter 1 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to identify and demonstrate how to format various elements of text. Assignment: In The Lab #1 Save As: LastName Commodity Trading Flyer Save Location: rm108users Word Chapter 1 folder Picture Location: rm108shared | Classes | Computer Applications | Word | Harvest Adjustments: Step #20--do not update address, instead update "Jansen" of Jansen Investments to your last name
Thursday Sept. 14	Word Chapter 1 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to identify and demonstrate how to format various elements of text. Assignment: In The Lab #1 Save As: LastName Commodity Trading Flyer Save Location: rm108users Word Chapter 1 folder Picture Location: rm108shared | Classes | Computer Applications | Word | Harvest Adjustments: Step #20--do not update address, instead update "Jansen" of Jansen Investments to your last name
Friday Sept. 16	Word Chapter 1 Practice Exam using GMetrix We will go over how the testing mode differs from training mode and it will give you a chance to review!
Monday Sept. 18	Word Chapter 1 Exam using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to identify and demonstrate how to format various elements of text.
Tuesday Sept. 19	Word Chapter 2 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to edit and insert citations, sources, footnotes and header/footer.
Wednesday Sept. 20	Word Chapter 2 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to edit and insert citations, sources, footnotes and header/footer.
Thursday Sept. 21	Word Chapter 2 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to edit and insert citations, sources, footnotes and header/footer.
Friday Sept. 22	Word Chapter 2 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to edit and insert citations, sources, footnotes and header/footer. Assignment: In The Lab #1 Save As: LastName Two-Step Verification Paper Save Location: rm108users Word Chapter 2 folder Adjustments: Step #1--Use your name, our class information and today's date.
Monday Sept. 25	Word Chapter 2 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to edit and insert citations, sources, footnotes and header/footer. Assignment: In The Lab #1 Save As: LastName Two-Step Verification Paper Save Location: rm108users Word Chapter 2 folder Adjustments: Step #1--Use your name, our class information and today's date.
Tuesday Sept. 26	Word Chapter 2 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to edit and insert citations, sources, footnotes and header/footer. Assignment: In The Lab #1 Save As: LastName Two-Step Verification Paper Save Location: rm108users Word Chapter 2 folder Adjustments: Step #1--Use your name, our class information and today's date.
Wednesday Sept. 27	Word Chapter 2 Exam using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.3-Customize document formatting FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to edit and insert citations, sources, footnotes and header/footer.
Thursday Sept. 28	Word Chapter 3 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.2-Use table to enhance documents FT1.3-Customize document formatting FT1.4-Create a mail merge document (extra credit option) FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.
Friday Sept. 29	Word Chapter 3 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.2-Use table to enhance documents FT1.3-Customize document formatting FT1.4-Create a mail merge document (extra credit option) FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.
Monday Oct. 2	Word Chapter 3 Training using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.2-Use table to enhance documents FT1.3-Customize document formatting FT1.4-Create a mail merge document (extra credit option) FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.
Tuesday Oct. 3	Word Chapter 3 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.2-Use table to enhance documents FT1.3-Customize document formatting FT1.4-Create a mail merge document (extra credit option) FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables. Assignment: In The Lab #2 Save As: LastName Rosewood Letter Save Location: rm108users Word Chapter 3 folder Picture Location: rm108shared | Classes | Computer Applications | Word | Rose Adjustments: Step #3--Change only the salutation to your name.
Wednesday Oct. 4	Word Chapter 3 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.2-Use table to enhance documents FT1.3-Customize document formatting FT1.4-Create a mail merge document (extra credit option) FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables. Assignment: In The Lab #2 Save As: LastName Rosewood Letter Save Location: rm108users Word Chapter 3 folder Picture Location: rm108shared | Classes | Computer Applications | Word | Rose Adjustments: Step #3--Change only the salutation to your name.
Thursday Oct. 5	Word Chapter 3 Application Project Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.2-Use table to enhance documents FT1.3-Customize document formatting FT1.4-Create a mail merge document (extra credit option) FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables. Assignment: In The Lab #2 Save As: LastName Rosewood Letter Save Location: rm108users Word Chapter 3 folder Picture Location: rm108shared | Classes | Computer Applications | Word | Rose Adjustments: Step #3--Change only the salutation to your name.
Friday Oct. 6	Word Chapter 3 Exam using GMetrix Standards: FT1.1-Modify and manipulate paragraphs and paragraph formatting FT1.2-Use table to enhance documents FT1.3-Customize document formatting FT1.4-Create a mail merge document (extra credit option) FT1.5-Create and use features of word processing software FT1.6-Format characters FT1.7-Use Help features Learning Target: Students will be able to perform customized document formatting (margins/tabs/etc.), insert/modify shapes and pictures, and create and customize tables.
Monday Oct. 9	No School for Everyone
Tuesday Oct. 10	No School for Students
Wednesday Oct. 11	PowerPoint Chapter 1 Training using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.2-Modify a presentation FT3.4-Add visual elements Learning Target: Students will be able to create a professional presentation using themes, bullets, Word Art, images, visual elements and transitions.
Thursday Oct. 12	PowerPoint Chapter 1 Training using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.2-Modify a presentation FT3.4-Add visual elements Learning Target: Students will be able to create a professional presentation using themes, bullets, Word Art, images, visual elements and transitions.
Friday Oct. 13	PowerPoint Chapter 1 Exam using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.2-Modify a presentation FT3.4-Add visual elements Learning Target: Students will be able to create a professional presentation using themes, bullets, Word Art, images, visual elements and transitions.
Monday Oct. 16	PowerPoint Chapter 2 Training using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.2-Modify a presentation FT3.3-Add visual appeal and animation to a presentation Learning Targets: Students will be able to modify and enhance a professional presentation using themes, Word Art, images, visual elements and transitions. Students will be able to print a presentation using various print options.
Tuesday Oct. 17	PowerPoint Chapter 2 Training using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.2-Modify a presentation FT3.3-Add visual appeal and animation to a presentation Learning Targets: Students will be able to modify and enhance a professional presentation using themes, Word Art, images, visual elements and transitions. Students will be able to print a presentation using various print options.
Wednesday Oct. 18	PowerPoint Chapter 2 Exam using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.2-Modify a presentation FT3.3-Add visual appeal and animation to a presentation Learning Targets: Students will be able to modify and enhance a professional presentation using themes, Word Art, images, visual elements and transitions. Students will be able to print a presentation using various print options.
Thursday Oct. 19	PowerPoint Chapter 3 Training using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.3-Add visual appeal and animation to a presentation FT3.4-Add visual elements FT3.5-Share and present professional presentations Learning Target: Students will be able to customize and enhance a professional presentation using custom slide show settings, images, visual elements, audio and visual elements and animations.
Friday Oct. 20	PowerPoint Chapter 3 Training using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.3-Add visual appeal and animation to a presentation FT3.4-Add visual elements FT3.5-Share and present professional presentations Learning Target: Students will be able to customize and enhance a professional presentation using custom slide show settings, images, visual elements, audio and visual elements and animations.
Monday Oct. 23	PowerPoint Chapter 3 Exam using GMetrix Standards: FT3.1-Create a presentation using presentation software FT3.3-Add visual appeal and animation to a presentation FT3.4-Add visual elements FT3.5-Share and present professional presentations Learning Target: Students will be able to customize and enhance a professional presentation using custom slide show settings, images, visual elements, audio and visual elements and animations.
Tuesday Oct. 24	Search Engines Standards: FT6.1-Demonstrate advanced search techniques within a search engine FT6.2-Analyze different search engines Learning Targets: Students will apply various search techniques while using different search engines to solve an Internet Scavenger Hunt. Students will be able to distinguish and apply key elements of search engines. Assignment: Internet Scavenger Hunt Develop an understanding by reading through the Introduction to Searching PowerPoint Assignment: Internet Scavenger Hunt.docx Save As: LastName Internet Search Save Location: rm108users Search Engines folder Additional Resources: Google Search Modifiers, Understanding/Comparing Different Search Engines, Search Booleans and Restrictors
Wednesday Oct. 25	Search Engines Standards: FT6.1-Demonstrate advanced search techniques within a search engine FT6.2-Analyze different search engines Learning Targets: Students will apply various search techniques while using different search engines to solve an Internet Scavenger Hunt. Students will be able to distinguish and apply key elements of search engines. Assignment: Internet Scavenger Hunt Develop an understanding by reading through the Introduction to Searching PowerPoint Assignment: Internet Scavenger Hunt.docx Save As: LastName Internet Search Save Location: rm108users Search Engines folder Additional Resources: Google Search Modifiers, Understanding/Comparing Different Search Engines, Search Booleans and Restrictors EXTRA CREDIT Assignment: Search Challenge Apply your understanding...Test your new found knowledge! Assignment: Web Search Challenge Use the snipping tool to screenshot each screen when you have the correct answer submitted and paste into a Word document. You may work with a partner. Save As: LastName(s) Web Challenge Save Location: rm108users Search Engines folder
Thursday Oct. 26	Introduction to Digital Citizenship Cyberbullying Video Assignment: Guided Movie Questions Assignment: Guided Movie Questions Assignment Location: Handout located on my desk. Turning in the assignment: You will turn in these questions at the end of the period for safe keeping.
Friday Oct. 27	Introduction to Digital Citizenship Cyberbullying Video Assignment: Guided Movie Questions Assignment: Guided Movie Questions Assignment Location: Handout located on my desk. Turning in the assignment: You will turn in the completed questions at the end of the movie for grading.
Monday Oct. 30	Digital Citizenship Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.1-Create a presentation using presentation software. FT3.3-Add visual appeal and animation to a presentation. FT3.4-Add visual elements to a presentation. FT3.5-Share and present professional presentations. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment Introduction: Digital Citizenship--9 Elements Presentation Assignment: Read through the Project Requirements Select 1 of the 9 Digital Citizenship Elements that you would like to research and present to the class. Find a partner who is also interested in researching the same element. (May be groups of 3 depending on class size.) Remember to pick someone you trust and can work collaboratively with...that isn't always your BFF. Sometimes when choosing friends for partners you tend to spend more time off-task resulting in a lower project grade! Now you and your partner must sign up! No duplicates! Additional Resources: Each of the nine elements has its' own rubric. Please locate the rubric on the shared drive
Tuesday Oct. 31	Digital Citizenship Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.1-Create a presentation using presentation software. FT3.3-Add visual appeal and animation to a presentation. FT3.4-Add visual elements to a presentation. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment Introduction: Digital Citizenship--9 Elements Presentation Assignment: Research your chosen Digital Citizenship Element. Create and design your PowerPoint presentation. Save your URLs to use/reference when creating your bibliography slides. I recommend copying and pasting the URL or citing information into the Notes section of your slide
Wednesday Nov. 1	Digital Citizenship Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.1-Create a presentation using presentation software. FT3.3-Add visual appeal and animation to a presentation. FT3.4-Add visual elements to a presentation. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment: Digital Citizenship--9 Elements Presentation Assignment: Continue researching your chosen Digital Citizenship Element. Continue creating and designing your PowerPoint presentation. Save your URLs to use/reference when creating your bibliography slides. I recommend copying and pasting the URL or citing information into the Notes section of your slide
Thursday Nov. 2	Digital Citizenship Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.1-Create a presentation using presentation software. FT3.3-Add visual appeal and animation to a presentation. FT3.4-Add visual elements to a presentation. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment: Digital Citizenship--9 Elements Presentation Assignment: Finish researching your chosen Digital Citizenship Element and Finish creating and designing your PowerPoint presentation. Save your URLs to use/reference when creating your bibliography slides. I recommend copying and pasting the URL or citing information into the Notes section of your slide
Friday Nov. 3	Digital Citizenship Presentations Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.5-Share and present professional presentations. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment: Assignment: Complete peer evaluation for each group. Assignment Location: Handout located on my desk. Turning in the assignment: You will turn in each completed evaluation at the end of the class period.
Monday Nov. 6	Digital Citizenship Presentations Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.5-Share and present professional presentations. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment: Assignment: Complete peer evaluation for each group. Assignment Location: Handout located on my desk. Turning in the assignment: You will turn in each completed evaluation at the end of the class period.
Tuesday Nov. 7	Digital Citizenship Presentations Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.5-Share and present professional presentations. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment: Assignment: Complete peer evaluation for each group. Assignment Location: Handout located on my desk. Turning in the assignment: You will turn in each completed evaluation at the end of the class period.
Wednesday Nov. 8	Digital Citizenship Presentations Standards: FT9.1-Demonstrate an understanding of the importance of privacy and security within relevant technological tools. FT9.2-Analyze the effect of technology on relationships and communication. FT9.3-Demonstrate the complexity of safe, legal and responsible creation of digital footprints and reputations. FT9.4-Follow ethical and legal guidelines in gathering and using digital information and applications. FT9.5-Effectively decipher reliable information on the web. FT3.5-Share and present professional presentations. Learning Targets: Students will be able to create and deliver a professional presentation. Students will be able to research and ascertain relevant information on a digital citizenship element. Students will develop an improved understanding of each of the nine digital citizenship elements. Assignment: Assignment: Complete peer evaluation for each group. Assignment Location: Handout located on my desk. Turning in the assignment: You will turn in each completed evaluation at the end of the class period.
Thursday Nov. 9	No School for Students
Friday Nov. 10	No School for Everyone
Monday Nov. 13	Excel Chapter 1 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.4-Create charts within a spreadsheet to represent data graphically Learning Target: Students will be able to construct a worksheet using basic formatting and the SUM function.
Tuesday Nov. 14	Excel Chapter 1 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.4-Create charts within a spreadsheet to represent data graphically Learning Target: Students will be able to construct a worksheet using basic formatting and the SUM function.
Wednesday Nov. 15	Excel Chapter 1 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.4-Create charts within a spreadsheet to represent data graphically Learning Target: Students will be able to construct a worksheet using basic formatting and the SUM function.
Thursday Nov. 16	Excel Chapter 1 Application Project Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.4-Create charts within a spreadsheet to represent data graphically Learning Target: Students will be able to construct a worksheet using basic formatting and the SUM function. Assignment: In The Lab #2 Save As: LastName Davis Mobile Concepts Save Location: rm108users Excel Chapter 1 folder Adjustments: See rubric for printing instructions.
Friday Nov. 17	Excel Chapter 1 Application Project Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.4-Create charts within a spreadsheet to represent data graphically Learning Target: Students will be able to construct a worksheet using basic formatting and the SUM function. Assignment: In The Lab #2 Save As: LastName Davis Mobile Concepts Save Location: rm108users Excel Chapter 1 folder Adjustment: See rubric for printing instructions.
Monday Nov. 20	Excel Chapter 1 Exam using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.4-Create charts within a spreadsheet to represent data graphically Learning Target: Students will be able to construct a worksheet using basic formatting and the SUM function.
Tuesday Nov. 21	Excel Chapter 2 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks Learning Target: Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.
Wednesday Nov. 22	No School for Everyone
Thursday Nov. 23	No School for Everyone
Friday Nov. 24	No School for Everyone
Monday Nov. 27	Excel Chapter 2 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks Learning Target: Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.
Tuesday Nov. 28	Excel Chapter 2 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks Learning Target: Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.
Wednesday Nov. 29	Excel Chapter 2 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks Learning Target: Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.
Thursday Nov. 30	Excel Chapter 2 Application Project Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks Learning Target: Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options. Assignment: Apply Your Knowledge Data File Location: rm108shared | Classes | Computer Applications | Excel | Proximity Bus Save As: LastName Proximity Bus Save Location: rm108users Excel Chapter 2 folder Adjustment: Step#6--Enter Name, Class & Period #, Date in the Header area
Friday Dec. 1	Excel Chapter 2 Exam using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks Learning Target: Students will be able to construct formulas, understand and apply MIN, MAX, and AVG functions, identify and apply conditional formatting and produce a print ready worksheet using various print settings/options.
Monday Dec. 4	Excel Chapter 3 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks FT2.4-Create charts within a spreadsheet to represent data graphically Learning Targets: Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions. Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.
Tuesday Dec.5	Excel Chapter 3 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks FT2.4-Create charts within a spreadsheet to represent data graphically Learning Targets: Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions. Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.
Wednesday Dec. 6	Excel Chapter 3 Training using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks FT2.4-Create charts within a spreadsheet to represent data graphically Learning Targets: Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions. Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.
Thursday Dec. 7	Excel Chapter 3 Application Project Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks FT2.4-Create charts within a spreadsheet to represent data graphically Learning Targets: Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions. Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options. Assignment: In the Lab #1 Save As: LastName August Online Technology Save Location: rm108users Excel Chapter 3 folder Adjustments: Step#7--complete the step as listed DO NOT complete Instructions Part 3
Friday Dec. 8	Excel Chapter 3 Application Project Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks FT2.4-Create charts within a spreadsheet to represent data graphically Learning Targets: Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions. Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options. Assignment: In the Lab #1 Save As: LastName August Online Technology Save Location: rm108users Excel Chapter 3 folder Adjustments: Step#7--complete the step as listed DO NOT complete Instructions Part 3
Monday Dec. 11	Excel Chapter 3 Application Project Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks FT2.4-Create charts within a spreadsheet to represent data graphically Learning Targets: Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions. Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options. Assignment: In the Lab #1 Save As: LastName August Online Technology Save Location: rm108users Excel Chapter 3 folder Adjustments: Step#7--complete the step as listed DO NOT complete Instructions Part 3
Tuesday Dec. 12	Excel Chapter 3 Exam using GMetrix Standards: FT2.1-Format a spreadsheet to enhance its appearance FT2.2-Insert formulas into a worksheet to enhance its functionality FT2.3-Manipulate data within and between workbooks FT2.4-Create charts within a spreadsheet to represent data graphically Learning Targets: Students will be able to construct a worksheet with enhanced formatting while utilizing formulas/functions. Students will be able to identify and apply absolute cell references, incorporate Sparklines and produce a print ready worksheet using various print settings/options.
Wednesday Dec. 13	Access Chapter 1 Training using GMetrix Standard: FT7.1-Create a database table Learning Target: Students will be able to construct a database, a table and enter in data.   What is Access?
Thursday Dec. 14	Access Chapter 1 Training using GMetrix Standard: FT7.1-Create a database table Learning Target: Students will be able to construct a database, a table and enter in data.
Friday Dec. 15	Access Chapter 1 Application Project Standard: FT7.1-Create a database table Learning Target: Students will be able to construct a database, a table and enter in data. Assignment: Teacher Lead Activity Save Database As: LastName My Classmates Save Location: rm108users Access folder Instruction Location: rm108shared | Classes | Computer Applications | Access | Access Ch. 1 Intro to Tables
Monday Dec. 18	Access Chapter 1 Application Project Standard: FT7.1-Create a database table Learning Target: Students will be able to construct a database, a table and enter in data. Assignment: Teacher Lead Activity Save Database As: LastName My Classmates Save Location: rm108users Access folder Instruction Location: rm108shared | Classes | Computer Applications | Access | Access Ch. 1 Intro to Tables
Tuesday Dec. 19	Access Chapter 1 Application Project Standard: FT7.1-Create a database table Learning Target: Students will be able to construct a database, a table and enter in data. Assignment: Teacher Lead Activity Save Database As: LastName My Classmates Save Location: rm108users Access folder Instruction Location: rm108shared | Classes | Computer Applications | Access | Access Ch. 1 Intro to Tables
Wednesday Dec. 20	Access Chapter 1 Exam using GMetrix Standard: FT7.1-Create a database table Learning Target: Students will be able to construct a database, a table and enter in data.
Thursday Dec. 21	Access Chapter 2 Training using GMetrix Standards: FT7.1-Perform queries and filter records FT7.4-Create forms in the database FT7.5-Create reports in the database Learning Target: Students will be able to create forms, reports and various queries.
Friday Dec. 22	Access Chapter 2 Training using GMetrix Standards: FT7.1-Perform queries and filter records FT7.4-Create forms in the database FT7.5-Create reports in the database Learning Target: Students will be able to create forms, reports and various queries.
Monday Dec. 25 thru Friday Jan. 5	Winter Holiday
Monday Jan. 8	Access Chapter 2 Training using GMetrix Standards: FT7.1-Perform queries and filter records FT7.4-Create forms in the database FT7.5-Create reports in the database Learning Target: Students will be able to create forms, reports and various queries.
Tuesday Jan. 9	Access Chapter 2 Application Project Standards: FT7.1-Perform queries and filter records FT7.4-Create forms in the database FT7.5-Create reports in the database Students will be able to create forms, reports and various queries. Learning Target: Assignment: Intro to Forms, Reports and Queries Open Database: LastName My Classmates Open Location: rm108users Access folder Instruction Location: rm108shared | Classes | Computer Applications | Access | Access Ch. 2 Intro to Forms, Reports and Queries
Wednesday Jan. 10	Access Chapter 2 Application Project Standards: FT7.1-Perform queries and filter records FT7.4-Create forms in the database FT7.5-Create reports in the database Students will be able to create forms, reports and various queries. Learning Target: Assignment: Intro to Forms, Reports and Queries Open Database: LastName My Classmates Open Location: rm108users Access folder Instruction Location: rm108shared | Classes | Computer Applications | Access | Access Ch. 2 Intro to Forms, Reports and Queries
Thursday Jan. 11	Access Chapter 2 Exam using GMetrix Standards: FT7.1-Perform queries and filter records FT7.4-Create forms in the database FT7.5-Create reports in the database Learning Target: Students will be able to create forms, reports and various queries.
Friday Jan. 12	Review for the final test. Final exam will be administered in GMetrix and covers Word, Excel, Access and PowerPoint.
Monday Jan. 15	No School for Everyone
Tuesday Jan. 16	Period 1    8:15-9:45 Period 3    9:55-11:25 Lunch       11:25-12:35 Period 5    12:40-2:10 Make-up    2:10-3:30
Wednesday Jan. 17	Period 2    8:15-9:45 Period 6    9:55-11:25 Lunch       11:25-12:35 Period 4    12:40-2:10 Make-up    2:10-3:30
Thursday Jan. 18	Period 7    8:15-9:45 Period 8    9:55-11:25
Friday Jan. 19	No School for Students