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
    • Blog-a-Difference Project.  [due today]
      • 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 
    Day 50-53 
    Day 49 (Mr. Turton is out, choose your tasks and get busy)
    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
    • 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
    • Check out the Alden Knights on Youtube.
    • Children's Book Project
      • You completed/printed book and rubric should be in the envelope on my desk.
    • Team IT Presentation Project
    • 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

    Days 24-26

    1. Scratch - Object Oriented Programming
    2. 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.
    3. Project - Thank You Letter (due 11/19)
    4. Children's Book Project
    5. Excel - Social Impact - Data Analysis Project - coming soon

    Days 19-23

    1. GRADES ARE CLOSING
    2. Last Days to present your IT . Make it happen.
      1. Topic B -  [Memory and Storage Devices] - Anne and Tim 10/27
      2. Topic G. - [Key Innovators] - Mike,  Jordan L, Jacob M. - complete
      3. Topic I [Art and Advertising] - Caitlin, Mike, Zach G. 10/29
      4. Topic J. [Manufacturing] - Matt, Jordan S., the Lopes 11/2
      5. Topic M. [Programming and Data Mngmt] - Trevor, Andrew 11/4
    3. Fix your Karel Project for a re-grade if you want and present it if you have not already.
    4. Open your Karel Writes a Word files so I can verify you included the "Define-new-instruction" part of the rubric. TODAY.
    5. 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]

    Days 17-18

    1. Wrap up your IT Presentation and get things printed.
    2. Fix your Karel Project for a re-grade if you want.
    3. Open your Karel Writes a Word files so I can verify you included the "Define-new-instruction" part of the rubric.
    4. 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]
    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
    Day 09 - 11

    Day 06 - 08

    1. 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.
    2. Team IT Presentation Project
    3. 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 
    1. Revisit Day01 and complete anything you did not get to.
    2. 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.
    3. 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.
    4. 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
    1. Quiz - 21st Century Survival Skills (10 point quiz grade)
      • Yep - a quiz on day 1. Don't worry it's easy.
    2. 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.
    3. 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

        1. Creativity and innovation

        Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology.

        1. Apply existing knowledge to generate new ideas, products, or processes
        2. Create original works as a means of personal or group expression
        3. Use models and simulations to explore complex systems and issues
        4. Identify trends and forecast possibilities
        5. 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.

        1. Interact, collaborate, and publish with peers, experts, or others employing a variety of digital environments and media
        2. Communicate information and ideas effectively to multiple audiences in a variety of media formats
        3. Develop cultural understanding and global awareness by engaging with learners of other cultures
        4. Contribute to project teams to produce original works or solve problems
        5. Research and information fluency

        Students apply digital tools to gather, evaluate, and use information.

        1. Plan strategies to guide inquiry
        2. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources and media
        3. Evaluate and select information sources and digital tools based on the appropriateness to tasks
        4. Process data and report results
        5. 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.

        1. Identify and define authentic problems and significant questions for investigation
        2. Plan and manage activities to develop a solution or complete a project
        3. Collect and analyze data to identify solutions and/or make informed decisions
        4. Use multiple processes and diverse perspectives to explore alternative solutions
        5. Digital citizenship

        Students understand human, cultural, and societal issues related to technology and practice legal and ethical behavior.

        1. Advocate and practice safe, legal, and responsible use of information and technology
        2. Exhibit a positive attitude toward using technology that supports collaboration, learning, and productivity
        3. Demonstrate personal responsibility for lifelong learning
        4. Exhibit leadership for digital citizenship
        5. Technology operations and concepts

        Students demonstrate a sound understanding of technology concepts, systems, and operations.

        1. Understand and use technology systems
        2. Select and use applications effectively and productively
        3. Troubleshoot systems and applications
        4. Transfer current knowledge to learning of new technologies
        Reference Info

        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. 
        • 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

more