College Computer Applications
-
Welcome to College Computer Applications!Day 77 - 82
- Your FINAL PROJECT is linked here.
- Scroll to the bottom of the linked page, and open the file.
- Save the file as lastname_FINAL_Rubric in the folder you created for your Final Project files.
- Please read the project rubric from top to bottom again and grade yourself as you go. Feel free to use highlighting or other tools to track your progress.
- Don't miss the easy points!!
- Comment with your Blog info on this FINAL Project Blog Post.
- Done with your FINAL Project?
- Make updates and check for new Posts from others on the Blog-a-Difference Project. [a June Post is required ... make it your best]
- Hand in your Database Project.
- Take some time to review some of the things you hopefully learned this year. If not, learn them now ... :)
Day 73 - 76-
Print the My Database Project.
- I like TED Talks ... check this out ... I'll bet this is something you hadn't considered.
Day 72-
Work to finish your Database Project today.
-
Take the Self-evaluation seriously.
- The FINAL PROJECT will start next class.
Day 64-65-
Team IT Presentation Project [due 4/11] PRESENTATION and Quizzes TODAY
- Peer Sharing Blog for IT Presentations
- Open you Google Slides.
- Go to File - Publish to Web.
- Copy the URL for your presentation.
- Example: https://docs.google.com/presentation/d/15gw8Ost_FWdJR0ETbCq1RxqwaSLgNonE4180054aGL4/pub?start=false&loop=false&delayms=3000
- Paste it into a comment on this IT Team Presentations - Peer Sharing Blog Post.
- Important - ask a neighbor, NOT on your team, to open the link. This will only work if you shared it publicly and properly. Otherwise, future students will not be able to open your presentation and see your work, which would be a waste. Your work is for future students to learn from.
- You will record yourself using the SWIVL device (and iPad). Here is a sample and test of me using it.
- Project Topics and Guidelines (for reference, your choices are below)
- Trevor - Programming Concepts and Data Management
- Matt and Jordan S. - Software and Business Applications
- Zach G.and Mike H. - Manufacturing
- Mike W. - Art and Advertising
- Caitlin and Andrew - Processing & Hardware Devices
- Anne and Jordan L. - Ethical Challenges
- Tim - Manufacturing
- Jacob - Software and Business Applications
- Zach L. - Manufacturing
- Team Members and Presentation Dates
- Print the rubric (self-evaluate) and evidence (print screen) of your posts.
- Start the DATABASES Lessons
Day 60-63-
Team IT Presentation Project [due 4/11]
- Project Topics and Guidelines (for reference, your choices are below)
- Trevor - Programming Concepts and Data Management
- Matt and Jordan S. - Software and Business Applications
- Zach G.and Mike H. - Manufacturing
- Mike W. - Art and Advertising
- Caitlin and Andrew - Processing & Hardware Devices
- Anne and Jordan L. - Ethical Challenges
- Tim - Manufacturing
- Jacob - Software and Business Applications
- Zach L. - Manufacturing
- IT Presentation Rubric
- Completely done and printed on due date or minus 10 per day. [100 point]
- Status Check Grade [20 point max] - must show me today
- 20 = all team members have made substantial contributions, research document is shared is sufficient to start presentation which is also shared
- 15 = weak research, all members helped, files shared
- 10 = incomplete team work and research to start presentation
- 5 = no evidence of research just started presentation, pace is weak.
- 0 = did not start = you're fired
- Team Members and Presentation Dates
-
Blog-a-Difference Project. [due weekly]
- Create 1 good post and leave a few solid comments weekly to remain on pace for a 100%. (you can catch up or get ahead)
- Ready to present and already Blogged? .....
- Explore the DATABASES Lessons
Day 54-59-
Blog-a-Difference Project. [due weekly]
- Create 1 good post and leave a few solid comments weekly.
- Checking for a grade today. Evidence of your effort since January 1st.
- Post quantity = 10 points/post.
- Comments left by you on others = 2 pts./comment
- Comments by others on yours = 2 pts./comment
- Maximum points = 50 (show me today)
-
Team IT Presentation Project
- Project Topics and Guidelines
- IT Presentation Rubric
- Team Members and Presentation Dates
Day 50-53-
Choose 2 of these 4 Excel Projects [due 3/15]
-
Floor Plan Project - Follow the instruction on the Graphic Design page. [due 4/8]
- Blog-a-Difference Project. [due weekly]
- Create 1 good post and leave a few solid comments weekly.
-
Excel Quizzes Review
- Follow this Link to the Spreadsheets page.
- Team IT Presentation Project
- Project Topics and Guidelines
- IT Presentation Rubric
- Team Members and Presentation Dates
Day 49 (Mr. Turton is out, choose your tasks and get busy)- Blog-a-Difference Project. [due weekly]
- Create 1 good post and leave a few solid comments weekly.
-
Excel Quizzes Review
- Follow this Link to the Spreadsheets page.
-
Choose 2 of these 4 Excel Projects [due 3/15]
-
Floor Plan Project - Follow the instruction on the Graphic Design page. [due 4/8]
Day 44-48 (Mr. Turton is out, choose your tasks and get busy)-
Excel Quizzes are here TODAY.
- You will benefit from any time and practice you spent on the skills and tutorials suggested in the previous weeks of class.
- You need to have at least one seat between you and the next closest student.
- These are NOT team quizzes. No sharing of ideas and stay quiet.
- You may use the internet to find tutorials, You Tube videos, and anything else to complete the quizzes. But, no internet chatting with classmates.
- The HELP feature within Excel is very handy.
- Follow this Link to the Spreadsheets page.
- Scroll to the bottom of the page and Open Excel Quiz
- Save it on your H:drive in for College Computer Apps folder.
- You only have today to complete Quiz A. [due 2/3]
- Complete Quiz B on Wednesday. Do not start it in advance.
-
Future Projects are below IF you finish the Quiz early.
-
Choose 2 of these 4 Excel Projects [due 3/15]
-
Blog-a-Difference Project. . [due weekly]
- Create 1 good post and leave a few solid comments weekly.
- Floor Plan Project - Follow the instruction on the Graphic Design page. [due 4/8]
Day 40-44-
Choose 2 of these 4 Excel Projects
-
Measurement Project - using Excel, a tape measure, and a caliper.[due 1/25]
- Team IT Presentation Project - Presentation Dates [due 1/25 - last team]
- Blog-a-Difference Project. . [due weekly]
- Create 1 good post and leave a few solid comments.
- Excel Quizzes are coming soon.
- You need to know:
- cell borders and shading
- sorting columns of data by multiple criteria
- adjusting cell formats (decimals showing, date, alignments)
- cell merging and text wrapping
- headers (auto insert date, file name and location)
- printing to one page and moving page breaks
- inserting columns and rows
- creating formulas (average, minimum, range, maximum, standard deviation, and search for others common mathematical functions)
- charts (formatting axis and titles, changing chart styles, adding or removing data)
- Sooo ... use the Atomic Learning Tutorials to refresh your skills
- This is a library of Software Applications Tutorials presented in an Video format. Our access to this site is paid for by Alden Central Schools. (user: aldenstudents, pass: bulldogs)
- This takes time. I suggest splitting your screen between the tutorial and Excel to allow you to try the new skills as they are demonstrated.
Day 36-39-
Show me your video comment from last class if you did not already.
-
Measurement Project - using Excel, a tape measure, and a caliper.
- Children's Book Project
- This is happening on 1/14. Please get/return your permission slip.
- Team IT Presentation Project
- Project Topics and Guidelines
- IT Presentation Rubric
- Team Members and Presentation Dates
- Blog-a-Difference Project. . [due weekly]
- Create 1 good post and leave a few solid comments.
- Excel Quizzes are coming on 1/8/16.
- You need to know:
- cell borders and shading
- sorting columns of data by multiple criteria
- adjusting cell formats (decimals showing, date, alignments)
- cell merging and text wrapping
- headers (auto insert date, file name and location)
- printing to one page and moving page breaks
- inserting columns and rows
- creating formulas (average, minimum, range, maximum, standard deviation, and search for others common mathematical functions)
- charts (formatting axis and titles, changing chart styles, adding or removing data)
- Sooo ... use the Atomic Learning Tutorials to refresh your skills
- This is a library of Software Applications Tutorials presented in an Video format. Our access to this site is paid for by Alden Central Schools. (user: aldenstudents, pass: bulldogs)
- This takes time. I suggest splitting your screen between the tutorial and Excel to allow you to try the new skills as they are demonstrated.
Day 31-35-
Check out this NEW video for our various Alden High School elective areas. Scroll down to see the videos and let me know if you think our 8th graders will be getting a better idea what to expect.
- HS Elective Quiz ... +5 point quiz ... leave a positive comment offering insight to future students for a course in one of the elective areas. Just show me the comment when approved. due 1/6/2015
- Children's Book Project
- You completed/printed book and rubric should be in the envelope on my desk.
- Team IT Presentation Project
- Begin working on this with your teammate.
- This time, you may use Google DRIVE instead of Wiki spaces.
- Make a folder titled DA103-topic-membernames.
- Project Topics and Guidelines
- IT Presentation Rubric
- Team Members and Presentation Dates
- HINT - Get ideas from Past Student Presentation on this IT Peer Sharing Blog.
- Blog-a-Difference Project. . [due weekly]
- Create 1 good post and leave a few solid comments.
- Excel Quizzes are coming on 1/4/16 and 1/8/16.
- You need to know:
- cell borders and shading
- sorting columns of data by multiple criteria
- adjusting cell formats (decimals showing, date, alignments)
- cell merging and text wrapping
- headers (auto insert date, file name and location)
- printing to one page and moving page breaks
- inserting columns and rows
- creating formulas (average, minimum, range, maximum, standard deviation, and search for others common mathematical functions)
- charts (formatting axis and titles, changing chart styles, adding or removing data)
- Sooo ... use the Atomic Learning Tutorials to refresh your skills
- This is a library of Software Applications Tutorials presented in an Video format. Our access to this site is paid for by Alden Central Schools. (user: aldenstudents, pass: bulldogs)
- This takes time. I suggest splitting your screen between the tutorial and Excel to allow you to try the new skills as they are demonstrated.
- Measurement Project - using Excel, a tape measure, and a caliper.
Day 27-30- Children's Book Project
- You should attempt to print your book today.
- I taught Caitlin how to review and print. She taught Matt. Keep the chain going.
- Team IT Presentation Project
- Choose a new Team, Topic, and date prior to 1/11.
- Find a partner that you have not worked with yet.
- Or you will work alone and be assigned a topic at Mr. Turton's discretion.
- Choose a topic that is new to you.
- Project Topics and Guidelines
- IT Presentation Rubric
- Team Members and Presentation Dates
- Blog-a-Difference Project. . [due weekly]
- Create 1 good post and leave a few solid comments.
Days 24-26
- Scratch - Object Oriented Programming
- Check out this Scratch page and get started if you have some time. Explore the tutorials before you get too involved. YOU NEED TO READ AND WATCH THESE!!
- I encourage you to check out games created by others to see what you are capable of with Scratch.
- Create an account an you can access it at home after you download it for free. This way, you can make progress at home if you need/want to.
- Check out Project - Beach Ball and get started. [due 11/9]
- Add your project link in the comments on this Beach Ball Post.
- Choose Project - Story Teller or Project - Video Game. [due 11/15]
- Link your Scratch Project on my Creative Programming Blog Post.
- Check out some from last semester's students.
- Be sure you add tags for your "lastname", "turton", and "Alden"
- Here are some Student Projects from 2011.
- Blog-a-Difference Project. .... plan for 1 good post and leave a few solid comments. [due weekly]
- If you already left a comment, please do it again. I had the wrong hyperlink here before.
- Project - Thank You Letter (due 11/19)
- Children's Book Project
- This link has the 1st grade sight words you should use.
- Excel - Social Impact - Data Analysis Project - coming soon
Days 19-23
- GRADES ARE CLOSING
- Last Days to present your IT . Make it happen.
- Topic B - [Memory and Storage Devices] - Anne and Tim 10/27
- Topic G. - [Key Innovators] - Mike, Jordan L, Jacob M. - complete
- Topic I [Art and Advertising] - Caitlin, Mike, Zach G. 10/29
- Topic J. [Manufacturing] - Matt, Jordan S., the Lopes 11/2
- Topic M. [Programming and Data Mngmt] - Trevor, Andrew 11/4
- Fix your Karel Project for a re-grade if you want and present it if you have not already.
- Open your Karel Writes a Word files so I can verify you included the "Define-new-instruction" part of the rubric. TODAY.
- Scratch - Object Oriented Programming (this is new).
- Check out this Scratch page and get started if you have some time. Explore the tutorials before you get too involved. YOU NEED TO READ AND WATCH THESE!!
- I encourage you to check out games created by others to see what you are capable of with Scratch.
- Create an account an you can access it at home after you download it for free. This way, you can make progress at home if you need/want to.
- Check out Project - Beach Ball and get started. [due 11/9]
- Choose Project - Story Teller or Project - Video Game. [due 11/15]
- Link your Scratch Project on my Creative Programming Blog Post.
- Check out some from last semester's students.
- Be sure you add tags for your "lastname", "turton", and "Alden"
- Here are some Student Projects from 2011.
Days 17-18
- Wrap up your IT Presentation and get things printed.
- Fix your Karel Project for a re-grade if you want.
- Open your Karel Writes a Word files so I can verify you included the "Define-new-instruction" part of the rubric.
- Scratch - Object Oriented Programming (this is new).
- Check out this Scratch page and get started if you have some time. Explore the tutorials before you get too involved.
- I encourage you to check out games created by others to see what you are capable of with Scratch.
- Create an account an you can access it at home after you download it for free. This way, you can make progress at home if you need/want to.
- Check out Project - Beach Ball and get started. [due 11/9]
- Choose Project - Story Teller or Project - Video Game. [due 11/15]
- Link your Scratch Project on my Creative Programming Blog Post.
- Check out some from last semester's students.
- Be sure you add tags for your "lastname", "turton", and "Alden"
- Here are some Student Projects from 2011.
Day 16- I am in a meeting today.
- You all have major work to do from days 08 and 09.
- Students who are reported as being distracting to others will spend time with me after school.
- Look at the Karel Project and Quiz due dates.
- Review the rubrics ASAP.
- Get what you have completed printed.
- Do not wait until the last minute
Day 12 - 15- Team IT Presentation Project - choose a new Team, Topic, and date prior to 10/31.
- Project Topics and Guidelines
- IT Presentation Rubric
- Team Members and Presentation Dates
- Blog-a-Difference Project. . [due weekly]
- Create 1 good post and leave a few solid comments.
- Meet KAREL the ROBOT
- Read the Karel Programming Intro Page. See the links on the left too. :)
- This is a Project that you will complete with Karel as your only partner. [due 10/09]
- Here is your Karel Programming Quiz. [due 10/09]
- Let's get CODING
- Follow this link to my CODING Projects page.
- We are going to work toward completing this 20 hour coding course.
- Login at www.code.org and then select our class and Section Code: UHOKUF.
- Get started. (due 10/30)
Day 09 - 11- Check your presentation date for your IT Team Presentation.
- Blog-a-Difference Project. .... plan for 1 good post and leave a few solid comments. [due weekly]
- If you already left a comment, please do it again. I had the wrong hyperlink here before. You can copy from my 2014-2015 Blog if that is where you pasted it during a prior class.
- Meet KAREL the ROBOT
- Read the Karel Programming Intro Page. See the links on the left too. :)
- This is a Project that you will complete with Karel as your only partner. [due 10/02]
- Here is your Karel Programming Quiz. [due 10/02]
- 3D Modeling - Computer Aided Drafting [due much later]
- See the World's First 3D Printed Car - follow link. Or is it?
- A little distraction - CAD (Computer Aided Drafting) follow this link and ask me questions.
- Check out Thingiverse from Makerbot for inspiration.
Day 06 - 08
- Blog-a-Difference Project
- Follow this link to the Blog-a-Difference Project and read the instructions.
- You will need to log in with your Google account.
- Team IT Presentation Project
- Project Topics and Guidelines
- IT Presentation Rubric
- Team Members and Presentation Dates
- Quizzes - just be sure you did them and your grade in the portal is correct. See earlier days.
- 21st Skills
- 365 Email
- Kahn Academy
Day 02 - 04- Revisit Day01 and complete anything you did not get to.
- ECC Registration must be postmarked by 2/12. (Be sure I get a copy if you mail it yourself.)
- Registration needs to be sent this week or you lose the opportunity.
- DA106 - MicroComputer Apps - 3 credits.
- DA103 - Intro to Info Tech - 4 credits.
- Make sure it is signed and MAIL IT by 2/12, but show me first. I actually like to send them all in together.
- Team IT Presentation
- Check out the guidelines and topics linked above then look at this IT Presentation Rubric (subpage). This stuff is linked at the left too.
- Choose 2 partners that are not sitting next to you.
- Choose a presentation date within the next 4 weeks.
- Let me know you team, topic, and date - first come first choice. I would like to have a day between presentations. We will add the teams and presentation dates to my site for reference.
- Go to www.wikispaces.com and create an account for K-12 Education - very important.
- Develop your info on your wiki. Use the sites I recommend for info and find new ones too.
- Share your wiki with me at aturton@aldenschools.org.
- Begin your research and collect the info on your team's wiki. Do not start the Google presentation until I approve your wiki completion.
-
Tips
-
exchange emails with your team members ASAP
-
one person creates a Wiki for the Project
-
give it a title like DA103-Team Topic
-
you all collect your research AND sources in the wiki (think bibliography with APA or MLA Format via www.easybib.com)
-
create an outline for your presentation. Use multiple wiki pages.
-
Check this old Blog of mine for sample IT presentations.
-
And these are some from last semester IT Team Presentation Peer Sharing Blog.
-
- Quiz 2 - Self Interest with Kahn Academy.
- The Kahn Academy Tutorials cover a huge range of content. Take time to search something interesting or that related to a course you are taking (History, Econmics, Calculus, ...)
- Try to complete the quiz today or tomorrow.
Day 01- Quiz - 21st Century Survival Skills (10 point quiz grade)
- Yep - a quiz on day 1. Don't worry it's easy.
- Project - Google Doc Intro
- Create a Google doc titled "DA103-lastname-intro".
- Answer the following questions in complete sentences with enough detail for a college level course:
- What career area do you hope to get into after high school graduation?
- What are you doing this year to see if that is the right career path for you?
- Which high school course has been most beneficial to you so far?
- Tell me something unique about you and your interests.
- Share this doc with me at aturton@aldenschools.org.
- Quiz - "Business Email to the Man" (10 point quiz grade)
- Log in to Office 365 from the district homepage and send me an email aturton@aldenschools.org.
- Copy the text from your "DA103-lastname-intro" google doc and paste it into the email.
- Format your email properly after reading these tips for a proper business email.
- Add "Dear Mr. Turton" as a salutation.
-
- Use your other info about yourself to complete the email.
- Send it to me. Thanks.
Course Learning Standards
ISTE Standards - International Society for Technology in Education
- Creativity and innovation
Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology.
- Apply existing knowledge to generate new ideas, products, or processes
- Create original works as a means of personal or group expression
- Use models and simulations to explore complex systems and issues
- Identify trends and forecast possibilities
- Communication and collaboration
Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others.
- Interact, collaborate, and publish with peers, experts, or others employing a variety of digital environments and media
- Communicate information and ideas effectively to multiple audiences in a variety of media formats
- Develop cultural understanding and global awareness by engaging with learners of other cultures
- Contribute to project teams to produce original works or solve problems
- Research and information fluency
Students apply digital tools to gather, evaluate, and use information.
- Plan strategies to guide inquiry
- Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media
- Evaluate and select information sources and digital tools based on the appropriateness to tasks
- Process data and report results
- Critical thinking, problem solving, and decision making
Students use critical thinking skills to plan and conduct research, manage projects, solve problems, and make informed decisions using appropriate digital tools and resources.
- Identify and define authentic problems and significant questions for investigation
- Plan and manage activities to develop a solution or complete a project
- Collect and analyze data to identify solutions and/or make informed decisions
- Use multiple processes and diverse perspectives to explore alternative solutions
- Digital citizenship
Students understand human, cultural, and societal issues related to technology and practice legal and ethical behavior.
- Advocate and practice safe, legal, and responsible use of information and technology
- Exhibit a positive attitude toward using technology that supports collaboration, learning, and productivity
- Demonstrate personal responsibility for lifelong learning
- Exhibit leadership for digital citizenship
- Technology operations and concepts
Students demonstrate a sound understanding of technology concepts, systems, and operations.
- Understand and use technology systems
- Select and use applications effectively and productively
- Troubleshoot systems and applications
- Transfer current knowledge to learning of new technologies
ECC Students:
- Go to www.ecc.edu and attempt to log into your Angel account [click Angel under Hot Links]. Follow the directions on the site. If you do not know your social security number, ask a parent and try to log in at home. I will help you work through obstacles during next class if necessary.
- Most of you will see DA103 and/or DA106. ECC is still in the process of setting our class up. But the sooner we work through the challenges, the sooner we will be able to incorporate Angel features into our course.
- Bills will be mailed next week and they will be due by the end of October. If a student does not receive a bill or has ECC Billing Questions have them call Ann Vertino 851-1897 or email vertino@ecc.edu
- Some things to consider ... I think you will need to copy the link and paste it in a new tab.
- Major discount for Microsoft Software for ECC students like you. Check out this link ...
[http://ubmicro.buffalo.edu/1/M2/BTS11S/images/BTS11S_email.gif]
- CLEP Exams (extra credit)
- Go to www.collegeboard.com
- Consider which Exam(s) could save you time and money in college.
- Complete the CLEP Extra Credit Project (linked here soon).
General Info:
I intend to make as much of the info you need to be successful in this course available via this site. Remember that this is a college level course in a high school setting. The expectations I have for you are set accordingly. Use this site and the lessons I share to maximize what you learn. They and I are vehicles for your learning. You are the driver! There is more here than we will cover in depth in our class. Your education is worth whatever you invest in it. Feel free to explore after you have completed what is required.
Related Files
Related Links
-
ECC - Information Technology Department
This site offers further information about the Information Technology at ECC. -
ECC DA106 Transfer Credit Blog
Leave a comment or read a comment about transferring your credits from this course to other colleges. -
Blogger
Free Blog Creation - use in a manner appropriate for school.