Office Tech - Lesson-8
Welcome!
Now lets log-on to http://www.edutyping.com/ and get started.
1--In the upper-right corner of the screen, click on the orange/yellow button that says "STUDENT".
2--Enter the License ID - "lindho500"
3--Enter your Username .
4--Enter your Password
Weekly Progress: By the end of the week, you should be done with the 16th activity (1-15 Review) - due by end of the day on Friday.
Cursive Signature Practice
Please open the blank page shown below in Notability. Pick your favorite pen color and then write your first and last name in cursive ten (10) times.
VIDEO - CREATING A CHART or GRAPH IN EXCEL
Check out this 3+ minute video to see how to QUICKLY create a chart or graph in Excel.
Use your headphones or earbuds please!
Want to see a shorter version? A simpler version? Check out this video.
MICROSOFT EXCEL Practice Charts & Graphs
Today we will make some simple charts and graphs in Excel. We surveyed 100 people and asked them what is their FAVORITE Fruit. We had many responses, and when all of the data was collected, we made two charts/graphs to display our data.
Your job is to re-create this in Excel. Open this Excel Document Printout on your iPad or this Screenshot, and set it next to your monitor so you can see both at the same time. Type the data into a new Excel Worksheet. Be sure to save your file as "Fruit Survey--your first & last name"
Once all of your data is entered, create charts as shown in the example. Format the font as shown in the example. When your file is complete, it should look almost EXACTLY like the printout file on your iPad. When you finish, save your work and move on to the next section.
MICROSOFT EXCEL Project #2 Sports Stats with Graph
For this project, you will research player statistics and record them in a spreadsheet. You can choose from baseball, Football, Basketball, Hockey, or Soccer. Please make sure that the players you choose are similar in position and stats. Example--if you choose baseball, please record stats for 12 Pitchers, or 12 Outfielders. Do NOT choose 6 Pitchers and 6 Outfielders....their stats won't match up well. Questions on this? Ask Mr. P.
For complete details on how to complete this assignment, please see the info sheet below:
Excel Sports Project Info Sheet
Deadline is Friday April 12th, 2019. Be sure to save your work early and often!
Turn in to Google Classroom when completed. Make sure to have your first and last name in the filename.
ALL FINISHED?
THEN.....Check out these cool typing games to help you practice:
A Friendly Reminder......
About Microsoft Office and SAVING on a PC as opposed to Google Docs/Drive....
Organization and Folders are always a good idea
You have a Home Directory/Drive, known as your H: Drive
Your H: Drive starts with your last name or User ID
Your H: Drive is where we will save all of your work
You must SAVE your work, it will NOT automatically save for you
Microsoft Word is similar to Google Docs, but has many more features and advanced tools
You can upload files from your H: Drive to your Google Drive and you can download files from your Google Drive to your H: Drive. It works both ways
Don't forget to save. If you do forget, no crying or whining, simply re-do the work.
Homework = edutype if you are behind. Enjoy the rest of your day! Stay on-top of your deadlines!