You can either complete assignments on google classroom or on www.coachlewispe.com to receive credit. You have three assignments each week to complete. I will post the live stream class times in google classroom. I will also upload a recorded video of the weekly lesson on google classroom and on this website. If you have any questions or need help regarding any school or nonrelated school issues, feel free to contact me.
Live stream classes for this week will be Monday, Thursday, and Friday, December 1 to 2 2020. Please check google classroom for live links. The recorded Lesson will be uploaded on Wednesday.
Week 15 Recorded Lesson
Lastly, if you missed anything from last week please go to google classroom and complete the assignments.
You can either complete assignments on google classroom or on www.coachlewispe.com to receive credit. You have three assignments each week to complete. I will post the live stream class times in google classroom. I will also upload a recorded video of the weekly lesson on google classroom and on this website. If you have any questions or need help regarding any school or non-related school issues, feel free to contact me.
You can either complete assignments on google classroom or on www.coachlewispe.com to receive credit. You have three assignments each week to complete. I will post the live stream class times in google classroom. I will also upload a recorded video of the weekly lesson on google classroom and on this website. If you have any questions or need help regarding any school or non-related school issues, feel free to contact me.
Live stream classes for this week will be Monday, Thursday, and Friday, November 16 to 20 2020. Please checkgoogle classroom for live links. The recorded Lesson will be uploaded on Wednesday.
Week 13 Recorded Lesson
Lastly if you missed anything from last week please go to google classroom and complete the assignments.
You can either complete assignments on google classroom or on www.coachlewispe.com to receive credit. You have three assignments each week to complete. I will post the live stream class times in google classroom. I will also upload a recorded video of the weekly lesson on google classroom and on this website. If you have any questions or need help regarding any school or non-related school issues, feel free to contact me.
Live stream classes for this week will be Monday, Thursday, and Friday, November 2 to 6 2020. Please checkgoogle classroom for live links. The recorded Lesson will be uploaded on Wednesday.
Week 12 Recorded Lesson
Lastly if you missed anything from last week please go to google classroom and complete the assignments.
You can either complete assignments on google classroom or on www.coachlewispe.com to receive credit. You have three assignments each week to complete. I will post the live stream class times in google classroom. I will also upload a recorded video of the weekly lesson on google classroom and on this website. If you have any questions or need help regarding any school or non-related school issues, feel free to contact me.
Live stream classes for this week will be Monday, Thursday, and Friday, November 2 to 6 2020. Please checkgoogle classroom for live links. The recorded Lesson will be uploaded on Wednesday.
Week 11 Recorded Lesson
Lastly if you missed anything from last week please go to google classroom and complete the assignments.
CA 3.2.3 Apply word-processing skills by accessing and editing documents, including the effective use of editing commands, i.e., delete, cut/copy/paste, format painter, undo/redo, repeat, and paste special. CA 3.2.2 Apply word-processing formatting skills, i.e., fonts, paragraphing, text flow options (widow/orphan), margins, indentations, page orientation, tabulation, breaks, enumeration, bulleting, borders/shading, columns.
Turn in your travel brochure
Complete CH2 Skills & Apply Your Knowledge 2-1. (AutoCorrect, Cut/copy/paste, Drag & drop, Header/Footer, formatting marks, thesaurus, find & replace, first line indent, document properties, & research task pane.)
CA 3.2.3 Apply word-processing skills by accessing and editing documents, including the effective use of editing commands, i.e., delete, cut/copy/paste, format painter, undo/redo, repeat, and paste special. CA 3.2.2 Apply word-processing formatting skills, i.e., fonts, paragraphing, text flow options (widow/orphan), margins, indentations, page orientation, tabulation, breaks, enumeration, bulleting, borders/shading, columns.
Review columns, column breaks, and margins.
Finish & Submit your travel brochure
Finish your 2-14 Cell Phone Flyer.
Check your Grades in Edmodo.
Submit late work.
For Tomorrow: Click here to Learn Skills from Ch2. (AutoCorrect, Cut/copy/paste, Drag & drop, Header/Footer, formatting marks, thesaurus, find & replace, first line indent, document properties, & research task pane.)
Complete the Apply Your Knowledge on the 3rd page of the file linked above.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
Check EDMODO to see your grades and due dates.
Turn in late work. (weather.docx & Cellphone.docx)
Review columns, column breaks, shading, and square text wrapping.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
CA 3.2.1-Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition. CA 3.2.3-Apply word-processing skills by accessing and editing documents, including the effective use of editing commands, i.e., delete, cut/copy/paste, format painter, undo/redo, repeat, and paste special.
Review Skills
line spacing, margins, Highlghting vs. Shading.
Teach your neighbor how to change the color scheme. The other neighbor should teach you how to change the spacing before and after a paragraph.
CA 3.2.1-Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition. CA 3.2.3-Apply word-processing skills by accessing and editing documents, including the effective use of editing commands, i.e., delete, cut/copy/paste, format painter, undo/redo, repeat, and paste special.
Review line spacing, margins, bullets, Borders, & Shading.
Play Wheel of Terms computer Game.
Check your grades in Edmodo. (Progress Tab)
Submit your Formatting font, & formatting Character files at the same time.
CA 3.2.3 Apply word-processing skills by accessing and editing documents, including the effective use of editing commands, i.e., delete, cut/copy/paste, format painter, undo/redo, repeat, and paste special.
February 4th, 2014 CA 3.2.6 -Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
2 HOUR DELAY
Review, saving, naming, opening, and submitting files.
Review Margins & Line spacing. (Pair & Share – Partner A Should teach the person in your row how to adjust the margins. Partner B should teach the person in their row how to adjust the line spacing.)
CA 1.1.3 -Use the operating system to save files to a hard drive, other drives, and/or a server. CA 1.1.6 -Apply the organizational concept behind using files and folders for storing information and organizing files into folders. CA 1.1.7 Demonstrate saving, opening, and finding files using a variety of different formats.
2 Hour Delay
Review Saving & opening files, file management, and submitting work in Edmodo. Save all files in the computer apps folder. Save file names with a date and description. (1-23 Screenparts.docx)
Finish Labeling Word Screen. Go over as a class. Submit in EDMODO.
Learning the Parts of the screen in Word 2013. Label the parts of the word screen. – Click here to open this file.Using Insert>Shapes> Callouts> label the parts of the Word Screen. Label the following: File, Title Bar, Document Pane, Scroll Bars, Status Bar, Quick Access Toolbar, Tabs, Groups, Ribbon, quick dialog box launcher, view buttons, ruler, Zoom, and the help button. Click for WORD 2013 CHEAT SHEET
IN THE LAB – Creating folders for a video Store. (pg OFF 85)
On your H drive, in the Computer Applications folder, create the folders shown on pg OFF 85. (skip step 1 that mentions a flash drive. We will use our H drive)
Review Terms learned from our Tech Handbook. Play the Wheel of Terms Game
CA 3.2 Students use word processing software through a variety of input technologies to create, edit, and publish industry appropriate documents.
Check to make sure you turned in your Tech Poster in EDMODO. (Reminder ALL assignments close 7 days from the day assigned. NO Exceptions)
Open your Tech questions from yesterday. (They SHOULD be saved in your Capps folder with yesterdays date ) We will finish the groups today) Submit Tech Questions in Edmodo.
Label the following: File Tab, Title Bar, Status Bar, Document Pane, Scroll Bars, Quick Access Toolbar, Tabs, Groups, Ribbon, quick dialog box launcher, view buttons, ruler, Zoom, center button, line and paragraph spacing button, and the help button.
Open EDOMO & SUBMIT your Tech Handbook Poster. To receive an “A,” you need pictures, smartart, Effects, & text must be easy to read.
Briefly meet with group to be sure you know what you are saying and which poster you would like to use. Be sure you address the questions in the file linked below.(7 Min)
CA 1.1.5 Compare and contrast the functional relationship between basic hardware and software systems and their components.CA 1.1.8 Compare and contrast the use of and the difference between temporary memory CA 1.1.9 Compare and contrast the many types of technologies used in society.
TECHNOLOGY HANDBOOK
Open your group with the information on your technology topic. (To receive credit, you must have posted at least 4 posts)
Individually, you will be creating a poster using PowerPoint. This poster should explain your topic. (Be sure your text is large enough to be read.)
Insert a SmartArt Object, change its colors, add information. (Insert>SmartArt)
Insert pictures. (Insert>Picture or copy>Paste)
Insert a title (Insert>WordArt)
Change the background color (Design>Format Background)
This poster should be very informative & include a lot of examples
CA 1.1.1 Select and demonstrate use of industry-standard hardware and emerging technology to complete any given task including academic work, i.e. scanners, digital cameras, digital camcorders, CD/DVDs, keyboard, touch screen, stylus, speech, and handhelds.CA 1.1.5 Compare and contrast the functional relationship between basic hardware and software systems and their components
TECHNOLOGY HANDBOOK TOPICS (Check your Edmodo group for your topic.)
Group 1: What is a computer & Types of Computers
Group 2: How have computers changed the world?
Group 3: Input Devices & Output Devices.
Group 4: Storage Devices/ places (The Cloud, flash drive, etc)
Group 5: The history of the internet
Group 6: How have computers changed throughout the years? When was the first computer built?
Group 7: Staying safe online
Group 8: Netiquette
Group 9: How can one remain ethical when using a computer?
Group 10: Forms of Online Communication.
1. Find your topic by clicking by going to Edmodo and seeing which group you were added to. Use a search engine to find information about your TOPIC. Share what you have found by posting it on your edmodo group. (Min of 4 posts per person to receive credit.) Be sure you have addressed the questions posed in this Tech Handbook Review Sheet.
2. Also gather at least 4 web sites that provide additional information about the topic. Paste them into your edmodo group so that all group members can share. (Minimum of two links per group member.)
3. Tomorrow,you are going to create a poster with pictures, links, & text that further describes your topic using SmartArt in PowerPoint.
REMINDER: All posts should be related to your topic. Any off topic or inappropriate posts will not be tolerated. Misuse of the computer will result in paper pencil assignments.
CA 4.1.2 Use appropriate technology to plan, develop, edit and present material to different types of audiences, i.e., paper, web page, multimedia presentation, publications, speech, hypermedia.Review Web 2.0
FILE MANAGEMENT: Learn how to create folders. Create a computer apps folder on your H drive. (New Folder button) Inside of that folder create a Word folder, PPT folder, & and Excel folder.
WORD CLOUD POSTER
Create your word cloud (Use Tagxedo) and save it to your H drive in your Computer Apps folder.
Open PowerPoint & insert your Word Cloud. (Insert>picture)
Crop your Wordle or Tagxedo. (Double click>choose crop (top right hand corner>drag edges in so they surround your wordle.)
Add images to your word cloud. Paste images on slide, resize, and add effects. (double click to add effects)
Format your background. (For more help view the video at the bottom.)
Save the slide. (file > Save As)
Print Finished product. Office button Print or ctrl+p (Print to the Lexmark so that you poster is in color)
Be sure you write your full name on the wordle & turn in on the black filing cabinet in the back of the room.
Go to typing sites from Wednesday & practice typing when you are finished.
Go to www.wordle.net or http://www.tagxedo.com/ to create a word cloud about you. Include as many words as you can. (At least 20) The words can be things that you like, people that you admire or love, characteristics that define you, hobbies, or more.
In Tagxedo, Click save. In Wordle, snip a picture of the word cloud and Paste it into a PowerPoint slide.
Search Google for images to add to your worlde. Save them in on your H drive or in an email. You need a minimum of 6 images. (right click on the image & choose Save Pictures as)
Your Name & period Full Name:
Parent’s email:
QUESTIONS: 1. Do you have a computer? What do you use a computer for most often?
2. What is your favorite website? (explain)
3. What is one thing that I should know about you?
4. If you could buy whatever you wanted right now, what would it be and why?
5. Favorite Musician
6. A person you admire (why?) When you are finished, click here to practice your typing skills
Move around the room & play other peoples games against one another.
EXCEL FINAL EXAM REVIEW (Complete on your own)Feel free to use your neighbor for help. (If you do not know an answer, 1. look it up, 2. use the help button, 3. ask a neighbor, 4. ask me)
CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
Submit Ms. Orange & your Avatar. (Delete all slides except the slide containing your avatars.
CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
Submit Ms. Orange & your Avatar. (Delete all slides except the slide containing your avatars.
CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
CA 3.5.14- Demonstrate presentation skills by creating well-organized, audience-appropriate presentations such as informative, entertaining, instructional, etc., using proper public speaking techniques CA 3.5.6-Use basic design guidelines to enhance visual presentations. CA 3.5.11-Modify and design templates—master slide, master title slide, master notes, header/footer.CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
CA 3.5.14- Demonstrate presentation skills by creating well-organized, audience-appropriate presentations such as informative, entertaining, instructional, etc., using proper public speaking techniques CA 3.5.6-Use basic design guidelines to enhance visual presentations. CA 3.5.11-Modify and design templates—master slide, master title slide, master notes, header/footer.CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
SUBMIT your slide master & holiday design in Edmodo.
Choose a topic to research & create a “How To” slide show
(How to do a jumping Jack, How to save money, How to curl your hair, etc)
Create your CUSTOM slide master for your how to. It should have graphics that go along with the theme. Be sure you can read your text.
Enter your text first (follow the do’s & don’ts of PPT)
Insert a picture on each slide that demonstrates the steps. (Use a Youtube & the snipping tool to get pictures.)
Add animations & transitions.
Check your grading rubric to be sure you are including all of the requirements.
-You need 3 layouts.
November 22nd, 2013
CA 3.5.6-Use basic design guidelines to enhance visual presentations. CA 3.5.11-Modify and design templates—master slide, master title slide, master notes, header/footer.CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
CA 3.5.6-Use basic design guidelines to enhance visual presentations. CA 3.5.11-Modify and design templates—master slide, master title slide, master notes, header/footer.
Finish cartoon (Advanced Animation)
Review Skills from yesterday & learn how to use the Slide Master.
CA 3.5.6-Use basic design guidelines to enhance visual presentations. CA 3.5.11-Modify and design templates—master slide, master title slide, master notes, header/footer.
Finish cartoon (Advanced Animation)
Review Skills from yesterday & learn how to use the Slide Master.
CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
Finish your cartoon.
– no CLICKS (with or after previous)
– Includes entrance, emphasis, motion path, & exit effects.
– Min of 10 Effects Click to see an example
If you finish early, create a second cartoon or add more detail to it.
You may also go online to find information about your “How To” presentation. Collect pictures and text.
CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
Create a cartoon.
– no CLICKS (with or after previous)
– Includes entrance, emphasis, motion path, & exit effects.
– Min of 10 Effects Click to see an example
CA 3.5.7-Create a presentation with animations, graphics, sound, transitions, embedded objects, specialized features (charts, organizational charts, hyperlinks).
CA 3.5.4- Use appropriate slide layouts and design templates to create presentations. CA 3.5.14- Demonstrate presentation skills by creating well-organized, audience-appropriate presentations such as informative, entertaining, instructional, etc., using proper public speaking techniques
CA 3.5.6-Use basic design guidelines to enhance visual presentations. CA 3.5.14- Demonstrate presentation skills by creating well-organized, audience-appropriate presentations such as informative, entertaining, instructional, etc., using proper public speaking techniques
Have you finished & submitted the PMT assignments? (Cost of Borrowing with PMT questions, & Autotrader)
CA 3.3.4 Apply editing and enhancement features to cell contents, i.e., edit, fill, rotate, move, merge, size, number formats, 3-D references, alignment, auto formats, sorting, row/column setting and formats, styles, borders and colors.
Be sure to check Edmodo to see that you have submitted all work.
Movie Madness, Holiday, & PMT
If you are not finished, complete them now.
CREATE A CALENDAR.
1. Open Excel
2. Go to File >New> Choose Calendar
3. download preferred template (If this does not work for you, then go to http://office.microsoft.com & choose templates, all templates, calendars, 2012 calendars)
4. Plan for the month of DECEMBER
5. Add in holidays, practices, events, and appointments.
6. Add interesting facts and place them on different days
7. Add images.
8. Style the calendar using fill colors, fonts, and borders.
CA 3.3.4 Apply editing and enhancement features to cell contents. CA 3.3.5 Apply page setup features, i.e., margins, headers/footers, page order, grid lines, repeating row/column titles, comments, shrink-to-fit, page orientation, and center horizontally/vertically.CA 3.3.6 Create, insert, modify, position appropriate graphics. CA 3.3.10 Apply and edit functions, i.e. SUM, IF.CA 3.3.13 Create effective charts or graphs which represent relevant data most effectively.
CA 3.3.4 Apply editing and enhancement features to cell contents. CA 3.3.5 Apply page setup features, i.e., margins, headers/footers, page order, grid lines, repeating row/column titles, comments, shrink-to-fit, page orientation, and center horizontally/vertically.CA 3.3.6 Create, insert, modify, position appropriate graphics. CA 3.3.10 Apply and edit functions, i.e. SUM, IF.CA 3.3.13 Create effective charts or graphs which represent relevant data most effectively.
CA 3.3.10 Apply and edit functions, i.e. SUM, MIN, MAX, AVE, COUNT, IF, PMT, NOW, FV, PV. CA 3.3.4 Apply editing and enhancement features to cell contents, i.e., edit, fill, rotate, move, merge, size, number formats, 3-D references, alignment, auto formats, sorting, row/column setting and formats, styles, borders and colors.
Turn in Fastfood. Check Edmodo for any other assignments that are coming due.
CA 3.3.10 Apply and edit functions, i.e. SUM, MIN, MAX, AVE, COUNT, IF, PMT, NOW, FV, PV. CA 3.3.4 Apply editing and enhancement features to cell contents, i.e., edit, fill, rotate, move, merge, size, number formats, 3-D references, alignment, auto formats, sorting, row/column setting and formats, styles, borders and colors.
CA 3.3.12 -Copy, move, and verify accuracy of formulas.CA 3.3.10 – Apply and edit functions, i.e. SUM, MIN, MAX, AVG .CA 3.3.6 Create, insert, modify, position appropriate graphics. CA 3.3.4 -Apply editing and enhancement features to cell contents,CA 3.3.13-Create effective charts or graphs which represent relevant data most effectively.
CA 3.3.12 -Copy, move, and verify accuracy of formulas.CA 3.3.10 – Apply and edit functions, i.e. SUM, MIN, MAX, AVG .CA 3.3.6 Create, insert, modify, position appropriate graphics. CA 3.3.4 -Apply editing and enhancement features to cell contents,CA 3.3.13-Create effective charts or graphs which represent relevant data most effectively.
CA 3.3.10 Apply and edit functions, i.e. SUM, MIN, MAX, AVE, COUNT, IF, PMT, NOW, FV, PV. CA 3.3.9 Create, enter, and edit formulas using arithmetic expressions and math order of operations. CA 3.3.12 Copy, move, and verify accuracy of formulas.
CA 3.3.10 Apply and edit functions, i.e. SUM, MIN, MAX, AVE, COUNT, IF, PMT, NOW, FV, PV. CA 3.3.9 Create, enter, and edit formulas using arithmetic expressions and math order of operations. CA 3.3.12 Copy, move, and verify accuracy of formulas.
CA 3.3.10 Apply and edit functions, i.e. SUM, MIN, MAX, AVE, COUNT, IF, PMT, NOW, FV, PV. CA 3.3.9 Create, enter, and edit formulas using arithmetic expressions and math order of operations.
CA 3.3.13-Create effective charts or graphs which represent relevant data most effectively.
CA 3.3.14 -Edit and label chart components such as axis, legends, titles, etc.
CA 3.3.4 Apply editing and enhancement features to cell contents, i.e., edit, fill, rotate, move, merge, size, number formats, 3-D references, alignment, auto formats, sorting, row/column setting and formats, styles, borders and colors.
Finish & Submit The Excel Screen Parts Assignment
Get back with your partner from the Lemonade stand game.
Open your Lemonade sheet. If you did not get to complete the lemonade game, open the blank data sheet to work with.
Format your sheet using borders & fill colors.
Use wrap text on row 4
Adjust the column & row width to better fit the data.
Learn to delete unused rows. (right click on row header)
Rename Sheet Tab
Learn how to freeze columns
Add border lines(grid lines)
Align Data
Learn how to add a filter & sort columns
Learn to create charts of the data (Insert >chart)
Learn to create charts that will let you compare several columns of data.
Format your charts with colors & titles
Using your charts, analyze your data. Why did you make more money on some days than others?
Check that you have turned in ALL excel files. (Screen Parts)
Play for 15 more days & report back your net profit or loss.
CA 3.3.2 Demonstrate creating, opening, saving, renaming, inserting, deleting, retrieving, and closing a worksheets and workbooks.
Check Edmodo to see that you submitted your Excel Screen parts.
Get with your APA partner. Each partner will be working on a computer.
One partner will be entering data while the other partner will play the game. You may rotate jobs as frequently as you would like.Data Sheet (Open and save this file. One partner should fill this form out while you play)
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
Check EDMODO to see your grades and due dates.
Turn in late work. (weather.docx & Cellphone.docx)
Review columns, column breaks, shading, and square text wrapping.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
Check EDMODO to turn in all work.
Turn in work. (9-24 weather.docx & 9-25 Cellphone.docx)
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
ca 3.3 Students use spreadsheet software to create, edit, and publish industry appropriate files.
Finish your EXCEL FINAL EXAM REVIEW (Complete on your own)Feel free to use your neighbor for help. (If you do not know an answer, 1. look it up, 2. use the help button, 3. ask a neighbor, 4. ask me)
ca 3.3 Students use spreadsheet software to create, edit, and publish industry appropriate files.
Review Access terms
Finish any late Access assignments & submit in Edmodo.
EXCEL FINAL EXAM REVIEW (Complete on your own)Feel free to use your neighbor for help. (If you do not know an answer, 1. look it up, 2. use the help button, 3. ask a neighbor, 4. ask me)
CA 3.4.8 Organize and analyze data, i.e., sorting, identifying, finding, filtering, and viewing. CA 3.4.6 Create a database using multiple tables to establish relationships between tables
CA 3.4.4 Differentiate between and use multiple views. CA 3.4.6 Create a database using multiple tables to establish relationships between tables. CA 3.4.9 Create and use queries to specify criteria such as wildcards, comparison operators (Boolean logic), numeric criteria, compound criteria.
CA 3.4.4 Differentiate between and use multiple views. CA 3.4.6 Create a database using multiple tables to establish relationships between tables. CA 3.4.9 Create and use queries to specify criteria such as wildcards, comparison operators (Boolean logic), numeric criteria, compound criteria.
CA 3.4.1 Define and apply basic terminology associated with database design, creation, and use.CA 3.4.2 Plan, create, and modify a database table structure using design view.CA 3.4.3 Input, edit, and delete data in table.
Open your book to page AC64. Complete Apply your Knowledge.
CA 3.4.1 Define and apply basic terminology associated with database design, creation, and use.CA 3.4.2 Plan, create, and modify a database table structure using design view.CA 3.4.3 Input, edit, and delete data in table.
CA 3.3.12 -Copy, move, and verify accuracy of formulas.CA 3.3.10 – Apply and edit functions, i.e. SUM, MIN, MAX, AVG .CA 3.3.6 Create, insert, modify, position appropriate graphics. CA 3.3.4 -Apply editing and enhancement features to cell contents,CA 3.3.13-Create effective charts or graphs which represent relevant data most effectively.
CA 3.3.4 Apply editing and enhancement features to cell contents, i.e., edit, fill, rotate, move, merge, size, number formats, 3-D references, alignment, auto formats, sorting, row/column setting and formats, styles, borders and colors.
Finish & Submit Excel Label Screen Parts
Get back with your partner from the Lemonade stand game.
Open your Lemonade sheet. If you did not get to complete the lemonade game, open the blank data sheet to work with.
Format your sheet using borders & fill colors.
Use wrap text on row 4
Adjust the column & row width to better fit the data.
Learn to delete unused rows. (right click on row header)
Rename Sheet Tab
Learn how to freeze columns
Add border lines(grid lines)
Align Data
Learn how to add a filter & sort columns
Learn to create charts of the data (Insert >chart)
Learn to create charts that will let you compare several columns of data.
Format your charts with colors & titles
Using your charts, analyze your data. Why did you make more money on some days than others?
Check that you have turned in ALL excel files. (Screen Parts)
Play for 15 more days & report back your net profit or loss.
CA 3.3.2 Demonstrate creating, opening, saving, renaming, inserting, deleting, retrieving, and closing a worksheets and workbooks.
Check Edmodo to see that you submitted your Excel Screen parts.
Get with your Cyberbully partner. Each partner will be working on a computer.
One partner will be entering data while the other partner will play the game. You may rotate jobs as frequently as you would like.Data Sheet (Open and save this file. One partner should fill this form out while you play)
CA 3.2.4 Apply advanced word-processing skills in the creation of tables, including calculations and special features. CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, . CA 3.2.7 Apply the ability to format a variety of documents that meet employability standards. CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
CA 3.2.4 Apply advanced word-processing skills in the creation of tables, including calculations and special features. CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, . CA 3.2.7 Apply the ability to format a variety of documents that meet employability standards. CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
Submit your APA paper in Turnitin.com (Only one partner needs to do this.)
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, . CA 3.2.7 Apply the ability to format a variety of documents that meet employability standards. CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
Submit your paper in Turnitin.com (Only one partner needs to do this.) If you are not finished, finish it at home, before school, after school, during study hall, during lunch, or during study table. I will make contact with the parents of any student who has not submitted their paper in turnitin.com today to let them know what you need to work on over the weekend.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, . CA 3.2.7 Apply the ability to format a variety of documents that meet employability standards. CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
Submit Cyberbully papers
Turn in your APA Cyberbullying reoprt in Edmodo. (This is for your formatting grade)
Submit your paper in Turnitin.com (Only one partner needs to do this.) If you are not finished, fnish it at home, before school, after school, during study hall, during lunch, or during study table.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition. CA 3.2.7 Apply the ability to format a variety of documents that meet employability standards. CA 3.2.6 Apply word-processing graphic object skills such as scale, insert, crop, borders, wrap text, shapes, fill and line options, shading, text boxes, WordArt.
Submit your paper in Turnitin.com (Only one partner needs to do this.) If you are not finished, finish it at home, before school, after school, during study hall, during lunch, or during study table. It is due FRIDAY in turnitin
CA 3.2.5-Apply word-processing skills and style manual usage to cite reference documentation, i.e. bibliography, works cited, footnotes, and endnotes.CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
Submit research sheet in Edmodo. If your partner is submitting it, you need to hit turn in and specify who your partner is.
Submit your Cyberbully paper in Edmodo. This will be graded for formatting only. If your partner submitted it, it turn in and specify who your partner is.
With the partner you were assigned, open your cyberbully paper and all of your research.
CA 3.2.5-Apply word-processing skills and style manual usage to cite reference documentation, i.e. bibliography, works cited, footnotes, and endnotes.CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
With the partner you were assigned, open your cyber bully paper and all of your research.
TODAY: We will finish typing all of the paragraphs and put the paper together.
Partner A – Open your Cyber bully Paper. Partner B- Open the formatting instructions AND Research sheet.
Check that you have cited your sources.
Check that you have a real example in paragraphs 2,3, & 4.
Add all 6 references if you have not already.
Spell check your paper.
E-mail the finished copy of the paper to both partners.
Check your paper for main parts.
Highlight in pink the real examples
Highlight in yellow your in text citations.
Underline your transitions sentences.
If you are missing elements, add them in.
SUBMIT IN TURNITIN.COM
lOGIN OR Create an account.
Class ID: 6173526 Enrollment Key: capps
PARAGRAPH 3:
Key an introduction sentence.
Discuss at least 4 different problems that cyber bullying can cause for the victim or the bully. (Ex: The bully may get charged criminally)
Include at least one specific example of how cyber bullying has caused a problem.
Key a transition sentence that will lead us into our next topic, solutions to cyber bullying.
PARAGRAPH 4:
Key an introduction sentence.
Discuss the best way to prevent cyber bullying.
Mention at least 3 other possible solutions.
Transition to the conclusion.
PARAGRAPH 5 – CONCLUSION
Key an introduction sentence.
Reiterate your main point about cyber bullying, its problems, & its solutions.
Be sure to have a closing sentence that sums up your entire paper. Remind readers what it is that they should have taken from your paper. (What were your main points you were trying to get across?)
CA 3.2.5-Apply word-processing skills and style manual usage to cite reference documentation, i.e. bibliography, works cited, footnotes, and endnotes.CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
With the partner you were assigned, open your cyberbully paper and all of your research.
Partner B- Open the formatting instructions and Research sheet.
Together your will type the first paragraph.
PARAGRAPH 1:
Key an attention getting sentence.
Key several sentences that discuss your 3 main points(Keep it simple & just mention the topics that will be discussed. Save the details for the following paragraphs)
(What is cyber bullying, problem, & solutions).
Key a transition sentence that will transition us into the next topic, what is cyber bullying?
4. Partner A will type paragraph 2 “What is Cyberbullying.” Partner B will type paragraph 3, “problems with cyberbullying. “
CA 3.2.5-Apply word-processing skills and style manual usage to cite reference documentation, i.e. bibliography, works cited, footnotes, and endnotes.CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
With the partner you were assigned, check that your research sheet is complete. You must have the URL’s that go along with your information.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
With the partner you were assigned, research Cyberbullying.
CA 3.2.5 Apply word-processing skills and style manual usage to cite reference documentation, i.e. bibliography, works cited, footnotes, and endnotes.CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
CA 3.2.5 Apply word-processing skills and style manual usage to cite reference documentation, i.e. bibliography, works cited, footnotes, and endnotes.CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or composition.
1. Finish Word review & SUBMIT in Edmodo.
2. EXCEL FINAL EXAM REVIEW (Complete on your own)Feel free to use your neighbor for help. (If you do not know an answer, 1. look it up, 2. use the help button, 3. ask a neighbor, 4. ask me)
The Word review needs to be 100% complete & submitted by Final exam day.
Games & email are not allowed. School is not over yet. I expect everyone to keep working and trying until the end of the year. Anyone who is found on a site that you should not be on, will lose internet privileges.
ACCESS FINAL PROJECT
Open Access & create a blank database.
Name it final-your name
Go to the design view & remove the primary key. (right click on the key & delete)
Choose a topic to create a database about. (Books you own, Clothes, Shoes, Baseball cards, etc)
Add at least 10 fields & adjust the field types as needed.
1.Learn about Citations
2. Open Research Sheet. You need 10 sources. Be sure to paste the URL and list 3 pieces of information for each. Three sources should be for paragraph 2 (What is Cyberbullying?), 3 for paragraph 3(Problems with Cyberbullying), and 3 for paragraph 4 (Solutions to Cyberbullying, and one that is a case study. Be sure to communicate with your partner on your group page in Edmodo.
3. Finish making your works cited page. Be sure to DS and add hanging indents. Submit in Edmodo
MLA report:
1st Paragraph: Introduction
2nd Paragraph: What is Cyberbullying (include a real example & technologies used to bully)
3rd Paragraph: Consequences (of the bully & the victim. include a real example)
4th Paragraph: Prevention Methods (solutions to prevent cyberbullying. Include a real example)
5th paragraph: Conclusion
1. Turn in Charts & Tables Assignments.
2. Review for the test
3. Take Lesson 5 Test
4. If you have late work to finish, do so now. Be sure to submit in Edmodo.
CA3.2.4
1. Finish Travel brochure & turn in. Finish & Turn in weather chart
2. Finish your chart on your own. Add a background color, border, clipart, & WordArt Title. Insert a table with information that you would like to display in a chart. (Ex: Sport scores, Grades, # of awards or nominations etc..) Format your table. Insert a chart the displays the same data. Format your chart using pictures.
3. Complete Interactive Review
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical
documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or
composition.
CA 3.2.3 Apply word-processing skills by accessing and editing documents, including the
effective use of editing commands, i.e., delete, cut/copy/paste, format painter,
undo/redo, repeat, and paste special.
Open your Itunes file. Learn Tab Stops & Character formatting.
On your Own: Hit Ctrl + enter to go to page 2. List the 7 classes you are taking and hit tab between each class ONCE. Hit enter and add an assignment for each class. Use tab stops to line up the class with the assignment.
CA 3.2.1 Apply word-processing skills by creating a variety of business and technical documents, i.e., newsletters, flyers, multi-page reports, using wizards, templates, or
composition.
3. Turn ALL work into Moodle (Especially #’s 23,24, 31, & 33) We are presenting our How to & Cartoon today. Speak loudly so all can here. Explain your cartoon & “How to” when presenting.
Welcome to my website! I hope you will be able to use this site as a resource in my class. I will keep all assignments posted on here. You will also be able to look back at previous assignments if you have been absent. My site has RSS feeds, which allows you to subscribe and receive updates. Feel free to email me with any questions at lajuan.lewis@jefferson.kyschools.us
STUDENT LOGINS- The students will have logins on the school computers. They can access these drives from home.
This page is dedicated to Computer Applications class. Be sure to check here often for assignment information as well as daily class work that was covered. Resources and links to other information given in class, as well as additional assistance, will be posted often. Technology changes rapidly, therefore, it is my goal to share my knowledge with each and every one of you.
Syllabus
The syllabus that we discussed in class today is posted here for your reference. Please remember that it is our goal to accomplish all that is listed, however, there may be unforeseen circumstances where we may not get to everything. I’m excited about the school year and hope that you are as well.