computer applications class assignments

• Discussions
• Advertising

If you're seeing this message, it means we're having trouble loading external resources on our website.

If you're behind a web filter, please make sure that the domains *.kastatic.org and *.kasandbox.org are unblocked.

To log in and use all the features of Khan Academy, please enable JavaScript in your browser.

Intro to computer science - Python

Computer programming - javascript and the web, ap®︎/college computer science principles, computers and the internet, computer science theory, pixar in a box, hour of code.

In order to continue enjoying our site, we ask that you confirm your identity as a human. Thank you very much for your cooperation.

Notes for Computer Applications: summaries, handouts, exercises

• Conewago Elementary School
• East Hanover Elementary School
• Londonderry Elementary School
• Lower Dauphin High School
• Lower Dauphin Middle School
• Nye Elementary School
• South Hanover Elementary School
• Price School

• Lower Dauphin School District
• Computer Applications

High School Curriculum

Page navigation.

• Multicultural Art
• Illustration I
• Illustration II
• Illustration III
• Illustration IV
• Digital Photography I
• Digital Photography II
• Digital Photography III
• Digital Photography IV
• Pottery III
• Wheel Throwing
• Fine Art II
• Fine Art III
• Fine Art IV
• AP Art History
• Independent Study - Art
• Word Certification
• PowerPoint Certification
• Excel Certification
• Access Certification
• Accounting I
• Accounting II
• Advanced Accounting III
• Careers and Personal Finance
• Business Law
• Sports/Entertainment Marketing
• Co-Op School-to-Work
• Business Internship
• Health Careers
• Independent Study - Business
• English Literature 10
• AP English 11 - Language & Composition
• AP English 12 - Literature & Composition
• Honors British Literature Grade 12
• Theatre Arts: Tragedy
• Theatre Arts: Comedy
• Public Speaking
• Advanced Public Speaking
• Falcon Flash
• Independent Study - English
• Personal Development
• Culinary Arts I
• Culinary Arts II
• Culinary Arts III
• Culinary Arts IV
• Family Relations & Independent Living
• Design & Textiles
• Nutrition & Wellness
• Child Development
• Independent Study - Family & Consumer Sciences
• Spanish III
• Independent Study - Foreign Language
• Harrisburg University
• Foundations of Physical Education
• Strength & Fitness
• Team Sports and Personal Fitness I
• Team Sports and Personal Fitness II
• Individual Sports and Personal Fitness I
• Individual Sports and Personal Fitness II
• Personal Group Conditioning
• Aspiring HPE Teacher Independent Study
• Athletic First Aid
• Applied Math 1
• Honors Algebra 2
• Honors Geometry
• Functions, Statistics & Trigonometry
• Pre-Calculus & Trigonometry
• Honors Analysis
• Senior Math
• CP Calculus
• AP Calculus AB
• Computer Programming 1
• Computer Programming 2
• AP Computer Science (Computer Programming 3)
• Cyber Security
• AP Statistics
• Advanced Math Topics
• Independent Study - Math
• Chorus 0.5 Credit Course
• Chorus 1.0 Credit Course
• Jazz Band/Improvisation
• Music Theory I
• Music Theory II
• Chamber Singers
• Women's Select Choir
• Independent Study - Music
• Decoding & Comprehension I
• Decoding & Comprehension II
• Reading Strategies
• Comprehension I
• Comprehension II
• Independent Study - Reading
• Reading Strategies II Special Education-Reading 11th & 12th Grade
• Anatomy & Physiology
• AP Chemistry
• AP Environmental Science
• Biology - College Prep
• Biology - General
• Biology - Honors
• Chemistry - CP and Honors
• Disease Detectives
• Earth & Space Science - General, CP, Honors
• Environment & Ecology - General, CP, Honors
• Independent Study - Science
• Keystone Biology Prep
• Keystone Biology Remediation
• Organic Chemistry
• Physical Science
• Physics - College Prep
• Physics - Honors
• American Government and Economics
• AP American Government
• American Women
• AP European History
• Contemporary Problems
• HACC - American Civil War
• HACC - Military History of WWII
• HACC - Modern American History
• HACC - The Vietnam War
• History and Sports
• Impact of Social Change in American History through Music and Fashion
• Making History
• Modern World History
• AP Psychology
• Social Justice & Genocide
• Pop Culture
• The American Way of War
• Uncertainty, Revolution & Ideology
• You and the Law
• AP US History
• World History
• AP World History
• Independent Study - Social Studies
• Architectural CAD
• Computer Graphic Design
• Digital Multimedia Design
• Engineering CAD
• Engineering Design
• Robotics Engineering
• Woodworking I
• Woodworking II
• Woodworking III
• Independent Study - Technology Education

  Lower Dauphin School District

Curriculum guide.

Synopsis of Curriculum

Students will explore computer skills and applications needed on a personal, school/college, and career level.  The focus of this course is to provide knowledge and skills associated with Microsoft Office applications including:  Word, PowerPoint, Excel, Access, Publisher and Outlook.  Students will create various documents:  reports, business letters, tables, databases, spreadsheets, and brochures.  In addition, students will expand their knowledge of computer terminology, parts of a computer, and search strategies on the Internet.

Units of Study Titles

Introduction to Microsoft Office

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

Microsoft Publisher

Microsoft Access

• Questions or Feedback? |
• Web Community Manager Privacy Policy (Updated) |

• Degrees Associate Degrees Bachelor's Degrees Master's Degrees Doctorate Degrees Online Programs Online Associate Degrees Online Bachelor's Degrees Online Master's Degrees Online Doctorate Degrees Degrees by State Top Ranked Schools
• Subjects All Subjects and Degree Programs Agricultural Studies Architecture Design Biological Sciences Business Management Computer Science Culinary and Cosmetic Services Engineering Health Professions and Medical Services Humanities and Liberal Arts Legal Studies Mechanical and Electrical Repair Media Related Communications Physical Science Psychology School Administration Transportation and Distribution Services Visual and Performing Arts
• Careers Career Aptitude Tests Career Planning Career Profiles Career Roadmaps Career Training FAQs Education and Career FAQs Job Resume FAQs Salary FAQs
• Resources All Articles All Videos Scholarships

In order to continue enjoying our site, we ask you enter in the text you see in the image below so we can confirm your identity as a human. Thank you very much for your cooperation.

ABOUT LEARN.ORG

• Privacy Policy
• © Copyright 2003- 2024 Learn.org, all rights reserved.

Subscribe to Student Saver

Free breaking news and coverage of savings in education

Pardon Our Interruption

As you were browsing something about your browser made us think you were a bot. There are a few reasons this might happen:

• You've disabled JavaScript in your web browser.
• You're a power user moving through this website with super-human speed.
• You've disabled cookies in your web browser.
• A third-party browser plugin, such as Ghostery or NoScript, is preventing JavaScript from running. Additional information is available in this support article .

To regain access, please make sure that cookies and JavaScript are enabled before reloading the page.

• Health Science
• Business Education
• Computer Applications
• Career Readiness
• Teaching Strategies

«  View All Posts

Computer Applications | Microsoft Office | Microsoft Office Specialist (MOS)

Microsoft Office Lesson Plans Your Students Will Love

• Share This Article

May 18th, 2022 | 9 min. read

Print/Save as PDF

Do you teach middle or high school computer applications classes? If so, it's likely that your standards include requirements on teaching Microsoft Office.

As a computer applications curriculum developer, teachers often ask how we help teach Microsoft Office and prepare students for MOS certification.

While we provide a Microsoft Office curriculum system, our solution may not be the best fit for everyone.

Some teachers are only looking for supplemental resources or tips on improving their existing lessons.

If that's the type of information you're looking for, you're in the right place!

In this article, you'll discover Microsoft Office lesson plans and teaching tips for:

• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Access
• Microsoft Publisher
• Microsoft Office Specialist Certification

For each of these topics, you'll find a list of recommended resources to help you teach the best Microsoft Office lessons possible.

1. Microsoft Word Lessons & Activities

Microsoft Word is often the first jumping off point for many computer applications classes. Rather than spend hours creating your own Microsoft Word lesson plans and activities, wouldn't you like some that you can just integrate into your existing curriculum?

That's where this post can help: Microsoft Word Lesson Plans to Wow Your Students

It contains a number of resources that you can use to teach your middle or high school students to use Microsoft Word.

Want more than just Microsoft Word lesson plans to supplement your existing curriculum?

Business&ITCenter21 has lessons, quizzes, and projects to teach your students all about Microsoft Word.

The curriculum begins with Microsoft Word Essentials, which introduces your students to the basics of the application.

Next, you can use the Microsoft Word Fundamentals lessons to give students a more in depth look at formatting content within a Word document.

Once they have mastered the basics, your students can move on to the Microsoft Word Skills Project to put their skills to the test. The project requires learners to start from scratch and fully create a document.

If you want to take it one step further, you can assign the Microsoft Word Business Project, which requires students to create a job description booklet using more advanced skills.

Looking for additional tips? Read this article: How to Teach Microsoft Word in Middle School

2. Microsoft Excel Lesson Plans

Let's face it--Excel isn't the most exciting Microsoft application out there. So what can you do to spice up your Microsoft Excel lesson plans? Make them relevant to your students!

So where can you find engaging, relevant Microsoft Excel lesson ideas?

Start by reviewing these popular Microsoft Excel lesson plan resources:

• Excel Tutorials from GCFLearnFree.org
• Microsoft Excel Spreadsheets Lesson Plan Bundle from Computer Creations
• Lessons & Activities Bundle for Microsoft Excel from TechCheck Lessons

Each of these resources can help supplement any teacher's lessons on Microsoft Excel.

But what if you need more than a few extra spreadsheet activities?

Our computer applications curriculum has you covered with Excel, too!

The first module in the sequence is the Microsoft Excel Essentials, which provides an overview of working with spreadsheets, cells, rows, and columns. Students also learn about using basic functions and formulas.

Next, students can work through Microsoft Excel Fundamentals. This module provides an overview of the fundamentals of Microsoft Excel, including relative and absolute cell references, common functions, and formatting.

If you need to cover more advanced skills and features within Excel, you can assign the Microsoft Excel Skills Project or Microsoft Excel Business Project.

3. Microsoft PowerPoint Lesson Plans

PowerPoint is sometimes considered to be overused in schools, both by instructors and students. Because of this, it’s important that your Microsoft PowerPoint lesson plans are right on par (or above and beyond!)

Your PowerPoint lessons should be more than just a How-To. You must make sure that your students understand how a presentation can effectively (and ineffectively) be used.

So how can you teach your students to effectively use Microsoft PowerPoint?

We recommend you start with four topics on Microsoft PowerPoint:

• An Introduction to Microsoft PowerPoint
• The Basics of Building a PowerPoint Presentation
• More Features in PowerPoint
• Do’s & Don’ts of Effective Presentations

To find teaching tips and activity outlines, read these articles:

• Best PowerPoint Lessons for Middle School
• 4 Best PowerPoint Lesson Plans for High School 

Need more structure and resources to teach Microsoft PowerPoint?

In Business&ITCenter21, the Microsoft PowerPoint Essentials module provides an overview of Microsoft PowerPoint essentials, themes, templates, and adding and inserting a variety of items into a presentation.

Then, in the Microsoft PowerPoint Fundamentals module, students learn about creating effective presentations that are interesting, engaging, and functional.

Once your students have the basics down, you can move on to more advanced concepts and features with the Microsoft PowerPoint Skills Project and Microsoft PowerPoint Business Project .

4. Microsoft Access Lesson Plans

Microsoft Access can be a challenging subject for middle school and high school students. So it’s no surprise that Microsoft Access lesson plans   are a challenge for computer applications teachers.

To help you save time, we put together a list of popular Microsoft Access teaching resources :

• GCF Learn Free
• Tonya Skinner's Website
• Teachers Pay Teachers

Each of these websites has a variety of materials to help you teach Microsoft Access skills.

In addition, check out the Microsoft Access Fundamentals module within Business&ITCenter21.

This module provides an overview of database theory as students gain practical experience with Microsoft Access.

5. Microsoft Publisher Lesson Plans

Do you give Microsoft Publisher its fair share of attention? Many computer applications educators avid including Microsoft Publisher lesson plans in their curriculum.

We've found that's often because they don’t know where to find good Microsoft Publisher lessons!

To help you get started, we put together a list of popular Microsoft Publisher lessons and activities:

• Tangipahoa Parish School System
• Cape May County Technical School District
• Council Rock High School South
• Rochester Hills Public Library
• Instructables
• Shawano School District
• Microsoft Office Support
• Business&ITCenter21

Each of these resources can help you introduce Microsoft Publisher to your students when added to your existing Microsoft Office lesson plans.

But are you looking for a more structured resource on Publisher? If so, check out the Microsoft Publisher Fundamentals module within Business&ITCenter21.

This module provides an overview of the fundamentals of Microsoft Publisher through the creation of a number of desktop publishing documents.

6. Microsoft Office Certification Prep

In our experience, we've found that teachers searching for Microsoft Office lesson plans are often also interested in preparing their students for the Microsoft Office Specialist certification exams.

To help your students prepare for certification, you most likely need more than just a lesson or two. It might be beneficial to also include test prep material to help your students prepare.

For tips on how to best prepare your students for MOS certification, read these articles:

• How to Prepare Students for the MOS Word Exam
• Steps for Successful Microsoft Excel Test Prep

Start Teaching Microsoft Office Skills Today!

All of the resources and ideas listed on this page can help you put together a great Microsoft Office curriculum.

However, if you're like most computer applications teachers you don't have much time to spare for piecing together a hodgepodge of lessons and activities.

If you need a more robust Microsoft Office solution that helps you teach all of the Microsoft Office applications, consider looking into a full curriculum.

There are many Microsoft Office curriculum options available so it can feel overwhelming to decide which one is right for you.

Choose your search type:

Frequently Asked Questions

• News & Media
• Campus Maps & Locations
• General Information
• The Newsroom
• Seminole State Events
• Altamonte Springs
• Sanford / Lake Mary
• Seminole Online
• Accreditation
• Facts & Figures
• College History
• Administration
• Meetings & Public Notices
• Safety & Security
• Phone Directory
• Become a Donor
• Scholarships
• Presidents Club
• Blue & Gold Circle
• Fine Arts Events
• Planetarium
• Economic Development
• Degree Programs
• Adult Education
• Search Degrees & Programs
• Search Courses
• View Academic Calendar
• Browse Student Information

• Associate in Arts
• Associate in Science
• Certificates

Find your program

• GED® Prep
• Adult & Workforce Education
• English Language Studies
• College Admission
• Financial Aid
• International Students
• Become a Student
• What We Offer
• Why Choose Us
• Contact Admissions
• Steps to Enroll
• Online Forms
• Enrollment Services
• Dual Enrollment
• Veteran Student Services
• Financial Aid Overview
• Types of Aid
• Work Study Program
• Current Fees
• Apply for Aid
• Programs of Study
• English Language Institute
• Current International Students
• Future Students
• Campus Life
• Student Essentials
• Student Support
• Student Activities
• Clubs & Organizations
• Intramural Sports
• Health and Wellness
• Leadership Programs
• Volunteering Opportunities
• Student Government
• Academic Calendar
• Assessment & Testing
• Blue & Gold Card
• Campus Dining
• Computer Help Desk
• Graduation Information
• Online Classes
• Text Messaging
• Transcripts
• Advising & Counseling
• Career Center
• Disability Support Services
• First Generation Program
• Hours of Operation
• Non-Traditional Students
• Online Exam Scheduling
• Raider Support
• Tutoring & Academic Help
• Workshops & Skill Sessions
• Athletics Website
• Cross Country

CGS2100C Computer Applications

This is an introductory course in computer applications that focuses on the effective use of word processing, spreadsheet, database and presentation software programs. Students will gain a fundamental knowledge of Microsoft Office 365 and learn skills that have practical applications in real world business situations. This course utilizes lectures and hands-on computer exercises. Lab fee required.

Terms Typically Offered: Fall, Spring, Summer Credits: 3.00

Textbook information will be available online for each term's courses 45 days prior to the first day of classes for the term.

The courses in this catalog are identified by prefixes and numbers that were assigned by Florida's Statewide Course Numbering System, a system used by all public postsecondary institutions in Florida and 32 non-public institutions. Seminole State controls the description, credit and content of its own courses.

An Error Occurred

• Whiteboard Notes
• Textbook: CS for All
• Coding Conventions
• Technology Student Association
• 4180, the Iron Riders, a FIRST Washington Team
• Student Information Survey
• Parent Information Survey
• Contact Instructor
• Visiting Lab 319
• Suggestions and Feedback
• Roosevelt Computer Science
• Curriculum Summary
• Course Policies
• Lab Policies

Computer Applications | Assignments

Mastering the tools of digital life.

• Assignments

Assignment 21

For the final exam, we will look at each person’s story as a class. I would like each person to show and explain his story, but if anyone feels that theirs is too personal or they are not comfortable sharing it with everyone, let me know.

DUE : Thursday, January 27 in class final.

Assignment 20

This is it — your finished digital story. The final version of your PowerPoint should be ready, with all the content on each page finished. It’s worth the largest portion of your final grade of any single assignment, about 10%.

• 50% : Story — Your story should be well-developed and clearly told. Writing a personal narrative is a bigger challenge than choosing an existing story to illustrate. Selecting existing material to illustrate is in between those two.
• 25% : Text — The narrative of your story should be clear and understood from the presentation. This can be done with onscreen text, captions, or audio narration, or by you live during the presentation.
• 25% : Visual — Good use of visual imagery and illustrations supports the narrative. Creating your own images is worth more than using existing ones.

You can earn extra credit on this project for using extra PowerPoint animations or incorporating so-called “rich media” in your digital story. By rich media, I mean scanned images or digital media (sound, photos or video) that you generate, not media that you find on the internet. This must be done in a way that supports your other content, not just something slapped gratuitously into the story!

• Max 25% Extra Credit : Animations, Rich Media — Incorporating animations, original digital media in an appropriate way that enhances other content.

DUE : Monday, January 24 in the course dropbox.

Assignment 19

This assignment is to create the first prototype of your story in PowerPoint. In this case, a story prototype is just a first mockup of the PowerPoint slide show. You should have one slide for each =”chapter” in your planning document. The slide doesn’t have to have all the images or text or other media on it, but should just be a placeholder for your final design and implementation.

The purpose of this assignment is just to make sure that you have the story mapped out and are beginning your production process. I will just come around and review it with you at your computer, make sure you are on the right track, and give you suggestions and feedback on your project.

DUE : Friday, January 19 in class.

Assignment 18

Before starting actual production of your PowerPoint story, I want you to do some planning on paper for it. I know this is always painful for most of you, because the fun is in making the images and animation, etc.

But, it is always a good idea to PLAN before DOING on a project. This one might seem small enough that you don’t need to, but on a larger project you will need to do this. So this is good practice.

Your planning document, called a storyboard, should summarize the project in a few paragraphs, and then have a list of “chapters” that will make up the story. These chapters, for your PowerPoint, will probably correspond to individual slides, but that may change as you get into production.

Then for each chapter, you create one page of a “board” of story elements, the storyboard, which describe what happens on that slide in the PowerPoint.

The storyboard page should have:

• Scene Title
• Image Description or Sample
• Narration (which may be just used as text on screen, not as sound)
• Notes on what happens to the image (animation, etc.)
• Music (description of music or sound effects)

You can create this story planning document in Word. Here is a sample that you download and use as a template: Story Planning .

DUE : Friday, January 7 on paper in class.

Assignment 17

We are shifting gears from Excel now, and into PowerPoint.

In this assignment, you will use PowerPoint to tell a story. Through this story-telling exercise, you will learn or practice a lot of the important features of PowerPoint and other programs, such as:

• using visual themes and different kinds of master slides
• using animation and effects in transitions
• incorporating digital photos, scanned images, sounds, and movies
• constructing and sequencing presentations
• rehearsing and delivering presentations
• making websites from presentations

The story you will tell should be something of personal significance to you. It may be about one of the following topics:

• someone who has inspired or influenced you
• a place you have been that was important to you
• an event you attended or experienced that changed you in some way

The format of this story will be a multimedia presentation in PowerPoint. But the idea is not to make the story like a business or marketing presentation. Rather I want you to use the power of digital media of all kinds (text, images, graphics, photos, video, sound, etc.) to communicate your ideas.

You will develop a presentation in PowerPoint and then show that presentation to the class. I would also like to have you make a website of the presentation as well, if we have time.

The first step in this digital story-telling process is to write down the story you want to tell, in words as a short essay. In this essay, explain the subject of your story — describe the person, place, or event that you have chosen that is important to you. Also explain why this person, place, or event had an impact on you, and how.

This essay can be done in Word and should be approximately one page long.

DUE : Friday, December 17 on paper in class.

Assignment 16

Continuing on the theme of analyzing sports statistics from the last assignemnt, this one will focus on college basketball.

• calculate percentages
• calculate sums (totals)
• calculate averages
• practice sorting ranges of cells

Your assignment is to modify this spreadsheet — College Basketball — to calculate the missing statistics in the colored cells on the spreadsheet.

Enter your answers right in the green cells on the spreadsheet at the bottom, and submit the spreadsheet in the course dropbox. ADD YOUR NAME to the name of the document when you save it! And substitute YOUR NAME inside the spreadsheet at the top.

DUE : Friday, December 10 in the course dropbox.

Assignment 15

This assignment will use an example from the world of international sports, Serie A Calcio, the “big league” of Italian football, or soccer, if you insist.

The purpose of this assignment is to learn how about some slightly more advanced features in Excel: creating formulas and sorting data. You will learn to

• do simple math calculations in a spreadsheet, using Excel fomulas
• use ranges of cells in formulas
• copy and paste formulas to apply them to large amounts of data
• do simple sorting of data in an Excel spreadsheet
• do multi-level sorting of selected data

The Italian Serie A Calcio league has 20 teams. We will look at statistics about their current season so far and analyze that data. The stats we will focus on are for the entire team:

• the number of matches each team has won, drawn (tied — yes, it’s possible in soccer), or lost
• the number of goals scored by each team in all of those matches
• the number of goals scored against each team in all of its matches

Teams are ranked in the league by a point system that uses all of those stats. It goes like this:

• Each win is worth 3 points
• Each draw is worth 1 point
• Each loss is worth zero points

The points for each team are calculated basesd on this formula, and they are ranked according to the number of points they have. If two teams are tied in points, then a further calculation based on the number of goals scored and allowed is made to break the tie.

For a tie, the difference between the number of goals scored (for) and the number allowed (against) is calculated. That is called the goal difference. A team with a larger goal difference than another with the same points is ranked higher.

And the Italian league has a wonderful system where, at the end of the season, the three teams at the bottom of the standings get demoted, or relegated, to a lower league (in this case, Serie B).

Your assignment is to modify this spreadsheet — Serie A Calcio — to automatically calculate the goal differences and points for each team in the league. Once you have completed that, you can sort the data in order to rank the teams in the league.

First download the spreadsheet and add the required formulas to the pink cells to caluate the missing stats. Here is an example spreadsheet that demonstrates some simple formulas that you can use as a reference.

Then sort just the 20 rows of the teams in the spreadsheet, and you should then be able to answer the questions at the bottom of the spreadsheet. You will have to do a two-level sort, on both the points and for the second level, the goal differences to break ties.

Here are some explanations to help answer some of the questions:

• Question 4: The top three teams in the ranking go directly to the Champions League playoff.
• Questions 5-7: The bottom three teams in the ranking get relegated to Serie B.
• Questions 8-9: The 5th and 6th place teams qualify for the Europa League.

Enter your answers right in the green cells on the spreadsheet, and submit the spreadsheet in the course dropbox. ADD YOUR NAME to the name of the document when you save it! And substitute YOUR NAME inside the spreadsheet at the top.

DUE : Wednesday, December 8 in the course dropbox.

Assignment 14

The purpose of this assignment is to learn about using formulas in Excel. Since this is not a particularly exciting topic, I am hoping we can have a little fun along the way.

We are going to return to our friend the QR Code, which I am sure you will all remember from the beginning of the class and our re-visitations along the way this semester. We’ll use Excel to do some layout and calculations, and then use that as a template to make our own QR codes with LEGOs! Physical QR codes that can be scanned. Actually, you can use any other materials you like; more on that later.

First, you are going to make your own QR code. You can put whatever message or content in this QR code that you like, as long as it is “appropriate.” You know what I mean. Here are the possible content types that can go in a QR code:

• Text: any message
• URL: link to a website
• Phone number: a phone number to dial
• SMS number: a phone number to text
• Email: an address to send an email
• Business card: a virtual business card (vCard)
• Geographic location: GPS coordinates for a map

Pick one and then go to this website — Mobilefish QR Code generator — to make your QR code image with the content you decided on.

Use the following settings for the QR code:

• Block size: 5
• Padding size: 4
• Border size: 1
• Background color: something fairly light
• Block color: something dark or with good contrast to the background
• Image type: PNG

Now you are going to plot the individual pixels in the QR code in an Excel spreadsheet. Create a blank spreadsheet. You will be using a 25 x 25 grid, where each spreadsheet cell represents one pixel of the QR code. Enter a “1” in every cell that corresponds to a dark pixel in the QR code. Leave the cells that correspond to the light, background pixels blank.

click for a larger version

This is tedious, so do it carefully. When you are done, you should have a spreadsheet that looks something like this.

Now you get to practice some Excel formulas to do some calculations. Since you are eventually going to build this QR code with LEGOs, I want to know how many LEGO pieces you will need to represent the dark pixels. You can do this by adding up the sum of the values in each row or column. This will count the number of 1’s in the row, which is the number of dark pixels. Then you can sum up all the row or column totals to find the total number of dark pixels. Make sure that you get the same number by summing the rows as you do by summing the columns.

You should have a spreadsheet now that looks something like this one. Put your name on it and submit that with the print of the QR code image.

The next step is to see if you can make the Excel spreadsheet itself scan as a QR code!

I made my spreadsheet look like this one by some tricky Excel formatting. See if you can figure out how to do it, without just manually coloring the cells with “1”s in them. I did it with one step. And, the QR code reader actually recognizes it!

Now, using this template, we’ll have a LEGO party and actually make the QR codes in a physical medium and see if they can be recognized by the scanner. Or maybe you’ll want to use some other materials. Check out this site: Edible QR Codes !

DUE : Tuesday, December 7 in LEGOs (or ?) in class.

Assignment 13

You have been hired as an information designer by the Roosevelt High School Counseling Center. The staff has tabulated some statistical information about the Rough Rider Class of 2010 and would like a nice visual display of this data.

Your assignment is to analyze this data and interpret it visually so that the information is easily understood by a reader. Statistical data is notoriously difficult to comprehend without graphs and charts.

You will go through this process in a step-by-step fashion and use it as a way to explore and master various features of Microsoft Excel, the spreadsheet application.

The first step is to unpack the data from the dense text in which it is embedded. Here is the source of the data that you have been given: RHS 2010 Grad Stats . And here is an additional supplement to incorporate: RHS 2010 Grad Stats, 2 Year Schools .

Read these document and extract the significant numerical information from them and assemble them in a simple tabular form. Use this template: RHS 2010 Stats Table .

Add one line for each school that a student will attend. Enter the number of students going to that school in the far right column. Look up the zip code of each and enter it in the third column. (You will use this information later to plot the schools on a map.) Calculate the total number of students in the Class of 2010.

Once you have generated the table information, save it, print it out, and show it to me to verify that you have the correct data. Then turn it in.

The next step is to put this data into a spreadsheet so that we can begin to analyze it. Your final assignemnt for this project is to produce a document that summarizes the data in four sets of charts. Each set has a display of the raw numeric values and a display of the associated percentages. The sets are as follows:

• Graduation Rate : students in the class of 2010 who graduated vs. did not graduate
• Graduate Plans : students’ planed activity after graduation
• 4 Year Colleges : distribution of students who owill attend four-year colleges
• 2 Year Colleges : distribution of students who will attend two-year colleges

This document — RHS 2010 Grad Stats — is a sample of what you should create in Excel. But it is only a suggestion, and a mediocre design. You should experiment with different kinds of charts and graphs to select the ones that you think best illustrate the data being represented. And pay attention to the layout so that it is pleasing and communicates the ideas well.

Your job is to produce something similar in Excel, but better, and to use the correct numbers in those charts from your analysis that you assembled in the Word Worksheet.

The grade for this assignment will be according to this rubric:

• 5 points — Graduation Rate: all numbers correct?
• 5 points — Graduation Plans: all numbers correct?
• 5 points — 4 Year Colleges: all numbers correct?
• 5 points — 2 year Colleges: all numbers correct?
• 4 points — Bar charts: all correct?
• 4 points — Pie charts: all correct?
• 5 points — Overall communication success
• 5 points — Graphic/chart visual style
• 2 points — Page layout style

TOTAL : 40 points

DUE : Friday, December 3 on paper in class.

Assignment 12

For this assignment, you will create a cover letter document in Word. The purpose of this is to understand and practice writing a properly formatted business letter.

The subject of the letter should relate to the objective you listed on your resume. You can write to a fictitious or real company that you would like to approach for a job, or perhaps an internship, or a volunteer opportunity, holiday workor another other professional opportunity, etc.

Follow the format in the sample letter from the Office 2007 book (page WD 147, Figure 3-1), which you can view at this link: Sample Cover Letter . Use the same letterhead you created for your resume.

DUE : Monday, November 8 on paper in class.

Assignment 11

This is a quick assignment, worth only half of the usual points for an assignment. You just need to read the post and an article on the course blog about “Car Hacking,” then go over to the Lab 319 blog and post a comment with at least one substantive question about what you’ve read.

We’ll use your questions in the discussion with Ms. Roesner during the demo on Tuesday.

DUE : Monday, October 25 in a comment on the Lab 319 blog post about “ Car Hacking .”

Assignment 10

In this second part of the resume assignment, you will expand the outline of items to be included in your resume (which you developed in Assignment 9) into a fully written and formatted resume.

This will be done in two phases. The first phase will focus on the content again, postponing the decisions about presentation and form and visual style until the second phase.

For the first step, expand the outline to a fully composed resume. The text you produce should have all of the information you want in your final document, exactly as it will be presented, but without worrying about font choices or page layout.

Your resume must be written in a style appropriate for a resume. Resume writing style is different from normal writing. It has to communicate very crisply and succinctly who you are and what you have done. Here are some guidelines for composing your resume:

• Use bullet points with phrases
• No complete sentences
• Most important items first
• Use positive language
• Use action verbs
• No pronouns (“I” or “me”)

Check your writing for correct spelling and grammar; use the tools in Word to do this. I will help you edit your writing, again in individual meetings.

Once you have the content of your final resume approved by me, you can then go on to the second step of this assignment—selecting the visual style and format you want to use for the presentation of your resume. This is a matter of personal choice—how you wish to show what you written about yourself—but it must be professional in appearance and appropriate for your stated objectives in the resume.

You will format the Word document, select colors, fonts and font styles, and lay out the page neatly. When finished, I will check them once more for any necessary revisions, and then you will prepare the final version for the completion of the assignment. You will convert the Word document to a PDF document and submit that

DUE : Monday, October 25 in the course dropbox.

Assignment 9

Your next assignment is to create a personal resume.

A resume is highly personal, yet professional, reflection of you; it speaks volumes about how you want people to perceive and respect you. It summarizes your skills, experience, interests, activities, etc. It is used to help you achieve your goals in the world outside of high school.

You will approach this assignment from two different angles: form and content.

The content is the information your resume contains about you. The form is how you choose to present it on paper. (Later in the course, you will build an online version of your resume as a web page.)

In this assignment, we will pay equal amounts of attention to both the form and the content. Part A of the assignment will be to think about and write down, in rough form, an inventory of all of the information you want to include in your personal resume. Part B will be to craft a professional-looking, carefully formatted Word document that is an expression of you.

In the previous assignments, we have been less concerned with the presentation and more with the mechanics of producing your content. In this assignment, design matters, and we will spend some time working on the details of your format choices. And also in this assignment, good grammar, spelling, and language count as well.

I will work with each of you to help you craft an excellent resume that reflects your profile and style. You will probably do a few revisions of the work.

Here is my resume , as an example. And here is another sample resume (from the Office 2007 textbook, Figure 3-2), which is probably closer to one you might create for yourself.

In Part A of this assignment, you are to create a list of categories of information you wish to include on your resume. You will also fill in the details of each category, listing all items in that category. You will not be concerned with the design of your resume in this part, only the contents. This should be done in outline form.

For example, on my resume, I have the following categories:

• Contact Information
• Summary / Profile
• Work Experience
• Personal Info

For the textbook sample resume, these are the categories she chose:

• Community Service

For a high school student, I suggest that all of the following categories are possible:

• Objective / Goal
• Personal Profile
• Extra-curricular activities

An outline form of my resume would look like this:

• Technologist
• University of Washington
• Golden Section
• Interaction Design Institute Ivrea
• Art Center College of Design
• Microware Systems Corporation
• Philips Interactive Media
• NewLine 7 Graphics
• Digital Productions
• Colonial Penn Group Data Corporation
• University of Pennsylvania
• Visual Studies Workshop
• University of Rochester
• Puget Sound Chapter, Computer Science Teachers Association
• dorkbot-sea
• First LEGO League Competition
• Homework Help Center, Seattle Public Library
• Citizenship

For Assignment 9, select from the list of categories I listed (or add your own) the ones you want to include on your resume. Then, for each category, list all the items that you will display in this category.

This may sound simple, but it will require a lot of thought. You need to consider the goals you have in using this resume.

When you have drafted an outline, I will review it with you and make suggestions for revising it. The revised version will serve as the basis for part B of the assignment, which is to create a beautifully formatted version of your resume.

DUE : Monday, October 18 on paper in class.

Assignment 8

For this assignment, you are going to continue working on the theme of your dream job and learn or practice making tables in Word.

Your task is to research available post-secondary (after high school) training or college programs in the State of Washington that will help you reach your goal or dream job. You will prepare a report using Word that summarizes what you found. Here is how to do it.

A branch of Washington state’s Employment Security Department (ESD) gathers, analyzes, and publishes information about the state’s labor market. There is an enormous amount of information available on their website ( Workforce Explorer ) for researching careers and job possibilities in the State of Washington.

Go to that website and follow the link for students to this page . Explore some of the links there for “Figure out what careers match my interests,” “Match career options to my work values,” and “Choose a major or career field.”

Choose at least three fields to research for yourself. These can be related to each other because you are not sure exactly what you might want to do (like be a medical doctor, or a nurse, or a paramedic). Or they could be very different, like acting or marketing or retail.

Now go to the link for “ Learn about education and training options ” and use the “Find Training Programs” tool to discover what programs are available in Washington for each field.

click to see a larger version

Create a report in Word to summarize all of the training programs that you found. Follow the format in this sample report, but replace all of the information with what your research turned up. Be sure that the information about you and the course at the top appears in a header at the top of every page. Also be sure that page numbers appear in the footer of each page.

The main task is to create a table in the body of the report for each professional field, and to copy the information you find on the website into the table. I will show you how to create a table in Word if you don’t know how.

Print the report out when you are done.

DUE : Thursday, October 14 on paper in class.

Assignment 7

For this assignment, you are going to continue working on the theme of your dream job and learn more features of Word.

You have already written in your mini-essay about some ideas you have for a job or career you would like to pursue ten years after you graduate from Roosevelt. Now imagine you want to start a new club at Roosevelt for other people who share your idea of a dream job.

Choose a name for this club, pick a date, time, and place for the first meeting, and write a short paragraph describing the purpose of the club. Find or make at least one image to use that will attract people’s attention and communicate the purpose of the club.

Then create a one page flyer in Word to advertise this first meeting. Here is a sample flyer for a club I made up. You can follow this template. Do not make it look exactly like mine, but you should have all of that basic information on yours. Choose your own fonts and sizes that you think are appropriate for your club.

If you need help figuring out how to insert an image into your document, there is a step-by-step explanation in the Office 2007 reference book (in the bookcase by the front door of the room) on page WD-40.

If you already know how to do most of this in Word, I expect you to be more adventurous in your design.

DUE : Monday, October 11 on paper in class.

Assignment 6

For this assignment, I would like you to take a short survey online about your habits and skills in using various computer applications and digital tools. This is to give me some data about what everyone already feels comfortable doing with various computer applications and what we need to focus on in the next weeks.

This first survey is fairly general. I will follow it up with more detailed assessments for specific software applications.

Please be honest abut your experience and comfort level with the tools. The purpose of this survey is for me to understand how best to support your learning needs. This assignment will not be graded; you will get full credit just for completing all of the questions.

Be sure to use your real name in the survey so I know whom to credit with the assignment.

Here is the link to the survey: Computer Apps Period 2 survey .

DUE : Tuesday, October 5 on the survey site.

Assignment 5

For this assignment, you simply have to return the signed Academic Integrity Policy document, indicating you and your parent or guardian have read and discussed it, and agree to those rules.

DUE : Monday, October 4 in class.

Assignment 4

For this assignment, watch this short video, which gives a nice explanation of the concept of cloud computing: “ Cloud Computing in Plain English .” (Select that title from the list to play it.)

Write down 2-4 things you observed about cloud computing from watching the video, and 2–4 things you wondered about or questioned. Post those “wows” and “wonders” as a comment on the class discussion blog at lab319.wordpress.com .

Be sure to use enough of your real name in your comments so I know who has authored the comment.

DUE : Tuesday, September 28 on that blog site.

Assignment 3

For this assignment, you will explore the issue of “net neutrality” and begin blogging as a way to share your ideas. I have set up a separate blog site for our class discussions at lab319.wordpress.com .

Please go there, find the post on net neutrality and read the information in the post. Then post a comment on the blog entry stating your opinion about net neutrality. Support your opinion with some reasons.

Once you have posted your opinion, reply to at least one other person’s comment with a followup opinion or question.

Be sure to use your name in your comments so I know who has authored the comment.

DUE : Monday, September 27 on that blog site.

Assignment 2

For this assignment, you will begin your portfolio project. I would like you to write a mini-essay or personal statement that describes what your dream job would be, ten years from now. You can find a worksheet for the assignment here .

Submit a Word document containing your essay. Be sure to include your name or RHS account in the name of the document so I can tell whose it is.

DUE : Friday, September 24 in the Course Dropbox.

Assignment 1

For this assignment, you and your parent or guardian should discuss the letter I gave you with the course syllabus. You and your parent or guardian should sign it, indicating you understand and agree to the course policies, and then return it to me. You can download a copy of the letter to print out here .

DUE : Monday, September 13 in class.

The Rough Riders – Roosevelt High School

Schedule | Fall 2020

Per 1: AP Computer Science Per 2: AP Computer Science Per 3: AP Computer Science Per 5: Intro to Programming Per 6: Intro to Programming

Search this site

Useful links.

The Source RHS Schedules RHS Website RHS Calendar The Roosevelt News

Blog Archives

Blog subscription.

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Email Address:

Recent Blog Posts

• Cupcake-tastic Lorem Ipsum Alternatives
• A Warm Wind
• The Problem About Being a Programmer
• How Kinect Spawned a Commercial Ecosystem
• Seattle Maker Faire 2012

Recent Tweets (@rooseveltcs)

Recent tweets (@roosevelths).

• Except where noted otherwise, content created between August 2012 and June 2019 on this site is licensed under CC BY-NC-SA 3.0 by Ashley Myers . Content created August 2010 through June 2012 is © Andrew Davidson .

• Already have a WordPress.com account? Log in now.
• Subscribe Subscribed
• Copy shortlink
• Report this content
• View post in Reader
• Manage subscriptions
• Collapse this bar

Course Resources

Assignments.

The assignments in this course are openly licensed, and are available as-is, or can be modified to suit your students’ needs.

If you import this course into your learning management system (Blackboard, Canvas, etc.), the assignments will automatically be loaded into the assignment tool.

The assignments for Computer Apps for Managers build on one another and culminate in the submission of a finished project.

You can view them below or throughout the course.

Assignment Rubric

Below is a suggested rubric for grading assignments.

Discussions

The following discussion assignments will also be preloaded (into the discussion-board tool) in your learning management system if you import the course. They can be used as is, modified, or removed. You can view them below or throughout the course.

• Assignments. Provided by : Lumen Learning. License : CC BY: Attribution
• Pencil Cup. Authored by : IconfactoryTeam. Provided by : Noun Project. Located at : https://thenounproject.com/term/pencil-cup/628840/ . License : CC BY: Attribution

We've detected unusual activity from your computer network

To continue, please click the box below to let us know you're not a robot.

Why did this happen?

Please make sure your browser supports JavaScript and cookies and that you are not blocking them from loading. For more information you can review our Terms of Service and Cookie Policy .

For inquiries related to this message please contact our support team and provide the reference ID below.