MS Excel Basic (Google Spreadsheets) Training 2015

This is your Introduction to MS Excel (Google Sheets).  Please pay close attention during the class presentation (Click Here to Download Presentation at Home). 
You will be creating a number of spreadsheets over the next few days. 
It is important that you learn to navigate around the spreadsheet as
easily as you do in MS Word (Google Documents).  You will find that most of the RIBBON
items are similar and that you can find out how to do things without my
help by using the HELP Button.



We will be using MS Excel (Google Spreadsheets) to perform Basic Math, create Employee
Timecards, Payroll Worksheets, a Family Monthly Budget, and much more!



Use this link for more information and helpful practice templates:  MS EXCEL PAGE



Are You Really LOST?  Click Here to access GOOGLE SHEETS TRAINING VIDEO



Finally,  you will be using templates that are built-in to the MS Excel
program.  I will add different requirements as we progress.  Good Luck!!



- Mr. S

Springtime Coding Day

Today is a rainy Monday!  I want to make this a stress-free day!  You can work on any of the following items:



1.  Yearbook Project:  Today is the last day for anyone to submit an entry for the yearbook.  Follow the instructions at the following link to see the directions: 



http://caatechnology.blogspot.com/2015/04/yearbook-creation-project-2015-400.html





2.  CodeHS.com:  You can continue to learn to write JavaScript with the introductory lesson on CodeHS.com. You will find instructions for signing up for the class at the following link:



http://caatechnology.blogspot.com/2015/01/codehscom-introduction-signup.html





3.  Microsoft TouchDevelop.com:  Last week you started to work on the introductory lesson for this program.  If you complete all 10 tutorials, you will qualify for a pizza party.  Please make sure you have created an account and started the Learning With Turtle tutorial for credit.  Use the following link for more directions and information:



http://caatechnology.blogspot.com/2015/04/microsoft-research-touchdevelop.html



Tomorrow we will be introducing ourselves to Google Spreadsheets.  Make sure you are ready to learn!  Enjoy your day today!



- Mr. S

Microsoft Research TouchDevelop Application Builder

Today, in addition to completing your Yearbook Project, you will be required to sign up for an account (USE YOUR CAA GMAIL ADDRESS ONLY) on the Microsoft TouchDevelop Website.



Use the link below to create your student account:

TouchDevelop.Com (CS CLASS I Sign Up Link)

Once you have created your account, please verify the account in your Gmail and proceed to the HUB!  This is where you will begin to learn how to read and write CODE!  

Step 1 - Set Your Experience Level:

Click on the box marked Experience Level (right side of HUB screen) and choose BEGINNER

Step 2 - Begin Work:

Click on the "First Steps With Turtle" tutorial and follow all instructions to get the turtle to draw a box.  You will need to add lines of code, making sure to read directions, and use a "button-style" interface to load your commands on each line.  You can use the + sign to add lines of code.

Step 3 - Work on other tutorials on your own.  The first 10 students at Crossroads@Meade to complete all 10 tutorials will receive an invitation to a PIZZA PARTY to be held after they have successfully completed the work.

Bear in mind, you are only going to be graded on signing up for this program and completing the First Steps With Turtle Tutorial.  No other work is required.  If you like this program, send me an email and tell me what you liked about it.  While you progress through the program, you will be able to write those lines of code and move away from the visual-based "blockley" programming, into a more syntax (words) based code.  This is an important transformation!  Eventually you can create games and applications, and you can also move on to more intricate forms of code!

Good Luck!

- Mr. S

Yearbook Creation Project 2015 (400 points)

ACADEMIC/LEARNING OBJECTIVE

Students will use their ability to find, manipulate, edit, and post items to help create a school-wide yearbook.  Students will use creativity and other lessons from digital photography, editing and writing to construct a personal entry for the class yearbook.  Students will have work published both online and in print.

STUDENTS MUST START BY READING ALL DIRECTIONS ON CLASS WEBSITE!

Students will go online to access the TEMPLATE document from the class website.  Students must successfully download and open the Template in Mac Pages.  Students will identify computers in the room that do not have the software installed to create the project.  Students will then access and select photographs and other online content to include in their project.  Students will create a ⅓ page layout about themselves, for entry into the school yearbook project.

Today you will be creating your own 1/3 page for the Crossroads
Yearbook.  Your page section will be copied and listed alphabetically in
our yearbook.  The yearbooks will be printed in color and an electronic color copy will be emailed to everyone and
linked to my website for download.  You can then print and bind additional copies if you like.



Here is a video tutorial I recorded to help you: (Click Link and Watch It)

https://docs.google.com/file/d/0BzY9jTFcLEUWMmQzWkV3VHV3V2s/edit?usp=sharing



Here are some tutorials for you to learn how to use MacWorks Pages:



https://www.youtube.com/watch?v=cYT3ULODKtE

http://manuals.info.apple.com/en_US/Pages09_UserGuide.pdf



http://www.lynda.com/iWork-tutorials/pages-09-essential-training/47996-2.html





When you think you have mastered the software a bit, please click the
link below to download the template.  You will be using any one of the
three outlined spaces to create your page.  Do not resize the background
blocks, but you can change the background color and edge trim. 
Ultimately, the yearbook staff will be editing, proofreading, and
pasting your section into the final draft of the yearbook.



YEARBOOK PAGES TEMPLATE: (CLICK LINK BELOW AND DOWNLOAD)

YEARBOOK TEMPLATE (MAC PAGES TEMPLATE FILE)



Anyone who does not submit this project will have the picture from their
SCHOOL DISTRICT ID used in the yearbook.  Enjoy creating this project!

 Good Luck,



- Mr. S 



Please see the example below for what the yearbook pages will look like:

Technology In The Workplace

ACADEMIC/LEARNING OBJECTIVE

Students will learn to use Google Drive Documents to SHARE information and research about specific technologies that are being created for different jobs.  Students will use investigative and research tools to collaborate with a partner effectively.  Students will present work in class and complete follow-up assignments.

Students will complete the TECHNOLOGY SURVEY online to begin class.  Students will then pair off and investigate specific technology that is used in different industries.  Students will present findings at the end of the class and then begin work on a Google Project to Document their findings.  The Google Document must be Named and Shared Correctly For Credit!

Workplace Awareness Of Technology

Please complete the survey below to begin class (CLICK LINK BELOW):

https://docs.google.com/forms/d/1ElzfbqEnsLrBCXpq0-xEaH_DST9BK_HBHgN8beWOB6g/viewform?usp=send_form

Today we will be viewing the video "Technology In The Workplace". 

Once we have discussed the video above, you and a partner will spend some time investigating specific technology that is used in the fields listed below.  You will use your research skills to help each other find at least one type of specific technology used in your career field.  You must describe the technology, tell how it was created, and what people in your career did before it existed.  You will report to the class after spending time looking for it.  You and your partner must create a Google Document together (SHARED WITH EACH OTHER AND ME FOR CREDIT) about your career field and technology.  We will share out in class today.  You must finish the project today for credit!

PRIOR TO APRIL 13th, You will complete the project below as a followup to this lesson:

For this assignment you are to COMPOSE and email to me.  Topic
Assignments are at the bottom of this post.  In the SUBJECT LINE you are
to put the following:  HELP WANTED ASSIGNMENT / INDUSTRY TECHNOLOGY
RESEARCH (Industry)



In the body of the email you should have the following items before SENDING:



1.  Describe some type of technology (hardware or software) that is used
by someone who has a job in the Industry that was assigned to you. 
Describe what the technology is, how it works, and who would use it. 
You must also specify where you found your information. (Cite a source) 
Describe how the technology, device or other type of equipment or
software helps make the job easier and how it was different 20-40 years
ago in the same industry.  Be specific.



2.  List three types of jobs in the Industry you were assigned. 
Describe the Job Requirements of each job and what training you might
need to have to hold the job.  Include the Salary Range information for a
person with these jobs.



3.  Finally,  create or find a Help Wanted Advertisement for a job in the
Industry you were assigned.  Use the template from the post prior to
this and make sure to eliminate the parenthesis as you enter your
information as they are only there to guide you.  Attention to detail,
neatness, and creativity will be critical.



Here is an example of what your email should look like:



TO:  hescribnercaa@gmail.com



SUBJECT:  HELP WANTED ASSIGNMENT / INDUSTRY TECHNOLOGY RESEARCH (Education)



1.  Technology Requirement

SmartBoards
are now used in many classrooms across the country.  In the last 10-15
years they have replaced standard chalk boards and white boards. 
SmartBoards and similar products offer a computer-based interactive
resource for teachers to make lessons "come to life!"  Students can
interact with video and audio supported presentations and work at the
board.  They can also be a tremendous help for the teacher to work
interactively on problems and grammar exercises. "Students
of all ages love the SMART Board because it is interactive and
interlinked with computer software"  according to an article on
wikibooks.org.



(http://en.wikibooks.org/wiki/Technology_Integration_In_K12_Education/SmartBoards_vs_White_Boards_in_the_Elementary_Classroom)



2.  Jobs and Descriptions

Educational Administrator:  Principal/Asst. Principal of a school.  Usually the person in charge of running the school and deciding what the budget is spent on during a given year.  Approx. $80k per year salary.



Teacher:  Usually in charge of the specific instruction to a group of students at a school.  Must be able to utilize many instructional tools and technologies.  Approx.  $45k per year salary to start.



Teaching Coach:  In charge of managing training for a school district.  Makes sure that people in both administration and teaching are up to date on training, best practices, and other technology advancements in the industry.



2.  Help Wanted Advertisement School District of Philadelphia,  Crossroads at Elverson

Position:  Technology Teacher

Salary:  $45k per year to start

Start Date:  Immediately

Must be able to use both Windows and Apple based computers.  Must be proficient with MS Office, Google Applications, Online Applications, Basic Programming, Graphic Design and other software.  Must have good Classroom Management skills and be confident and interested in helping students achieve in a high academic standards environment.  Must be willing to work long hours and stay for Parent-Teacher conferences.  Experience with SmartBoards is a plus.



Please possess a Bachelor's Degree, PA State Teaching Certification, and include any additional training or classwork you have completed.  Special skills are public speaking, organization and paperwork management, and the ability to control over one hundred students in a crowded lunch room.





This is where you save your work, pat yourself on the back for following directions, and hit SEND to submit your project to me for a grade.  Good Luck!          -Mr S. 



TOPIC ASSIGNMENTS:  The computer/seat number you are assigned to corresponds with the following topic/industry that you are responsible for:

1. Advertising & Marketing


2. Airlines, Hotel & Travel


3. Apparel, Textiles & Fashion


4. Automobiles & Trucks


5. Banking


6. Biotechnical


7. Careers & Employment 


8. Cell Telephone


9. Chemical, Coatings & Plastics


10. Computer Support


11. Consulting, Outsourcing & Offshoring


12. Construction


13. E-Commerce & Internet


14. Energy, Utilities, Oil & Gas


15. Engineering, Research & Developing


16. Entertainment & Media


17. Food, Beverage & Tobacco


18. Health Care & Pharmaceutical


19. Investments & Securities (Financial)


20. Retailing


21. Sports Industry


22. Telecommunications, Wireless Communication


23. Transportation


24. Military